dJBTFrUN

1-- BEGIN generate DDL --
2
3DROP DATABASE IF EXISTS ex;
4
5CREATE DATABASE ex;
6
7DROP USER IF EXISTS ex_rw@'%';
8
9CREATE USER ex_rw@'%' IDENTIFIED BY 'ex_rw_password';
10
11GRANT SELECT,INSERT,DELETE,UPDATE ON ex.* TO ex_rw@'%' WITH GRANT OPTION;
12
13DROP USER IF EXISTS ex_ro@'%';
14
15CREATE USER ex_ro@'%' IDENTIFIED BY 'ex_ro_password';
16
17GRANT SELECT ON ex.* TO ex_ro@'%' WITH GRANT OPTION;
18
19USE ex;
20
21
22CREATE TABLE withdraw_requests (
23  id BIGINT AUTO_INCREMENT NOT NULL,
24  createdAt BIGINT NOT NULL,
25  updatedAt BIGINT NOT NULL,
26  userId BIGINT NOT NULL,
27  version BIGINT NOT NULL,
28  amount DECIMAL(36,18) NOT NULL,
29  withdrawFee DECIMAL(36,18) NOT NULL,
30  currency VARCHAR(32) NOT NULL,
31  errorCode VARCHAR(32) NOT NULL,
32  status VARCHAR(50) NOT NULL,
33  errorMessage VARCHAR(100) NOT NULL,
34  tx VARCHAR(200) NOT NULL,
35  encryptedToAddress VARCHAR(1000) NOT NULL,
36  INDEX IDX_USER_ID (userId),
37  PRIMARY KEY(id)
38) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
39
40
41CREATE TABLE spot_accounts (
42  id BIGINT AUTO_INCREMENT NOT NULL,
43  createdAt BIGINT NOT NULL,
44  updatedAt BIGINT NOT NULL,
45  userId BIGINT NOT NULL,
46  version BIGINT NOT NULL,
47  balance DECIMAL(36,18) NOT NULL,
48  currency VARCHAR(32) NOT NULL,
49  type VARCHAR(32) NOT NULL,
50  CONSTRAINT UNI_USERID_CURRENCY_TYPE UNIQUE (userId, currency, type),
51  PRIMARY KEY(id)
52) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
53
54
55
56CREATE TABLE hd_deposit_addresses (
57  id BIGINT AUTO_INCREMENT NOT NULL,
58  bipIndex INTEGER NOT NULL,
59  createdAt BIGINT NOT NULL,
60  userId BIGINT NOT NULL,
61  currency VARCHAR(32) NOT NULL,
62  CONSTRAINT UNI_IDX_CUR UNIQUE (bipIndex, currency),
63  CONSTRAINT UNI_USERID_CUR UNIQUE (userId, currency),
64  PRIMARY KEY(id)
65) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
66
67
68CREATE TABLE order_sequences_4 (
69  id BIGINT NOT NULL,
70  createdAt BIGINT NOT NULL,
71  orderId BIGINT NOT NULL,
72  previousId BIGINT NOT NULL,
73  symbol VARCHAR(32) NOT NULL,
74  CONSTRAINT UNI_ORDER_ID UNIQUE (orderId),
75  PRIMARY KEY(id)
76) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
77
78CREATE TABLE ext_order_whitelist (
79  id BIGINT AUTO_INCREMENT NOT NULL,
80  createdAt BIGINT NOT NULL,
81  updatedAt BIGINT NOT NULL,
82  userId BIGINT NOT NULL,
83  version BIGINT NOT NULL,
84  symbol VARCHAR(32) NOT NULL,
85  CONSTRAINT UNI_USER_SYMBOL UNIQUE (userId, symbol),
86  PRIMARY KEY(id)
87) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
88
89
90CREATE TABLE match_details (
91  id BIGINT AUTO_INCREMENT NOT NULL,
92  createdAt BIGINT NOT NULL,
93  orderId BIGINT NOT NULL,
94  userId BIGINT NOT NULL,
95  amount DECIMAL(36,18) NOT NULL,
96  fee DECIMAL(36,18) NOT NULL,
97  price DECIMAL(36,18) NOT NULL,
98  feeCurrency VARCHAR(32) NOT NULL,
99  type VARCHAR(50) NOT NULL,
100  INDEX IDX_ORDERID (orderId),
101  PRIMARY KEY(id)
102) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
103
104
105CREATE TABLE withdraw_addresses (
106  id BIGINT AUTO_INCREMENT NOT NULL,
107  createdAt BIGINT NOT NULL,
108  userId BIGINT NOT NULL,
109  currency VARCHAR(32) NOT NULL,
110  addressHash VARCHAR(100) NOT NULL,
111  description VARCHAR(100) NOT NULL,
112  encryptedAddress VARCHAR(1000) NOT NULL,
113  CONSTRAINT UNI_ADDR_CUR_USERID UNIQUE (addressHash, currency, userId),
114  PRIMARY KEY(id)
115) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
116
117
118CREATE TABLE symbol_fee_rates (
119  id BIGINT AUTO_INCREMENT NOT NULL,
120  createdAt BIGINT NOT NULL,
121  startTime BIGINT NOT NULL,
122  makerFeeRate DECIMAL(36,18) NOT NULL,
123  takerFeeRate DECIMAL(36,18) NOT NULL,
124  symbol VARCHAR(255) NOT NULL,
125  CONSTRAINT UNI_START_SYMBOL UNIQUE (startTime, symbol),
126  PRIMARY KEY(id)
127) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
128
129
130CREATE TABLE deposit_rules (
131  id BIGINT AUTO_INCREMENT NOT NULL,
132  confirms INTEGER NOT NULL,
133  createdAt BIGINT NOT NULL,
134  amount DECIMAL(36,18) NOT NULL,
135  currency VARCHAR(32) NOT NULL,
136  INDEX IDX_CURRENCY (currency),
137  PRIMARY KEY(id)
138) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
139
140
141CREATE TABLE users (
142  id BIGINT AUTO_INCREMENT NOT NULL,
143  canSignin BOOL NOT NULL,
144  canTrade BOOL NOT NULL,
145  canWithdraw BOOL NOT NULL,
146  internal BOOL NOT NULL,
147  level INTEGER NOT NULL,
148  createdAt BIGINT NOT NULL,
149  organizationId BIGINT NOT NULL,
150  referrerId BIGINT NOT NULL,
151  updatedAt BIGINT NOT NULL,
152  version BIGINT NOT NULL,
153  type VARCHAR(50) NOT NULL,
154  PRIMARY KEY(id)
155) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
156
157
158CREATE TABLE ext_order_fee_refunds (
159  id BIGINT AUTO_INCREMENT NOT NULL,
160  createdAt BIGINT NOT NULL,
161  orderId BIGINT NOT NULL,
162  userId BIGINT NOT NULL,
163  refundPercent DOUBLE NOT NULL,
164  exchangeRate DECIMAL(36,18) NOT NULL,
165  originalFee DECIMAL(36,18) NOT NULL,
166  refundedFee DECIMAL(36,18) NOT NULL,
167  replacedFee DECIMAL(36,18) NOT NULL,
168  originalFeeCurrency VARCHAR(32) NOT NULL,
169  replacedFeeCurrency VARCHAR(32) NOT NULL,
170  CONSTRAINT UNI_ORDER_ID UNIQUE (orderId),
171  PRIMARY KEY(id)
172) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
173
174
175CREATE TABLE clearing_results (
176  id BIGINT AUTO_INCREMENT NOT NULL,
177  createdAt BIGINT NOT NULL,
178  orderId BIGINT NOT NULL,
179  symbol VARCHAR(32) NOT NULL,
180  type VARCHAR(50) NOT NULL,
181  hashStatus VARCHAR(100) NOT NULL,
182  CONSTRAINT UNI_ORDER_ID UNIQUE (orderId),
183  PRIMARY KEY(id)
184) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
185
186
187CREATE TABLE withdraw_fees (
188  id BIGINT AUTO_INCREMENT NOT NULL,
189  blockHeight BIGINT NOT NULL,
190  createdAt BIGINT NOT NULL,
191  feeAmount DECIMAL(36,18) NOT NULL,
192  currency VARCHAR(32) NOT NULL,
193  feeCurrency VARCHAR(32) NOT NULL,
194  blockHash VARCHAR(100) NOT NULL,
195  tx VARCHAR(100) NOT NULL,
196  uniqueId VARCHAR(200) NOT NULL,
197  CONSTRAINT UNI_UNIQUE_ID UNIQUE (uniqueId),
198  PRIMARY KEY(id)
199) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
200
201CREATE TABLE orders (
202  id BIGINT AUTO_INCREMENT NOT NULL,
203  chargeQuote BOOL NOT NULL,
204  features INTEGER NOT NULL,
205  sequenceIndex INTEGER NOT NULL,
206  createdAt BIGINT NOT NULL,
207  previousSeqId BIGINT NOT NULL,
208  refOrderId BIGINT NOT NULL,
209  refSeqId BIGINT NOT NULL,
210  seqId BIGINT NOT NULL,
211  updatedAt BIGINT NOT NULL,
212  userId BIGINT NOT NULL,
213  version BIGINT NOT NULL,
214  amount DECIMAL(36,18) NOT NULL,
215  fee DECIMAL(36,18) NOT NULL,
216  filledAmount DECIMAL(36,18) NOT NULL,
217  makerFeeRate DECIMAL(36,18) NOT NULL,
218  price DECIMAL(36,18) NOT NULL,
219  takerFeeRate DECIMAL(36,18) NOT NULL,
220  triggerOn DECIMAL(36,18) NOT NULL,
221  source VARCHAR(32) NOT NULL,
222  status VARCHAR(50) NOT NULL,
223  symbol VARCHAR(32) NOT NULL,
224  type VARCHAR(50) NOT NULL,
225  INDEX IDX_USERID_STATUS_SYMBOL (userId, status, symbol),
226  INDEX IDX_CREATEDAT (createdAt),
227  PRIMARY KEY(id)
228) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
229
230CREATE TABLE deposit_results (
231  id BIGINT AUTO_INCREMENT NOT NULL,
232  shouldAudit BOOL NOT NULL,
233  cancelled INTEGER NOT NULL,
234  confirms INTEGER NOT NULL,
235  deposited INTEGER NOT NULL,
236  minimumConfirms INTEGER NOT NULL,
237  createdAt BIGINT NOT NULL,
238  updatedAt BIGINT NOT NULL,
239  userId BIGINT NOT NULL,
240  version BIGINT NOT NULL,
241  amount DECIMAL(36,18) NOT NULL,
242  currency VARCHAR(32) NOT NULL,
243  status VARCHAR(50) NOT NULL,
244  uniqueId VARCHAR(200) NOT NULL,
245  encryptedToAddress VARCHAR(1000) NOT NULL,
246  CONSTRAINT UNI_UNIQUE_ID UNIQUE (uniqueId),
247  INDEX IDX_CURRENCY (currency),
248  PRIMARY KEY(id)
249) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
250
251
252CREATE TABLE ext_mining_reports (
253  id BIGINT AUTO_INCREMENT NOT NULL,
254  userId BIGINT NOT NULL,
255  feeAmount DECIMAL(36,18) NOT NULL,
256  miningAmount DECIMAL(36,18) NOT NULL,
257  feeCurrency VARCHAR(32) NOT NULL,
258  miningCurrency VARCHAR(32) NOT NULL,
259  reportDate VARCHAR(32) NOT NULL,
260  CONSTRAINT UNI_DATE_USER_CUR UNIQUE (reportDate, userId, feeCurrency),
261  PRIMARY KEY(id)
262) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
263
264
265CREATE TABLE archive_orders (
266  id BIGINT NOT NULL,
267  chargeQuote BOOL NOT NULL,
268  features INTEGER NOT NULL,
269  sequenceIndex INTEGER NOT NULL,
270  createdAt BIGINT NOT NULL,
271  previousSeqId BIGINT NOT NULL,
272  refOrderId BIGINT NOT NULL,
273  refSeqId BIGINT NOT NULL,
274  seqId BIGINT NOT NULL,
275  updatedAt BIGINT NOT NULL,
276  userId BIGINT NOT NULL,
277  version BIGINT NOT NULL,
278  amount DECIMAL(36,18) NOT NULL,
279  fee DECIMAL(36,18) NOT NULL,
280  filledAmount DECIMAL(36,18) NOT NULL,
281  makerFeeRate DECIMAL(36,18) NOT NULL,
282  price DECIMAL(36,18) NOT NULL,
283  takerFeeRate DECIMAL(36,18) NOT NULL,
284  triggerOn DECIMAL(36,18) NOT NULL,
285  source VARCHAR(32) NOT NULL,
286  status VARCHAR(50) NOT NULL,
287  symbol VARCHAR(32) NOT NULL,
288  type VARCHAR(50) NOT NULL,
289  INDEX IDX_USERID_SYMBOL (userId, symbol),
290  PRIMARY KEY(id)
291) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
292
293
294CREATE TABLE spot_account_flows (
295  id BIGINT AUTO_INCREMENT NOT NULL,
296  createdAt BIGINT NOT NULL,
297  fromAccountId BIGINT NOT NULL,
298  fromUserId BIGINT NOT NULL,
299  refId BIGINT NOT NULL,
300  toAccountId BIGINT NOT NULL,
301  toUserId BIGINT NOT NULL,
302  amount DECIMAL(36,18) NOT NULL,
303  currency VARCHAR(32) NOT NULL,
304  flowType VARCHAR(50) NOT NULL,
305  refType VARCHAR(32) NOT NULL,
306  description VARCHAR(200) NOT NULL,
307  INDEX IDX_CREATEDAT (createdAt),
308  PRIMARY KEY(id)
309) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
310
311
312CREATE TABLE clearing_records (
313  id BIGINT AUTO_INCREMENT NOT NULL,
314  done BOOL NOT NULL,
315  createdAt BIGINT NOT NULL,
316  fromAccountId BIGINT NOT NULL,
317  fromUserId BIGINT NOT NULL,
318  makerOrderId BIGINT NOT NULL,
319  takerOrderId BIGINT NOT NULL,
320  toAccountId BIGINT NOT NULL,
321  toUserId BIGINT NOT NULL,
322  makerFee DECIMAL(36,18) NULL,
323  makerFilledAmount DECIMAL(36,18) NULL,
324  takerFee DECIMAL(36,18) NULL,
325  takerFilledAmount DECIMAL(36,18) NULL,
326  transferAmount DECIMAL(36,18) NOT NULL,
327  currency VARCHAR(32) NOT NULL,
328  makerOrderStatus VARCHAR(50) NULL,
329  takerOrderStatus VARCHAR(50) NULL,
330  transfer VARCHAR(50) NOT NULL,
331  type VARCHAR(50) NOT NULL,
332  INDEX IDX_MAKER_ORDER_ID (makerOrderId),
333  PRIMARY KEY(id)
334) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
335
336
337CREATE TABLE symbols (
338  id BIGINT AUTO_INCREMENT NOT NULL,
339  baseScale INTEGER NOT NULL,
340  displayOrder INTEGER NOT NULL,
341  quoteScale INTEGER NOT NULL,
342  sequenceIndex INTEGER NOT NULL,
343  createdAt BIGINT NOT NULL,
344  endTime BIGINT NOT NULL,
345  startTime BIGINT NOT NULL,
346  updatedAt BIGINT NOT NULL,
347  version BIGINT NOT NULL,
348  baseMinimum DECIMAL(36,18) NOT NULL,
349  quoteMinimum DECIMAL(36,18) NOT NULL,
350  baseName VARCHAR(32) NOT NULL,
351  quoteName VARCHAR(32) NOT NULL,
352  meta VARCHAR(1000) NOT NULL,
353  CONSTRAINT UNI_BASE_QUOTE UNIQUE (baseName, quoteName),
354  PRIMARY KEY(id)
355) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
356
357
358CREATE TABLE user_fee_rates (
359  id BIGINT AUTO_INCREMENT NOT NULL,
360  createdAt BIGINT NOT NULL,
361  startTime BIGINT NOT NULL,
362  userId BIGINT NULL,
363  makerFeeRate DECIMAL(36,18) NOT NULL,
364  takerFeeRate DECIMAL(36,18) NOT NULL,
365  CONSTRAINT UNI_START_USERID UNIQUE (startTime, userId),
366  PRIMARY KEY(id)
367) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
368
369
370CREATE TABLE level_fee_rates (
371  id BIGINT AUTO_INCREMENT NOT NULL,
372  level INTEGER NOT NULL,
373  createdAt BIGINT NOT NULL,
374  startTime BIGINT NOT NULL,
375  makerFeeRate DECIMAL(36,18) NOT NULL,
376  takerFeeRate DECIMAL(36,18) NOT NULL,
377  CONSTRAINT UNI_START_LEVEL UNIQUE (startTime, level),
378  PRIMARY KEY(id)
379) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
380
381
382CREATE TABLE withdraw_rules (
383  id BIGINT AUTO_INCREMENT NOT NULL,
384  createdAt BIGINT NOT NULL,
385  feeRate DECIMAL(36,18) NOT NULL,
386  maximumFee DECIMAL(36,18) NOT NULL,
387  minimumAmount DECIMAL(36,18) NOT NULL,
388  minimumFee DECIMAL(36,18) NOT NULL,
389  currency VARCHAR(32) NOT NULL,
390  CONSTRAINT UNI_CURRENCY UNIQUE (currency),
391  PRIMARY KEY(id)
392) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
393
394
395CREATE TABLE api_key_auths (
396  id BIGINT AUTO_INCREMENT NOT NULL,
397  canTrade BOOL NOT NULL,
398  canWithdraw BOOL NOT NULL,
399  enabled BOOL NOT NULL,
400  netAddress INTEGER NOT NULL,
401  netmask INTEGER NOT NULL,
402  createdAt BIGINT NOT NULL,
403  updatedAt BIGINT NOT NULL,
404  userId BIGINT NOT NULL,
405  version BIGINT NOT NULL,
406  apiKey VARCHAR(32) NOT NULL,
407  apiSecret VARCHAR(32) NOT NULL,
408  description VARCHAR(100) NOT NULL,
409  CONSTRAINT UNI_API_KEY UNIQUE (apiKey),
410  INDEX IDX_USERID (userId),
411  PRIMARY KEY(id)
412) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
413
414
415CREATE TABLE fee_reports (
416  id BIGINT AUTO_INCREMENT NOT NULL,
417  collected BOOL NOT NULL,
418  divided BOOL NOT NULL,
419  createdAt BIGINT NOT NULL,
420  feeAmount DECIMAL(36,18) NOT NULL,
421  feeCurrency VARCHAR(32) NOT NULL,
422  reportDate VARCHAR(32) NOT NULL,
423  CONSTRAINT UNI_DATE_CUR UNIQUE (reportDate, feeCurrency),
424  PRIMARY KEY(id)
425) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
426
427
428CREATE TABLE ticks (
429  id BIGINT AUTO_INCREMENT NOT NULL,
430  createdAt BIGINT NOT NULL,
431  makerOrderId BIGINT NOT NULL,
432  takerOrderId BIGINT NOT NULL,
433  amount DECIMAL(36,18) NOT NULL,
434  price DECIMAL(36,18) NOT NULL,
435  symbol VARCHAR(32) NOT NULL,
436  CONSTRAINT UNI_CREATED_TAKER_MAKER UNIQUE (createdAt, takerOrderId, makerOrderId),
437  PRIMARY KEY(id)
438) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
439
440
441CREATE TABLE match_message_store (
442  id BIGINT AUTO_INCREMENT NOT NULL,
443  createdAt BIGINT NOT NULL,
444  orderId BIGINT NOT NULL,
445  hashStatus VARCHAR(32) NOT NULL,
446  symbol VARCHAR(32) NOT NULL,
447  message TEXT NOT NULL,
448  CONSTRAINT UNI_ORDER_ID UNIQUE (orderId),
449  PRIMARY KEY(id)
450) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
451
452
453CREATE TABLE bars (
454  id BIGINT AUTO_INCREMENT NOT NULL,
455  createdAt BIGINT NOT NULL,
456  startTime BIGINT NOT NULL,
457  amount DECIMAL(36,18) NOT NULL,
458  closePrice DECIMAL(36,18) NOT NULL,
459  highPrice DECIMAL(36,18) NOT NULL,
460  lowPrice DECIMAL(36,18) NOT NULL,
461  openPrice DECIMAL(36,18) NOT NULL,
462  symbol VARCHAR(32) NOT NULL,
463  type VARCHAR(50) NOT NULL,
464  CONSTRAINT UNI_START_TYPE_SYMBOL UNIQUE (startTime, type, symbol),
465  PRIMARY KEY(id)
466) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
467
468
469CREATE TABLE ext_mining_results (
470  id BIGINT AUTO_INCREMENT NOT NULL,
471  createdAt BIGINT NOT NULL,
472  orderId BIGINT NOT NULL,
473  userId BIGINT NOT NULL,
474  exchangeRate DECIMAL(36,18) NOT NULL,
475  feeAmount DECIMAL(36,18) NOT NULL,
476  miningAmount DECIMAL(36,18) NOT NULL,
477  miningPercent DECIMAL(36,18) NOT NULL,
478  feeCurrency VARCHAR(32) NOT NULL,
479  miningCurrency VARCHAR(32) NOT NULL,
480  CONSTRAINT UNI_ORDER_ID UNIQUE (orderId),
481  PRIMARY KEY(id)
482) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
483
484
485CREATE TABLE unreplays (
486  id BIGINT AUTO_INCREMENT NOT NULL,
487  createdAt BIGINT NOT NULL,
488  uniqueId VARCHAR(50) NOT NULL,
489  CONSTRAINT UNI_UNIQUE_ID UNIQUE (uniqueId),
490  PRIMARY KEY(id)
491) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
492
493
494
495
496CREATE TABLE transfer_requests (
497  id BIGINT AUTO_INCREMENT NOT NULL,
498  done BOOL NOT NULL,
499  createdAt BIGINT NOT NULL,
500  fromAccountId BIGINT NOT NULL,
501  fromUserId BIGINT NOT NULL,
502  refId BIGINT NOT NULL,
503  toAccountId BIGINT NOT NULL,
504  toUserId BIGINT NOT NULL,
505  amount DECIMAL(36,18) NOT NULL,
506  currency VARCHAR(32) NOT NULL,
507  flowType VARCHAR(50) NOT NULL,
508  refType VARCHAR(32) NOT NULL,
509  description VARCHAR(200) NOT NULL,
510  INDEX IDX_CREATEDAT (createdAt),
511  PRIMARY KEY(id)
512) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
513
514
515CREATE TABLE currencies (
516  id BIGINT AUTO_INCREMENT NOT NULL,
517  depositEnabled BOOL NOT NULL,
518  legal BOOL NOT NULL,
519  token BOOL NOT NULL,
520  withdrawEnabled BOOL NOT NULL,
521  tokenDecimals INTEGER NOT NULL,
522  createdAt BIGINT NOT NULL,
523  addressAliasTo VARCHAR(32) NOT NULL,
524  name VARCHAR(32) NOT NULL,
525  tokenIssuesOn VARCHAR(32) NOT NULL,
526  tokenContractAddress VARCHAR(100) NOT NULL,
527  encryptedXpubKey VARCHAR(1000) NOT NULL,
528  meta VARCHAR(1000) NOT NULL,
529  CONSTRAINT UNI_NAME UNIQUE (name),
530  PRIMARY KEY(id)
531) Engine=INNODB AUTO_INCREMENT=100000 DEFAULT CHARSET=utf8;
532
533-- END generate DDL --