Database map

Should always contain a map of latest repositoryversion. If a develeoper (for example me ^_^ ) changes anything one should also change here and make a note of it, with explanation and date at the bottom.

Note that this map doesn't have the tableprefix that is probably present in most installations of XodaGallery.

CREATE TABLE IF NOT EXISTS `admins` (
  `admin_user_id` tinyint(3) UNSIGNED NOT NULL,
  PRIMARY KEY  (`admin_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `bad_behavior` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `request_method` text NOT NULL,
  `request_uri` text NOT NULL,
  `server_protocol` text NOT NULL,
  `http_headers` text NOT NULL,
  `user_agent` text NOT NULL,
  `request_entity` text NOT NULL,
  `key` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ip` (`ip`(15)),
  KEY `user_agent` (`user_agent`(10))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `bips` (
  `bip_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `bip_ip` varchar(20) NOT NULL,
  `bip_hits` int(11) NOT NULL,
  `bip_date` datetime NOT NULL,
  PRIMARY KEY  (`bip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `bwords` (
  `bword_id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `bword_word` varchar(100) NOT NULL,
  `bword_hits` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY  (`bword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `categories` (
  `category_id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_name` varchar(255) NOT NULL DEFAULT '',
  `category_description` text NOT NULL,
  `category_images` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `comments` (
  `comment_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `comment_image_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `comment_user_id` smallint(5) UNSIGNED NOT NULL,
  `comment_guest_id` smallint(5) UNSIGNED NOT NULL,
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text NOT NULL,
  `comment_block` enum('0','1','spam') NOT NULL DEFAULT '0',
  PRIMARY KEY  (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `guests` (
  `guest_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `guest_ip` varchar(21) NOT NULL DEFAULT '',
  `guest_host` varchar(255) NOT NULL DEFAULT '',
  `guest_name` varchar(150) NOT NULL DEFAULT '',
  `guest_url` varchar(255) NOT NULL DEFAULT '',
  `guest_email` varchar(255) NOT NULL DEFAULT '',
  `guest_code` varchar(255) NOT NULL DEFAULT '',
  `guest_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY  (`guest_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `images` (
  `image_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `image_name` varchar(255) NOT NULL DEFAULT '',
  `image_file` varchar(255) NOT NULL DEFAULT '',
  `image_format` varchar(4) NOT NULL DEFAULT '.gif',
  `image_user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `image_category_id` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `image_width` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `image_height` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `image_comments` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `image_description` text NOT NULL,
  `image_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY  (`image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `options` (
  `option_id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `option_title` varchar(50) NOT NULL,
  `option_value` varchar(255) NOT NULL,
  `option_description` varchar(255) NOT NULL,
  PRIMARY KEY  (`option_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_name` varchar(40) NOT NULL DEFAULT '',
  `user_full_name` varchar(255) NOT NULL,
  `user_password` varchar(40) NOT NULL DEFAULT '',
  `user_email` varchar(255) NOT NULL DEFAULT '',
  `user_show_email` tinyint(1) UNSIGNED NOT NULL,
  `user_images` int(11) UNSIGNED NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

Database map

Index