encounters (encounter_id) {
        encounter_id -> Int4,
        zone -> Int4,
        display_order -> Int4,
    }
}
table! {

    release_dates (zone) {
        zone -> Int4,
        release_date -> Timestamptz,
    }
}
table! {

    encounters,

    release_dates,

    use crate::schema::release_dates::dsl as rd;

        .inner_join(logs_t.inner_join(teams))

        .inner_join(
            logs_t
                .inner_join(teams)
                .inner_join(rd::release_dates.on(rd::zone.eq(logs::zone_id))),
        )

                .and(fights::encounter_id.eq(encounter_id)),

                .and(fights::encounter_id.eq(encounter_id))
                .and(rd::release_date.le(logs::start_time)),

-- Your SQL goes here
create table encounters (
  encounter_id int primary key,
  zone int not null,
  display_order int not null,
  unique(zone, display_order)
);
insert into encounters 
values
  (2398, 26, 10),
  (2418, 26, 9),
  (2383, 26, 8),
  (2402, 26, 7),
  (2405, 26, 6),
  (2406, 26, 5),
  (2412, 26, 4),
  (2399, 26, 3),
  (2417, 26, 2),
  (2407, 26, 1);
truncate fights;

-- This file should undo anything in `up.sql`
drop table if exists encounters;

-- Your SQL goes here
create table release_dates (
  zone integer primary key,
  release_date timestamp with time zone not null
);
insert into release_dates values (24, '2020-07-09'), (25, '2020-01-14'), (26, '2020-12-08');

-- This file should undo anything in `up.sql`
drop table if exists release_dates;