CREATE TABLE cola_markets (
  mkt_id NUMERIC(10) PRIMARY KEY,
  name VARCHAR(32),
  shape GEOMETRY);

INSERT INTO cola_markets VALUES(
  1,
  'cola_a',
  st_makeenvelope(1,1,5,7,4326)
);

INSERT INTO cola_markets VALUES(
  2,
  'cola_b',
  st_geomfromtext('polygon((5 1, 8 1, 8 6, 5 7, 5 1))',4326)
);

INSERT INTO cola_markets VALUES(
  3,
  'cola_c',
  st_geomfromtext('polygon((3 3, 6 3, 6 5, 4 5, 3 3))',4326)
);

INSERT INTO cola_markets VALUES(
  4,
  'cola_d',
  st_buffer(st_geomfromtext('point(8 9)',4326), 2)
);
