SQL

CREATE TABLE "settings"  (
  "key"	TEXT NOT NULL,
  "value"	TEXT NOT NULL DEFAULT '',
  "loadOnStartup"	boolean NOT NULL default false,
  PRIMARY KEY("key")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
key TEXT Rename | Drop
value TEXT Rename | Drop
loadOnStartup boolean Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_settings_1 key SQL
-- no sql found --
Drop