SQL

CREATE TABLE h5_pages  (
  id TEXT PRIMARY KEY,
  workspace_id TEXT NOT NULL UNIQUE,
  slug TEXT NOT NULL UNIQUE,
  app_secrets TEXT NOT NULL DEFAULT '{}',
  default_model TEXT NOT NULL DEFAULT '',
  permission_mode TEXT NOT NULL DEFAULT 'full' CHECK (permission_mode IN ('confirm', 'full')),
  page_title TEXT NOT NULL DEFAULT '',
  assistant_name TEXT NOT NULL DEFAULT '',
  description TEXT NOT NULL DEFAULT '',
  welcome_message TEXT NOT NULL DEFAULT '',
  icon_emoji TEXT NOT NULL DEFAULT '',
  enabled INTEGER NOT NULL DEFAULT 1,
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  updated_at TEXT NOT NULL DEFAULT (datetime('now')),
  FOREIGN KEY (workspace_id) REFERENCES workspaces(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
workspace_id TEXT Rename | Drop
slug TEXT Rename | Drop
app_secrets TEXT Rename | Drop
default_model TEXT Rename | Drop
permission_mode TEXT Rename | Drop
page_title TEXT Rename | Drop
assistant_name TEXT Rename | Drop
description TEXT Rename | Drop
welcome_message TEXT Rename | Drop
icon_emoji TEXT Rename | Drop
enabled INTEGER Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

Foreign Keys

Column Destination
workspace_id workspaces.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_h5_pages_slug slug ✓ SQL 
CREATE UNIQUE INDEX idx_h5_pages_slug
ON h5_pages(slug)
Drop
idx_h5_pages_workspace workspace_id SQL 
CREATE INDEX idx_h5_pages_workspace
ON h5_pages(workspace_id)
Drop
sqlite_autoindex_h5_pages_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_h5_pages_2 workspace_id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_h5_pages_3 slug ✓ SQL
-- no sql found --
 Drop