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