src/main/resources/db/db-data.sql
changeset 104 ef29ecada49d
parent 99 49eb72a46208
--- 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,