Mercurial > gemma

comparison schema/gemma.sql @ 916:69394644bc73

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 )