diff -r 6a2a19785cd8 -r ef29ecada49d src/main/resources/db/db-data.sql --- a/src/main/resources/db/db-data.sql Tue Jun 05 15:40:44 2012 +0200 +++ b/src/main/resources/db/db-data.sql Tue Jun 05 15:40:45 2012 +0200 @@ -3,8 +3,14 @@ (code_list, id, i18n, name, rank, dflt, i1, i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) VALUES -('project_state', nextval('code_list_item_id_seq'), true, 'project.state.assigned', 10, true, 0, -0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); +('project_state', nextval('code_list_item_id_seq'), true, 'project.state.new', 1, true, 0, +0, 0, 0, 0, 0, 'new', '', '', current_timestamp, current_timestamp, false); +INSERT INTO code_list_item +(code_list, id, i18n, name, rank, dflt, i1, +i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) +VALUES +('project_state', nextval('code_list_item_id_seq'), true, 'project.state.assigned', 10, false, 0, +0, 0, 0, 0, 0, 'assigned', '', '', current_timestamp, current_timestamp, false); INSERT INTO code_list_item (code_list, id, i18n, name, rank, dflt, i1, i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) @@ -28,14 +34,26 @@ i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) VALUES ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.cancelled', 50, false, 1, +0, 0, 0, 0, 0, 'closed', '', '', current_timestamp, current_timestamp, false); +INSERT INTO code_list_item +(code_list, id, i18n, name, rank, dflt, i1, +i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) +VALUES +('project_state', nextval('code_list_item_id_seq'), true, 'project.state.realized', 40, false, 1, +0, 0, 0, 0, 0, 'closed', '', '', current_timestamp, current_timestamp, false); +-- Project phases +INSERT INTO code_list_item +(code_list, id, i18n, name, rank, dflt, i1, +i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) +VALUES +('project_phase', nextval('code_list_item_id_seq'), true, 'project.phase.offer', 10, true, 0, 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); INSERT INTO code_list_item (code_list, id, i18n, name, rank, dflt, i1, i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) VALUES -('project_state', nextval('code_list_item_id_seq'), true, 'project.state.realized', 40, false, 1, +('project_phase', nextval('code_list_item_id_seq'), true, 'project.phase.realization', 20, false, 0, 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); - -- Task states INSERT INTO code_list_item (code_list, id, i18n, name, rank, dflt, i1,