From f4e9a623fef4ec18a2182240334872e25242850e 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" --- 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 b28de2e..e13bfd6 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.0.4