Tribiq CMS

Choose your language

Database Changelog

5.0.2 to 5.0.3

Database Changes

# Add Newsletter Archive Support

CREATE TABLE `tribalcms_content_nlar_tmp` ( `id` int(10) unsigned NOT NULL default '0', `version` int(10) unsigned NOT NULL default '1', `title` varchar(250) NOT NULL default '', `private` tinyint(1) NOT NULL default '0', `language_id` varchar(5) NOT NULL default 'en', `status` enum('private_draft','reviewable_draft','published','hidden','archived') default 'private_draft', `draft_exists` enum('0','1') NOT NULL default '0', `created_datetime` datetime default NULL, `owner_id` int(10) unsigned NOT NULL default '0', `owner_authtype` enum('local','super') default NULL, `creating_author_id` int(10) unsigned NOT NULL default '0', `creating_author_authtype` enum('local','super') default NULL, `allow_local_coauthor_id` int(10) unsigned NOT NULL default '0', `last_author_id` int(10) unsigned NOT NULL default '0', `last_author_authtype` enum('local','super') default NULL, `publisher_id` int(10) unsigned NOT NULL default '0', `publisher_authtype` enum('local','super') default NULL, `published_datetime` datetime default NULL, `hider_id` int(10) unsigned NOT NULL default '0', `hider_authtype` enum('local','super') default NULL, `hidden_datetime` datetime default NULL, `archiver_id` int(10) unsigned NOT NULL default '0', `archiver_authtype` enum('local','super') default NULL, `archived_datetime` datetime default NULL, `expiry_datetime` datetime default NULL, `expiry_action` enum('delete','hide','alert') default NULL, `folder_id` int(10) unsigned NOT NULL default '0', `description` text, `keywords` text, `template_id` int(10) unsigned NOT NULL default '0', `content_head` text, `content_bodytop` mediumtext, `content_bodymain` mediumtext, `content_bodyfoot` mediumtext, `spare_varchar1` varchar(250) NOT NULL default '', `spare_varchar2` varchar(250) NOT NULL default '', `new_menu_text` varchar(250) NOT NULL default '', `publication_date` date default NULL, `seo_sitemap_changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never') default NULL, `seo_sitemap_priority` float(3,1) default NULL, `sendto_groups` text NOT NULL, `sendto_status` set('pending','active','suspended') default NULL, `sendto_planid` int(10) default NULL, `sendto_subscrip_start` datetime default NULL, `sendto_subscrip_end` datetime default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `tribalcms_content_nlar` ( `id` int(10) unsigned NOT NULL default '0', `version` int(10) unsigned NOT NULL default '1', `title` varchar(250) NOT NULL default '', `private` tinyint(1) NOT NULL default '0', `language_id` varchar(5) NOT NULL default 'en', `status` enum('private_draft','reviewable_draft','published','hidden','archived') default 'private_draft', `draft_exists` enum('0','1') NOT NULL default '0', `created_datetime` datetime default NULL, `owner_id` int(10) unsigned NOT NULL default '0', `owner_authtype` enum('local','super') default NULL, `creating_author_id` int(10) unsigned NOT NULL default '0', `creating_author_authtype` enum('local','super') default NULL, `allow_local_coauthor_id` int(10) unsigned NOT NULL default '0', `last_author_id` int(10) unsigned NOT NULL default '0', `last_author_authtype` enum('local','super') default NULL, `publisher_id` int(10) unsigned NOT NULL default '0', `publisher_authtype` enum('local','super') default NULL, `published_datetime` datetime default NULL, `hider_id` int(10) unsigned NOT NULL default '0', `hider_authtype` enum('local','super') default NULL, `hidden_datetime` datetime default NULL, `archiver_id` int(10) unsigned NOT NULL default '0', `archiver_authtype` enum('local','super') default NULL, `archived_datetime` datetime default NULL, `expiry_datetime` datetime default NULL, `expiry_action` enum('delete','hide','alert') default NULL, `folder_id` int(10) unsigned NOT NULL default '0', `description` text, `keywords` text, `template_id` int(10) unsigned NOT NULL default '0', `content_head` text, `content_bodytop` mediumtext, `content_bodymain` mediumtext, `content_bodyfoot` mediumtext, `spare_varchar1` varchar(250) NOT NULL default '', `spare_varchar2` varchar(250) NOT NULL default '', `new_menu_text` varchar(250) NOT NULL default '', `publication_date` date default NULL, `seo_sitemap_changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never') default NULL, `seo_sitemap_priority` float(3,1) default NULL, `sendto_groups` text NOT NULL, `sendto_status` set('pending','active','suspended') default NULL, `sendto_planid` int(10) default NULL, `sendto_subscrip_start` datetime default NULL, `sendto_subscrip_end` datetime default NULL, PRIMARY KEY (`id`,`version`), KEY `folder_id` (`folder_id`), KEY `date_value` (`publication_date`), KEY `version` (`version`), FULLTEXT KEY `title` (`title`), FULLTEXT KEY `keywords` (`keywords`), FULLTEXT KEY `description` (`description`), FULLTEXT KEY `content_bodytop` (`content_bodytop`), FULLTEXT KEY `content_bodymain` (`content_bodymain`), FULLTEXT KEY `content_bodyfoot` (`content_bodyfoot`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#Add NLAR ContentType to ContentTypes table

alter table tribalcms_contenttypes add disallow_normal_creation
tinyint(1) not null default '0';

INSERT INTO `tribalcms_contenttypes`

VALUES ('nlar', 'Newsletter', 'NLAR', '0', '0', '1', '1', '1', '0', '1');

 

# Add Subscription Support

CREATE TABLE `tribalcms_subscription_plans` ( `id` int(10) unsigned NOT NULL auto_increment, `description` varchar(255) default NULL, `duration` int(10) unsigned NOT NULL default '1', `duration_unit` enum('YEAR','MONTH','DAY','HOUR') default NULL, `group_id` int(10) unsigned default NULL, `after_end_action` enum('remove_from_group','suspend_user','delete_user') default NULL, PRIMARY KEY (`id`), FULLTEXT KEY `description` (`description`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `tribalcms_user_subscriptions` ( `id` int(10) unsigned NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL default '0', `plan_id` int(10) unsigned default '0', `adhoc_description` varchar(255) default NULL, `start` datetime default NULL, `end` datetime default NULL, `duration` int(10) unsigned NOT NULL default '1', `duration_unit` enum('YEAR','MONTH','DAY','HOUR') default NULL, `confirm_date` datetime default NULL, `status` enum('pending','active','expired','cancelled') NOT NULL default 'pending', PRIMARY KEY (`id`), KEY `user_id` (`user_id`), FULLTEXT KEY `adhoc_description` (`adhoc_description`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; ALTER TABLE `tribalcms_users` ADD `first_subscrip_id` int(10) unsigned NOT NULL default '0' AFTER `suspended_date`, ADD `first_subscrip_start` datetime default NULL AFTER `first_subscrip_id`, ADD `first_subscrip_end` datetime default NULL AFTER `first_subscrip_start`;

# Remove redundant column

ALTER TABLE `tribalcms_users` DROP `suspend_date`;

# Localization Additions

ALTER TABLE `tribalcms_admin_phrases` CHANGE `pt-PT` `pt-EU` text NOT NULL; ALTER TABLE `tribalcms_admin_phrases` ADD `ru` text NOT NULL AFTER `pt-EU`;

# Support for thumbnail images

ALTER TABLE `tribalcms_images`

ADD `thumbnail_width` SMALLINT( 5 ) UNSIGNED NULL
AFTER `checksum` ,

ADD `thumbnail_height` SMALLINT( 5 ) UNSIGNED NULL
AFTER `thumbnail_width` ,

ADD `thumbnail_data` MEDIUMBLOB NULL
AFTER `thumbnail_height` ,

ADD `thumbnail_size` INT( 10 ) UNSIGNED NULL
AFTER `thumbnail_data` ,

ADD `sticky_flag` TINYINT( 1 ) NOT NULL
AFTER `thumbnail_size` ;

# Support for phrase comments

ALTER TABLE `tribalcms_admin_phrases`
ADD `comment` TEXT NOT NULL AFTER `code` ;

# Support for cached menus

CREATE TABLE `tribalcms_menu_cache` (`cache` mediumtext NOT NULL);

# Parameters

CREATE TABLE `tribalcms_param_keys` (

`content_type` varchar(20) NOT NULL default '', `param_key_name` varchar(20) NOT NULL default '', `ordinal` int(10) unsigned NOT NULL default '0', `form_label` text NOT NULL, PRIMARY KEY (`content_type`,`param_key_name`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# Keyword caching

CREATE TABLE `tribalcms_keyword_cache` ( `keyword` varchar(250) NOT NULL default '', `content_id` int(10) unsigned NOT NULL default '0', `content_type` varchar(20) NOT NULL default '', PRIMARY KEY (`keyword`,`content_id`,`content_type`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# News content type

CREATE TABLE `tribalcms_content_news` ( `id` int(10) unsigned NOT NULL default '0', `version` int(10) unsigned NOT NULL default '1', `title` varchar(250) NOT NULL default '', `private` tinyint(1) NOT NULL default '0', `language_id` varchar(5) NOT NULL default 'en', `status` enum('private_draft','reviewable_draft','published','hidden','archived') default 'private_draft', `draft_exists` enum('0','1') NOT NULL default '0', `created_datetime` datetime default NULL, `owner_id` int(10) unsigned NOT NULL default '0', `owner_authtype` enum('local','super') default NULL, `creating_author_id` int(10) unsigned NOT NULL default '0', `creating_author_authtype` enum('local','super') default NULL, `allow_local_coauthor_id` int(10) unsigned NOT NULL default '0', `last_author_id` int(10) unsigned NOT NULL default '0', `last_author_authtype` enum('local','super') default NULL, `publisher_id` int(10) unsigned NOT NULL default '0', `publisher_authtype` enum('local','super') default NULL, `published_datetime` datetime default NULL, `hider_id` int(10) unsigned NOT NULL default '0', `hider_authtype` enum('local','super') default NULL, `hidden_datetime` datetime default NULL, `archiver_id` int(10) unsigned NOT NULL default '0', `archiver_authtype` enum('local','super') default NULL, `archived_datetime` datetime default NULL, `expiry_datetime` datetime default NULL, `expiry_action` enum('delete','hide','alert') default NULL, `folder_id` int(10) unsigned NOT NULL default '0', `description` text, `keywords` text, `template_id` int(10) unsigned NOT NULL default '0', `content_head` text NOT NULL, `content_bodytop` mediumtext, `content_bodymain` mediumtext, `content_bodyfoot` mediumtext, `spare_varchar1` varchar(250) NOT NULL default '', `spare_varchar2` varchar(250) NOT NULL default '', `new_menu_text` varchar(250) NOT NULL default '', `publication_date` date default NULL, `seo_sitemap_changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never') default NULL, `seo_sitemap_priority` float(3,1) default NULL, PRIMARY KEY (`id`,`version`), KEY `folder_id` (`folder_id`), KEY `date_value` (`publication_date`), KEY `version` (`version`), FULLTEXT KEY `title` (`title`), FULLTEXT KEY `keywords` (`keywords`), FULLTEXT KEY `description` (`description`), FULLTEXT KEY `content_bodytop` (`content_bodytop`), FULLTEXT KEY `content_bodymain` (`content_bodymain`), FULLTEXT KEY `content_bodyfoot` (`content_bodyfoot`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `tribalcms_content_news_tmp` ( `id` int(10) unsigned NOT NULL default '0', `version` int(10) unsigned NOT NULL default '1', `title` varchar(250) NOT NULL default '', `private` tinyint(1) NOT NULL default '0', `language_id` varchar(5) NOT NULL default 'en', `status` enum('private_draft','reviewable_draft','published','hidden','archived') default 'private_draft', `draft_exists` enum('0','1') NOT NULL default '0', `created_datetime` datetime default NULL, `owner_id` int(10) unsigned NOT NULL default '0', `owner_authtype` enum('local','super') default NULL, `creating_author_id` int(10) unsigned NOT NULL default '0', `creating_author_authtype` enum('local','super') default NULL, `allow_local_coauthor_id` int(10) unsigned NOT NULL default '0', `last_author_id` int(10) unsigned NOT NULL default '0', `last_author_authtype` enum('local','super') default NULL, `publisher_id` int(10) unsigned NOT NULL default '0', `publisher_authtype` enum('local','super') default NULL, `published_datetime` datetime default NULL, `hider_id` int(10) unsigned NOT NULL default '0', `hider_authtype` enum('local','super') default NULL, `hidden_datetime` datetime default NULL, `archiver_id` int(10) unsigned NOT NULL default '0', `archiver_authtype` enum('local','super') default NULL, `archived_datetime` datetime default NULL, `expiry_datetime` datetime default NULL, `expiry_action` enum('delete','hide','alert') default NULL, `folder_id` int(10) unsigned NOT NULL default '0', `description` text, `keywords` text, `template_id` int(10) unsigned NOT NULL default '0', `content_head` text NOT NULL, `content_bodytop` mediumtext, `content_bodymain` mediumtext, `content_bodyfoot` mediumtext, `spare_varchar1` varchar(250) NOT NULL default '', `spare_varchar2` varchar(250) NOT NULL default '', `new_menu_text` varchar(250) NOT NULL default '', `publication_date` date default NULL, `seo_sitemap_changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never') default NULL, `seo_sitemap_priority` float(3,1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

# Extranet is now a content type

 

CREATE TABLE `tribalcms_content_extranet` (

`id` int(10) unsigned NOT NULL default '0',

`version` int(10) unsigned NOT NULL default '1',

`title` varchar(250) NOT NULL default '',

`private` tinyint(1) NOT NULL default '0',

`language_id` varchar(5) NOT NULL default 'en',

`status` enum('private_draft','reviewable_draft','published','hidden','archived') default 'private_draft',

`draft_exists` enum('0','1') NOT NULL default '0',

`created_datetime` datetime default NULL,

`owner_id` int(10) unsigned NOT NULL default '0',

`owner_authtype` enum('local','super') default NULL,

`creating_author_id` int(10) unsigned NOT NULL default '0',

`creating_author_authtype` enum('local','super') default NULL,

`allow_local_coauthor_id` int(10) unsigned NOT NULL default '0',

`last_author_id` int(10) unsigned NOT NULL default '0',

`last_author_authtype` enum('local','super') default NULL,

`publisher_id` int(10) unsigned NOT NULL default '0',

`publisher_authtype` enum('local','super') default NULL,

`published_datetime` datetime default NULL,

`hider_id` int(10) unsigned NOT NULL default '0',

`hider_authtype` enum('local','super') default NULL,

`hidden_datetime` datetime default NULL,

`archiver_id` int(10) unsigned NOT NULL default '0',

`archiver_authtype` enum('local','super') default NULL,

`archived_datetime` datetime default NULL,

`expiry_datetime` datetime default NULL,

`expiry_action` enum('delete','hide','alert') default NULL,

`folder_id` int(10) unsigned NOT NULL default '0',

`description` text,

`keywords` text,

`template_id` int(10) unsigned NOT NULL default '0',

`content_head` text,

`content_bodytop` mediumtext,

`content_bodymain` mediumtext,

`content_bodyfoot` mediumtext,

`signup_model_id` int(11) unsigned NOT NULL default '0',

`spare_varchar1` varchar(250) NOT NULL default '',

`spare_varchar2` varchar(250) NOT NULL default '',

`new_menu_text` varchar(250) NOT NULL default '',

`publication_date` date default NULL,

`seo_sitemap_changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never') default NULL,

`seo_sitemap_priority` float(3,1) default NULL,

PRIMARY KEY (`id`,`version`),

KEY `folder_id` (`folder_id`),

KEY `date_value` (`publication_date`),

KEY `version` (`version`),

FULLTEXT KEY `title` (`title`),

FULLTEXT KEY `keywords` (`keywords`),

FULLTEXT KEY `description` (`description`),

FULLTEXT KEY `content_bodytop` (`content_bodytop`),

FULLTEXT KEY `content_bodymain` (`content_bodymain`),

FULLTEXT KEY `content_bodyfoot` (`content_bodyfoot`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

CREATE TABLE `tribalcms_content_extranet_tmp` (

`id` int(10) unsigned NOT NULL default '0',

`version` int(10) unsigned NOT NULL default '1',

`title` varchar(250) NOT NULL default '',

`private` tinyint(1) NOT NULL default '0',

`language_id` varchar(5) NOT NULL default 'en',

`status` enum('private_draft','reviewable_draft','published','hidden','archived') default 'private_draft',

`draft_exists` enum('0','1') NOT NULL default '0',

`created_datetime` datetime default NULL,

`owner_id` int(10) unsigned NOT NULL default '0',

`owner_authtype` enum('local','super') default NULL,

`creating_author_id` int(10) unsigned NOT NULL default '0',

`creating_author_authtype` enum('local','super') default NULL,

`allow_local_coauthor_id` int(10) unsigned NOT NULL default '0',

`last_author_id` int(10) unsigned NOT NULL default '0',

`last_author_authtype` enum('local','super') default NULL,

`publisher_id` int(10) unsigned NOT NULL default '0',

`publisher_authtype` enum('local','super') default NULL,

`published_datetime` datetime default NULL,

`hider_id` int(10) unsigned NOT NULL default '0',

`hider_authtype` enum('local','super') default NULL,

`hidden_datetime` datetime default NULL,

`archiver_id` int(10) unsigned NOT NULL default '0',

`archiver_authtype` enum('local','super') default NULL,

`archived_datetime` datetime default NULL,

`expiry_datetime` datetime default NULL,

`expiry_action` enum('delete','hide','alert') default NULL,

`folder_id` int(10) unsigned NOT NULL default '0',

`description` text,

`keywords` text,

`template_id` int(10) unsigned NOT NULL default '0',

`content_head` text,

`content_bodytop` mediumtext,

`content_bodymain` mediumtext,

`content_bodyfoot` mediumtext,

`signup_model_id` int(11) unsigned NOT NULL default '0',

`spare_varchar1` varchar(250) NOT NULL default '',

`spare_varchar2` varchar(250) NOT NULL default '',

`new_menu_text` varchar(250) NOT NULL default '',

`publication_date` date default NULL,

`seo_sitemap_changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never') default NULL,

`seo_sitemap_priority` float(3,1) default NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

ALTER TABLE tribalcms_enet_user_val

MODIFY COLUMN `signup_model_id` int(11) unsigned NOT NULL auto_increment PRIMARY KEY;

ALTER TABLE tribalcms_enet_user_val

ADD COLUMN `name` varchar(255) NOT NULL default '' UNIQUE AFTER signup_model_id;

# Further Strict_Trans_Tables tidy-up

ALTER TABLE `tribalcms_admin_notes` MODIFY COLUMN `content_body` text; ALTER TABLE `tribalcms_content_document` MODIFY COLUMN `content_head` text; ALTER TABLE `tribalcms_content_document` ADD PRIMARY KEY (`id`,`version`), ADD KEY `folder_id` (`folder_id`), ADD KEY `publication_date` (`publication_date`), ADD KEY `version` (`version`), ADD FULLTEXT KEY `title` (`title`), ADD FULLTEXT KEY `keywords` (`keywords`), ADD FULLTEXT KEY `description` (`description`), ADD FULLTEXT KEY `content_bodytop` (`content_bodytop`), ADD FULLTEXT KEY `content_bodymain` (`content_bodymain`), ADD FULLTEXT KEY `content_bodyfoot` (`content_bodyfoot`), ADD FULLTEXT KEY `document_text` (`document_text`); ALTER TABLE `tribalcms_content_document_tmp` MODIFY COLUMN `content_head` text, MODIFY COLUMN `content_bodytop` mediumtext, MODIFY COLUMN `content_bodymain` mediumtext, MODIFY COLUMN `content_bodyfoot` mediumtext; ALTER TABLE `tribalcms_content_forum` MODIFY COLUMN `description` text, MODIFY COLUMN `keywords` text, MODIFY COLUMN `content_head` text; ALTER TABLE `tribalcms_content_forum_tmp` MODIFY COLUMN `description` text, MODIFY COLUMN `keywords` text, MODIFY COLUMN `content_head` mediumtext, MODIFY COLUMN `content_bodytop` mediumtext, MODIFY COLUMN `content_bodymain` mediumtext, MODIFY COLUMN `content_bodyfoot` mediumtext; ALTER TABLE `tribalcms_content_html` MODIFY COLUMN `content_head` text; ALTER TABLE `tribalcms_content_html_tmp` MODIFY COLUMN `content_head` text, MODIFY COLUMN `content_bodytop` mediumtext, MODIFY COLUMN `content_bodymain` mediumtext, MODIFY COLUMN `content_bodyfoot` mediumtext; ALTER TABLE `tribalcms_content_news` MODIFY COLUMN `content_head` text; ALTER TABLE `tribalcms_content_news_tmp` MODIFY COLUMN `content_head` text; ALTER TABLE `tribalcms_folders` MODIFY COLUMN `folder_comment_en` text; ALTER TABLE `tribalcms_forumpost` MODIFY COLUMN `post_text` text; ALTER TABLE `tribalcms_groups` MODIFY COLUMN `description` text; ALTER TABLE `tribalcms_links` MODIFY COLUMN `text2` text, MODIFY COLUMN `img_data` longblob; ALTER TABLE `tribalcms_menu_cache` MODIFY COLUMN `cache` mediumtext; ALTER TABLE `tribalcms_param_keys` MODIFY COLUMN `form_label` text; ALTER TABLE `tribalcms_templates` MODIFY COLUMN `custom_bodytag` text;

# Site Settings - Navigation Category

UPDATE `tribalcms_site_settings` SET section='Navigation' WHERE `name`= 'menu_show_accesskey_in_titles'; UPDATE `tribalcms_site_settings` SET section='Navigation' WHERE `name`= 'default_shortcut_thumbnail_max_filesize';

# Support for Email Templates

CREATE TABLE `tribalcms_email_templates` (

`id` int(20) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,

`name` varchar(50) NOT NULL default '',

`subject` varchar(255) NOT NULL default '',

`body` text NOT NULL,

UNIQUE KEY `name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# Changing title to varchar to support wider range of Titles. Dropping title_other

# Warning: title_other no longer exists. Applications using this field should be ammended to use title instead.

ALTER TABLE `tribalcms_users` MODIFY COLUMN `title` varchar(25) NULL;

ALTER TABLE `tribalcms_users` DROP COLUMN `title_other`;

# Support for extranet user signup steps

CREATE TABLE `tribalcms_enet_steps` (

`id` int(10) unsigned NOT NULL auto_increment,

`signup_model_id` int(10) unsigned NOT NULL default '0',

`name` varchar(255) NOT NULL default '',

`initial` tinyint(1) NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `signup_model_id` (`signup_model_id`,`name`)

) ENGINE=MyISAM;

CREATE TABLE `tribalcms_user_enet_step_link` (

`id` int(10) unsigned NOT NULL auto_increment,

`user_id` int(10) unsigned NOT NULL default '0',

`step_id` int(10) unsigned NOT NULL default '0',

`approved` tinyint(1) NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `user_id` (`user_id`,`step_id`)

) ENGINE=MyISAM;

# Added checksum for shortcut images

ALTER TABLE `tribalcms_links` ADD COLUMN `img_checksum` varchar(32) AFTER `img_data`;

# Added support for additional Extranet functionality

ALTER TABLE tribalcms_enet_user_val ADD COLUMN email_is_username enum('Yes','No') DEFAULT 'No' NOT NULL AFTER username_minlength; ALTER TABLE tribalcms_enet_user_val ADD COLUMN auto_create_password enum('Yes','No') DEFAULT 'No' NOT NULL AFTER email_is_username;

# Added support for different email templates for different steps of a signup model

ALTER TABLE tribalcms_enet_steps ADD COLUMN email_template_id int(20) unsigned DEFAULT NULL;

# Added support for Adverts

CREATE TABLE `tribalcms_adverts` ( `id` int(20) unsigned NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `img_mime_type` enum('image/jpeg','image/gif','image/png','image/jpg','image/pjpeg') NOT NULL default 'image/jpeg', `img_width` smallint(5) unsigned NOT NULL default '0', `img_height` smallint(5) unsigned NOT NULL default '0', `img_bytes` int(10) unsigned NOT NULL default '0', `img_data` longblob NOT NULL, `url` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

CREATE TABLE `tribalcms_advert_counter` ( `advert_id` int(20) unsigned NOT NULL default '0', `advert_day` date NOT NULL default '0000-00-00', `advert_counter` int(20) unsigned NOT NULL default '0', PRIMARY KEY (`advert_id`,`advert_day`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE tribalcms_links ADD COLUMN `advert_id` int(20) NULL AFTER `target_content_type`;

# Compatibility Update, convert tables to UTF8

ALTER TABLE tribalcms_admin_languages CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_admin_phrases CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_public_urls CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_site_registry CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_superadmins CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_url_alias_redirects CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_admin_menuitem_perms CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_admin_notes CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_admin_session CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_admins CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_advert_counter CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_adverts CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_ancil_forum_badwords CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_categories CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_category_item_link CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_document CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_document_tmp CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_extranet CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_extranet_tmp CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_forum CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_forum_tmp CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_html CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_html_tmp CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_news CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_news_tmp CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_nlar CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_nlar_tmp CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_content_stats_public CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_contenttypes CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_countries CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_document_types CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_email_templates CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_enet_steps CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_enet_user_field_labels CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_enet_user_val CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_folders CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_forumpost CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_forumthread CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_group_content_link CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_group_user_link CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_groups CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_images CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_keyword_cache CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_known_referrers CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_lang_equiv_content CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_languages CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_links CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_menu_cache CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_menu_sections CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_menuitems CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_mime_types CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_minimail_list_user CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_minimail_lists CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_minimail_user CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_param_keys CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_param_values CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_searched_keywords CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_site_settings CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_stats_daily CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_stats_extrefers CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_stats_hourly CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_stats_intrefers CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_stats_raw CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_stats_user_login_hist CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_subscription_plans CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_template_link_blocks CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_template_params CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_templates CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_user_content_link CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_user_enet_step_link CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_user_subscriptions CONVERT TO CHARACTER SET utf8; ALTER TABLE tribalcms_users CONVERT TO CHARACTER SET utf8;

# Newsletter Email Preperation Table

CREATE TABLE `tribalcms_newsletter_recip` ( `admin_id` int(10) NOT NULL default '0', `nlar_id` int(10) NOT NULL default '0', `user_email` varchar(255) NOT NULL default '', `created` datetime default NULL, `sent` datetime default NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

# Add support to nlar table for newsletter publishing

ALTER TABLE `tribalcms_content_nlar` ADD `publish_onsite` INT( 10 ) NULL AFTER `seo_sitemap_priority` ; ALTER TABLE `tribalcms_content_nlar_tmp` ADD `publish_onsite` INT( 10 ) NULL AFTER `seo_sitemap_priority` ;

# Add support to nlar table for newsletter sendto starting and stopping

ALTER TABLE `tribalcms_content_nlar` ADD `sendto_date_filter` ENUM('starting','ending') NULL AFTER `sendto_planid` ; ALTER TABLE `tribalcms_content_nlar_tmp` ADD `sendto_date_filter` ENUM('starting','ending') NULL AFTER `sendto_planid` ;

# Added support for toggling of Registration Confirmation email

ALTER TABLE `tribalcms_enet_user_val` ADD COLUMN `register_confirmation_email` enum('Yes','No') NOT NULL DEFAULT 'Yes' AFTER `email_is_username`;

# Added support of passwordless signup

ALTER TABLE `tribalcms_enet_user_val` ADD COLUMN `passwordless_signup` enum('Yes','No') NOT NULL DEFAULT 'No' AFTER `auto_create_password`;

# Added support for transaction system

ALTER TABLE `tribalcms_subscription_plans` ADD `price` INT(15) NOT NULL AFTER `description` ; ALTER TABLE `tribalcms_subscription_plans` ADD `currency_code` VARCHAR( 3 ) NOT NULL AFTER `price` ; ALTER TABLE `tribalcms_subscription_plans` CHANGE `price` `price` INT( 15 ) NOT NULL;

# Added support for Newsletter Templates

CREATE TABLE `tribalcms_newsletter_templates` ( `id` int(20) unsigned NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `title` varchar(255) NOT NULL default '', `body` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

# Added support for new administrator types

ALTER TABLE `tribalcms_superadmins` ADD `perm_sysadmin` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `perm_manage` ; ALTER TABLE `tribalcms_superadmins` ADD `perm_translate` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `perm_edit_groups` ; ALTER TABLE `tribalcms_admins` ADD `perm_sysadmin` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `perm_manage` ; ALTER TABLE `tribalcms_admins` ADD `perm_translate` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `perm_edit_groups` ;

# Transaction System

CREATE TABLE `tribalcms_gateways` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `gate_name` VARCHAR( 255 ) NOT NULL, `decimal_places` char(1) default NULL, `time_format` enum('unixtime','mysqldatetime') default NULL, FULLTEXT KEY `gate_name` (`gate_name`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tribalcms_creditcards` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `card_name` VARCHAR( 255 ) NOT NULL, `allowed` tinyint(1) NOT NULL default 0, FULLTEXT KEY `card_name` (`card_name`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8; CREATE TABLE `tribalcms_cc_gateways` ( `code` VARCHAR(255) NOT NULL, `gateway_id` int(10) NOT NULL default '0', `card_id` int(10) NOT NULL default '0' ) ENGINE = MYISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tribalcms_transactions` ( `id` int(10) NOT NULL auto_increment, `gateway_trans_id` varchar(255) default NULL, `gateway_id` varchar(255) NOT NULL default '', `user_id` int(10) NOT NULL default '0', `order_id` int(10) NOT NULL default '0', `amount` int(15) NOT NULL default '0', `status` varchar(100) NOT NULL default '', `avs_info` varchar(100) NOT NULL default '', `cvd_info` varchar(100) NOT NULL default '', `err_code` int(10) default NULL, `suberr_code` int(10) default NULL, `action_code` varchar(100) default NULL, `auth_time` datetime default NULL, `auth_code` varchar(100) default NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `currency_code` varchar(3) NOT NULL default '', `auth_key` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tribalcms_orders` ( `id` int(10) NOT NULL AUTO_INCREMENT, `transaction_id` int(10) NOT NULL, `company_name` varchar(100) NOT NULL default '', `first_name` varchar(100) NOT NULL default '', `middle_name` varchar(100) NOT NULL default '', `last_name` varchar(100) NOT NULL default '', `cust_del_address1` varchar(255) NOT NULL default '', `cust_del_address2` varchar(255) NOT NULL default '', `cust_del_town` varchar(255) NOT NULL default '', `cust_del_state` varchar(255) NOT NULL default '', `cust_del_postcode` varchar(20) NOT NULL default '', `cust_del_country_id` varchar(3) NOT NULL default '', `cust_del_phone` varchar(20) NOT NULL default '', `cust_bill_address1` varchar(255) NOT NULL default '', `cust_bill_address2` varchar(255) NOT NULL default '', `cust_bill_town` varchar(255) NOT NULL default '', `cust_bill_state` varchar(255) NOT NULL default '', `cust_bill_postcode` varchar(20) NOT NULL default '', `cust_bill_country_id` varchar(3) NOT NULL default '', `cust_bill_phone` varchar(20) NOT NULL default '', `created` datetime NULL, `total_amount` int(15) NOT NULL, `currency_code` varchar(3) NOT NULL default '', PRIMARY KEY(`id`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tribalcms_order_items` ( `o_id` INT( 10 ) NOT NULL , `product_type` ENUM( 'product', 'subscription', 'event' ) NOT NULL , `product_id` INT( 10 ) NOT NULL , `price` int(15) NOT NULL , `quantity` INT( 10 ) NOT NULL , `tax` FLOAT NOT NULL, `currency_code` varchar(3) NOT NULL default '' ) ENGINE = MYISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tribalcms_currencies` ( `id` int(11) NOT NULL auto_increment, `title` varchar(32) NOT NULL default '', `code` varchar(3) NOT NULL default '', `symbol_left` varchar(12) default NULL, `symbol_right` varchar(12) default NULL, `decimal_point` char(1) default NULL, `thousands_point` char(1) default NULL, `decimal_places` char(1) default NULL, `factor` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tribalcms_invoices` ( `id` int(10) NOT NULL AUTO_INCREMENT, `transaction_id` int(10) NOT NULL, `company_name` varchar(100) NOT NULL default '', `first_name` varchar(100) NOT NULL default '', `middle_name` varchar(100) NOT NULL default '', `last_name` varchar(100) NOT NULL default '', `cust_del_address1` varchar(255) NOT NULL default '', `cust_del_address2` varchar(255) NOT NULL default '', `cust_del_town` varchar(255) NOT NULL default '', `cust_del_state` varchar(255) NOT NULL default '', `cust_del_postcode` varchar(20) NOT NULL default '', `cust_del_country_id` varchar(3) NOT NULL default '', `cust_del_phone` varchar(20) NOT NULL default '', `cust_bill_address1` varchar(255) NOT NULL default '', `cust_bill_address2` varchar(255) NOT NULL default '', `cust_bill_town` varchar(255) NOT NULL default '', `cust_bill_state` varchar(255) NOT NULL default '', `cust_bill_postcode` varchar(20) NOT NULL default '', `cust_bill_country_id` varchar(3) NOT NULL default '', `cust_bill_phone` varchar(20) NOT NULL default '', `created` datetime NULL, `total_amount` float(15,2) NOT NULL default '0.00', `currency_code` varchar(3) NOT NULL default '', PRIMARY KEY(`id`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8;