From f18911adb4a6d08fc85963a2f15f13fa869877ec Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Thu, 12 Jun 2008 02:26:17 -0400
Subject: [PATCH] - #1485120 (text column can't have a default value)
---
SQL/mysql5.initial.sql | 2 +-
SQL/mysql.update.sql | 2 +-
SQL/mysql.initial.sql | 2 +-
3 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql
index fadc072..ec42073 100644
--- a/SQL/mysql.initial.sql
+++ b/SQL/mysql.initial.sql
@@ -55,7 +55,7 @@
`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 2a9603f..f076726 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -19,7 +19,7 @@
-- 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 546eecd..7e3dd9a 100644
--- a/SQL/mysql5.initial.sql
+++ b/SQL/mysql5.initial.sql
@@ -111,7 +111,7 @@
`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`),
--
Gitblit v1.9.1