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

Subversion URL:
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.

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