From 346e71cabbdbb6d9a1cd54df7bde7ce4eaf1e0d0 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" 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 Comment: No errors. Tested loading on new database. Signed-off-by: Jonathan Druart Signed-off-by: Galen Charlton (cherry picked from commit 09e802c7933073cd98040155b02898ab79739b3a) Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 2ba6d6636b6e6eeab554e6793074899fa40be5c8) Signed-off-by: Bernardo Gonzalez Kriegel (cherry picked from commit 2ba6d6636b6e6eeab554e6793074899fa40be5c8) --- 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 8d490d432c..66385aa108 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2413,14 +2413,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 -- 2.39.5