stds_map_register_table_template.sql 813 B

123456789101112131415161718
  1. --#############################################################################
  2. -- This SQL script generates the table in which all registered GRASS_MAP maps
  3. -- are listed in.
  4. --
  5. -- This table will be created for each STDS.
  6. --
  7. -- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
  8. --#############################################################################
  9. -- SPACETIME_NAME is a placeholder for specific stds name (SQL compliant): name_mapset
  10. -- GRASS_MAP is a placeholder for specific map type: raster, raster3d or vector
  11. -- This table stores the.ids of the GRASS_MAP maps registered in the current spacetime GRASS_MAP table
  12. CREATE TABLE SPACETIME_NAME_GRASS_MAP_register (
  13. id VARCHAR NOT NULL, -- This colum is a primary key storing the registered GRASS_MAP map.ids
  14. PRIMARY KEY (id)
  15. );