hv2-all-in-one/schema/changes01.sql

7 lines
360 B
MySQL
Raw Permalink Normal View History

2021-11-08 21:05:24 +01:00
alter table premise_t add column account integer;
alter table premise_t add constraint fk_premise_t_account foreign key (account) references account_t(id);
alter table premise_t add constraint uk_premise_t_account unique(account);
alter table account_entry_t add column document_no integer unique;
create sequence unique_number_s start with 1 increment by 1;