[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.2.6-DEV to 1.2.7
   6  #
   7  #####################################################
   8  
   9  
  10  CREATE TABLE `phpwcms_formtracking` (
  11    `formtracking_id` INT NOT NULL AUTO_INCREMENT,
  12    `formtracking_hash` VARCHAR( 50 ) NOT NULL default '',
  13    `formtracking_ip` VARCHAR( 20 ) NOT NULL default '',
  14    `formtracking_created` TIMESTAMP(14) NOT NULL,
  15    `formtracking_sentdate` VARCHAR( 20 ) NOT NULL default '',
  16    `formtracking_sent` INT( 1 ) NOT NULL DEFAULT '0',
  17    PRIMARY KEY  (`formtracking_id`)
  18  ) TYPE=MyISAM;
  19  
  20  ALTER TABLE `phpwcms_articlecat` ADD `acat_maxlist` INT( 11 ) NOT NULL DEFAULT '0';
  21  ALTER TABLE `phpwcms_articlecat` ADD `acat_cntpart` VARCHAR( 255 ) NOT NULL ;