H2djrzij

1--
2-- FOR TASK 2486
3--
4ALTER TABLE `inv_types_finders_def` 
5CHANGE `group` `group` ENUM('TYPES_FINDER','TYPES_FINDER_DEMURRAGE','TYPES_FINDER_BOOKING','TYPES_FINDER_REBOOKING') 
6CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'TYPES_FINDER';
7
8INSERT INTO `inv_layouts_def` 
9(`code`, `valid_from`, `template_name`) 
10VALUES 
11('BLAYOUT1', '0001-01-01', 'blayout1'), 
12('CANCELLATION_BLAYOUT1', '0001-01-01', 'cancellation_blayout1'),
13('BLAYOUT2', '0001-01-01', 'blayout2'), 
14('CANCELLATION_BLAYOUT2', '0001-01-01', 'cancellation_blayout2'),
15('BLAYOUT3', '0001-01-01', 'blayout3'), 
16('CANCELLATION_BLAYOUT3', '0001-01-01', 'cancellation_blayout3'),
17('BLAYOUT4', '0001-01-01', 'blayout4'), 
18('CANCELLATION_BLAYOUT4', '0001-01-01', 'cancellation_blayout4'),
19('BLAYOUT5', '0001-01-01', 'blayout5'), 
20('CANCELLATION_BLAYOUT5', '0001-01-01', 'cancellation_blayout5'),
21('BLAYOUT6', '0001-01-01', 'blayout6'), 
22('CANCELLATION_BLAYOUT6', '0001-01-01', 'cancellation_blayout6'),
23('BLAYOUT7', '0001-01-01', 'blayout7'), 
24('CANCELLATION_BLAYOUT7', '0001-01-01', 'cancellation_blayout7'),
25('RBLAYOUT1', '0001-01-01', 'rblayout1'), 
26('CANCELLATION_RBLAYOUT1', '0001-01-01', 'cancellation_rblayout1'),
27('RBLAYOUT2', '0001-01-01', 'rblayout2'), 
28('CANCELLATION_RBLAYOUT2', '0001-01-01', 'cancellation_rblayout2');
29
30INSERT INTO `inv_invoices_def` 
31(`invoice_code`, `valid_from`, `layout_code`, `calculation_code`) 
32VALUES 
33('BINVOICE1', '2016-01-01', 'BLAYOUT1', 'BCALCULATION1'),
34('CANCELLATION_BINVOICE1', '2016-01-01', 'CANCELLATION_BLAYOUT1', 'CANCELLATION_CALCULATION'),
35('BINVOICE2', '2016-01-01', 'BLAYOUT2', 'BCALCULATION2'),
36('CANCELLATION_BINVOICE2', '2016-01-01', 'CANCELLATION_BLAYOUT2', 'CANCELLATION_CALCULATION'),
37('BINVOICE3', '2016-01-01', 'BLAYOUT3', 'BCALCULATION1'),
38('CANCELLATION_BINVOICE3', '2016-01-01', 'CANCELLATION_BLAYOUT3', 'CANCELLATION_CALCULATION'),
39('BINVOICE4', '2016-01-01', 'BLAYOUT4', 'BCALCULATION2'),
40('CANCELLATION_BINVOICE4', '2016-01-01', 'CANCELLATION_BLAYOUT4', 'CANCELLATION_CALCULATION'),
41('BINVOICE5', '2016-01-01', 'BLAYOUT5', 'BCALCULATION1'),
42('CANCELLATION_BINVOICE5', '2016-01-01', 'CANCELLATION_BLAYOUT5', 'CANCELLATION_CALCULATION'),
43('BINVOICE6', '2016-01-01', 'BLAYOUT6', 'BCALCULATION2'),
44('CANCELLATION_BINVOICE6', '2016-01-01', 'CANCELLATION_BLAYOUT6', 'CANCELLATION_CALCULATION'),
45('BINVOICE7', '2016-01-01', 'BLAYOUT7', 'BCALCULATION3'),
46('CANCELLATION_BINVOICE7', '2016-01-01', 'CANCELLATION_BLAYOUT7', 'CANCELLATION_CALCULATION'),
47('RBINVOICE1', '2016-01-01', 'RBLAYOUT1', 'BCALCULATION1'),
48('CANCELLATION_RBINVOICE1', '2016-01-01', 'CANCELLATION_RBLAYOUT1', 'CANCELLATION_CALCULATION'),
49('RBINVOICE2', '2016-01-01', 'RBLAYOUT2', 'BCALCULATION2'),
50('CANCELLATION_RBINVOICE2', '2016-01-01', 'CANCELLATION_RBLAYOUT2', 'CANCELLATION_CALCULATION');
51
52INSERT INTO `inv_invoices_pairs` 
53(`regular_invoice`, `cancellation_invoice`) 
54VALUES 
55('BINVOICE1', 'CANCELLATION_BINVOICE1'),
56('BINVOICE2', 'CANCELLATION_BINVOICE2'),
57('BINVOICE3', 'CANCELLATION_BINVOICE3'),
58('BINVOICE4', 'CANCELLATION_BINVOICE4'),
59('BINVOICE5', 'CANCELLATION_BINVOICE5'),
60('BINVOICE6', 'CANCELLATION_BINVOICE6'),
61('BINVOICE7', 'CANCELLATION_BINVOICE7'),
62('RBINVOICE1', 'CANCELLATION_RBINVOICE1'),
63('RBINVOICE2', 'CANCELLATION_RBINVOICE2');
64
65INSERT INTO `inv_invoices` 
66(`name`, `code`, `description`) 
67VALUES 
68('bi1', 'BINVOICE1', 'Netto-Rechnung EU'),
69('bc1', 'CANCELLATION_BINVOICE1', 'Storno-Netto-Rechnung EU'),
70('bi2', 'BINVOICE2', 'Brutto-Rechnung EU'),
71('bc2', 'CANCELLATION_BINVOICE2', 'Storno-Brutto-Rechnung EU'),
72('bi3', 'BINVOICE3', 'Netto-Rechnung Drittland'),
73('bc3', 'CANCELLATION_BINVOICE3', 'Storno-Netto-Rechnung Drittland'),
74('bi4', 'BINVOICE4', 'Brutto-Rechnung Drittland'),
75('bc4', 'CANCELLATION_BINVOICE4', 'Storno-Brutto-Rechnung Drittland'),
76('bi5', 'BINVOICE5', 'Netto-Rechnung DE'),
77('bc5', 'CANCELLATION_BINVOICE5', 'Storno-Netto-Rechnung DE'),
78('bi6', 'BINVOICE6', 'Brutto-Rechnung DE'),
79('bc6', 'CANCELLATION_BINVOICE6', 'Storno-Brutto-Rechnung DE'),
80('bi7', 'BINVOICE7', '§25a-Rechnung DE EU'),
81('bc7', 'CANCELLATION_BINVOICE7', 'Storno-§25a-Rechnung DE EU'),
82('rbi1', 'RBINVOICE1', 'Netto-Rechnung DE'),
83('rbc1', 'CANCELLATION_RBINVOICE1', 'Storno-Netto-Rechnung DE'),
84('rbi2', 'RBINVOICE2', 'Brutto-Rechnung DE'),
85('rbc2', 'CANCELLATION_RBINVOICE2', 'Storno-brutto-Rechnung DE');
86
87INSERT INTO `inv_calculations_def` 
88(`code`, `valid_from`, `class_name`) 
89VALUES 
90('BCALCULATION1', '2016-01-01', 'BCalculation1_1'),
91('BCALCULATION2', '2016-01-01', 'BCalculation2_1'),
92('BCALCULATION3', '2016-01-01', 'BCalculation3_1');
93
94ALTER TABLE `inv_types_finders_def` DROP INDEX `valid_from`;
95
96ALTER TABLE `inv_types_finders_def` ADD UNIQUE KEY `UK_inv_types_finders_def` (`valid_from`, `group`);
97
98INSERT INTO `inv_types_finders_def` 
99(`valid_from`, `type`, `group`, `name`) 
100VALUES 
101('2018-02-01', 'JAVA', 'TYPES_FINDER_BOOKING', 'TFBooking1'), 
102('2018-02-02', 'JAVA', 'TYPES_FINDER_REBOOKING', 'TFRebooking1');
103
104INSERT INTO `inv_parameters` 
105(`id`, `name`, `type`, `group_name`, `description`) 
106VALUES 
107('185', 'Ptax_id', 'STRING', 'car', ''),
108('186', 'GPwe_de_regular_net', 'STRING', 'global', ''),
109('187', 'GPwe_de_regular_tax', 'STRING', 'global', ''),
110('188', 'GPwe_re_de_regular_net', 'STRING', 'global', ''),
111('189', 'GPwe_re_de_regular_tax', 'STRING', 'global', ''),
112('190', 'GPwe_de_eu_diff', 'STRING', 'global', ''),
113('191', 'GPwe_3rd_regular_net', 'STRING', 'global', ''),
114('192', 'GPwe_eu_regular_net', 'STRING', 'global', ''),
115('193', 'GPwe_eu_regular_tax', 'STRING', 'global', ''),
116('194', 'GPwe_eu_regular_notional_tax', 'STRING', 'global', ''),
117('195', 'Psupplier_name', 'STRING', 'car', ''),
118('196', 'Psupplier_address', 'STRING', 'car', ''),
119('197', 'Psupplier_countries_group', 'ENUM', 'car', ''),
120('198', 'Pdate_incoming_invoice', 'DATE', 'car', '');
121
122INSERT INTO `inv_parameters_global` 
123(`parameter_id`, `valid_from`, `value`) 
124VALUES 
125('186', '0001-01-01', '3349'),
126('187', '0001-01-01', '1546'),
127('188', '0001-01-01', '3420'),
128('189', '0001-01-01', '1576'),
129('190', '0001-01-01', '3210'),
130('191', '0001-01-01', '3559'),
131('192', '0001-01-01', '3426'),
132('193', '0001-01-01', '1574'),
133('194', '0001-01-01', '1774');
134
135CREATE TABLE IF NOT EXISTS `inv_booking` (
136  `id` int(11) NOT NULL AUTO_INCREMENT,
137  `car_id` int(11) NOT NULL,
138  `invoice_id` int(11) NOT NULL,
139  `booking_id` int(11),
140  `rebooking_id` int(11),
141  PRIMARY KEY (`id`)
142) ENGINE=NDBCLUSTER DEFAULT CHARSET=utf8;
143
144ALTER TABLE `inv_bills` 
145ADD  `car_vin` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER  `car_id` ;
146
147CREATE INDEX `inv_bills_car_vin_index` ON `inv_bills`(`car_vin`);
148CREATE INDEX `inv_booking_car_id` ON `inv_booking`(`car_id`);
149CREATE INDEX `inv_booking_invoice_id` ON `inv_booking`(`invoice_id`);
150CREATE INDEX `inv_booking_booking_id` ON `inv_booking`(`booking_id`);
151CREATE INDEX `inv_booking_rebooking_id` ON `inv_booking`(`rebooking_id`);
152--
153-- FOR TASK 2486 END
154--