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