From a21b030abd4d5cd88f914f79574e425c7908553a Mon Sep 17 00:00:00 2001
From: Daniel Weipert <git@mail.dweipert.de>
Date: Mon, 24 Mar 2025 13:28:57 +0100
Subject: various changes

---
 bin/db.php | 18 +++++++++---------
 1 file changed, 9 insertions(+), 9 deletions(-)

(limited to 'bin')

diff --git a/bin/db.php b/bin/db.php
index 66258cc..914ff5f 100644
--- a/bin/db.php
+++ b/bin/db.php
@@ -117,12 +117,12 @@ DB::query(<<<SQL
     constraint "relation_event"
       foreign key ("event_id") references events("id") on delete cascade,
 
-    "village_id" bigint not null,
-    constraint "relation_village"
-      foreign key ("village_id") references villages("id") on delete cascade,
-
     "type" character varying(255) not null,
 
+    "wood" bigint not null,
+    "clay" bigint not null,
+    "iron" bigint not null,
+
     "created_at" timestamp(0) not null default current_timestamp,
     "updated_at" timestamp(0) not null default current_timestamp
   );
@@ -136,13 +136,13 @@ DB::query(<<<SQL
     constraint "relation_event"
       foreign key ("event_id") references events("id") on delete cascade,
 
-    "village_id" bigint not null,
-    constraint "relation_village"
-      foreign key ("village_id") references villages("id") on delete cascade,
-
     "amount" bigint not null,
     "type" character varying(255) not null,
 
+    "wood" bigint not null,
+    "clay" bigint not null,
+    "iron" bigint not null,
+
     "created_at" timestamp(0) not null default current_timestamp,
     "updated_at" timestamp(0) not null default current_timestamp
   );
@@ -220,7 +220,7 @@ DB::query(<<<SQL
 
     "unit_id" bigint not null,
     constraint "relation_unit"
-      foreign key ("unit") references village_units("id"),
+      foreign key ("unit_id") references village_units("id"),
 
     "amount" bigint not null,
 
-- 
cgit v1.2.3