diff options
Diffstat (limited to 'install/piwigo_structure-mysql.sql')
| -rw-r--r-- | install/piwigo_structure-mysql.sql | 442 |
1 files changed, 442 insertions, 0 deletions
diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql new file mode 100644 index 000000000..559addfc4 --- /dev/null +++ b/install/piwigo_structure-mysql.sql @@ -0,0 +1,442 @@ +-- 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; |