SQL

CREATE TABLE skills  (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  description TEXT NOT NULL DEFAULT '',
  scope TEXT NOT NULL DEFAULT 'workspace',
  enabled INTEGER NOT NULL DEFAULT 1,
  content TEXT NOT NULL DEFAULT '',
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  updated_at TEXT NOT NULL DEFAULT (datetime('now')),
  user_id TEXT NOT NULL DEFAULT ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
description TEXT Rename | Drop
scope TEXT Rename | Drop
enabled INTEGER Rename | Drop
content TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
user_id TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_skills_user
  • user_id
  • updated_at
 SQL 
CREATE INDEX idx_skills_user
ON skills(user_id, updated_at)
Drop
sqlite_autoindex_skills_1 id ✓ SQL
-- no sql found --
 Drop