diff options
author | Yorhel <git@yorhel.nl> | 2015-10-11 14:03:50 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-10-12 19:35:18 +0200 |
commit | 1a6dd0160a75bc83390912dfb2635cd5664ce9ee (patch) | |
tree | a8ed2161296205b2f9c8cbee27b11554e7c60a48 /lib | |
parent | 15382265b39f045fc5f20e9e676b24941da6bd63 (diff) |
SQL: Split constraints/indices/triggers in new file + use idempotent SQL
Turning the foreign key references into idempotent statements required
adding the name for each reference in the query. I used the names of the
production database, but since the names are autogenerated at creation
time, it's possible that they have other names if the database has been
created slightly differently.
Using explicit names for everything and having idempotent SQL statements
is rather useful when making nontrivial modifications to the database
schema. Which is something I consider doing.
Diffstat (limited to 'lib')
0 files changed, 0 insertions, 0 deletions