X-Git-Url: http://git.inspyration.org/?a=blobdiff_plain;f=sql%2FCOPIER_CONTAINERS.SQL;h=2d02fe07af5249fc8dee354420ea8593277a1ae9;hb=1fccb8fb0c76123aac93642be40d8f74fd067c4b;hp=075db64f633d86f85ec289c416d432289e156f11;hpb=1956444d7225153c63171bac049e2e69bfe87d78;p=OpenERP%2Ftodolist.git diff --git a/sql/COPIER_CONTAINERS.SQL b/sql/COPIER_CONTAINERS.SQL index 075db64..2d02fe0 100644 --- a/sql/COPIER_CONTAINERS.SQL +++ b/sql/COPIER_CONTAINERS.SQL @@ -2,16 +2,16 @@ CREATE OR REPLACE FUNCTION copierContainer (id_container todolist_container.id%T DECLARE copy_id todolist_container.id%TYPE; BEGIN - INSERT INTO todolist_container (name, description, state) ( - SELECT 'Copy of ' || name, description, 'draft' + INSERT INTO todolist_container (name, description, state, create_uid) ( + SELECT 'Copy of ' || name, description, 'draft', create_uid FROM todolist_container WHERE id = id_container ); SELECT currval(pg_get_serial_sequence('todolist_container', 'id')) INTO copy_id; - INSERT INTO todolist_task (name, description, container_id, milestone, planned, manday, priority) ( - SELECT name, description, copy_id, milestone, planned, manday, priority + INSERT INTO todolist_task (name, description, container_id, milestone, planned, manday, priority, create_uid) ( + SELECT name, description, copy_id, milestone, planned, manday, priority, create_uid FROM todolist_task WHERE container_id = id_container );