Changes between Version 27 and Version 28 of Cookbook CCM21_France

Timestamp:

Jul 27, 2010 3:01:22 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook CCM21_France

@@ -99 +99 @@
 {{{
 #!sql
-DROP TABLE IF EXISTS ccm21.riversegments_France;   
-CREATE TABLE  ccm21.riversegments_France AS
+DROP TABLE IF EXISTS ccm21.riversegments_france;   
+CREATE TABLE  ccm21.riversegments_france AS
     SELECT * FROM ccm21.riversegments
         WHERE wso_id IN (SELECT wso_id FROM france.wso WHERE area='France');
-ALTER TABLE ccm21.riversegments_France ADD CONSTRAINT c_pk_gid_riversegments_France PRIMARY KEY  (gid);
+ALTER TABLE ccm21.riversegments_France ADD CONSTRAINT c_pk_gid_riversegments_france PRIMARY KEY  (gid);
 INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
 SELECT '', 'ccm21', 'riversegments_France', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
-FROM ccm21.riversegments_France LIMIT 1;
-alter table ccm21.riversegments_France add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
-alter table ccm21.riversegments_France add    CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
-alter table clc.ccm21.riversegments_France add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
-CREATE INDEX index_riversegments_France ON ccm21.riversegments_France
+FROM ccm21.riversegments_france LIMIT 1;
+alter table ccm21.riversegments_france add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table ccm21.riversegments_france add    CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
+alter table clc.ccm21.riversegments_france add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+CREATE INDEX index_riversegments_france ON ccm21.riversegments_france
   USING GIST ( the_geom GIST_GEOMETRY_OPS );