SQL

CREATE TABLE session_profiles  (
  profile_id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  description TEXT NOT NULL,
  comment TEXT NOT NULL,
  data_schema_version INTEGER NOT NULL DEFAULT 1,
  data_json TEXT NOT NULL,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
profile_id TEXT Rename | Drop
name TEXT Rename | Drop
description TEXT Rename | Drop
comment TEXT Rename | Drop
data_schema_version INTEGER Rename | Drop
data_json TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_session_profiles_1 profile_id SQL
-- no sql found --
Drop