oficina / sheets 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 `cells` (`tab_id` integer,`row_id` integer,`col_id` integer,`input_sealed` blob,`cached_sealed` blob,`input_version` integer,`cache_version` integer,`format_id` integer,`updated_by` integer,`updated_at` datetime,PRIMARY KEY (`tab_id`,`row_id`,`col_id`));
5
6	CREATE TABLE `cols` (`id` integer PRIMARY KEY AUTOINCREMENT,`tab_id` integer,`position` integer,`width` integer);
7
8	CREATE TABLE `comments` (`id` integer PRIMARY KEY AUTOINCREMENT,`tab_id` integer,`row_id` integer,`col_id` integer,`author_id` integer,`body_sealed` blob,`created_at` datetime,`resolved_at` datetime,`resolved_by` integer);
9
10	CREATE TABLE `events` (`id` integer PRIMARY KEY AUTOINCREMENT,`kind` text,`tab_id` integer,`actor_id` integer,`payload_sealed` blob,`trigger_id` integer,`derived_count` integer,`created_at` datetime);
11
12	CREATE TABLE `formats` (`id` integer PRIMARY KEY AUTOINCREMENT,`digest` text,`number_fmt` text,`bold` numeric,`italic` numeric,`fill_intent_h` real,`fill_intent_c` real,`fill_hex` text,`align` text, `ink_hex` text, `ink_intent_h` real, `ink_intent_c` real);
13
14	CREATE TABLE `grants` (`id` integer PRIMARY KEY AUTOINCREMENT,`sheet_id` integer,`member_id` integer,`role` text,`granted_by` integer,`created_at` datetime,`updated_at` datetime);
15
16	CREATE TABLE `members` (`id` integer PRIMARY KEY AUTOINCREMENT,`address` text,`created_at` datetime, `team_role` text);
17
18	CREATE TABLE `rows` (`id` integer PRIMARY KEY AUTOINCREMENT,`tab_id` integer,`position` integer,`height` integer);
19
20	CREATE TABLE `share_links` (`id` integer PRIMARY KEY AUTOINCREMENT,`sheet_id` integer,`token_hash` text,`role` text,`created_by` integer,`created_at` datetime,`revoked_at` datetime);
21
22	CREATE TABLE `sheets` (`id` integer PRIMARY KEY AUTOINCREMENT,`title_sealed` blob,`created_by` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime, `filling_since` datetime);
23
24	CREATE TABLE `tab_views` (`id` integer PRIMARY KEY AUTOINCREMENT,`tab_id` integer,`spec_sealed` blob,`updated_by` integer,`updated_at` datetime);
25
26	CREATE TABLE `tabs` (`id` integer PRIMARY KEY AUTOINCREMENT,`sheet_id` integer,`name_sealed` blob,`position` integer,`frozen_rows` integer,`frozen_cols` integer, `content_version` integer NOT NULL DEFAULT 0);
27
28	CREATE UNIQUE INDEX `idx_col_tab_pos` ON `cols`(`tab_id`,`position`);
29
30	CREATE INDEX `idx_comments_tab_id` ON `comments`(`tab_id`);
31
32	CREATE INDEX `idx_events_kind` ON `events`(`kind`);
33
34	CREATE INDEX `idx_events_tab_id` ON `events`(`tab_id`);
35
36	CREATE UNIQUE INDEX `idx_formats_digest` ON `formats`(`digest`);
37
38	CREATE UNIQUE INDEX `idx_grant_sheet_member` ON `grants`(`sheet_id`,`member_id`);
39
40	CREATE INDEX `idx_grants_sheet_id` ON `grants`(`sheet_id`);
41
42	CREATE UNIQUE INDEX `idx_members_address` ON `members`(`address`);
43
44	CREATE UNIQUE INDEX `idx_row_tab_pos` ON `rows`(`tab_id`,`position`);
45
46	CREATE INDEX `idx_share_links_sheet_id` ON `share_links`(`sheet_id`);
47
48	CREATE UNIQUE INDEX `idx_share_links_token_hash` ON `share_links`(`token_hash`);
49
50	CREATE INDEX `idx_sheets_deleted_at` ON `sheets`(`deleted_at`);
51
52	CREATE INDEX `idx_sheets_filling_since` ON `sheets`(`filling_since`);
53
54	CREATE UNIQUE INDEX `idx_tab_views_tab_id` ON `tab_views`(`tab_id`);
55
56	CREATE INDEX `idx_tabs_sheet_id` ON `tabs`(`sheet_id`);
57
58