aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-mysql.sql
diff options
context:
space:
mode:
authornikrou <nikrou@piwigo.org>2009-12-02 20:27:06 +0000
committernikrou <nikrou@piwigo.org>2009-12-02 20:27:06 +0000
commitfdfaefd17a7b3c91d214a60a27524bb138df3552 (patch)
tree56b7379da093bf2b6fc948215f6091a0cd988433 /install/piwigo_structure-mysql.sql
parentb8c33dcf2035f4cd5a67d918f1a5c490b128f9ae (diff)
Feature 1255 :
- add postgres database engine - change installation process to allow postgres or mysql database git-svn-id: http://piwigo.org/svn/trunk@4410 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/piwigo_structure-mysql.sql')
-rw-r--r--install/piwigo_structure-mysql.sql442
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;