From c6e808e90c67f08a821907053a83013a9213a021 Mon Sep 17 00:00:00 2001 From: svncommit <devs@roundcube.net> Date: Tue, 24 Jan 2006 23:33:25 -0500 Subject: [PATCH] fixed mysql SQL scripts for new created column --- SQL/mysql.update.sql | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index 778919a..08ce920 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -2,8 +2,8 @@ -- Version 0.1-20051007 -ALTER TABLE session ADD ip VARCHAR(15) NOT NULL AFTER changed; -ALTER TABLE users ADD alias VARCHAR(128) NOT NULL AFTER mail_host; +ALTER TABLE `session` ADD `ip` VARCHAR(15) NOT NULL AFTER changed; +ALTER TABLE `users` ADD `alias` VARCHAR(128) NOT NULL AFTER mail_host; @@ -31,6 +31,7 @@ `user_id` int(11) unsigned NOT NULL default '0', `del` tinyint(1) NOT NULL default '0', `cache_key` varchar(128) NOT NULL default '', + `created` datetime NOT NULL default '0000-00-00 00:00:00', `idx` int(11) unsigned NOT NULL default '0', `uid` int(11) unsigned NOT NULL default '0', `subject` varchar(255) NOT NULL default '', -- Gitblit v1.9.1