oficina / slides Public

Download this file

1	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);
2
3	CREATE INDEX `idx_decks_owner_id` ON `decks`(`owner_id`);
4
5	CREATE UNIQUE INDEX `idx_decks_sqid` ON `decks`(`sqid`);
6
7	CREATE TABLE `deck_updates` (`id` integer PRIMARY KEY AUTOINCREMENT,`deck_id` integer,`seq` integer,`actor` text,`bytes` blob,`created_at` datetime);
8
9	CREATE UNIQUE INDEX `idx_deck_updates_deck_seq` ON `deck_updates`(`deck_id`,`seq`);
10
11	CREATE TABLE `deck_grants` (`id` integer PRIMARY KEY AUTOINCREMENT,`deck_id` integer,`user_id` integer,`actor` text,`created_at` datetime);
12
13	CREATE INDEX `idx_deck_grants_user_id` ON `deck_grants`(`user_id`);
14
15	CREATE INDEX `idx_deck_grants_deck_id` ON `deck_grants`(`deck_id`);
16
17