Database Changelog

5.0.4 to 5.0.5

Database Changes

# Ticket System

CREATE TABLE `tribalcms_ticketthread` ( `id` bigint(20) unsigned NOT NULL auto_increment, `lastpost` datetime default NULL, `status` enum('open','pending-close','closed') NOT NULL default 'open', `title` varchar(255) NOT NULL default '', `starter_person_id` int(10) unsigned default NULL, `starter_person_type` enum('admin','user') default NULL, `starter_admin_authtype` enum('local','super') default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `tribalcms_ticketpost` ( `id` bigint(20) unsigned NOT NULL auto_increment, `ticket_id` bigint(20) unsigned NOT NULL default '0', `date_posted` datetime default NULL, `writer_person_id` int(10) unsigned default NULL, `writer_person_type` enum('admin','user') default NULL, `writer_admin_authtype` enum('local','super') default NULL, `title` varchar(255) NOT NULL default '', `post_text` mediumtext, PRIMARY KEY (`id`), KEY `ticket_id` (`ticket_id`), FULLTEXT KEY `title` (`title`), FULLTEXT KEY `post_text` (`post_text`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

# Admin Menu Items

DROP TABLE IF EXISTS `tribalcms_admin_menuitems`;
CREATE TABLE `tribalcms_admin_menuitems` (
`id` int(20) unsigned NOT NULL auto_increment,
`parent_id` int(20) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`url` text NOT NULL,
`ordinal` int(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

# Plugin functionality

CREATE TABLE `tribalcms_plugins` (
`id` int(20) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`status` enum('_ENUM_INSTALLED','_ENUM_INITIALISED','_ENUM_RUNNING','_ENUM_SUSPENDED') NOT NULL default '_ENUM_INSTALLED',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

# Site Languages functionality

ALTER TABLE `tribalcms_languages`
ADD `flag_file_name` VARCHAR( 10 ) NOT NULL;

ALTER TABLE `tribalcms_languages`
ADD `default_sitemap_alias` VARCHAR( 50 ) NOT NULL AFTER `default_homepage_alias` ;

ALTER TABLE `tribalcms_languages`
ADD `default_search_page_alias` VARCHAR( 100 ) NOT NULL AFTER `default_extranet_page_alias` ;

update `tribalcms_languages` set `flag_file_name` = id;