1--############################################################################# 2-- This SQL script generates two views to access all map specific tables. 3-- 4-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com 5--############################################################################# 6 7-- Create the views to access all columns for the absolute and relative time 8 9CREATE VIEW vector_view_abs_time AS SELECT 10 A1.id, A1.mapset, 11 A1.name, A1.layer, A1.temporal_type, 12 A1.creation_time, 13 A1.creator, 14 A2.start_time, A2.end_time, 15 A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj, 16 A4.is_3d, A4.points, A4.lines, 17 A4.boundaries, A4.centroids, A4.faces, A4.kernels, 18 A4.primitives, A4.nodes, A4.areas, A4.islands, 19 A4.holes, A4.volumes, A5.registered_stds 20 FROM vector_base A1, vector_absolute_time A2, 21 vector_spatial_extent A3, vector_metadata A4, 22 vector_stds_register A5 23 WHERE A1.id = A2.id AND A1.id = A3.id AND 24 A1.id = A4.id AND A1.id = A5.id; 25 26CREATE VIEW vector_view_rel_time AS SELECT 27 A1.id, A1.mapset, 28 A1.name, A1.layer, A1.temporal_type, 29 A1.creation_time, 30 A1.creator, 31 A2.start_time, A2.end_time, A2.unit, 32 A3.north, A3.south, A3.east, A3.west, A3.bottom, A3.top, A3.proj, 33 A4.is_3d, A4.points, A4.lines, 34 A4.boundaries, A4.centroids, A4.faces, A4.kernels, 35 A4.primitives, A4.nodes, A4.areas, A4.islands, 36 A4.holes, A4.volumes, A5.registered_stds 37 FROM vector_base A1, vector_relative_time A2, 38 vector_spatial_extent A3, vector_metadata A4, 39 vector_stds_register A5 40 WHERE A1.id = A2.id AND A1.id = A3.id AND 41 A1.id = A4.id AND A1.id = A5.id; 42 43 44