oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner : jim.wjh
5
#owner group: sql2
6
#description: todo
7
--disable_warnings
8
drop database if exists createsql;
9
--enable_warnings
10
create database createsql;
11
use createsql;
12

13
CREATE TABLE IF NOT EXISTS rpt_chenfeng_custid_shishi_000(
14
    thedate datetime(6),
15
    puttype int,
16
    sourcetype int,
17
    clickprice int,
18
    click int,
19
    custid int,
20
    impression int,
21
    PRIMARY KEY (custid,thedate,puttype,sourcetype)
22
) COMPRESSION='lz4_1.0' ;
23

24
CREATE TABLE IF NOT EXISTS rpt_solar_feed_bidword_ob_000(
25
    bidwordid int,
26
    searchtype int,
27
    thedate datetime(6),
28
    adgroupid int,
29
    freeclick int,
30
    directtransactionshipping int,
31
    matchscope int,
32
    memberid int,
33
    feedid int,
34
    favshoptotal int,
35
    cost int,
36
    campaignid int,
37
    favitemtotal int,
38
    indirecttransaction int,
39
    gmt_created datetime default now(),
40
    gmt_modified datetime default now(),
41
    directtransaction int,
42
    indirecttransactionshipping int,
43
    network int,
44
    invalidclick int,
45
    bidwordstr varchar(300),
46
    custid int,
47
    impression int,
48
    itemid int,
49
    click int,
50
    ranksum int,
51
    PRIMARY KEY (custid,thedate,campaignid,adgroupid,bidwordid,feedid,network,matchscope)
52
) COMPRESSION='lz4_1.0' ;
53

54
CREATE TABLE IF NOT EXISTS rpt_chenfeng_campaignid_lixian_000(
55
    thedate datetime(6),
56
    sourcetype int,
57
    custid int,
58
    impression int,
59
    puttype int,
60
    campaignid int,
61
    clickprice int,
62
    click int,
63
    PRIMARY KEY (custid,thedate,campaignid,puttype,sourcetype)
64
) COMPRESSION='lz4_1.0' ;
65

66
CREATE TABLE IF NOT EXISTS rpt_bpp4p_bidword_ob_000(
67
    click int,
68
    bidwordstr varchar(300),
69
    custid int,
70
    onefavshoptotal int,
71
    directtransaction int,
72
    invalidclick int,
73
    network int,
74
    campaignid int,
75
    cost int,
76
    favitemtotal int,
77
    adgroupid int,
78
    memberid int,
79
    sevenindirecttransactionshipping int,
80
    fifteenfavitemtotal int,
81
    thedate datetime(6),
82
    fifteenindirecttransactionshipping int,
83
    isshop int,
84
    fifteenfavshoptotal int,
85
    fifteendirecttransactionshipping int,
86
    threeindirecttransactionshipping int,
87
    ranksum int,
88
    sevenfavitemtotal int,
89
    impression int,
90
    threefavshoptotal int,
91
    sevenindirecttransaction int,
92
    indirecttransactionshipping int,
93
    onedirecttransactionshipping int,
94
    onefavitemtotal int,
95
    indirecttransaction int,
96
    threeindirecttransaction int,
97
    sevendirecttransactionshipping int,
98
    sevendirecttransaction int,
99
    sevenfavshoptotal int,
100
    fifteenindirecttransaction int,
101
    favshoptotal int,
102
    onedirecttransaction int,
103
    oneindirecttransactionshipping int,
104
    matchscope int,
105
    directtransactionshipping int,
106
    threefavitemtotal int,
107
    fifteendirecttransaction int,
108
    threedirecttransactionshipping int,
109
    oneindirecttransaction int,
110
    threedirecttransaction int,
111
    bidwordid int,
112
    searchtype int,
113
    PRIMARY KEY (custid,thedate,campaignid,adgroupid,bidwordid,network,matchscope)
114
) COMPRESSION='lz4_1.0' ;
115

116
CREATE TABLE IF NOT EXISTS rpt_bpp4p_adgroupplace_name_000(
117
    placeid int,
118
    placename varchar(100),
119
    thedate datetime(6),
120
    PRIMARY KEY (placeid)
121
) COMPRESSION='lz4_1.0' ;
122

123
CREATE TABLE IF NOT EXISTS rpt_chenfeng_custid_shishi_accumulative_000(
124
    custid int,
125
    impression int,
126
    sourcetype int,
127
    puttype int,
128
    thedate datetime(6),
129
    clickprice int,
130
    click int,
131
    PRIMARY KEY (custid,thedate,puttype,sourcetype)
132
) COMPRESSION='lz4_1.0' ;
133

134
CREATE TABLE IF NOT EXISTS rpt_bpp4p_querysession_ob_000(
135
    relword varchar(3000),
136
    originalword varchar(300),
137
    PRIMARY KEY (originalword)
138
) COMPRESSION='lz4_1.0' ;
139

140
CREATE TABLE IF NOT EXISTS rpt_bpp4p_area_ob_000(
141
    onedirecttransaction int,
142
    favshoptotal int,
143
    threefavitemtotal int,
144
    oneindirecttransactionshipping int,
145
    directtransactionshipping int,
146
    provinceid int,
147
    threedirecttransactionshipping int,
148
    fifteendirecttransaction int,
149
    oneindirecttransaction int,
150
    threedirecttransaction int,
151
    ext2 int,
152
    threeindirecttransactionshipping int,
153
    threefavshoptotal int,
154
    impression int,
155
    sevenfavitemtotal int,
156
    ext1 int,
157
    onedirecttransactionshipping int,
158
    indirecttransactionshipping int,
159
    onefavitemtotal int,
160
    sevenindirecttransaction int,
161
    sevenfavshoptotal int,
162
    fifteenindirecttransaction int,
163
    sevendirecttransaction int,
164
    cityid int,
165
    sevendirecttransactionshipping int,
166
    threeindirecttransaction int,
167
    indirecttransaction int,
168
    favitemtotal int,
169
    productid int,
170
    campaignid int,
171
    cost int,
172
    sevenindirecttransactionshipping int,
173
    memberid int,
174
    fifteenfavshoptotal int,
175
    fifteenfavitemtotal int,
176
    fifteenindirecttransactionshipping int,
177
    thedate datetime(6),
178
    fifteendirecttransactionshipping int,
179
    click int,
180
    traffictype int,
181
    custid int,
182
    invalidclick int,
183
    productline int,
184
    directtransaction int,
185
    onefavshoptotal int,
186
    mechanism int,
187
    PRIMARY KEY (custid,thedate,campaignid,traffictype,mechanism,provinceid,cityid,productline,productid,ext1,ext2)
188
) COMPRESSION='lz4_1.0' ;
189

190
CREATE TABLE IF NOT EXISTS rpt_bpp4p_insight_bidword_area_000(
191
    indirecttransaction int,
192
    mechanism int,
193
    competition int,
194
    area int,
195
    indirecttransactionshipping int,
196
    network int,
197
    ext1 int,
198
    directtransaction int,
199
    bidwordstr varchar(300),
200
    impression int,
201
    click int,
202
    ext2 int,
203
    thedate datetime(6),
204
    directtransactionshipping int,
205
    bidwordhash int,
206
    cost int,
207
    favshoptotal int,
208
    favitemtotal int,
209
    PRIMARY KEY (bidwordhash,thedate,area,network,mechanism,ext1,ext2,bidwordstr)
210
) COMPRESSION='lz4_1.0' ;
211

212
CREATE TABLE IF NOT EXISTS rpt_solar_feed_name_000(
213
    gmt_created datetime default now(),
214
    gmt_modified datetime default now(),
215
    thedate datetime(6),
216
    linkurl varchar(1024),
217
    adgroupid int,
218
    custid int,
219
    title varchar(1024),
220
    memberid int,
221
    imgurl varchar(1024),
222
    feedid int,
223
    campaignid int,
224
    PRIMARY KEY (custid,thedate,campaignid,adgroupid,feedid)
225
) COMPRESSION='lz4_1.0' ;
226

227
CREATE TABLE IF NOT EXISTS rpt_chenfeng_custid_lixian_accumulative_000(
228
    clickprice int,
229
    click int,
230
    sourcetype int,
231
    puttype int,
232
    thedate datetime(6),
233
    impression int,
234
    custid int,
235
    PRIMARY KEY (custid,thedate,puttype,sourcetype)
236
) COMPRESSION='lz4_1.0' ;
237

238
CREATE TABLE IF NOT EXISTS rpt_bpp4p_creative_name_000(
239
    is_shop int,
240
    thedate datetime(6),
241
    linkurl varchar(1024),
242
    adgroupid int,
243
    title varchar(1024),
244
    custid int,
245
    creativeid int,
246
    memberid int,
247
    imgurl varchar(1024),
248
    campaignid int,
249
    PRIMARY KEY (custid,thedate,campaignid,adgroupid,creativeid)
250
) COMPRESSION='lz4_1.0' ;
251

252
CREATE TABLE IF NOT EXISTS rpt_bpp4p_demographic_name_000(
253
    name varchar(100),
254
    demographicid int,
255
    thedate datetime(6),
256
    PRIMARY KEY (demographicid)
257
) COMPRESSION='lz4_1.0' ;
258

259
CREATE TABLE IF NOT EXISTS rpt_bpp4p_demographic_name_star_000(
260
    thedate datetime(6),
261
    demographicid int,
262
    name varchar(100),
263
    PRIMARY KEY (demographicid)
264
) COMPRESSION='lz4_1.0' ;
265

266
CREATE TABLE IF NOT EXISTS rpt_solar_item_ob_000(
267
    indirecttransactionshipping int,
268
    ext1 int,
269
    onedirecttransactionshipping int,
270
    onefavitemtotal int,
271
    sevenindirecttransaction int,
272
    fifteenindirecttransaction int,
273
    sevenfavshoptotal int,
274
    productlineid int,
275
    sevendirecttransaction int,
276
    sevendirecttransactionshipping int,
277
    threeindirecttransaction int,
278
    indirecttransaction int,
279
    ranksum int,
280
    ext2 int,
281
    threeindirecttransactionshipping int,
282
    threefavshoptotal int,
283
    impression int,
284
    sevenfavitemtotal int,
285
    creativeid int,
286
    threedirecttransactionshipping int,
287
    fifteendirecttransaction int,
288
    searchtype int,
289
    rptext2 int,
290
    threedirecttransaction int,
291
    oneindirecttransaction int,
292
    onedirecttransaction int,
293
    favshoptotal int,
294
    entityid int,
295
    creativepv int,
296
    threefavitemtotal int,
297
    oneindirecttransactionshipping int,
298
    directtransactionshipping int,
299
    invalidclick int,
300
    directtransaction int,
301
    onefavshoptotal int,
302
    rptext1 int,
303
    click int,
304
    traffictype int,
305
    custid int,
306
    entitytype int,
307
    fifteenfavshoptotal int,
308
    thedate datetime(6),
309
    fifteenfavitemtotal int,
310
    fifteenindirecttransactionshipping int,
311
    fifteendirecttransactionshipping int,
312
    favitemtotal int,
313
    productid int,
314
    cost int,
315
    areaid int,
316
    campaignid int,
317
    feedid int,
318
    sevenindirecttransactionshipping int,
319
    memberid int,
320
    adgroupid int,
321
    PRIMARY KEY (memberid,thedate,productlineid,campaignid,adgroupid,creativeid,areaid,entityid,entitytype,traffictype,searchtype,productid,ext1,ext2)
322
) COMPRESSION='lz4_1.0' ;
323

324
CREATE TABLE IF NOT EXISTS rpt_p4p_bidword_normtoorigin_000(
325
    normalword varchar(300),
326
    originalword varchar(300),
327
    PRIMARY KEY (normalword)
328
) COMPRESSION='lz4_1.0' ;
329

330
CREATE TABLE IF NOT EXISTS rpt_chenfeng_campaignid_lixian_accumulative_000(
331
    click int,
332
    clickprice int,
333
    puttype int,
334
    campaignid int,
335
    impression int,
336
    custid int,
337
    thedate datetime(6),
338
    sourcetype int,
339
    PRIMARY KEY (custid,thedate,campaignid,puttype,sourcetype)
340
) COMPRESSION='lz4_1.0' ;
341

342
CREATE TABLE IF NOT EXISTS rpt_chenfeng_custid_lixian_000(
343
    custid int,
344
    impression int,
345
    sourcetype int,
346
    puttype int,
347
    thedate datetime(6),
348
    click int,
349
    clickprice int,
350
    PRIMARY KEY (custid,thedate,puttype,sourcetype)
351
) COMPRESSION='lz4_1.0' ;
352

353
CREATE TABLE IF NOT EXISTS rpt_chenfeng_campaignid_shishi_000(
354
    thedate datetime(6),
355
    sourcetype int,
356
    custid int,
357
    impression int,
358
    campaignid int,
359
    puttype int,
360
    click int,
361
    clickprice int,
362
    PRIMARY KEY (custid,thedate,campaignid,puttype,sourcetype)
363
) COMPRESSION='lz4_1.0' ;
364

365
CREATE TABLE IF NOT EXISTS rpt_chenfeng_campaignid_shishi_accumulative_000(
366
    clickprice int,
367
    click int,
368
    puttype int,
369
    campaignid int,
370
    impression int,
371
    custid int,
372
    sourcetype int,
373
    thedate datetime(6),
374
    PRIMARY KEY (custid,thedate,campaignid,puttype,sourcetype)
375
) COMPRESSION='lz4_1.0' ;
376

377
CREATE TABLE IF NOT EXISTS rpt_bpp4p_custom_ob_000(
378
    oneindirecttransaction int,
379
    threedirecttransaction int,
380
    fifteendirecttransaction int,
381
    threedirecttransactionshipping int,
382
    directtransactionshipping int,
383
    oneindirecttransactionshipping int,
384
    threefavitemtotal int,
385
    favshoptotal int,
386
    onedirecttransaction int,
387
    indirecttransaction int,
388
    threeindirecttransaction int,
389
    sevendirecttransactionshipping int,
390
    sevendirecttransaction int,
391
    sevenfavshoptotal int,
392
    fifteenindirecttransaction int,
393
    sevenindirecttransaction int,
394
    onedirecttransactionshipping int,
395
    indirecttransactionshipping int,
396
    onefavitemtotal int,
397
    sevenfavitemtotal int,
398
    impression int,
399
    threefavshoptotal int,
400
    threeindirecttransactionshipping int,
401
    ranksum int,
402
    fifteendirecttransactionshipping int,
403
    fifteenfavitemtotal int,
404
    fifteenindirecttransactionshipping int,
405
    thedate datetime(6),
406
    fifteenfavshoptotal int,
407
    memberid int,
408
    sevenindirecttransactionshipping int,
409
    cost int,
410
    favitemtotal int,
411
    onefavshoptotal int,
412
    directtransaction int,
413
    invalidclick int,
414
    custid int,
415
    click int,
416
    PRIMARY KEY (custid,thedate)
417
) COMPRESSION='lz4_1.0' ;
418

419
CREATE TABLE IF NOT EXISTS rpt_bpp4p_demographic_name_purchase_000(
420
    demographicid int,
421
    thedate datetime(6),
422
    name varchar(100),
423
    PRIMARY KEY (demographicid)
424
) COMPRESSION='lz4_1.0' ;
425

426
CREATE TABLE IF NOT EXISTS rpt_bpp4p_tag_000(
427
    name varchar(300),
428
    gmt_created datetime default now(),
429
    id int,
430
    type int,
431
    gmt_modified datetime default now(),
432
    PRIMARY KEY (id)
433
) COMPRESSION='lz4_1.0' ;
434

435
CREATE TABLE IF NOT EXISTS rpt_bpp4p_adgroup_ob_000(
436
    adgroupid int,
437
    sevenindirecttransactionshipping int,
438
    memberid int,
439
    cost int,
440
    campaignid int,
441
    favitemtotal int,
442
    fifteendirecttransactionshipping int,
443
    fifteenindirecttransactionshipping int,
444
    fifteenfavitemtotal int,
445
    thedate datetime(6),
446
    isshop int,
447
    fifteenfavshoptotal int,
448
    custid int,
449
    click int,
450
    onefavshoptotal int,
451
    invalidclick int,
452
    network int,
453
    directtransaction int,
454
    oneindirecttransactionshipping int,
455
    directtransactionshipping int,
456
    matchscope int,
457
    threefavitemtotal int,
458
    favshoptotal int,
459
    onedirecttransaction int,
460
    threedirecttransaction int,
461
    oneindirecttransaction int,
462
    searchtype int,
463
    auctionid int,
464
    fifteendirecttransaction int,
465
    threedirecttransactionshipping int,
466
    sevenfavitemtotal int,
467
    creativeid int,
468
    threefavshoptotal int,
469
    impression int,
470
    threeindirecttransactionshipping int,
471
    ranksum int,
472
    sevendirecttransactionshipping int,
473
    threeindirecttransaction int,
474
    indirecttransaction int,
475
    fifteenindirecttransaction int,
476
    sevenfavshoptotal int,
477
    sevendirecttransaction int,
478
    onefavitemtotal int,
479
    indirecttransactionshipping int,
480
    onedirecttransactionshipping int,
481
    sevenindirecttransaction int,
482
    PRIMARY KEY (custid,thedate,campaignid,adgroupid,creativeid,network,matchscope,searchtype)
483
) COMPRESSION='lz4_1.0' ;
484

485
CREATE TABLE IF NOT EXISTS rpt_bpp4p_dim_000(
486
    gmt_modified datetime default now(),
487
    id int,
488
    name varchar(300),
489
    gmt_created datetime default now(),
490
    PRIMARY KEY (id)
491
) COMPRESSION='lz4_1.0' ;
492

493
CREATE TABLE IF NOT EXISTS rpt_bpp4p_adgroup_name_000(
494
    title varchar(1024),
495
    custid int,
496
    adgroupid int,
497
    memberid int,
498
    campaignid int,
499
    imgurl varchar(1024),
500
    auctionid int,
501
    thedate datetime(6),
502
    isshop int,
503
    linkurl varchar(1024),
504
    PRIMARY KEY (custid,thedate,campaignid,adgroupid)
505
) COMPRESSION='lz4_1.0' ;
506

507
CREATE TABLE IF NOT EXISTS rpt_bpp4p_insight_bidword_price_000(
508
    indirecttransaction int,
509
    competition int,
510
    mechanism int,
511
    directtransaction int,
512
    ext1 int,
513
    indirecttransactionshipping int,
514
    network int,
515
    bidwordstr varchar(300),
516
    impression int,
517
    ext2 int,
518
    click int,
519
    pricedistribution int,
520
    thedate datetime(6),
521
    directtransactionshipping int,
522
    bidwordhash int,
523
    favshoptotal int,
524
    cost int,
525
    favitemtotal int,
526
    PRIMARY KEY (bidwordhash,thedate,pricedistribution,network,mechanism,ext1,ext2,bidwordstr)
527
) COMPRESSION='lz4_1.0' ;
528

529
CREATE TABLE IF NOT EXISTS rpt_bpp4p_sexpowerstar_ob_000(
530
    directtransaction int,
531
    invalidclick int,
532
    onefavshoptotal int,
533
    click int,
534
    custid int,
535
    fifteenfavshoptotal int,
536
    fifteenfavitemtotal int,
537
    thedate datetime(6),
538
    fifteenindirecttransactionshipping int,
539
    fifteendirecttransactionshipping int,
540
    demographicstarid int,
541
    demographicsexid int,
542
    favitemtotal int,
543
    campaignid int,
544
    cost int,
545
    memberid int,
546
    sevenindirecttransactionshipping int,
547
    sevenindirecttransaction int,
548
    onefavitemtotal int,
549
    indirecttransactionshipping int,
550
    onedirecttransactionshipping int,
551
    sevendirecttransaction int,
552
    fifteenindirecttransaction int,
553
    sevenfavshoptotal int,
554
    indirecttransaction int,
555
    threeindirecttransaction int,
556
    sevendirecttransactionshipping int,
557
    threeindirecttransactionshipping int,
558
    impression int,
559
    threefavshoptotal int,
560
    sevenfavitemtotal int,
561
    threedirecttransactionshipping int,
562
    fifteendirecttransaction int,
563
    demographicpurchaseid int,
564
    threedirecttransaction int,
565
    oneindirecttransaction int,
566
    onedirecttransaction int,
567
    favshoptotal int,
568
    threefavitemtotal int,
569
    directtransactionshipping int,
570
    oneindirecttransactionshipping int,
571
    PRIMARY KEY (custid,thedate,campaignid,demographicsexid,demographicpurchaseid,demographicstarid)
572
) COMPRESSION='lz4_1.0' ;
573

574
CREATE TABLE IF NOT EXISTS rpt_bpp4p_campaign_name_000(
575
    memeberid int,
576
    thedate datetime(6),
577
    campaignid int,
578
    campaigintitle varchar(1024),
579
    custid int,
580
    campaigntype int,
581
    PRIMARY KEY (custid,thedate,campaignid)
582
) COMPRESSION='lz4_1.0' ;
583

584
CREATE TABLE IF NOT EXISTS rpt_bpp4p_insight_bidword_000(
585
    mechanism int,
586
    competition int,
587
    indirecttransaction int,
588
    ext1 int,
589
    indirecttransactionshipping int,
590
    network int,
591
    directtransaction int,
592
    impression int,
593
    bidwordstr varchar(512),
594
    click int,
595
    ext2 int,
596
    thedate datetime(6),
597
    bidwordhash int,
598
    directtransactionshipping int,
599
    favitemtotal int,
600
    cost int,
601
    favshoptotal int,
602
    PRIMARY KEY (bidwordhash,thedate,network,mechanism,ext1,ext2,bidwordstr)
603
) COMPRESSION='lz4_1.0' ;
604

605
CREATE TABLE IF NOT EXISTS rpt_bpp4p_insight_bidword_category_000(
606
    click int,
607
    ext2 int,
608
    bidwordstr varchar(300),
609
    impression int,
610
    indirecttransactionshipping int,
611
    ext1 int,
612
    network int,
613
    directtransaction int,
614
    indirecttransaction int,
615
    mechanism int,
616
    competition int,
617
    favshoptotal int,
618
    cost int,
619
    favitemtotal int,
620
    directtransactionshipping int,
621
    bidwordhash int,
622
    thedate datetime(6),
623
    category int,
624
    PRIMARY KEY (category,bidwordhash,thedate,network,mechanism,ext1,ext2,bidwordstr)
625
) COMPRESSION='lz4_1.0' ;
626

627
CREATE TABLE IF NOT EXISTS rpt_bpp4p_demographic_name_sex_000(
628
    name varchar(100),
629
    thedate datetime(6),
630
    demographicid int,
631
    PRIMARY KEY (demographicid)
632
) COMPRESSION='lz4_1.0' ;
633

634
CREATE TABLE IF NOT EXISTS rpt_bpp4p_pos_ob_000(
635
    threedirecttransactionshipping int,
636
    fifteendirecttransaction int,
637
    auctionid int,
638
    oneindirecttransaction int,
639
    threedirecttransaction int,
640
    dimid int,
641
    onedirecttransaction int,
642
    favshoptotal int,
643
    threefavitemtotal int,
644
    oneindirecttransactionshipping int,
645
    directtransactionshipping int,
646
    sevenindirecttransaction int,
647
    onedirecttransactionshipping int,
648
    indirecttransactionshipping int,
649
    onefavitemtotal int,
650
    sevendirecttransaction int,
651
    fifteenindirecttransaction int,
652
    sevenfavshoptotal int,
653
    indirecttransaction int,
654
    threeindirecttransaction int,
655
    sevendirecttransactionshipping int,
656
    threeindirecttransactionshipping int,
657
    impression int,
658
    threefavshoptotal int,
659
    placeid int,
660
    sevenfavitemtotal int,
661
    fifteenfavshoptotal int,
662
    isshop int,
663
    fifteenindirecttransactionshipping int,
664
    fifteenfavitemtotal int,
665
    thedate datetime(6),
666
    fifteendirecttransactionshipping int,
667
    favitemtotal int,
668
    cost int,
669
    campaignid int,
670
    memberid int,
671
    sevenindirecttransactionshipping int,
672
    adgroupid int,
673
    directtransaction int,
674
    invalidclick int,
675
    onefavshoptotal int,
676
    click int,
677
    custid int,
678
    PRIMARY KEY (custid,thedate,campaignid,adgroupid,placeid)
679
) COMPRESSION='lz4_1.0' ;
680

681
CREATE TABLE IF NOT EXISTS rpt_bpp4p_campaign_ob_000(
682
    searchtype int,
683
    oneindirecttransaction int,
684
    threedirecttransaction int,
685
    threedirecttransactionshipping int,
686
    fifteendirecttransaction int,
687
    threefavitemtotal int,
688
    matchscope int,
689
    directtransactionshipping int,
690
    oneindirecttransactionshipping int,
691
    onedirecttransaction int,
692
    favshoptotal int,
693
    sevenfavshoptotal int,
694
    fifteenindirecttransaction int,
695
    sevendirecttransaction int,
696
    sevendirecttransactionshipping int,
697
    threeindirecttransaction int,
698
    indirecttransaction int,
699
    onefavitemtotal int,
700
    indirecttransactionshipping int,
701
    onedirecttransactionshipping int,
702
    sevenindirecttransaction int,
703
    threefavshoptotal int,
704
    impression int,
705
    sevenfavitemtotal int,
706
    ranksum int,
707
    threeindirecttransactionshipping int,
708
    fifteendirecttransactionshipping int,
709
    fifteenfavshoptotal int,
710
    isshop int,
711
    fifteenfavitemtotal int,
712
    fifteenindirecttransactionshipping int,
713
    thedate datetime(6),
714
    sevenindirecttransactionshipping int,
715
    memberid int,
716
    favitemtotal int,
717
    campaignid int,
718
    cost int,
719
    invalidclick int,
720
    network int,
721
    directtransaction int,
722
    onefavshoptotal int,
723
    custid int,
724
    click int,
725
    PRIMARY KEY (custid,thedate,campaignid,network,matchscope,searchtype,isshop)
726
) COMPRESSION='lz4_1.0' ;
727

728
CREATE TABLE IF NOT EXISTS rpt_bpp4p_area_name_000(
729
    cityid int,
730
    cityname varchar(100),
731
    provinceid int,
732
    provincename varchar(100),
733
    PRIMARY KEY (provinceid,cityid)
734
) COMPRESSION='lz4_1.0' ;
735

736
drop database createsql;
737