From 310ee114983b33c6ba1823dbc811ff8c843e045d Mon Sep 17 00:00:00 2001 From: Chris Nighswonger Date: Mon, 21 May 2012 14:08:57 -0400 Subject: [PATCH] Making source a text field rather than a varchar to avoid potential length limitations Content-Type: text/plain; charset="utf-8" http://koha-community.org http://bugs.koha-community.org/show_bug.cgi?id=7977 Signed-off-by: Mason James --- installer/data/mysql/kohastructure.sql | 2 +- installer/data/mysql/updatedatabase.pl | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a6f8456..494691a 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2838,7 +2838,7 @@ CREATE TABLE ratings ( DROP TABLE IF EXISTS quotes; CREATE TABLE `quotes` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `source` varchar(45) DEFAULT NULL, + `source` text DEFAULT NULL, `text` mediumtext NOT NULL, `timestamp` datetime NOT NULL, PRIMARY KEY (`id`) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 500e25a..399506e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -5252,7 +5252,7 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { $dbh->do( qq{ CREATE TABLE `quotes` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `source` varchar(45) DEFAULT NULL, + `source` text DEFAULT NULL, `text` mediumtext NOT NULL, `timestamp` datetime NOT NULL, PRIMARY KEY (`id`) -- 1.7.2.5