Ignore:
Timestamp:
07/05/08 10:13:17 (12 years ago)
Author:
cbyrom
Message:

Adjust tables to use timestamps instead of dates - and add create dates to
the spatiotemporal tables + add delete cascade to the spatial_temporal_data
to allow easy removal of spatial and temporal records.

File:
1 edited

Legend:

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

    r3834 r3849  
    99( 
    1010        spatial_data_id SERIAL primary key, 
    11         description character varying (255) 
     11        description character varying (255), 
     12        create_date     timestamp 
    1213); 
    13 ALTER TABLE spatial_data OWNER TO postgres; 
     14--ALTER TABLE spatial_data OWNER TO postgres; 
    1415 
    1516-- add 2D geometry column, 'geometry', to table - with SRS val of 4326 
Note: See TracChangeset for help on using the changeset viewer.