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 |
|
✓ | SQL | read-only |