Mercurial Mercurial > fis / file revision
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
src/main/resources/db/db-data.sql
author Tomas Zeman <tzeman@volny.cz>
Thu, 24 May 2012 11:19:26 +0200
changeset 99 49eb72a46208
parent 92 eb207b189332
child 104 ef29ecada49d
permissions -rw-r--r--
e45557248ba12a15 Services

-- Project states
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, 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.paused', 45, false, 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.in_preparation', 20, false, 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.in_realization', 30, false, 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.cancelled', 50, false, 1,
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,
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,
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
VALUES
('task_state', nextval('code_list_item_id_seq'), false, '', 0, false, 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
('task_state', nextval('code_list_item_id_seq'), false, '', 10, false, 10,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 20, false, 20,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 30, false, 30,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 40, false, 40,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 50, false, 50,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 60, false, 60,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 70, false, 70,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 80, false, 80,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 90, false, 90,
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
('task_state', nextval('code_list_item_id_seq'), false, '', 100, false, 100,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);

-- Task types
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
('task_type', nextval('code_list_item_id_seq'), true, 'Task type 1', 1, false, 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
('task_type', nextval('code_list_item_id_seq'), true, 'Task type 2', 2, false, 0,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);

-- Company status
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
('company_status', nextval('code_list_item_id_seq'), true, 'company.status.active', 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
('company_status', nextval('code_list_item_id_seq'), true, 'company.status.potencial', 20, false, 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
('company_status', nextval('code_list_item_id_seq'), true, 'company.status.inactive', 30, false, 0,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);

-- Service state
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
('service_state', nextval('code_list_item_id_seq'), true, 'service.state.init', 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
('service_state', nextval('code_list_item_id_seq'), true, 'service.state.active', 20, false, 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
('service_state', nextval('code_list_item_id_seq'), true, 'service.state.terminated', 30, false, 0,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);

-- Currency
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
('currency', nextval('code_list_item_id_seq'), false, 'CZK', 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
('currency', nextval('code_list_item_id_seq'), false, 'EUR', 20, false, 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
('currency', nextval('code_list_item_id_seq'), false, 'USD', 30, false, 0,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);

-- Payment period
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
('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.initial', 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
('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.monthly', 20, false, 12,
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
('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.quarterly', 30, false, 4,
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
('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.semiannually', 40, false, 2,
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
('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.annually', 50, false, 1,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
fis