diff options
| author | alecpl <alec@alec.pl> | 2008-06-12 06:26:17 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2008-06-12 06:26:17 +0000 |
| commit | f18911adb4a6d08fc85963a2f15f13fa869877ec (patch) | |
| tree | beef40b15f98ab1a59269c2fb162b315259ed5c3 /SQL | |
| parent | d87fc29fee9e629fad49d956a449ae647c0bc142 (diff) | |
- #1485120 (text column can't have a default value)
Diffstat (limited to 'SQL')
| -rw-r--r-- | SQL/mysql.initial.sql | 2 | ||||
| -rw-r--r-- | SQL/mysql.update.sql | 2 | ||||
| -rw-r--r-- | SQL/mysql5.initial.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index fadc07280..ec420734f 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -55,7 +55,7 @@ CREATE TABLE `identities` ( `email` varchar(128) NOT NULL, `reply-to` varchar(128) NOT NULL default '', `bcc` varchar(128) NOT NULL default '', - `signature` text NOT NULL default '', + `signature` text, `html_signature` tinyint(1) NOT NULL default '0', PRIMARY KEY (`identity_id`), KEY `user_id` (`user_id`) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index 2a9603f3e..f07672614 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -19,7 +19,7 @@ ALTER TABLE `users` -- Updates from version 0.1.1 ALTER TABLE `identities` - MODIFY `signature` text NOT NULL DEFAULT '', + MODIFY `signature` text, MODIFY `bcc` varchar(128) NOT NULL DEFAULT '', MODIFY `reply-to` varchar(128) NOT NULL DEFAULT '', MODIFY `organization` varchar(128) NOT NULL DEFAULT '', diff --git a/SQL/mysql5.initial.sql b/SQL/mysql5.initial.sql index 546eecd29..7e3dd9a73 100644 --- a/SQL/mysql5.initial.sql +++ b/SQL/mysql5.initial.sql @@ -111,7 +111,7 @@ CREATE TABLE `identities` ( `email` varchar(128) NOT NULL, `reply-to` varchar(128) NOT NULL DEFAULT '', `bcc` varchar(128) NOT NULL DEFAULT '', - `signature` text NOT NULL DEFAULT '', + `signature` text, `html_signature` tinyint(1) NOT NULL DEFAULT '0', `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY(`identity_id`), |