# Pricing functionality

CREATE TABLE `tribalcms_contentitem_price` ( `content_id` int(20) NOT NULL, `content_type` varchar(20) NOT NULL, `currency` varchar(3) NOT NULL, `quantity` int(20) default NULL, `group_id` int(20) default NULL, `user_id` int(20) default NULL, `value` int(20) NOT NULL, UNIQUE KEY `content_id` (`content_id`,`content_type`,`currency`,`quantity`,`group_id`,`user_id`,`value`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

# Signup Model Post Login Target

ALTER TABLE tribalcms_enet_user_val ADD COLUMN post_login_target_content_id int(20) unsigned NULL; ALTER TABLE tribalcms_enet_user_val ADD COLUMN post_login_target_content_type varchar(20) NULL;

# Visitor Phrases

CREATE TABLE `tribalcms_visitor_phrases` (
`code` varchar(100) NOT NULL default '',
`language_id` varchar(5) NOT NULL default '',
`local_text` text NOT NULL,
`protect_flag` tinyint(1) NOT NULL default '0',
`review_flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`code`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

# Added diagnostic functionality

ALTER TABLE `tribalcms_content_html` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_html_tmp` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_document` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_document_tmp` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_forum` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_forum_tmp` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_news` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_news_tmp` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_extranet` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_extranet_tmp` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_nlar` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

ALTER TABLE `tribalcms_content_nlar_tmp` ADD COLUMN diagnostic_page tinyint(1) NOT NULL DEFAULT 0;

# Fix for tribalcms_content_news and tribalcms_content_nlar

ALTER TABLE `tribalcms_content_news` MODIFY COLUMN draft_exists tinyint(1) DEFAULT 0 NOT NULL; ALTER TABLE `tribalcms_content_nlar` MODIFY COLUMN draft_exists tinyint(1) DEFAULT 0 NOT NULL;