summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-10-11 14:03:50 +0200
committerYorhel <git@yorhel.nl>2015-10-12 19:35:18 +0200
commit1a6dd0160a75bc83390912dfb2635cd5664ce9ee (patch)
treea8ed2161296205b2f9c8cbee27b11554e7c60a48 /lib
parent15382265b39f045fc5f20e9e676b24941da6bd63 (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