View | Details | Raw Unified | Return to bug 10703
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-9 / +8 lines)
Lines 2523-2536 CREATE TABLE `message_transports` ( Link Here
2523
--
2523
--
2524
2524
2525
DROP TABLE IF EXISTS `borrower_files`;
2525
DROP TABLE IF EXISTS `borrower_files`;
2526
CREATE TABLE IF NOT EXISTS `borrower_files` (
2526
CREATE TABLE IF NOT EXISTS `borrower_files` ( -- files attached to the patron/borrower record
2527
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
2527
  `file_id` int(11) NOT NULL AUTO_INCREMENT, -- unique key
2528
  `borrowernumber` int(11) NOT NULL,
2528
  `borrowernumber` int(11) NOT NULL, -- foreign key linking to the patron via the borrowernumber
2529
  `file_name` varchar(255) NOT NULL,
2529
  `file_name` varchar(255) NOT NULL, -- file name
2530
  `file_type` varchar(255) NOT NULL,
2530
  `file_type` varchar(255) NOT NULL, -- type of file
2531
  `file_description` varchar(255) DEFAULT NULL,
2531
  `file_description` varchar(255) DEFAULT NULL, -- description given to the file
2532
  `file_content` longblob NOT NULL,
2532
  `file_content` longblob NOT NULL, -- the file
2533
  `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2533
  `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- date and time the file was added
2534
  PRIMARY KEY (`file_id`),
2534
  PRIMARY KEY (`file_id`),
2535
  KEY `borrowernumber` (`borrowernumber`),
2535
  KEY `borrowernumber` (`borrowernumber`),
2536
  CONSTRAINT borrower_files_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
2536
  CONSTRAINT borrower_files_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
2537
- 

Return to bug 10703