From b326af914d8c181aa8d24418c819bad9613c31c7 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 --- installer/data/mysql/kohastructure.sql | 16 ++++++++-------- 1 files changed, 8 insertions(+), 8 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 8a8b70f..e45f991 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.2.3