Vyššie na [Platon] / web-apps / task-manager / sql

Task Manager added into repository.
It was a test project made for NUSTEP -- http://www.nustep.net/

--
-- Task Manager DML file
--

--
-- taskmng_users
--

insert into taskmng_users (id, name, position)
values (1, 'Ondrej Jombík', 'vývojár');

insert into taskmng_users (id, name, position)
values (2, 'Jožko Mrkvička', 'riaditeľ');

insert into taskmng_users (id, name, position)
values (3, 'Klára Uhlíková', 'upratovačka');

insert into taskmng_users (id, name, position)
values (4, 'Jozef Tester', 'tester');

--
-- taskmng_customers
--

insert into taskmng_customers (id, name, street, city)
values (1, 'Nextra Slovakia, Ltd.', 'Plynárenská 1', 'Bratislava');

insert into taskmng_customers (id, name, street, city)
values (2, 'Slovak Telecom', 'Neznáma 54', 'Bratislava'); -- no project

insert into taskmng_customers (id, name, street, city)
values (3, 'Platon SDG', 'Hlavná 3', 'Šaľa');

insert into taskmng_customers (id, name, street, city)
values (4, 'Nejaká firma', 'Nejaká ulica 39', 'Mesto');

--
-- taskmng_projects & taskmng_tasks
--

insert into taskmng_projects (id, customer_id, name, state, started, finished)
values (1, 1, 'Reimplementácia ADSL accountingu', 'done', '2004-02-24', '2004-04-10');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (1, 1, 1, 'Vytvorenie tabuliek v SESSIONS and ACCOUNTING', 'done', 1, 100, '2004-02-24');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (2, 1, 1, 'Zber logov z Telecom syslog', 'done', 5, 100, '2004-02-24');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (3, 1, 1, 'Zber logov z Nextra radius', 'done', 3, 100, '2004-02-24');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (4, 1, 1, 'Denné spracovanie SESSIONS do ACCOUNTING', 'done', 10, 100, '2004-03-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (5, 1, 1, 'Zmeny na MOJA.NEXTRA.SK', 'done', 40, 100, '2004-04-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (6, 1, 4, 'Testovanie', 'done', 16, 100, '2004-04-01');

insert into taskmng_projects (id, customer_id, name, state, started, finished)
values (2, 1, 'DIAL/ISDN/ADSL viacnásobné pripojenie (multiconnect)', 'deffered', '2004-05-16', NULL);

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (7, 2, 1, 'Definície produktov', 'waiting-task', 18, 70, '2004-06-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (9, 2, 2, 'Definície štandardných cien', 'abandoned', 6, 10, '2004-06-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (10, 2, 2, 'Definícia špeciálnych cien', 'waiting-customer', 20, 10, '2004-06-16');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (11, 2, 4, 'Testovanie', 'scheduled', 16, 0, '2004-07-01');

insert into taskmng_projects (id, customer_id, name, state, started, finished)
values (3, 3, 'Sťahovanie', 'processed', '2004-04-01', NULL);

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (12, 3, 1, 'Príprava', 'done', 50, 100, '2004-06-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (13, 3, 1, 'Byrokracia 1', 'processed', 8, 3, '2004-06-21');
    
    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (14, 3, 1, 'Byrokracia 2', 'scheduled', 8, 0, '2004-06-23');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (15, 3, 1, 'Sťahovanie', 'scheduled', 50, 0, '2004-07-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (16, 3, 1, 'Maľovanie', 'scheduled', 24, 0, '2004-07-07');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (17, 3, 3, 'Upratovanie', 'scheduled', 8, 0, '2004-07-08');

insert into taskmng_projects (id, customer_id, name, state, started, finished)
values (4, 4, 'Nejaký projekt', 'processed', '2004-01-01', NULL);

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (18, 4, 1, 'Nejaká úloha 1', 'scheduled', 8, 0, '2004-12-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (19, 4, 2, 'Nejaká úloha 2', 'processed', 8, 30, '2004-10-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (20, 4, 3, 'Nejaká úloha 3', 'deferred', 8, 40, '2004-08-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (21, 4, 4, 'Nejaká úloha 4', 'waiting-task', 8, 50, '2004-07-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (22, 4, 5 /* purpously!! */, 'Nejaká úloha 5', 'waiting-customer', 8, 60, '2004-06-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (23, 4, 1, 'Nejaká úloha 5', 'done', 8, 100, '2004-05-01');

    insert into taskmng_tasks (id, project_id, user_id, name, state, duration, percentage, deadline)
    values (24, 4, 2, 'Nejaká úloha 6', 'abandoned', 8, 83, '2004-04-01');