Lines 1642-1654
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1642 |
DROP TABLE IF EXISTS `opac_news`; |
1642 |
DROP TABLE IF EXISTS `opac_news`; |
1643 |
CREATE TABLE `opac_news` ( -- data from the news tool |
1643 |
CREATE TABLE `opac_news` ( -- data from the news tool |
1644 |
`idnew` int(10) unsigned NOT NULL auto_increment, -- unique identifier for the news article |
1644 |
`idnew` int(10) unsigned NOT NULL auto_increment, -- unique identifier for the news article |
|
|
1645 |
`branchcode` varchar(10) default NULL, -- branch code users to create branch specific news, NULL is every branch. |
1645 |
`title` varchar(250) NOT NULL default '', -- title of the news article |
1646 |
`title` varchar(250) NOT NULL default '', -- title of the news article |
1646 |
`new` text NOT NULL, -- the body of your news article |
1647 |
`new` text NOT NULL, -- the body of your news article |
1647 |
`lang` varchar(25) NOT NULL default '', -- location for the article (koha is the staff client, slip is the circulation receipt and language codes are for the opac) |
1648 |
`lang` varchar(25) NOT NULL default '', -- location for the article (koha is the staff client, slip is the circulation receipt and language codes are for the opac) |
1648 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- pulibcation date and time |
1649 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- pulibcation date and time |
1649 |
`expirationdate` date default NULL, -- date the article is set to expire or no longer be visible |
1650 |
`expirationdate` date default NULL, -- date the article is set to expire or no longer be visible |
1650 |
`number` int(11) default NULL, -- the order in which this article appears in that specific location |
1651 |
`number` int(11) default NULL, -- the order in which this article appears in that specific location |
1651 |
PRIMARY KEY (`idnew`) |
1652 |
PRIMARY KEY (`idnew`), |
|
|
1653 |
CONSTRAINT opac_news_branchcode_ibfk FOREIGN KEY (branchcode) REFERENCES branches (branchcode) |
1654 |
ON DELETE CASCADE ON UPDATE CASCADE |
1652 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1655 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1653 |
|
1656 |
|
1654 |
-- |
1657 |
-- |