AwLYgARQ

1ALTER TABLE `cb_ba_pa_business_event`
2	CHANGE COLUMN `pabe_is_deferral_related` `pabe_is_current_year_only` TINYINT(1) NOT NULL DEFAULT '0' AFTER `pabe_is_commitment_related`;
3
4	
5ALTER TABLE `cb_ba_pa_business_event_account`
6	ALTER `pabea_maturity` DROP DEFAULT;
7ALTER TABLE `cb_ba_pa_business_event_account`
8	CHANGE COLUMN `pabea_maturity` `pabea_booking_period` VARCHAR(255) NOT NULL AFTER `pabea_debit_credit`,
9	CHANGE COLUMN `pabea_pa_budget_line_account_role` `pabea_account_role` VARCHAR(255) NULL DEFAULT NULL AFTER `pabea_is_repeatable`;
10
11
12DROP TABLE IF EXISTS `cb_ba_pa_business_event_tag`;
13CREATE TABLE IF NOT EXISTS `cb_ba_pa_business_event_tag` (
14  `pabet_id` bigint(20) NOT NULL,
15  `pabet_tag` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
16  `pabe_id` bigint(20) NOT NULL,
17  `created` datetime NOT NULL,
18  `creator` varchar(255) COLLATE utf8_hungarian_ci NOT NULL,
19  `updated` datetime DEFAULT NULL,
20  `updater` varchar(255) COLLATE utf8_hungarian_ci DEFAULT NULL,
21  `version` bigint(20) NOT NULL,
22  PRIMARY KEY (`pabet_id`),
23  KEY `FK__cb_ba_pa_business_event` (`pabe_id`),
24  CONSTRAINT `FK__cb_ba_pa_business_event` FOREIGN KEY (`pabe_id`) REFERENCES `cb_ba_pa_business_event` (`pabe_id`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;