oficina / slides Public

Download this file

1	-- Generated by rastrillo migration generate; DO NOT EDIT.
2	-- The schema every migration in this directory adds up to.
3
4	CREATE TABLE `agents` (`id` integer PRIMARY KEY AUTOINCREMENT,`name` text,`operator_id` integer,`token_hash` text,`created_at` datetime,`revoked_at` datetime);
5
6	CREATE TABLE `asset_uploads` (`id` integer PRIMARY KEY AUTOINCREMENT,`deck_id` integer,`actor` text,`staging_key` text,`object_key` text,`declared_hash` text,`content_type` text,`size` integer,`created_at` datetime,`consumed_at` datetime);
7
8	CREATE TABLE `deck_assets` (`id` integer PRIMARY KEY AUTOINCREMENT,`deck_id` integer,`ref` text,`created_at` datetime);
9
10	CREATE TABLE `deck_grants` (`id` integer PRIMARY KEY AUTOINCREMENT,`deck_id` integer,`user_id` integer,`actor` text,`created_at` datetime);
11
12	CREATE TABLE `deck_snapshots` (`id` integer PRIMARY KEY AUTOINCREMENT,`deck_id` integer,`seq` integer,`bytes` blob,`created_at` datetime);
13
14	CREATE TABLE `deck_updates` (`id` integer PRIMARY KEY AUTOINCREMENT,`deck_id` integer,`seq` integer,`actor` text,`bytes` blob,`created_at` datetime);
15
16	CREATE TABLE `decks` (`id` integer PRIMARY KEY AUTOINCREMENT,`sqid` text,`title` text,`owner_id` integer,`rung` text,`theme` text,`seq` integer,`created_at` datetime,`updated_at` datetime);
17
18	CREATE TABLE `presentations` (`id` integer PRIMARY KEY AUTOINCREMENT,`sqid` text,`deck_id` integer,`actor` text,`slide` integer,`blackout` numeric,`code` text,`remote_token_hash` text,`started_at` datetime,`ended_at` datetime);
19
20	CREATE TABLE `share_links` (`id` integer PRIMARY KEY AUTOINCREMENT,`deck_id` integer,`token_hash` text,`actor` text,`views` integer,`created_at` datetime,`revoked_at` datetime);
21
22	CREATE TABLE `users` (`id` integer PRIMARY KEY AUTOINCREMENT,`email` text,`name` text,`colour` text,`created_at` datetime);
23
24	CREATE INDEX `idx_agents_operator_id` ON `agents`(`operator_id`);
25
26	CREATE UNIQUE INDEX `idx_agents_token_hash` ON `agents`(`token_hash`);
27
28	CREATE INDEX `idx_asset_uploads_deck_id` ON `asset_uploads`(`deck_id`);
29
30	CREATE UNIQUE INDEX `idx_asset_uploads_staging_key` ON `asset_uploads`(`staging_key`);
31
32	CREATE UNIQUE INDEX `idx_deck_assets_deck_ref` ON `deck_assets`(`deck_id`,`ref`);
33
34	CREATE INDEX `idx_deck_grants_deck_id` ON `deck_grants`(`deck_id`);
35
36	CREATE INDEX `idx_deck_grants_user_id` ON `deck_grants`(`user_id`);
37
38	CREATE INDEX `idx_deck_snapshots_deck_id` ON `deck_snapshots`(`deck_id`);
39
40	CREATE UNIQUE INDEX `idx_deck_updates_deck_seq` ON `deck_updates`(`deck_id`,`seq`);
41
42	CREATE INDEX `idx_decks_owner_id` ON `decks`(`owner_id`);
43
44	CREATE UNIQUE INDEX `idx_decks_sqid` ON `decks`(`sqid`);
45
46	CREATE INDEX `idx_presentations_code` ON `presentations`(`code`);
47
48	CREATE INDEX `idx_presentations_deck_id` ON `presentations`(`deck_id`);
49
50	CREATE UNIQUE INDEX `idx_presentations_sqid` ON `presentations`(`sqid`);
51
52	CREATE INDEX `idx_share_links_deck_id` ON `share_links`(`deck_id`);
53
54	CREATE UNIQUE INDEX `idx_share_links_token_hash` ON `share_links`(`token_hash`);
55
56	CREATE UNIQUE INDEX `idx_users_email` ON `users`(`email`);
57
58