[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.2.7-DEV to 1.2.8
   6  #
   7  #####################################################
   8  
   9  
  10  ALTER TABLE `phpwcms_articlecat` ADD `acat_pagetitle` VARCHAR( 255 ) NOT NULL ;
  11  ALTER TABLE `phpwcms_articlecat` ADD `acat_paginate` INT( 1 ) DEFAULT '0' NOT NULL ;
  12  ALTER TABLE `phpwcms_article` ADD `article_pagetitle` VARCHAR( 255 ) NOT NULL ;
  13  ALTER TABLE `phpwcms_article` ADD `article_paginate` INT( 1 ) DEFAULT '0' NOT NULL ;
  14  ALTER TABLE `phpwcms_article` ADD `article_serialized` BLOB NOT NULL ;
  15  
  16  ALTER TABLE `phpwcms_keyword` ADD `keyword_updated` TIMESTAMP NOT NULL ;
  17  ALTER TABLE `phpwcms_keyword` ADD `keyword_created` VARCHAR( 14 ) NOT NULL AFTER `keyword_name` ;
  18  ALTER TABLE `phpwcms_keyword` ADD `keyword_description` TEXT NOT NULL ;
  19  ALTER TABLE `phpwcms_keyword` ADD `keyword_link` VARCHAR( 255 ) NOT NULL ;
  20  ALTER TABLE `phpwcms_keyword` ADD `keyword_sort` INT DEFAULT '0' NOT NULL ;
  21  ALTER TABLE `phpwcms_keyword` ADD `keyword_important` INT( 1 ) DEFAULT '0' NOT NULL ;
  22  ALTER TABLE `phpwcms_keyword` ADD `keyword_abbr` CHAR( 10 ) NOT NULL ;
  23  ALTER TABLE `phpwcms_keyword` ADD INDEX ( `keyword_abbr` ) ;
  24  
  25  ALTER TABLE `phpwcms_guestbook` CHANGE `guestbook_useragent` `guestbook_useragent` VARCHAR( 255 ) NOT NULL ;
  26  ALTER TABLE `phpwcms_guestbook` ADD `guestbook_image` VARCHAR( 255 ) NOT NULL ;
  27  ALTER TABLE `phpwcms_guestbook` ADD `guestbook_imagename` VARCHAR( 255 ) NOT NULL ;
  28  ALTER TABLE `phpwcms_articlecontent` ADD `acontent_template` VARCHAR( 255 ) NOT NULL ;
  29  ALTER TABLE `phpwcms_articlecontent` ADD `acontent_spacer` INT( 1 ) DEFAULT '0' NOT NULL ;
  30  
  31  ALTER TABLE `phpwcms_address` CHANGE `address_email` `address_email` TEXT ;
  32  
  33  ALTER TABLE `phpwcms_subscription` ADD `subscription_active` INT( 1 ) DEFAULT '0' NOT NULL ;
  34  ALTER TABLE `phpwcms_subscription` ADD `subscription_lang` VARCHAR( 100 ) NOT NULL ;
  35  ALTER TABLE `phpwcms_subscription` ADD `subscription_tstamp` TIMESTAMP NOT NULL ;
  36  UPDATE `phpwcms_subscription` SET `subscription_active` = 1 ; 
  37  
  38  ALTER TABLE `phpwcms_newsletter` ADD `newsletter_created` TIMESTAMP NOT NULL ;
  39  ALTER TABLE `phpwcms_newsletter` ADD `newsletter_lastsending` TIMESTAMP NOT NULL ;
  40  ALTER TABLE `phpwcms_newsletter` ADD `newsletter_active` INT( 1 ) DEFAULT '0' NOT NULL ;
  41  
  42  ALTER TABLE `phpwcms_address` ADD `address_iddetail` INT( 11 ) DEFAULT '0' NOT NULL ;
  43  ALTER TABLE `phpwcms_address` ADD `address_url1` VARCHAR( 255 ) NOT NULL ;
  44  ALTER TABLE `phpwcms_address` ADD `address_url2` VARCHAR( 255 ) NOT NULL ;
  45  
  46  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_newsletter` `detail_newsletter` INT( 11 ) NOT NULL DEFAULT '0' ;
  47  
  48  
  49  ALTER TABLE `phpwcms_userdetail` ADD `detail_website` VARCHAR( 255 ) NOT NULL ;
  50  ALTER TABLE `phpwcms_userdetail` ADD `detail_userimage` VARCHAR( 255 ) NOT NULL ;
  51  ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar1` VARCHAR( 255 ) NOT NULL ;
  52  ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar2` VARCHAR( 255 ) NOT NULL ;
  53  ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar3` VARCHAR( 255 ) NOT NULL ;
  54  ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar4` VARCHAR( 255 ) NOT NULL ;
  55  ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar5` VARCHAR( 255 ) NOT NULL ;
  56  ALTER TABLE `phpwcms_userdetail` ADD `detail_text1` TEXT NOT NULL ;
  57  ALTER TABLE `phpwcms_userdetail` ADD `detail_text2` TEXT NOT NULL ;
  58  ALTER TABLE `phpwcms_userdetail` ADD `detail_text3` TEXT NOT NULL ;
  59  ALTER TABLE `phpwcms_userdetail` ADD `detail_formid` INT( 11 ) NOT NULL DEFAULT '0' AFTER `detail_pid` ;
  60  ALTER TABLE `phpwcms_userdetail` ADD `detail_gender` VARCHAR( 255 ) NOT NULL AFTER `detail_userimage` ;
  61  ALTER TABLE `phpwcms_userdetail` ADD `detail_birthday` DATE NOT NULL AFTER `detail_gender` ;
  62  ALTER TABLE `phpwcms_userdetail` ADD `detail_email` VARCHAR( 255 ) NOT NULL ;
  63  ALTER TABLE `phpwcms_userdetail` ADD `detail_password` VARCHAR( 255 ) NOT NULL ;
  64  
  65  ALTER TABLE `phpwcms_userdetail` ADD INDEX ( `detail_formid` ) ;
  66  ALTER TABLE `phpwcms_userdetail` ADD INDEX ( `detail_pid` ) ;
  67  
  68  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_title` `detail_title` VARCHAR( 255 ) NOT NULL ; 
  69  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_firstname` `detail_firstname` VARCHAR( 255 ) NOT NULL ; 
  70  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_lastname` `detail_lastname` VARCHAR( 255 ) NOT NULL ; 
  71  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_company` `detail_company` VARCHAR( 255 ) NOT NULL ; 
  72  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_street` `detail_street` VARCHAR( 255 ) NOT NULL ; 
  73  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_add` `detail_add` VARCHAR( 255 ) NOT NULL ; 
  74  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_city` `detail_city` VARCHAR( 255 ) NOT NULL ; 
  75  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_zip` `detail_zip` VARCHAR( 255 ) NOT NULL ; 
  76  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_region` `detail_region` VARCHAR( 255 ) NOT NULL ; 
  77  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_country` `detail_country` VARCHAR( 255 ) NOT NULL ; 
  78  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_fon` `detail_fon` VARCHAR( 255 ) NOT NULL ; 
  79  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_fax` `detail_fax` VARCHAR( 255 ) NOT NULL ; 
  80  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_mobile` `detail_mobile` VARCHAR( 255 ) NOT NULL ; 
  81  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_fax` `detail_fax` VARCHAR( 255 ) NOT NULL ; 
  82  ALTER TABLE `phpwcms_userdetail` CHANGE `detail_prof` `detail_prof` VARCHAR( 255 ) NOT NULL ; 
  83  
  84  ALTER TABLE `phpwcms_template` ADD `template_type` INT( 11 ) NOT NULL DEFAULT '0' AFTER `template_id` ;
  85  
  86  ALTER TABLE `phpwcms_articlecontent` ADD `acontent_tid` INT( 11 ) DEFAULT '0' NOT NULL ;
  87  ALTER TABLE `phpwcms_articlecontent` ADD `acontent_livedate` DATETIME NOT NULL ;
  88  ALTER TABLE `phpwcms_articlecontent` ADD `acontent_killdate` DATETIME NOT NULL;
  89  ALTER TABLE `phpwcms_articlecontent` ADD INDEX ( `acontent_livedate` , `acontent_killdate` ) ;
  90  ALTER TABLE `phpwcms_articlecontent` ADD `acontent_created` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `acontent_uid` ;
  91  
  92  
  93  DROP TABLE `phpwcms_results` ;
  94  DROP TABLE `phpwcms_resultscat` ;
  95  DROP TABLE `phpwcms_schedule` ;
  96  DROP TABLE `phpwcms_schedulecat` ;
  97  
  98  CREATE TABLE `phpwcms_formresult` (
  99    `formresult_id` int(11) NOT NULL auto_increment,
 100    `formresult_pid` int(11) NOT NULL default '0',
 101    `formresult_createdate` timestamp NULL,
 102    `formresult_ip` varchar(50) NOT NULL default '',
 103    `formresult_content` mediumblob NOT NULL,
 104    PRIMARY KEY  (`formresult_id`),
 105    KEY `formresult_pid` (`formresult_pid`)
 106  ) TYPE=MyISAM;
 107  
 108  CREATE TABLE `phpwcms_newsletterqueue` (
 109    `queue_id` int(11) NOT NULL auto_increment,
 110    `queue_created` timestamp NOT NULL,
 111    `queue_changed` timestamp NOT NULL,
 112    `queue_status` int(11) NOT NULL default '0',
 113    `queue_pid` int(11) NOT NULL default '0',
 114    `queue_rid` int(11) NOT NULL default '0',
 115    `queue_errormsg` varchar(255) NOT NULL default '',
 116    PRIMARY KEY  (`queue_id`)
 117  ) ENGINE=MyISAM;