Lines 2519-2524
CREATE TABLE `message_transports` (
Link Here
|
2519 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2519 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2520 |
|
2520 |
|
2521 |
-- |
2521 |
-- |
|
|
2522 |
-- Table structure for table `borrower_files` |
2523 |
-- |
2524 |
|
2525 |
DROP TABLE IF EXISTS `borrower_files`; |
2526 |
CREATE TABLE IF NOT EXISTS `borrower_files` ( |
2527 |
`file_id` int(11) NOT NULL AUTO_INCREMENT, |
2528 |
`borrowernumber` int(11) NOT NULL, |
2529 |
`file_name` varchar(255) NOT NULL, |
2530 |
`file_type` varchar(255) NOT NULL, |
2531 |
`file_description` varchar(255) DEFAULT NULL, |
2532 |
`file_content` longblob NOT NULL, |
2533 |
`date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
2534 |
PRIMARY KEY (`file_id`), |
2535 |
KEY `borrowernumber` (`borrowernumber`) |
2536 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2537 |
|
2538 |
-- |
2522 |
-- Table structure for table `borrower_message_preferences` |
2539 |
-- Table structure for table `borrower_message_preferences` |
2523 |
-- |
2540 |
-- |
2524 |
|
2541 |
|
2525 |
- |
|
|