SQL

CREATE TABLE feedback  (
  id TEXT NOT NULL,
  user_id TEXT,
  version BIGINT,
  type TEXT,
  data JSON,
  meta JSON,
  snapshot JSON,
  created_at BIGINT NOT NULL,
  updated_at BIGINT NOT NULL,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT Rename | Drop
user_id TEXT Rename | Drop
version BIGINT Rename | Drop
type TEXT Rename | Drop
data JSON Rename | Drop
meta JSON Rename | Drop
snapshot JSON Rename | Drop
created_at BIGINT Rename | Drop
updated_at BIGINT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_feedback_1 id SQL
-- no sql found --
Drop