-- MySQL dump 9.11 -- -- Host: localhost Database: pwg-bsf -- ------------------------------------------------------ -- Server version 4.0.24_Debian-10-log -- -- Table structure for table `piwigo_caddie` -- DROP TABLE IF EXISTS `piwigo_caddie`; CREATE TABLE `piwigo_caddie` ( `user_id` smallint(5) NOT NULL default '0', `element_id` mediumint(8) NOT NULL default '0', PRIMARY KEY (`user_id`,`element_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_categories` -- DROP TABLE IF EXISTS `piwigo_categories`; CREATE TABLE `piwigo_categories` ( `id` smallint(5) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `id_uppercat` smallint(5) unsigned default NULL, `comment` text, `dir` varchar(255) default NULL, `rank` smallint(5) unsigned default NULL, `status` enum('public','private') NOT NULL default 'public', `site_id` tinyint(4) unsigned default '1', `visible` enum('true','false') NOT NULL default 'true', `representative_picture_id` mediumint(8) unsigned default NULL, `uppercats` varchar(255) NOT NULL default '', `commentable` enum('true','false') NOT NULL default 'true', `global_rank` varchar(255) default NULL, `image_order` varchar(128) default NULL, `permalink` varchar(64) binary default NULL, PRIMARY KEY (`id`), UNIQUE KEY `categories_i3` (`permalink`), KEY `categories_i2` (`id_uppercat`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_comments` -- DROP TABLE IF EXISTS `piwigo_comments`; CREATE TABLE `piwigo_comments` ( `id` int(11) unsigned NOT NULL auto_increment, `image_id` mediumint(8) unsigned NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `author` varchar(255) default NULL, `author_id` smallint(5) DEFAULT NULL, `content` longtext, `validated` enum('true','false') NOT NULL default 'false', `validation_date` datetime default NULL, PRIMARY KEY (`id`), KEY `comments_i2` (`validation_date`), KEY `comments_i1` (`image_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_config` -- DROP TABLE IF EXISTS `piwigo_config`; CREATE TABLE `piwigo_config` ( `param` varchar(40) NOT NULL default '', `value` text, `comment` varchar(255) default NULL, PRIMARY KEY (`param`) ) ENGINE=MyISAM COMMENT='configuration table'; -- -- Table structure for table `piwigo_favorites` -- DROP TABLE IF EXISTS `piwigo_favorites`; CREATE TABLE `piwigo_favorites` ( `user_id` smallint(5) NOT NULL default '0', `image_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`,`image_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_group_access` -- DROP TABLE IF EXISTS `piwigo_group_access`; CREATE TABLE `piwigo_group_access` ( `group_id` smallint(5) unsigned NOT NULL default '0', `cat_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`group_id`,`cat_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_groups` -- DROP TABLE IF EXISTS `piwigo_groups`; CREATE TABLE `piwigo_groups` ( `id` smallint(5) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `is_default` enum('true','false') NOT NULL default 'false', PRIMARY KEY (`id`), UNIQUE KEY `groups_ui1` (`name`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_history` -- DROP TABLE IF EXISTS `piwigo_history`; CREATE TABLE `piwigo_history` ( `id` int(10) unsigned NOT NULL auto_increment, `date` date NOT NULL default '0000-00-00', `time` time NOT NULL default '00:00:00', `user_id` smallint(5) NOT NULL default '0', `IP` varchar(15) NOT NULL default '', `section` enum('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats') default NULL, `category_id` smallint(5) default NULL, `tag_ids` varchar(50) default NULL, `image_id` mediumint(8) default NULL, `summarized` enum('true','false') default 'false', `image_type` enum('picture','high','other') default NULL, PRIMARY KEY (`id`), KEY `history_i1` (`summarized`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_history_summary` -- DROP TABLE IF EXISTS `piwigo_history_summary`; CREATE TABLE `piwigo_history_summary` ( `year` smallint(4) NOT NULL default '0', `month` tinyint(2) default NULL, `day` tinyint(2) default NULL, `hour` tinyint(2) default NULL, `nb_pages` int(11) default NULL, UNIQUE KEY history_summary_ymdh (`year`,`month`,`day`,`hour`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_image_category` -- DROP TABLE IF EXISTS `piwigo_image_category`; CREATE TABLE `piwigo_image_category` ( `image_id` mediumint(8) unsigned NOT NULL default '0', `category_id` smallint(5) unsigned NOT NULL default '0', `rank` mediumint(8) unsigned default NULL, PRIMARY KEY (`image_id`,`category_id`), KEY `image_category_i1` (`category_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_image_tag` -- DROP TABLE IF EXISTS `piwigo_image_tag`; CREATE TABLE `piwigo_image_tag` ( `image_id` mediumint(8) unsigned NOT NULL default '0', `tag_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`image_id`,`tag_id`), KEY `image_tag_i1` (`tag_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_images` -- DROP TABLE IF EXISTS `piwigo_images`; CREATE TABLE `piwigo_images` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `file` varchar(255) binary NOT NULL default '', `date_available` datetime NOT NULL default '0000-00-00 00:00:00', `date_creation` datetime default NULL, `tn_ext` varchar(4) default '', `name` varchar(255) default NULL, `comment` text, `author` varchar(255) default NULL, `hit` int(10) unsigned NOT NULL default '0', `filesize` mediumint(9) unsigned default NULL, `width` smallint(9) unsigned default NULL, `height` smallint(9) unsigned default NULL, `representative_ext` varchar(4) default NULL, `date_metadata_update` date default NULL, `average_rate` float(5,2) unsigned default NULL, `has_high` enum('true') default NULL, `path` varchar(255) NOT NULL default '', `storage_category_id` smallint(5) unsigned default NULL, `high_filesize` mediumint(9) unsigned default NULL, `high_width` smallint(9) unsigned default NULL, `high_height` smallint(9) unsigned default NULL, `level` tinyint unsigned NOT NULL default '0', `md5sum` char(32) default NULL, `added_by` smallint(5) NOT NULL default '0', PRIMARY KEY (`id`), KEY `images_i2` (`date_available`), KEY `images_i3` (`average_rate`), KEY `images_i4` (`hit`), KEY `images_i5` (`date_creation`), KEY `images_i1` (`storage_category_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_languages` -- DROP TABLE IF EXISTS `piwigo_languages`; CREATE TABLE `piwigo_languages` ( `id` varchar(64) NOT NULL default '', `version` varchar(64) NOT NULL default '0', `name` varchar(64) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_old_permalinks` -- DROP TABLE IF EXISTS `piwigo_old_permalinks`; CREATE TABLE `piwigo_old_permalinks` ( `cat_id` smallint(5) unsigned NOT NULL default '0', `permalink` varchar(64) binary NOT NULL default '', `date_deleted` datetime NOT NULL default '0000-00-00 00:00:00', `last_hit` datetime default NULL, `hit` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`permalink`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_plugins` -- DROP TABLE IF EXISTS `piwigo_plugins`; CREATE TABLE `piwigo_plugins` ( `id` varchar(64) binary NOT NULL default '', `state` enum('inactive','active') NOT NULL default 'inactive', `version` varchar(64) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_rate` -- DROP TABLE IF EXISTS `piwigo_rate`; CREATE TABLE `piwigo_rate` ( `user_id` smallint(5) NOT NULL default '0', `element_id` mediumint(8) unsigned NOT NULL default '0', `anonymous_id` varchar(45) NOT NULL default '', `rate` tinyint(2) unsigned NOT NULL default '0', `date` date NOT NULL default '0000-00-00', PRIMARY KEY (`element_id`,`user_id`,`anonymous_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_search` -- DROP TABLE IF EXISTS `piwigo_search`; CREATE TABLE `piwigo_search` ( `id` int(10) unsigned NOT NULL auto_increment, `last_seen` date default NULL, `rules` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_sessions` -- DROP TABLE IF EXISTS `piwigo_sessions`; CREATE TABLE `piwigo_sessions` ( `id` varchar(255) binary NOT NULL default '', `data` mediumtext NOT NULL, `expiration` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_sites` -- DROP TABLE IF EXISTS `piwigo_sites`; CREATE TABLE `piwigo_sites` ( `id` tinyint(4) NOT NULL auto_increment, `galleries_url` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `sites_ui1` (`galleries_url`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_tags` -- DROP TABLE IF EXISTS `piwigo_tags`; CREATE TABLE `piwigo_tags` ( `id` smallint(5) unsigned NOT NULL auto_increment, `name` varchar(255) binary NOT NULL default '', `url_name` varchar(255) binary NOT NULL default '', PRIMARY KEY (`id`), KEY `tags_i1` (`url_name`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_themes` -- DROP TABLE IF EXISTS `piwigo_themes`; CREATE TABLE `piwigo_themes` ( `id` varchar(64) NOT NULL default '', `version` varchar(64) NOT NULL default '0', `name` varchar(64) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_upgrade` -- DROP TABLE IF EXISTS `piwigo_upgrade`; CREATE TABLE `piwigo_upgrade` ( `id` varchar(20) NOT NULL default '', `applied` datetime NOT NULL default '0000-00-00 00:00:00', `description` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_user_access` -- DROP TABLE IF EXISTS `piwigo_user_access`; CREATE TABLE `piwigo_user_access` ( `user_id` smallint(5) NOT NULL default '0', `cat_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`,`cat_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_user_cache` -- DROP TABLE IF EXISTS `piwigo_user_cache`; CREATE TABLE `piwigo_user_cache` ( `user_id` smallint(5) NOT NULL default '0', `need_update` enum('true','false') NOT NULL default 'true', `cache_update_time` integer unsigned NOT NULL default 0, `forbidden_categories` mediumtext, `nb_total_images` mediumint(8) unsigned default NULL, `image_access_type` enum('NOT IN','IN') NOT NULL default 'NOT IN', `image_access_list` mediumtext default NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_user_cache_categories` -- DROP TABLE IF EXISTS `piwigo_user_cache_categories`; CREATE TABLE `piwigo_user_cache_categories` ( `user_id` smallint(5) NOT NULL default '0', `cat_id` smallint(5) unsigned NOT NULL default '0', `date_last` datetime default NULL, `max_date_last` datetime default NULL, `nb_images` mediumint(8) unsigned NOT NULL default '0', `count_images` mediumint(8) unsigned default '0', `count_categories` mediumint(8) unsigned default '0', `user_representative_picture_id` mediumint(8) unsigned default NULL, PRIMARY KEY (`user_id`,`cat_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_user_feed` -- DROP TABLE IF EXISTS `piwigo_user_feed`; CREATE TABLE `piwigo_user_feed` ( `id` varchar(50) binary NOT NULL default '', `user_id` smallint(5) NOT NULL default '0', `last_check` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_user_group` -- DROP TABLE IF EXISTS `piwigo_user_group`; CREATE TABLE `piwigo_user_group` ( `user_id` smallint(5) NOT NULL default '0', `group_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`group_id`,`user_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_user_infos` -- DROP TABLE IF EXISTS `piwigo_user_infos`; CREATE TABLE `piwigo_user_infos` ( `user_id` smallint(5) NOT NULL default '0', `nb_image_line` tinyint(1) unsigned NOT NULL default '5', `nb_line_page` tinyint(3) unsigned NOT NULL default '3', `status` enum('webmaster','admin','normal','generic','guest') NOT NULL default 'guest', `language` varchar(50) NOT NULL default 'en_UK', `maxwidth` smallint(6) default NULL, `maxheight` smallint(6) default NULL, `expand` enum('true','false') NOT NULL default 'false', `show_nb_comments` enum('true','false') NOT NULL default 'false', `show_nb_hits` enum('true','false') NOT NULL default 'false', `recent_period` tinyint(3) unsigned NOT NULL default '7', `theme` varchar(255) NOT NULL default 'Sylvia', `registration_date` datetime NOT NULL default '0000-00-00 00:00:00', `enabled_high` enum('true','false') NOT NULL default 'true', `level` tinyint unsigned NOT NULL default '0', UNIQUE KEY `user_infos_ui1` (`user_id`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_user_mail_notification` -- DROP TABLE IF EXISTS `piwigo_user_mail_notification`; CREATE TABLE `piwigo_user_mail_notification` ( `user_id` smallint(5) NOT NULL default '0', `check_key` varchar(16) binary NOT NULL default '', `enabled` enum('true','false') NOT NULL default 'false', `last_send` datetime default NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `user_mail_notification_ui1` (`check_key`) ) ENGINE=MyISAM; -- -- Table structure for table `piwigo_users` -- DROP TABLE IF EXISTS `piwigo_users`; CREATE TABLE `piwigo_users` ( `id` smallint(5) NOT NULL auto_increment, `username` varchar(100) binary NOT NULL default '', `password` varchar(32) default NULL, `mail_address` varchar(255) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_ui1` (`username`) ) ENGINE=MyISAM;