diff options
Diffstat (limited to 'res/sql/tables/orcl_add_constraints_defaults.sql')
-rw-r--r-- | res/sql/tables/orcl_add_constraints_defaults.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/res/sql/tables/orcl_add_constraints_defaults.sql b/res/sql/tables/orcl_add_constraints_defaults.sql new file mode 100644 index 0000000..4fd386c --- /dev/null +++ b/res/sql/tables/orcl_add_constraints_defaults.sql | |||
@@ -0,0 +1,36 @@ | |||
1 | -- constraints | ||
2 | |||
3 | ALTER TABLE USERS | ||
4 | ADD CONSTRAINT username_unique UNIQUE (USERNAME); | ||
5 | |||
6 | |||
7 | -- defaults | ||
8 | |||
9 | -- oracle can not use user defined functions (gen_uuid()) as default values :c | ||
10 | |||
11 | ALTER TABLE USERS | ||
12 | MODIFY UUID DEFAULT regexp_replace(rawtohex(sys_guid()) | ||
13 | , '([A-F0-9]{8})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{12})' | ||
14 | , '\1-\2-\3-\4-\5'); | ||
15 | |||
16 | ALTER TABLE BIDS | ||
17 | MODIFY UUID DEFAULT regexp_replace(rawtohex(sys_guid()) | ||
18 | , '([A-F0-9]{8})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{12})' | ||
19 | , '\1-\2-\3-\4-\5'); | ||
20 | |||
21 | ALTER TABLE CHARGES | ||
22 | MODIFY UUID DEFAULT regexp_replace(rawtohex(sys_guid()) | ||
23 | , '([A-F0-9]{8})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{12})' | ||
24 | , '\1-\2-\3-\4-\5'); | ||
25 | |||
26 | ALTER TABLE ITEMS | ||
27 | MODIFY UUID DEFAULT regexp_replace(rawtohex(sys_guid()) | ||
28 | , '([A-F0-9]{8})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{12})' | ||
29 | , '\1-\2-\3-\4-\5'); | ||
30 | |||
31 | ALTER TABLE TRANSACTIONS | ||
32 | MODIFY UUID DEFAULT regexp_replace(rawtohex(sys_guid()) | ||
33 | , '([A-F0-9]{8})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{12})' | ||
34 | , '\1-\2-\3-\4-\5'); | ||
35 | |||
36 | COMMIT; | ||