12 lines
312 B
SQL
12 lines
312 B
SQL
|
|
CREATE TABLE contract_t (
|
|
id serial not null primary key
|
|
,supplier varchar(256) not null
|
|
,content varchar(256) not null
|
|
,identifier varchar(256) not null
|
|
,unique(supplier, content)
|
|
);
|
|
|
|
GRANT SELECT, INSERT, UPDATE ON contract_t TO hv2;
|
|
GRANT SELECT, UPDATE ON contract_t_id_seq TO hv2;
|