-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathmigrations.sql
45 lines (37 loc) · 5.03 KB
/
migrations.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
INSERT INTO hrms.roles(name) VALUES('ROLE_EMPLOYEE');
INSERT INTO hrms.roles(name) VALUES('ROLE_ADMIN');
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(1, 0, 50000, 'QUEBEC', 10, 10);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(2, 50001, 100000, 'QUEBEC', 12, 12);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(3, 100001, 200000, 'QUEBEC', 15, 15);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(4, 200001, 300000, 'QUEBEC', 20, 20);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(5, 300001, 999999, 'QUEBEC', 25, 25);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(6, 0, 50000, 'ONTARIO', 10, 10);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(7, 50001, 100000, 'ONTARIO', 12, 12);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(8, 100001, 200000, 'ONTARIO', 15, 15);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(9, 200001, 300000, 'ONTARIO', 20, 20);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(10, 300001, 999999, 'ONTARIO', 25, 25);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(11, 0, 50000, 'BRITISH_COLUMBIA', 10, 10);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(12, 50001, 100000, 'BRITISH_COLUMBIA', 12, 12);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(13, 100001, 200000, 'BRITISH_COLUMBIA', 15, 15);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(14, 200001, 300000, 'BRITISH_COLUMBIA', 20, 20);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(15, 300001, 999999, 'BRITISH_COLUMBIA', 25, 25);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(16, 0, 50000, 'ALBERTA', 10, 10);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(17, 50001, 100000, 'ALBERTA', 12, 12);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(18, 100001, 200000, 'ALBERTA', 15, 15);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(19, 200001, 300000, 'ALBERTA', 20, 20);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(20, 300001, 999999, 'ALBERTA', 25, 25);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(21, 0, 50000, 'NOVA_SCOTIA', 10, 10);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(22, 50001, 100000, 'NOVA_SCOTIA', 12, 12);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(23, 100001, 200000, 'NOVA_SCOTIA', 15, 15);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(24, 200001, 300000, 'NOVA_SCOTIA', 20, 20);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(25, 300001, 999999, 'NOVA_SCOTIA', 25, 25);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(26, 0, 50000, 'SASKATCHEWAN', 10, 10);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(27, 50001, 100000, 'SASKATCHEWAN', 12, 12);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(28, 100001, 200000, 'SASKATCHEWAN', 15, 15);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(29, 200001, 300000, 'SASKATCHEWAN', 20, 20);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(30, 300001, 999999, 'SASKATCHEWAN', 25, 25);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(31, 0, 50000, 'MANITOBA', 10, 10);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(32, 50001, 100000, 'MANITOBA', 12, 12);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(33, 100001, 200000, 'MANITOBA', 15, 15);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(34, 200001, 300000, 'MANITOBA', 20, 20);
INSERT INTO hrms.tax(id, tax_bracket_min, tax_bracket_max, province, province_tax, federal_tax) VALUES(35, 300001, 999999, 'MANITOBA', 25, 25);