diff options
| author | svncommit <devs@roundcube.net> | 2006-01-25 04:33:25 +0000 |
|---|---|---|
| committer | svncommit <devs@roundcube.net> | 2006-01-25 04:33:25 +0000 |
| commit | c6e808e90c67f08a821907053a83013a9213a021 (patch) | |
| tree | 1a1ce97f1028a79b829177b2d12e5434a57fc6e0 /SQL | |
| parent | 9d04c24ffa1e3ba541333d1d405857aa016ccde8 (diff) | |
fixed mysql SQL scripts for new created column
Diffstat (limited to 'SQL')
| -rw-r--r-- | SQL/mysql.initial.sql | 1 | ||||
| -rw-r--r-- | SQL/mysql.update.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index eabc75e1f..acaac7bdf 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -106,6 +106,7 @@ CREATE TABLE `messages` ( `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 '', diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index e93fc980f..08ce92019 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -31,6 +31,7 @@ CREATE TABLE `messages` ( `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 '', |