Bugzilla – Attachment 9730 Details for
Bug 7977
Add a "Quote-of-the-day" feature to the OPAC homepage
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Making source a text field rather than a varchar to avoid potential length limitations
Making-source-a-text-field-rather-than-a-varchar-t.patch (text/plain), 1.71 KB, created by
Mason James
on 2012-05-22 23:58:33 UTC
(
hide
)
Description:
Making source a text field rather than a varchar to avoid potential length limitations
Filename:
MIME Type:
Creator:
Mason James
Created:
2012-05-22 23:58:33 UTC
Size:
1.71 KB
patch
obsolete
>From 310ee114983b33c6ba1823dbc811ff8c843e045d Mon Sep 17 00:00:00 2001 >From: Chris Nighswonger <cnighswonger@foundations.edu> >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 <mtj@kohaaloha.com> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 7977
:
9310
|
9321
|
9323
|
9324
|
9325
|
9326
|
9327
|
9328
|
9338
|
9343
|
9373
|
9376
|
9377
|
9378
|
9392
|
9405
|
9406
|
9407
|
9408
|
9409
|
9433
|
9434
|
9435
|
9441
|
9442
|
9443
|
9447
|
9473
|
9474
|
9475
|
9476
|
9477
|
9478
|
9479
|
9480
|
9481
|
9482
|
9483
|
9484
|
9485
|
9486
|
9503
|
9504
|
9505
|
9510
|
9517
|
9521
|
9529
|
9530
|
9531
|
9682
|
9683
|
9711
|
9712
|
9713
|
9714
|
9715
|
9716
|
9717
|
9718
|
9719
|
9720
|
9721
|
9722
|
9723
|
9724
|
9725
|
9726
|
9727
|
9728
|
9729
| 9730 |
9731
|
9732