Query

mira.db — rooms

SQL

CREATE TABLE rooms  (
  id         TEXT PRIMARY KEY,
  number     INTEGER NOT NULL UNIQUE,
  capacity   INTEGER NOT NULL DEFAULT 2,
  created_at INTEGER NOT NULL DEFAULT (unixepoch())
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
number INTEGER Rename | Drop
capacity INTEGER Rename | Drop
created_at INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_rooms_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_rooms_2 number ✓ SQL
-- no sql found --
 Drop