annotate update/core-update.v1.2.3-v1.2.4.sql @ 536:750b0be5acb6
Work on unit/area/policy events: added column "policy_id" to "event" table, added new "event_type"s
 | author | 
 jbe | 
 | date | 
 Mon Jun 26 15:54:26 2017 +0200 (2017-06-26) | 
 | parents | 
 bdccc56fb705  | 
 | children | 
  | 
 
 | rev | 
   line source | 
| 
jbe@65
 | 
     1 BEGIN;
 | 
| 
jbe@65
 | 
     2 
 | 
| 
jbe@65
 | 
     3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
 | 
| 
jbe@65
 | 
     4   SELECT * FROM (VALUES ('1.2.4', 1, 2, 4))
 | 
| 
jbe@65
 | 
     5   AS "subquery"("string", "major", "minor", "revision");
 | 
| 
jbe@65
 | 
     6 
 | 
| 
jbe@65
 | 
     7 -- no changes in database scheme except version number
 | 
| 
jbe@65
 | 
     8 
 | 
| 
jbe@65
 | 
     9 COMMIT;
 |