· 6 years ago · Jun 05, 2019, 04:28 PM
1
2create table ST_PAZIME (
3 PAZIME_TYPE VARCHAR(10),
4 DESCR VARCHAR(200),
5 VERSION int,
6 PRIMARY KEY (PAZIME_TYPE)
7);
8ALTER TABLE ST_PAZIME ENGINE=INNODB;
9ALTER TABLE `ST_PAZIME` ADD INDEX(
10 `PAZIME_TYPE`);
11
12create table ST_PAZIME_VERTIBA (
13 PAZIME_TYPE VARCHAR(10),
14 PAZIME_TYPE_VERTIBA VARCHAR(10),
15 PAZIME_VERTIBA VARCHAR(20),
16 DATE_VERTIBA DATE,
17 INT_VERTIBA int,
18 SEARCH_PAZIME_VERTIBA VARCHAR(200),
19 DESCR VARCHAR(200),
20 VERSION int
21);
22
23create table ST_PAZIME_AF(
24 PAZIME_TYPE VARCHAR(10),
25 AFFILIATION VARCHAR(200)
26);
27ALTER TABLE ST_PAZIME_AF ENGINE=INNODB;
28ALTER TABLE `ST_PAZIME_AF` ADD INDEX(
29 `PAZIME_TYPE`);
30
31
32ALTER TABLE ST_PAZIME_VERTIBA ENGINE=INNODB;
33ALTER TABLE `ST_PAZIME_VERTIBA` ADD INDEX(
34 `PAZIME_TYPE`);
35
36create table CL_PERSON (
37 KLIENTS_ID int NOT NULL AUTO_INCREMENT,
38 COUNTRY VARCHAR(4),
39 CREATION_DATE DATE,
40 VERSION int,
41 PRIMARY KEY (KLIENTS_ID)
42);
43ALTER TABLE CL_PERSON ENGINE=INNODB;
44ALTER TABLE `CL_PERSON` ADD INDEX(
45 `KLIENTS_ID`);
46
47create table CL_KLIENTS_CH (
48 KLIENTS_ID int NOT NULL,
49 PAZIME_TYPE VARCHAR(10),
50 PAZIME_VERTIBA VARCHAR(20),
51 DATE_VERTIBA DATE,
52 INT_VERTIBA int,
53 SEARCH_PAZIME_VERTIBA VARCHAR(200),
54 E_DATE DATE
55 );
56 ALTER TABLE CL_KLIENTS_CH ENGINE=INNODB;
57 ALTER TABLE `CL_KLIENTS_CH` ADD INDEX(
58 `KLIENTS_ID`);
59
60create table CL_ACCOUNT (
61 KONTS_ID int NOT NULL AUTO_INCREMENT,
62 CUSTOMER_CLASS VARCHAR(200),
63 VERSION int,
64 PRIMARY KEY (KONTS_ID)
65);
66
67ALTER TABLE CL_ACCOUNT ENGINE=INNODB;
68ALTER TABLE `CL_ACCOUNT` ADD INDEX(
69 `KONTS_ID`);
70
71create table CL_AP (
72 KLIENTS_ID int NOT NULL,
73 KONTS_ID int NOT NULL,
74 PRIMARY_ACCOUNT VARCHAR(5),
75 VERSION int
76);
77ALTER TABLE CL_AP ENGINE=INNODB;
78ALTER TABLE `CL_AP` ADD INDEX(
79 `KLIENTS_ID`);
80
81
82create table PR_PRODUCT (
83 PRODUCT_TYPE VARCHAR(20),
84 DESCRIPTION VARCHAR(200),
85 START_DATE DATE,
86 END_DATE DATE,
87 VERSION int
88);
89ALTER TABLE PR_PRODUCT ENGINE=INNODB;
90ALTER TABLE `PR_PRODUCT` ADD INDEX(
91 `PRODUCT_TYPE`);
92
93create table PR_PRODUCT_OWNR (
94 PRD_ID INT NOT NULL AUTO_INCREMENT,
95 PRODUCT_TYPE VARCHAR(20),
96 KONTS_ID int NOT NULL,
97 VERSION int,
98 PRIMARY KEY (PRD_ID)
99);
100ALTER TABLE PR_PRODUCT_OWNR ENGINE=INNODB;
101ALTER TABLE `PR_PRODUCT_OWNR` ADD INDEX(
102 `PRD_ID`);
103
104create table Students (
105 vards VARCHAR(200),
106 uzvards VARCHAR(200),
107 apliecibas_nr VARCHAR(20)
108);
109ALTER TABLE Students ENGINE=INNODB;
110
111INSERT INTO Students
112SELECT 'RŪDOLFS MATĪSS','MIĶELSONS','171RDC024' FROM DUAL;
113INSERT INTO Students
114SELECT 'RAIMONDS','SIMANOVIČS','171RDC025' FROM DUAL;
115
116ALTER TABLE `CL_AP`
117 ADD CONSTRAINT `cl_ap_ibfk_1` FOREIGN KEY (`KONTS_ID`) REFERENCES `CL_ACCOUNT` (`KONTS_ID`);
118
119ALTER TABLE `CL_AP`
120 ADD CONSTRAINT `cl_ap_ibfk_2` FOREIGN KEY (`KLIENTS_ID`) REFERENCES `CL_PERSON` (`KLIENTS_ID`);
121
122 ALTER TABLE `ST_PAZIME_AF`
123 ADD CONSTRAINT `ST_PAZIME_AF_ibfk_1` FOREIGN KEY (`PAZIME_TYPE`) REFERENCES `ST_PAZIME` (`PAZIME_TYPE`);
124
125
126ALTER TABLE `ST_PAZIME_VERTIBA`
127 ADD CONSTRAINT `ST_PAZIME_VERTIBA_ibfk_1` FOREIGN KEY (`PAZIME_TYPE`) REFERENCES `ST_PAZIME` (`PAZIME_TYPE`);
128
129
130ALTER TABLE `PR_PRODUCT_OWNR`
131 ADD CONSTRAINT `PR_PO_ibfk_1` FOREIGN KEY (`PRODUCT_TYPE`) REFERENCES `PR_PRODUCT` (`PRODUCT_TYPE`);
132
133ALTER TABLE `PR_PRODUCT_OWNR`
134 ADD CONSTRAINT `PR_PO_ibfk_2` FOREIGN KEY (`KONTS_ID`) REFERENCES `CL_ACCOUNT` (`KONTS_ID`);
135
136ALTER TABLE `CL_KLIENTS_CH`
137 ADD CONSTRAINT `CL_KLIENTS_CH_ibfk_2` FOREIGN KEY (`KLIENTS_ID`) REFERENCES `CL_PERSON` (`KLIENTS_ID`);
138
139 ALTER TABLE `PR_PRODUCT_CH`
140 ADD CONSTRAINT `PR_PRODUCT_CH_ibfk_1` FOREIGN KEY (`PRD_ID`) REFERENCES `PR_PRODUCT_OWNR` (`PRD_ID`);
141-- /
142-- delimiter |
143--
144-- CREATE or replace TRIGGER trgr_KLIENTS_ins AFTER INSERT ON CL_PERSON
145-- FOR EACH ROW
146-- BEGIN
147-- INSERT INTO ST_AUDIT (/*AUDIT_ID, */TBL_NAME, ACTION, FIELD, B_VERTIBA_VAR, B_VERTIBA_DATE, A_VERTIBA_VAR, A_VERTIBA_DATE, VERSION, EFFECTIVE_DATE)
148-- values ('CL_PERSON', 'I', NULL, NULL, NULL, new.KLIENTS_id, NULL, 1, CURRENT_TIMESTAMP);
149-- END;
150-- |
151--
152-- delimiter ;
153--
154-- delimiter |
155--
156-- CREATE or replace TRIGGER trgr_KLIENTS_upd AFTER update ON CL_PERSON
157-- FOR EACH ROW
158-- BEGIN
159-- IF OLD.COUNTRY <> NEW.COUNTRY THEN
160-- INSERT INTO ST_AUDIT (/*AUDIT_ID, */TBL_NAME, ACTION, FIELD, P_KEY, B_VERTIBA_VAR, B_VERTIBA_DATE, A_VERTIBA_VAR, A_VERTIBA_DATE, VERSION, EFFECTIVE_DATE)
161-- SELECT 'CL_PERSON', 'U', NULL, new.KLIENTS_id, OLD.COUNTRY, NULL, NEW.COUNTRY, NULL, 1, CURRENT_TIMESTAMP FROM DUAL;
162--
163-- END IF;
164-- IF OLD.CREATION_DATE <> NEW.CREATION_DATE THEN
165-- INSERT INTO ST_AUDIT (/*AUDIT_ID, */TBL_NAME, ACTION, FIELD, P_KEY, B_VERTIBA_VAR, B_VERTIBA_DATE, A_VERTIBA_VAR, A_VERTIBA_DATE, VERSION, EFFECTIVE_DATE)
166-- SELECT 'CL_PERSON', 'U', NULL, new.KLIENTS_id, OLD.CREATION_DATE, NULL, NEW.CREATION_DATE, NULL, 1, CURRENT_TIMESTAMP FROM DUAL;
167-- END IF;
168-- END;
169-- |
170--
171-- delimiter ;
172--
173-- delimiter |
174--
175-- CREATE or replace TRIGGER trgr_KONTS_ins AFTER INSERT ON CL_ACCOUNT
176-- FOR EACH ROW
177-- BEGIN
178-- INSERT INTO ST_AUDIT (/*AUDIT_ID, */TBL_NAME, ACTION, FIELD, B_VERTIBA_VAR, B_VERTIBA_DATE, A_VERTIBA_VAR, A_VERTIBA_DATE, VERSION, EFFECTIVE_DATE)
179-- values ('CL_ACCOUNT', 'I', NULL, NULL, NULL, new.KONTS_ID, NULL, 1, CURRENT_TIMESTAMP);
180-- END;
181-- |
182--
183-- delimiter ;
184--
185-- delimiter |
186--
187-- CREATE or replace TRIGGER trgr_KONTS_upd AFTER update ON CL_ACCOUNT
188-- FOR EACH ROW
189-- BEGIN
190-- IF OLD.CUSTOMER_CLASS <> NEW.CUSTOMER_CLASS THEN
191-- INSERT INTO ST_AUDIT (/*AUDIT_ID, */TBL_NAME, ACTION, FIELD, P_KEY, B_VERTIBA_VAR, B_VERTIBA_DATE, A_VERTIBA_VAR, A_VERTIBA_DATE, VERSION, EFFECTIVE_DATE)
192-- SELECT 'CL_ACCOUNT', 'U', NULL, new.KONTS_ID, OLD.CUSTOMER_CLASS, NULL, NEW.CUSTOMER_CLASS, NULL, 1, CURRENT_TIMESTAMP FROM DUAL;
193--
194-- END IF;
195-- END;
196-- |
197--
198-- delimiter ;
199--
200--
201
202insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
203select 'LRGE','Large customer', 1 from dual;
204
205insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
206select 'SMALL','Small customer', 1 from dual;
207
208insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
209select 'LTERM','Long term customer', 1 from dual;
210
211insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
212select 'FROZEN','Frozen Account', 1 from dual;
213
214insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
215select 'STRT_DT','Start Date', 1 from dual;
216
217insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
218select 'END_DT','End Date', 1 from dual;
219
220insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
221select 'LOCATION','Location', 1 from dual;
222
223insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
224select 'PHONE','Phone number', 1 from dual;
225
226insert into ST_PAZIME (PAZIME_TYPE, DESCR, VERSION)
227select 'PRDSIZE','Product Size', 1 from dual;
228
229
230
231
232
233insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
234select 'LRGE','PERSON' from dual;
235
236insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
237select 'SMALL','PERSON' from dual;
238
239insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
240select 'LTERM','PERSON' from dual;
241
242insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
243select 'PHONE','PERSON' from dual;
244
245insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
246select 'FROZEN','ACCOUNT' from dual;
247
248insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
249select 'STRT_DT','PRODUCT' from dual;
250
251insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
252select 'END_DT','PRODUCT' from dual;
253
254insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
255select 'LOCATION','PRODUCT' from dual;
256
257insert into ST_PAZIME_AF (PAZIME_TYPE, AFFILIATION)
258select 'PRDSIZE','PRODUCT' from dual;
259
260
261insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
262select 'LRGE', NULL, 'Y', NULL, NULL,'Y','Yes', 1 from dual;
263insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
264select 'LRGE', NULL, 'N', NULL, NULL,'N','No', 1 from dual;
265
266insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
267select 'SMALL', NULL, 'Y', NULL, NULL,'Y','Yes', 1 from dual;
268insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
269select 'SMALL', NULL, 'N', NULL, NULL,'N','No', 1 from dual;
270
271insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
272select 'LTERM', NULL, 'Y', NULL, NULL,'Y','Yes', 1 from dual;
273
274insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
275select 'FROZEN', NULL, 'Y', NULL, NULL,'Y','Yes', 1 from dual;
276
277insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
278select 'PRDSIZE', NULL, 'SP', NULL, NULL,'SP','0-200 Sale', 1 from dual;
279insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
280select 'PRDSIZE', NULL, 'MP', NULL, NULL,'MP','200-1000 Sale', 1 from dual;
281insert into ST_PAZIME_VERTIBA (PAZIME_TYPE, PAZIME_TYPE_VERTIBA, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, DESCR, VERSION)
282select 'PRDSIZE', NULL, 'BP', NULL, NULL,'BP','+1000 Sale', 1 from dual;
283
284insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
285select 'LV', CURDATE()-10, 2000 from dual;
286insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
287select 'LV', CURDATE()-100, 2000 from dual;
288insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
289select 'EE', CURDATE()-3, 2000 from dual;
290insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
291select 'EE', CURDATE()-1, 2000 from dual;
292insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
293select 'LT', CURDATE()-10, 2000 from dual;
294insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
295select 'RUS', CURDATE()-20, 2000 from dual;
296insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
297select 'LV', CURDATE()-5, 2000 from dual;
298insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
299select 'EE', CURDATE()-70, 2000 from dual;
300select 'RUS', CURDATE()-13, 2000 from dual;
301insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
302select 'LV', CURDATE()-23, 2000 from dual;
303insert into CL_PERSON (COUNTRY, CREATION_DATE, VERSION)
304select 'EE', CURDATE()-33, 2000 from dual;
305
306
307insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
308select 'BUSINESS', 2000 from dual;
309insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
310select 'BUSINESS', 2000 from dual;
311insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
312select 'PRIVATE', 2000 from dual;
313insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
314select 'BUSINESS', 2000 from dual;
315insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
316select 'BUSINESS', 2000 from dual;
317insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
318select 'PRIVATE', 2000 from dual;
319insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
320select 'BUSINESS', 2000 from dual;
321insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
322select 'BUSINESS', 2000 from dual;
323insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
324select 'BUSINESS', 2000 from dual;
325insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
326select 'PRIVATE', 2000 from dual;
327insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
328select 'BUSINESS', 2000 from dual;
329insert into CL_ACCOUNT (CUSTOMER_CLASS, VERSION)
330select 'BUSINESS', 2000 from dual;
331
332
333insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
334select 1, 3, 'PRIM' from dual;
335insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
336select 1, 4, 'SEC' from dual;
337insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
338select 2, 5, 'PRIM' from dual;
339insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
340select 3, 1, 'PRIM' from dual;
341insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
342select 3, 2, 'SEC' from dual;
343insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
344select 4, 5, 'PRIM' from dual;
345insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
346select 4, 6, 'SEC' from dual;
347insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
348select 4, 7, 'SEC' from dual;
349insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
350select 4, 8, 'SEC' from dual;
351insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
352select 5, 9, 'PRIM' from dual;
353insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
354select 5, 10, 'SEC' from dual;
355insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
356select 5, 11, 'SEC' from dual;
357insert into CL_AP (KLIENTS_ID, KONTS_ID, PRIMARY_ACCOUNT)
358select 5, 12, 'SEC' from dual;
359
360insert into CL_KONTS_CH (KONTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
361select 1, 'FROZEN', 'YES', NULL, NULL,'YES', CURDATE()-1 from dual;
362insert into CL_KONTS_CH (KONTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
363select 5, 'FROZEN', 'YES', NULL, NULL,'YES', CURDATE()-2 from dual;
364insert into CL_KONTS_CH (KONTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
365select 7, 'FROZEN', 'YES', NULL, NULL,'YES', CURDATE()-3 from dual;
366insert into CL_KONTS_CH (KONTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
367select 10, 'FROZEN', 'YES', NULL, NULL,'YES', CURDATE()-4 from dual;
368
369
370insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
371select 1, 'LRGE', 'Y', NULL, NULL,'Y', CURDATE()-1 from dual;
372insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
373select 5, 'LRGE', 'Y', NULL, NULL,'Y', CURDATE()-2 from dual;
374insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
375select 7, 'SMALL', 'Y', NULL, NULL,'Y', CURDATE()-3 from dual;
376insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
377select 10, 'SMALL', 'N', NULL, NULL,'N', CURDATE()-4 from dual;
378insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
379select 1, 'LTERM', 'Y', NULL, NULL,'Y', CURDATE()-1 from dual;
380insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
381select 5, 'LTERM', 'Y', NULL, NULL,'Y', CURDATE()-2 from dual;
382insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
383select 7, 'PHONE', NULL, NULL, 25463758,25463758, CURDATE()-3 from dual;
384insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
385select 10, 'PHONE', NULL, NULL, 25463758,25463758, CURDATE()-4 from dual;
386insert into CL_KLIENTS_CH (KLIENTS_ID, PAZIME_TYPE, PAZIME_VERTIBA, DATE_VERTIBA, INT_VERTIBA, SEARCH_PAZIME_VERTIBA, E_DATE)
387select 10, 'PHONE', NULL, NULL, 25463758,25463758, CURDATE()-4 from dual;
388
389
390/*FOR TESTING PURPOSES*/
391
392SELECT * FROM CL_ACCOUNT A
393 WHERE 1=1
394 AND EXISTS (SELECT 1 FROM CL_AP AP, CL_KLIENTS_CH CH
395 WHERE A.KONTS_ID = AP.KONTS_ID
396 AND AP.KLIENTS_ID = CH.KLIENTS_ID
397 AND PAZIME_TYPE = 'LRGE'
398 AND PAZIME_VERTIBA = 'Y')