Lines 1726-1732
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1726 |
CREATE TABLE IF NOT EXISTS `items_last_borrower` ( |
1726 |
CREATE TABLE IF NOT EXISTS `items_last_borrower` ( |
1727 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1727 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1728 |
`itemnumber` int(11) NOT NULL, |
1728 |
`itemnumber` int(11) NOT NULL, |
1729 |
`borrowernumber` int(11) NOT NULL, |
1729 |
`borrowernumber` int(11) default NULL, |
1730 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
1730 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
1731 |
PRIMARY KEY (`id`), |
1731 |
PRIMARY KEY (`id`), |
1732 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
1732 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
1733 |
- |
|
|