event tables

1 files changed, 50 insertions, 0 deletions

diff --git a/bin/db.php b/bin/db.php
index 951c0b3..7f3f344 100644
--- a/bin/db.php
+++ b/bin/db.php
@@ -123,6 +123,56 @@ DB::query(<<<SQL
 SQL);
 
 DB::query(<<<SQL
+  create table if not exists "events_train_units" (
+    "id" bigserial primary key,
+
+    "event_id" bigint not null,
+    constraint "relation_event"
+      foreign key ("event_id") references events("id") on delete cascade,
+
+    "amount" bigint not null,
+    "type" character varying(255) not null,
+
+    "created_at" timestamp(0) not null default current_timestamp,
+    "updated_at" timestamp(0) not null default current_timestamp
+  );
+SQL);
+
+DB::query(<<<SQL
+  create table if not exists "events_send_units" (
+    "id" bigserial primary key,
+
+    "event_id" bigint not null,
+    constraint "relation_event"
+      foreign key ("event_id") references events("id") on delete cascade,
+
+    "type" character varying(255) not null,
+    "amount" bigint not null,
+    "unit" character varying(255) not null,
+    "is_canceled" boolean not null default false,
+
+    "source" bigint not null,
+    constraint "relation_village_source"
+      foreign key ("source") references villages("id"),
+
+    "destination" bigint not null,
+    constraint "relation_village_destination"
+      foreign key ("destination") references villages("id"),
+
+    "home" bigint,
+    constraint "relation_village_home"
+      foreign key ("home") references villages("id"),
+
+    "residence" bigint,
+    constraint "relation_village_residence"
+      foreign key ("residence") references villages("id"),
+
+    "created_at" timestamp(0) not null default current_timestamp,
+    "updated_at" timestamp(0) not null default current_timestamp
+  );
+SQL);
+
+DB::query(<<<SQL
   create table if not exists "users" (
     "id" bigserial primary key,