Query

cool-keeper.db — organizations

SQL

CREATE TABLE `organizations`  (
  `id` text PRIMARY KEY NOT NULL,
  `vcs_provider` text NOT NULL,
  `vcs_org_identifier` text NOT NULL,
  `display_name` text,
  `created_at` text DEFAULT (datetime('now')) NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
vcs_provider TEXT Rename | Drop
vcs_org_identifier TEXT Rename | Drop
display_name TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
organizations_vcs_provider_vcs_org_identifier_unique
  • vcs_provider
  • vcs_org_identifier
 ✓ SQL 
CREATE UNIQUE INDEX `organizations_vcs_provider_vcs_org_identifier_unique`
ON `organizations` (`vcs_provider`,`vcs_org_identifier`)
Drop
sqlite_autoindex_organizations_1 id ✓ SQL
-- no sql found --
 Drop