-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathdata.sql
More file actions
107 lines (94 loc) · 2.73 KB
/
Copy pathdata.sql
File metadata and controls
107 lines (94 loc) · 2.73 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
97
98
99
100
101
102
103
104
105
106
107
CREATE TABLE BidList
(
BidListId int 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 DATETIME NULL DEFAULT NULL ,
commentary VARCHAR(125),
security VARCHAR(125),
status VARCHAR(10),
trader VARCHAR(125),
book VARCHAR(125),
creationName VARCHAR(125),
creationDate DATETIME NOT NULL,
revisionName VARCHAR(125),
revisionDate DATETIME NOT NULL,
dealName VARCHAR(125),
dealType VARCHAR(125),
sourceListId VARCHAR(125),
side VARCHAR(125),
PRIMARY KEY (BidListId)
);
CREATE TABLE Trade
(
TradeId int NOT NULL AUTO_INCREMENT,
account VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
buyQuantity DOUBLE,
sellQuantity DOUBLE,
buyPrice DOUBLE,
sellPrice DOUBLE,
tradeDate DATETIME NULL default NULL,
security VARCHAR(125),
status VARCHAR(10),
trader VARCHAR(125),
benchmark VARCHAR(125),
book VARCHAR(125),
creationName VARCHAR(125),
creationDate DATETIME NOT NULL,
revisionName VARCHAR(125),
revisionDate DATETIME NOT NULL,
dealName VARCHAR(125),
dealType VARCHAR(125),
sourceListId VARCHAR(125),
side VARCHAR(125),
PRIMARY KEY (TradeId)
);
CREATE TABLE CurvePoint
(
Id int NOT NULL AUTO_INCREMENT,
CurveId int ,
asOfDate DATETIME NULL default NULL,
term DOUBLE,
value DOUBLE,
creationDate DATETIME NOT NULL,
PRIMARY KEY (Id)
);
CREATE TABLE Rating
(
Id int NOT NULL AUTO_INCREMENT,
moodysRating VARCHAR(125),
sandPRating VARCHAR(125),
fitchRating VARCHAR(125),
orderNumber int ,
PRIMARY KEY (Id)
);
CREATE TABLE RuleName
(
Id int 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 int NOT NULL AUTO_INCREMENT,
username VARCHAR(125) NOT NULL,
password VARCHAR(125) NOT NULL,
fullname VARCHAR(125) NOT NULL,
role VARCHAR(125) NOT NULL,
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');