Bugzilla – Attachment 20209 Details for
Bug 10703
add/update database documentation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10703: Document quotes table
0001-Bug-10703-Document-quotes-table.patch (text/plain), 1.35 KB, created by
Nicole C. Engard
on 2013-08-09 01:03:12 UTC
(
hide
)
Description:
Bug 10703: Document quotes table
Filename:
MIME Type:
Creator:
Nicole C. Engard
Created:
2013-08-09 01:03:12 UTC
Size:
1.35 KB
patch
obsolete
>From 1cab017ac444638400b264aec61d63c5c0e509d5 Mon Sep 17 00:00:00 2001 >From: Nicole C. Engard <nengard@bywatersolutions.com> >Date: Thu, 8 Aug 2013 08:53:58 -0400 >Subject: [PATCH] Bug 10703: Document quotes table > >Add db documentation for the quotes table > >To test: > >apply patch >review kohastructure.sql to be sure documentation is there >--- > installer/data/mysql/kohastructure.sql | 10 +++++----- > 1 files changed, 5 insertions(+), 5 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 8a8b70f..eacb929 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3059,11 +3059,11 @@ CREATE TABLE ratings ( -- information related to the star ratings in the OPAC > -- > > DROP TABLE IF EXISTS quotes; >-CREATE TABLE `quotes` ( >- `id` int(11) NOT NULL AUTO_INCREMENT, >- `source` text DEFAULT NULL, >- `text` mediumtext NOT NULL, >- `timestamp` datetime NOT NULL, >+CREATE TABLE `quotes` ( -- data for the quote of the day feature >+ `id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote >+ `source` text DEFAULT NULL, -- source/credit for the quote >+ `text` mediumtext NOT NULL, -- text of the quote >+ `timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > >-- >1.7.2.3 >
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 10703
:
20208
|
20209
|
20210
|
20248
|
20249
|
20250
|
20415
|
20416
|
20417
|
36582
|
36602
|
36603
|
36604
|
36605
|
36640
|
36641
|
36642
|
36648
|
36649
|
36650
|
36660
|
36669
|
36670
|
36910
|
36911
|
36912
|
36913