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