BLmePX6B

1DROP TABLE IF EXISTS `cb_ba_rovat`;		
2DROP TABLE IF EXISTS `cb_ba_rovat_cofog`;
3DROP TABLE IF EXISTS `cb_ba_rovat_era`;
4DROP TABLE IF EXISTS `cb_ad_szakfeladat`;
5DROP TABLE IF EXISTS `cb_ba_governmental_function`;	
6DROP TABLE IF EXISTS `cb_ba_cofog_szakfeladat`;	
7DROP TABLE IF EXISTS `cb_ba_cofog_governmental_function`;
8DROP TABLE IF EXISTS `join_cb_ba_governmental_to_cb_ba_functional_area`;	
9DROP TABLE IF EXISTS `join_cb_ba_rovat_to_cb_ba_cofog`;	
10DROP TABLE IF EXISTS `join_cb_ba_rovat_to_cb_ba_pa_business_event`;	
11DROP TABLE IF EXISTS `join_cb_ba_szakfeladat_to_cb_ba_cofog`;	
12
13	
14DROP TABLE IF EXISTS `cb_ba_budgetline`;
15CREATE TABLE IF NOT EXISTS `cb_ba_budgetline` (
16  `bl_id` bigint(20) NOT NULL AUTO_INCREMENT,
17  `bl_code` varchar(255) NOT NULL,
18  `bl_type` varchar(255) NOT NULL,
19  `bl_is_detail_allowed` tinyint(1) NOT NULL,
20  `bl_is_required_by_law` tinyint(1) NOT NULL,
21  `bl_name` varchar(255) NOT NULL,
22  `bl_comment` text,
23  `active` tinyint(1) NOT NULL,
24  `inactivation_date` date DEFAULT NULL,
25  `inactivation_reason` varchar(255) DEFAULT NULL,
26  `valid_from` date NOT NULL,
27  `valid_to` date DEFAULT NULL,
28  `created` datetime NOT NULL,
29  `creator` varchar(255) NOT NULL,
30  `updated` datetime DEFAULT NULL,
31  `updater` varchar(255) DEFAULT NULL,
32  `version` bigint(20) NOT NULL,
33  PRIMARY KEY (`bl_id`)
34) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
35
36
37DROP TABLE IF EXISTS `cb_ba_cofog`;
38CREATE TABLE IF NOT EXISTS `cb_ba_cofog` (
39  `cofog_id` bigint(20) NOT NULL AUTO_INCREMENT,
40  `cofog_code` varchar(255) NOT NULL,
41  `cofog_is_detail_allowed` tinyint(1) NOT NULL,
42  `cofog_is_required_by_law` tinyint(1) NOT NULL,
43  `cofog_name` varchar(255) NOT NULL,
44  `cofog_comment` text,
45  `active` tinyint(1) NOT NULL,
46  `inactivation_date` date DEFAULT NULL,
47  `inactivation_reason` varchar(255) DEFAULT NULL,
48  `valid_from` date NOT NULL,
49  `valid_to` date DEFAULT NULL,
50  `created` datetime NOT NULL,
51  `creator` varchar(255) NOT NULL,
52  `updated` datetime DEFAULT NULL,
53  `updater` varchar(255) DEFAULT NULL,
54  `version` bigint(20) NOT NULL,
55  PRIMARY KEY (`cofog_id`)
56) ENGINE=InnoDB AUTO_INCREMENT=641 DEFAULT CHARSET=utf8;
57
58
59DROP TABLE IF EXISTS `cb_ba_era`;
60CREATE TABLE IF NOT EXISTS `cb_ba_era` (
61  `era_id` bigint(20) NOT NULL AUTO_INCREMENT,
62  `era_code` varchar(255) NOT NULL,
63  `era_type` varchar(255) NOT NULL,
64  `era_is_detail_allowed` tinyint(1) NOT NULL,
65  `era_is_required_by_law` tinyint(1) NOT NULL,
66  `era_name` varchar(255) NOT NULL,
67  `active` tinyint(1) NOT NULL,
68  `era_comment` text,
69  `bl_id` bigint(20) DEFAULT 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 (`era_id`),
80  KEY `FK_cb_ba_era_cb_ba_rubric` (`bl_id`),
81  CONSTRAINT `FK_cb_ba_era_cb_ba_budgetline` FOREIGN KEY (`bl_id`) REFERENCES `cb_ba_budgetline` (`bl_id`)
82) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
83	
84	
85DROP TABLE IF EXISTS `cb_ba_budget_activity`;
86CREATE TABLE IF NOT EXISTS `cb_ba_budget_activity` (
87  `ba_id` bigint(20) NOT NULL AUTO_INCREMENT,
88  `ba_code` varchar(255) NOT NULL,
89  `ba_is_detail_allowed` tinyint(1) NOT NULL,
90  `ba_is_required_by_law` tinyint(1) NOT NULL,
91  `ba_name` varchar(255) NOT NULL,
92  `active` tinyint(1) NOT NULL,
93  `ba_comment` text,
94  `inactivation_date` date DEFAULT NULL,
95  `inactivation_reason` varchar(255) DEFAULT NULL,
96  `valid_from` date NOT NULL,
97  `valid_to` date DEFAULT NULL,
98  `created` datetime NOT NULL,
99  `creator` varchar(255) NOT NULL,
100  `updated` datetime DEFAULT NULL,
101  `updater` varchar(255) DEFAULT NULL,
102  `version` bigint(20) NOT NULL,
103  PRIMARY KEY (`ba_id`)
104) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
105
106	
107
108DROP TABLE IF EXISTS `cb_ba_functional_area`;
109CREATE TABLE IF NOT EXISTS `cb_ba_functional_area` (
110  `fa_id` bigint(20) NOT NULL AUTO_INCREMENT,
111  `fa_name` varchar(255) NOT NULL,
112  `fa_code` varchar(255) NOT NULL,
113  `fa_is_detail_allowed` tinyint(4) NOT NULL,
114  `fa_is_required_by_law` tinyint(4) NOT NULL,
115  `fa_comment` varchar(255) DEFAULT NULL,
116  `gf_id` bigint(20) NOT NULL,
117  `active` tinyint(4) NOT NULL,
118  `valid_from` date NOT NULL,
119  `valid_to` date DEFAULT NULL,
120  `created` datetime NOT NULL,
121  `creator` varchar(255) NOT NULL,
122  `updated` datetime DEFAULT NULL,
123  `updater` varchar(255) DEFAULT NULL,
124  `version` bigint(20) NOT NULL,
125  PRIMARY KEY (`fa_id`),
126  KEY `FK_cb_ba_functional_area_cb_ba_governmental_function` (`gf_id`),
127  CONSTRAINT `FK_cb_ba_functional_area_cb_ba_governmental_function` FOREIGN KEY (`gf_id`) REFERENCES `cb_ba_governmental_function` (`gf_id`)
128) ENGINE=InnoDB DEFAULT CHARSET=utf8;
129
130
131
132
133DROP TABLE IF EXISTS `cb_ba_pa_business_event`;
134CREATE TABLE IF NOT EXISTS `cb_ba_pa_business_event` (
135  `pabe_id` bigint(20) NOT NULL AUTO_INCREMENT,
136  `pabe_code` varchar(255) NOT NULL,
137  `pabe_is_appropriation_related` tinyint(1) NOT NULL,
138  `pabe_is_commitment_related` tinyint(1) NOT NULL,
139  `pabe_is_current_year_only` tinyint(1) NOT NULL DEFAULT '0',
140  `pabe_name` varchar(255) NOT NULL,
141  `pabe_comment` text,
142  `active` tinyint(1) NOT NULL,
143  `inactivation_date` date DEFAULT NULL,
144  `inactivation_reason` varchar(255) DEFAULT NULL,
145  `valid_from` date NOT NULL,
146  `valid_to` date DEFAULT NULL,
147  `created` datetime NOT NULL,
148  `creator` varchar(255) NOT NULL,
149  `updated` datetime DEFAULT NULL,
150  `updater` varchar(255) DEFAULT NULL,
151  `version` bigint(20) NOT NULL,
152  PRIMARY KEY (`pabe_id`)
153) ENGINE=InnoDB DEFAULT CHARSET=utf8;
154
155
156
157DROP TABLE IF EXISTS `cb_ba_pa_business_event_journal`;
158CREATE TABLE IF NOT EXISTS `cb_ba_pa_business_event_journal` (
159  `pabej_id` bigint(20) NOT NULL AUTO_INCREMENT,
160  `pabej_accounting_system` varchar(255) NOT NULL,
161  `pabej_jrnl_code` varchar(255) NOT NULL,
162  `pabe_id` bigint(20) NOT NULL,
163  `fisy_id` bigint(20) DEFAULT NULL,
164  `active` tinyint(1) NOT NULL,
165  `inactivation_date` date DEFAULT NULL,
166  `inactivation_reason` varchar(255) DEFAULT NULL,
167  `valid_from` date NOT NULL,
168  `valid_to` date DEFAULT NULL,
169  `created` datetime NOT NULL,
170  `creator` varchar(255) NOT NULL,
171  `updated` datetime DEFAULT NULL,
172  `updater` varchar(255) DEFAULT NULL,
173  `version` bigint(20) NOT NULL,
174  PRIMARY KEY (`pabej_id`),
175  KEY `FK_cb_ba_pa_business_event_journal_cb_ba_pa_business_event` (`pabe_id`),
176  KEY `FK_cb_ba_pa_business_event_journal_cb_bd_fiscal_year` (`fisy_id`),
177  CONSTRAINT `FK_cb_ba_pa_business_event_journal_cb_ba_pa_business_event` FOREIGN KEY (`pabe_id`) REFERENCES `cb_ba_pa_business_event` (`pabe_id`),
178  CONSTRAINT `FK_cb_ba_pa_business_event_journal_cb_bd_fiscal_year` FOREIGN KEY (`fisy_id`) REFERENCES `cb_bd_fiscal_year` (`fisy_id`)
179) ENGINE=InnoDB DEFAULT CHARSET=utf8;
180
181
182
183DROP TABLE IF EXISTS `cb_ba_pa_business_event_tag`;
184CREATE TABLE IF NOT EXISTS `cb_ba_pa_business_event_tag` (
185  `pabet_id` bigint(20) NOT NULL AUTO_INCREMENT,
186  `pabet_tag` varchar(255) NOT NULL,
187  `pabe_id` bigint(20) NOT NULL,
188  `created` datetime NOT NULL,
189  `creator` varchar(255) NOT NULL,
190  `updated` datetime DEFAULT NULL,
191  `updater` varchar(255) DEFAULT NULL,
192  `version` bigint(20) NOT NULL,
193  PRIMARY KEY (`pabet_id`),
194  KEY `FK__cb_ba_pa_business_event` (`pabe_id`),
195  CONSTRAINT `FK__cb_ba_pa_business_event` FOREIGN KEY (`pabe_id`) REFERENCES `cb_ba_pa_business_event` (`pabe_id`)
196) ENGINE=InnoDB DEFAULT CHARSET=utf8;
197
198
199DROP TABLE IF EXISTS `cb_ba_pa_business_event_account`;
200CREATE TABLE IF NOT EXISTS `cb_ba_pa_business_event_account` (
201  `pabea_id` bigint(20) NOT NULL AUTO_INCREMENT,
202  `pabea_accounting_system` varchar(255) NOT NULL,
203  `pabea_account_source` varchar(255) NOT NULL,
204  `pabea_debit_credit` varchar(255) NOT NULL,
205  `pabea_booking_period` varchar(255) NOT NULL,
206  `pabea_value_type` varchar(255) NOT NULL,
207  `pabea_transaction_type` varchar(255) NOT NULL,
208  `pabea_is_repeatable` tinyint(1) NOT NULL DEFAULT '0',
209  `pabea_account_role` varchar(255) DEFAULT NULL,
210  `pabea_source_related_data` varchar(255) DEFAULT NULL,
211  `pabe_id` bigint(20) NOT NULL,
212  `fisy_id` bigint(20) DEFAULT NULL,
213  `created` datetime NOT NULL,
214  `creator` varchar(255) NOT NULL,
215  `updated` datetime DEFAULT NULL,
216  `updater` varchar(255) DEFAULT NULL,
217  `version` bigint(20) NOT NULL,
218  PRIMARY KEY (`pabea_id`),
219  KEY `FK_cb_ba_pa_business_event_account_cb_ba_pa_business_event` (`pabe_id`),
220  KEY `FK_cb_ba_pa_business_event_account_cb_bd_fiscal_year` (`fisy_id`),
221  CONSTRAINT `FK_cb_ba_pa_business_event_account_cb_ba_pa_business_event` FOREIGN KEY (`pabe_id`) REFERENCES `cb_ba_pa_business_event` (`pabe_id`),
222  CONSTRAINT `FK_cb_ba_pa_business_event_account_cb_bd_fiscal_year` FOREIGN KEY (`fisy_id`) REFERENCES `cb_bd_fiscal_year` (`fisy_id`)
223) ENGINE=InnoDB DEFAULT CHARSET=utf8;
224
225
226
227DROP TABLE IF EXISTS `cb_ba_pa_business_event_budget_line_role`;
228CREATE TABLE IF NOT EXISTS `cb_ba_pa_business_event_budget_line_role` (
229  `pabebl_id` bigint(20) NOT NULL AUTO_INCREMENT,
230  `pabe_id` bigint(20) NOT NULL,
231  `bl_id` bigint(20) NOT NULL,
232  `pabebl_value_type` varchar(255) NOT NULL,
233  `created` datetime NOT NULL,
234  `creator` varchar(255) NOT NULL,
235  `updated` datetime DEFAULT NULL,
236  `updater` varchar(255) DEFAULT NULL,
237  `version` bigint(20) NOT NULL,
238  PRIMARY KEY (`pabebl_id`),
239  KEY `FK__cb_ba_pa_business_event_` (`pabe_id`),
240  KEY `FK__cb_ba_budgetline_` (`bl_id`),
241  CONSTRAINT `FK__cb_ba_budgetline_` FOREIGN KEY (`bl_id`) REFERENCES `cb_ba_budgetline` (`bl_id`),
242  CONSTRAINT `FK__cb_ba_pa_business_event_` FOREIGN KEY (`pabe_id`) REFERENCES `cb_ba_pa_business_event` (`pabe_id`)
243) ENGINE=InnoDB DEFAULT CHARSET=utf8;
244
245
246
247
248DROP TABLE IF EXISTS `join_cb_ba_budget_activity_to_cb_ba_functional_area`;
249CREATE TABLE IF NOT EXISTS `join_cb_ba_budget_activity_to_cb_ba_functional_area` (
250  `ba_id` bigint(20) DEFAULT NULL,
251  `fa_id` bigint(20) DEFAULT NULL,
252  KEY `FK__cb_ba_functional_area` (`fa_id`),
253  KEY `FK__cb_ba_budget_activity` (`ba_id`),
254  CONSTRAINT `FK__cb_ba_budget_activity` FOREIGN KEY (`ba_id`) REFERENCES `cb_ba_budget_activity` (`ba_id`),
255  CONSTRAINT `FK__cb_ba_functional_area` FOREIGN KEY (`fa_id`) REFERENCES `cb_ba_functional_area` (`fa_id`)
256) ENGINE=InnoDB DEFAULT CHARSET=utf8;
257
258
259DROP TABLE IF EXISTS `cb_ba_cofog_budget_activity`;
260CREATE TABLE IF NOT EXISTS `cb_ba_cofog_budget_activity` (
261  `cofogba_id` bigint(20) NOT NULL AUTO_INCREMENT,
262  `cofog_id` bigint(20) NOT NULL,
263  `ba_id` bigint(20) NOT NULL,
264  `valid_from` date NOT NULL,
265  `valid_to` date DEFAULT NULL,
266  `created` datetime NOT NULL,
267  `creator` varchar(255) NOT NULL,
268  `updated` datetime DEFAULT NULL,
269  `updater` varchar(255) DEFAULT NULL,
270  `version` bigint(20) NOT NULL,
271  PRIMARY KEY (`cofogba_id`),
272  KEY `FK_cb_ba_cofog_budget_activity_cb_ba_cofog` (`cofog_id`),
273  KEY `FK_cb_ba_cofog_budget_activity_cb_ba_ba` (`ba_id`),
274  CONSTRAINT `FK_cb_ba_cofog_ba_cb_ba_budget_activtiy` FOREIGN KEY (`ba_id`) REFERENCES `cb_ba_budget_activity` (`ba_id`),
275  CONSTRAINT `FK_cb_ba_cofog_ba_cb_ba_cofog` FOREIGN KEY (`cofog_id`) REFERENCES `cb_ba_cofog` (`cofog_id`)
276) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
277
278
279DROP TABLE IF EXISTS `cb_ba_budgetline_era`;
280CREATE TABLE IF NOT EXISTS `cb_ba_budgetline_era` (
281  `blera_id` bigint(20) NOT NULL AUTO_INCREMENT,
282  `bl_id` bigint(20) NOT NULL,
283  `era_id` bigint(20) NOT NULL,
284  `valid_from` date NOT NULL,
285  `valid_to` date DEFAULT NULL,
286  `created` datetime NOT NULL,
287  `creator` varchar(255) NOT NULL,
288  `updated` datetime DEFAULT NULL,
289  `updater` varchar(255) DEFAULT NULL,
290  `version` bigint(20) NOT NULL,
291  PRIMARY KEY (`blera_id`),
292  KEY `FK_cb_ba_budgetline_era_cb_ba_budgetline` (`bl_id`),
293  KEY `FK_cb_ba_budgetline_era_cb_ba_era` (`era_id`),
294  CONSTRAINT `FK_cb_ba_budgetline_era_cb_ba_budgetline` FOREIGN KEY (`bl_id`) REFERENCES `cb_ba_budgetline` (`bl_id`),
295  CONSTRAINT `FK_cb_ba_budgetline_era_cb_ba_era` FOREIGN KEY (`era_id`) REFERENCES `cb_ba_era` (`era_id`)
296) ENGINE=InnoDB DEFAULT CHARSET=utf8;
297
298
299
300DROP TABLE IF EXISTS `cb_ba_budgetline_cofog`;
301CREATE TABLE IF NOT EXISTS `cb_ba_budgetline_cofog` (
302  `blcofog_id` bigint(20) NOT NULL,
303  `bl_id` bigint(20) NOT NULL,
304  `cofog_id` bigint(20) NOT NULL,
305  `valid_from` date NOT NULL,
306  `valid_to` date DEFAULT NULL,
307  `created` datetime NOT NULL,
308  `creator` varchar(255) NOT NULL,
309  `updated` datetime DEFAULT NULL,
310  `updater` varchar(255) DEFAULT NULL,
311  `version` bigint(20) NOT NULL,
312  PRIMARY KEY (`blcofog_id`),
313  KEY `FK_cb_ba_budgetline_cofog_cb_ba_budgetline` (`bl_id`),
314  KEY `FK_cb_ba_budgetline_cofog_cb_ba_cofog` (`cofog_id`),
315  CONSTRAINT `FK_cb_ba_budgetline_cofog_cb_ba_budgetline` FOREIGN KEY (`bl_id`) REFERENCES `cb_ba_budgetline` (`bl_id`),
316  CONSTRAINT `FK_cb_ba_budgetline_cofog_cb_ba_cofog` FOREIGN KEY (`cofog_id`) REFERENCES `cb_ba_cofog` (`cofog_id`)
317) ENGINE=InnoDB DEFAULT CHARSET=utf8;
318
319
320
321
322
323UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='GOVERNMENTAL_FUNCTION_CREATE' WHERE  `pe_code`='SZAKFELADAT_CREATE';
324UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='GOVERNMENTAL_FUNCTION_UPDATE' WHERE  `pe_code`='SZAKFELADAT_UPDATE';
325UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='GOVERNMENTAL_FUNCTION_READ' WHERE  `pe_code`='SZAKFELADAT_READ';
326UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='GOVERNMENTAL_FUNCTION_DELETE' WHERE  `pe_code`='SZAKFELADAT_DELETE';	
327
328UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_LINE_CREATE' WHERE  `pe_code`='ROVAT_CREATE';
329UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_LINE_UPDATE' WHERE  `pe_code`='ROVAT_UPDATE';
330UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_LINE_READ' WHERE  `pe_code`='ROVAT_READ';
331UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_LINE_DELETE' WHERE  `pe_code`='ROVAT_DELETE';
332
333UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_ACTIVITY_CREATE' WHERE  `pe_code`='GOVERNMENTAL_FUNCTION_CREATE';
334UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_ACTIVITY_UPDATE' WHERE  `pe_code`='GOVERNMENTAL_FUNCTION_UPDATE';
335UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_ACTIVITY_READ' WHERE  `pe_code`='GOVERNMENTAL_FUNCTION_READ';
336UPDATE `cleanbook_master`.`cb_ad_permission` SET `pe_code`='BUDGET_ACTIVITY_DELETE' WHERE  `pe_code`='GOVERNMENTAL_FUNCTION_DELETE';