Index: openacs-4/packages/cms/tcl/module-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/module-procs-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/cms/tcl/module-procs-postgresql.xql 16 Sep 2002 15:30:29 -0000 1.7
+++ openacs-4/packages/cms/tcl/module-procs-postgresql.xql 9 May 2005 22:44:48 -0000 1.8
@@ -83,16 +83,16 @@
-
- select content_template__get_root_folder()
+ select root_key from cm_modules where key = 'templates' and package_id = :package_id
+ -- select content_template__get_root_folder()
-
- select content_item__get_root_folder(null)
+ -- select content_item__get_root_folder(null)
+ select root_key from cm_modules where key = 'sitemap' and package_id = :package_id
@@ -191,5 +191,23 @@
-
+
+
+ select content_module__new (
+ :module_name, --name
+ lower(:module),
+ :root_key,
+ :sort_key,
+ :package_id, -- parent_id
+ :package_id -- package_id
+ )
+
+
+
+
+
+ select content_module__delete (:module_id)
+
+
+