db/db-data.sql
changeset 79 25392159b6ca
child 81 c7d21399c726
equal deleted inserted replaced
78:7af1b5887759 79:25392159b6ca
       
     1 -- Project states
       
     2 INSERT INTO code_list_item
       
     3 (code_list, id, i18n, name, rank, dflt, i1,
       
     4 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
       
     5 VALUES
       
     6 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.assigned', 10, true, 0,
       
     7 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
       
     8 INSERT INTO code_list_item
       
     9 (code_list, id, i18n, name, rank, dflt, i1,
       
    10 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
       
    11 VALUES
       
    12 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.paused', 45, false, 0,
       
    13 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
       
    14 INSERT INTO code_list_item
       
    15 (code_list, id, i18n, name, rank, dflt, i1,
       
    16 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
       
    17 VALUES
       
    18 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.in_preparation', 20, false, 0,
       
    19 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
       
    20 INSERT INTO code_list_item
       
    21 (code_list, id, i18n, name, rank, dflt, i1,
       
    22 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
       
    23 VALUES
       
    24 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.in_realization', 30, false, 0,
       
    25 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
       
    26 INSERT INTO code_list_item
       
    27 (code_list, id, i18n, name, rank, dflt, i1,
       
    28 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
       
    29 VALUES
       
    30 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.cancelled', 50, false, 1,
       
    31 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
       
    32 INSERT INTO code_list_item
       
    33 (code_list, id, i18n, name, rank, dflt, i1,
       
    34 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
       
    35 VALUES
       
    36 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.realized', 40, false, 1,
       
    37 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);