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 |
- |
|
|