Download this file
| 1 | ALTER TABLE `members` ADD `team_role` text; |
| 2 | |
| 3 | 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); |
| 4 | |
| 5 | CREATE INDEX `idx_grants_sheet_id` ON `grants`(`sheet_id`); |
| 6 | |
| 7 | CREATE UNIQUE INDEX `idx_grant_sheet_member` ON `grants`(`sheet_id`,`member_id`); |
| 8 | |
| 9 | |
amadan