Changeset 291 for trunk


Ignore:
Timestamp:
08/09/13 10:54:26 (11 years ago)
Author:
astrid.emde
Message:

Aufnahme der Anmerkungen von Herrn Espenlaub

ALKIS_BEZIEHUNGEN

constraint alkis_bez_unique unique (BEZIEHUNG_ZU,BEZIEHUNG_VON,BEZIEHUNGSART)

CREATE UNIQUE INDEX ALKIS_343_1 ON AX_KLASSIFIZIERUNGNACHWASSERRE (gml_id,beginnt);

KS_SONSTIGESBAUWERK -> unique index

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/import/alkis_PostNAS_ORACLE_schema.sql

    r247 r291  
    4242        beziehungsart           varchar2(2047), 
    4343        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) 
    4546); 
    4647CREATE INDEX ALKIS_3 ON alkis_beziehungen (beziehung_von); 
     
    8485        CONSTRAINT ALKIS_6 PRIMARY KEY (ogr_fid) 
    8586); 
     87CREATE UNIQUE INDEX ALKIS_6_1 ON KS_SONSTIGESBAUWERK (gml_id); 
    8688ALTER TABLE KS_SONSTIGESBAUWERK ADD ORA_GEOMETRY MDSYS.SDO_GEOMETRY; 
    8789INSERT 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))); 
     
    29592961        CONSTRAINT ALKIS_341 PRIMARY KEY (ogr_fid) 
    29602962); 
     2963CREATE UNIQUE INDEX ALKIS_343_1 ON AX_KLASSIFIZIERUNGNACHWASSERRE (gml_id,beginnt); 
    29612964ALTER TABLE AX_KLASSIFIZIERUNGNACHWASSERRE ADD ORA_GEOMETRY MDSYS.SDO_GEOMETRY; 
    29622965INSERT 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.