Lines 1685-1691
CREATE TABLE `opac_news` ( -- data from the news tool
Link Here
|
1685 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- pulibcation date and time |
1685 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- pulibcation date and time |
1686 |
`expirationdate` date default NULL, -- date the article is set to expire or no longer be visible |
1686 |
`expirationdate` date default NULL, -- date the article is set to expire or no longer be visible |
1687 |
`number` int(11) default NULL, -- the order in which this article appears in that specific location |
1687 |
`number` int(11) default NULL, -- the order in which this article appears in that specific location |
|
|
1688 |
`borrowernumber` int(11) default NULL, -- The user who created the news article |
1688 |
PRIMARY KEY (`idnew`), |
1689 |
PRIMARY KEY (`idnew`), |
|
|
1690 |
CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
1689 |
CONSTRAINT opac_news_branchcode_ibfk FOREIGN KEY (branchcode) REFERENCES branches (branchcode) |
1691 |
CONSTRAINT opac_news_branchcode_ibfk FOREIGN KEY (branchcode) REFERENCES branches (branchcode) |
1690 |
ON DELETE CASCADE ON UPDATE CASCADE |
1692 |
ON DELETE CASCADE ON UPDATE CASCADE |
1691 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1693 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |