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