From d1bdc16c9b1ad9a2b17b90a998640ebad1c02f9a Mon Sep 17 00:00:00 2001
From: Teddy Wing
Date: Mon, 31 Jul 2017 01:26:12 +0200
Subject: 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.
---
 ...0731002034_create_github_commit_plugin_channel_repo_urls.down.sql | 1 +
 ...170731002034_create_github_commit_plugin_channel_repo_urls.up.sql | 5 +++++
 2 files changed, 6 insertions(+)
 create mode 100644 db/migrations/20170731002034_create_github_commit_plugin_channel_repo_urls.down.sql
 create mode 100644 db/migrations/20170731002034_create_github_commit_plugin_channel_repo_urls.up.sql

(limited to 'db')

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
+);
-- 
cgit v1.2.3