· 8 years ago · Jul 26, 2018, 11:32 AM
1CREATE TABLE IF NOT EXISTS `user` (
2 `id` INTEGER PRIMARY KEY
3);
4
5CREATE TABLE IF NOT EXISTS `statistics` (
6 `user_id` INTEGER REFERENCES user (id),
7 `calls` SMALLINT UNSIGNED NOT NULL,
8 `updates` SMALLINT UNSIGNED NOT NULL
9);
10
11CREATE TABLE IF NOT EXISTS `restriction` (
12 `user_id` INTEGER REFERENCES user (id),
13 `name` TEXT NOT NULL,
14 `times` TINYINT UNSIGNED NOT NULL
15);