db/db-data.sql
author Tomas Zeman <tzeman@volny.cz>
Tue, 24 Apr 2012 20:31:58 +0200
changeset 79 25392159b6ca
child 81 c7d21399c726
permissions -rw-r--r--
Project
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
79
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     1
-- Project states
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     2
INSERT INTO code_list_item
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     3
(code_list, id, i18n, name, rank, dflt, i1,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     4
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     5
VALUES
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     6
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.assigned', 10, true, 0,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     7
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     8
INSERT INTO code_list_item
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     9
(code_list, id, i18n, name, rank, dflt, i1,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    10
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    11
VALUES
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    12
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.paused', 45, false, 0,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    13
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    14
INSERT INTO code_list_item
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    15
(code_list, id, i18n, name, rank, dflt, i1,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    16
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    17
VALUES
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    18
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.in_preparation', 20, false, 0,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    19
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    20
INSERT INTO code_list_item
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    21
(code_list, id, i18n, name, rank, dflt, i1,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    22
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    23
VALUES
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    24
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.in_realization', 30, false, 0,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    25
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    26
INSERT INTO code_list_item
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    27
(code_list, id, i18n, name, rank, dflt, i1,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    28
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    29
VALUES
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    30
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.cancelled', 50, false, 1,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    31
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    32
INSERT INTO code_list_item
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    33
(code_list, id, i18n, name, rank, dflt, i1,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    34
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    35
VALUES
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    36
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.realized', 40, false, 1,
25392159b6ca Project
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    37
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);