Index: openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0d6-3.0d7.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/sql/postgresql/upgrade/Attic/upgrade-3.0d6-3.0d7.sql,v
diff -u -N
--- openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0d6-3.0d7.sql	21 Jun 2005 22:19:02 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,177 +0,0 @@
-select define_function_args('pm_task__new_task_item', 'project_id, title, description, html_p, end_date, percent_complete, estimated_hours_work, estimated_hours_work_min, estimated_hours_work_max, status_id, process_instance_id, dform, creation_date, creation_user, creation_ip, package_id, priority, task_id');
-
-create or replace function pm_task__new_task_item (
-        integer,        -- project_id
-        varchar,        -- title
-        varchar,        -- description
-        varchar,        -- html_p
-        timestamptz,    -- end_date
-        numeric,        -- percent_complete
-        numeric,        -- estimated_hours_work
-        numeric,        -- estimated_hours_work_min
-        numeric,        -- estimated_hours_work_max,
-        integer,        -- status_id
-        integer,        -- process_instance_id
-        varchar,        -- dform
-        timestamptz,    -- creation_date
-        integer,        -- creation_user
-        varchar,        -- creation_ip
-        integer,        -- package_id
-	integer,        -- priority
-        integer         -- task_id
-) returns integer 
-as '
-declare
-        p_project_id                            alias for $1;
-        p_title                                 alias for $2;
-        p_description                           alias for $3;
-        p_mime_type                             alias for $4;
-        p_end_date                              alias for $5;
-        p_percent_complete                      alias for $6;
-        p_estimated_hours_work                  alias for $7;
-        p_estimated_hours_work_min              alias for $8;
-        p_estimated_hours_work_max              alias for $9;
-        p_status_id                             alias for $10;
-        p_process_instance_id                   alias for $11;
-        p_dform                                 alias for $12;
-        p_creation_date                         alias for $13;
-        p_creation_user                         alias for $14;
-        p_creation_ip                           alias for $15;
-        p_package_id                            alias for $16;
-        p_priority                              alias for $17;
-        p_task_id                               alias for $18;
-
-        v_item_id               cr_items.item_id%TYPE;
-        v_revision_id           cr_revisions.revision_id%TYPE;
-        v_task_number           integer;
-begin
-        -- We want to put the task under the project item
-
-        -- create the task_number
-
-        v_item_id := content_item__new (
-                p_task_id::varchar,     -- name
-                p_project_id,           -- parent_id
-                p_task_id,              -- item_id
-                null,                   -- locale
-                now(),                  -- creation_date
-                p_creation_user,        -- creation_user
-                p_package_id,           -- context_id
-                p_creation_ip,          -- creation_ip
-                ''pm_task'',            -- item_subtype
-                ''pm_task'',            -- content_type
-                p_title,                -- title
-                p_description,          -- description
-                p_mime_type,            -- mime_type
-                null,                   -- nls_language
-                null,                   -- data
-                p_package_id            -- package_id
-        );
-
-        v_revision_id := content_revision__new (
-                p_title,                -- title
-                p_description,          -- description
-                now(),                  -- publish_date
-                p_mime_type,            -- mime_type
-                NULL,                   -- nls_language
-                NULL,                   -- data
-                v_item_id,              -- item_id
-                NULL,                   -- revision_id
-                now(),                  -- creation_date
-                p_creation_user,        -- creation_user
-                p_creation_ip,          -- creation_ip
-                p_package_id            -- package_id
-        );
-
-        PERFORM content_item__set_live_revision (v_revision_id);
-
-        insert into pm_tasks (
-                task_id, task_number, status, process_instance)
-        values (
-                v_item_id, v_task_number, p_status_id, p_process_instance_id);
-
-        insert into pm_tasks_revisions (
-                task_revision_id, end_date, percent_complete, estimated_hours_work, estimated_hours_work_min, estimated_hours_work_max, actual_hours_worked, priority, dform)
-        values (
-                v_revision_id, p_end_date, p_percent_complete, p_estimated_hours_work, p_estimated_hours_work_min, p_estimated_hours_work_max, ''0'', p_priority, p_dform);
-
-        update acs_objects set context_id = p_project_id where object_id = v_item_id;
-
-        PERFORM acs_permission__grant_permission(
-                v_revision_id,
-                p_creation_user,
-                ''admin''
-        );
-
-        return v_revision_id;
-end;' language 'plpgsql';
-
-select define_function_args('pm_task__new_task_item', 'project_id, title, description, html_p, end_date, percent_complete, estimated_hours_work, estimated_hours_work_min, estimated_hours_work_max, status_id, process_instance_id, dform, creation_date, creation_user, creation_ip, package_id, priority');
-
-create or replace function pm_task__new_task_item (
-        integer,        -- project_id
-        varchar,        -- title
-        varchar,        -- description
-        varchar,        -- html_p
-        timestamptz,    -- end_date
-        numeric,        -- percent_complete
-        numeric,        -- estimated_hours_work
-        numeric,        -- estimated_hours_work_min
-        numeric,        -- estimated_hours_work_max,
-        integer,        -- status_id
-        integer,        -- process_instance_id
-        varchar,        -- dform
-        timestamptz,    -- creation_date
-        integer,        -- creation_user
-        varchar,        -- creation_ip
-        integer,        -- package_id
-	integer		-- priority
-) returns integer 
-as '
-declare
-        p_project_id                            alias for $1;
-        p_title                                 alias for $2;
-        p_description                           alias for $3;
-        p_mime_type                             alias for $4;
-        p_end_date                              alias for $5;
-        p_percent_complete                      alias for $6;
-        p_estimated_hours_work                  alias for $7;
-        p_estimated_hours_work_min              alias for $8;
-        p_estimated_hours_work_max              alias for $9;
-        p_status_id                             alias for $10;
-        p_process_instance_id                   alias for $11;
-        p_dform                                 alias for $12;
-        p_creation_date                         alias for $13;
-        p_creation_user                         alias for $14;
-        p_creation_ip                           alias for $15;
-        p_package_id                            alias for $16;
-        p_priority                              alias for $17;
-
-        v_task_id               cr_items.item_id%TYPE;
-        v_revision_id           cr_revisions.revision_id%TYPE;
-begin
-        select acs_object_id_seq.nextval into v_task_id from dual;
-
-        v_revision_id := pm_task__new_task_item (
-                p_project_id,                 -- project_id
-                p_title,                      -- title
-                p_description,                -- description
-                p_mime_type,                  -- mime_type
-                p_end_date,                   -- end_date
-                p_percent_complete,           -- percent_complete
-                p_estimated_hours_work,       -- estimated_hours_work
-                p_estimated_hours_work_min,   -- estimated_hours_work_min
-                p_estimated_hours_work_max,   -- estimated_hours_work_max
-                p_status_id,                  -- status_id
-                p_process_instance_id,        -- process_instance_id
-                p_dform,                      -- dfom
-                p_creation_date,              -- creation_date
-                p_creation_user,              -- creation_user
-                p_creation_ip,                -- creation_ip
-                p_package_id,                 -- package_id
-                p_priority,                   -- priority
-                v_task_id                     -- task_item_id
-        );
-
-        return v_revision_id;
-end;' language 'plpgsql';
