summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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`),