-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdata.sql
More file actions
96 lines (85 loc) · 2.35 KB
/
Copy pathdata.sql
File metadata and controls
96 lines (85 loc) · 2.35 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
CREATE TABLE BidList (
BidListId tinyint(4) NOT NULL AUTO_INCREMENT,
account VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
bidQuantity DOUBLE,
askQuantity DOUBLE,
bid DOUBLE ,
ask DOUBLE,
benchmark VARCHAR(125),
bidListDate TIMESTAMP,
commentary VARCHAR(125),
security VARCHAR(125),
status VARCHAR(10),
trader VARCHAR(125),
book VARCHAR(125),
creationName VARCHAR(125),
creationDate TIMESTAMP ,
revisionName VARCHAR(125),
revisionDate TIMESTAMP ,
dealName VARCHAR(125),
dealType VARCHAR(125),
sourceListId VARCHAR(125),
side VARCHAR(125),
PRIMARY KEY (BidListId)
);
CREATE TABLE Trade (
TradeId tinyint(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
account VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
buyQuantity DOUBLE,
sellQuantity DOUBLE,
buyPrice DOUBLE ,
sellPrice DOUBLE,
tradeDate TIMESTAMP,
security VARCHAR(125),
status VARCHAR(10),
trader VARCHAR(125),
benchmark VARCHAR(125),
book VARCHAR(125),
creationName VARCHAR(125),
creationDate TIMESTAMP ,
revisionName VARCHAR(125),
revisionDate TIMESTAMP ,
dealName VARCHAR(125),
dealType VARCHAR(125),
sourceListId VARCHAR(125),
side VARCHAR(125)
);
CREATE TABLE CurvePoint (
Id tinyint(4) NOT NULL AUTO_INCREMENT,
CurveId tinyint,
asOfDate TIMESTAMP,
term DOUBLE ,
value DOUBLE ,
creationDate TIMESTAMP ,
PRIMARY KEY (Id)
);
CREATE TABLE Rating (
Id tinyint(4) NOT NULL AUTO_INCREMENT,
moodysRating VARCHAR(125),
sandPRating VARCHAR(125),
fitchRating VARCHAR(125),
orderNumber tinyint,
PRIMARY KEY (Id)
);
CREATE TABLE RuleName (
Id tinyint(4) NOT NULL AUTO_INCREMENT,
name VARCHAR(125),
description VARCHAR(125),
json VARCHAR(125),
template VARCHAR(512),
sqlStr VARCHAR(125),
sqlPart VARCHAR(125),
PRIMARY KEY (Id)
);
CREATE TABLE Users (
Id tinyint(4) NOT NULL AUTO_INCREMENT,
username VARCHAR(125),
password VARCHAR(125),
fullname VARCHAR(125),
role VARCHAR(125),
PRIMARY KEY (Id)
);
insert into Users(fullname, username, password, role) values("Administrator", "admin", "$2a$10$pBV8ILO/s/nao4wVnGLrh.sa/rnr5pDpbeC4E.KNzQWoy8obFZdaa", "ADMIN");
insert into Users(fullname, username, password, role) values("User", "user", "$2a$10$pBV8ILO/s/nao4wVnGLrh.sa/rnr5pDpbeC4E.KNzQWoy8obFZdaa", "USER");