From 898e7ed11ab0958fcdaf65b99b33f7b04787630a Mon Sep 17 00:00:00 2001
From: Joris
Date: Sun, 24 Sep 2017 22:14:48 +0200
Subject: Bootstrap with GHCJS and reflex:

- setup login and logout,
- first draft of payment view.
---
 src/migrations/2.sql | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 src/migrations/2.sql

(limited to 'src/migrations')

diff --git a/src/migrations/2.sql b/src/migrations/2.sql
new file mode 100644
index 0000000..ec0d1b0
--- /dev/null
+++ b/src/migrations/2.sql
@@ -0,0 +1,23 @@
+BEGIN TRANSACTION;
+
+ALTER TABLE payment RENAME TO tmp_payment;
+
+CREATE TABLE IF NOT EXISTS "payment"(
+  "id" INTEGER PRIMARY KEY,
+  "user" INTEGER NOT NULL REFERENCES "user",
+  "name" VARCHAR NOT NULL,
+  "cost" INTEGER NOT NULL,
+  "date" DATE NOT NULL,
+  "frequency" VARCHAR NOT NULL,
+  "created_at" TIMESTAMP NOT NULL,
+  "edited_at" TIMESTAMP NULL,
+  "deleted_at" TIMESTAMP NULL
+);
+
+INSERT INTO payment(id, user, name, cost, date, frequency, created_at, edited_at, deleted_at)
+SELECT id, user_id, name, cost, date, frequency, created_at, edited_at, deleted_at
+FROM tmp_payment;
+
+DROP TABLE tmp_payment;
+
+COMMIT;
-- 
cgit v1.2.3


From 27e11b20b06f2f2dbfb56c0998a63169b4b8abc4 Mon Sep 17 00:00:00 2001
From: Joris
Date: Wed, 8 Nov 2017 23:47:26 +0100
Subject: Use a better project structure

---
 src/migrations/1.sql | 65 ----------------------------------------------------
 src/migrations/2.sql | 23 -------------------
 2 files changed, 88 deletions(-)
 delete mode 100644 src/migrations/1.sql
 delete mode 100644 src/migrations/2.sql

(limited to 'src/migrations')

diff --git a/src/migrations/1.sql b/src/migrations/1.sql
deleted file mode 100644
index d7c300e..0000000
--- a/src/migrations/1.sql
+++ /dev/null
@@ -1,65 +0,0 @@
-CREATE TABLE IF NOT EXISTS "user" (
-  "id" INTEGER PRIMARY KEY,
-  "creation" TIMESTAMP NOT NULL,
-  "email" VARCHAR NOT NULL,
-  "name" VARCHAR NOT NULL,
-  CONSTRAINT "uniq_user_email" UNIQUE ("email"),
-  CONSTRAINT "uniq_user_name" UNIQUE ("name")
-);
-
-CREATE TABLE IF NOT EXISTS "job" (
-  "id" INTEGER PRIMARY KEY,
-  "kind" VARCHAR NOT NULL,
-  "last_execution" TIMESTAMP NULL,
-  "last_check" TIMESTAMP NULL,
-  CONSTRAINT "uniq_job_kind" UNIQUE ("kind")
-);
-
-CREATE TABLE IF NOT EXISTS "sign_in"(
-  "id" INTEGER PRIMARY KEY,
-  "token" VARCHAR NOT NULL,
-  "creation" TIMESTAMP NOT NULL,
-  "email" VARCHAR NOT NULL,
-  "is_used" BOOLEAN NOT NULL,
-  CONSTRAINT "uniq_sign_in_token" UNIQUE ("token")
-);
-
-CREATE TABLE IF NOT EXISTS "payment"(
-  "id" INTEGER PRIMARY KEY,
-  "user_id" INTEGER NOT NULL REFERENCES "user",
-  "name" VARCHAR NOT NULL,
-  "cost" INTEGER NOT NULL,
-  "date" DATE NOT NULL,
-  "frequency" VARCHAR NOT NULL,
-  "created_at" TIMESTAMP NOT NULL,
-  "edited_at" TIMESTAMP NULL,
-  "deleted_at" TIMESTAMP NULL
-);
-
-CREATE TABLE IF NOT EXISTS "income"(
-  "id" INTEGER PRIMARY KEY,
-  "user_id" INTEGER NOT NULL REFERENCES "user",
-  "date" DATE NOT NULL,
-  "amount" INTEGERNOT NULL,
-  "created_at" TIMESTAMP NOT NULL,
-  "edited_at" TIMESTAMP NULL,
-  "deleted_at" TIMESTAMP NULL
-);
-
-CREATE TABLE IF NOT EXISTS "category"(
-  "id" INTEGER PRIMARY KEY,
-  "name" VARCHAR NOT NULL,
-  "color" VARCHAR NOT NULL,
-  "created_at" TIMESTAMP NOT NULL,
-  "edited_at" TIMESTAMP NULL,
-  "deleted_at" TIMESTAMP NULL
-);
-
-CREATE TABLE IF NOT EXISTS "payment_category"(
-  "id" INTEGER PRIMARY KEY,
-  "name" VARCHAR NOT NULL,
-  "category" INTEGER NOT NULL REFERENCES "category",
-  "created_at" TIMESTAMP NOT NULL,
-  "edited_at" TIMESTAMP NULL,
-  CONSTRAINT "uniq_payment_category_name" UNIQUE ("name")
-);
diff --git a/src/migrations/2.sql b/src/migrations/2.sql
deleted file mode 100644
index ec0d1b0..0000000
--- a/src/migrations/2.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-BEGIN TRANSACTION;
-
-ALTER TABLE payment RENAME TO tmp_payment;
-
-CREATE TABLE IF NOT EXISTS "payment"(
-  "id" INTEGER PRIMARY KEY,
-  "user" INTEGER NOT NULL REFERENCES "user",
-  "name" VARCHAR NOT NULL,
-  "cost" INTEGER NOT NULL,
-  "date" DATE NOT NULL,
-  "frequency" VARCHAR NOT NULL,
-  "created_at" TIMESTAMP NOT NULL,
-  "edited_at" TIMESTAMP NULL,
-  "deleted_at" TIMESTAMP NULL
-);
-
-INSERT INTO payment(id, user, name, cost, date, frequency, created_at, edited_at, deleted_at)
-SELECT id, user_id, name, cost, date, frequency, created_at, edited_at, deleted_at
-FROM tmp_payment;
-
-DROP TABLE tmp_payment;
-
-COMMIT;
-- 
cgit v1.2.3