13 lines
393 B
Plaintext
13 lines
393 B
Plaintext
-- Immutable ordered DbUp migration. Never rewrite after release.
|
|
create schema if not exists __schema__;
|
|
|
|
create table if not exists __schema__.__table__ (
|
|
id uuid primary key,
|
|
source_id text not null,
|
|
published_at timestamptz not null,
|
|
ingested_at timestamptz not null,
|
|
revision_no integer not null,
|
|
content_hash text not null,
|
|
unique (source_id, revision_no)
|
|
);
|