insert into employees values(
    '1','Smith', 'Josh',      'Josh',
    '04/03/1996','m','US, Colorado',             'Freedom street',  '123456'
);
insert into employees values(
    '2','Wasley', 'Paul',     'Paul',
    '05/04/1990','m','Russia, Moscow',           'Mira street',     '654321'
);
insert into employees values(
    '3','Ivanov', 'Ivan',     'Ivanovish',
    '10/04/1980','m','Russia, Omsk',             '1 street',        '65432221'
);
insert into employees values(
    '4','Potter', 'Harry',    'James',
    '31/07/1976','m','UK, Godrics Hollow',       'Poderic alley',   '792400'
);
insert into employees values(
    '5','Maslova','Ekaterina','Nikolaevna',
    '31/10/1983','f','Russia, Saint-Petersburg', 'Vyasemsky street','9992232'
);
insert into employees values(
    '6','Tinny',  'Piter',   'John',
    '2/02/1992', 'm','Australia, Sidney',        'Widow steet',     '152349'
);
insert into employees values(
    '7', 'Yon',   'Yonson',  'Immanuel',
    '10/03/1986','m','US, Wisconsin',            'Lumber street',   '1947352'
);
insert into employees values(
    '8', 'Luthien', 'Tinuviel', 'Melian',
    '08/01/1990', 'f', 'UK, Sussex',             'Doriath alley',   '9432413'
);



insert into departments values(
    '1','Softeware Engineering','SoE','111'
);
insert into departments values(
    '2','User Design',          'UD', '222'
);
insert into departments values(
    '3','Web Developing',       'WD', '333'
);
insert into departments values(
    '4','Management',           'MA', '444'
);
-


insert into positions values(
    '1', 'System Engineer',         'SyE'
);
insert into positions values(
    '2', 'Software Engineer',       'SoE'
);
insert into positions values(
    '3', 'UX Desiner',              'UXD'
);
insert into positions values(
    '4', 'UI Desiner',              'UID'
);
insert into positions values(
    '5', 'Web Developer',           'WD'
);
insert into positions values(
    '6', 'Web Interface Developer', 'WID'
);
insert into positions values(
    '7', 'Staf Manager',            'SM'
);
-- Show it.

-- Insert states.
insert into states values(
    '1','Working',                          'W'
);
insert into states values(
    '2','Fired',                            'F'
);
insert into states values(
    '3','Transferred to another positions',  'TP'
);
insert into states values(
    '4','Transferred to another departments','TD'
);



insert into emp_departments values(
    '1', '1', '1', '30-09-2009'
);
insert into emp_departments values(
    '2', '2', '2', '13-10-2009'
);
insert into emp_departments values(
    '3', '3', '1', '14-10-2009'
);
insert into emp_departments values(
    '4', '4', '2', '14-10-2009'
);
insert into emp_departments values(
    '5', '5', '3', '15-12-2009'
);
insert into emp_departments values(
    '6', '5', '3', '20-12-2009'
);
insert into emp_departments values(
    '7', '5', '4', '12-01-2010'
);
insert into emp_departments values(
    '8', '6', '3', '12-01-2010'
);
insert into emp_departments values(
    '9', '7', '3', '12-01-2010'
);
insert into emp_departments values(
    '10', '8', '1', '13-02-2010'
);
insert into emp_departments values(
    '11', '1', '1', '01-04-2015'
);




insert into emp_work_ranges values(
    '1', '1', '20-09-2010', NULL
);
insert into emp_work_ranges values(
    '2', '2', '20-09-2010', NULL
); 
insert into emp_work_ranges values(
    '3', '3', '10-02-2005', NULL
); 
insert into emp_work_ranges values(
    '4', '5', '10-01-2009', '01-10-2014'
);
insert into emp_work_ranges values(
    '5', '6', '9-12-2007',  NULL
);
insert into emp_work_ranges values(
    '6', '4', '4-02-2011',  NULL
);
insert into emp_work_ranges values(
    '7', '7', '7-12-2010',  NULL
);
insert into emp_work_ranges values(
    '8', '8', '20-11-2011', NULL
);


insert into emp_positions values(
    '1', '1', '2', '30-09-2009'
);
insert into emp_positions values(
    '2', '2', '1', '13-10-2009'
);
insert into emp_positions values(
    '3', '3', '5', '14-10-2009'
);
insert into emp_positions values(
    '4', '4', '7', '14-10-2009'
);
insert into emp_positions values(
    '5', '5', '3', '15-12-2009'
);
insert into emp_positions values(
    '6', '6', '2', '12-01-2010'
);
insert into emp_positions values(
    '7', '7', '4', '12-01-2010'
);
insert into emp_positions values(
    '8', '8', '6', '13-02-2010'
);
insert into emp_positions values(
    '9', '5', '3', '20-12-2009'
);
insert into emp_positions values(
    '10', '5', '7', '12-01-2010'
);
insert into emp_positions values(
    '11', '1', '2', '01-04-2015'
);

insert into emp_states values(
    '1', '1', '1', '15-03-2011','', 'Hate him.'
);
insert into emp_states values(
    '2', '2', '1', '15-04-2012','', 'Google man.'
);
insert into emp_states values(
    '3', '3', '1', '13-10-2012','', 'Good person. Suppose.'
);
insert into emp_states values(
    '4', '4', '1', '13-09-2015','', 'Have never seen him.'
);
insert into emp_states values(
    '5', '5', '2', '01-11-2014','', 'Not so smart. Decrease salary'
);
insert into emp_states values(
    '6', '6', '4', '22-12-2015','', 'Kill him.'
);
insert into emp_states values(
    '7', '7', '4', '22-11-2014','', 'Must not tell lies.'
);
insert into emp_states values(
    '8', '8', '3', '01-03-2015','', 'TODO: fire.'
);
insert into emp_states values(
    '9', '5', '4', '20-12-2009','Web Developing', 'Monkey'
);
insert into emp_states values(
    '10', '5', '3', '12-01-2010','Staf Manager', 'Good slave!'
);
insert into emp_states values(
    '11', '1', '3', '01-04-2015','Software Engineer', 'Bad boy'
);
