Changes between Version 91 and Version 92 of CookBook join BDMAP_CCM
- Timestamp:
- Mar 23, 2010 11:29:24 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CookBook join BDMAP_CCM
v91 v92 241 241 alter table bd_map.correspondance add CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL); 242 242 alter table bd_map.correspondance add CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035); 243 alter table bd_map.correspondance add column id serial;244 243 alter table bd_map.correspondance ADD CONSTRAINT pk_id PRIMARY KEY(id); 245 244 CREATE INDEX indexcorrespondance ON bd_map.correspondance