CREATE TABLE place

(

  locationplace_id int(11) NOT NULL AUTO_INCREMENT,

  location_id int(11) NOT NULL,

  calculated int(1),

  namedplace_id int(11) NOT NULL,

  CONSTRAINT place_pkey PRIMARY KEY (locationplace_id ),

  CONSTRAINT place_location_id FOREIGN KEY (location_id)

      REFERENCES location (location_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  CONSTRAINT place_namedplace_id FOREIGN KEY (namedplace_id)

      REFERENCES namedplace (namedplace_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  CONSTRAINT place_keys UNIQUE (location_id , namedplace_id )

);

CREATE TABLE stratum

(

  stratum_id int(11) NOT NULL AUTO_INCREMENT,

  locationevent_id int(11) NOT NULL,

  stratumtype_id int(11) NOT NULL,

  stratummethod_id int(11),

  stratumname character varying(30),

  stratumheight double precision,

  stratumbase double precision,

  stratumcover double precision,

  stratumdescription character varying(200),

  CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ),

  CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id)

      REFERENCES locationevent (locationevent_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

);