Files
SHiNE-server/SHiNE-server/shine-server-db/src/main/resources/postgres/migration_v34.sql
T

13 lines
636 B
PL/PgSQL

-- SHiNE v34. Отдельный checkpoint Arweave сертификатов, не смешивать с блоками.
BEGIN;
CREATE TABLE IF NOT EXISTS free_registration_arweave_sync_state (
id SMALLINT PRIMARY KEY CHECK (id=1),
last_block_height BIGINT NOT NULL DEFAULT 0 CHECK (last_block_height>=0),
updated_at_ms BIGINT NOT NULL DEFAULT 0
);
INSERT INTO free_registration_arweave_sync_state (id,last_block_height,updated_at_ms)
VALUES (1,0,0) ON CONFLICT (id) DO NOTHING;
UPDATE db_schema_version SET schema_version=34,
updated_at_ms=CAST(EXTRACT(EPOCH FROM clock_timestamp())*1000 AS BIGINT) WHERE id=1;
COMMIT;