Index: openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql	20 Nov 2005 23:52:09 -0000	1.1
@@ -0,0 +1,47 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.4</version></rdbms>
+
+   <fullquery name="curriculum_central::curriculum_new.instance_info">
+     <querytext>
+	select p.instance_name, o.creation_user, o.creation_ip
+	from apm_packages p join acs_objects o on (p.package_id = o.object_id)
+        where p.package_id = :curriculum_id
+     </querytext>
+   </fullquery>
+
+   <fullquery name="curriculum_central::curriculum_new.already_there">
+     <querytext>
+       SELECT 1 from cc_curriculum where curriculum_id = :curriculum_id
+     </querytext>
+   </fullquery>
+
+   <fullquery name="curriculum_central::curriculum_new.cc_curriculum_insert">
+     <querytext>
+       INSERT INTO cc_curriculum (curriculum_id, folder_id, root_keyword_id)
+           VALUES (:curriculum_id, :folder_id, :keyword_id)
+     </querytext>
+   </fullquery>
+
+   <fullquery name="curriculum_central::curriculum_delete.delete_curriculum">
+     <querytext>
+       SELECT cc_curriculum__delete(:curriculum_id)
+     </querytext>
+   </fullquery>
+
+   <fullquery name="curriculum_central::users_get_options.users">
+     <querytext>
+       SELECT first_names || ' ' || last_name || ' (' || email || ')'  AS name,
+           user_id
+	   FROM   cc_users
+     </querytext>
+   </fullquery>
+
+   <fullquery name="curriculum_central::departments_get_options.departments">
+     <querytext>
+       SELECT department_name, department_id FROM cc_department
+           WHERE package_id = :package_id
+     </querytext>
+   </fullquery>
+</queryset>