Lines 3730-3736
DROP TABLE IF EXISTS `items_last_borrower`;
Link Here
|
3730 |
CREATE TABLE `items_last_borrower` ( |
3730 |
CREATE TABLE `items_last_borrower` ( |
3731 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3731 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3732 |
`itemnumber` int(11) NOT NULL, |
3732 |
`itemnumber` int(11) NOT NULL, |
3733 |
`borrowernumber` int(11) NOT NULL, |
3733 |
`borrowernumber` int(11) NULL, |
3734 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
3734 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
3735 |
PRIMARY KEY (`id`), |
3735 |
PRIMARY KEY (`id`), |
3736 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3736 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3737 |
- |
|
|