|
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 |
- |
|
|