SQL

CREATE TABLE video  (
  id INTEGER NOT NULL,
  room VARCHAR NOT NULL,
  video_id VARCHAR NOT NULL,
  title VARCHAR NOT NULL,
  duration INTEGER,
  added_by_key VARCHAR NOT NULL,
  added_ts DATETIME NOT NULL,
  lastplayed DATETIME,
  position INTEGER NOT NULL,
  pending BOOLEAN,
  status VARCHAR(11) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (position)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
room VARCHAR Rename | Drop
video_id VARCHAR Rename | Drop
title VARCHAR Rename | Drop
duration INTEGER ✓ Rename | Drop
added_by_key VARCHAR Rename | Drop
added_ts DATETIME Rename | Drop
lastplayed DATETIME ✓ Rename | Drop
position INTEGER Rename | Drop
pending BOOLEAN ✓ Rename | Drop
status VARCHAR(11) Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_video_1 position ✓ SQL
-- no sql found --
 Drop