SQL

CREATE TABLE settings  (
  id INTEGER NOT NULL,
  room VARCHAR NOT NULL,
  adminpass VARCHAR,
  lock_leader BOOLEAN,
  safe_mode BOOLEAN,
  moderation BOOLEAN,
  roundrobin BOOLEAN,
  start_key INTEGER,
  PRIMARY KEY (id),
  UNIQUE (room)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
room VARCHAR Rename | Drop
adminpass VARCHAR ✓ Rename | Drop
lock_leader BOOLEAN ✓ Rename | Drop
safe_mode BOOLEAN ✓ Rename | Drop
moderation BOOLEAN ✓ Rename | Drop
roundrobin BOOLEAN ✓ Rename | Drop
start_key INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_settings_1 room ✓ SQL
-- no sql found --
 Drop