Lines 3079-3085
DROP TABLE IF EXISTS `items_last_borrower`;
Link Here
|
3079 |
CREATE TABLE `items_last_borrower` ( |
3079 |
CREATE TABLE `items_last_borrower` ( |
3080 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3080 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
3081 |
`itemnumber` int(11) NOT NULL, |
3081 |
`itemnumber` int(11) NOT NULL, |
3082 |
`borrowernumber` int(11) NOT NULL, |
3082 |
`borrowernumber` int(11) NULL, |
3083 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
3083 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
3084 |
PRIMARY KEY (`id`), |
3084 |
PRIMARY KEY (`id`), |
3085 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3085 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3086 |
- |
|
|