keii.dev
1CREATE TABLE IF NOT EXISTS `migrations` (
2 `id` INT PRIMARY KEY AUTO_INCREMENT,
3 `name` VARCHAR(16) NOT NULL
4);
5
6INSERT INTO
7 `migrations` (`name`)
8VALUES
9 ("0001_init");
10
11CREATE TABLE IF NOT EXISTS `users` (
12 `id` INT PRIMARY KEY AUTO_INCREMENT,
13 `username` VARCHAR(32) NOT NULL UNIQUE,
14 `email` VARCHAR(128) NOT NULL UNIQUE,
15 `updated_at` TIMESTAMP,
16 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
17);
18
19CREATE TABLE IF NOT EXISTS `user_auth_codes` (
20 `id` INT PRIMARY KEY AUTO_INCREMENT,
21 `user_id` INT NOT NULL,
22 `code` INT NOT NULL,
23 `used` BOOLEAN NOT NULL,
24 `updated_at` TIMESTAMP,
25 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
26);
27
28CREATE TABLE IF NOT EXISTS `user_sessions` (
29 `id` INT PRIMARY KEY AUTO_INCREMENT,
30 `user_id` INT NOT NULL,
31 `token` UUID NOT NULL UNIQUE,
32 `updated_at` TIMESTAMP,
33 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
34);
35
36CREATE TABLE IF NOT EXISTS `teams` (
37 `id` INT PRIMARY KEY AUTO_INCREMENT,
38 `name` VARCHAR(64) NOT NULL,
39 `slug` VARCHAR(64) NOT NULL,
40 `owner_id` INT NOT NULL,
41 `updated_at` TIMESTAMP,
42 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
43);
44
45CREATE TABLE IF NOT EXISTS `team_users` (
46 `id` INT PRIMARY KEY AUTO_INCREMENT,
47 `user_id` INT NOT NULL,
48 `team_id` INT NOT NULL,
49 `updated_at` TIMESTAMP,
50 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
51);
52
53CREATE TABLE IF NOT EXISTS `team_projects` (
54 `id` INT PRIMARY KEY AUTO_INCREMENT,
55 `name` VARCHAR(64) NOT NULL,
56 `slug` VARCHAR(64) NOT NULL,
57 `team_id` INT NOT NULL,
58 `updated_at` TIMESTAMP,
59 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
60);
61
62CREATE TABLE IF NOT EXISTS `cached_images` (
63 `id` INT PRIMARY KEY AUTO_INCREMENT,
64 `width` INT NOT NULL,
65 `height` INT NOT NULL,
66 `cache_file` VARCHAR(64) NOT NULL,
67 `directory` VARCHAR(64) NOT NULL,
68 `file` VARCHAR(64) NOT NULL,
69 `size_bytes` INT NOT NULL,
70 `team_project_id` INT NOT NULL,
71 `updated_at` TIMESTAMP,
72 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
73);