Add balancing capabilities

If payment are too unbalanced, it’s easier to make a transfer.

1 files changed, 9 insertions, 0 deletions

diff --git a/src/db/migrations/07-create-balancing-table.sql b/src/db/migrations/07-create-balancing-table.sql
new file mode 100644
index 0000000..148657e
--- /dev/null
+++ b/src/db/migrations/07-create-balancing-table.sql
@@ -0,0 +1,9 @@
+CREATE TABLE IF NOT EXISTS "balancing"(
+  "id" INTEGER PRIMARY KEY,
+  "source" INTEGER NOT NULL REFERENCES "users",
+  "destination" INTEGER NOT NULL REFERENCES "users",
+  "amount" INTEGER NOT NULL,
+  "created_at" TEXT NULL DEFAULT (datetime('now')),
+  "updated_at" TEXT NULL,
+  "deleted_at" TEXT NULL
+) STRICT;