Mercurial > gemma
comparison schema/gemma.sql @ 916:69394644bc73
Remove obsolete unused table
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 04 Oct 2018 12:28:09 +0200 |
parents | fa417ff1f355 |
children | 5b90217aa1bb |
comparison
equal
deleted
inserted
replaced
911:86278692c30c | 916:69394644bc73 |
---|---|
410 -- XXX: We may raster the data later. | 410 -- XXX: We may raster the data later. |
411 -- sounding_data raster NOT NULL, | 411 -- sounding_data raster NOT NULL, |
412 staging_done boolean NOT NULL DEFAULT false | 412 staging_done boolean NOT NULL DEFAULT false |
413 ) | 413 ) |
414 | 414 |
415 CREATE TABLE meshes ( | |
416 sounding_result_id int NOT NULL REFERENCES sounding_results, | |
417 geom geometry(polygonz) NOT NULL | |
418 ) | |
419 | |
420 CREATE INDEX meshes_gix ON meshes USING gist(geom) | |
421 | |
422 CREATE TABLE octrees ( | 415 CREATE TABLE octrees ( |
423 sounding_result_id int NOT NULL UNIQUE REFERENCES sounding_results, | 416 sounding_result_id int NOT NULL UNIQUE REFERENCES sounding_results, |
424 checksum varchar NOT NULL, | 417 checksum varchar NOT NULL, |
425 octree_index bytea NOT NULL | 418 octree_index bytea NOT NULL |
426 ) | 419 ) |