Changes between Version 11 and Version 12 of dbeel

Timestamp:

Dec 21, 2010 4:27:47 PM (14 years ago)

Author:

cedric

Comment:

--

dbeel

@@ -22 +22 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d dbeel -p 5433 -f bdmap.bdmap.sql
 }}}
-{{{
-#!sql
-DROP TABLE if exists "onema".station_onema CASCADE;
-CREATE TABLE "onema".station_onema (
-        LIKE bdmap.station,
-        CONSTRAINT station_onema_id PRIMARY KEY (op_id),
-        CONSTRAINT station_onema_fk_observation_place_type_id FOREIGN KEY (op_no_observationplacetype) 
-        REFERENCES "dbeel_nomenclature".observation_place_type (no_id) 
-        MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT
-) INHERITS ("dbeel".observation_places);
--- TODO: insert trigger
 
-INSERT INTO "onema".station_onema
-        SELECT  uuid_generate_v4() as op_id,
-        'onema' as op_gis_systemname ,
-        'BDMAP' as op_gis_layername, 
-        s.st_id as op_gislocation,
-        s.st_localisation as op_placename,
-        10 as op_no_observationplacetype, -- Sampling station
-        NULL as  op_op_id,
-        s.* FROM bdmap.station s ;
-}}}
+= changes by cedric =
+changeset:1488 [[BR]]