# Added country_id to tribalcms_subscription_plans

ALTER TABLE `tribalcms_subscription_plans`

ADD COLUMN `country_id` varchar(2) NULL AFTER `currency_code`;

# Added fulfillment_status and transaction_status to tribalcms_orders

ALTER TABLE `tribalcms_orders`

ADD COLUMN `transaction_status` enum('SUCCESS','FAILURE')

NOT NULL DEFAULT 'FAILURE' AFTER `transaction_id`;

ALTER TABLE `tribalcms_orders`

ADD COLUMN `fulfillment_status`

enum('NEW','ACKNOWLEDGED','PROCESSED','DISPATCHED')

NOT NULL DEFAULT 'NEW' AFTER `transaction_status`;

# Make email newsletters more efficient

alter table tribalcms_newsletter_recip add key (admin_id), add key (nlar_id), add key (user_email);

# Added diagnostic page flag

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_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_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_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;

INSERT INTO `tribalcms_admin_menuitems` VALUES (1,0,'_ADMIN_HOME_TAB','admin/home.php',1),(2,0,'_CONTENT_TAB','admin/content.php',2),(3,0,'_TEMPLATES_TAB','admin/templates.php',3),(4,0,'_PEOPLE_TAB','admin/administrators.php',4),(5,0,'_SETTINGS_TAB','admin/settings.php?section=General',5),(6,0,'_SERVER_ADMIN_TAB','admin/server.php',6),(7,1,'_OVERVIEW_TAB','admin/home.php',1),(8,2,'_CONTENT_FOLDERS_TAB','admin/content.php',1),(9,2,'_STATISTICS_TAB','admin/statistics.php',2),(10,7,'_CONTENT_EQUIVALENCE_TAB','admin/content_equivalence.php',3),(11,3,'_LIST_TEMPLATES_TAB','admin/templates.php',1),(12,3,'_LIST_TEMPLATES_MISSING_TAB','admin/templates_missing.php',2),(13,3,'_LIST_TEMPLATES_UNREGISTERED_TAB','admin/templates_unregistered.php',3),(14,4,'_ADMINISTRATORS_TAB','admin/administrators.php',1),(15,4,'_EXTRANET_USERS_TAB','admin/users.php',2),(16,4,'_EXTRANET_GROUPS_TAB','admin/groups.php',3),(17,4,'_EXPORT_USER_DETAILS_TAB','admin/users_export.php',4),(18,6,'_SERVER_INFORMATION_TAB','admin/server.php',1),(19,6,'_ADMIN_LANGUAGES_TAB','admin/admin_languages.php',2),(20,7,'_SITE_LANGUAGES_TAB','admin/site_languages.php',1),(21,6,'_SITE_REGISTRY_TAB','admin/site_registry.php',4),(22,6,'_ALIAS_URLS_TAB','admin/alias_urls.php',5),(23,6,'_PLUGINS_TAB','admin/plugins.php',6),(24,4,'_NEWSLETTERS','admin/newsletters.php',5),(25,0,'_LANGUAGES_TAB','admin/site_languages.php',7),(26,7,'_VISITOR_LANGUAGES_TAB','admin/visitor_languages.php',2),(27,2,'_CONTENT_ITEMS_STATISTICS','admin/stats_content_item.php',3),(28,2,'_META_DATA_TAB','admin/meta.php',4),(29,0,'_WORKFLOW_TAB','admin/tasks.php',8),(30,8,'_SENT_TASK_TAB','admin/tasks_sent.php',3),(31,8,'_RECEIVED_TASK_TAB','admin/tasks_received.php',2),(32,8,'_ALL_TASKS_TAB','admin/tasks.php',1);