create table logistic_site ( 
  id bigint not null primary key,
  key character varying not null unique,
  name character varying,
  created timestamp with time zone not null,
  updated timestamp with time zone not null,
  archived timestamp with time zone,
  geom geometry,
  location geometry,
  notes text,
  country_id bigint,
  customer_id bigint
);


create index "logistic_site_country_id_9a696481" on logistic_site using btree (country_id);
create index "logistic_site_customer_id_a2c8a74a" on logistic_site using btree (customer_id);
create index "logistic_site_geom_105a08da_id" on logistic_site using gist (geom);
create index "logistic_site_key_2e791173_like" on logistic_site using btree (key varchar_pattern_ops);
create index "logistic_site_location_54ae0166_id" on logistic_site using gist (location);

insert into logistic_site (id,key,created,updated) select x,x::text,now(),now() from generate_Series(1,213)x;