From 51491ab08f2be1c59439e049a20d7555ec0f918d Mon Sep 17 00:00:00 2001
From: rub <rub@piwigo.org>
Date: Wed, 14 May 2008 22:25:36 +0000
Subject: Change some PhpWebGallery to Piwigo. Not all PhpWebGallery has been
 translated!

git-svn-id: http://piwigo.org/svn/trunk@2339 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 install/phpwebgallery_structure.sql | 457 ------------------------------------
 install/piwigo_structure.sql        | 457 ++++++++++++++++++++++++++++++++++++
 install/upgrade_1.4.0.php           |  42 ++--
 3 files changed, 478 insertions(+), 478 deletions(-)
 delete mode 100644 install/phpwebgallery_structure.sql
 create mode 100644 install/piwigo_structure.sql

(limited to 'install')

diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
deleted file mode 100644
index f34b2f571..000000000
--- a/install/phpwebgallery_structure.sql
+++ /dev/null
@@ -1,457 +0,0 @@
--- MySQL dump 9.11
---
--- Host: localhost    Database: pwg-bsf
--- ------------------------------------------------------
--- Server version	4.0.24_Debian-10-log
-
---
--- Table structure for table `phpwebgallery_caddie`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_caddie`;
-CREATE TABLE `phpwebgallery_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`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_categories`;
-CREATE TABLE `phpwebgallery_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) default NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `categories_i3` (`permalink`),
-  KEY `categories_i2` (`id_uppercat`)
-) TYPE=MyISAM;
-
---
--- Table structure for table `phpwebgallery_comments`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_comments`;
-CREATE TABLE `phpwebgallery_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,
-  `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 `phpwebgallery_config`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_config`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_favorites`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_favorites`;
-CREATE TABLE `phpwebgallery_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`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_group_access`;
-CREATE TABLE `phpwebgallery_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`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_groups`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_history`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_history`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_history_summary`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_history_summary`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_image_category`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_image_category`;
-CREATE TABLE `phpwebgallery_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`),
-  KEY `image_category_i1` (`category_id`)
-) TYPE=MyISAM;
-
---
--- Table structure for table `phpwebgallery_image_tag`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_image_tag`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_images`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_images`;
-CREATE TABLE `phpwebgallery_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',
-  `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',
-  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 `phpwebgallery_old_permalinks`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_old_permalinks`;
-CREATE TABLE `phpwebgallery_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',
-  `last_hit` datetime default NULL,
-  `hit` int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`permalink`)
-) TYPE=MyISAM;
-
---
--- Table structure for table `phpwebgallery_plugins`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_plugins`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_rate`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_rate`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_search`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_search`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_sessions`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_sessions`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_sites`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_sites`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_tags`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_tags`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_upgrade`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_upgrade`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_user_access`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_user_access`;
-CREATE TABLE `phpwebgallery_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`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_user_cache`;
-CREATE TABLE `phpwebgallery_user_cache` (
-  `user_id` smallint(5) NOT NULL default '0',
-  `need_update` enum('true','false') NOT NULL default 'true',
-  `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 `phpwebgallery_user_cache_categories`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_user_cache_categories`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_user_feed`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_user_feed`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_user_group`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_user_group`;
-CREATE TABLE `phpwebgallery_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`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_user_infos`;
-CREATE TABLE `phpwebgallery_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/clear',
-  `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 `phpwebgallery_user_mail_notification`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_user_mail_notification`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_users`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_users`;
-CREATE TABLE `phpwebgallery_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 `phpwebgallery_waiting`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_waiting`;
-CREATE TABLE `phpwebgallery_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;
-
---
--- Table structure for table `phpwebgallery_ws_access`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_ws_access`;
-CREATE TABLE `phpwebgallery_ws_access` (
-  `id` smallint(5) unsigned NOT NULL auto_increment,
-  `name` varchar(32) NOT NULL default '',
-  `access` varchar(255) default NULL,
-  `start` datetime default NULL,
-  `end` datetime default NULL,
-  `request` varchar(255) default NULL,
-  `limit` smallint(5) unsigned default NULL,
-  `comment` varchar(255) default NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `ws_access_ui1` (`name`)
-) TYPE=MyISAM COMMENT='Access for Web Services';
-
diff --git a/install/piwigo_structure.sql b/install/piwigo_structure.sql
new file mode 100644
index 000000000..aa290149f
--- /dev/null
+++ b/install/piwigo_structure.sql
@@ -0,0 +1,457 @@
+-- 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) 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,
+  `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',
+  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) 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',
+  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) 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',
+  `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/clear',
+  `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;
+
+--
+-- Table structure for table `piwigo_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,
+  `start` datetime default NULL,
+  `end` datetime default NULL,
+  `request` varchar(255) default NULL,
+  `limit` smallint(5) unsigned default NULL,
+  `comment` varchar(255) default NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `ws_access_ui1` (`name`)
+) TYPE=MyISAM COMMENT='Access for Web Services';
+
diff --git a/install/upgrade_1.4.0.php b/install/upgrade_1.4.0.php
index c7ad6ac69..f49e2f9f2 100644
--- a/install/upgrade_1.4.0.php
+++ b/install/upgrade_1.4.0.php
@@ -69,72 +69,72 @@ mysql_query($query);
 $queries = array(
 
   "
-ALTER TABLE phpwebgallery_categories
+ALTER TABLE piwigo_categories
   CHANGE COLUMN date_last date_last datetime default NULL
 ;",
 
   "
-ALTER TABLE phpwebgallery_comments
+ALTER TABLE piwigo_comments
   ADD COLUMN validation_date datetime default NULL
 ;",
 
   "
-UPDATE phpwebgallery_comments
+UPDATE piwigo_comments
   SET validation_date = date
 ",
 
   "
-ALTER TABLE phpwebgallery_comments
+ALTER TABLE piwigo_comments
   ADD INDEX comments_i1 (image_id)
 ;",
 
   "
-ALTER TABLE phpwebgallery_comments
+ALTER TABLE piwigo_comments
   ADD INDEX comments_i2 (validation_date)
 ;",
 
   "
-ALTER TABLE phpwebgallery_favorites
+ALTER TABLE piwigo_favorites
   CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
 ;",
 
   "
-ALTER TABLE phpwebgallery_images
+ALTER TABLE piwigo_images
   CHANGE COLUMN date_available
     date_available datetime NOT NULL default '0000-00-00 00:00:00'
 ;",
 
   "
-ALTER TABLE phpwebgallery_rate
+ALTER TABLE piwigo_rate
   CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
 ;",
 
   "
-ALTER TABLE phpwebgallery_sessions
+ALTER TABLE piwigo_sessions
   CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
 ;",
 
   "
-ALTER TABLE phpwebgallery_user_access
+ALTER TABLE piwigo_user_access
   CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
 ;",
 
   "
-DROP TABLE phpwebgallery_user_forbidden
+DROP TABLE piwigo_user_forbidden
 ;",
 
   "
-ALTER TABLE phpwebgallery_user_group
+ALTER TABLE piwigo_user_group
  CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
 ;",
 
   "
-ALTER TABLE phpwebgallery_users
+ALTER TABLE piwigo_users
   CHANGE COLUMN id id smallint(5) NOT NULL auto_increment
 ;",
 
   "
-CREATE TABLE phpwebgallery_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)
@@ -142,7 +142,7 @@ CREATE TABLE phpwebgallery_caddie (
 ;",
 
   "
-CREATE TABLE phpwebgallery_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 text,
@@ -151,7 +151,7 @@ CREATE TABLE phpwebgallery_user_cache (
 ;",
 
   "
-CREATE TABLE phpwebgallery_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,
@@ -160,7 +160,7 @@ CREATE TABLE phpwebgallery_user_feed (
 ;",
 
   "
-CREATE TABLE phpwebgallery_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',
@@ -180,11 +180,11 @@ CREATE TABLE phpwebgallery_user_infos (
 
 foreach ($queries as $query)
 {
-  $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query);
+  $query = str_replace('piwigo_', PREFIX_TABLE, $query);
   pwg_query($query);
 }
 
-// user datas migration from phpwebgallery_users to phpwebgallery_user_infos
+// user datas migration from piwigo_users to piwigo_user_infos
 $query = '
 SELECT *
   FROM '.USERS_TABLE.'
@@ -253,7 +253,7 @@ INSERT INTO ".CONFIG_TABLE."
   VALUES
   (
     'gallery_title',
-    'PhpWebGallery demonstration site',
+    'Piwigo demonstration site',
     'Title at top of each page and for RSS feed'
   )
 ;",
@@ -273,7 +273,7 @@ INSERT INTO ".CONFIG_TABLE."
 
 foreach ($queries as $query)
 {
-  $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query);
+  $query = str_replace('piwigo_', PREFIX_TABLE, $query);
   pwg_query($query);
 }
 
-- 
cgit v1.2.3