[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.3.4 to 1.3.5
   6  #
   7  #####################################################
   8  
   9  
  10  DROP TABLE IF EXISTS `phpwcms_categories` ;
  11  CREATE TABLE `phpwcms_categories` (
  12    `cat_id` int(10) unsigned NOT NULL auto_increment,
  13    `cat_type` varchar(255) NOT NULL default '',
  14    `cat_pid` int(11) NOT NULL default '0',
  15    `cat_status` int(1) NOT NULL default '0',
  16    `cat_createdate` datetime NOT NULL default '0000-00-00 00:00:00',
  17    `cat_changedate` datetime NOT NULL default '0000-00-00 00:00:00',
  18    `cat_name` varchar(255) NOT NULL default '',
  19    `cat_info` text NOT NULL,
  20    PRIMARY KEY  (`cat_id`),
  21    KEY `cat_type` (`cat_type`,`cat_status`),
  22    KEY `cat_pid` (`cat_pid`)
  23  ) TYPE=MyISAM ;