Changes between Version 6 and Version 7 of CookBook/Configuration/Reports

Timestamp:

Dec 15, 2013, 8:22:12 AM (10 years ago)

Author:

Ryan J Ollos

Comment:

Adjust queries for cross-db compatibility.

CookBook/Configuration/Reports

@@ -222 +222 @@
 #!sql
 SELECT 
-   "changeset" AS _realm, rev as id, 
+   'changeset' AS _realm, rev as id, 
    time AS date, time, 
    SUBSTR(message, 1, 80 )AS message
@@ -236 +236 @@
 @@ -1,7 +1,7 @@
   SELECT 
-     "changeset" AS _realm, rev as id, 
+     'changeset' AS _realm, rev as id, 
      time AS date, time, 
 -    SUBSTR(message, 1, 80 )AS message
@@ -252 +252 @@
 #!sql
 SELECT 
-   "wiki" AS _realm, 
+   'wiki' AS _realm, 
    name AS id, 
    max(version) AS Version,
@@ -265 +265 @@
 #!sql
 SELECT 
-   "wiki" AS _realm, 
+   'wiki' AS _realm, 
    wiki.name AS id, 
    time AS date, time,