Index: openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-create.sql	4 Feb 2006 01:54:41 -0000	1.1
+++ openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-create.sql	5 Feb 2006 03:36:30 -0000	1.2
@@ -93,7 +93,7 @@
   p_template_demo_note_id                    alias for $1;       -- default null
   p_title                      alias for $2;
   p_body                       alias for $3;
-  p_object_type                alias for $4;       -- default ''note''
+  p_object_type                alias for $4;       -- default ''template_demo_note''
   p_creation_date              alias for $5;        -- default now()
   p_creation_user              alias for $6;        -- default null
   p_creation_ip                alias for $7;        -- default null
@@ -160,4 +160,5 @@
 
 
 -- neophytosd
-\i notes-sc-create.sql
+\i template-demo-notes-sc-create.sql
+\i template-demo-notes-sample.sql
\ No newline at end of file
Index: openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sample.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sample.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sample.sql	5 Feb 2006 03:36:30 -0000	1.1
@@ -0,0 +1,314 @@
+create function template__make_sample_data() returns integer
+as
+'
+declare
+    security_context_root integer;
+    a_sitewide_admin integer;
+    acs_templating_package_id int4;
+begin
+    -- try to find a sitewide admin by finding a user 
+    -- with admin perm on the security context root object
+
+    security_context_root := acs__magic_object_id(''security_context_root'');
+
+    select 
+        p.grantee_id into a_sitewide_admin
+    from
+        acs_permissions p
+    where
+        p.object_id = security_context_root
+      and
+        p.privilege = ''admin''
+    limit 1;
+
+    -- now, we want the object id of the acs templating package instance
+
+    select
+        p.package_id into acs_templating_package_id
+    from
+	apm_packages p
+    where
+        p.package_key = ''acs-templating'';
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title01'',
+		''body01'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title02'',
+		''body02'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title03'',
+		''body03'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title04'',
+		''body04'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title05'',
+		''body05'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title06'',
+		''body06'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title07'',
+		''body07'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title08'',
+		''body08'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title09'',
+		''body09'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title10'',
+		''body10'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title11'',
+		''body11'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title12'',
+		''body12'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title13'',
+		''body13'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title14'',
+		''body14'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title15'',
+		''body15'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title16'',
+		''body16'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title17'',
+		''body17'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title18'',
+		''body18'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title1'',
+		''body1'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title19'',
+		''body19'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    perform template_demo_note__new
+	(
+		NULL,
+		''title20'',
+		''body20'',
+		''template_demo_note'',
+
+		now(),
+		a_sitewide_admin,
+		NULL,
+		acs_templating_package_id
+	);
+
+    return a_sitewide_admin;
+end;
+'
+language 'plpgsql';
+
+select template__make_sample_data();
+
+drop function template__make_sample_data();
+
Index: openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sc-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/sql/postgresql/Attic/template-demo-notes-sc-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sc-create.sql	4 Feb 2006 01:54:41 -0000	1.1
+++ openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sc-create.sql	5 Feb 2006 03:36:30 -0000	1.2
@@ -57,10 +57,10 @@
 
 
 create trigger template_demo_notes__itrg after insert on template_demo_notes
-for each row execute procedure notes__itrg (); 
+for each row execute procedure template_demo_notes__itrg (); 
 
 create trigger template_demo_notes__dtrg after delete on template_demo_notes
-for each row execute procedure notes__dtrg (); 
+for each row execute procedure template_demo_notes__dtrg (); 
 
 create trigger template_demo_notes__utrg after update on template_demo_notes
-for each row execute procedure notes__utrg (); 
+for each row execute procedure template_demo_notes__utrg (); 
Index: openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sc-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/sql/postgresql/Attic/template-demo-notes-sc-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sc-drop.sql	4 Feb 2006 01:54:41 -0000	1.1
+++ openacs-4/packages/acs-templating/sql/postgresql/template-demo-notes-sc-drop.sql	5 Feb 2006 03:36:30 -0000	1.2
@@ -6,9 +6,9 @@
 
 
 
-drop trigger template_demo_notes__utrg on notes;
-drop trigger template_demo_notes__dtrg on notes;
-drop trigger template_demo_notes__itrg on notes;
+drop trigger template_demo_notes__utrg on template_demo_notes;
+drop trigger template_demo_notes__dtrg on template_demo_notes;
+drop trigger template_demo_notes__itrg on template_demo_notes;