Mercurial > dive4elements > river
annotate flys-backend/doc/schema/oracle-spatial_idx.sql @ 4215:c179cd02177d
Logout the current user
Add code to the logout button to remove the current user from the session and to
redirect the browser window to the login page.
Part of flys/issue916 (Logout: "Abmelden" Knopf mit Funktion belegen)
| author | Björn Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Tue, 23 Oct 2012 09:59:16 +0200 |
| parents | bb116a8d6e19 |
| children | eecd1ebba128 |
| rev | line source |
|---|---|
|
2864
bb116a8d6e19
Changed the geometry type of 'catchments' from polygon to multipolygon.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2365
diff
changeset
|
1 CREATE INDEX catchment_spatial_idx ON catchment(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=multipolygon'); |
|
1254
3d4eb1abe23e
Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
2 CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point'); |
|
3d4eb1abe23e
Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
3 CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); |
|
3d4eb1abe23e
Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
4 CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); |
|
3d4eb1abe23e
Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
5 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); |
|
3d4eb1abe23e
Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
6 CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); |
|
3d4eb1abe23e
Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
7 CREATE INDEX hws_spatial_idx ON hws(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); |
|
3d4eb1abe23e
Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
8 CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON'); |
|
2365
60532f75396b
Adapted 'lines' relation and made lines queryable for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
1254
diff
changeset
|
9 CREATE INDEX lines_idx ON lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); |