17 lines
441 B
SQL
17 lines
441 B
SQL
CREATE TABLE schema_version (
|
|
version INTEGER NOT NULL
|
|
);
|
|
CREATE TABLE tokens (
|
|
id INTEGER PRIMARY KEY,
|
|
data TEXT NOT NULL
|
|
);
|
|
CREATE TABLE agents (
|
|
id INTEGER PRIMARY KEY,
|
|
data TEXT NOT NULL
|
|
);
|
|
CREATE TABLE contracts (
|
|
id INTEGER PRIMARY KEY,
|
|
data TEXT NOT NULL
|
|
);
|
|
CREATE UNIQUE INDEX contracts_data_id ON contracts (json_extract(data, '$.id'));
|
|
CREATE INDEX contracts_data_fulfilled ON contracts (json_extract(data, '$.fulfilled'));
|