--- 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,