kSL6ic8D

1DROP TABLE IF EXISTS `cb_ba_governmental_function`;	
2DROP TABLE IF EXISTS `cb_ba_cofog_governmental_function`;	
3DROP TABLE IF EXISTS `join_cb_ba_governmental_to_cb_ba_functional_area`;	
4	
5	
6DROP TABLE IF EXISTS `cb_ba_budget_activity`;
7CREATE TABLE IF NOT EXISTS `cb_ba_budget_activity` (
8  `ba_id` bigint(20) NOT NULL AUTO_INCREMENT,
9  `ba_code` varchar(255) NOT NULL,
10  `ba_is_detail_allowed` tinyint(1) NOT NULL,
11  `ba_is_required_by_law` tinyint(1) NOT NULL,
12  `ba_name` varchar(255) NOT NULL,
13  `active` tinyint(1) NOT NULL,
14  `ba_comment` text,
15  `inactivation_date` date DEFAULT NULL,
16  `inactivation_reason` varchar(255) DEFAULT NULL,
17  `valid_from` date NOT NULL,
18  `valid_to` date DEFAULT NULL,
19  `created` datetime NOT NULL,
20  `creator` varchar(255) NOT NULL,
21  `updated` datetime DEFAULT NULL,
22  `updater` varchar(255) DEFAULT NULL,
23  `version` bigint(20) NOT NULL,
24  PRIMARY KEY (`ba_id`)
25) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
26
27	
28	
29DROP TABLE IF EXISTS `cb_ba_cofog_budget_activity`;
30CREATE TABLE IF NOT EXISTS `cb_ba_cofog_budget_activity` (
31  `cofogba_id` bigint(20) NOT NULL AUTO_INCREMENT,
32  `cofog_id` bigint(20) NOT NULL,
33  `ba_id` bigint(20) NOT NULL,
34  `valid_from` date NOT NULL,
35  `valid_to` date DEFAULT NULL,
36  `created` datetime NOT NULL,
37  `creator` varchar(255) NOT NULL,
38  `updated` datetime DEFAULT NULL,
39  `updater` varchar(255) DEFAULT NULL,
40  `version` bigint(20) NOT NULL,
41  PRIMARY KEY (`cofogba_id`),
42  KEY `FK_cb_ba_cofog_budget_activity_cb_ba_cofog` (`cofog_id`),
43  KEY `FK_cb_ba_cofog_budget_activity_cb_ba_ba` (`ba_id`),
44  CONSTRAINT `FK_cb_ba_cofog_ba_cb_ba_budget_activtiy` FOREIGN KEY (`ba_id`) REFERENCES `cb_ba_budget_activity` (`ba_id`),
45  CONSTRAINT `FK_cb_ba_cofog_ba_cb_ba_cofog` FOREIGN KEY (`cofog_id`) REFERENCES `cb_ba_cofog` (`cofog_id`)
46) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
47
48
49DROP TABLE IF EXISTS `join_cb_ba_budget_activity_to_cb_ba_functional_area`;
50CREATE TABLE IF NOT EXISTS `join_cb_ba_budget_activity_to_cb_ba_functional_area` (
51  `ba_id` bigint(20) DEFAULT NULL,
52  `fa_id` bigint(20) DEFAULT NULL,
53  KEY `FK__cb_ba_functional_area` (`fa_id`),
54  KEY `FK__cb_ba_budget_activity` (`ba_id`),
55  CONSTRAINT `FK__cb_ba_budget_activity` FOREIGN KEY (`ba_id`) REFERENCES `cb_ba_budget_activity` (`ba_id`),
56  CONSTRAINT `FK__cb_ba_functional_area` FOREIGN KEY (`fa_id`) REFERENCES `cb_ba_functional_area` (`fa_id`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58
59
60
61DROP TABLE IF EXISTS `cb_ba_cofog`;
62CREATE TABLE IF NOT EXISTS `cb_ba_cofog` (
63  `cofog_id` bigint(20) NOT NULL AUTO_INCREMENT,
64  `cofog_code` varchar(255) NOT NULL,
65  `cofog_is_detail_allowed` tinyint(1) NOT NULL,
66  `cofog_is_required_by_law` tinyint(1) NOT NULL,
67  `cofog_name` varchar(255) NOT NULL,
68  `cofog_comment` text,
69  `active` tinyint(1) NOT NULL,
70  `inactivation_date` date DEFAULT NULL,
71  `inactivation_reason` varchar(255) DEFAULT NULL,
72  `valid_from` date NOT NULL,
73  `valid_to` date DEFAULT NULL,
74  `created` datetime NOT NULL,
75  `creator` varchar(255) NOT NULL,
76  `updated` datetime DEFAULT NULL,
77  `updater` varchar(255) DEFAULT NULL,
78  `version` bigint(20) NOT NULL,
79  PRIMARY KEY (`cofog_id`)
80) ENGINE=InnoDB AUTO_INCREMENT=641 DEFAULT CHARSET=utf8;
81
82
83
84DROP TABLE IF EXISTS `cb_ba_era`;
85CREATE TABLE IF NOT EXISTS `cb_ba_era` (
86  `era_id` bigint(20) NOT NULL AUTO_INCREMENT,
87  `era_code` varchar(255) NOT NULL,
88  `era_type` varchar(255) NOT NULL,
89  `era_is_detail_allowed` tinyint(1) NOT NULL,
90  `era_is_required_by_law` tinyint(1) NOT NULL,
91  `era_name` varchar(255) NOT NULL,
92  `active` tinyint(1) NOT NULL,
93  `era_comment` text,
94  `bl_id` bigint(20) DEFAULT NULL,
95  `inactivation_date` date DEFAULT NULL,
96  `inactivation_reason` varchar(255) DEFAULT NULL,
97  `valid_from` date NOT NULL,
98  `valid_to` date DEFAULT NULL,
99  `created` datetime NOT NULL,
100  `creator` varchar(255) NOT NULL,
101  `updated` datetime DEFAULT NULL,
102  `updater` varchar(255) DEFAULT NULL,
103  `version` bigint(20) NOT NULL,
104  PRIMARY KEY (`era_id`),
105  KEY `FK_cb_ba_era_cb_ba_rubric` (`bl_id`),
106  CONSTRAINT `FK_cb_ba_era_cb_ba_budgetline` FOREIGN KEY (`bl_id`) REFERENCES `cb_ba_budgetline` (`bl_id`)
107) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
108
109
110
111CREATE TABLE `cb_ba_pa_business_event_budget_line_role` (
112	`pabebl_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
113	`pabe_id` BIGINT(20) NOT NULL,
114	`bl_id` BIGINT(20) NOT NULL,
115	`pabebl_value_type` VARCHAR(255) NOT NULL,
116	`created` DATETIME NOT NULL,
117	`creator` VARCHAR(255) NOT NULL,
118	`updated` DATETIME NULL DEFAULT NULL,
119	`updater` VARCHAR(255) NULL DEFAULT NULL,
120	`version` BIGINT(20) NOT NULL,
121	PRIMARY KEY (`pabebl_id`),
122	CONSTRAINT `FK__cb_ba_pa_business_event_` FOREIGN KEY (`pabe_id`) REFERENCES `cb_ba_pa_business_event` (`pabe_id`),
123	CONSTRAINT `FK__cb_ba_budgetline_` FOREIGN KEY (`bl_id`) REFERENCES `cb_ba_budgetline` (`bl_id`)
124)
125COLLATE='utf8_general_ci'
126ENGINE=InnoDB
127;
128
129
130	
131UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_ACTIVITY_CREATE' WHERE  `pe_code`='GOVERNMENTAL_FUNCTION_CREATE';
132UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_ACTIVITY_UPDATE' WHERE  `pe_code`='GOVERNMENTAL_FUNCTION_UPDATE';
133UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_ACTIVITY_READ' WHERE  `pe_code`='GOVERNMENTAL_FUNCTION_READ';
134UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_ACTIVITY_DELETE' WHERE  `pe_code`='GOVERNMENTAL_FUNCTION_DELETE';