[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.3.0 to 1.3.2
   6  #
   7  #####################################################
   8  
   9  
  10  ALTER TABLE `phpwcms_userdetail` ADD `detail_login` VARCHAR( 255 ) NOT NULL ;
  11  ALTER TABLE `phpwcms_userdetail` ADD `detail_text4` TEXT NOT NULL ;
  12  ALTER TABLE `phpwcms_userdetail` ADD `detail_text5` TEXT NOT NULL ;
  13  ALTER TABLE `phpwcms_userdetail` ADD `userdetail_lastlogin` DATETIME NOT NULL ;
  14  ALTER TABLE `phpwcms_userdetail` ADD UNIQUE (`detail_login`) ; 
  15  ALTER TABLE `phpwcms_userdetail` ADD INDEX ( `detail_aktiv` ) ;
  16  ALTER TABLE `phpwcms_userdetail` ADD INDEX ( `detail_password` ) ;
  17  ALTER TABLE `phpwcms_userdetail` ADD `detail_int1` BIGINT NOT NULL ;
  18  ALTER TABLE `phpwcms_userdetail` ADD `detail_int2` BIGINT NOT NULL ;
  19  ALTER TABLE `phpwcms_userdetail` ADD `detail_int3` BIGINT NOT NULL ;
  20  ALTER TABLE `phpwcms_userdetail` ADD `detail_int4` BIGINT NOT NULL ;
  21  ALTER TABLE `phpwcms_userdetail` ADD `detail_int5` BIGINT NOT NULL ;
  22  ALTER TABLE `phpwcms_userdetail` ADD `detail_float1` FLOAT NOT NULL ;
  23  ALTER TABLE `phpwcms_userdetail` ADD `detail_float2` FLOAT NOT NULL ;
  24  ALTER TABLE `phpwcms_userdetail` ADD `detail_float3` FLOAT NOT NULL ;
  25  ALTER TABLE `phpwcms_userdetail` ADD `detail_float4` FLOAT NOT NULL ;
  26  ALTER TABLE `phpwcms_userdetail` ADD `detail_float5` FLOAT NOT NULL ;
  27  
  28  ALTER TABLE `phpwcms_articlecontent` ADD `acontent_comment` TEXT NOT NULL ;
  29  
  30  CREATE TABLE `phpwcms_crossreference` (
  31    `cref_id` int(11) NOT NULL auto_increment,
  32    `cref_type` int(11) NOT NULL default '0',
  33    `cref_rid` int(11) NOT NULL default '0',
  34    `cref_int` int(11) NOT NULL default '0',
  35    `cref_str` varchar(255) NOT NULL default '',
  36    PRIMARY KEY  (`cref_id`),
  37    KEY `cref_type` (`cref_type`,`cref_rid`,`cref_int`,`cref_str`)
  38  ) TYPE=MyISAM;