home / bibliothek

wish

0 rows where media_id = 20

✎ View and edit SQL

This data as json

0 records

CREATE TABLE wish (
  id         INTEGER PRIMARY KEY,
  uuid       TEXT NOT NULL UNIQUE DEFAULT (lower(hex(randomblob(16)))),
  media_id   INTEGER NOT NULL REFERENCES media(id),
  note       TEXT,
  created_at TEXT NOT NULL DEFAULT (date('now','localtime')),
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  deleted_at TEXT
);
CREATE INDEX ix_wish_media ON wish(media_id);
Powered by Datasette · Queries took 5.022ms