Index: openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql,v diff -u -r1.19 -r1.20 --- openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql 5 Jan 2005 21:27:32 -0000 1.19 +++ openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql 6 Jan 2005 16:19:25 -0000 1.20 @@ -491,128 +491,5 @@ END LOOP; return 0; end;' language 'plpgsql'; - ---------------------------------------- --- TEMPLATES ---------------------------------------- - -create function evaluation__create_template () -returns integer as' -declare - template_id integer; -begin - - -- Create the (default) content type template - - template_id := content_template__new( - ''evaluation-tasks-default'', -- name - ''@text;noquote@'', -- text - true -- is_live - ); - - -- Register the template for the content type - - perform content_type__register_template( - ''evaluation_tasks'', -- content_type - template_id, -- template_id - ''public'', -- use_context - ''t'' -- is_default - ); - - -- Create the (default) content type template - - template_id := content_template__new( - ''evaluation-tasks-sols-default'', -- name - ''@text;noquote@'', -- text - true -- is_live - ); - - -- Register the template for the content type - - perform content_type__register_template( - ''evaluation_tasks_sols'', -- content_type - template_id, -- template_id - ''public'', -- use_context - ''t'' -- is_default - ); - -- Create the (default) content type template - - template_id := content_template__new( - ''evaluation-answers-default'', -- name - ''@text;noquote@'', -- text - true -- is_live - ); - - -- Register the template for the content type - - perform content_type__register_template( - ''evaluation_answers'', -- content_type - template_id, -- template_id - ''public'', -- use_context - ''t'' -- is_default - ); - - -- Create the (default) content type template - - template_id := content_template__new( - ''evaluation-grades-sheets-default'', -- name - ''@text;noquote@'', -- text - true -- is_live - ); - - -- Register the template for the content type - - perform content_type__register_template( - ''evaluation_grades_sheets'', -- content_type - template_id, -- template_id - ''public'', -- use_context - ''t'' -- is_default - ); - - return null; -end;' language 'plpgsql'; - -create function evaluation__delete_template () -returns integer as ' -declare - v_template_id cr_templates.template_id%TYPE; - v_item_cursor RECORD; - -begin - - FOR v_item_cursor IN - select template_id - from cr_templates, cr_items - where name=''evaluation-tasks-default'' - LOOP - PERFORM content_template__delete(v_item_cursor.template_id); - END LOOP; - - FOR v_item_cursor IN - select template_id - from cr_templates, cr_items - where name=''evaluation-tasks-sols-default'' - LOOP - PERFORM content_template__delete(v_item_cursor.template_id); - END LOOP; - - FOR v_item_cursor IN - select template_id - from cr_templates, cr_items - where name=''evaluation-answers-default'' - LOOP - PERFORM content_template__delete(v_item_cursor.template_id); - END LOOP; - - FOR v_item_cursor IN - select template_id - from cr_templates, cr_items - where name=''evaluation-grades-sheets-default'' - LOOP - PERFORM content_template__delete(v_item_cursor.template_id); - END LOOP; - - return 0; -end;' language 'plpgsql'; - + \i evaluation-calendar-create.sql Index: openacs-4/packages/evaluation/sql/postgresql/evaluation-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/sql/postgresql/evaluation-drop.sql,v diff -u -r1.11 -r1.12 --- openacs-4/packages/evaluation/sql/postgresql/evaluation-drop.sql 5 Jan 2005 21:28:35 -0000 1.11 +++ openacs-4/packages/evaluation/sql/postgresql/evaluation-drop.sql 6 Jan 2005 16:20:10 -0000 1.12 @@ -136,10 +136,4 @@ drop function evaluation__delete_contents (integer); ---------------------------------------- --- TEMPLATES ---------------------------------------- -drop function evaluation__delete_template (); - -drop function evaluation__create_template ();