Lines 1681-1687
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1681 |
CREATE TABLE IF NOT EXISTS `items_last_borrower` ( |
1681 |
CREATE TABLE IF NOT EXISTS `items_last_borrower` ( |
1682 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1682 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1683 |
`itemnumber` int(11) NOT NULL, |
1683 |
`itemnumber` int(11) NOT NULL, |
1684 |
`borrowernumber` int(11) NOT NULL, |
1684 |
`borrowernumber` int(11) default NULL, |
1685 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
1685 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
1686 |
PRIMARY KEY (`id`), |
1686 |
PRIMARY KEY (`id`), |
1687 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
1687 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
1688 |
- |
|
|