Add E-R model and SQL bootstrap scripts

1 files changed, 26 insertions, 0 deletions

diff --git a/res/sql/tables/pg_add_constraints_defaults.sql b/res/sql/tables/pg_add_constraints_defaults.sql
new file mode 100644
index 0000000..df9250d
--- /dev/null
+++ b/res/sql/tables/pg_add_constraints_defaults.sql
@@ -0,0 +1,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;