From e6468b012d5b33dd16992652da57f11dd5a6e82f Mon Sep 17 00:00:00 2001
From: Jokler <jokler@protonmail.com>
Date: Sun, 21 Jun 2020 06:37:46 +0200
Subject: Initial commit

---
 migrations/2020-06-07-161450_create_transaction/up.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 migrations/2020-06-07-161450_create_transaction/up.sql

(limited to 'migrations/2020-06-07-161450_create_transaction/up.sql')

diff --git a/migrations/2020-06-07-161450_create_transaction/up.sql b/migrations/2020-06-07-161450_create_transaction/up.sql
new file mode 100644
index 0000000..fb81016
--- /dev/null
+++ b/migrations/2020-06-07-161450_create_transaction/up.sql
@@ -0,0 +1,12 @@
+CREATE TABLE transactions (
+    id SERIAL NOT NULL PRIMARY KEY,
+    `date` timestamp NOT NULL DEFAULT current_timestamp(),
+    sender bigint UNSIGNED NOT NULL,
+    receiver bigint UNSIGNED NOT NULL,
+    amount bigint UNSIGNED NOT NULL,
+    sender_balance bigint UNSIGNED NOT NULL,
+    receiver_balance bigint UNSIGNED NOT NULL,
+    purpose varchar(70) NOT NULL,
+    CONSTRAINT fk_sender_id FOREIGN KEY (sender) REFERENCES users (id),
+    CONSTRAINT fk_receiver_id FOREIGN KEY (receiver) REFERENCES users (id)
+);
-- 
cgit v1.2.3-70-g09d2

