res/sql/tables/pg_add_constraints_defaults.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

-- constraints

ALTER TABLE USERS
ADD CONSTRAINT username_unique UNIQUE (USERNAME);


-- defaults

CREATE EXTENSION "uuid-ossp";

ALTER TABLE USERS
ALTER COLUMN UUID SET DEFAULT gen_uuid();

ALTER TABLE BIDS
ALTER COLUMN UUID SET DEFAULT gen_uuid();

ALTER TABLE CHARGES
ALTER COLUMN UUID SET DEFAULT gen_uuid();

ALTER TABLE ITEMS
ALTER COLUMN UUID SET DEFAULT gen_uuid();

ALTER TABLE TRANSACTIONS
ALTER COLUMN UUID SET DEFAULT gen_uuid();

COMMIT;