liquid_feedback_core
annotate update/core-update.v1.2.6-v1.2.7.sql @ 188:8b496fa85a65
Renamed core-update.v1.4.0-v1.5.0.sql to core-update.v1.4.0_rc4-v1.5.0_rc1.sql; Set version info to v1.5.0_rc1
| author | jbe | 
|---|---|
| date | Sat Jul 30 01:57:27 2011 +0200 (2011-07-30) | 
| parents | dcaa1525c388 | 
| children | 
| rev | line source | 
|---|---|
| jbe@72 | 1 BEGIN; | 
| jbe@72 | 2 | 
| jbe@72 | 3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS | 
| jbe@72 | 4 SELECT * FROM (VALUES ('1.2.7', 1, 2, 7)) | 
| jbe@72 | 5 AS "subquery"("string", "major", "minor", "revision"); | 
| jbe@72 | 6 | 
| jbe@72 | 7 DROP VIEW "global_delegation"; | 
| jbe@72 | 8 | 
| jbe@72 | 9 CREATE VIEW "global_delegation" AS | 
| jbe@72 | 10 SELECT "id", "truster_id", "trustee_id" | 
| jbe@72 | 11 FROM "active_delegation" WHERE "scope" = 'global'; | 
| jbe@72 | 12 | 
| jbe@72 | 13 COMMIT; |