Skip to content
Snippets Groups Projects
V2__account_number_sequence.sql 200 B
Newer Older
ALTER TABLE accounts
    ALTER COLUMN account_number SET DATA TYPE numeric(38, 0);
Filip Fabry's avatar
Filip Fabry committed
CREATE SEQUENCE "account_number_sequence"
    MINVALUE 1
    MAXVALUE 999999999
    INCREMENT BY 1
    START WITH 1;