Bugzilla – Attachment 9682 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.59 KB, created by
Chris Nighswonger
on 2012-05-21 18:15:22 UTC
(
hide
)
Description:
Making source a text field rather than a varchar to avoid potential length limitations
Filename:
MIME Type:
Creator:
Chris Nighswonger
Created:
2012-05-21 18:15:22 UTC
Size:
1.59 KB
patch
obsolete
>From f4e9a623fef4ec18a2182240334872e25242850e 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" > >--- > 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
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