diff options
author | Paul Duncan <pabs@pablotron.org> | 2016-03-06 23:12:06 -0500 |
---|---|---|
committer | Paul Duncan <pabs@pablotron.org> | 2016-03-06 23:12:06 -0500 |
commit | f0f87c439037715cac407004e2220c678d96757a (patch) | |
tree | 40e9330d709f2b33f6e95fa7b87ec6b3990e3c17 /src/guff/database-updater.cr | |
parent | 70e294e312710eb1e89c9cacd09a830e05d4bbe9 (diff) | |
download | old-guff-f0f87c439037715cac407004e2220c678d96757a.tar.bz2 old-guff-f0f87c439037715cac407004e2220c678d96757a.zip |
chaos!
Diffstat (limited to 'src/guff/database-updater.cr')
-rw-r--r-- | src/guff/database-updater.cr | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/src/guff/database-updater.cr b/src/guff/database-updater.cr index c1d4188..daf77fd 100644 --- a/src/guff/database-updater.cr +++ b/src/guff/database-updater.cr @@ -86,7 +86,7 @@ module Guff CREATE INDEX in_posts_slug ON posts(slug) }], }, { - id: "2-create-indices", + id: "2-create-tags", backup: false, sql: [%{ @@ -96,6 +96,20 @@ module Guff ) }, %{ CREATE INDEX in_tags_name ON tags(name) + }, %{ + CREATE TABLE post_tags ( + tag_id INTEGER NOT NULL + REFERENCES tags(tag_id), + + post_id INTEGER NOT NULL + REFERENCES posts(post_id), + + UNIQUE(tag_id, post_id) + ) + }, %{ + CREATE INDEX in_post_tags_tag_id ON post_tags(tag_id) + }, %{ + CREATE INDEX in_post_tags_post_id ON post_tags(post_id) }], }, { id: "3-create-domains", |