Add database migrations for GitHub Commit plugin

Create a table to store mappings between channels and repo URLs.

We don't have any database configuration set up or anything to run the
migrations yet, but this gets the schema defined.

2 files changed, 6 insertions, 0 deletions

diff --git a/db/migrations/20170731002034_create_github_commit_plugin_channel_repo_urls.down.sql b/db/migrations/20170731002034_create_github_commit_plugin_channel_repo_urls.down.sql
new file mode 100644
index 0000000..82bc736
--- /dev/null
+++ b/db/migrations/20170731002034_create_github_commit_plugin_channel_repo_urls.down.sql
@@ -0,0 +1 @@
+DROP TABLE plugin_github_commit_channel_repo_urls;
diff --git a/db/migrations/20170731002034_create_github_commit_plugin_channel_repo_urls.up.sql b/db/migrations/20170731002034_create_github_commit_plugin_channel_repo_urls.up.sql
new file mode 100644
index 0000000..9853357
--- /dev/null
+++ b/db/migrations/20170731002034_create_github_commit_plugin_channel_repo_urls.up.sql
@@ -0,0 +1,5 @@
+CREATE TABLE IF NOT EXISTS plugin_github_commit_channel_repo_urls (
+    id       INTEGER PRIMARY KEY,
+    channel  TEXT    NOT NULL,
+    repo_url TEXT    NOT NULL
+);