Task : modification contrainte, manday doit etre>= 0

[OpenERP/todolist.git] / sql / COPIER_CONTAINERS.SQL

diff --git a/sql/COPIER_CONTAINERS.SQL b/sql/COPIER_CONTAINERS.SQL
index 075db64..2d02fe0 100644 (file)
--- 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
        );