oceanbase

1
CREATE TABLE if not exists trade_sequence_000
2
(
3
 name varchar(256),
4
 value int,
5
 min_value int,
6
 max_value int,
7
 step int,
8
 gmt_create TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
9
 gmt_modified TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
10
 primary key (name)
11
) DEFAULT CHARSET = 'utf8';
12

13

14
CREATE TABLE if not exists BUSINESS_ACTION_000 
15
(
16
  ACTION_ID     int           NOT NULL,
17
  TX_ID         varchar(128)   NOT NULL,
18
  NAME          varchar(64)    NOT NULL,
19
  STATE         CHAR(1)         NOT NULL,
20
  GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
21
  GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
22
  CONTEXT       varchar(4000),
23
  primary key (ACTION_ID)
24
) DEFAULT CHARSET = 'utf8';
25

26
CREATE TABLE if not exists BUSINESS_ACTIVITY_000 
27
(
28
  TX_ID                varchar(128)   NOT NULL,
29
  STATE               	VARCHAR(1)         NOT NULL,
30
  ACCOUNT_TRANS_STATE 	VARCHAR(1)         NOT NULL,
31
  GMT_CREATE           TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
32
  GMT_MODIFIED         TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
33
  PROPAGATION         	VARCHAR(1),
34
  CONTEXT              varchar(2048),
35
  primary key (TX_ID)
36
) DEFAULT CHARSET = 'utf8';
37

38
CREATE TABLE if not exists NOTIFY_000 
39
(
40
  ID                varchar(34)    NOT NULL,
41
  PLUGIN            varchar(50)    NOT NULL,
42
  PARAMETER         varchar(4000)  NOT NULL,
43
  GROUP_NO          int            NOT NULL,
44
  STATUS           	VARCHAR(1)         NOT NULL,
45
  GMT_CREATE        TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
46
  GMT_MODIFY        TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
47
  IW_USER_ID        varchar(16),
48
  CHANNEL_ENDPOINT  varchar(200),
49
  BUSINESS_ORDER    varchar(128),
50
  BUSINESS_TYPE     varchar(50),
51
  PLUGIN_HOST       varchar(15),
52
  GMT_LOCAL_CREATE  TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
53
  primary key (id)
54
)DEFAULT CHARSET = 'utf8';
55

56
CREATE INDEX NOTIFY_BUSINESS_ORDER1_IND ON NOTIFY_000 (BUSINESS_ORDER);
57
CREATE INDEX NOTIFY_PLUGIN_IND ON NOTIFY_000 (PLUGIN, CHANNEL_ENDPOINT);
58

59
CREATE TABLE if not exists NOTIFY_HISTORY_000 
60
(
61
  ID                varchar(34)    NOT NULL,
62
  PLUGIN            varchar(50)    NOT NULL,
63
  PARAMETER         varchar(4000)  NOT NULL,
64
  GROUP_NO          int            NOT NULL,
65
  STATUS           	VARCHAR(1)         NOT NULL,
66
  GMT_CREATE        TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
67
  GMT_MODIFY        TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
68
  IW_USER_ID        varchar(16),
69
  CHANNEL_ENDPOINT  varchar(200),
70
  BUSINESS_ORDER    varchar(128),
71
  BUSINESS_TYPE     varchar(50),
72
  PLUGIN_HOST       varchar(15),
73
  GMT_LOCAL_CREATE  TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
74
  PRIMARY KEY (ID)
75
)DEFAULT CHARSET = 'utf8';
76
CREATE INDEX NOTIFY_HISTORY_000_BORDER_IND ON NOTIFY_HISTORY_000 (BUSINESS_ORDER);
77
CREATE INDEX NOTIFY_HISTORY_IG_IND ON NOTIFY_HISTORY_000 (IW_USER_ID, GROUP_NO);
78

79
CREATE TABLE if not exists TIMEOUT_000 
80
(
81
  JOB_ID        varchar(32)   NOT NULL,
82
  TRADE_NO      varchar(64),
83
  USER_ID       varchar(128),
84
  PAYTYPE       varchar(4),
85
  END_TIME      TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
86
  ACTION        varchar(30),
87
  PARAMETER     varchar(100),
88
  STATUS       	VARCHAR(1),
89
  ACTION_TYPE  	VARCHAR(1),
90
  GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
91
  PRIOR_LEVEL   int default 1,
92
  GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
93
  GMT_OCCUR     TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
94
  PRIMARY KEY (JOB_ID)
95
) DEFAULT CHARSET = 'utf8';
96

97
CREATE INDEX IND_BEYOND_TIMEOUT_ETIME ON TIMEOUT_000 (END_TIME);
98
CREATE INDEX TIMEOUT_000_PL_IND ON TIMEOUT_000 (PRIOR_LEVEL);
99
CREATE INDEX TIMEOUT_TNO_IND ON TIMEOUT_000 (TRADE_NO);
100

101
CREATE TABLE if not exists TIMEOUT_HISTORY_000 
102
(
103
  JOB_ID        varchar(32)   NOT NULL,
104
  TRADE_NO      varchar(64)   NOT NULL,
105
  USER_ID       varchar(128),
106
  PAYTYPE       varchar(4),
107
  END_TIME      TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
108
  ACTION        varchar(30),
109
  PARAMETER     varchar(100),
110
  STATUS       	VARCHAR(1),
111
  ACTION_TYPE  	VARCHAR(1)        NOT NULL,
112
  GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
113
  PRIOR_LEVEL   int,
114
  GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
115
  GMT_OCCUR     TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
116
  PRIMARY KEY (JOB_ID, TRADE_NO, ACTION_TYPE)
117
) DEFAULT CHARSET = 'utf8';
118

119
CREATE TABLE if not exists TIMEOUT_LONG_000 
120
(
121
  JOB_ID        varchar(32)   NOT NULL,
122
  TRADE_NO      varchar(64),
123
  USER_ID       varchar(128),
124
  PAYTYPE       varchar(4),
125
  END_TIME      TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
126
  ACTION        varchar(30),
127
  PARAMETER     varchar(100),
128
  STATUS       	VARCHAR(1),
129
  ACTION_TYPE  	VARCHAR(1),
130
  GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
131
  PRIOR_LEVEL   int          ,
132
  GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
133
  GMT_OCCUR     TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
134
  PRIMARY KEY (JOB_ID)
135
) DEFAULT CHARSET = 'utf8';
136
CREATE INDEX BYD_TIMEOUT_LONG_ENDTIME_IND ON TIMEOUT_LONG_000 (END_TIME);
137
CREATE INDEX TIMEOUT_LONG_000_PL_IND ON TIMEOUT_LONG_000 (PRIOR_LEVEL);
138
CREATE INDEX TIMEOUT_LONG_TNO_IND ON TIMEOUT_LONG_000 (TRADE_NO);
139

140

141
CREATE TABLE if not exists TIMEOUT_REMIND_000 
142
(
143
  JOB_ID        varchar(32)   NOT NULL,
144
  TRADE_NO      varchar(64),
145
  USER_ID       varchar(128),
146
  PAYTYPE       varchar(4),
147
  END_TIME      TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
148
  ACTION        varchar(30),
149
  PARAMETER     varchar(100),
150
  STATUS       	VARCHAR(1),
151
  ACTION_TYPE  	VARCHAR(1),
152
  GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
153
  PRIOR_LEVEL   int          ,
154
  GMT_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
155
  GMT_OCCUR     TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
156
  PRIMARY KEY (JOB_ID)
157
) DEFAULT CHARSET = 'utf8';
158

159

160
CREATE INDEX BY_TIMEOUT_REMIND_ETIME_IND ON TIMEOUT_REMIND_000 (END_TIME);
161

162
CREATE INDEX TIMEOUT_REMIND_000_PL_IND ON TIMEOUT_REMIND_000 (PRIOR_LEVEL);
163

164
CREATE INDEX TIMEOUT_REMIND_TNO_IND ON TIMEOUT_REMIND_000 (TRADE_NO);
165

166
CREATE TABLE if not exists TRADE_BASE_000 
167
(
168
 ID                     int           NOT NULL,
169
  TRADE_NO               varchar(64)    NOT NULL,
170
  OUT_TRADE_NO           varchar(64),
171
  SELLER_ACCOUNT         varchar(100)   NOT NULL,
172
  SELLER_LOGIN_EMAIL     varchar(100)   NOT NULL,
173
  BUYER_ACCOUNT          varchar(100)   NOT NULL,
174
  BUYER_LOGIN_EMAIL      varchar(100)   NOT NULL,
175
  SELLER_TYPE            int,
176
  BUYER_TYPE             int,
177
  TRADE_FROM             varchar(100),
178
  TRADE_EMAIL            varchar(100),
179
  OPERATOR_ROLE          VARCHAR(1)     NOT NULL,
180
  TRADE_STATUS           varchar(50)    NOT NULL,
181
  TOTAL_FEE              int            default 0 NOT NULL,
182
  SERVICE_FEE_RATIO      varchar(64),
183
  SERVICE_FEE            int            default 0 NOT NULL,
184
  CURRENCY               varchar(3),
185
  SELLER_ACTION          varchar(200),
186
  BUYER_ACTION           varchar(200),
187
  GMT_CREATE             TIMESTAMP(6) default "2012-01-01 12:00:00"                ,
188
  SELLER_USER_ID         varchar(16),
189
  BUYER_USER_ID          varchar(16),
190
  ADDITIONAL_TRD_STATUS  varchar(50),
191
  TRADE_TYPE             varchar(4)     NOT NULL,
192
  SELLER_FULLNAME        varchar(256)   default '',
193
  BUYER_FULLNAME         varchar(256)   default '',
194
  SELLER_NICK            varchar(100)   default '' NOT NULL,
195
  BUYER_NICK             varchar(100)   default '' NOT NULL,
196
  GOODS_TITLE            varchar(256),
197
  GMT_LAST_MODIFIED_DT   TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
198
  STOP_TIMEOUT           varchar(4) 	default '0',
199
  GATHERING_TYPE         varchar(4),
200
  BUYER_MARKER           VARCHAR(1),
201
  SELLER_MARKER          VARCHAR(1),
202
  BUYER_MARKER_MEMO      varchar(1000),
203
  SELLER_MARKER_MEMO     varchar(1000),
204
  CHANNEL                varchar(32),
205
  PRODUCT                varchar(20),
206
  PAY_CHANNEL            varchar(32),
207
  OTHER_SERVICE_FEE      int,
208
  RELATION_PRO           varchar(64),
209
  PLATFORM varchar(100),
210
  CHANNEL_PARTNER varchar(100),
211
  GOODS_TYPE      VARCHAR(4),
212
  GOODS_SUB_TYPE  VARCHAR(4),
213
  PRIMARY KEY (TRADE_NO)
214
)DEFAULT CHARSET = 'utf8';
215

216
CREATE INDEX BYD_TRADE_BASE_TEMAIL_GMTC_IND ON TRADE_BASE_000 
217
(TRADE_EMAIL, GMT_CREATE);
218

219
CREATE INDEX IND_BEYOND_TRADE_BASE_BUYGMT1 ON TRADE_BASE_000 
220
(BUYER_ACCOUNT, GMT_CREATE);
221

222
CREATE INDEX IND_BEYOND_TRADE_BASE_SALGMT1 ON TRADE_BASE_000 
223
(SELLER_ACCOUNT, GMT_CREATE);
224

225
CREATE TABLE if not exists TRADE_CHARGE_000 
226
(
227
  ID                int           NOT NULL,
228
  TRADE_NO          varchar(64)   NOT NULL,
229
  GMT_CHARGE        TIMESTAMP(6) default "2012-01-01 12:00:00"    NOT NULL,
230
  GMT_PAY           TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
231
  CHARGE_OUT_DATE  	VARCHAR(8),
232
  GMT_MODIFIED      TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
233
  PLAN_CHARGE       int,
234
  ACTUAL_CHARGE     int,
235
  RATE_ID           int,
236
  RATE              int,
237
  RATE_ORIGIN      	VARCHAR(1),
238
  PRODUCT_NAME      varchar(32),
239
  CHARGE_TYPE       varchar(16),
240
  SERVICE_EVENT_ID  int,
241
  PAYMENT_BILL_ID   int,
242
  SALES_ID          int,
243
  PARTNER_ID        varchar(30),
244
  DEBIT_ACCOUNT     varchar(20),
245
  CREDIT_ACCOUNT    varchar(20),
246
  BILL_STATUS      	VARCHAR(1),
247
  SERVICE_AMOUNT    int,
248
  TRADE_FROM        varchar(100),
249
  DEBIT_USER_ID     varchar(16),
250
  SERVICT_TYPE      varchar(8),
251
  SUB_TRADE_NO      varchar(64),
252
  primary key (TRADE_NO, SERVICT_TYPE,	CHARGE_TYPE, SUB_TRADE_NO)
253
)DEFAULT CHARSET = 'utf8';
254

255
CREATE INDEX TRADE_CHARGE_000_GMT_IND ON TRADE_CHARGE_000
256
(GMT_MODIFIED);
257

258
CREATE TABLE if not exists TRADE_EXT_000 
259
(
260
  TRADE_NO               varchar(64)    NOT NULL,
261
  EXT_INFO               varchar(1000),
262
  TRADE_AGENT            varchar(30),
263
  GMT_MODIFIED           TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
264
  FP_TIME_OUT_RULE       varchar(1000),
265
  FOREX_RATE_ID          int,
266
  FOREX_CURRENCY         varchar(8),
267
  FOREX_TOTAL_FEE        int,
268
  GOODS_INNER_SELL_RATE  int,
269
  PREPARE_COUPON_FEE     int,
270
  PREPARE_COUPON_LIST    varchar(64),
271
  FOREX_CERT_NO          varchar(128),
272
  GMT_CREATE             TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
273
  AUTH_DEBIT_TYPE        varchar(1),
274
  SUPPORT_CREDIT_CARD    varchar(256),
275
  SPECIFIED_PAY_CHANNEL  varchar(128),
276
  CHARGE_CHANNEL_INFO    varchar(256),
277
  PAY_CHANNELS           varchar(900),
278
  PRIMARY KEY (TRADE_NO)
279
)DEFAULT CHARSET = 'utf8';
280
CREATE INDEX TRADE_EXT_000_GMT_IND ON TRADE_EXT_000 (GMT_MODIFIED);
281

282
CREATE TABLE if not exists TRADE_FUND_BILL_000 
283
(
284
  BILL_NO             varchar(128)   NOT NULL,
285
  TRADE_NO            varchar(64)    NOT NULL,
286
  PAY_ACCOUNT_NO      varchar(20)    NOT NULL,
287
  RECEIVE_ACCOUNT_NO  varchar(20)    NOT NULL,
288
  CURRENCY            varchar(3)    default '156' NOT NULL,
289
  AMOUNT              int           NOT NULL,
290
  TYPE               	VARCHAR(2)         NOT NULL,
291
  STATUS             	VARCHAR(1)         NOT NULL,
292
  CHANNEL            	VARCHAR(2)         NOT NULL,
293
  GMT_PAY             TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
294
  IW_TRANS_LOG_ID     int,
295
  GMT_TRADE_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
296
  GMT_CREATE          TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
297
  GMT_MODIFIED        TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
298
  MEMO                varchar(1000),
299
  BANK_PAY_ONLINE_ID  int,
300
  BANK_AMOUNT         int,
301
  BANK_TYPE           varchar(32),
302
  FREEZE_TYPE         varchar(5),
303
  OUT_ORDER_NO        varchar(64),
304
  PARTNER_ID          varchar(30),
305
  DEPOSIT_ID          varchar(16),
306
  BILL_EXT            varchar(200),
307
  PAY_ORDER_NO        varchar(64),
308
  primary key (TRADE_NO,BILL_NO)
309
)DEFAULT CHARSET = 'utf8';
310

311
CREATE INDEX BYD_TRADE_FUND_BILL_PF_IND ON TRADE_FUND_BILL_000 
312
(PAY_ACCOUNT_NO, GMT_TRADE_CREATE);
313

314
CREATE INDEX BYD_TRADE_FUND_BILL_RF_IND ON TRADE_FUND_BILL_000 
315
(RECEIVE_ACCOUNT_NO, GMT_TRADE_CREATE);
316

317
CREATE INDEX TRADE_FUND_BILL_PTG_IND ON TRADE_FUND_BILL_000 
318
(PARTNER_ID, GMT_TRADE_CREATE);
319

320
CREATE INDEX TRADE_FUND_BILL_000_GMT_IND ON TRADE_FUND_BILL_000
321
(GMT_MODIFIED);
322

323
CREATE TABLE if not exists TRADE_GOODS_INFO_000 
324
(
325
  ID              int           NOT NULL,
326
  TRADE_NO        varchar(64)    NOT NULL,
327
  GOODS_ID        varchar(32)    default ' ' NOT NULL,
328
  GOODS_TITLE     varchar(256),
329
  GOODS_BID       int         default 0 NOT NULL,
330
  GOODS_QUANTITY  int         default 1 NOT NULL,
331
  DETAIL_URL      varchar(400),
332
  GOODS_MEMO      varchar(1000),
333
  REFER_URL       varchar(400),
334
  PARTNER         varchar(100),
335
  GMT_CREATE      TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
336
  OTHER_FEE       int,
337
  CATEGORY        varchar(24),
338
  PROMOTION_DESC  varchar(256),
339
  PIC_URL         varchar(400),
340
  GOODS_TYPE      VARCHAR(4),
341
  GOODS_SUB_TYPE  VARCHAR(4),
342
  primary key (TRADE_NO, ID)
343
)DEFAULT CHARSET = 'utf8';
344

345
CREATE TABLE if not exists TRADE_LOGISTICS_000
346
(
347
  ID                    int          NOT NULL,
348
  TRADE_NO              VARCHAR(64)   NOT NULL,
349
  LOGISTICS_ID          VARCHAR(20),
350
  LOGISTICS_NAME        VARCHAR(128),
351
  INVOICE_NO            VARCHAR(64),
352
  SIGN_VOUCHER_NO       VARCHAR(64),
353
  TRANSPORT_TYPE        int,
354
  TRANSPORT_FEE         int    default 0 NOT NULL, 
355
  OTHER_FEE             int    default 0,
356
  ADDITIONAL_SERVICE    VARCHAR(300),
357
  LOGISTICS_STATUS      VARCHAR(100),
358
  SEND_FULLNAME         VARCHAR(256),
359
  SEND_PHONE            VARCHAR(30),
360
  SEND_MOBILE_PHONE     VARCHAR(30),
361
  SEND_ADDRESS          VARCHAR(256),
362
  SEND_POST             VARCHAR(20),
363
  RECEIVE_FULLNAME      VARCHAR(256),
364
  RECEIVE_PHONE         VARCHAR(30),
365
  RECEIVE_MOBILE_PHONE  VARCHAR(30),
366
  RECEIVE_ADDRESS       VARCHAR(256),
367
  RECEIVE_POST          VARCHAR(20),
368
  LOGISTICS_MEMO        VARCHAR(600),
369
  TRADE_OR_REFUND_FLAG  int         default 1 NOT NULL,
370
  GMT_CREATE            TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
371
  GMT_APPLY             TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
372
  GMT_FETCH             TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
373
  GMT_TRANSPORT         TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
374
  GMT_SIGN              TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
375
  GMT_MODIFIED          TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
376
  SEND_IM_TYPE          VARCHAR(10),
377
  SEND_IM_ID            VARCHAR(100),
378
  RECEIVE_IM_TYPE       VARCHAR(10),
379
  RECEIVE_IM_ID         VARCHAR(100),
380
  TRANSPORT_PAYMENT     int,
381
  TRANSPORT_MODIFIABLE  int,
382
  RECEIVE_ADDRESS_CODE  VARCHAR(8),
383
  SEND_ADDRESS_CODE     VARCHAR(8),
384
  TRANSPORT_TYPE_SEND   int,
385
  LOGISTICS_NO          VARCHAR(100),
386
  TRANS_GOODS_INFO      VARCHAR(400),
387
  REC_ADDRESS_NO        VARCHAR(100),
388
  FLAG_MAIN             int,
389
  primary key (TRADE_NO, TRADE_OR_REFUND_FLAG, ID)
390
)DEFAULT CHARSET = 'utf8';
391
CREATE INDEX TRADE_LOGISTICS_000_GMT_IND ON TRADE_LOGISTICS_000
392
(GMT_MODIFIED);
393

394

395
#这个表修改了IS_READ,原来使用的是CHAR（1）
396
CREATE TABLE if not exists TRADE_MESSAGE_BOARD_000 
397
(
398
  ID           int           NOT NULL,
399
  TRADE_NO     varchar(64)    NOT NULL,
400
  MESSAGE      varchar(2000)  NOT NULL,
401
  POSTER       varchar(100)  default ' ' NOT NULL,
402
  POSTER_ROLE  int,
403
  OPERATOR_IP  varchar(15),
404
  MSG_TYPE     int    default 0,
405
  IS_READ     	int   default 0 NOT NULL,
406
  GMT_CREATE   TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
407
  PRIMARY KEY (TRADE_NO, ID)
408
) DEFAULT CHARSET = 'utf8';
409

410
CREATE TABLE if not exists TRADE_NOTE_000 
411
(
412
  ID              int          NOT NULL,
413
  TRADE_NO        varchar(64)   NOT NULL,
414
  TRADE_STATUS    varchar(64)   default ' ',
415
  BUYER_EMAIL     varchar(100)  default ' ' NOT NULL,
416
  SELLER_EMAIL    varchar(100)  default ' ' NOT NULL,
417
  OPERATOR_EMAIL  varchar(100)  default ' ' NOT NULL,
418
  OPERATOR_IP     varchar(15),
419
  GMT_CREATE      TIMESTAMP(6) default "2012-01-01 12:00:00",
420
  OPERATOR_MEMO   varchar(256),
421
  NOTE_TYPE       varchar(100),
422
  REMOTE_MAC      varchar(64),
423
  primary key (TRADE_NO, ID, GMT_CREATE)
424
)DEFAULT CHARSET = 'utf8';
425

426
CREATE TABLE if not exists TRADE_OUTTRADE_000 
427
(
428
  PARTNER_ID    varchar(200)  NOT NULL,
429
  OUT_TRADE_NO  varchar(64)   NOT NULL,
430
  TRADE_FROM    varchar(100)  NOT NULL,
431
  TRADE_NO      varchar(64)   NOT NULL,
432
  GMT_CREATE    TIMESTAMP(6) default "2012-01-01 12:00:00"       NOT NULL,
433
  primary key (OUT_TRADE_NO, PARTNER_ID, TRADE_FROM)
434
) DEFAULT CHARSET = 'utf8';
435

436
CREATE TABLE if not exists TRADE_PAYMENT_CLAUSE_000 
437
(
438
  ID                     int           NOT NULL,
439
  OUT_RELATION_ID        varchar(64),
440
  SERIAL_NO              int,
441
  TRADE_NO               varchar(64)    NOT NULL,
442
  GMT_CREATE             TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
443
  GMT_MODIFIED           TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
444
  PAYMENT_TYPE           varchar(64)    NOT NULL,
445
  STATUS                 varchar(50),
446
  PAY_ACCOUNT_NO         varchar(20),
447
  PAY_USER_ID            varchar(16),
448
  RECEIVE_ACCOUNT_NO     varchar(20),
449
  RECEIVE_USER_ID        varchar(16),
450
  AMOUNT                 int,
451
  CURRENCY               varchar(64),
452
  PAYMENT_RESTRICT_RULE  varchar(1000),
453
  DESCRIPTION            varchar(1000),
454
  MEMO                   varchar(1000),
455
  CONTEXT                varchar(1000),
456
  primary key (TRADE_NO, OUT_RELATION_ID)
457
)DEFAULT CHARSET = 'utf8';
458
CREATE INDEX TRADE_PCLAUSE_000_GMT_IND ON TRADE_PAYMENT_CLAUSE_000 
459
(GMT_MODIFIED);
460

461
CREATE TABLE if not exists TRADE_PAYMENT_ORDER_000 
462
(
463
  ORDER_NO            varchar(64)    NOT NULL,
464
  TRADE_NO            varchar(64)    NOT NULL,
465
  BIZ_TYPE            varchar(20)    NOT NULL,
466
  OUT_ORDER_NO        varchar(64),
467
  GMT_MODIFIED        TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
468
  STATUS              varchar(2)     NOT NULL,
469
  PAY_ACCOUNT_NO      varchar(20)    NOT NULL,
470
  RECEIVE_ACCOUNT_NO  varchar(20)    NOT NULL,
471
  AMOUNT              int           NOT NULL,
472
  RETURN_AMOUNT       int,
473
  CURRENCY            varchar(3)     NOT NULL,
474
  FREEZE_TYPE         varchar(5),
475
  EXT_INFO            varchar(1000),
476
  MEMO                varchar(1000),
477
  PAYMENT_ID          varchar(64),
478
  PAYMENT_CONTEXT     varchar(1000),
479
  GMT_PAY             TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
480
  GMT_CREATE          TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
481
  FREEZE_AMOUNT       int,
482
  SUB_TRANS_CODE      varchar(40)    NOT NULL,
483
  primary key (TRADE_NO, ORDER_NO)
484
  )DEFAULT CHARSET = 'utf8';
485

486
CREATE INDEX TRADE_PAYMENT_ORD_000_GM_IND ON TRADE_PAYMENT_ORDER_000
487
(GMT_MODIFIED);
488

489
CREATE TABLE if not exists TRADE_PROCESS_000 
490
(
491
  ID                        int           NOT NULL,
492
  TRADE_NO                  varchar(64)   default ' ' NOT NULL,
493
  OUT_TRADE_NO              varchar(64),
494
  RECEIVE_FEE               int           default 0 NOT NULL,
495
  SEND_FEE                  int           default 0 NOT NULL,
496
  ADJUST_FEE                int           default 0 NOT NULL,
497
  MEMO                      varchar(600),
498
  OPERATE_TIME              TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
499
  OPERATE_NAME              varchar(256),
500
  FLAG_REFUND               varchar(4)    default '0' NOT NULL,
501
  FLAG_DEFERPAY             varchar(4)    default '0' NOT NULL,
502
  FLAG_PAYMENT              varchar(8)    default '0' NOT NULL,
503
  FLAG_TRADE_LOCKED         varchar(4)    default '0' NOT NULL,
504
  FLAG_SELLER_MDF           varchar(4)    default '0' NOT NULL,
505
  GMT_CREATE                TIMESTAMP(6) default "2012-01-01 12:00:00"                ,
506
  GMT_MODIFIED              TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
507
  GMT_RECEIVE_PAY           TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
508
  GMT_SEND_PAY              TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
509
  GMT_SEND_GOODS            TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
510
  TIME_OUT_RULE             varchar(1000),
511
  GMT_OUT_TRADE_NO_CREATED  TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
512
  COUPON_CLEAR_FEE          int,
513
  COUPON_ADJUST_FEE         int,
514
  REFUND_FEE                int,
515
  GMT_REFUND_PAY            TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
516
  GMT_FINISH                TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
517
  ACCOUNT_TX_ID             varchar(40),
518
  ADJUST_TIMEOUT            int,
519
  GMT_PRE_AUTH              TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
520
  PRE_AUTH_FEE              int,
521
  ACTUAL_ADJUST_FEE         int,
522
  EXPIRE_TIME               TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
523
  SEND_BACK_FEE             int,
524
  PRIMARY KEY (TRADE_NO)
525
 )DEFAULT CHARSET = 'utf8';
526

527
CREATE INDEX IND_BYD_TRD_PROCESS_GRPAY ON TRADE_PROCESS_000 
528
(GMT_RECEIVE_PAY, RECEIVE_FEE);
529

530
CREATE INDEX TRADE_PROCESS_GMT_IND ON TRADE_PROCESS_000
531
(GMT_MODIFIED);
532

533
CREATE TABLE if not exists TRADE_REFUND_000 
534
(
535
  ID                  int           NOT NULL,
536
  TRADE_NO            varchar(64)    NOT NULL,
537
  OUT_TRADE_NO        varchar(64),
538
  RETURN_STATUS       varchar(100),
539
  MEMO                varchar(2000),
540
  RETURN_FEE          int,
541
  GMT_ADMIN_MODIFIED  TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
542
  ADMIN_STATUS        varchar(100),
543
  RETURN_TYPE         varchar(20)    NOT NULL,
544
  RETURN_GOODS        int,
545
  GOODS_STATUS        int,
546
  CLOSE_CAUSE         varchar(600),
547
  REQUIRE_VOUCHER     int,
548
  GMT_CREATE          TIMESTAMP(6) default "2012-01-01 12:00:00"                NOT NULL,
549
  GMT_MODIFIED        TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
550
  SELLER_NOT_RECEIVE  int,
551
  REFUND_REASON       varchar(400),
552
  APPEAL_NO           varchar(50),
553
  GMT_DW_SYNC         TIMESTAMP(6) default "2012-01-01 12:00:00"        ,
554
  BUY_USER_ID         varchar(16)    NOT NULL,
555
  BUY_ACCOUNT         varchar(20)    NOT NULL,
556
  SELL_USER_ID        varchar(16)    NOT NULL,
557
  SELL_ACCOUNT        varchar(20)    NOT NULL,
558
  TRADE_FROM          varchar(100),
559
  TRADE_EMAIL         varchar(100),
560
  IS_INPOUR_REFUND   	VARCHAR(1),
561
  REFUND_FLOW_TYPE   	VARCHAR(1),
562
  GMT_LAST_APPLY      TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
563
  REFUND_FOREX_FEE    int,
564
  PRIMARY KEY (TRADE_NO, ID)
565
)DEFAULT CHARSET = 'utf8';
566
CREATE INDEX TRADE_REFUND_BG_IND ON TRADE_REFUND_000 
567
(BUY_ACCOUNT, GMT_CREATE);
568

569
CREATE INDEX TRADE_REFUND_SG_IND ON TRADE_REFUND_000 
570
(SELL_ACCOUNT, GMT_CREATE);
571

572
CREATE INDEX TRADE_REFUND_TG_IND ON TRADE_REFUND_000 
573
(TRADE_EMAIL, GMT_CREATE);
574

575
CREATE INDEX TRADE_REFUND_000_GMT_IND ON TRADE_REFUND_000 (GMT_MODIFIED);
576

577
CREATE TABLE if not exists TRADE_VOUCHER_000 
578
(
579
  ID                     int           NOT NULL,
580
  TRADE_NO               varchar(64)   default ' '  NOT NULL,
581
  REFUND_ID              int           NOT NULL,
582
  SELLER_OR_BUYER        VARCHAR(1)    default 'S' NOT NULL,
583
  SELLER_UPLOAD_VOUCHER  varchar(4000),
584
  BUYER_UPLOAD_VOUCHER   varchar(4000),
585
  UPLOAD_FLAG            int           default 0 NOT NULL,
586
  GMT_CREATE             TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
587
  GMT_MODIFIED           TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
588
  GMT_CHECK              TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
589
  LAST_OPERATOR          varchar(32),
590
  CHECK_MEMO             varchar(2000),
591
  MEMEO                  varchar(4000),
592
  GMT_TIMEOUT_START      TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
593
  PRIMARY KEY (TRADE_NO, ID)
594
) DEFAULT CHARSET = 'utf8';
595

596
CREATE INDEX TRADE_VOUCHER_000_MT_IND ON TRADE_VOUCHER_000
597
(GMT_MODIFIED);
598

599
CREATE TABLE if not exists TRADE_RECEIVE_ADDRESS_000
600
(
601
TRADE_NO          VARCHAR(64)   NOT NULL,
602
ADDRESS_NO        VARCHAR(100)  NOT NULL,
603
RECEIVE_NAME      VARCHAR(256),
604
ADDRESS_CODE      VARCHAR(8),
605
ADDRESS           VARCHAR(256),
606
MOBILE_PHONE      VARCHAR(30),
607
PHONE             VARCHAR(30),
608
RECEIVE_POST      VARCHAR(20),
609
VIRTUAL_REC_INFO  VARCHAR(400),
610
GMT_CREATE        DATETIME                NOT NULL,
611
GMT_MODIFIED      DATETIME,
612
PRIMARY KEY (TRADE_NO, ADDRESS_NO)
613
)DEFAULT CHARSET = 'utf8';
614

615

616
CREATE TABLE if not exists TRADE_COOPERATE_000
617
(
618
TRADE_NO         VARCHAR(64),
619
COOPERATE_NO     VARCHAR(64),
620
COOPERATOR_FROM  VARCHAR(32),
621
GMT_CREATE       TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
622
GMT_MODIFIED     TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
623
PRIMARY key (TRADE_NO, COOPERATE_NO, COOPERATOR_FROM)
624
)DEFAULT CHARSET = 'utf8';
625

626
CREATE INDEX TRADE_COOPERATE_000_MT_IND ON TRADE_COOPERATE_000
627
(GMT_MODIFIED);
628

629
CREATE TABLE if not exists TRADE_SETTLE_ORDER_000
630
(
631
ORDER_NO            VARCHAR(64)    NOT NULL,
632
ORG_ORDER_NO        VARCHAR(64),
633
TRADE_NO            VARCHAR(64)    NOT NULL,
634
OUT_REQUEST_NO      VARCHAR(64),
635
BIZ_PRODUCT         VARCHAR(32),
636
SETTLE_ACTION_TYPE  VARCHAR(32),
637
AMOUNT              int           NOT NULL,
638
STATUS              VARCHAR(50)    NOT NULL,
639
EXTINFO             VARCHAR(1024),
640
MEMO                VARCHAR(512),
641
SETTLE_ID           VARCHAR(64),
642
SETTLE_CONTEXT      VARCHAR(1024),
643
GMT_CREATE          TIMESTAMP(6)         NOT NULL,
644
GMT_MODIFIED        TIMESTAMP(6),
645
SETTLE_TYPE         VARCHAR(32),
646
PRIMARY KEY (TRADE_NO, ORDER_NO, GMT_CREATE)
647
)DEFAULT CHARSET = 'utf8';
648

649

650
CREATE TABLE if not exists TRADE_PARTICIPANT_000
651
(
652
TRADE_NO          VARCHAR(64)   NOT NULL,
653
USER_ID           VARCHAR(16)   NOT NULL,
654
USER_NAME         VARCHAR(256),
655
USER_NICK         VARCHAR(100),
656
PARTICIPANT_ROLE  VARCHAR(64)   NOT NULL,
657
MEMO              VARCHAR(200),
658
GMT_CREATE        TIMESTAMP(6) default "2012-01-01 12:00:00"              NOT NULL,
659
GMT_MODIFIED      TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
660
PRIMARY KEY (TRADE_NO, USER_ID, PARTICIPANT_ROLE)
661
)DEFAULT CHARSET = 'utf8';
662

663
CREATE TABLE if not exists BUSINESS_ACTIVITY_ASYNC_000
664
(
665
TX_ID                VARCHAR(128)   NOT NULL,
666
STATE                VARCHAR(1)         NOT NULL,
667
ACCOUNT_TRANS_STATE  VARCHAR(1)         NOT NULL,
668
GMT_CREATE           TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
669
GMT_MODIFIED         TIMESTAMP(6) default "2012-01-01 12:00:00"        NOT NULL,
670
PROPAGATION          VARCHAR(1),
671
CONTEXT              VARCHAR(2048),
672
PRIMARY KEY (TX_ID)
673
)DEFAULT CHARSET = 'utf8';
674

675
CREATE TABLE if not exists EXTERFACE_INVOKE_000
676
(
677
  ID           int         NOT NULL,
678
  PARTNER_ID   VARCHAR(32)   NOT NULL,
679
  TARGET       VARCHAR(64)   NOT NULL,
680
  EXTERFACE    VARCHAR(128)  NOT NULL,
681
  NOTIFY_URL   VARCHAR(200),
682
  RETURN_URL   VARCHAR(200),
683
  SIGN_TYPE    VARCHAR(10),
684
  CHARSET      VARCHAR(20),
685
  GMT_INVOKE   TIMESTAMP(6) default "2012-01-01 12:00:00"       NOT NULL,
686
  GMT_FINISH   TIMESTAMP(6) default "2012-01-01 12:00:00"      NOT NULL,
687
  TARGET_TYPE  VARCHAR(20)   NOT NULL,
688
  GMT_NOTIFY   TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
689
  GMT_RETURN   TIMESTAMP(6) default "2012-01-01 12:00:00" NULL,
690
  PRIMARY KEY(TARGET_TYPE, TARGET, PARTNER_ID)
691
)DEFAULT CHARSET = 'utf8';
692

693
CREATE INDEX EXTERFACE_INVOKE_000_ID_IND ON EXTERFACE_INVOKE_000(ID);
694