X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=migrations%2F007-up-event-objects-view.sql;fp=migrations%2F007-up-event-objects-view.sql;h=2ed47ee9456701bf3a4071ed6edd97b6ccb0a917;hb=1600712a2312d824ade8c8a688e1dee9a426a68e;hp=0000000000000000000000000000000000000000;hpb=c8a1d201650168b0e3f25d606a412740577a389b;p=plcapi.git

diff --git a/migrations/007-up-event-objects-view.sql b/migrations/007-up-event-objects-view.sql
new file mode 100644
index 0000000..2ed47ee
--- /dev/null
+++ b/migrations/007-up-event-objects-view.sql
@@ -0,0 +1,26 @@
+--
+-- migration 007
+-- change the way event objects are fetched, use a view for that purpose
+-- 
+
+
+CREATE OR REPLACE VIEW view_event_objects AS 
+SELECT
+events.event_id,
+events.person_id,
+events.node_id,
+events.fault_code,
+events.call_name,
+events.call,
+events.message,
+events.runtime,
+CAST(date_part('epoch', events.time) AS bigint) AS time,
+event_object.object_id,
+event_object.object_type
+FROM events LEFT JOIN event_object USING (event_id);
+
+
+---------- bump subversion
+
+UPDATE plc_db_version SET subversion = 7;
+SELECT subversion from plc_db_version;