SHA256
17 lines
488 B
PL/PgSQL
17 lines
488 B
PL/PgSQL
BEGIN;
|
|
|
|
ALTER TABLE blocks
|
|
DROP CONSTRAINT IF EXISTS blocks_login_fkey;
|
|
|
|
ALTER TABLE blocks
|
|
ADD CONSTRAINT blocks_login_fkey
|
|
FOREIGN KEY (login) REFERENCES solana_user_pda_current(normalized_login);
|
|
|
|
INSERT INTO db_schema_version (id, schema_version, updated_at_ms)
|
|
VALUES (1, 7, CAST(EXTRACT(EPOCH FROM clock_timestamp()) * 1000 AS BIGINT))
|
|
ON CONFLICT (id) DO UPDATE SET
|
|
schema_version = EXCLUDED.schema_version,
|
|
updated_at_ms = EXCLUDED.updated_at_ms;
|
|
|
|
COMMIT;
|