cms.updates.inc

groupoffice

<?php
$updates[16][] = array();

$updates[15][] = "ALTER TABLE `cms_files` ADD `auto_meta` ENUM( '0', '1' ) DEFAULT '1' NOT NULL AFTER `content` ;";
$updates[15][] = "DROP TABLE IF EXISTS `qn_actions`;";
$updates[15][] = "DROP TABLE IF EXISTS `qn_answers`;";
$updates[15][] = "DROP TABLE IF EXISTS `qn_emails`;";
$updates[15][] = "DROP TABLE IF EXISTS `qn_questionnaires`;";
$updates[15][] = "DROP TABLE IF EXISTS `cms_subscribed`;";
$updates[15][] = "DROP TABLE IF EXISTS `cms_search_files`;";
$updates[15][] = "DROP TABLE IF EXISTS `cms_search_words`;";

$updates[14][] = "ALTER TABLE `cms_languages` ADD `language_code` CHAR( 2 ) NOT NULL";
$updates[14][] = "ALTER TABLE `cms_templates` ADD `print_style` TEXT NOT NULL AFTER `additional_style`;";

$updates[13][] = "ALTER TABLE `cms_sites` ADD `allow_properties` ENUM( '0', '1' ) DEFAULT '0' NOT NULL AFTER `acl_read` ";
$updates[13][] = "ALTER TABLE `cms_sites` ADD `multilingual` ENUM( '0', '1' ) NOT NULL AFTER `acl_read`";
$updates[13][] = "ALTER TABLE `cms_sites` ADD `webmaster` VARCHAR( 100 ) NOT NULL AFTER `domain`";
$updates[13][] = "ALTER TABLE `cms_files` CHANGE `name` `name` VARCHAR( 255 ) NOT NULL"; 
$updates[13][] = "ALTER TABLE `cms_folders` CHANGE `name` `name` CHAR( 255 ) NOT NULL";
$updates[13][] = "ALTER TABLE `cms_sites` DROP `display_type`";
$updates[13][] = "ALTER TABLE `cms_folders` CHANGE `disable_multipage` `multipage` ENUM( '0', '1' ) DEFAULT NULL";

$updates[12][] = "ALTER TABLE `cms_templates` DROP `root_folder_id`;";
$updates[12][] = "ALTER TABLE `cms_templates` ADD `activate_frontpage` ENUM( '0', '1' ) NOT NULL AFTER `restrict_editor` ;";
$updates[12][] = "ALTER TABLE `cms_templates` ADD `main_template_item_id` INT NOT NULL AFTER `activate_frontpage` ,
ADD `frontpage_template_item_id` INT NOT NULL AFTER `main_template_item_id` ;";

$updates[11][] = "ALTER TABLE `cms_files` ADD INDEX ( `folder_id` );";

$updates[10][] = "ALTER TABLE `cms_sites` ADD `domain` varchar(100) NOT NULL default '';";
$updates[10][] = "ALTER TABLE `cms_sites` ADD `display_type` ENUM( '0', '1');";
$updates[10][] = "ALTER TABLE `cms_files` ADD `hot_item` ENUM( '0', '1');";
$updates[10][] = "ALTER TABLE `cms_folders` ADD `disable_multipage` ENUM( '0', '1');";
?>