From d42e35ef4970c46bf131eb0a0126c8559e89b58a 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 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 a6f84562ff..494691af1d 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 500e25ab57..399506eda1 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`) -- 2.39.2