[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.2.4-DEV to 1.2.5-DEV
   6  #  2005.30.07
   7  #
   8  #####################################################
   9  
  10  ALTER TABLE `phpwcms_file` ADD `f_refid` INT NOT NULL ;
  11  ALTER TABLE `phpwcms_article` ADD `article_aliasid` INT NOT NULL ;
  12  ALTER TABLE `phpwcms_article` ADD `article_headerdata` INT( 1 ) NOT NULL ;
  13  ALTER TABLE `phpwcms_article` ADD `article_morelink` INT( 1 ) DEFAULT '1' NOT NULL ;
  14  
  15  CREATE TABLE `phpwcms_imgcache` (
  16      `imgcache_id` int(11) NOT NULL auto_increment,
  17      `imgcache_hash` varchar(50) NOT NULL default '',
  18      `imgcache_imgname` varchar(255) NOT NULL default '',
  19      `imgcache_width` int(11) NOT NULL default '0',
  20      `imgcache_height` int(11) NOT NULL default '0',
  21      `imgcache_wh` varchar(255) NOT NULL default '',
  22      `imgcache_timestamp` timestamp(14) NOT NULL,
  23      `imgcache_trash` int(1) NOT NULL default '0',
  24      PRIMARY KEY  (`imgcache_id`),
  25      KEY `imgcache_hash` (`imgcache_hash`)
  26  ) TYPE=MyISAM AUTO_INCREMENT=1 ;