forked from mathwizard1232/tipnyan
-
-
Notifications
You must be signed in to change notification settings - Fork 1
/
database.sql
21 lines (20 loc) · 862 Bytes
/
database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
CREATE TABLE IF NOT EXISTS `actions` (
`action` enum('accept','decline','history','info','register','tip','withdraw') NOT NULL,
`amount` decimal(17,8) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT NOW(),
`destination` varchar(34) DEFAULT NULL,
`message_id` varchar(10) NOT NULL,
`message_timestamp` timestamp NOT NULL,
`path` varchar(128) DEFAULT NULL,
`source` varchar(20) NOT NULL,
`status` enum('completed','declined','expired','failed','pending') NOT NULL,
`transaction_id` varchar(64) DEFAULT NULL,
PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `users` (
`address` varchar(34) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT NOW(),
`username` varchar(20) NOT NULL,
PRIMARY KEY (`username`),
UNIQUE KEY `address` (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;