oficina / sheets Public

Download this file

1	CREATE TABLE `sheets` (`id` integer PRIMARY KEY AUTOINCREMENT,`title_sealed` blob,`created_by` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime);
2
3	CREATE INDEX `idx_sheets_deleted_at` ON `sheets`(`deleted_at`);
4
5	CREATE TABLE `tabs` (`id` integer PRIMARY KEY AUTOINCREMENT,`sheet_id` integer,`name_sealed` blob,`position` integer,`frozen_rows` integer,`frozen_cols` integer);
6
7	CREATE INDEX `idx_tabs_sheet_id` ON `tabs`(`sheet_id`);
8
9	CREATE TABLE `rows` (`id` integer PRIMARY KEY AUTOINCREMENT,`tab_id` integer,`position` integer,`height` integer);
10
11	CREATE UNIQUE INDEX `idx_row_tab_pos` ON `rows`(`tab_id`,`position`);
12
13	CREATE TABLE `cols` (`id` integer PRIMARY KEY AUTOINCREMENT,`tab_id` integer,`position` integer,`width` integer);
14
15	CREATE UNIQUE INDEX `idx_col_tab_pos` ON `cols`(`tab_id`,`position`);
16
17	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`));
18
19	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);
20
21	CREATE UNIQUE INDEX `idx_formats_digest` ON `formats`(`digest`);
22
23	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);
24
25	CREATE INDEX `idx_events_tab_id` ON `events`(`tab_id`);
26
27	CREATE INDEX `idx_events_kind` ON `events`(`kind`);
28
29