mirror of
https://github.com/matrix-org/sliding-sync.git
synced 2025-03-10 13:37:11 +00:00
12 lines
425 B
SQL
12 lines
425 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
ALTER TABLE IF EXISTS syncv3_device_data DROP COLUMN IF EXISTS id;
|
|
DROP SEQUENCE IF EXISTS syncv3_device_data_seq;
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
CREATE SEQUENCE IF NOT EXISTS syncv3_device_data_seq;
|
|
ALTER TABLE syncv3_device_data ADD COLUMN IF NOT EXISTS id BIGINT PRIMARY KEY NOT NULL DEFAULT nextval('syncv3_device_data_seq') ;
|
|
-- +goose StatementEnd
|