aboutsummaryrefslogtreecommitdiffstats
path: root/install/phpwebgallery_structure.sql
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2006-11-09 22:13:33 +0000
committerplegall <plg@piwigo.org>2006-11-09 22:13:33 +0000
commit1233f248ed20795c544441c5ebd97e344462c70a (patch)
tree3e0594904d0bf4dedfad9cfccd3391698897b478 /install/phpwebgallery_structure.sql
parente4606c00b04bb58e18fdf744567d1d329658719d (diff)
New: upgrade script from 1.6.0 (or 1.6.1) to 1.6.2.
#user_infos.auto_login_key is added in upgrade_1.6.0.php instead of upgrade_1.5.0.php. Bug fixed: the database structure dump was starting with a "1", very interesting typo! Bug fixed: the database structure dump was adding #user_infos.auto_login_key nullable while the upgrade file was adding it not nullable. git-svn-id: http://piwigo.org/svn/branches/branch-1_6@1599 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/phpwebgallery_structure.sql')
-rw-r--r--install/phpwebgallery_structure.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index 43bf6128b..65ee39eca 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -1,4 +1,4 @@
-1-- MySQL dump 9.11
+-- MySQL dump 9.11
--
-- Host: localhost Database: pwg-1_6
-- ------------------------------------------------------
@@ -318,6 +318,7 @@ CREATE TABLE `phpwebgallery_user_infos` (
`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',
+ `auto_login_key` varchar(64) NOT NULL default '',
UNIQUE KEY `user_infos_ui1` (`user_id`)
) TYPE=MyISAM;
@@ -345,7 +346,6 @@ CREATE TABLE `phpwebgallery_users` (
`username` varchar(100) binary NOT NULL default '',
`password` varchar(32) default NULL,
`mail_address` varchar(255) default NULL,
- `auto_login_key` varchar(64) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_ui1` (`username`)
) TYPE=MyISAM;