aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--install/piwigo_structure.sql (renamed from install/phpwebgallery_structure.sql)180
1 files changed, 90 insertions, 90 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/piwigo_structure.sql
index f34b2f571..aa290149f 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/piwigo_structure.sql
@@ -5,22 +5,22 @@
-- Server version 4.0.24_Debian-10-log
--
--- Table structure for table `phpwebgallery_caddie`
+-- Table structure for table `piwigo_caddie`
--
-DROP TABLE IF EXISTS `phpwebgallery_caddie`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_categories`
+-- Table structure for table `piwigo_categories`
--
-DROP TABLE IF EXISTS `phpwebgallery_categories`;
-CREATE TABLE `phpwebgallery_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,
@@ -43,11 +43,11 @@ CREATE TABLE `phpwebgallery_categories` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_comments`
+-- Table structure for table `piwigo_comments`
--
-DROP TABLE IF EXISTS `phpwebgallery_comments`;
-CREATE TABLE `phpwebgallery_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',
@@ -61,11 +61,11 @@ CREATE TABLE `phpwebgallery_comments` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_config`
+-- Table structure for table `piwigo_config`
--
-DROP TABLE IF EXISTS `phpwebgallery_config`;
-CREATE TABLE `phpwebgallery_config` (
+DROP TABLE IF EXISTS `piwigo_config`;
+CREATE TABLE `piwigo_config` (
`param` varchar(40) NOT NULL default '',
`value` text,
`comment` varchar(255) default NULL,
@@ -73,33 +73,33 @@ CREATE TABLE `phpwebgallery_config` (
) TYPE=MyISAM COMMENT='configuration table';
--
--- Table structure for table `phpwebgallery_favorites`
+-- Table structure for table `piwigo_favorites`
--
-DROP TABLE IF EXISTS `phpwebgallery_favorites`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_group_access`
+-- Table structure for table `piwigo_group_access`
--
-DROP TABLE IF EXISTS `phpwebgallery_group_access`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_groups`
+-- Table structure for table `piwigo_groups`
--
-DROP TABLE IF EXISTS `phpwebgallery_groups`;
-CREATE TABLE `phpwebgallery_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',
@@ -108,11 +108,11 @@ CREATE TABLE `phpwebgallery_groups` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_history`
+-- Table structure for table `piwigo_history`
--
-DROP TABLE IF EXISTS `phpwebgallery_history`;
-CREATE TABLE `phpwebgallery_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',
@@ -129,11 +129,11 @@ CREATE TABLE `phpwebgallery_history` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_history_summary`
+-- Table structure for table `piwigo_history_summary`
--
-DROP TABLE IF EXISTS `phpwebgallery_history_summary`;
-CREATE TABLE `phpwebgallery_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,
@@ -143,11 +143,11 @@ CREATE TABLE `phpwebgallery_history_summary` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_image_category`
+-- Table structure for table `piwigo_image_category`
--
-DROP TABLE IF EXISTS `phpwebgallery_image_category`;
-CREATE TABLE `phpwebgallery_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',
PRIMARY KEY (`image_id`,`category_id`),
@@ -155,11 +155,11 @@ CREATE TABLE `phpwebgallery_image_category` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_image_tag`
+-- Table structure for table `piwigo_image_tag`
--
-DROP TABLE IF EXISTS `phpwebgallery_image_tag`;
-CREATE TABLE `phpwebgallery_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`),
@@ -167,11 +167,11 @@ CREATE TABLE `phpwebgallery_image_tag` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_images`
+-- Table structure for table `piwigo_images`
--
-DROP TABLE IF EXISTS `phpwebgallery_images`;
-CREATE TABLE `phpwebgallery_images` (
+DROP TABLE IF EXISTS `piwigo_images`;
+CREATE TABLE `piwigo_images` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`file` varchar(255) NOT NULL default '',
`date_available` datetime NOT NULL default '0000-00-00 00:00:00',
@@ -201,11 +201,11 @@ CREATE TABLE `phpwebgallery_images` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_old_permalinks`
+-- Table structure for table `piwigo_old_permalinks`
--
-DROP TABLE IF EXISTS `phpwebgallery_old_permalinks`;
-CREATE TABLE `phpwebgallery_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) NOT NULL default '',
`date_deleted` datetime NOT NULL default '0000-00-00 00:00:00',
@@ -215,11 +215,11 @@ CREATE TABLE `phpwebgallery_old_permalinks` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_plugins`
+-- Table structure for table `piwigo_plugins`
--
-DROP TABLE IF EXISTS `phpwebgallery_plugins`;
-CREATE TABLE `phpwebgallery_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',
@@ -227,11 +227,11 @@ CREATE TABLE `phpwebgallery_plugins` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_rate`
+-- Table structure for table `piwigo_rate`
--
-DROP TABLE IF EXISTS `phpwebgallery_rate`;
-CREATE TABLE `phpwebgallery_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 '',
@@ -241,11 +241,11 @@ CREATE TABLE `phpwebgallery_rate` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_search`
+-- Table structure for table `piwigo_search`
--
-DROP TABLE IF EXISTS `phpwebgallery_search`;
-CREATE TABLE `phpwebgallery_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,
@@ -253,11 +253,11 @@ CREATE TABLE `phpwebgallery_search` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_sessions`
+-- Table structure for table `piwigo_sessions`
--
-DROP TABLE IF EXISTS `phpwebgallery_sessions`;
-CREATE TABLE `phpwebgallery_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',
@@ -265,11 +265,11 @@ CREATE TABLE `phpwebgallery_sessions` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_sites`
+-- Table structure for table `piwigo_sites`
--
-DROP TABLE IF EXISTS `phpwebgallery_sites`;
-CREATE TABLE `phpwebgallery_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`),
@@ -277,11 +277,11 @@ CREATE TABLE `phpwebgallery_sites` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_tags`
+-- Table structure for table `piwigo_tags`
--
-DROP TABLE IF EXISTS `phpwebgallery_tags`;
-CREATE TABLE `phpwebgallery_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 '',
@@ -290,11 +290,11 @@ CREATE TABLE `phpwebgallery_tags` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_upgrade`
+-- Table structure for table `piwigo_upgrade`
--
-DROP TABLE IF EXISTS `phpwebgallery_upgrade`;
-CREATE TABLE `phpwebgallery_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,
@@ -302,22 +302,22 @@ CREATE TABLE `phpwebgallery_upgrade` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_user_access`
+-- Table structure for table `piwigo_user_access`
--
-DROP TABLE IF EXISTS `phpwebgallery_user_access`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_user_cache`
+-- Table structure for table `piwigo_user_cache`
--
-DROP TABLE IF EXISTS `phpwebgallery_user_cache`;
-CREATE TABLE `phpwebgallery_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',
`forbidden_categories` mediumtext,
@@ -328,11 +328,11 @@ CREATE TABLE `phpwebgallery_user_cache` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_user_cache_categories`
+-- Table structure for table `piwigo_user_cache_categories`
--
-DROP TABLE IF EXISTS `phpwebgallery_user_cache_categories`;
-CREATE TABLE `phpwebgallery_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,
@@ -344,11 +344,11 @@ CREATE TABLE `phpwebgallery_user_cache_categories` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_user_feed`
+-- Table structure for table `piwigo_user_feed`
--
-DROP TABLE IF EXISTS `phpwebgallery_user_feed`;
-CREATE TABLE `phpwebgallery_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,
@@ -356,22 +356,22 @@ CREATE TABLE `phpwebgallery_user_feed` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_user_group`
+-- Table structure for table `piwigo_user_group`
--
-DROP TABLE IF EXISTS `phpwebgallery_user_group`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_user_infos`
+-- Table structure for table `piwigo_user_infos`
--
-DROP TABLE IF EXISTS `phpwebgallery_user_infos`;
-CREATE TABLE `phpwebgallery_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',
@@ -392,11 +392,11 @@ CREATE TABLE `phpwebgallery_user_infos` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_user_mail_notification`
+-- Table structure for table `piwigo_user_mail_notification`
--
-DROP TABLE IF EXISTS `phpwebgallery_user_mail_notification`;
-CREATE TABLE `phpwebgallery_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',
@@ -406,11 +406,11 @@ CREATE TABLE `phpwebgallery_user_mail_notification` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_users`
+-- Table structure for table `piwigo_users`
--
-DROP TABLE IF EXISTS `phpwebgallery_users`;
-CREATE TABLE `phpwebgallery_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,
@@ -420,11 +420,11 @@ CREATE TABLE `phpwebgallery_users` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_waiting`
+-- Table structure for table `piwigo_waiting`
--
-DROP TABLE IF EXISTS `phpwebgallery_waiting`;
-CREATE TABLE `phpwebgallery_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 '',
@@ -438,11 +438,11 @@ CREATE TABLE `phpwebgallery_waiting` (
) TYPE=MyISAM;
--
--- Table structure for table `phpwebgallery_ws_access`
+-- Table structure for table `piwigo_ws_access`
--
-DROP TABLE IF EXISTS `phpwebgallery_ws_access`;
-CREATE TABLE `phpwebgallery_ws_access` (
+DROP TABLE IF EXISTS `piwigo_ws_access`;
+CREATE TABLE `piwigo_ws_access` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`access` varchar(255) default NULL,