hALvPer7

152 queries executed, 43 success, 9 errors, 1 warnings
2
3Query: drop table if exists cashreceiptitem_rpt_noledger
4
50 row(s) affected
6
7Execution Time : 0.428 sec
8Transfer Time  : 0.004 sec
9Total Time     : 0.432 sec
10-----------------------------------------------------------
11
12Query: drop table if exists cashreceiptitem_rpt
13
140 row(s) affected
15
16Execution Time : 0.154 sec
17Transfer Time  : 0.001 sec
18Total Time     : 0.155 sec
19-----------------------------------------------------------
20
21Query: drop table if exists rptledger_payment_share
22
230 row(s) affected
24
25Execution Time : 0.119 sec
26Transfer Time  : 0.001 sec
27Total Time     : 0.120 sec
28-----------------------------------------------------------
29
30Query: drop table if exists rptledger_payment_item
31
320 row(s) affected
33
34Execution Time : 0.101 sec
35Transfer Time  : 0.004 sec
36Total Time     : 0.105 sec
37-----------------------------------------------------------
38
39Query: drop table if exists rptledger_payment
40
410 row(s) affected
42
43Execution Time : 0.080 sec
44Transfer Time  : 0.001 sec
45Total Time     : 0.082 sec
46-----------------------------------------------------------
47
48Query: CREATE TABLE `rptledger_payment` ( `objid` varchar(100) NOT NULL, `rptledgerid` varchar(50) NOT NULL, `type` varchar(20) NOT NUL...
49
500 row(s) affected
51
52Execution Time : 0.301 sec
53Transfer Time  : 0.002 sec
54Total Time     : 0.304 sec
55-----------------------------------------------------------
56
57Query: create index `fk_rptledger_payment_rptledger` on rptledger_payment(`rptledgerid`) using btree
58
590 row(s) affected
60
61Execution Time : 0.458 sec
62Transfer Time  : 0.002 sec
63Total Time     : 0.461 sec
64-----------------------------------------------------------
65
66Query: create index `fk_rptledger_payment_cashreceipt` on rptledger_payment(`receiptid`) using btree
67
680 row(s) affected
69
70Execution Time : 0.424 sec
71Transfer Time  : 0.004 sec
72Total Time     : 0.428 sec
73-----------------------------------------------------------
74
75Query: create index `ix_receiptno` on rptledger_payment(`receiptno`) using btree
76
770 row(s) affected
78
79Execution Time : 0.519 sec
80Transfer Time  : 0.002 sec
81Total Time     : 0.521 sec
82-----------------------------------------------------------
83
84Query: alter table rptledger_payment add constraint `fk_rptledger_payment_cashreceipt` foreign key (`receiptid`) references `cashreceip...
85
860 row(s) affected
87
88Execution Time : 0.366 sec
89Transfer Time  : 0.003 sec
90Total Time     : 0.369 sec
91-----------------------------------------------------------
92
93Query: alter table rptledger_payment add constraint `fk_rptledger_payment_rptledger` foreign key (`rptledgerid`) references `rptledger`...
94
950 row(s) affected
96
97Execution Time : 0.430 sec
98Transfer Time  : 0.002 sec
99Total Time     : 0.433 sec
100-----------------------------------------------------------
101
102Query: CREATE TABLE `rptledger_payment_item` ( `objid` varchar(50) NOT NULL, `parentid` varchar(100) NOT NULL, `rptledgerfaasid` varcha...
103
1040 row(s) affected
105
106Execution Time : 0.144 sec
107Transfer Time  : 0.007 sec
108Total Time     : 0.152 sec
109-----------------------------------------------------------
110
111Query: create index `FK_rptledger_payment_item_parentid` on rptledger_payment_item(`parentid`) using btree
112
1130 row(s) affected
114
115Execution Time : 0.390 sec
116Transfer Time  : 0.001 sec
117Total Time     : 0.391 sec
118-----------------------------------------------------------
119
120Query: create index `FK_rptledger_payment_item_rptledgerfaasid` on rptledger_payment_item(`rptledgerfaasid`) using btree
121
1220 row(s) affected
123
124Execution Time : 0.343 sec
125Transfer Time  : 0.002 sec
126Total Time     : 0.346 sec
127-----------------------------------------------------------
128
129Query: create index `ix_rptledgeritemid` on rptledger_payment_item(`rptledgeritemid`) using btree
130
1310 row(s) affected
132
133Execution Time : 0.353 sec
134Transfer Time  : 0.001 sec
135Total Time     : 0.355 sec
136-----------------------------------------------------------
137
138Query: create index `ix_rptledgeritemqtrlyid` on rptledger_payment_item(`rptledgeritemqtrlyid`) using btree
139
1400 row(s) affected
141
142Execution Time : 0.334 sec
143Transfer Time  : 0.003 sec
144Total Time     : 0.337 sec
145-----------------------------------------------------------
146
147Query: alter table rptledger_payment_item add constraint `fk_rptledger_payment_item_parentid` foreign key (`parentid`) references `rptl...
148
1490 row(s) affected
150
151Execution Time : 0.337 sec
152Transfer Time  : 0.001 sec
153Total Time     : 0.339 sec
154-----------------------------------------------------------
155
156Query: alter table rptledger_payment_item add constraint `fk_rptledger_payment_item_rptledgerfaasid` foreign key (`rptledgerfaasid`) re...
157
1580 row(s) affected
159
160Execution Time : 0.409 sec
161Transfer Time  : 0.003 sec
162Total Time     : 0.413 sec
163-----------------------------------------------------------
164
165Query: create table rptledger_payment_share ( objid varchar(50) not null, parentid varchar(100) null, revperiod varchar(25) not null, r...
166
1670 row(s) affected
168
169Execution Time : 0.139 sec
170Transfer Time  : 0.005 sec
171Total Time     : 0.145 sec
172-----------------------------------------------------------
173
174Query: alter table rptledger_payment_share add constraint FK_rptledger_payment_share_parentid foreign key (parentid) references rptledg...
175
1760 row(s) affected
177
178Execution Time : 0.379 sec
179Transfer Time  : 0.004 sec
180Total Time     : 0.384 sec
181-----------------------------------------------------------
182
183Query: alter table rptledger_payment_share add constraint FK_rptledger_payment_share_itemaccount foreign key (item_objid) references it...
184
1850 row(s) affected
186
187Execution Time : 0.440 sec
188Transfer Time  : 0.002 sec
189Total Time     : 0.443 sec
190-----------------------------------------------------------
191
192Query: create index FK_parentid on rptledger_payment_share(parentid) using btree
193
1940 row(s) affected
195
196Execution Time : 0.337 sec
197Transfer Time  : 0.002 sec
198Total Time     : 0.339 sec
199-----------------------------------------------------------
200
201Query: create index FK_item_objid on rptledger_payment_share(item_objid) using btree
202
2030 row(s) affected
204
205Execution Time : 0.614 sec
206Transfer Time  : 0.003 sec
207Total Time     : 0.618 sec
208-----------------------------------------------------------
209
210Query: SET foreign_key_checks = 0
211
2120 row(s) affected
213
214Execution Time : 0.037 sec
215Transfer Time  : 0.002 sec
216Total Time     : 0.040 sec
217-----------------------------------------------------------
218
219Query: insert into rptledger_payment( objid, rptledgerid, type, receiptid, receiptno, receiptdate, paidby_name, paidby_address, postedb...
220
2218962 row(s) affected, 8567 warning(s)
222
223Execution Time : 25.131 sec
224Transfer Time  : 0.002 sec
225Total Time     : 25.133 sec
226
227Note: To see complete list of warning(s), enable Tools -> Preferences -> General -> Show Warning(s) in Messages Tab
228-----------------------------------------------------------
229
230Query: SET foreign_key_checks = 1
231
2320 row(s) affected
233
234Execution Time : 0.039 sec
235Transfer Time  : 0.002 sec
236Total Time     : 0.042 sec
237-----------------------------------------------------------
238
239Query: SET foreign_key_checks = 0
240
2410 row(s) affected
242
243Execution Time : 0 sec
244Transfer Time  : 0.001 sec
245Total Time     : 0.001 sec
246-----------------------------------------------------------
247
248Query: insert into rptledger_payment_item( objid, parentid, rptledgerfaasid, rptledgeritemid, rptledgeritemqtrlyid, year, qtr, basic, b...
249
25056538 row(s) affected
251
252Execution Time : 15.708 sec
253Transfer Time  : 0.003 sec
254Total Time     : 15.711 sec
255-----------------------------------------------------------
256
257Query: SET FOREIGN_KEY_CHECKS = 1
258
2590 row(s) affected
260
261Execution Time : 0.001 sec
262Transfer Time  : 0.003 sec
263Total Time     : 0.005 sec
264-----------------------------------------------------------
265
266Query: SET foreign_key_checks = 0
267
2680 row(s) affected
269
270Execution Time : 0 sec
271Transfer Time  : 0.002 sec
272Total Time     : 0.003 sec
273-----------------------------------------------------------
274
275Query: insert into rptledger_payment_share( objid, parentid, revperiod, revtype, item_objid, amount, sharetype, discount ) select cra.o...
276
27790896 row(s) affected
278
279Execution Time : 17.370 sec
280Transfer Time  : 0.001 sec
281Total Time     : 17.371 sec
282-----------------------------------------------------------
283
284Query: SET foreign_key_checks = 1
285
2860 row(s) affected
287
288Execution Time : 0 sec
289Transfer Time  : 0 sec
290Total Time     : 0.001 sec
291-----------------------------------------------------------
292
293Query: insert into rptledger_payment( objid, rptledgerid, type, receiptid, receiptno, receiptdate, paidby_name, paidby_address, postedb...
294
295Error Code: 1452
296Cannot add or update a child row: a foreign key constraint fails (`etracs254_impasugong`.`rptledger_payment`, CONSTRAINT `fk_rptledger_payment_rptledger` FOREIGN KEY (`rptledgerid`) REFERENCES `rptledger` (`objid`))
297
298Execution Time : 0 sec
299Transfer Time  : 0 sec
300Total Time     : 1.014 sec
301-----------------------------------------------------------
302
303Query: alter table rptledgeritem add sh decimal(16,2), add shdisc decimal(16,2), add shpaid decimal(16,2), add shint decimal(16,2)
304
305Error Code: 1060
306Duplicate column name 'sh'
307
308Execution Time : 0 sec
309Transfer Time  : 0 sec
310Total Time     : 0.002 sec
311-----------------------------------------------------------
312
313Query: update rptledgeritem set sh = 0, shdisc=0, shpaid = 0, shint = 0 where sh is null
314
3150 row(s) affected
316
317Execution Time : 14.347 sec
318Transfer Time  : 0.001 sec
319Total Time     : 14.348 sec
320-----------------------------------------------------------
321
322Query: alter table rptledgeritem_qtrly add sh decimal(16,2), add shdisc decimal(16,2), add shpaid decimal(16,2), add shint decimal(16,2...
323
324Error Code: 1060
325Duplicate column name 'sh'
326
327Execution Time : 0 sec
328Transfer Time  : 0 sec
329Total Time     : 0.002 sec
330-----------------------------------------------------------
331
332Query: update rptledgeritem_qtrly set sh = 0, shdisc = 0, shpaid = 0, shint = 0 where sh is null
333
3340 row(s) affected
335
336Execution Time : 6.817 sec
337Transfer Time  : 0.001 sec
338Total Time     : 6.818 sec
339-----------------------------------------------------------
340
341Query: alter table rptledger_compromise_item add sh decimal(16,2)
342
343Error Code: 1060
344Duplicate column name 'sh'
345
346Execution Time : 0 sec
347Transfer Time  : 0 sec
348Total Time     : 0.002 sec
349-----------------------------------------------------------
350
351Query: alter table rptledger_compromise_item add shpaid decimal(16,2)
352
353Error Code: 1060
354Duplicate column name 'shpaid'
355
356Execution Time : 0 sec
357Transfer Time  : 0 sec
358Total Time     : 0.002 sec
359-----------------------------------------------------------
360
361Query: alter table rptledger_compromise_item add shint decimal(16,2)
362
363Error Code: 1060
364Duplicate column name 'shint'
365
366Execution Time : 0 sec
367Transfer Time  : 0 sec
368Total Time     : 0.001 sec
369-----------------------------------------------------------
370
371Query: alter table rptledger_compromise_item add shintpaid decimal(16,2)
372
373Error Code: 1060
374Duplicate column name 'shintpaid'
375
376Execution Time : 0 sec
377Transfer Time  : 0 sec
378Total Time     : 0.003 sec
379-----------------------------------------------------------
380
381Query: update rptledger_compromise_item set sh = 0, shpaid = 0, shint = 0, shintpaid = 0 where sh is null
382
3830 row(s) affected
384
385Execution Time : 0.118 sec
386Transfer Time  : 0.001 sec
387Total Time     : 0.120 sec
388-----------------------------------------------------------
389
390Query: alter table rptledger_compromise_item_credit add sh decimal(16,2)
391
392Error Code: 1060
393Duplicate column name 'sh'
394
395Execution Time : 0 sec
396Transfer Time  : 0 sec
397Total Time     : 0.002 sec
398-----------------------------------------------------------
399
400Query: alter table rptledger_compromise_item_credit add shint decimal(16,2)
401
402Error Code: 1060
403Duplicate column name 'shint'
404
405Execution Time : 0 sec
406Transfer Time  : 0 sec
407Total Time     : 0.001 sec
408-----------------------------------------------------------
409
410Query: update rptledger_compromise_item_credit set sh = 0, shint = 0 where sh is null
411
4120 row(s) affected
413
414Execution Time : 0.002 sec
415Transfer Time  : 0.001 sec
416Total Time     : 0.003 sec
417-----------------------------------------------------------
418
419Query: update province_taxaccount_mapping set basicprioracct_objid = null, basicpriorintacct_objid = null
420
4210 row(s) affected
422
423Execution Time : 0.087 sec
424Transfer Time  : 0.001 sec
425Total Time     : 0.088 sec
426-----------------------------------------------------------
427
428Query: update municipality_taxaccount_mapping set basicprioracct_objid = null, basicpriorintacct_objid = null
429
4300 row(s) affected
431
432Execution Time : 0.116 sec
433Transfer Time  : 0.001 sec
434Total Time     : 0.118 sec
435-----------------------------------------------------------
436
437Query: update brgy_taxaccount_mapping set basicprioracct_objid = null, basicpriorintacct_objid = null
438
4390 row(s) affected
440
441Execution Time : 0.098 sec
442Transfer Time  : 0.001 sec
443Total Time     : 0.099 sec
444-----------------------------------------------------------
445
446Query: update province_taxaccount_mapping set sefprioracct_objid = null, sefpriorintacct_objid = null
447
4480 row(s) affected
449
450Execution Time : 0.082 sec
451Transfer Time  : 0.001 sec
452Total Time     : 0.083 sec
453-----------------------------------------------------------
454
455Query: update municipality_taxaccount_mapping set sefprioracct_objid = null, sefpriorintacct_objid = null
456
4570 row(s) affected
458
459Execution Time : 0.079 sec
460Transfer Time  : 0.001 sec
461Total Time     : 0.081 sec
462-----------------------------------------------------------
463
464Query: update province_taxaccount_mapping set sefprioracct_objid = null, sefpriorintacct_objid = null
465
4660 row(s) affected
467
468Execution Time : 0.084 sec
469Transfer Time  : 0.001 sec
470Total Time     : 0.086 sec
471-----------------------------------------------------------
472
473Query: update municipality_taxaccount_mapping set sefprioracct_objid = null, sefpriorintacct_objid = null
474
4750 row(s) affected
476
477Execution Time : 0.062 sec
478Transfer Time  : 0.001 sec
479Total Time     : 0.063 sec