blob: c4724f8ad3a102796a486419d015cad0e0eb2b84 (
plain) (
blame)
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
|
CREATE TABLE `profiles` (
`profile_id` INTEGER PRIMARY KEY,
`profile_path` VARCHAR(255) NOT NULL
);
CREATE UNIQUE INDEX `profile_by_path` ON `profiles`(`profile_path`);
CREATE TABLE `games` (
`game_id` INTEGER PRIMARY KEY,
`steam_appid` INTEGER NOT NULL,
`color` VARCHAR(255) NOT NULL
);
CREATE UNIQUE INDEX `game_by_appid` ON `games`(`steam_appid`);
CREATE TABLE `achievements` (
`achievement_id` INTEGER PRIMARY KEY,
`game_id` INTEGER NOT NULL,
`title` VARCHAR(255) NOT NULL
);
CREATE TABLE `dids` (
`achievement_id` INTEGER NOT NULL,
`profile_id` INTEGER NOT NULL,
`achieved_at` DATETIME NOT NULL,
PRIMARY KEY (`achievement_id`, `profile_id`)
) WITHOUT ROWID;
CREATE TABLE `images` (
`image_id` INTEGER PRIMARY KEY,
`game_id` INTEGER NOT NULL,
`filename` VARCHAR(255) NOT NULL
);
|
