add tracking of clients

1 files changed, 12 insertions, 0 deletions

diff --git a/migrations/20170625140530_client.sql b/migrations/20170625140530_client.sql
new file mode 100644
index 0000000..b872526
--- /dev/null
+++ b/migrations/20170625140530_client.sql
@@ -0,0 +1,12 @@
+
+-- +goose Up
+-- SQL in section 'Up' is executed when this migration is applied
+CREATE TABLE clients (
+    key text PRIMARY KEY,
+    secret text,
+    name text
+);
+
+-- +goose Down
+-- SQL section 'Down' is executed when this migration is rolled back
+DROP TABLE clients;