- Timestamp:
- 08/09/13 10:54:26 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/import/alkis_PostNAS_ORACLE_schema.sql
r247 r291 42 42 beziehungsart varchar2(2047), 43 43 beziehung_zu character(16), 44 CONSTRAINT ALKIS_2 PRIMARY KEY (ogr_fid) 44 CONSTRAINT ALKIS_2 PRIMARY KEY (ogr_fid), 45 constraint alkis_bez_unique unique (BEZIEHUNG_ZU,BEZIEHUNG_VON,BEZIEHUNGSART) 45 46 ); 46 47 CREATE INDEX ALKIS_3 ON alkis_beziehungen (beziehung_von); … … 84 85 CONSTRAINT ALKIS_6 PRIMARY KEY (ogr_fid) 85 86 ); 87 CREATE UNIQUE INDEX ALKIS_6_1 ON KS_SONSTIGESBAUWERK (gml_id); 86 88 ALTER TABLE KS_SONSTIGESBAUWERK ADD ORA_GEOMETRY MDSYS.SDO_GEOMETRY; 87 89 INSERT INTO user_sdo_geom_metadata(table_name,column_name,srid,diminfo) VALUES ('KS_SONSTIGESBAUWERK','ORA_GEOMETRY',&&alkis_epsg,mdsys.sdo_dim_array(mdsys.sdo_dim_element('X',200000,800000,0.001),mdsys.sdo_dim_element('Y',5200000,6100000,0.001))); … … 2959 2961 CONSTRAINT ALKIS_341 PRIMARY KEY (ogr_fid) 2960 2962 ); 2963 CREATE UNIQUE INDEX ALKIS_343_1 ON AX_KLASSIFIZIERUNGNACHWASSERRE (gml_id,beginnt); 2961 2964 ALTER TABLE AX_KLASSIFIZIERUNGNACHWASSERRE ADD ORA_GEOMETRY MDSYS.SDO_GEOMETRY; 2962 2965 INSERT INTO user_sdo_geom_metadata(table_name,column_name,srid,diminfo) VALUES ('AX_KLASSIFIZIERUNGNACHWASSERRE','ORA_GEOMETRY',&&alkis_epsg,mdsys.sdo_dim_array(mdsys.sdo_dim_element('X',200000,800000,0.001),mdsys.sdo_dim_element('Y',5200000,6100000,0.001)));
Note: See TracChangeset
for help on using the changeset viewer.