diff options
Diffstat (limited to 'bin/db.php')
| -rw-r--r-- | bin/db.php | 18 |
1 files changed, 9 insertions, 9 deletions
@@ -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, |