Lines 3654-3660
DROP TABLE IF EXISTS `items_last_borrower`;
Link Here
|
3654 |
CREATE TABLE `items_last_borrower` ( |
3654 |
CREATE TABLE `items_last_borrower` ( |
3655 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3655 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3656 |
`itemnumber` int(11) NOT NULL, |
3656 |
`itemnumber` int(11) NOT NULL, |
3657 |
`borrowernumber` int(11) NOT NULL, |
3657 |
`borrowernumber` int(11) NULL, |
3658 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
3658 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
3659 |
PRIMARY KEY (`id`), |
3659 |
PRIMARY KEY (`id`), |
3660 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3660 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3661 |
- |
|
|