forked from bertvandepoel/tabby
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdb.sql
More file actions
73 lines (65 loc) · 2.08 KB
/
db.sql
File metadata and controls
73 lines (65 loc) · 2.08 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
CREATE TABLE `users` (
`email` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
`iban` varchar(34) NOT NULL,
`reminddate` date NULL,
PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `tokens` (
`email` varchar(50) NOT NULL,
`token` varchar(25) NOT NULL,
PRIMARY KEY (`email`),
UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `activities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL,
`user` varchar(50) NOT NULL,
`date` date NOT NULL,
PRIMARY KEY (`id`),
KEY `user` (`user`),
FOREIGN KEY (`user`) REFERENCES users(email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `debtors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`user` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `user` (`user`),
KEY `email` (`email`),
FOREIGN KEY (`user`) REFERENCES users(email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `credits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`debtor` int(11) NOT NULL,
`comment` varchar(250) NOT NULL,
`amount` int(8) NOT NULL,
`date` date NOT NULL,
PRIMARY KEY (`id`),
KEY `debtor` (`debtor`),
FOREIGN KEY (`debtor`) REFERENCES debtors(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `debts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`activity` int(11) NOT NULL,
`debtor` int(11) NOT NULL,
`comment` varchar(250) DEFAULT NULL,
`amount` int(8) NOT NULL,
PRIMARY KEY (`id`),
KEY `debtor` (`debtor`),
KEY `activity` (`activity`),
FOREIGN KEY (`debtor`) REFERENCES debtors(id),
FOREIGN KEY (`activity`) REFERENCES activities(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `pending_users` (
`email` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
`iban` varchar(34) NOT NULL,
`confirmation` varchar(25) NOT NULL,
`datetime` datetime NOT NULL,
PRIMARY KEY (`email`),
UNIQUE KEY `confirmation` (`confirmation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;