Bugzilla – Attachment 20248 Details for
Bug 10703
add/update database documentation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[SIGNED-OFF] Bug 10703: Add db documentation for biblioimages table
SIGNED-OFF-Bug-10703-Add-db-documentation-for-bibl.patch (text/plain), 1.69 KB, created by
Bernardo Gonzalez Kriegel
on 2013-08-09 21:42:05 UTC
(
hide
)
Description:
[SIGNED-OFF] Bug 10703: Add db documentation for biblioimages table
Filename:
MIME Type:
Creator:
Bernardo Gonzalez Kriegel
Created:
2013-08-09 21:42:05 UTC
Size:
1.69 KB
patch
obsolete
>From 5af698abd545b02e4b64cead6f9631111e64b48d Mon Sep 17 00:00:00 2001 >From: "Nicole C. Engard" <nengard@bywatersolutions.com> >Date: Thu, 8 Aug 2013 08:49:25 -0400 >Subject: [PATCH] [SIGNED-OFF] Bug 10703: Add db documentation for > biblioimages table > >This patch adds db documentation to the biblioimages table. > >To test: > >Apply patch >Review kohastructure.sql to be sure that the documentation is there > >Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> >--- > installer/data/mysql/kohastructure.sql | 12 ++++++------ > 1 file changed, 6 insertions(+), 6 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 8a8b70f..eb565d0 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3013,12 +3013,12 @@ CREATE TABLE transport_cost ( > > DROP TABLE IF EXISTS `biblioimages`; > >-CREATE TABLE `biblioimages` ( >- `imagenumber` int(11) NOT NULL AUTO_INCREMENT, >- `biblionumber` int(11) NOT NULL, >- `mimetype` varchar(15) NOT NULL, >- `imagefile` mediumblob NOT NULL, >- `thumbnail` mediumblob NOT NULL, >+CREATE TABLE `biblioimages` ( -- local cover images >+ `imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image >+ `biblionumber` int(11) NOT NULL, -- foreign key from biblio table to link to biblionumber >+ `mimetype` varchar(15) NOT NULL, -- image type >+ `imagefile` mediumblob NOT NULL, -- image file contents >+ `thumbnail` mediumblob NOT NULL, -- thumbnail file contents > PRIMARY KEY (`imagenumber`), > CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >-- >1.7.9.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 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