forked from farm-army/farm-army-backend
-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.sql
23 lines (19 loc) · 801 Bytes
/
db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
PRAGMA auto_vacuum = INCREMENTAL;
CREATE TABLE IF NOT EXISTS token_price (
id INTEGER PRIMARY KEY AUTOINCREMENT,
token VARCHAR(255) NOT NULL,
price VARCHAR(255) NOT NULL,
price_usd VARCHAR(255) NULL,
created_at INT NOT NULL
);
CREATE INDEX IF NOT EXISTS idx_token ON token_price (token);
CREATE UNIQUE INDEX IF NOT EXISTS idx_token_created_at ON token_price (token, created_at);
CREATE TABLE IF NOT EXISTS lp_token_history (
id INTEGER PRIMARY KEY AUTOINCREMENT,
token VARCHAR(255) NOT NULL,
token0 VARCHAR(255) NOT NULL,
token1 VARCHAR(255) NULL,
created_at INT NOT NULL
);
CREATE INDEX IF NOT EXISTS idx_lp_history_token ON lp_token_history (token);
CREATE UNIQUE INDEX IF NOT EXISTS idx_lp_created_at ON lp_token_history (token, created_at);