SQL

CREATE TABLE workspaces  (
  id TEXT PRIMARY KEY,
  path TEXT NOT NULL UNIQUE,
  last_opened_at TEXT NOT NULL DEFAULT (datetime('now')),
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  owner_user_id TEXT NOT NULL DEFAULT '',
  team_id TEXT,
  visibility TEXT NOT NULL DEFAULT 'private'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
path TEXT Rename | Drop
last_opened_at TEXT Rename | Drop
created_at TEXT Rename | Drop
owner_user_id TEXT Rename | Drop
team_id TEXT ✓ Rename | Drop
visibility TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_workspaces_owner
  • owner_user_id
  • last_opened_at
 SQL 
CREATE INDEX idx_workspaces_owner
ON workspaces(owner_user_id, last_opened_at)
Drop
idx_workspaces_team_visibility
  • team_id
  • visibility
  • last_opened_at
 SQL 
CREATE INDEX idx_workspaces_team_visibility
ON workspaces(team_id, visibility, last_opened_at)
Drop
sqlite_autoindex_workspaces_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_workspaces_2 path ✓ SQL
-- no sql found --
 Drop