-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdata.sql
More file actions
98 lines (87 loc) · 2.42 KB
/
Copy pathdata.sql
File metadata and controls
98 lines (87 loc) · 2.42 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
CREATE TABLE bidList (
bid_list_id tinyint(3) NOT NULL AUTO_INCREMENT,
account VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
bid_quantity DOUBLE,
ask_quantity DOUBLE,
bid DOUBLE ,
ask DOUBLE,
benchmark VARCHAR(125),
bid_list_date TIMESTAMP,
commentary VARCHAR(125),
security VARCHAR(125),
status VARCHAR(10),
trader VARCHAR(125),
book VARCHAR(125),
creation_name VARCHAR(125),
creation_date TIMESTAMP ,
revision_name VARCHAR(125),
revision_date TIMESTAMP ,
deal_name VARCHAR(125),
deal_type VARCHAR(125),
source_list_id VARCHAR(125),
side VARCHAR(125),
PRIMARY KEY (bid_list_id)
);
CREATE TABLE trade (
trade_id tinyint(3) NOT NULL AUTO_INCREMENT,
account VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
buy_quantity DOUBLE,
sell_quantity DOUBLE,
buy_price DOUBLE ,
sell_price DOUBLE,
trade_date TIMESTAMP,
security VARCHAR(125),
status VARCHAR(10),
trader VARCHAR(125),
benchmark VARCHAR(125),
book VARCHAR(125),
creation_name VARCHAR(125),
creation_date TIMESTAMP ,
revision_name VARCHAR(125),
revision_date TIMESTAMP ,
deal_name VARCHAR(125),
deal_type VARCHAR(125),
source_list_id VARCHAR(125),
side VARCHAR(125),
PRIMARY KEY (trade_id)
);
CREATE TABLE curve_point (
id tinyint(3) NOT NULL AUTO_INCREMENT,
Curve_id tinyint,
as_of_date TIMESTAMP,
term DOUBLE ,
value DOUBLE ,
creation_date TIMESTAMP ,
PRIMARY KEY (id)
);
CREATE TABLE rating (
id tinyint(3) NOT NULL AUTO_INCREMENT,
moodys_rating VARCHAR(125),
sandp_rating VARCHAR(125),
fitch_rating VARCHAR(125),
order_number tinyint,
PRIMARY KEY (id)
);
CREATE TABLE rule_name (
id tinyint(3) NOT NULL AUTO_INCREMENT,
name VARCHAR(125),
description VARCHAR(125),
json VARCHAR(125),
template VARCHAR(512),
sql_str VARCHAR(125),
sql_part VARCHAR(125),
PRIMARY KEY (id)
);
CREATE TABLE users (
id tinyint(3) NOT NULL AUTO_INCREMENT,
username VARCHAR(125),
password VARCHAR(125),
fullname VARCHAR(125),
role VARCHAR(125),
PRIMARY KEY (id)
);
-- Password+123
insert into users(fullname, username, password, role) values("Administrator", "admin", "$2y$10$7RqkEDjt5iCMKK.g9qsgb.5hyRRjF9T7iicOlmyJd8qiBMBqT0CQi", "ADMIN");
insert into users(fullname, username, password, role) values("User", "user", "$2y$10$7RqkEDjt5iCMKK.g9qsgb.5hyRRjF9T7iicOlmyJd8qiBMBqT0CQi", "USER");