source: TI01-discovery/branches/ingestAutomation-upgrade/database/temporal_data.sql @ 3831

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery/branches/ingestAutomation-upgrade/database/temporal_data.sql@3831
Revision 3831, 229 bytes checked in by cbyrom, 12 years ago (diff)

Extend the new data model to include spatio-temporal tables - including using
postGIS geom column for the spatial data.

Line 
1DROP TABLE temporal_data;
2CREATE TABLE temporal_data
3(
4        temporal_data_id SERIAL primary key,
5        start_time timestamp without time zone,
6        end_time timestamp without time zone,
7);
8ALTER TABLE temporal_data OWNER TO postgres;
Note: See TracBrowser for help on using the repository browser.