[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  25.08.2004
   6  #
   7  #####################################################
   8  
   9  ALTER TABLE `phpwcms_article` ADD `article_cache` INT( 14 ) NOT NULL ;
  10  ALTER TABLE `phpwcms_article` ADD `article_searchable` INT( 1 ) NOT NULL ;
  11  
  12  CREATE TABLE `phpwcms_cache` (
  13  `cache_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
  14  `cache_hash` VARCHAR( 50 ) NOT NULL ,
  15  `cache_changed` TIMESTAMP NOT NULL ,
  16  `cache_searchable` INT( 1 ) NOT NULL ,
  17  `cache_content` MEDIUMTEXT NOT NULL ,
  18  PRIMARY KEY ( `cache_id` ) ,
  19  INDEX ( `cache_hash` ) 
  20  );
  21  
  22  CREATE TABLE `phpwcms_map` (
  23    `map_id` int(11) NOT NULL auto_increment,
  24    `map_cid` int(11) NOT NULL default '0',
  25    `map_x` int(5) NOT NULL default '0',
  26    `map_y` int(5) NOT NULL default '0',
  27    `map_title` text NOT NULL,
  28    `map_deleted` int(1) NOT NULL default '0',
  29    `map_vars` mediumblob NOT NULL,
  30    PRIMARY KEY  (`map_id`)
  31  ) TYPE=MyISAM AUTO_INCREMENT=1 ;