Database Changelog
5.0.8 to 5.0.9
Database changes
# Added support for tracking forum threads
CREATE TABLE `tribalcms_user_forumthread_link` (
`user_id` int(11) default NULL,
`forumthread_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
# Added extra redundant fields reflecting information about posts for efficiency of looking up.
ALTER TABLE tribalcms_forumthread ADD COLUMN firstpost DATETIME AFTER forum_id;
ALTER TABLE tribalcms_forumthread ADD COLUMN last_user_id INT UNSIGNED AFTER start_user_id;
# Added support for 'events'
CREATE TABLE `tribalcms_content_event` (
`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` mediumtext, `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 '',
`private_view_event` tinyint(1) NOT NULL default '0',
`private_view_guests` enum('public','extranet','guests','owner') NOT NULL default 'owner',
`allow_join_event` enum('open','request_invitation','private') NOT NULL default 'private',
`joining_fee` tinyint(1) NOT NULL default '0',
`allow_max_guests` int(10) unsigned default NULL,
`confirmation_status` enum('tentative','confirmed','cancelled') default NULL,
`declare_full` tinyint(1) NOT NULL default '0',
`allow_friends` tinyint(1) default '0',
`event_type1` int(10) unsigned NOT NULL default '0',
`event_type2` int(10) unsigned NOT NULL default '0',
`location_name` varchar(255) NOT NULL default '',
`location_address1` varchar(255) NOT NULL default '',
`location_address2` varchar(255) NOT NULL default '',
`location_city` varchar(255) NOT NULL default '',
`location_state` varchar(255) NOT NULL default '',
`location_postcode` varchar(20) NOT NULL default '',
`location_country_id` char(3) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`website` varchar(255) NOT NULL default '',
`start_date` date default NULL,
`start_time` time default NULL,
`end_date` date default NULL,
`end_time` time default NULL,
`specify_time` tinyint(1) NOT NULL default '0',
`seo_sitemap_changefreq` enum ('always','hourly','daily','weekly','monthly','yearly','never') default NULL,
`seo_sitemap_priority` float(3,1) default NULL,
`diagnostic_page` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`,`version`),
KEY `folder_id` (`folder_id`),
KEY `version` (`version`),
KEY `start_date` (`start_date`),
KEY `start_time` (`start_time`),
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=utf8;
CREATE TABLE `tribalcms_content_event_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` mediumtext, `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 '',
`private_view_event` tinyint(1) NOT NULL default '0',
`private_view_guests` enum('public','extranet','guests','owner') NOT NULL default 'owner',
`allow_join_event` enum('open','request_invitation','private') NOT NULL default 'private',
`joining_fee` tinyint(1) NOT NULL default '0',
`allow_max_guests` int(10) unsigned default NULL,
`confirmation_status` enum('tentative','confirmed','cancelled') default NULL,
`declare_full` tinyint(1) NOT NULL default '0',
`allow_friends` tinyint(1) default '0',
`event_type1` int(10) unsigned NOT NULL default '0',
`event_type2` int(10) unsigned NOT NULL default '0',
`location_name` varchar(255) NOT NULL default '',
`location_address1` varchar(255) NOT NULL default '',
`location_address2` varchar(255) NOT NULL default '',
`location_city` varchar(255) NOT NULL default '',
`location_state` varchar(255) NOT NULL default '',
`location_postcode` varchar(20) NOT NULL default '',
`location_country_id` char(3) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`website` varchar(255) NOT NULL default '',
`start_date` date default NULL,
`start_time` time default NULL,
`end_date` date default NULL,
`end_time` time default NULL,
`specify_time` tinyint(1) NOT NULL default '0',
`seo_sitemap_changefreq` enum ('always','hourly','daily','weekly','monthly','yearly','never') default NULL,
`seo_sitemap_priority` float(3,1) default NULL,
`diagnostic_page` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`,`version`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tribalcms_user_content_event_attendees` (
`event_id` int(10) unsigned NOT NULL default '0',
`attendee_id` int(10) unsigned NOT NULL default '0',
`attendee_authtype` enum('local','super','user') NOT NULL default 'local',
`booking_status` enum ('requested','invited','confirmed','cancelled') default NULL,
`invited` datetime default NULL,
`confirmed` datetime default NULL,
`cancelled` datetime default NULL,
`attended` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`event_id`,`attendee_id`,`attendee_authtype`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tribalcms_content_eventtype1` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`use_physical_location` tinyint(1) default '0',
PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tribalcms_content_eventtype2` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`parent_eventtype_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Added support for parameter settings
ALTER TABLE tribalcms_template_params ADD COLUMN setting_type enum('simple_readonly','simple_writeable','enum','helper') NOT NULL;
ALTER TABLE tribalcms_template_params ADD COLUMN setting_value text NOT NULL;
ALTER TABLE tribalcms_param_values ADD COLUMN setting_type enum('simple_readonly','simple_writeable','enum','helper') NOT NULL;
ALTER TABLE tribalcms_param_values ADD COLUMN setting_value text NOT NULL;
# Added support for flash/quicktime movies
CREATE TABLE `tribalcms_movies` (
`content_item_id` int(10) unsigned NOT NULL default '0',
`content_item_version` int(10) unsigned NOT NULL default '0',
`content_item_type` varchar(20) NOT NULL default '',
`created_datetime` datetime default NULL,
`filename` varchar(50) NOT NULL default '',
`mime_type` enum('application/x-shockwave-flash','video/quicktime','audio/x-ms-wmv') NOT NULL default 'application/x-shockwave-flash',
`width` smallint(5) unsigned default NULL,
`height` smallint(5) unsigned default NULL,
`size` int(10) unsigned default NULL,
`data` mediumblob,
`checksum` varchar(32) default NULL,
`thumbnail_width` smallint(5) unsigned default NULL,
`thumbnail_height` smallint(5) unsigned default NULL,
`thumbnail_data` mediumblob,
`thumbnail_size` int(10) unsigned default NULL,
`sticky_flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`content_item_id`,`content_item_version`,`filename`,`content_item_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
# Added new settings for maximum movie size
INSERT INTO tribalcms_site_settings VALUES ('max_content_movie_filesize','Content Items',12,'TEXT',NULL,2000000);
# Added support for movies in shortcuts
ALTER TABLE tribalcms_links MODIFY `img_mime_type` enum('image/jpeg','image/gif','image/png','image/jpg','image/pjpeg','application/x-shockwave-flash','video/quicktime','audio/x-ms-wmv') default NULL;
ALTER TABLE tribalcms_adverts MODIFY `img_mime_type` enum('image/jpeg','image/gif','image/png','image/jpg','image/pjpeg','application/x-shockwave-flash','video/quicktime','audio/x-ms-wmv') default NULL;
# Adding the tab for Backup functionality (not complete)
insert into tribalcms_admin_menuitems values (NULL,6,'_BACKUP_TAB','admin/backup.php',7);
# Tidying up to get rid of deprecated minimail from TribalCMS 4
drop table tribalcms_minimail_user;
drop table tribalcms_minimail_lists;
drop table tribalcms_minimail_list_user;
# Support for new Picture content type
CREATE TABLE `tribalcms_content_picture` (
`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` tinyint(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,
`diagnostic_page` tinyint(1) NOT NULL default '0',
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=utf8;
CREATE TABLE `tribalcms_content_picture_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` tinyint(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,
`diagnostic_page` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tribalcms_contenttype_settings` (
`content_type_id` varchar(20) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`ordinal` int(10) unsigned default NULL,
`value` blob,
PRIMARY KEY (`content_type_id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `tribalcms_contenttype_settings` (`content_type_id`, `name`, `ordinal`, `value`) VALUES
('picture', 'standard_width', 1, 0x323030),
('picture', 'standard_height', 2, 0x323030);
INSERT INTO tribalcms_contenttypes VALUES ('picture','Picture','PICT',0,0,1,1,1,0,0);
# Added new settings for maximum picture size
INSERT INTO tribalcms_site_settings VALUES ('max_picture_filesize','Content Items',13,'TEXT',NULL,2000000);
# Added support for bulk upload of content
ALTER TABLE tribalcms_contenttypes ADD COLUMN bulk_upload tinyint(1) DEFAULT 0 NOT NULL;
# Enlarged extlink_url field to accommodate very long urls
ALTER TABLE tribalcms_links MODIFY COLUMN extlink_url TEXT;
# Added support for rel property on tags
ALTER TABLE tribalcms_links ADD COLUMN `rel_tag` varchar(100) NULL;
ALTER TABLE tribalcms_menuitems ADD COLUMN `rel_tag` varchar(100) NULL;
#Added support for RSS feeds from HTML content items
ALTER TABLE tribalcms_templates ADD COLUMN `allow_rss` tinyint(1) DEFAULT 0;
ALTER TABLE tribalcms_content_html ADD COLUMN `enable_rss` tinyint(1) DEFAULT 0;
ALTER TABLE tribalcms_content_html_tmp ADD COLUMN `enable_rss` tinyint(1) DEFAULT 0;
#Added support for raw picture store
CREATE TABLE `tribalcms_raw_picture_store` (
`content_id` int(10) unsigned default NULL,
`data` longblob
) ENGINE=MyISAM DEFAULT CHARSET=utf8
#Added support for content type settings
CREATE TABLE `tribalcms_contenttype_settings` (
`content_type_id` varchar(20) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`ordinal` int(10) unsigned default NULL,
`value` blob,
PRIMARY KEY (`content_type_id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
#Permissions for Admin Pages
TRUNCATE `tribalcms_admin_page_perms`;
INSERT INTO `tribalcms_admin_page_perms` VALUES
('admin_languages.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('administrators.php','manage','AND','both','perm_manage'),
('alias_urls.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('content.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('content_equivalence.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('groups.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('home.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('meta.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('newsletters.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('plugins.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('server.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('site_languages.php','manage','OR','both','perm_sysadmin'),
('site_languages_start.php','view','OR','both','perm_sysadmin'),
('site_languages.php','view','OR','both','perm_sysadmin,perm_publish,perm_author,perm_translate'),
('site_registry.php','view','OR','super','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('statistics.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('stats_adverts.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('stats_content_item.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('subscription_plans.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('tasks.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('templates.php','manage','OR','both','perm_sysadmin'),
('template.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('templates.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('visitor_languages.php','manage','OR','both','perm_sysadmin'),
('templates_unregistered.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('users.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('users_export.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('visitor_languages.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('settings.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('workflow_sent_tasks.inc.php','view','AND','both','perm_publish,perm_author'),
('workflow_received_tasks.inc.php','view','AND','both','perm_publish,perm_author'),
('avls_content_equivalence_manage.inc.php','view','AND','both','perm_publish,perm_author'),
('avls_dual_view.inc.php','view','AND','both','perm_publish,perm_author'),
('avls_content_equivalence_set.inc.php','view','AND','both','perm_publish,perm_author'),
('workflow_create_task.inc.php','view','AND','both','perm_publish,perm_author'),
('workflow_view_task.inc.php','view','AND','both','perm_publish,perm_author'),
('visitor_languages_manage.php','view','AND','both','perm_sysadmin'),
('site_registry_site.php','view','AND','both','perm_publish,perm_author'),
('administrator_super.php','view','AND','super','perm_manage'),
('user.php','view','AND','both','perm_publish,perm_author'),
('newsletter.php','view','AND','both','perm_publish,perm_author'),
('settings.php','edit','OR','both','perm_sysadmin'),
('create_content.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('edit_meta_data.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('images.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('menuitem.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('permissions.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('shortcut_image_browser.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('shortcuts.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('template_browser.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('advert_browser.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('administrator.php','view','AND','both','perm_manage'),
('stats_summary_hits.inc.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('install_content_types.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('group_documents.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('stats_monthly_hits.inc.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('stats_monthly_topitems.inc.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('template_block.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('template_menu_section.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('adverts.php','view','AND','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('backup.php','view','OR','both','perm_sysadmin'),
('template.php','manage','OR','both','perm_sysadmin'),
('content_types.php','view','OR','both','perm_sysadmin,perm_publish,perm_author'),
('content_types.php','manage','AND','both','perm_sysadmin'),
('categories.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('categories.php','manage','OR','both','perm_sysadmin,perm_publish'),
('movies.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('dropbox.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('dropbox.php','manage','OR','both','perm_sysadmin,perm_publish'),
('my_profile.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('administrators.php','view','OR','both','perm_manage,perm_sysadmin'),
('create_content.php','manage','OR','both','perm_sysadmin,perm_publish,perm_author'),
('create_content.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('create_content.php','edit','OR','both','perm_sysadmin,perm_author'),
('set_meta_data.php','edit','OR','both','perm_sysadmin,perm_author'),
('set_categories.php','edit','OR','both','perm_sysadmin,perm_author'),
('set_meta_data.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('set_categories.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('set_permissions.php','edit','OR','both','perm_sysadmin,perm_author'),
('set_permissions.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('set_settings.php','edit','OR','both','perm_sysadmin,perm_author'),
('set_settings.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('set_template.php','edit','OR','both','perm_sysadmin,perm_author'),
('set_template.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('upload_content2.php','edit','OR','both','perm_sysadmin,perm_author'),
('upload_content2.php','view','OR','both','perm_manage,perm_sysadmin,perm_publish,perm_author,perm_editmenu,perm_manageforum,perm_view_users,perm_edit_users,perm_view_groups,perm_edit_groups,perm_translate'),
('dropbox.php','edit','OR','both','perm_sysadmin,perm_author');
#Admin Menu Items
TRUNCATE `tribalcms_admin_menuitems`;
INSERT INTO `tribalcms_admin_menuitems` VALUES
(NULL,0,'_ADMIN_HOME_TAB','admin/home.php',1),
(NULL,0,'_CONTENT_TAB','admin/content.php',2),
(NULL,0,'_TEMPLATES_TAB','admin/templates.php',3),
(NULL,0,'_SETTINGS_TAB','admin/settings.php?section=General',5),
(NULL,0,'_SERVER_ADMIN_TAB','admin/server.php',6),
(NULL,1,'_OVERVIEW_TAB','admin/home.php',1),
(NULL,2,'_STATISTICS_ADVERTS','admin/stats_adverts.php',5),
(NULL,7,'_CONTENT_EQUIVALENCE_TAB','admin/content_equivalence.php',3),
(NULL,3,'_LIST_TEMPLATES_TAB','admin/templates.php',1),
(NULL,6,'_CONTENT_TYPES_TAB','admin/content_types.php',2),
(NULL,3,'_LIST_TEMPLATES_UNREGISTERED_TAB','admin/templates_unregistered.php',2),
(NULL,4,'_EXPORT_USER_DETAILS_TAB','admin/users_export.php',4),
(NULL,4,'_EXTRANET_GROUPS_TAB','admin/groups.php',3),
(NULL,4,'_EXTRANET_USERS_TAB','admin/users.php',2),
(NULL,4,'_ADMINISTRATORS_TAB','admin/administrators.php',5),
(NULL,6,'_SERVER_INFORMATION_TAB','admin/server.php',1),
(NULL,6,'_ADMIN_LANGUAGES_TAB','admin/admin_languages.php',3),
(NULL,7,'_SITE_LANGUAGES_TAB','admin/site_languages.php',1),
(NULL,6,'_SITE_REGISTRY_TAB','admin/site_registry.php',4),
(NULL,6,'_ALIAS_URLS_TAB','admin/alias_urls.php',5),
(NULL,6,'_PLUGINS_TAB','admin/plugins.php',6),
(NULL,0,'_PEOPLE_TAB','admin/my_profile.php',4),
(NULL,0,'_LANGUAGES_TAB','admin/site_languages.php',7),
(NULL,7,'_VISITOR_LANGUAGES_TAB','admin/visitor_languages.php',2),
(NULL,2,'_META_DATA_TAB','admin/meta.php',2),
(NULL,0,'_WORKFLOW_TAB','admin/tasks.php',8),
(NULL,8,'_SENT_TASK_TAB','admin/tasks_sent.php',3),
(NULL,8,'_RECEIVED_TASK_TAB','admin/tasks_received.php',2),
(NULL,8,'_ALL_TASKS_TAB','admin/tasks.php',1),
(NULL,2,'_CONTENT_ITEMS_STATISTICS','admin/stats_content_item.php',4),
(NULL,2,'_STATISTICS_TAB','admin/statistics.php',3),
(NULL,2,'_CONTENT_FOLDERS_TAB','admin/content.php',1),
(NULL,2,'_CATEGORIES_TAB','admin/categories.php',7),
(NULL,6,'_BACKUP_TAB','admin/backup.php',7),
(NULL,2,'_NEWSLETTERS','admin/newsletters.php',6),
(NULL,4,'_MY_PROFILE_TAB','admin/my_profile.php',1),
(NULL,4,'_SUBSCRIPTION_PLANS_TAB','admin/subscription_plans.php',7);
# Added image meta data to tribalcms_content_picture
ALTER TABLE tribalcms_content_picture ADD COLUMN filename varchar(50) NOT NULL AFTER content_bodyfoot;
ALTER TABLE tribalcms_content_picture ADD COLUMN mime_type enum('image/jpeg','image/gif','image/png','image/jpg','image/pjpeg') DEFAULT 'image/jpeg' NOT NULL AFTER filename;
ALTER TABLE tribalcms_content_picture ADD COLUMN width smallint(5) unsigned AFTER mime_type;
ALTER TABLE tribalcms_content_picture ADD COLUMN height smallint(5) unsigned AFTER width;
ALTER TABLE tribalcms_content_picture ADD COLUMN size int(10) unsigned AFTER height;
ALTER TABLE tribalcms_content_picture_tmp ADD COLUMN filename varchar(50) NOT NULL AFTER content_bodyfoot;
ALTER TABLE tribalcms_content_picture_tmp ADD COLUMN mime_type enum('image/jpeg','image/gif','image/png','image/jpg','image/pjpeg') DEFAULT 'image/jpeg' NOT NULL AFTER filename;
ALTER TABLE tribalcms_content_picture_tmp ADD COLUMN width smallint(5) unsigned AFTER mime_type;
ALTER TABLE tribalcms_content_picture_tmp ADD COLUMN height smallint(5) unsigned AFTER width;
ALTER TABLE tribalcms_content_picture_tmp ADD COLUMN size int(10) unsigned AFTER height;
# Added support for version in raw picture store
ALTER TABLE tribalcms_raw_picture_store ADD COLUMN content_version int(10) unsigned NOT NULL AFTER content_id;
# Added comment field to template parameter
ALTER TABLE `tribalcms_template_params` ADD `param_comment` VARCHAR( 255 ) NOT NULL AFTER `param_key` ;
#News publication date now is DATETIME
ALTER TABLE `tribalcms_content_news` CHANGE `publication_date` `publication_date` DATETIME NULL DEFAULT NULL;
ALTER TABLE `tribalcms_content_news_tmp` CHANGE `publication_date` `publication_date` DATETIME NULL DEFAULT NULL;
#Add new folder for pictures
INSERT INTO tribalcms_folders VALUES ('',1,'Pictures','',0);
UPDATE tribalcms_contenttypes SET default_folder_id = last_insert_id()
WHERE content_type_id = 'picture';
#Added support for rss feed to contenttype tables
ALTER TABLE tribalcms_content_event ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_event_tmp ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_picture ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_picture_tmp ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_nlar ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_nlar_tmp ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_news ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_news_tmp ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_extranet ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_extranet_tmp ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_forum_tmp ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;ALTER TABLE tribalcms_content_forum ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
#Added support for user images
CREATE TABLE `tribalcms_user_images` (
`user_id` int(10) unsigned NOT NULL default '0',
`filename` varchar(50) NOT NULL default '',
`mime_type` enum('image/jpeg','image/gif','image/png','image/jpg','image/pjpeg') NOT NULL default 'image/jpeg',
`width` smallint(5) unsigned default NULL,
`height` smallint(5) unsigned default NULL,
`size` int(10) unsigned default NULL,
`data` mediumblob,
`checksum` varchar(32) default NULL,
`usage` ENUM ('thumbnail','fullsize'),
`sticky_flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (user_id, checksum), KEY user_id (user_id) )
ENGINE=MyISAM DEFAULT CHARSET=utf8;
#Added support for rss feed to document contenttype tables
ALTER TABLE tribalcms_content_document ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
ALTER TABLE tribalcms_content_document_tmp ADD COLUMN enable_rss tinyint(1) NULL DEFAULT 0;
# Tidy up subscriptions
ALTER TABLE `tribalcms_subscription_plans` CHANGE `duration_unit` `duration_unit` ENUM( 'YEAR', 'MONTH', 'DAY' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
ALTER TABLE `tribalcms_user_subscriptions` CHANGE `duration_unit` `duration_unit` ENUM( 'YEAR', 'MONTH', 'DAY' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
# Change for searching Users which does not belong to any Group
ALTER TABLE `tribalcms_group_user_link` CHANGE `group_id` `group_id` INT( 10 ) UNSIGNED NULL DEFAULT '0';
# Define admin permissions for site_language_start
insert into tribalcms_admin_page_perms(filename, mode, `require`, authtype, satisfy_permissions)
values('site_language_start.php', 'view', 'OR', 'both', 'perm_sysadmin');
# Define admin permissions for content_export_translate
insert into tribalcms_admin_page_perms(filename, mode, `require`, authtype, satisfy_permissions)
values('content_export_translate.php', 'view', 'AND', 'both', 'perm_author,perm_editmenu,perm_override_author_lock');
# Add weightings for Advanced tabular search
INSERT INTO `tribalcms_site_settings` VALUES
('html_title_weighting','Search',5,'TEXT',NULL,'24'),
('html_keyword_weighting','Search',6,'TEXT',NULL,'6'),
('html_desc_weighting','Search',7,'TEXT',NULL,'3'),
('html_content_bodymain_weighting','Search',8,'TEXT',NULL,'2'),
('html_title_wild_weighting','Search',9,'TEXT',NULL,'16'),
('html_keyword_wild_weighting','Search',10,'TEXT',NULL,'4'),
('html_desc_wild_weighting','Search',11,'TEXT',NULL,'1'),
('html_content_bodymain_wild_weighting','Search',12,'TEXT',NULL,'1'),
('html_keyword_exact_match','Search',13,'TEXT',NULL,'false'),
('news_title_weighting','Search',14,'TEXT',NULL,'24'),
('news_keyword_weighting','Search',15,'TEXT',NULL,'6'),
('news_desc_weighting','Search',16,'TEXT',NULL,'3'),
('news_content_bodymain_weighting','Search',17,'TEXT',NULL,'2'),
('news_title_wild_weighting','Search',18,'TEXT',NULL,'16'),
('news_keyword_wild_weighting','Search',19,'TEXT',NULL,'4'),
('news_desc_wild_weighting','Search',20,'TEXT',NULL,'1'),
('news_content_bodymain_wild_weighting','Search',21,'TEXT',NULL,'1'),
('news_keyword_exact_match','Search',22,'TEXT',NULL,'false'),
('document_title_weighting','Search',23,'TEXT',NULL,'24'),
('document_keyword_weighting','Search',24,'TEXT',NULL,'6'),
('document_desc_weighting','Search',25,'TEXT',NULL,'3'),
('document_content_bodymain_weighting','Search',26,'TEXT',NULL,'2'),
('document_document_text_weighting','Search',27,'TEXT',NULL,'2'),
('document_title_wild_weighting','Search',28,'TEXT',NULL,'16'),
('document_keyword_wild_weighting','Search',29,'TEXT',NULL,'4'),
('document_desc_wild_weighting','Search',30,'TEXT',NULL,'1'),
('document_content_bodymain_wild_weighting','Search',31,'TEXT',NULL,'1'),
('document_document_text_wild_weighting','Search',32,'TEXT',NULL,'1'),
('document_keyword_exact_match','Search',33,'TEXT',NULL,'false');
# Added support for group images
CREATE TABLE `tribalcms_group_images`(
`group_id` int(10) unsigned NOT NULL default '0',
`filename` varchar(50) NOT NULL default '',
`mime_type` enum('image/jpeg','image/gif','image/png','image/jpg','image/pjpeg') NOT NULL default 'image/jpeg',
`width` smallint(5) unsigned default NULL,
`height` smallint(5) unsigned default NULL,
`size` int(10) unsigned default NULL,
`data` mediumblob,
`checksum` varchar(32) NOT NULL default '',
`usage` enum('thumbnail','medium','fullsize') default NULL,
`sticky_flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`group_id`,`checksum`),
KEY `group_id` (`group_id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8;
