Bugzilla – Attachment 20417 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 borrower_files table
Bug-10703-Document-borrowerfiles-table.patch (text/plain), 2.08 KB, created by
Jonathan Druart
on 2013-08-16 14:39:26 UTC
(
hide
)
Description:
Bug 10703: Document borrower_files table
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2013-08-16 14:39:26 UTC
Size:
2.08 KB
patch
obsolete
>From a770b041410d20b89e18ceafac3da69d108070db Mon Sep 17 00:00:00 2001 >From: "Nicole C. Engard" <nengard@bywatersolutions.com> >Date: Thu, 8 Aug 2013 09:01:23 -0400 >Subject: [PATCH] Bug 10703: Document borrower_files table > >Add db documentation to borrower_files table. > >To test: > >apply >review kohastructure.sql to be sure documentation is there > >Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> >Comment: No errors. Tested loading on new database. > >Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com> >--- > installer/data/mysql/kohastructure.sql | 16 ++++++++-------- > 1 file changed, 8 insertions(+), 8 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index a13a4b2..7628983 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2523,14 +2523,14 @@ CREATE TABLE `message_transports` ( > -- > > DROP TABLE IF EXISTS `borrower_files`; >-CREATE TABLE IF NOT EXISTS `borrower_files` ( >- `file_id` int(11) NOT NULL AUTO_INCREMENT, >- `borrowernumber` int(11) NOT NULL, >- `file_name` varchar(255) NOT NULL, >- `file_type` varchar(255) NOT NULL, >- `file_description` varchar(255) DEFAULT NULL, >- `file_content` longblob NOT NULL, >- `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, >+CREATE TABLE IF NOT EXISTS `borrower_files` ( -- files attached to the patron/borrower record >+ `file_id` int(11) NOT NULL AUTO_INCREMENT, -- unique key >+ `borrowernumber` int(11) NOT NULL, -- foreign key linking to the patron via the borrowernumber >+ `file_name` varchar(255) NOT NULL, -- file name >+ `file_type` varchar(255) NOT NULL, -- type of file >+ `file_description` varchar(255) DEFAULT NULL, -- description given to the file >+ `file_content` longblob NOT NULL, -- the file >+ `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- date and time the file was added > PRIMARY KEY (`file_id`), > KEY `borrowernumber` (`borrowernumber`), > CONSTRAINT borrower_files_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE >-- >1.7.10.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 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