Lines 3088-3094
DROP TABLE IF EXISTS `items_last_borrower`;
Link Here
|
3088 |
CREATE TABLE `items_last_borrower` ( |
3088 |
CREATE TABLE `items_last_borrower` ( |
3089 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3089 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3090 |
`itemnumber` int(11) NOT NULL, |
3090 |
`itemnumber` int(11) NOT NULL, |
3091 |
`borrowernumber` int(11) NOT NULL, |
3091 |
`borrowernumber` int(11) NULL, |
3092 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
3092 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
3093 |
PRIMARY KEY (`id`), |
3093 |
PRIMARY KEY (`id`), |
3094 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3094 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3095 |
- |
|
|