Ignore:
Timestamp:
01/05/08 13:56:05 (12 years ago)
Author:
cbyrom
Message:

Changes to data model:
i) Simplify creation script - to take input parameters and reuse these in a env variable
ii) Create history table direct from the main table
iii) Create procedure to do the backup to the history table
iv) Add trigger to call the backup procedure
v) Tidy up of spatio + temporal tables + additional docs.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • TI01-discovery/branches/ingestAutomation-upgrade/database/spatial_data.sql

    r3831 r3834  
    1 DROP TABLE spatial_data; 
     1/*  
     2 * Table storing spatial information 
     3 *  
     4 * C Byrom Apr 08 
     5 *  
     6 */ 
     7DROP TABLE spatial_data CASCADE; 
    28CREATE TABLE spatial_data 
    39( 
    410        spatial_data_id SERIAL primary key, 
    5         description character varying (255), 
     11        description character varying (255) 
    612); 
    7 ALTER TABLE test_location OWNER TO postgres; 
     13ALTER TABLE spatial_data OWNER TO postgres; 
    814 
    915-- add 2D geometry column, 'geometry', to table - with SRS val of 4326 
Note: See TracChangeset for help on using the changeset viewer.