sQFQfAnb

154 queries executed, 46 success, 8 errors, 3 warnings
2
3Query: drop table if exists cashreceiptitem_rpt_noledger
4
50 row(s) affected, 1 warning(s)
6
7Execution Time : 0.002 sec
8Transfer Time  : 0.014 sec
9Total Time     : 0.016 sec
10
11Note: To see complete list of warning(s), enable Tools -> Preferences -> General -> Show Warning(s) in Messages Tab
12-----------------------------------------------------------
13
14Query: drop table if exists cashreceiptitem_rpt
15
160 row(s) affected, 1 warning(s)
17
18Execution Time : 0.002 sec
19Transfer Time  : 0.001 sec
20Total Time     : 0.003 sec
21
22Note: To see complete list of warning(s), enable Tools -> Preferences -> General -> Show Warning(s) in Messages Tab
23-----------------------------------------------------------
24
25Query: drop table if exists rptledger_payment_share
26
270 row(s) affected
28
29Execution Time : 0.081 sec
30Transfer Time  : 0.001 sec
31Total Time     : 0.082 sec
32-----------------------------------------------------------
33
34Query: drop table if exists rptledger_payment_item
35
360 row(s) affected
37
38Execution Time : 0.098 sec
39Transfer Time  : 0.001 sec
40Total Time     : 0.100 sec
41-----------------------------------------------------------
42
43Query: drop table if exists rptledger_payment
44
450 row(s) affected
46
47Execution Time : 0.103 sec
48Transfer Time  : 0.002 sec
49Total Time     : 0.106 sec
50-----------------------------------------------------------
51
52Query: CREATE TABLE `rptledger_payment` ( `objid` varchar(100) NOT NULL, `rptledgerid` varchar(50) NOT NULL, `type` varchar(20) NOT NUL...
53
540 row(s) affected
55
56Execution Time : 0.100 sec
57Transfer Time  : 0.002 sec
58Total Time     : 0.102 sec
59-----------------------------------------------------------
60
61Query: create index `fk_rptledger_payment_rptledger` on rptledger_payment(`rptledgerid`) using btree
62
630 row(s) affected
64
65Execution Time : 0.287 sec
66Transfer Time  : 0.002 sec
67Total Time     : 0.290 sec
68-----------------------------------------------------------
69
70Query: create index `fk_rptledger_payment_cashreceipt` on rptledger_payment(`receiptid`) using btree
71
720 row(s) affected
73
74Execution Time : 0.266 sec
75Transfer Time  : 0.002 sec
76Total Time     : 0.269 sec
77-----------------------------------------------------------
78
79Query: create index `ix_receiptno` on rptledger_payment(`receiptno`) using btree
80
810 row(s) affected
82
83Execution Time : 0.286 sec
84Transfer Time  : 0.001 sec
85Total Time     : 0.287 sec
86-----------------------------------------------------------
87
88Query: alter table rptledger_payment add constraint `fk_rptledger_payment_cashreceipt` foreign key (`receiptid`) references `cashreceip...
89
900 row(s) affected
91
92Execution Time : 0.274 sec
93Transfer Time  : 0.003 sec
94Total Time     : 0.278 sec
95-----------------------------------------------------------
96
97Query: alter table rptledger_payment add constraint `fk_rptledger_payment_rptledger` foreign key (`rptledgerid`) references `rptledger`...
98
990 row(s) affected
100
101Execution Time : 0.281 sec
102Transfer Time  : 0.002 sec
103Total Time     : 0.284 sec
104-----------------------------------------------------------
105
106Query: CREATE TABLE `rptledger_payment_item` ( `objid` varchar(50) NOT NULL, `parentid` varchar(100) NOT NULL, `rptledgerfaasid` varcha...
107
1080 row(s) affected
109
110Execution Time : 0.113 sec
111Transfer Time  : 0.006 sec
112Total Time     : 0.120 sec
113-----------------------------------------------------------
114
115Query: create index `FK_rptledger_payment_item_parentid` on rptledger_payment_item(`parentid`) using btree
116
1170 row(s) affected
118
119Execution Time : 0.298 sec
120Transfer Time  : 0.001 sec
121Total Time     : 0.300 sec
122-----------------------------------------------------------
123
124Query: create index `FK_rptledger_payment_item_rptledgerfaasid` on rptledger_payment_item(`rptledgerfaasid`) using btree
125
1260 row(s) affected
127
128Execution Time : 0.252 sec
129Transfer Time  : 0.002 sec
130Total Time     : 0.254 sec
131-----------------------------------------------------------
132
133Query: create index `ix_rptledgeritemid` on rptledger_payment_item(`rptledgeritemid`) using btree
134
1350 row(s) affected
136
137Execution Time : 0.286 sec
138Transfer Time  : 0.002 sec
139Total Time     : 0.289 sec
140-----------------------------------------------------------
141
142Query: create index `ix_rptledgeritemqtrlyid` on rptledger_payment_item(`rptledgeritemqtrlyid`) using btree
143
1440 row(s) affected
145
146Execution Time : 0.422 sec
147Transfer Time  : 0.003 sec
148Total Time     : 0.425 sec
149-----------------------------------------------------------
150
151Query: alter table rptledger_payment_item add constraint `fk_rptledger_payment_item_parentid` foreign key (`parentid`) references `rptl...
152
1530 row(s) affected
154
155Execution Time : 0.282 sec
156Transfer Time  : 0.001 sec
157Total Time     : 0.283 sec
158-----------------------------------------------------------
159
160Query: alter table rptledger_payment_item add constraint `fk_rptledger_payment_item_rptledgerfaasid` foreign key (`rptledgerfaasid`) re...
161
1620 row(s) affected
163
164Execution Time : 0.288 sec
165Transfer Time  : 0.002 sec
166Total Time     : 0.290 sec
167-----------------------------------------------------------
168
169Query: create table rptledger_payment_share ( objid varchar(50) not null, parentid varchar(100) null, revperiod varchar(25) not null, r...
170
1710 row(s) affected
172
173Execution Time : 0.113 sec
174Transfer Time  : 0.005 sec
175Total Time     : 0.118 sec
176-----------------------------------------------------------
177
178Query: alter table rptledger_payment_share add constraint FK_rptledger_payment_share_parentid foreign key (parentid) references rptledg...
179
1800 row(s) affected
181
182Execution Time : 0.380 sec
183Transfer Time  : 0.002 sec
184Total Time     : 0.383 sec
185-----------------------------------------------------------
186
187Query: alter table rptledger_payment_share add constraint FK_rptledger_payment_share_itemaccount foreign key (item_objid) references it...
188
1890 row(s) affected
190
191Execution Time : 0.302 sec
192Transfer Time  : 0.003 sec
193Total Time     : 0.305 sec
194-----------------------------------------------------------
195
196Query: create index FK_parentid on rptledger_payment_share(parentid) using btree
197
1980 row(s) affected
199
200Execution Time : 0.366 sec
201Transfer Time  : 0.004 sec
202Total Time     : 0.371 sec
203-----------------------------------------------------------
204
205Query: create index FK_item_objid on rptledger_payment_share(item_objid) using btree
206
2070 row(s) affected
208
209Execution Time : 0.264 sec
210Transfer Time  : 0.001 sec
211Total Time     : 0.265 sec
212-----------------------------------------------------------
213
214Query: SET foreign_key_checks = 0
215
2160 row(s) affected
217
218Execution Time : 0 sec
219Transfer Time  : 0.001 sec
220Total Time     : 0.001 sec
221-----------------------------------------------------------
222
223Query: insert into rptledger_payment( objid, rptledgerid, type, receiptid, receiptno, receiptdate, paidby_name, paidby_address, postedb...
224
2258962 row(s) affected, 8567 warning(s)
226
227Execution Time : 19.204 sec
228Transfer Time  : 0.009 sec
229Total Time     : 19.213 sec
230
231Note: To see complete list of warning(s), enable Tools -> Preferences -> General -> Show Warning(s) in Messages Tab
232-----------------------------------------------------------
233
234Query: SET foreign_key_checks = 1
235
2360 row(s) affected
237
238Execution Time : 0.031 sec
239Transfer Time  : 0.002 sec
240Total Time     : 0.033 sec
241-----------------------------------------------------------
242
243Query: SET foreign_key_checks = 0
244
2450 row(s) affected
246
247Execution Time : 0.002 sec
248Transfer Time  : 0.003 sec
249Total Time     : 0.005 sec
250-----------------------------------------------------------
251
252Query: insert into rptledger_payment_item( objid, parentid, rptledgerfaasid, rptledgeritemid, rptledgeritemqtrlyid, year, qtr, basic, b...
253
25456538 row(s) affected
255
256Execution Time : 15.500 sec
257Transfer Time  : 0.002 sec
258Total Time     : 15.502 sec
259-----------------------------------------------------------
260
261Query: SET FOREIGN_KEY_CHECKS = 1
262
2630 row(s) affected
264
265Execution Time : 0 sec
266Transfer Time  : 0 sec
267Total Time     : 0.001 sec
268-----------------------------------------------------------
269
270Query: SET foreign_key_checks = 0
271
2720 row(s) affected
273
274Execution Time : 0 sec
275Transfer Time  : 0.001 sec
276Total Time     : 0.001 sec
277-----------------------------------------------------------
278
279Query: insert into rptledger_payment_share( objid, parentid, revperiod, revtype, item_objid, amount, sharetype, discount ) select cra.o...
280
28190896 row(s) affected
282
283Execution Time : 15.697 sec
284Transfer Time  : 0.005 sec
285Total Time     : 15.703 sec
286-----------------------------------------------------------
287
288Query: SET foreign_key_checks = 1
289
2900 row(s) affected
291
292Execution Time : 0.001 sec
293Transfer Time  : 0.004 sec
294Total Time     : 0.005 sec
295-----------------------------------------------------------
296
297Query: SET foreign_key_checks=0
298
2990 row(s) affected
300
301Execution Time : 0.006 sec
302Transfer Time  : 0.003 sec
303Total Time     : 0.010 sec
304-----------------------------------------------------------
305
306Query: insert into rptledger_payment( objid, rptledgerid, type, receiptid, receiptno, receiptdate, paidby_name, paidby_address, postedb...
307
3085563 row(s) affected
309
310Execution Time : 0.960 sec
311Transfer Time  : 0.001 sec
312Total Time     : 0.962 sec
313-----------------------------------------------------------
314
315Query: SET foreign_key_checks=1
316
3170 row(s) affected
318
319Execution Time : 0.009 sec
320Transfer Time  : 0.002 sec
321Total Time     : 0.012 sec
322-----------------------------------------------------------
323
324Query: alter table rptledgeritem add sh decimal(16,2), add shdisc decimal(16,2), add shpaid decimal(16,2), add shint decimal(16,2)
325
326Error Code: 1060
327Duplicate column name 'sh'
328
329Execution Time : 0 sec
330Transfer Time  : 0 sec
331Total Time     : 0.022 sec
332-----------------------------------------------------------
333
334Query: update rptledgeritem set sh = 0, shdisc=0, shpaid = 0, shint = 0 where sh is null
335
3360 row(s) affected
337
338Execution Time : 5.645 sec
339Transfer Time  : 0.001 sec
340Total Time     : 5.646 sec
341-----------------------------------------------------------
342
343Query: alter table rptledgeritem_qtrly add sh decimal(16,2), add shdisc decimal(16,2), add shpaid decimal(16,2), add shint decimal(16,2...
344
345Error Code: 1060
346Duplicate column name 'sh'
347
348Execution Time : 0 sec
349Transfer Time  : 0 sec
350Total Time     : 0.088 sec
351-----------------------------------------------------------
352
353Query: update rptledgeritem_qtrly set sh = 0, shdisc = 0, shpaid = 0, shint = 0 where sh is null
354
3550 row(s) affected
356
357Execution Time : 1.712 sec
358Transfer Time  : 0.001 sec
359Total Time     : 1.714 sec
360-----------------------------------------------------------
361
362Query: alter table rptledger_compromise_item add sh decimal(16,2)
363
364Error Code: 1060
365Duplicate column name 'sh'
366
367Execution Time : 0 sec
368Transfer Time  : 0 sec
369Total Time     : 0.081 sec
370-----------------------------------------------------------
371
372Query: alter table rptledger_compromise_item add shpaid decimal(16,2)
373
374Error Code: 1060
375Duplicate column name 'shpaid'
376
377Execution Time : 0 sec
378Transfer Time  : 0 sec
379Total Time     : 0.003 sec
380-----------------------------------------------------------
381
382Query: alter table rptledger_compromise_item add shint decimal(16,2)
383
384Error Code: 1060
385Duplicate column name 'shint'
386
387Execution Time : 0 sec
388Transfer Time  : 0 sec
389Total Time     : 0.003 sec
390-----------------------------------------------------------
391
392Query: alter table rptledger_compromise_item add shintpaid decimal(16,2)
393
394Error Code: 1060
395Duplicate column name 'shintpaid'
396
397Execution Time : 0 sec
398Transfer Time  : 0 sec
399Total Time     : 0.003 sec
400-----------------------------------------------------------
401
402Query: update rptledger_compromise_item set sh = 0, shpaid = 0, shint = 0, shintpaid = 0 where sh is null
403
4040 row(s) affected
405
406Execution Time : 0.002 sec
407Transfer Time  : 0.002 sec
408Total Time     : 0.005 sec
409-----------------------------------------------------------
410
411Query: alter table rptledger_compromise_item_credit add sh decimal(16,2)
412
413Error Code: 1060
414Duplicate column name 'sh'
415
416Execution Time : 0 sec
417Transfer Time  : 0 sec
418Total Time     : 0.004 sec
419-----------------------------------------------------------
420
421Query: alter table rptledger_compromise_item_credit add shint decimal(16,2)
422
423Error Code: 1060
424Duplicate column name 'shint'
425
426Execution Time : 0 sec
427Transfer Time  : 0 sec
428Total Time     : 0.003 sec
429-----------------------------------------------------------
430
431Query: update rptledger_compromise_item_credit set sh = 0, shint = 0 where sh is null
432
4330 row(s) affected
434
435Execution Time : 0.001 sec
436Transfer Time  : 0.002 sec
437Total Time     : 0.003 sec
438-----------------------------------------------------------
439
440Query: update province_taxaccount_mapping set basicprioracct_objid = null, basicpriorintacct_objid = null
441
4420 row(s) affected
443
444Execution Time : 0.061 sec
445Transfer Time  : 0.002 sec
446Total Time     : 0.063 sec
447-----------------------------------------------------------
448
449Query: update municipality_taxaccount_mapping set basicprioracct_objid = null, basicpriorintacct_objid = null
450
4510 row(s) affected
452
453Execution Time : 0.044 sec
454Transfer Time  : 0.003 sec
455Total Time     : 0.048 sec
456-----------------------------------------------------------
457
458Query: update brgy_taxaccount_mapping set basicprioracct_objid = null, basicpriorintacct_objid = null
459
4600 row(s) affected
461
462Execution Time : 0.056 sec
463Transfer Time  : 0.001 sec
464Total Time     : 0.057 sec
465-----------------------------------------------------------
466
467Query: update province_taxaccount_mapping set sefprioracct_objid = null, sefpriorintacct_objid = null
468
4690 row(s) affected
470
471Execution Time : 0.048 sec
472Transfer Time  : 0.001 sec
473Total Time     : 0.050 sec
474-----------------------------------------------------------
475
476Query: update municipality_taxaccount_mapping set sefprioracct_objid = null, sefpriorintacct_objid = null
477
4780 row(s) affected
479
480Execution Time : 0.045 sec
481Transfer Time  : 0.001 sec
482Total Time     : 0.046 sec
483-----------------------------------------------------------
484
485Query: update province_taxaccount_mapping set sefprioracct_objid = null, sefpriorintacct_objid = null
486
4870 row(s) affected
488
489Execution Time : 0.048 sec
490Transfer Time  : 0.001 sec
491Total Time     : 0.049 sec
492-----------------------------------------------------------
493
494Query: update municipality_taxaccount_mapping set sefprioracct_objid = null, sefpriorintacct_objid = null
495
4960 row(s) affected
497
498Execution Time : 0.045 sec
499Transfer Time  : 0.005 sec
500Total Time     : 0.050 sec