SQL

CREATE TABLE resources  (
  collection TEXT NOT NULL,
  id TEXT NOT NULL,
  data TEXT NOT NULL,
  created_at TEXT,
  updated_at TEXT,
  PRIMARY KEY (collection, id)
)

Columns

Column Data type Allow null Primary key Actions
collection TEXT ✓ read-only
id TEXT ✓ read-only
data TEXT read-only
created_at TEXT ✓ read-only
updated_at TEXT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_resources_1
  • collection
  • id
✓ SQL
-- no sql found --
read-only