oceanbase

1
DROP TABLE if exists trade_sequence_000;
2
DROP TABLE if exists BUSINESS_ACTION_000;
3
DROP TABLE if exists BUSINESS_ACTIVITY_000;
4
DROP TABLE if exists NOTIFY_000 ;
5
DROP TABLE if exists NOTIFY_HISTORY_000 ;
6
DROP TABLE if exists TIMEOUT_000 ;
7
DROP TABLE if exists TIMEOUT_HISTORY_000 ;
8
DROP TABLE if exists TIMEOUT_LONG_000 ;
9
DROP TABLE if exists TIMEOUT_REMIND_000;
10
DROP TABLE if exists TRADE_BASE_000 ;
11
DROP TABLE if exists TRADE_CHARGE_000;
12
DROP TABLE if exists TRADE_EXT_000 ;
13
DROP TABLE if exists TRADE_FUND_BILL_000 ;
14
DROP TABLE if exists TRADE_GOODS_INFO_000 ;
15
DROP TABLE if exists TRADE_LOGISTICS_000;
16
DROP TABLE if exists TRADE_MESSAGE_BOARD_000 ;
17
DROP TABLE if exists TRADE_NOTE_000 ;
18
DROP TABLE if exists TRADE_OUTTRADE_000 ;
19
DROP TABLE if exists TRADE_PAYMENT_CLAUSE_000 ;
20
DROP TABLE if exists TRADE_PAYMENT_ORDER_000 ;
21
DROP TABLE if exists TRADE_PROCESS_000 ;
22
DROP TABLE if exists TRADE_REFUND_000 ;
23
DROP TABLE if exists TRADE_VOUCHER_000 ;
24
DROP TABLE if exists TRADE_RECEIVE_ADDRESS_000;
25
DROP TABLE if exists TRADE_COOPERATE_000;
26
DROP TABLE if exists TRADE_SETTLE_ORDER_000;
27
DROP TABLE if exists TRADE_PARTICIPANT_000;
28
DROP TABLE if exists BUSINESS_ACTIVITY_ASYNC_000;
29
DROP TABLE if exists EXTERFACE_INVOKE_000;
30
CREATE TABLE if not exists trade_sequence_000
31
(
32
name varchar(256),
33
value int,
34
min_value int,
35
max_value int,
36
step int,
37
gmt_create TIMESTAMP(6) default "2012-01-01 12:00:00",
38
gmt_modified TIMESTAMP(6) default "2012-01-01 12:00:00",
39
primary key (name)
40
) DEFAULT CHARSET = 'utf8';
41
CREATE TABLE if not exists BUSINESS_ACTION_000 
42
(
43
ACTION_ID     int           NOT NULL,
44
TX_ID         varchar(128)   NOT NULL,
45
NAME          varchar(64)    NOT NULL,
46
STATE         CHAR(1)         NOT NULL,
47
GMT_CREATE    TIMESTAMP         NOT NULL,
48
GMT_MODIFIED  TIMESTAMP         NOT NULL,
49
CONTEXT       varchar(4000),
50
primary key (ACTION_ID)
51
) DEFAULT CHARSET = 'utf8';
52
CREATE TABLE if not exists BUSINESS_ACTIVITY_000 
53
(
54
TX_ID                varchar(128)   NOT NULL,
55
STATE               	VARCHAR(1)         NOT NULL,
56
ACCOUNT_TRANS_STATE 	VARCHAR(1)         NOT NULL,
57
GMT_CREATE           TIMESTAMP         NOT NULL,
58
GMT_MODIFIED         TIMESTAMP         NOT NULL,
59
PROPAGATION         	VARCHAR(1),
60
CONTEXT              varchar(2048),
61
primary key (TX_ID)
62
) DEFAULT CHARSET = 'utf8';
63
CREATE TABLE if not exists NOTIFY_000 
64
(
65
ID                varchar(34)    NOT NULL,
66
PLUGIN            varchar(50)    NOT NULL,
67
PARAMETER         varchar(4000)  NOT NULL,
68
GROUP_NO          int            NOT NULL,
69
STATUS           	VARCHAR(1)         NOT NULL,
70
GMT_CREATE        TIMESTAMP         NOT NULL,
71
GMT_MODIFY        TIMESTAMP         NOT NULL,
72
IW_USER_ID        varchar(16),
73
CHANNEL_ENDPOINT  varchar(200),
74
BUSINESS_ORDER    varchar(128),
75
BUSINESS_TYPE     varchar(50),
76
PLUGIN_HOST       varchar(15),
77
GMT_LOCAL_CREATE  TIMESTAMP(6) default "2012-01-01 12:00:00",
78
primary key (id)
79
)DEFAULT CHARSET = 'utf8';
80
CREATE INDEX NOTIFY_BUSINESS_ORDER1_IND ON NOTIFY_000 (BUSINESS_ORDER);
81
CREATE INDEX NOTIFY_PLUGIN_IND ON NOTIFY_000 (PLUGIN, CHANNEL_ENDPOINT);
82
CREATE TABLE if not exists NOTIFY_HISTORY_000 
83
(
84
ID                varchar(34)    NOT NULL,
85
PLUGIN            varchar(50)    NOT NULL,
86
PARAMETER         varchar(4000)  NOT NULL,
87
GROUP_NO          int            NOT NULL,
88
STATUS           	VARCHAR(1)         NOT NULL,
89
GMT_CREATE        TIMESTAMP         NOT NULL,
90
GMT_MODIFY        TIMESTAMP         NOT NULL,
91
IW_USER_ID        varchar(16),
92
CHANNEL_ENDPOINT  varchar(200),
93
BUSINESS_ORDER    varchar(128),
94
BUSINESS_TYPE     varchar(50),
95
PLUGIN_HOST       varchar(15),
96
GMT_LOCAL_CREATE  TIMESTAMP(6) default "2012-01-01 12:00:00",
97
PRIMARY KEY (ID)
98
)DEFAULT CHARSET = 'utf8';
99
CREATE INDEX NOTIFY_HISTORY_000_BORDER_IND ON NOTIFY_HISTORY_000 (BUSINESS_ORDER);
100
CREATE INDEX NOTIFY_HISTORY_IG_IND ON NOTIFY_HISTORY_000 (IW_USER_ID, GROUP_NO);
101
CREATE TABLE if not exists TIMEOUT_000 
102
(
103
JOB_ID        varchar(32)   NOT NULL,
104
TRADE_NO      varchar(64),
105
USER_ID       varchar(128),
106
PAYTYPE       varchar(4),
107
END_TIME      TIMESTAMP(6) default "2012-01-01 12:00:00",
108
ACTION        varchar(30),
109
PARAMETER     varchar(100),
110
STATUS       	VARCHAR(1),
111
ACTION_TYPE  	VARCHAR(1),
112
GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00",
113
PRIOR_LEVEL   int default 1,
114
GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00",
115
GMT_OCCUR     TIMESTAMP(6) default "2012-01-01 12:00:00",
116
PRIMARY KEY (JOB_ID)
117
) DEFAULT CHARSET = 'utf8';
118
CREATE INDEX IND_BEYOND_TIMEOUT_ETIME ON TIMEOUT_000 (END_TIME);
119
CREATE INDEX TIMEOUT_000_PL_IND ON TIMEOUT_000 (PRIOR_LEVEL);
120
CREATE INDEX TIMEOUT_TNO_IND ON TIMEOUT_000 (TRADE_NO);
121
CREATE TABLE if not exists TIMEOUT_HISTORY_000 
122
(
123
JOB_ID        varchar(32)   NOT NULL,
124
TRADE_NO      varchar(64)   NOT NULL,
125
USER_ID       varchar(128),
126
PAYTYPE       varchar(4),
127
END_TIME      TIMESTAMP(6) default "2012-01-01 12:00:00",
128
ACTION        varchar(30),
129
PARAMETER     varchar(100),
130
STATUS       	VARCHAR(1),
131
ACTION_TYPE  	VARCHAR(1)        NOT NULL,
132
GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00",
133
PRIOR_LEVEL   int,
134
GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00",
135
GMT_OCCUR     TIMESTAMP(6) default "2012-01-01 12:00:00",
136
PRIMARY KEY (JOB_ID, TRADE_NO, ACTION_TYPE)
137
) DEFAULT CHARSET = 'utf8';
138
CREATE TABLE if not exists TIMEOUT_LONG_000 
139
(
140
JOB_ID        varchar(32)   NOT NULL,
141
TRADE_NO      varchar(64),
142
USER_ID       varchar(128),
143
PAYTYPE       varchar(4),
144
END_TIME      TIMESTAMP(6) default "2012-01-01 12:00:00",
145
ACTION        varchar(30),
146
PARAMETER     varchar(100),
147
STATUS       	VARCHAR(1),
148
ACTION_TYPE  	VARCHAR(1),
149
GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00",
150
PRIOR_LEVEL   int          ,
151
GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00",
152
GMT_OCCUR     TIMESTAMP(6) default "2012-01-01 12:00:00",
153
PRIMARY KEY (JOB_ID)
154
) DEFAULT CHARSET = 'utf8';
155
CREATE INDEX BYD_TIMEOUT_LONG_ENDTIME_IND ON TIMEOUT_LONG_000 (END_TIME);
156
CREATE INDEX TIMEOUT_LONG_000_PL_IND ON TIMEOUT_LONG_000 (PRIOR_LEVEL);
157
CREATE INDEX TIMEOUT_LONG_TNO_IND ON TIMEOUT_LONG_000 (TRADE_NO);
158
CREATE TABLE if not exists TIMEOUT_REMIND_000 
159
(
160
JOB_ID        varchar(32)   NOT NULL,
161
TRADE_NO      varchar(64),
162
USER_ID       varchar(128),
163
PAYTYPE       varchar(4),
164
END_TIME      TIMESTAMP(6) default "2012-01-01 12:00:00",
165
ACTION        varchar(30),
166
PARAMETER     varchar(100),
167
STATUS       	VARCHAR(1),
168
ACTION_TYPE  	VARCHAR(1),
169
GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00",
170
PRIOR_LEVEL   int          ,
171
GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00",
172
GMT_OCCUR     TIMESTAMP(6) default "2012-01-01 12:00:00",
173
PRIMARY KEY (JOB_ID)
174
) DEFAULT CHARSET = 'utf8';
175
CREATE INDEX BY_TIMEOUT_REMIND_ETIME_IND ON TIMEOUT_REMIND_000 (END_TIME);
176
CREATE INDEX TIMEOUT_REMIND_000_PL_IND ON TIMEOUT_REMIND_000 (PRIOR_LEVEL);
177
CREATE INDEX TIMEOUT_REMIND_TNO_IND ON TIMEOUT_REMIND_000 (TRADE_NO);
178
CREATE TABLE if not exists TRADE_BASE_000 
179
(
180
ID                     int           NOT NULL,
181
TRADE_NO               varchar(64)    NOT NULL,
182
OUT_TRADE_NO           varchar(64),
183
SELLER_ACCOUNT         varchar(100)   NOT NULL,
184
SELLER_LOGIN_EMAIL     varchar(100)   NOT NULL,
185
BUYER_ACCOUNT          varchar(100)   NOT NULL,
186
BUYER_LOGIN_EMAIL      varchar(100)   NOT NULL,
187
SELLER_TYPE            int,
188
BUYER_TYPE             int,
189
TRADE_FROM             varchar(100),
190
TRADE_EMAIL            varchar(100),
191
OPERATOR_ROLE          VARCHAR(1)     NOT NULL,
192
TRADE_STATUS           varchar(50)    NOT NULL,
193
TOTAL_FEE              int            default 0 NOT NULL,
194
SERVICE_FEE_RATIO      varchar(64),
195
SERVICE_FEE            int            default 0 NOT NULL,
196
CURRENCY               varchar(3),
197
SELLER_ACTION          varchar(200),
198
BUYER_ACTION           varchar(200),
199
GMT_CREATE             TIMESTAMP                 ,
200
SELLER_USER_ID         varchar(16),
201
BUYER_USER_ID          varchar(16),
202
ADDITIONAL_TRD_STATUS  varchar(50),
203
TRADE_TYPE             varchar(4)     NOT NULL,
204
SELLER_FULLNAME        varchar(256)   default '',
205
BUYER_FULLNAME         varchar(256)   default '',
206
SELLER_NICK            varchar(100)   default '' NOT NULL,
207
BUYER_NICK             varchar(100)   default '' NOT NULL,
208
GOODS_TITLE            varchar(256),
209
GMT_LAST_MODIFIED_DT   TIMESTAMP(6) default "2012-01-01 12:00:00",
210
STOP_TIMEOUT           varchar(4) 	default '0',
211
GATHERING_TYPE         varchar(4),
212
BUYER_MARKER           VARCHAR(1),
213
SELLER_MARKER          VARCHAR(1),
214
BUYER_MARKER_MEMO      varchar(1000),
215
SELLER_MARKER_MEMO     varchar(1000),
216
CHANNEL                varchar(32),
217
PRODUCT                varchar(20),
218
PAY_CHANNEL            varchar(32),
219
OTHER_SERVICE_FEE      int,
220
RELATION_PRO           varchar(64),
221
PLATFORM varchar(100),
222
CHANNEL_PARTNER varchar(100),
223
GOODS_TYPE      VARCHAR(4),
224
GOODS_SUB_TYPE  VARCHAR(4),
225
PRIMARY KEY (TRADE_NO)
226
)DEFAULT CHARSET = 'utf8';
227
CREATE INDEX BYD_TRADE_BASE_TEMAIL_GMTC_IND ON TRADE_BASE_000 
228
(TRADE_EMAIL, GMT_CREATE);
229
CREATE INDEX IND_BEYOND_TRADE_BASE_BUYGMT1 ON TRADE_BASE_000 
230
(BUYER_ACCOUNT, GMT_CREATE);
231
CREATE INDEX IND_BEYOND_TRADE_BASE_SALGMT1 ON TRADE_BASE_000 
232
(SELLER_ACCOUNT, GMT_CREATE);
233
CREATE TABLE if not exists TRADE_CHARGE_000 
234
(
235
ID                int           NOT NULL,
236
TRADE_NO          varchar(64)   NOT NULL,
237
GMT_CHARGE        TIMESTAMP     NOT NULL,
238
GMT_PAY           TIMESTAMP(6) default "2012-01-01 12:00:00",
239
CHARGE_OUT_DATE  	VARCHAR(8),
240
GMT_MODIFIED      TIMESTAMP(6) default "2012-01-01 12:00:00",
241
PLAN_CHARGE       int,
242
ACTUAL_CHARGE     int,
243
RATE_ID           int,
244
RATE              int,
245
RATE_ORIGIN      	VARCHAR(1),
246
PRODUCT_NAME      varchar(32),
247
CHARGE_TYPE       varchar(16),
248
SERVICE_EVENT_ID  int,
249
PAYMENT_BILL_ID   int,
250
SALES_ID          int,
251
PARTNER_ID        varchar(30),
252
DEBIT_ACCOUNT     varchar(20),
253
CREDIT_ACCOUNT    varchar(20),
254
BILL_STATUS      	VARCHAR(1),
255
SERVICE_AMOUNT    int,
256
TRADE_FROM        varchar(100),
257
DEBIT_USER_ID     varchar(16),
258
SERVICT_TYPE      varchar(8),
259
SUB_TRADE_NO      varchar(64),
260
primary key (TRADE_NO, SERVICT_TYPE,	CHARGE_TYPE, SUB_TRADE_NO)
261
)DEFAULT CHARSET = 'utf8';
262
CREATE INDEX TRADE_CHARGE_000_GMT_IND ON TRADE_CHARGE_000
263
(GMT_MODIFIED);
264
CREATE TABLE if not exists TRADE_EXT_000 
265
(
266
TRADE_NO               varchar(64)    NOT NULL,
267
EXT_INFO               varchar(1000),
268
TRADE_AGENT            varchar(30),
269
GMT_MODIFIED           TIMESTAMP(6) default "2012-01-01 12:00:00",
270
FP_TIME_OUT_RULE       varchar(1000),
271
FOREX_RATE_ID          int,
272
FOREX_CURRENCY         varchar(8),
273
FOREX_TOTAL_FEE        int,
274
GOODS_INNER_SELL_RATE  int,
275
PREPARE_COUPON_FEE     int,
276
PREPARE_COUPON_LIST    varchar(64),
277
FOREX_CERT_NO          varchar(128),
278
GMT_CREATE             TIMESTAMP(6) default "2012-01-01 12:00:00",
279
AUTH_DEBIT_TYPE        varchar(1),
280
SUPPORT_CREDIT_CARD    varchar(256),
281
SPECIFIED_PAY_CHANNEL  varchar(128),
282
CHARGE_CHANNEL_INFO    varchar(256),
283
PAY_CHANNELS           varchar(900),
284
PRIMARY KEY (TRADE_NO)
285
)DEFAULT CHARSET = 'utf8';
286
CREATE INDEX TRADE_EXT_000_GMT_IND ON TRADE_EXT_000 (GMT_MODIFIED);
287
CREATE TABLE if not exists TRADE_FUND_BILL_000 
288
(
289
BILL_NO             varchar(128)   NOT NULL,
290
TRADE_NO            varchar(64)    NOT NULL,
291
PAY_ACCOUNT_NO      varchar(20)    NOT NULL,
292
RECEIVE_ACCOUNT_NO  varchar(20)    NOT NULL,
293
CURRENCY            varchar(3)    default '156' NOT NULL,
294
AMOUNT              int           NOT NULL,
295
TYPE               	VARCHAR(2)         NOT NULL,
296
STATUS             	VARCHAR(1)         NOT NULL,
297
CHANNEL            	VARCHAR(2)         NOT NULL,
298
GMT_PAY             TIMESTAMP(6) default "2012-01-01 12:00:00",
299
IW_TRANS_LOG_ID     int,
300
GMT_TRADE_CREATE    TIMESTAMP         NOT NULL,
301
GMT_CREATE          TIMESTAMP         NOT NULL,
302
GMT_MODIFIED        TIMESTAMP         NOT NULL,
303
MEMO                varchar(1000),
304
BANK_PAY_ONLINE_ID  int,
305
BANK_AMOUNT         int,
306
BANK_TYPE           varchar(32),
307
FREEZE_TYPE         varchar(5),
308
OUT_ORDER_NO        varchar(64),
309
PARTNER_ID          varchar(30),
310
DEPOSIT_ID          varchar(16),
311
BILL_EXT            varchar(200),
312
PAY_ORDER_NO        varchar(64),
313
primary key (TRADE_NO,BILL_NO)
314
)DEFAULT CHARSET = 'utf8';
315
CREATE INDEX BYD_TRADE_FUND_BILL_PF_IND ON TRADE_FUND_BILL_000(PAY_ACCOUNT_NO, GMT_TRADE_CREATE);
316
CREATE INDEX BYD_TRADE_FUND_BILL_RF_IND ON TRADE_FUND_BILL_000(RECEIVE_ACCOUNT_NO, GMT_TRADE_CREATE);
317
CREATE INDEX TRADE_FUND_BILL_PTG_IND ON TRADE_FUND_BILL_000 (PARTNER_ID, GMT_TRADE_CREATE);
318
CREATE INDEX TRADE_FUND_BILL_000_GMT_IND ON TRADE_FUND_BILL_000(GMT_MODIFIED);
319
CREATE TABLE if not exists TRADE_GOODS_INFO_000 
320
(
321
ID              int           NOT NULL,
322
TRADE_NO        varchar(64)    NOT NULL,
323
GOODS_ID        varchar(32)    default ' ' NOT NULL,
324
GOODS_TITLE     varchar(256),
325
GOODS_BID       int         default 0 NOT NULL,
326
GOODS_QUANTITY  int         default 1 NOT NULL,
327
DETAIL_URL      varchar(400),
328
GOODS_MEMO      varchar(1000),
329
REFER_URL       varchar(400),
330
PARTNER         varchar(100),
331
GMT_CREATE      TIMESTAMP         NOT NULL,
332
OTHER_FEE       int,
333
CATEGORY        varchar(24),
334
PROMOTION_DESC  varchar(256),
335
PIC_URL         varchar(400),
336
GOODS_TYPE      VARCHAR(4),
337
GOODS_SUB_TYPE  VARCHAR(4),
338
primary key (TRADE_NO, ID)
339
)DEFAULT CHARSET = 'utf8';
340
CREATE TABLE if not exists TRADE_LOGISTICS_000
341
(
342
ID                    int          NOT NULL,
343
TRADE_NO              VARCHAR(64)   NOT NULL,
344
LOGISTICS_ID          VARCHAR(20),
345
LOGISTICS_NAME        VARCHAR(128),
346
INVOICE_NO            VARCHAR(64),
347
SIGN_VOUCHER_NO       VARCHAR(64),
348
TRANSPORT_TYPE        int,
349
TRANSPORT_FEE         int    default 0 NOT NULL, 
350
OTHER_FEE             int    default 0,
351
ADDITIONAL_SERVICE    VARCHAR(300),
352
LOGISTICS_STATUS      VARCHAR(100),
353
SEND_FULLNAME         VARCHAR(256),
354
SEND_PHONE            VARCHAR(30),
355
SEND_MOBILE_PHONE     VARCHAR(30),
356
SEND_ADDRESS          VARCHAR(256),
357
SEND_POST             VARCHAR(20),
358
RECEIVE_FULLNAME      VARCHAR(256),
359
RECEIVE_PHONE         VARCHAR(30),
360
RECEIVE_MOBILE_PHONE  VARCHAR(30),
361
RECEIVE_ADDRESS       VARCHAR(256),
362
RECEIVE_POST          VARCHAR(20),
363
LOGISTICS_MEMO        VARCHAR(600),
364
TRADE_OR_REFUND_FLAG  int         default 1 NOT NULL,
365
GMT_CREATE            TIMESTAMP(6) default "2012-01-01 12:00:00",
366
GMT_APPLY             TIMESTAMP(6) default "2012-01-01 12:00:00",
367
GMT_FETCH             TIMESTAMP(6) default "2012-01-01 12:00:00",
368
GMT_TRANSPORT         TIMESTAMP(6) default "2012-01-01 12:00:00",
369
GMT_SIGN              TIMESTAMP(6) default "2012-01-01 12:00:00",
370
GMT_MODIFIED          TIMESTAMP(6) default "2012-01-01 12:00:00",
371
SEND_IM_TYPE          VARCHAR(10),
372
SEND_IM_ID            VARCHAR(100),
373
RECEIVE_IM_TYPE       VARCHAR(10),
374
RECEIVE_IM_ID         VARCHAR(100),
375
TRANSPORT_PAYMENT     int,
376
TRANSPORT_MODIFIABLE  int,
377
RECEIVE_ADDRESS_CODE  VARCHAR(8),
378
SEND_ADDRESS_CODE     VARCHAR(8),
379
TRANSPORT_TYPE_SEND   int,
380
LOGISTICS_NO          VARCHAR(100),
381
TRANS_GOODS_INFO      VARCHAR(400),
382
REC_ADDRESS_NO        VARCHAR(100),
383
FLAG_MAIN             int,
384
primary key (TRADE_NO, TRADE_OR_REFUND_FLAG, ID)
385
)DEFAULT CHARSET = 'utf8';
386
CREATE INDEX TRADE_LOGISTICS_000_GMT_IND ON TRADE_LOGISTICS_000
387
(GMT_MODIFIED);
388
CREATE TABLE if not exists TRADE_MESSAGE_BOARD_000 
389
(
390
ID           int           NOT NULL,
391
TRADE_NO     varchar(64)    NOT NULL,
392
MESSAGE      varchar(2000)  NOT NULL,
393
POSTER       varchar(100)  default ' ' NOT NULL,
394
POSTER_ROLE  int,
395
OPERATOR_IP  varchar(15),
396
MSG_TYPE     int    default 0,
397
IS_READ     	int   default 0 NOT NULL,
398
GMT_CREATE   TIMESTAMP(6) default "2012-01-01 12:00:00",
399
PRIMARY KEY (TRADE_NO, ID)
400
) DEFAULT CHARSET = 'utf8';
401
CREATE TABLE if not exists TRADE_NOTE_000 
402
(
403
ID              int          NOT NULL,
404
TRADE_NO        varchar(64)   NOT NULL,
405
TRADE_STATUS    varchar(64)   default ' ',
406
BUYER_EMAIL     varchar(100)  default ' ' NOT NULL,
407
SELLER_EMAIL    varchar(100)  default ' ' NOT NULL,
408
OPERATOR_EMAIL  varchar(100)  default ' ' NOT NULL,
409
OPERATOR_IP     varchar(15),
410
GMT_CREATE      TIMESTAMP(6) default "2012-01-01 12:00:00",
411
OPERATOR_MEMO   varchar(256),
412
NOTE_TYPE       varchar(100),
413
REMOTE_MAC      varchar(64),
414
primary key (TRADE_NO, ID, GMT_CREATE)
415
)DEFAULT CHARSET = 'utf8';
416
CREATE TABLE if not exists TRADE_OUTTRADE_000 
417
(
418
PARTNER_ID    varchar(200)  NOT NULL,
419
OUT_TRADE_NO  varchar(64)   NOT NULL,
420
TRADE_FROM    varchar(100)  NOT NULL,
421
TRADE_NO      varchar(64)   NOT NULL,
422
GMT_CREATE    TIMESTAMP        NOT NULL,
423
primary key (OUT_TRADE_NO, PARTNER_ID, TRADE_FROM)
424
) DEFAULT CHARSET = 'utf8';
425
CREATE TABLE if not exists TRADE_PAYMENT_CLAUSE_000 
426
(
427
ID                     int           NOT NULL,
428
OUT_RELATION_ID        varchar(64),
429
SERIAL_NO              int,
430
TRADE_NO               varchar(64)    NOT NULL,
431
GMT_CREATE             TIMESTAMP(6) default "2012-01-01 12:00:00",
432
GMT_MODIFIED           TIMESTAMP(6) default "2012-01-01 12:00:00",
433
PAYMENT_TYPE           varchar(64)    NOT NULL,
434
STATUS                 varchar(50),
435
PAY_ACCOUNT_NO         varchar(20),
436
PAY_USER_ID            varchar(16),
437
RECEIVE_ACCOUNT_NO     varchar(20),
438
RECEIVE_USER_ID        varchar(16),
439
AMOUNT                 int,
440
CURRENCY               varchar(64),
441
PAYMENT_RESTRICT_RULE  varchar(1000),
442
DESCRIPTION            varchar(1000),
443
MEMO                   varchar(1000),
444
CONTEXT                varchar(1000),
445
primary key (TRADE_NO, OUT_RELATION_ID)
446
)DEFAULT CHARSET = 'utf8';
447
CREATE INDEX TRADE_PCLAUSE_000_GMT_IND ON TRADE_PAYMENT_CLAUSE_000 
448
(GMT_MODIFIED);
449
CREATE TABLE if not exists TRADE_PAYMENT_ORDER_000 
450
(
451
ORDER_NO            varchar(64)    NOT NULL,
452
TRADE_NO            varchar(64)    NOT NULL,
453
BIZ_TYPE            varchar(20)    NOT NULL,
454
OUT_ORDER_NO        varchar(64),
455
GMT_MODIFIED        TIMESTAMP         NOT NULL,
456
STATUS              varchar(2)     NOT NULL,
457
PAY_ACCOUNT_NO      varchar(20)    NOT NULL,
458
RECEIVE_ACCOUNT_NO  varchar(20)    NOT NULL,
459
AMOUNT              int           NOT NULL,
460
RETURN_AMOUNT       int,
461
CURRENCY            varchar(3)     NOT NULL,
462
FREEZE_TYPE         varchar(5),
463
EXT_INFO            varchar(1000),
464
MEMO                varchar(1000),
465
PAYMENT_ID          varchar(64),
466
PAYMENT_CONTEXT     varchar(1000),
467
GMT_PAY             TIMESTAMP(6) default "2012-01-01 12:00:00",
468
GMT_CREATE          TIMESTAMP         NOT NULL,
469
FREEZE_AMOUNT       int,
470
SUB_TRANS_CODE      varchar(40)    NOT NULL,
471
primary key (TRADE_NO, ORDER_NO)
472
)DEFAULT CHARSET = 'utf8';
473
CREATE INDEX TRADE_PAYMENT_ORD_000_GM_IND ON TRADE_PAYMENT_ORDER_000
474
(GMT_MODIFIED);
475
CREATE TABLE if not exists TRADE_PROCESS_000 
476
(
477
ID                        int           NOT NULL,
478
TRADE_NO                  varchar(64)   default ' ' NOT NULL,
479
OUT_TRADE_NO              varchar(64),
480
RECEIVE_FEE               int           default 0 NOT NULL,
481
SEND_FEE                  int           default 0 NOT NULL,
482
ADJUST_FEE                int           default 0 NOT NULL,
483
MEMO                      varchar(600),
484
OPERATE_TIME              TIMESTAMP(6) default "2012-01-01 12:00:00",
485
OPERATE_NAME              varchar(256),
486
FLAG_REFUND               varchar(4)    default '0' NOT NULL,
487
FLAG_DEFERPAY             varchar(4)    default '0' NOT NULL,
488
FLAG_PAYMENT              varchar(8)    default '0' NOT NULL,
489
FLAG_TRADE_LOCKED         varchar(4)    default '0' NOT NULL,
490
FLAG_SELLER_MDF           varchar(4)    default '0' NOT NULL,
491
GMT_CREATE                TIMESTAMP                 ,
492
GMT_MODIFIED              TIMESTAMP(6) default "2012-01-01 12:00:00",
493
GMT_RECEIVE_PAY           TIMESTAMP(6) default "2012-01-01 12:00:00",
494
GMT_SEND_PAY              TIMESTAMP(6) default "2012-01-01 12:00:00",
495
GMT_SEND_GOODS            TIMESTAMP(6) default "2012-01-01 12:00:00",
496
TIME_OUT_RULE             varchar(1000),
497
GMT_OUT_TRADE_NO_CREATED  TIMESTAMP(6) default "2012-01-01 12:00:00",
498
COUPON_CLEAR_FEE          int,
499
COUPON_ADJUST_FEE         int,
500
REFUND_FEE                int,
501
GMT_REFUND_PAY            TIMESTAMP(6) default "2012-01-01 12:00:00",
502
GMT_FINISH                TIMESTAMP(6) default "2012-01-01 12:00:00",
503
ACCOUNT_TX_ID             varchar(40),
504
ADJUST_TIMEOUT            int,
505
GMT_PRE_AUTH              TIMESTAMP(6) default "2012-01-01 12:00:00",
506
PRE_AUTH_FEE              int,
507
ACTUAL_ADJUST_FEE         int,
508
EXPIRE_TIME               TIMESTAMP(6) default "2012-01-01 12:00:00",
509
SEND_BACK_FEE             int,
510
PRIMARY KEY (TRADE_NO)
511
)DEFAULT CHARSET = 'utf8';
512
CREATE INDEX IND_BYD_TRD_PROCESS_GRPAY ON TRADE_PROCESS_000 
513
(GMT_RECEIVE_PAY, RECEIVE_FEE);
514
CREATE INDEX TRADE_PROCESS_GMT_IND ON TRADE_PROCESS_000
515
(GMT_MODIFIED);
516
CREATE TABLE if not exists TRADE_REFUND_000 
517
(
518
ID                  int           NOT NULL,
519
TRADE_NO            varchar(64)    NOT NULL,
520
OUT_TRADE_NO        varchar(64),
521
RETURN_STATUS       varchar(100),
522
MEMO                varchar(2000),
523
RETURN_FEE          int,
524
GMT_ADMIN_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00",
525
ADMIN_STATUS        varchar(100),
526
RETURN_TYPE         varchar(20)    NOT NULL,
527
RETURN_GOODS        int,
528
GOODS_STATUS        int,
529
CLOSE_CAUSE         varchar(600),
530
REQUIRE_VOUCHER     int,
531
GMT_CREATE          TIMESTAMP                 NOT NULL,
532
GMT_MODIFIED        TIMESTAMP(6) default "2012-01-01 12:00:00",
533
SELLER_NOT_RECEIVE  int,
534
REFUND_REASON       varchar(400),
535
APPEAL_NO           varchar(50),
536
GMT_DW_SYNC         TIMESTAMP         ,
537
BUY_USER_ID         varchar(16)    NOT NULL,
538
BUY_ACCOUNT         varchar(20)    NOT NULL,
539
SELL_USER_ID        varchar(16)    NOT NULL,
540
SELL_ACCOUNT        varchar(20)    NOT NULL,
541
TRADE_FROM          varchar(100),
542
TRADE_EMAIL         varchar(100),
543
IS_INPOUR_REFUND   	VARCHAR(1),
544
REFUND_FLOW_TYPE   	VARCHAR(1),
545
GMT_LAST_APPLY      TIMESTAMP(6) default "2012-01-01 12:00:00",
546
REFUND_FOREX_FEE    int,
547
PRIMARY KEY (TRADE_NO, ID)
548
)DEFAULT CHARSET = 'utf8';
549
CREATE INDEX TRADE_REFUND_BG_IND ON TRADE_REFUND_000 
550
(BUY_ACCOUNT, GMT_CREATE);
551
CREATE INDEX TRADE_REFUND_SG_IND ON TRADE_REFUND_000 
552
(SELL_ACCOUNT, GMT_CREATE);
553
CREATE INDEX TRADE_REFUND_TG_IND ON TRADE_REFUND_000 
554
(TRADE_EMAIL, GMT_CREATE);
555
CREATE INDEX TRADE_REFUND_000_GMT_IND ON TRADE_REFUND_000 (GMT_MODIFIED);
556
CREATE TABLE if not exists TRADE_VOUCHER_000 
557
(
558
ID                     int           NOT NULL,
559
TRADE_NO               varchar(64)   default ' '  NOT NULL,
560
REFUND_ID              int           NOT NULL,
561
SELLER_OR_BUYER        VARCHAR(1)    default 'S' NOT NULL,
562
SELLER_UPLOAD_VOUCHER  varchar(4000),
563
BUYER_UPLOAD_VOUCHER   varchar(4000),
564
UPLOAD_FLAG            int           default 0 NOT NULL,
565
GMT_CREATE             TIMESTAMP(6) default "2012-01-01 12:00:00",
566
GMT_MODIFIED           TIMESTAMP(6) default "2012-01-01 12:00:00",
567
GMT_CHECK              TIMESTAMP(6) default "2012-01-01 12:00:00",
568
LAST_OPERATOR          varchar(32),
569
CHECK_MEMO             varchar(2000),
570
MEMEO                  varchar(4000),
571
GMT_TIMEOUT_START      TIMESTAMP(6) default "2012-01-01 12:00:00",
572
PRIMARY KEY (TRADE_NO, ID)
573
) DEFAULT CHARSET = 'utf8';
574
CREATE INDEX TRADE_VOUCHER_000_MT_IND ON TRADE_VOUCHER_000
575
(GMT_MODIFIED);
576
CREATE TABLE if not exists TRADE_RECEIVE_ADDRESS_000
577
(
578
TRADE_NO          VARCHAR(64)   NOT NULL,
579
ADDRESS_NO        VARCHAR(100)  NOT NULL,
580
RECEIVE_NAME      VARCHAR(256),
581
ADDRESS_CODE      VARCHAR(8),
582
ADDRESS           VARCHAR(256),
583
MOBILE_PHONE      VARCHAR(30),
584
PHONE             VARCHAR(30),
585
RECEIVE_POST      VARCHAR(20),
586
VIRTUAL_REC_INFO  VARCHAR(400),
587
GMT_CREATE        DATETIME                NOT NULL,
588
GMT_MODIFIED      DATETIME,
589
PRIMARY KEY (TRADE_NO, ADDRESS_NO)
590
)DEFAULT CHARSET = 'utf8';
591
CREATE TABLE if not exists TRADE_COOPERATE_000
592
(
593
TRADE_NO         VARCHAR(64),
594
COOPERATE_NO     VARCHAR(64),
595
COOPERATOR_FROM  VARCHAR(32),
596
GMT_CREATE       TIMESTAMP(6) default "2012-01-01 12:00:00",
597
GMT_MODIFIED     TIMESTAMP(6) default "2012-01-01 12:00:00",
598
PRIMARY key (TRADE_NO, COOPERATE_NO, COOPERATOR_FROM)
599
)DEFAULT CHARSET = 'utf8';
600
CREATE INDEX TRADE_COOPERATE_000_MT_IND ON TRADE_COOPERATE_000
601
(GMT_MODIFIED);
602
CREATE TABLE if not exists TRADE_SETTLE_ORDER_000
603
(
604
ORDER_NO            VARCHAR(64)    NOT NULL,
605
ORG_ORDER_NO        VARCHAR(64),
606
TRADE_NO            VARCHAR(64)    NOT NULL,
607
OUT_REQUEST_NO      VARCHAR(64),
608
BIZ_PRODUCT         VARCHAR(32),
609
SETTLE_ACTION_TYPE  VARCHAR(32),
610
AMOUNT              int           NOT NULL,
611
STATUS              VARCHAR(50)    NOT NULL,
612
EXTINFO             VARCHAR(1024),
613
MEMO                VARCHAR(512),
614
SETTLE_ID           VARCHAR(64),
615
SETTLE_CONTEXT      VARCHAR(1024),
616
GMT_CREATE          TIMESTAMP(6)         NOT NULL,
617
GMT_MODIFIED        TIMESTAMP(6),
618
SETTLE_TYPE         VARCHAR(32),
619
PRIMARY KEY (TRADE_NO, ORDER_NO, GMT_CREATE)
620
)DEFAULT CHARSET = 'utf8';
621
CREATE TABLE if not exists TRADE_PARTICIPANT_000
622
(
623
TRADE_NO          VARCHAR(64)   NOT NULL,
624
USER_ID           VARCHAR(16)   NOT NULL,
625
USER_NAME         VARCHAR(256),
626
USER_NICK         VARCHAR(100),
627
PARTICIPANT_ROLE  VARCHAR(64)   NOT NULL,
628
MEMO              VARCHAR(200),
629
GMT_CREATE        TIMESTAMP               NOT NULL,
630
GMT_MODIFIED      TIMESTAMP(6) default "2012-01-01 12:00:00",
631
PRIMARY KEY (TRADE_NO, USER_ID, PARTICIPANT_ROLE)
632
)DEFAULT CHARSET = 'utf8';
633
CREATE TABLE if not exists BUSINESS_ACTIVITY_ASYNC_000
634
(
635
TX_ID                VARCHAR(128)   NOT NULL,
636
STATE                VARCHAR(1)         NOT NULL,
637
ACCOUNT_TRANS_STATE  VARCHAR(1)         NOT NULL,
638
GMT_CREATE           TIMESTAMP         NOT NULL,
639
GMT_MODIFIED         TIMESTAMP         NOT NULL,
640
PROPAGATION          VARCHAR(1),
641
CONTEXT              VARCHAR(2048),
642
PRIMARY KEY (TX_ID)
643
)DEFAULT CHARSET = 'utf8';
644
CREATE TABLE if not exists EXTERFACE_INVOKE_000
645
(
646
ID           int         NOT NULL,
647
PARTNER_ID   VARCHAR(32)   NOT NULL,
648
TARGET       VARCHAR(64)   NOT NULL,
649
EXTERFACE    VARCHAR(128)  NOT NULL,
650
NOTIFY_URL   VARCHAR(200),
651
RETURN_URL   VARCHAR(200),
652
SIGN_TYPE    VARCHAR(10),
653
CHARSET      VARCHAR(20),
654
GMT_INVOKE   TIMESTAMP        NOT NULL,
655
GMT_FINISH   TIMESTAMP       NOT NULL,
656
TARGET_TYPE  VARCHAR(20)   NOT NULL,
657
GMT_NOTIFY   TIMESTAMP(6) default "2012-01-01 12:00:00",
658
GMT_RETURN   TIMESTAMP(6) default "2012-01-01 12:00:00",
659
PRIMARY KEY(TARGET_TYPE, TARGET, PARTNER_ID)
660
)DEFAULT CHARSET = 'utf8';
661
CREATE INDEX EXTERFACE_INVOKE_000_ID_IND ON EXTERFACE_INVOKE_000(ID);
662
DROP TABLE if exists trade_sequence_000;
663
DROP TABLE if exists BUSINESS_ACTION_000;
664
DROP TABLE if exists BUSINESS_ACTIVITY_000;
665
DROP TABLE if exists NOTIFY_000 ;
666
DROP TABLE if exists NOTIFY_HISTORY_000 ;
667
DROP TABLE if exists TIMEOUT_000 ;
668
DROP TABLE if exists TIMEOUT_HISTORY_000 ;
669
DROP TABLE if exists TIMEOUT_LONG_000 ;
670
DROP TABLE if exists TIMEOUT_REMIND_000;
671
DROP TABLE if exists TRADE_BASE_000 ;
672
DROP TABLE if exists TRADE_CHARGE_000;
673
DROP TABLE if exists TRADE_EXT_000 ;
674
DROP TABLE if exists TRADE_FUND_BILL_000 ;
675
DROP TABLE if exists TRADE_GOODS_INFO_000 ;
676
DROP TABLE if exists TRADE_LOGISTICS_000;
677
DROP TABLE if exists TRADE_MESSAGE_BOARD_000 ;
678
DROP TABLE if exists TRADE_NOTE_000 ;
679
DROP TABLE if exists TRADE_OUTTRADE_000 ;
680
DROP TABLE if exists TRADE_PAYMENT_CLAUSE_000 ;
681
DROP TABLE if exists TRADE_PAYMENT_ORDER_000 ;
682
DROP TABLE if exists TRADE_PROCESS_000 ;
683
DROP TABLE if exists TRADE_REFUND_000 ;
684
DROP TABLE if exists TRADE_VOUCHER_000 ;
685
DROP TABLE if exists TRADE_RECEIVE_ADDRESS_000;
686
DROP TABLE if exists TRADE_COOPERATE_000;
687
DROP TABLE if exists TRADE_SETTLE_ORDER_000;
688
DROP TABLE if exists TRADE_PARTICIPANT_000;
689
DROP TABLE if exists BUSINESS_ACTIVITY_ASYNC_000;
690
DROP TABLE if exists EXTERFACE_INVOKE_000;
691