[Summary view] [Print] [Text view]

   1  #
   2  # PHPWCMS database update script
   3  # ==============================
   4  # 19-04-2004
   5  
   6  # added new field for different kind of article listing
   7  ALTER TABLE `phpwcms_articlecat` ADD `acat_topcount` INT NOT NULL ;
   8  
   9  #
  10  # guestbook table `phpwcms_guestbook`
  11  #
  12  
  13  CREATE TABLE `phpwcms_guestbook` (
  14    `guestbook_id` int(11) NOT NULL auto_increment,
  15    `guestbook_cid` int(11) NOT NULL default '0',
  16    `guestbook_msg` text NOT NULL,
  17    `guestbook_name` varchar(255) NOT NULL default '',
  18    `guestbook_email` varchar(255) NOT NULL default '',
  19    `guestbook_created` varchar(14) NOT NULL default '',
  20    `guestbook_trashed` int(1) NOT NULL default '0',
  21    `guestbook_url` varchar(255) NOT NULL default '',
  22    PRIMARY KEY  (`guestbook_id`)
  23  ) TYPE=MyISAM AUTO_INCREMENT=1 ;
  24  
  25  DROP TABLE IF EXISTS `phpwcms_newsletter`;
  26  
  27  CREATE TABLE `phpwcms_newsletter` (
  28    `newsletter_id` int(11) NOT NULL auto_increment,
  29    `newsletter_subject` text NOT NULL,
  30    `newsletter_changed` timestamp(14) NOT NULL,
  31    `newsletter_vars` mediumblob NOT NULL,
  32    `newsletter_trashed` int(1) NOT NULL default '0',
  33    PRIMARY KEY  (`newsletter_id`)
  34  ) TYPE=MyISAM AUTO_INCREMENT=1 ;
  35  
  36  
  37  # 24-03-2004
  38  
  39  # change or add field definitions
  40  
  41  ALTER TABLE `phpwcms_articlecat` ADD `acat_ssl` INT( 1 ) NOT NULL ;
  42  
  43  ALTER TABLE `phpwcms_articlecat` ADD `acat_regonly` INT( 1 ) NOT NULL ;
  44  
  45  ALTER TABLE `phpwcms_articlecat` CHANGE `acat_name` `acat_name` VARCHAR( 255 ) NOT NULL ;
  46  
  47  ALTER TABLE `phpwcms_article` ADD `article_notitle` INT( 1 ) NOT NULL ;
  48  
  49  ALTER TABLE `phpwcms_user` CHANGE `usr_pass` `usr_pass` VARCHAR( 255 ) NOT NULL ;
  50  
  51  # new for storing UTF-8 datas = many chars
  52  # article
  53  ALTER TABLE `phpwcms_article` CHANGE `article_subtitle` `article_subtitle` TEXT NOT NULL;
  54  ALTER TABLE `phpwcms_article` CHANGE `article_title` `article_title` TEXT NOT NULL;
  55  ALTER TABLE `phpwcms_article` CHANGE `article_keyword` `article_keyword` TEXT NOT NULL;
  56  ALTER TABLE `phpwcms_article` CHANGE `article_summary` `article_summary` TEXT NOT NULL;
  57  ALTER TABLE `phpwcms_article` CHANGE `article_redirect` `article_redirect` TEXT NOT NULL;
  58  
  59  # article content
  60  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_title` `acontent_title` TEXT NOT NULL;
  61  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_text` `acontent_text` TEXT NOT NULL;
  62  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_alink` `acontent_alink` TEXT NOT NULL;
  63  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_html` `acontent_html` TEXT NOT NULL;
  64  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_image` `acontent_image` TEXT NOT NULL;
  65  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_files` `acontent_files` TEXT NOT NULL;
  66  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_subtitle` `acontent_subtitle` TEXT NOT NULL;
  67  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_redirect` `acontent_redirect` TEXT NOT NULL;
  68  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_media` `acontent_media` TEXT NOT NULL;
  69  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_form` `acontent_form` MEDIUMTEXT NOT NULL;
  70  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_newsletter` `acontent_newsletter` MEDIUMTEXT NOT NULL;
  71  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_before` `acontent_before` VARCHAR( 10 ) NOT NULL;
  72  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_after` `acontent_after` VARCHAR( 10 ) NOT NULL;
  73  ALTER TABLE `phpwcms_articlecontent` CHANGE `acontent_type` `acontent_type` INT( 10 ) DEFAULT '0' NOT NULL;
  74  
  75  # article category (structure)
  76  ALTER TABLE `phpwcms_articlecat` CHANGE `acat_name` `acat_name` TEXT NOT NULL;
  77  ALTER TABLE `phpwcms_articlecat` CHANGE `acat_info` `acat_info` TEXT NOT NULL;
  78  ALTER TABLE `phpwcms_articlecat` CHANGE `acat_alias` `acat_alias` TEXT NOT NULL;
  79  
  80  # subscription
  81  ALTER TABLE `phpwcms_subscription` CHANGE `subscription_name` `subscription_name` TEXT NOT NULL;
  82  
  83  # newsletter
  84  ALTER TABLE `phpwcms_newsletter` CHANGE `newsletter_name` `newsletter_name` TEXT NOT NULL;
  85  ALTER TABLE `phpwcms_newsletter` CHANGE `newsletter_subject` `newsletter_subject` TEXT NOT NULL;
  86  
  87  # addresses
  88  ALTER TABLE `phpwcms_address` CHANGE `address_name` `address_name` TEXT NOT NULL;
  89  
  90  # blog
  91  CREATE TABLE `phpwcms_blog` (
  92    `blog_id` int(11) NOT NULL auto_increment,
  93    `blog_cid` int(11) NOT NULL default '0',
  94    `blog_created` varchar(14) NOT NULL default '',
  95    `blog_changed` varchar(14) NOT NULL default '',
  96    `blog_editor` varchar(255) NOT NULL default '',
  97    `blog_var` mediumtext NOT NULL,
  98    `blog_active` int(1) NOT NULL default '0',
  99    `blog_trashed` int(1) NOT NULL default '0',
 100    PRIMARY KEY  (`blog_id`)
 101  ) TYPE=MyISAM AUTO_INCREMENT=1 ;