summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2008-06-12 06:26:17 +0000
committeralecpl <alec@alec.pl>2008-06-12 06:26:17 +0000
commitf18911adb4a6d08fc85963a2f15f13fa869877ec (patch)
treebeef40b15f98ab1a59269c2fb162b315259ed5c3
parentd87fc29fee9e629fad49d956a449ae647c0bc142 (diff)
- #1485120 (text column can't have a default value)
-rw-r--r--SQL/mysql.initial.sql2
-rw-r--r--SQL/mysql.update.sql2
-rw-r--r--SQL/mysql5.initial.sql2
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`),