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