diff options
Diffstat (limited to 'install/piwigo_structure.sql')
| -rw-r--r-- | install/piwigo_structure.sql | 442 |
1 files changed, 0 insertions, 442 deletions
diff --git a/install/piwigo_structure.sql b/install/piwigo_structure.sql deleted file mode 100644 index 559addfc4..000000000 --- a/install/piwigo_structure.sql +++ /dev/null @@ -1,442 +0,0 @@ --- 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`) -) TYPE=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', - `uploadable` enum('true','false') NOT NULL default 'false', - `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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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` date 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, - `level` tinyint unsigned NOT NULL default '0', - `md5sum` char(32) default NULL, - 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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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', - PRIMARY KEY (`user_id`,`cat_id`) -) TYPE=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`) -) TYPE=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`) -) TYPE=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', - `adviser` enum('true','false') NOT NULL default 'false', - `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', - `template` varchar(255) NOT NULL default 'yoga/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`) -) TYPE=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`) -) TYPE=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`) -) TYPE=MyISAM; - --- --- Table structure for table `piwigo_waiting` --- - -DROP TABLE IF EXISTS `piwigo_waiting`; -CREATE TABLE `piwigo_waiting` ( - `id` int(10) unsigned NOT NULL auto_increment, - `storage_category_id` smallint(5) unsigned NOT NULL default '0', - `file` varchar(255) NOT NULL default '', - `username` varchar(255) NOT NULL default '', - `mail_address` varchar(255) NOT NULL default '', - `date` int(10) unsigned NOT NULL default '0', - `tn_ext` char(3) default NULL, - `validated` enum('true','false') NOT NULL default 'false', - `infos` text, - PRIMARY KEY (`id`) -) TYPE=MyISAM; |