SQL

CREATE TABLE wxapp_configs  (
  id TEXT PRIMARY KEY,
  workspace_id TEXT NOT NULL UNIQUE,
  slug TEXT NOT NULL UNIQUE,
  appid TEXT NOT NULL DEFAULT '',
  app_secret TEXT NOT NULL DEFAULT '',
  default_model TEXT NOT NULL DEFAULT '',
  permission_mode TEXT NOT NULL DEFAULT 'full',
  page_title 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'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
workspace_id TEXT Rename | Drop
slug TEXT Rename | Drop
appid TEXT Rename | Drop
app_secret TEXT Rename | Drop
default_model TEXT Rename | Drop
permission_mode TEXT Rename | Drop
page_title 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

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_wxapp_configs_workspace workspace_id SQL 
CREATE INDEX idx_wxapp_configs_workspace
ON wxapp_configs(workspace_id)
Drop
sqlite_autoindex_wxapp_configs_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_wxapp_configs_2 workspace_id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_wxapp_configs_3 slug ✓ SQL
-- no sql found --
 Drop