r9898 - in apps/gobi/trunk/db/relational: . Page

Author: hannes
Date: 2009-09-15 13:03:21 +0200 (Tue, 15 Sep 2009)
New Revision: 9898

Added:
   apps/gobi/trunk/db/relational/gobi-mysql.sql
   apps/gobi/trunk/db/relational/gobi-postgresql.sql
Removed:
   apps/gobi/trunk/db/relational/gobi.sql
Modified:
   apps/gobi/trunk/db/relational/Page/type.properties
   apps/gobi/trunk/db/relational/Relational.zip
Log:
Add support for PostgreSQL


Details at http://dev.helma.org/trac/helma/changeset/9898

Modified: apps/gobi/trunk/db/relational/Page/type.properties
===================================================================
--- apps/gobi/trunk/db/relational/Page/type.properties	2009-09-15 11:00:30 UTC (rev 9897)
+++ apps/gobi/trunk/db/relational/Page/type.properties	2009-09-15 11:03:21 UTC (rev 9898)
@@ -5,7 +5,7 @@
 _children.accessname = name
 _children.local = id
 _children.foreign = parent_id
-_children.filter = collection = "main"
+_children.filter = collection = 'main'
 _children.order = weight, createtime
 _children.cachemode = aggressive
 
@@ -20,26 +20,26 @@
 version_history = collection(Page)
 version_history.local  = id
 version_history.foreign = parent_id
-version_history.filter = collection = "history"
+version_history.filter = collection = 'history'
 version_history.order = createtime
 
 comment_pages = collection(Page)
 comment_pages.local = id
 comment_pages.foreign = parent_id
-comment_pages.filter = collection = "comment"
+comment_pages.filter = collection = 'comment'
 comment_pages.order = createtime
 
 embedded_pages = collection(Page)
 embedded_pages.local = id
 embedded_pages.foreign = parent_id
-embedded_pages.filter = collection = "embedded"
+embedded_pages.filter = collection = 'embedded'
 embedded_pages.order = weight
 
 links_in = collection(Link)
 links_in.local = id
 links_in.foreign = target_id
 links_in.group = type
-links_in.group.order = id, createtime
+links_in.group.order = type
 links_in.order = id, createtime
 links_in.accessname = sourceId
 links_in.cachemode = aggressive
@@ -49,7 +49,7 @@
 links_out.local = id
 links_out.foreign = source_id
 links_out.group = type
-links_out.group.order = id, createtime
+links_out.group.order = type
 links_out.order = id, createtime
 links_out.accessname = targetId
 links_out.cachemode = aggressive

Modified: apps/gobi/trunk/db/relational/Relational.zip
===================================================================
(Binary files differ)

Copied: apps/gobi/trunk/db/relational/gobi-mysql.sql (from rev 9423, apps/gobi/trunk/db/relational/gobi.sql)


Property changes on: apps/gobi/trunk/db/relational/gobi-mysql.sql
___________________________________________________________________
Name: cvs2svn:cvs-rev
   + 1.4
Name: svn:mergeinfo
   + 

Added: apps/gobi/trunk/db/relational/gobi-postgresql.sql

Deleted: apps/gobi/trunk/db/relational/gobi.sql