oceanbase

1
drop database if exists createvarchar;
2
create database createvarchar;
3
use createvarchar;
4
CREATE TABLE IF NOT EXISTS rpt_chenfeng_custid_shishi_000(
5
thedate datetime(6),
6
puttype varchar(124),
7
sourcetype varchar(124),
8
clickprice varchar(124),
9
click varchar(124),
10
custid varchar(124),
11
impression varchar(124),
12
PRIMARY KEY (custid,thedate,puttype,sourcetype)
13
)  COMPRESSION='lz4_1.0' ;
14
CREATE TABLE IF NOT EXISTS rpt_solar_feed_bidword_ob_000(
15
bidwordid varchar(124),
16
searchtype varchar(124),
17
thedate datetime(6),
18
adgroupid varchar(124),
19
freeclick varchar(124),
20
directtransactionshipping varchar(124),
21
matchscope varchar(124),
22
memberid varchar(124),
23
feedid varchar(124),
24
favshoptotal varchar(124),
25
cost varchar(124),
26
campaignid varchar(124),
27
favitemtotal varchar(124),
28
indirecttransaction varchar(124),
29
gmt_created datetime default now(),
30
gmt_modified datetime default now(),
31
directtransaction varchar(124),
32
indirecttransactionshipping varchar(124),
33
network varchar(124),
34
invalidclick varchar(124),
35
bidwordstr varchar(300),
36
custid varchar(124),
37
impression varchar(124),
38
itemid varchar(124),
39
click varchar(124),
40
ranksum varchar(124),
41
PRIMARY KEY (custid,thedate,campaignid,adgroupid,bidwordid,feedid,network,matchscope)
42
)  COMPRESSION='lz4_1.0' ;
43
CREATE TABLE IF NOT EXISTS rpt_chenfeng_campaignid_lixian_000(
44
thedate datetime(6),
45
sourcetype varchar(124),
46
custid varchar(124),
47
impression varchar(124),
48
puttype varchar(124),
49
campaignid varchar(124),
50
clickprice varchar(124),
51
click varchar(124),
52
PRIMARY KEY (custid,thedate,campaignid,puttype,sourcetype)
53
)  COMPRESSION='lz4_1.0' ;
54
CREATE TABLE IF NOT EXISTS rpt_bpp4p_bidword_ob_000(
55
click varchar(124),
56
bidwordstr varchar(300),
57
custid varchar(124),
58
onefavshoptotal varchar(124),
59
directtransaction varchar(124),
60
invalidclick varchar(124),
61
network varchar(124),
62
campaignid varchar(124),
63
cost varchar(124),
64
favitemtotal varchar(124),
65
adgroupid varchar(124),
66
memberid varchar(124),
67
sevenindirecttransactionshipping varchar(124),
68
fifteenfavitemtotal varchar(124),
69
thedate datetime(6),
70
fifteenindirecttransactionshipping varchar(124),
71
isshop varchar(124),
72
fifteenfavshoptotal varchar(124),
73
fifteendirecttransactionshipping varchar(124),
74
threeindirecttransactionshipping varchar(124),
75
ranksum varchar(124),
76
sevenfavitemtotal varchar(124),
77
impression varchar(124),
78
threefavshoptotal varchar(124),
79
sevenindirecttransaction varchar(124),
80
indirecttransactionshipping varchar(124),
81
onedirecttransactionshipping varchar(124),
82
onefavitemtotal varchar(124),
83
indirecttransaction varchar(124),
84
threeindirecttransaction varchar(124),
85
sevendirecttransactionshipping varchar(124),
86
sevendirecttransaction varchar(124),
87
sevenfavshoptotal varchar(124),
88
fifteenindirecttransaction varchar(124),
89
favshoptotal varchar(124),
90
onedirecttransaction varchar(124),
91
oneindirecttransactionshipping varchar(124),
92
matchscope varchar(124),
93
directtransactionshipping varchar(124),
94
threefavitemtotal varchar(124),
95
fifteendirecttransaction varchar(124),
96
threedirecttransactionshipping varchar(124),
97
oneindirecttransaction varchar(124),
98
threedirecttransaction varchar(124),
99
bidwordid varchar(124),
100
searchtype varchar(124),
101
PRIMARY KEY (custid,thedate,campaignid,adgroupid,bidwordid,network,matchscope)
102
)  COMPRESSION='lz4_1.0' ;
103
CREATE TABLE IF NOT EXISTS rpt_bpp4p_adgroupplace_name_000(
104
placeid varchar(124),
105
placename varchar(100),
106
thedate datetime(6),
107
PRIMARY KEY (placeid)
108
)  COMPRESSION='lz4_1.0' ;
109
CREATE TABLE IF NOT EXISTS rpt_chenfeng_custid_shishi_accumulative_000(
110
custid varchar(124),
111
impression varchar(124),
112
sourcetype varchar(124),
113
puttype varchar(124),
114
thedate datetime(6),
115
clickprice varchar(124),
116
click varchar(124),
117
PRIMARY KEY (custid,thedate,puttype,sourcetype)
118
)  COMPRESSION='lz4_1.0' ;
119
CREATE TABLE IF NOT EXISTS rpt_bpp4p_querysession_ob_000(
120
relword varchar(3000),
121
originalword varchar(300),
122
PRIMARY KEY (originalword)
123
)  COMPRESSION='lz4_1.0' ;
124
CREATE TABLE IF NOT EXISTS rpt_bpp4p_area_ob_000(
125
onedirecttransaction varchar(124),
126
favshoptotal varchar(124),
127
threefavitemtotal varchar(124),
128
oneindirecttransactionshipping varchar(124),
129
directtransactionshipping varchar(124),
130
provinceid varchar(124),
131
threedirecttransactionshipping varchar(124),
132
fifteendirecttransaction varchar(124),
133
oneindirecttransaction varchar(124),
134
threedirecttransaction varchar(124),
135
ext2 varchar(124),
136
threeindirecttransactionshipping varchar(124),
137
threefavshoptotal varchar(124),
138
impression varchar(124),
139
sevenfavitemtotal varchar(124),
140
ext1 varchar(124),
141
onedirecttransactionshipping varchar(124),
142
indirecttransactionshipping varchar(124),
143
onefavitemtotal varchar(124),
144
sevenindirecttransaction varchar(124),
145
sevenfavshoptotal varchar(124),
146
fifteenindirecttransaction varchar(124),
147
sevendirecttransaction varchar(124),
148
cityid varchar(124),
149
sevendirecttransactionshipping varchar(124),
150
threeindirecttransaction varchar(124),
151
indirecttransaction varchar(124),
152
favitemtotal varchar(124),
153
productid varchar(124),
154
campaignid varchar(124),
155
cost varchar(124),
156
sevenindirecttransactionshipping varchar(124),
157
memberid varchar(124),
158
fifteenfavshoptotal varchar(124),
159
fifteenfavitemtotal varchar(124),
160
fifteenindirecttransactionshipping varchar(124),
161
thedate datetime(6),
162
fifteendirecttransactionshipping varchar(124),
163
click varchar(124),
164
traffictype varchar(124),
165
custid varchar(124),
166
invalidclick varchar(124),
167
productline varchar(124),
168
directtransaction varchar(124),
169
onefavshoptotal varchar(124),
170
mechanism varchar(124),
171
PRIMARY KEY (custid,thedate,campaignid,traffictype,mechanism,provinceid,cityid,productline,productid,ext1,ext2)
172
)  COMPRESSION='lz4_1.0' ;
173
CREATE TABLE IF NOT EXISTS rpt_bpp4p_insight_bidword_area_000(
174
indirecttransaction varchar(124),
175
mechanism varchar(124),
176
competition varchar(124),
177
area varchar(124),
178
indirecttransactionshipping varchar(124),
179
network varchar(124),
180
ext1 varchar(124),
181
directtransaction varchar(124),
182
bidwordstr varchar(300),
183
impression varchar(124),
184
click varchar(124),
185
ext2 varchar(124),
186
thedate datetime(6),
187
directtransactionshipping varchar(124),
188
bidwordhash varchar(124),
189
cost varchar(124),
190
favshoptotal varchar(124),
191
favitemtotal varchar(124),
192
PRIMARY KEY (bidwordhash,thedate,area,network,mechanism,ext1,ext2,bidwordstr)
193
)  COMPRESSION='lz4_1.0' ;
194
CREATE TABLE IF NOT EXISTS rpt_solar_feed_name_000(
195
gmt_created datetime default now(),
196
gmt_modified datetime default now(),
197
thedate datetime(6),
198
linkurl varchar(124),
199
adgroupid varchar(124),
200
custid varchar(124),
201
title varchar(124),
202
memberid varchar(124),
203
imgurl varchar(124),
204
feedid varchar(124),
205
campaignid varchar(124),
206
PRIMARY KEY (custid,thedate,campaignid,adgroupid,feedid)
207
)  COMPRESSION='lz4_1.0' ;
208
CREATE TABLE IF NOT EXISTS rpt_chenfeng_custid_lixian_accumulative_000(
209
clickprice varchar(124),
210
click varchar(124),
211
sourcetype varchar(124),
212
puttype varchar(124),
213
thedate datetime(6),
214
impression varchar(124),
215
custid varchar(124),
216
PRIMARY KEY (custid,thedate,puttype,sourcetype)
217
)  COMPRESSION='lz4_1.0' ;
218
CREATE TABLE IF NOT EXISTS rpt_bpp4p_creative_name_000(
219
is_shop varchar(124),
220
thedate datetime(6),
221
linkurl varchar(124),
222
adgroupid varchar(124),
223
title varchar(124),
224
custid varchar(124),
225
creativeid varchar(124),
226
memberid varchar(124),
227
imgurl varchar(124),
228
campaignid varchar(124),
229
PRIMARY KEY (custid,thedate,campaignid,adgroupid,creativeid)
230
)  COMPRESSION='lz4_1.0' ;
231
CREATE TABLE IF NOT EXISTS rpt_bpp4p_demographic_name_000(
232
name varchar(100),
233
demographicid varchar(124),
234
thedate datetime(6),
235
PRIMARY KEY (demographicid)
236
)  COMPRESSION='lz4_1.0' ;
237
CREATE TABLE IF NOT EXISTS rpt_bpp4p_demographic_name_star_000(
238
thedate datetime(6),
239
demographicid varchar(124),
240
name varchar(100),
241
PRIMARY KEY (demographicid)
242
)  COMPRESSION='lz4_1.0' ;
243
CREATE TABLE IF NOT EXISTS rpt_solar_item_ob_000(
244
indirecttransactionshipping varchar(124),
245
ext1 varchar(124),
246
onedirecttransactionshipping varchar(124),
247
onefavitemtotal varchar(124),
248
sevenindirecttransaction varchar(124),
249
fifteenindirecttransaction varchar(124),
250
sevenfavshoptotal varchar(124),
251
productlineid varchar(124),
252
sevendirecttransaction varchar(124),
253
sevendirecttransactionshipping varchar(124),
254
threeindirecttransaction varchar(124),
255
indirecttransaction varchar(124),
256
ranksum varchar(124),
257
ext2 varchar(124),
258
threeindirecttransactionshipping varchar(124),
259
threefavshoptotal varchar(124),
260
impression varchar(124),
261
sevenfavitemtotal varchar(124),
262
creativeid varchar(124),
263
threedirecttransactionshipping varchar(124),
264
fifteendirecttransaction varchar(124),
265
searchtype varchar(124),
266
rptext2 varchar(124),
267
threedirecttransaction varchar(124),
268
oneindirecttransaction varchar(124),
269
onedirecttransaction varchar(124),
270
favshoptotal varchar(124),
271
entityid varchar(124),
272
creativepv varchar(124),
273
threefavitemtotal varchar(124),
274
oneindirecttransactionshipping varchar(124),
275
directtransactionshipping varchar(124),
276
invalidclick varchar(124),
277
directtransaction varchar(124),
278
onefavshoptotal varchar(124),
279
rptext1 varchar(124),
280
click varchar(124),
281
traffictype varchar(124),
282
custid varchar(124),
283
entitytype varchar(124),
284
fifteenfavshoptotal varchar(124),
285
thedate datetime(6),
286
fifteenfavitemtotal varchar(124),
287
fifteenindirecttransactionshipping varchar(124),
288
fifteendirecttransactionshipping varchar(124),
289
favitemtotal varchar(124),
290
productid varchar(124),
291
cost varchar(124),
292
areaid varchar(124),
293
campaignid varchar(124),
294
feedid varchar(124),
295
sevenindirecttransactionshipping varchar(124),
296
memberid varchar(124),
297
adgroupid varchar(124),
298
PRIMARY KEY (memberid,thedate,productlineid,campaignid,adgroupid,creativeid,areaid,entityid,entitytype,traffictype,searchtype,productid,ext1,ext2)
299
)  COMPRESSION='lz4_1.0' ;
300
CREATE TABLE IF NOT EXISTS rpt_p4p_bidword_normtoorigin_000(
301
normalword varchar(300),
302
originalword varchar(300),
303
PRIMARY KEY (normalword)
304
)  COMPRESSION='lz4_1.0' ;
305
CREATE TABLE IF NOT EXISTS rpt_chenfeng_campaignid_lixian_accumulative_000(
306
click varchar(124),
307
clickprice varchar(124),
308
puttype varchar(124),
309
campaignid varchar(124),
310
impression varchar(124),
311
custid varchar(124),
312
thedate datetime(6),
313
sourcetype varchar(124),
314
PRIMARY KEY (custid,thedate,campaignid,puttype,sourcetype)
315
)  COMPRESSION='lz4_1.0' ;
316
CREATE TABLE IF NOT EXISTS rpt_chenfeng_custid_lixian_000(
317
custid varchar(124),
318
impression varchar(124),
319
sourcetype varchar(124),
320
puttype varchar(124),
321
thedate datetime(6),
322
click varchar(124),
323
clickprice varchar(124),
324
PRIMARY KEY (custid,thedate,puttype,sourcetype)
325
)  COMPRESSION='lz4_1.0' ;
326
CREATE TABLE IF NOT EXISTS rpt_chenfeng_campaignid_shishi_000(
327
thedate datetime(6),
328
sourcetype varchar(124),
329
custid varchar(124),
330
impression varchar(124),
331
campaignid varchar(124),
332
puttype varchar(124),
333
click varchar(124),
334
clickprice varchar(124),
335
PRIMARY KEY (custid,thedate,campaignid,puttype,sourcetype)
336
)  COMPRESSION='lz4_1.0' ;
337
CREATE TABLE IF NOT EXISTS rpt_chenfeng_campaignid_shishi_accumulative_000(
338
clickprice varchar(124),
339
click varchar(124),
340
puttype varchar(124),
341
campaignid varchar(124),
342
impression varchar(124),
343
custid varchar(124),
344
sourcetype varchar(124),
345
thedate datetime(6),
346
PRIMARY KEY (custid,thedate,campaignid,puttype,sourcetype)
347
)  COMPRESSION='lz4_1.0' ;
348
CREATE TABLE IF NOT EXISTS rpt_bpp4p_custom_ob_000(
349
oneindirecttransaction varchar(124),
350
threedirecttransaction varchar(124),
351
fifteendirecttransaction varchar(124),
352
threedirecttransactionshipping varchar(124),
353
directtransactionshipping varchar(124),
354
oneindirecttransactionshipping varchar(124),
355
threefavitemtotal varchar(124),
356
favshoptotal varchar(124),
357
onedirecttransaction varchar(124),
358
indirecttransaction varchar(124),
359
threeindirecttransaction varchar(124),
360
sevendirecttransactionshipping varchar(124),
361
sevendirecttransaction varchar(124),
362
sevenfavshoptotal varchar(124),
363
fifteenindirecttransaction varchar(124),
364
sevenindirecttransaction varchar(124),
365
onedirecttransactionshipping varchar(124),
366
indirecttransactionshipping varchar(124),
367
onefavitemtotal varchar(124),
368
sevenfavitemtotal varchar(124),
369
impression varchar(124),
370
threefavshoptotal varchar(124),
371
threeindirecttransactionshipping varchar(124),
372
ranksum varchar(124),
373
fifteendirecttransactionshipping varchar(124),
374
fifteenfavitemtotal varchar(124),
375
fifteenindirecttransactionshipping varchar(124),
376
thedate datetime(6),
377
fifteenfavshoptotal varchar(124),
378
memberid varchar(124),
379
sevenindirecttransactionshipping varchar(124),
380
cost varchar(124),
381
favitemtotal varchar(124),
382
onefavshoptotal varchar(124),
383
directtransaction varchar(124),
384
invalidclick varchar(124),
385
custid varchar(124),
386
click varchar(124),
387
PRIMARY KEY (custid,thedate)
388
)  COMPRESSION='lz4_1.0' ;
389
CREATE TABLE IF NOT EXISTS rpt_bpp4p_demographic_name_purchase_000(
390
demographicid varchar(124),
391
thedate datetime(6),
392
name varchar(100),
393
PRIMARY KEY (demographicid)
394
)  COMPRESSION='lz4_1.0' ;
395
CREATE TABLE IF NOT EXISTS rpt_bpp4p_tag_000(
396
name varchar(300),
397
gmt_created datetime default now(),
398
id varchar(124),
399
type varchar(124),
400
gmt_modified datetime default now(),
401
PRIMARY KEY (id)
402
)  COMPRESSION='lz4_1.0' ;
403
CREATE TABLE IF NOT EXISTS rpt_bpp4p_adgroup_ob_000(
404
adgroupid varchar(124),
405
sevenindirecttransactionshipping varchar(124),
406
memberid varchar(124),
407
cost varchar(124),
408
campaignid varchar(124),
409
favitemtotal varchar(124),
410
fifteendirecttransactionshipping varchar(124),
411
fifteenindirecttransactionshipping varchar(124),
412
fifteenfavitemtotal varchar(124),
413
thedate datetime(6),
414
isshop varchar(124),
415
fifteenfavshoptotal varchar(124),
416
custid varchar(124),
417
click varchar(124),
418
onefavshoptotal varchar(124),
419
invalidclick varchar(124),
420
network varchar(124),
421
directtransaction varchar(124),
422
oneindirecttransactionshipping varchar(124),
423
directtransactionshipping varchar(124),
424
matchscope varchar(124),
425
threefavitemtotal varchar(124),
426
favshoptotal varchar(124),
427
onedirecttransaction varchar(124),
428
threedirecttransaction varchar(124),
429
oneindirecttransaction varchar(124),
430
searchtype varchar(124),
431
auctionid varchar(124),
432
fifteendirecttransaction varchar(124),
433
threedirecttransactionshipping varchar(124),
434
sevenfavitemtotal varchar(124),
435
creativeid varchar(124),
436
threefavshoptotal varchar(124),
437
impression varchar(124),
438
threeindirecttransactionshipping varchar(124),
439
ranksum varchar(124),
440
sevendirecttransactionshipping varchar(124),
441
threeindirecttransaction varchar(124),
442
indirecttransaction varchar(124),
443
fifteenindirecttransaction varchar(124),
444
sevenfavshoptotal varchar(124),
445
sevendirecttransaction varchar(124),
446
onefavitemtotal varchar(124),
447
indirecttransactionshipping varchar(124),
448
onedirecttransactionshipping varchar(124),
449
sevenindirecttransaction varchar(124),
450
PRIMARY KEY (custid,thedate,campaignid,adgroupid,creativeid,network,matchscope,searchtype)
451
)  COMPRESSION='lz4_1.0' ;
452
CREATE TABLE IF NOT EXISTS rpt_bpp4p_dim_000(
453
gmt_modified datetime default now(),
454
id varchar(124),
455
name varchar(300),
456
gmt_created datetime default now(),
457
PRIMARY KEY (id)
458
)  COMPRESSION='lz4_1.0' ;
459
CREATE TABLE IF NOT EXISTS rpt_bpp4p_adgroup_name_000(
460
title varchar(124),
461
custid varchar(124),
462
adgroupid varchar(124),
463
memberid varchar(124),
464
campaignid varchar(124),
465
imgurl varchar(124),
466
auctionid varchar(124),
467
thedate datetime(6),
468
isshop varchar(124),
469
linkurl varchar(124),
470
PRIMARY KEY (custid,thedate,campaignid,adgroupid)
471
)  COMPRESSION='lz4_1.0' ;
472
CREATE TABLE IF NOT EXISTS rpt_bpp4p_insight_bidword_price_000(
473
indirecttransaction varchar(124),
474
competition varchar(124),
475
mechanism varchar(124),
476
directtransaction varchar(124),
477
ext1 varchar(124),
478
indirecttransactionshipping varchar(124),
479
network varchar(124),
480
bidwordstr varchar(300),
481
impression varchar(124),
482
ext2 varchar(124),
483
click varchar(124),
484
pricedistribution varchar(124),
485
thedate datetime(6),
486
directtransactionshipping varchar(124),
487
bidwordhash varchar(124),
488
favshoptotal varchar(124),
489
cost varchar(124),
490
favitemtotal varchar(124),
491
PRIMARY KEY (bidwordhash,thedate,pricedistribution,network,mechanism,ext1,ext2,bidwordstr)
492
)  COMPRESSION='lz4_1.0' ;
493
CREATE TABLE IF NOT EXISTS rpt_bpp4p_sexpowerstar_ob_000(
494
directtransaction varchar(124),
495
invalidclick varchar(124),
496
onefavshoptotal varchar(124),
497
click varchar(124),
498
custid varchar(124),
499
fifteenfavshoptotal varchar(124),
500
fifteenfavitemtotal varchar(124),
501
thedate datetime(6),
502
fifteenindirecttransactionshipping varchar(124),
503
fifteendirecttransactionshipping varchar(124),
504
demographicstarid varchar(124),
505
demographicsexid varchar(124),
506
favitemtotal varchar(124),
507
campaignid varchar(124),
508
cost varchar(124),
509
memberid varchar(124),
510
sevenindirecttransactionshipping varchar(124),
511
sevenindirecttransaction varchar(124),
512
onefavitemtotal varchar(124),
513
indirecttransactionshipping varchar(124),
514
onedirecttransactionshipping varchar(124),
515
sevendirecttransaction varchar(124),
516
fifteenindirecttransaction varchar(124),
517
sevenfavshoptotal varchar(124),
518
indirecttransaction varchar(124),
519
threeindirecttransaction varchar(124),
520
sevendirecttransactionshipping varchar(124),
521
threeindirecttransactionshipping varchar(124),
522
impression varchar(124),
523
threefavshoptotal varchar(124),
524
sevenfavitemtotal varchar(124),
525
threedirecttransactionshipping varchar(124),
526
fifteendirecttransaction varchar(124),
527
demographicpurchaseid varchar(124),
528
threedirecttransaction varchar(124),
529
oneindirecttransaction varchar(124),
530
onedirecttransaction varchar(124),
531
favshoptotal varchar(124),
532
threefavitemtotal varchar(124),
533
directtransactionshipping varchar(124),
534
oneindirecttransactionshipping varchar(124),
535
PRIMARY KEY (custid,thedate,campaignid,demographicsexid,demographicpurchaseid,demographicstarid)
536
)  COMPRESSION='lz4_1.0' ;
537
CREATE TABLE IF NOT EXISTS rpt_bpp4p_campaign_name_000(
538
memeberid varchar(124),
539
thedate datetime(6),
540
campaignid varchar(124),
541
campaigintitle varchar(124),
542
custid varchar(124),
543
campaigntype varchar(124),
544
PRIMARY KEY (custid,thedate,campaignid)
545
)  COMPRESSION='lz4_1.0' ;
546
CREATE TABLE IF NOT EXISTS rpt_bpp4p_insight_bidword_000(
547
mechanism varchar(124),
548
competition varchar(124),
549
indirecttransaction varchar(124),
550
ext1 varchar(124),
551
indirecttransactionshipping varchar(124),
552
network varchar(124),
553
directtransaction varchar(124),
554
impression varchar(124),
555
bidwordstr varchar(512),
556
click varchar(124),
557
ext2 varchar(124),
558
thedate datetime(6),
559
bidwordhash varchar(124),
560
directtransactionshipping varchar(124),
561
favitemtotal varchar(124),
562
cost varchar(124),
563
favshoptotal varchar(124),
564
PRIMARY KEY (bidwordhash,thedate,network,mechanism,ext1,ext2,bidwordstr)
565
)  COMPRESSION='lz4_1.0' ;
566
CREATE TABLE IF NOT EXISTS rpt_bpp4p_insight_bidword_category_000(
567
click varchar(124),
568
ext2 varchar(124),
569
bidwordstr varchar(300),
570
impression varchar(124),
571
indirecttransactionshipping varchar(124),
572
ext1 varchar(124),
573
network varchar(124),
574
directtransaction varchar(124),
575
indirecttransaction varchar(124),
576
mechanism varchar(124),
577
competition varchar(124),
578
favshoptotal varchar(124),
579
cost varchar(124),
580
favitemtotal varchar(124),
581
directtransactionshipping varchar(124),
582
bidwordhash varchar(124),
583
thedate datetime(6),
584
category varchar(124),
585
PRIMARY KEY (category,bidwordhash,thedate,network,mechanism,ext1,ext2,bidwordstr)
586
)  COMPRESSION='lz4_1.0' ;
587
CREATE TABLE IF NOT EXISTS rpt_bpp4p_demographic_name_sex_000(
588
name varchar(100),
589
thedate datetime(6),
590
demographicid varchar(124),
591
PRIMARY KEY (demographicid)
592
)  COMPRESSION='lz4_1.0' ;
593
CREATE TABLE IF NOT EXISTS rpt_bpp4p_pos_ob_000(
594
threedirecttransactionshipping varchar(124),
595
fifteendirecttransaction varchar(124),
596
auctionid varchar(124),
597
oneindirecttransaction varchar(124),
598
threedirecttransaction varchar(124),
599
dimid varchar(124),
600
onedirecttransaction varchar(124),
601
favshoptotal varchar(124),
602
threefavitemtotal varchar(124),
603
oneindirecttransactionshipping varchar(124),
604
directtransactionshipping varchar(124),
605
sevenindirecttransaction varchar(124),
606
onedirecttransactionshipping varchar(124),
607
indirecttransactionshipping varchar(124),
608
onefavitemtotal varchar(124),
609
sevendirecttransaction varchar(124),
610
fifteenindirecttransaction varchar(124),
611
sevenfavshoptotal varchar(124),
612
indirecttransaction varchar(124),
613
threeindirecttransaction varchar(124),
614
sevendirecttransactionshipping varchar(124),
615
threeindirecttransactionshipping varchar(124),
616
impression varchar(124),
617
threefavshoptotal varchar(124),
618
placeid varchar(124),
619
sevenfavitemtotal varchar(124),
620
fifteenfavshoptotal varchar(124),
621
isshop varchar(124),
622
fifteenindirecttransactionshipping varchar(124),
623
fifteenfavitemtotal varchar(124),
624
thedate datetime(6),
625
fifteendirecttransactionshipping varchar(124),
626
favitemtotal varchar(124),
627
cost varchar(124),
628
campaignid varchar(124),
629
memberid varchar(124),
630
sevenindirecttransactionshipping varchar(124),
631
adgroupid varchar(124),
632
directtransaction varchar(124),
633
invalidclick varchar(124),
634
onefavshoptotal varchar(124),
635
click varchar(124),
636
custid varchar(124),
637
PRIMARY KEY (custid,thedate,campaignid,adgroupid,placeid)
638
)  COMPRESSION='lz4_1.0' ;
639
CREATE TABLE IF NOT EXISTS rpt_bpp4p_campaign_ob_000(
640
searchtype varchar(124),
641
oneindirecttransaction varchar(124),
642
threedirecttransaction varchar(124),
643
threedirecttransactionshipping varchar(124),
644
fifteendirecttransaction varchar(124),
645
threefavitemtotal varchar(124),
646
matchscope varchar(124),
647
directtransactionshipping varchar(124),
648
oneindirecttransactionshipping varchar(124),
649
onedirecttransaction varchar(124),
650
favshoptotal varchar(124),
651
sevenfavshoptotal varchar(124),
652
fifteenindirecttransaction varchar(124),
653
sevendirecttransaction varchar(124),
654
sevendirecttransactionshipping varchar(124),
655
threeindirecttransaction varchar(124),
656
indirecttransaction varchar(124),
657
onefavitemtotal varchar(124),
658
indirecttransactionshipping varchar(124),
659
onedirecttransactionshipping varchar(124),
660
sevenindirecttransaction varchar(124),
661
threefavshoptotal varchar(124),
662
impression varchar(124),
663
sevenfavitemtotal varchar(124),
664
ranksum varchar(124),
665
threeindirecttransactionshipping varchar(124),
666
fifteendirecttransactionshipping varchar(124),
667
fifteenfavshoptotal varchar(124),
668
isshop varchar(124),
669
fifteenfavitemtotal varchar(124),
670
fifteenindirecttransactionshipping varchar(124),
671
thedate datetime(6),
672
sevenindirecttransactionshipping varchar(124),
673
memberid varchar(124),
674
favitemtotal varchar(124),
675
campaignid varchar(124),
676
cost varchar(124),
677
invalidclick varchar(124),
678
network varchar(124),
679
directtransaction varchar(124),
680
onefavshoptotal varchar(124),
681
custid varchar(124),
682
click varchar(124),
683
PRIMARY KEY (custid,thedate,campaignid,network,matchscope,searchtype,isshop)
684
)  COMPRESSION='lz4_1.0' ;
685
CREATE TABLE IF NOT EXISTS rpt_bpp4p_area_name_000(
686
cityid varchar(124),
687
cityname varchar(100),
688
provinceid varchar(124),
689
provincename varchar(100),
690
PRIMARY KEY (provinceid,cityid)
691
)  COMPRESSION='lz4_1.0' ;
692
set @@recyclebin = off;
693
drop database createvarchar;
694