PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "users"(
                "users_id" INTEGER PRIMARY KEY AUTOINCREMENT,
                "uid" INTEGER,
                "login" VARCHAR(50),
                "password" CHARACTER(128) DEFAULT '',
                "oauth" CHARACTER(128) DEFAULT '',
                "fullname" VARCHAR(255),
                "loghash" CHARACTER(128) DEFAULT ''
            );
INSERT INTO users VALUES(1,0,'admin','0f982d8560a15d4a3d180f209b109777ab175a2260f68ee969664622422ac73b052dc89049b87f548f09a3b497aed237f10021ca8c8bc98324ece8edec38b6bd','2ba6a7a84df3002988544771d4b716240a2e88bdd229532ce45323f2bcfe5db062291fadfcd3917130a893aa2682be4bf9150369b86138d9a6520d838708f27c','admin','2fd05ec390bcb7a237b64f4e3718ab1a377df4564a31fa7e0de44442a8c06e08940aaf6b1f17a5b052f14084aa7642b08942103857ac7e2a908ac183d15c51a8');
INSERT INTO users VALUES(2,462,'cingrova','4a6702da992dccd4f6ee2c028b80a86298303648d7464f65fab2a41bdeda27f54992c50ff59237335f2035d26b011f3de327b8a6a2703e7dee3b002277f8ba68','8c29a435f791466f21a76542dc0ce1aa2ca4574d40d5a3def3c0675b0f402e99222e4b077dea7fe130924a3c797fe1c9edb7e1311f34821b651e7dfaa9e47536','Jitka Cingrová','');
INSERT INTO users VALUES(3,641,'koptova','948be5a6e854ac3b3bd93bec4b6678fc8bbe9384456f620d5cb88306d425d4913ce1cfc8f9ea09445b7a8e4d2a09e26456f22bfc895b006cc8d264992b5a36af','323860ba576c748a95728d7cf397a2d108802fca9307945f35eb43d86ea6ae71e550c1dfad74225be3afafce66372cedb0d17269ad30a0cfe75fa430d868b79e','Martina Koptová','a9a542d766fe2a2b4b8f3ed1c1151340622623b5b10637c30c8b58f1dbf0e4e10427e41a128eb3ea2bbb3e9ad59ee94faa36964e25e4873dad0e6c722c52c21b');
INSERT INTO users VALUES(4,233,'adamkova','aba728d8327ae70e5cad7bff32a0d2b06522b9024eb4d9a8446b2e67d3b770e6849c1bd21510429f65159fe63d75053e4e8c472ac0e5c0e63e8a6b240c829b0d','e5baae8fe19fd1e6efa9cbe104ce8e620fc8a72675f75d62b81381993627320759c4866a22826292fb8d4fd1f10bb5ed78a4ec3aa9d804d746a7864100f3883c','Ing. Dana Adámková','');
INSERT INTO users VALUES(5,627,'zajickova','89a450fb6085b8f019571191b0668ee6c1e66a0c4e022836151fe87dafe625821650acdba1bb910949532bfb636a1ae8247e728a09a3b2038786387dd17c67a7','89a450fb6085b8f019571191b0668ee6c1e66a0c4e022836151fe87dafe625821650acdba1bb910949532bfb636a1ae8247e728a09a3b2038786387dd17c67a7','Martina Zajíčková','f969c400371309f82794f3d65cf56d7de65444bb7cfb4fc4047a703c49c49069605cde30eec9bc7c503b8e44e18abccef6f169a92e4a1a5f1eb939fd894ee8bb');
INSERT INTO users VALUES(6,135,'zuzankova','56ffb80201eb8b85032d78c9af856cb09294a5e4fc897b9ba5378e9e9a675f6c2c232846f016e04f97937d700e2a0e96a2545d4777669e9cc7baf09f588b79dc','dfe81c9f278ca4a53ec0f1e2efd95864ef0daf7702de8aa87349bccfaf31711e1916cb674dfc5e68a0ed4898db527abb6375a94a32ca7a76022d0c96a9628ff6','Jana Zuzánková','8087ff4b7123c2efcf68b93b8e1a2cdcdc45bad95fcb5f702da1a53a4d60235739e71ed017be5cde8bdbc60b653b3ac2da102e5d9c4663961f3efe8ed23d0662');
INSERT INTO users VALUES(7,530,'kalinova','c419ad682bd474da1992fd8a1cc4a0c7a980a6562abea1250a3d537fc677b2c4d7e0e3397151deae24fd7b0833dd77c2b7c6bce22854e6a49243ecc21b3ac0ce','49bbfb9d8418ff8ee4c03598f361f7d3b78da0ebb10b3df13af0e8904dec7c8dd05a19be6b37d2576cfaf9f7511736cf4b54f29eb69548bce0928d22742fc136','Iveta Kalinová','0b4a90ed819ffd8a3ba39026f0d3fe83957aeaca52f0ed90e09467b3c728e9d9e22f64be7d62f7e70942a0e844e3ab42d589dc7e8f5d874c36d27d8ec77c2118');
CREATE TABLE IF NOT EXISTS "roles"(
                "roles_id" INTEGER PRIMARY KEY AUTOINCREMENT,
                "code" VARCHAR(10),
                "title" VARCHAR(150)
            );
INSERT INTO roles VALUES(1,'ADMIN','Správce');
INSERT INTO roles VALUES(2,'HMU','Hlavní mzdová účetní');
INSERT INTO roles VALUES(3,'LEAD','Vedoucí pobočky/dílny');
INSERT INTO roles VALUES(4,'PRAC','Pracovník');
CREATE TABLE IF NOT EXISTS "users_roles"(
                "users_id" INTEGER NOT NULL,
                "roles_id" INTEGER NOT NULL
            );
INSERT INTO users_roles VALUES(1,1);
INSERT INTO users_roles VALUES(2,2);
INSERT INTO users_roles VALUES(2,1);
INSERT INTO users_roles VALUES(3,3);
INSERT INTO users_roles VALUES(4,3);
INSERT INTO users_roles VALUES(6,3);
INSERT INTO users_roles VALUES(5,3);
INSERT INTO users_roles VALUES(7,3);
CREATE TABLE IF NOT EXISTS "utv"(
                "utvar_id" INTEGER PRIMARY KEY AUTOINCREMENT,
                "utvar" INTEGER,
                "zapl" CHARACTER(10),
                "kopl" CHARACTER(10),
                "utvart" VARCHAR(120)
            );
INSERT INTO utv VALUES(3,20,NULL,NULL,'Provozovna Osek');
INSERT INTO utv VALUES(4,50,NULL,NULL,'Provozovna Sobědruhy');
INSERT INTO utv VALUES(5,70,NULL,NULL,'provozovna Neštěmice');
CREATE TABLE IF NOT EXISTS "user_utv"(
                "id_users" INTEGER NOT NULL,
                "utvar" INTEGER NOT NULL
            );
INSERT INTO user_utv VALUES(3,20);
INSERT INTO user_utv VALUES(5,70);
INSERT INTO user_utv VALUES(4,70);
INSERT INTO user_utv VALUES(6,50);
INSERT INTO user_utv VALUES(7,20);
CREATE TABLE IF NOT EXISTS "prac"(
                "oscis" INTEGER NOT NULL,
                "cicin" INTEGER DEFAULT 0,
                "utvar" INTEGER,
                "prijm" VARCHAR(255),
                "tarif" float
            );
INSERT INTO prac VALUES(12,0,12,'Seidlová Zdeňka',0.0);
INSERT INTO prac VALUES(27,0,20,'Faladová Petra',0.0);
INSERT INTO prac VALUES(46,0,20,'Faladová Alena',0.0);
INSERT INTO prac VALUES(62,0,70,'Lukešová Dana',0.0);
INSERT INTO prac VALUES(63,0,70,'Matoušová Naděžda',0.0);
INSERT INTO prac VALUES(72,0,70,'Pulchartová Jana',0.0);
INSERT INTO prac VALUES(135,0,50,'Zuzánková Jana',0.0);
INSERT INTO prac VALUES(257,0,70,'Prokopová Rúžena',0.0);
INSERT INTO prac VALUES(280,0,70,'Hálová Jitka',0.0);
INSERT INTO prac VALUES(284,0,70,'Taufnerová Růžena',0.0);
INSERT INTO prac VALUES(317,0,80,'Zelenková Václava',0.0);
INSERT INTO prac VALUES(322,0,12,'Adámková Dana',0.0);
INSERT INTO prac VALUES(382,0,70,'Polák Lukáš',0.0);
INSERT INTO prac VALUES(409,0,12,'Bálková Jitka',0.0);
INSERT INTO prac VALUES(421,0,12,'Lesayová Věra',0.0);
INSERT INTO prac VALUES(462,0,12,'Cingrová Jitka',0.0);
INSERT INTO prac VALUES(476,0,50,'Mišáková Lenka',0.0);
INSERT INTO prac VALUES(477,0,50,'Cachová Naděžda',0.0);
INSERT INTO prac VALUES(480,0,50,'Vacková Jana',0.0);
INSERT INTO prac VALUES(486,0,20,'Hoyer Lukáš',0.0);
INSERT INTO prac VALUES(489,0,12,'Vlasáková Iva',0.0);
INSERT INTO prac VALUES(499,0,50,'Vránová Jana',0.0);
INSERT INTO prac VALUES(502,0,70,'Vlček Marek',0.0);
INSERT INTO prac VALUES(515,0,70,'Kmoníčková Ivana',0.0);
INSERT INTO prac VALUES(530,0,20,'Kalinová Iveta',0.0);
INSERT INTO prac VALUES(550,0,50,'Vrbová Brigita',0.0);
INSERT INTO prac VALUES(551,0,20,'Čech Stanislav',0.0);
INSERT INTO prac VALUES(565,0,20,'Čechová Jitka',0.0);
INSERT INTO prac VALUES(568,0,70,'Kostková Michaela',0.0);
INSERT INTO prac VALUES(579,0,20,'Balogh Jiří',0.0);
INSERT INTO prac VALUES(614,0,70,'Pšenička Petr',0.0);
INSERT INTO prac VALUES(623,0,70,'Pavlata Jindřich',0.0);
INSERT INTO prac VALUES(627,0,70,'Zajíčková Martina',0.0);
INSERT INTO prac VALUES(641,0,12,'Koptová Martina',0.0);
INSERT INTO prac VALUES(648,0,50,'Spěšná Vlasta',0.0);
INSERT INTO prac VALUES(655,0,20,'Švarc Rudolf',0.0);
INSERT INTO prac VALUES(662,0,70,'Jirák Pavel',0.0);
INSERT INTO prac VALUES(666,0,70,'Vrbová Věra',0.0);
INSERT INTO prac VALUES(679,0,70,'Marková Monika',0.0);
INSERT INTO prac VALUES(687,0,70,'Svádová Markéta',0.0);
INSERT INTO prac VALUES(696,0,70,'Jirkovský Martin',0.0);
INSERT INTO prac VALUES(744,0,70,'Thiemová Lenka',0.0);
INSERT INTO prac VALUES(745,0,70,'Löblová Andrea',0.0);
INSERT INTO prac VALUES(745,1,70,'Löblová Andrea',1.0);
INSERT INTO prac VALUES(746,0,70,'Hálek Václav',0.0);
INSERT INTO prac VALUES(756,0,13,'Bálek Walter',0.0);
INSERT INTO prac VALUES(759,0,70,'Vázlerová Eva',0.0);
INSERT INTO prac VALUES(774,0,50,'Bláha Čeněk',0.0);
INSERT INTO prac VALUES(775,0,20,'Kufel Jiří',0.0);
INSERT INTO prac VALUES(781,0,70,'Patsar Alla',0.0);
INSERT INTO prac VALUES(782,0,70,'Šimonková Petra',0.0);
INSERT INTO prac VALUES(783,0,70,'Koptová Eva',0.0);
INSERT INTO prac VALUES(785,0,20,'Güntnerová Petra',0.0);
INSERT INTO prac VALUES(790,0,70,'Löbl Libor',0.0);
INSERT INTO prac VALUES(793,0,70,'Vošický Josef',0.0);
INSERT INTO prac VALUES(794,0,20,'Pokoš Jan',0.0);
CREATE TABLE IF NOT EXISTS "todm"(
                "kod" INTEGER NOT NULL,
                "zapl" CHARACTER(10),
                "kopl" CHARACTER(10),
                "sazba" FLOAT,
                "sazbap" FLOAT,
                "kodt" VARCHAR(50)
            );
INSERT INTO todm VALUES(1,'2014-01-01 00:00:00',NULL,0.0,100.0,'Základní mzda časová');
INSERT INTO todm VALUES(2,'2014-01-01 00:00:00',NULL,0.0,100.0,'Práce nad úvazek');
INSERT INTO todm VALUES(3,'2014-01-01 00:00:00',NULL,0.0,100.0,'Práce přesčas v časové mzdě bez příplatku');
INSERT INTO todm VALUES(4,'2014-01-01 00:00:00',NULL,0.0,100.0,'Práce přesčas v časové mzdě s příplatkem 25 %');
INSERT INTO todm VALUES(5,'2014-01-01 00:00:00',NULL,0.0,100.0,'Práce přesčas v časové mzdě s příplatkem 50 %');
INSERT INTO todm VALUES(6,'2014-01-01 00:00:00',NULL,0.0,100.0,'Práce přesčas v časové mzdě s příplatkem -jiné%');
INSERT INTO todm VALUES(8,'2014-01-01 00:00:00',NULL,0.0,0.0,'Mzda ve výši průměrného výdělku');
INSERT INTO todm VALUES(10,'2014-01-01 00:00:00',NULL,0.0,100.0,'Základní úkolová mzda');
INSERT INTO todm VALUES(11,'2014-01-01 00:00:00',NULL,0.0,100.0,'Základní úkolová mzda akordní');
INSERT INTO todm VALUES(12,'2014-01-01 00:00:00',NULL,0.0,100.0,'Náhradní volno za práci ve svátek');
INSERT INTO todm VALUES(14,'2014-01-01 00:00:00',NULL,0.0,100.0,'Přesč.hod.u mzdy sjedn.s přihl. k práci přesčas');
INSERT INTO todm VALUES(15,'2014-01-01 00:00:00',NULL,0.0,100.0,'Základní podílová mzda zadaná částkou');
INSERT INTO todm VALUES(20,'2014-01-01 00:00:00',NULL,0.0,100.0,'Časová složka smíšené mzdy podílové');
INSERT INTO todm VALUES(21,'2014-01-01 00:00:00',NULL,0.0,100.0,'Podílová složka smíšené mzdy podílové');
INSERT INTO todm VALUES(25,'2014-01-01 00:00:00',NULL,0.0,100.0,'Časová složka smíšené mzdy úkolové');
INSERT INTO todm VALUES(26,'2014-01-01 00:00:00',NULL,0.0,100.0,'Úkolová složka smíšené mzdy úkolové');
INSERT INTO todm VALUES(30,'2014-01-01 00:00:00',NULL,0.0,25.0,'Příplatek za práci přesčas 25% z prům. výdělku');
INSERT INTO todm VALUES(31,'2014-01-01 00:00:00',NULL,0.0,50.0,'Příplatek za práci přesčas 50% z prům. výdělku');
INSERT INTO todm VALUES(33,'2014-01-01 00:00:00',NULL,0.0,0.0,'Příplatek za přesčas jiné % z prům. výdělku');
INSERT INTO todm VALUES(35,'2014-01-01 00:00:00',NULL,0.0,25.0,'Příplatek za práci v SO+NE 25% z Pv,§126 ZP');
INSERT INTO todm VALUES(36,'2014-01-01 00:00:00',NULL,0.0,10.0,'Příplatek za práci v SO+NE 10% z PV,§118 ZP');
INSERT INTO todm VALUES(38,'2014-01-01 00:00:00',NULL,0.0,100.0,'Příplatek za práci ve svátek');
INSERT INTO todm VALUES(42,'2014-01-01 00:00:00',NULL,0.0,100.0,'Přípl.za ztíž.prostř.v Kč/hod.nejm.10%MM,§117 ZP');
INSERT INTO todm VALUES(43,'2024-01-01 00:00:00',NULL,12.0,100.0,'Přípl za ztíž.prostř.v % z MM,§117 ZP');
INSERT INTO todm VALUES(44,'2014-01-01 00:00:00',NULL,6.0,100.0,'Zvláštní mimořádný přípl. za stíž. prostř.');
INSERT INTO todm VALUES(49,'2014-01-01 00:00:00',NULL,0.0,20.0,'Příplatek za práci v noci 20% z prům. výd,§125 ZP');
INSERT INTO todm VALUES(50,'2014-01-01 00:00:00',NULL,0.0,10.0,'Přípl. za pr. v noci v Kč /hod.nejm. 10% PV,§116 Z');
INSERT INTO todm VALUES(51,'2014-01-01 00:00:00',NULL,4.0,100.0,'Příplatek za práci ve směnách 4 Kčs/hod.');
INSERT INTO todm VALUES(53,'2014-01-01 00:00:00',NULL,0.0,10.0,'Přípl. za pr. v noci  10% PV,§116 ZP');
INSERT INTO todm VALUES(54,'2014-01-01 00:00:00',NULL,0.0,100.0,'Příplatek za vedení');
INSERT INTO todm VALUES(68,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odm.za  poh.mimo prac.v Kč/hod.nejm.10% Pv §140');
INSERT INTO todm VALUES(69,'2014-01-01 00:00:00',NULL,0.0,10.0,'Odměna za pohot. mimo prac.10% z Pv ,§140 ZP');
INSERT INTO todm VALUES(70,'2014-01-01 00:00:00',NULL,0.0,100.0,'Prémie z nákladů měsíční k časové mzdě');
INSERT INTO todm VALUES(71,'2014-01-01 00:00:00',NULL,0.0,100.0,'Prémie z nákladů měsíční k úkolové mzdě');
INSERT INTO todm VALUES(72,'2014-01-01 00:00:00',NULL,0.0,100.0,'Prémie z nákladů za hospodářské výsledky');
INSERT INTO todm VALUES(73,'2014-01-01 00:00:00',NULL,0.0,0.0,'Prémie z nákladů měsíční def. % z dosažené mzdy');
INSERT INTO todm VALUES(77,'2014-01-01 00:00:00',NULL,0.0,100.0,'Prémie z nákladů čtvrtletní');
INSERT INTO todm VALUES(78,'2014-01-01 00:00:00',NULL,0.0,0.0,'Prémie z nákladů čtvrtletní def.% z dosažené mzdy');
INSERT INTO todm VALUES(80,'2014-01-01 00:00:00',NULL,0.0,100.0,'Prémie z fondu odměn měsíční k časové mzdě');
INSERT INTO todm VALUES(81,'2014-01-01 00:00:00',NULL,0.0,100.0,'Prémie z fondu odměn měsíční k úkolové mzdě');
INSERT INTO todm VALUES(82,'2014-01-01 00:00:00',NULL,0.0,100.0,'Prémie z fondu odměn za hospodářské výsledky');
INSERT INTO todm VALUES(83,'2014-01-01 00:00:00',NULL,0.0,0.0,'Prémie z fondu odměn měsíční def. % z dosaž. mzdy');
INSERT INTO todm VALUES(87,'2014-01-01 00:00:00',NULL,0.0,100.0,'Prémie z fondu odměn čtvrtletní');
INSERT INTO todm VALUES(88,'2014-01-01 00:00:00',NULL,0.0,0.0,'Prémie z fondu odměn čtvrt. def. % z dosaž. mzdy');
INSERT INTO todm VALUES(90,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z nákladů výkonnostní');
INSERT INTO todm VALUES(91,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z nákladů mimořádné');
INSERT INTO todm VALUES(92,'2014-01-01 00:00:00',NULL,0.0,100.0,'13.plat');
INSERT INTO todm VALUES(93,'2014-01-01 00:00:00',NULL,0.0,100.0,'mimořádná odměna za splnění exportu');
INSERT INTO todm VALUES(94,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z nákladů z fondu mistra');
INSERT INTO todm VALUES(95,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z nákladů z fondu vedoucího');
INSERT INTO todm VALUES(97,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z nákladů mimořádné - funkční');
INSERT INTO todm VALUES(98,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměn důchodci po lr.od skončení zaměstnání');
INSERT INTO todm VALUES(100,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z fondu odměn výkonnostní');
INSERT INTO todm VALUES(101,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z fondu odměn mimořádné');
INSERT INTO todm VALUES(103,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny členům zast. při skončení funkčního období');
INSERT INTO todm VALUES(104,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z fondu odměn z fondu mistra');
INSERT INTO todm VALUES(105,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z fondu odměn z fondu vedoucího');
INSERT INTO todm VALUES(107,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z fondu odměn k ostatním výročím');
INSERT INTO todm VALUES(108,'2014-01-01 00:00:00',NULL,0.0,100.0,'Stabilizační odměny');
INSERT INTO todm VALUES(109,'2014-01-01 00:00:00',NULL,0.0,100.0,'Rozdíl mezi zúčtov.a plnou cenou výrobku,služby.');
INSERT INTO todm VALUES(111,'2014-01-01 00:00:00',NULL,0.0,100.0,'Podíly');
INSERT INTO todm VALUES(112,'2014-01-01 00:00:00',NULL,0.0,100.0,'Podíl z personifikace');
INSERT INTO todm VALUES(113,'2014-01-01 00:00:00',NULL,0.0,100.0,'Podíl z transformace');
INSERT INTO todm VALUES(114,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odm. čl. stat. a kol.orgánů-nepovinné čl.,rezident');
INSERT INTO todm VALUES(115,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny z OON za práci v dohodě o prac. činnosti');
INSERT INTO todm VALUES(116,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odm. čl. stat., kol.orgánů-nepovinné čl., nerezid.');
INSERT INTO todm VALUES(118,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměna prokuristy mimo PPV');
INSERT INTO todm VALUES(119,'2014-01-01 00:00:00',NULL,0.0,100.0,'Dohoda o provedení práce zadaná odpracovanými hod.');
INSERT INTO todm VALUES(120,'2014-01-01 00:00:00',NULL,0.0,100.0,'Dohoda o provedení práce - celková částka');
INSERT INTO todm VALUES(121,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odm. za vynálezy, ZN - nesouvisí s výkonem zaměst.');
INSERT INTO todm VALUES(123,'2014-01-01 00:00:00',NULL,0.0,100.0,'Svědečné');
INSERT INTO todm VALUES(124,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměna příkazníka, úplata mandatáře');
INSERT INTO todm VALUES(125,'2014-01-01 00:00:00',NULL,0.0,100.0,'Naturální požitky kromě naturální mzdy');
INSERT INTO todm VALUES(127,'2014-01-01 00:00:00',NULL,0.0,100.0,'Peněžní plnění z FKSP 50let.odchod do důchodu');
INSERT INTO todm VALUES(128,'2014-01-01 00:00:00',NULL,0.0,100.0,'Peněžní plnění z FKSP k vypl. a zdaň.');
INSERT INTO todm VALUES(130,'2014-01-01 00:00:00',NULL,0.0,100.0,'Částky nezahrn. do mzd. prostředku-stipendium');
INSERT INTO todm VALUES(131,'2014-01-01 00:00:00',NULL,0.0,100.0,'Částky nezahrn. do mzd. prostředku-cestovné');
INSERT INTO todm VALUES(132,'2014-01-01 00:00:00',NULL,0.0,100.0,'Částky nezahrn. do mzd. prostředku-jiné');
INSERT INTO todm VALUES(133,'2014-01-01 00:00:00',NULL,0.0,100.0,'Stipendium nezdaněné');
INSERT INTO todm VALUES(134,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odm. žáků/studentů za pr. čin. - §122 škol. zákona');
INSERT INTO todm VALUES(135,'2014-01-01 00:00:00',NULL,0.0,100.0,'Částka cestovného přesahující limit');
INSERT INTO todm VALUES(136,'2014-01-01 00:00:00',NULL,0.0,100.0,'Jiné náhrady výdajů.podléhající  dani');
INSERT INTO todm VALUES(137,'2014-01-01 00:00:00',NULL,0.0,100.0,'Jiné náhrady výdajů podléh. dani z příjmu');
INSERT INTO todm VALUES(138,'2014-01-01 00:00:00',NULL,0.0,100.0,'Jiná nepeněžní plnění podléhající dani');
INSERT INTO todm VALUES(146,'2024-01-01 00:00:00',NULL,0.0,100.0,'Stravenkový paušál osvobozený');
INSERT INTO todm VALUES(147,'2024-01-01 00:00:00',NULL,0.0,100.0,'Stravenkový paušál zdaněný');
INSERT INTO todm VALUES(156,'2023-10-01 00:00:00',NULL,0.0,100.0,'DPČ - Příplatek za práci ve svátek');
INSERT INTO todm VALUES(164,'2023-10-01 00:00:00',NULL,0.0,10.0,'DPČ - Příplatek za práci v SO+NE 10 % z PV');
INSERT INTO todm VALUES(165,'2023-10-01 00:00:00',NULL,0.0,100.0,'DPČ - Přípl. za pr. v noci v Kč/hod.,nejm.10% PV');
INSERT INTO todm VALUES(169,'2023-10-01 00:00:00',NULL,0.0,100.0,'DPČ - Přípl. za ztíž. prostř.v Kč/hod.nejm.10%MM');
INSERT INTO todm VALUES(170,'2024-01-01 00:00:00',NULL,0.0,100.0,'Stravenky - příspěvek zaměstnavatele osvobozený');
INSERT INTO todm VALUES(171,'2024-01-01 00:00:00',NULL,0.0,100.0,'FKSP - rekreace');
INSERT INTO todm VALUES(172,'2024-01-01 00:00:00',NULL,0.0,100.0,'Stravenky - příspěvek zaměstnavatele zdaněný');
INSERT INTO todm VALUES(174,'2024-01-01 00:00:00',NULL,0.0,100.0,'Stravování na pracovišti osvobozené');
INSERT INTO todm VALUES(175,'2023-10-01 00:00:00',NULL,0.0,100.0,'Odměna z OON za práci v  DPČ  - celkem Kč');
INSERT INTO todm VALUES(178,'2014-01-01 00:00:00',NULL,0.0,100.0,'FKSP - sociální výpomoc (živelní p.)- zdaněná část');
INSERT INTO todm VALUES(179,'2014-01-01 00:00:00',NULL,0.0,100.0,'FKSP - sociální výpomoc (živelní p.) - osvob. část');
INSERT INTO todm VALUES(180,'2024-01-01 00:00:00',NULL,0.0,100.0,'FKSP - kultur., sport., vzděl. a zdrav. zařízení');
INSERT INTO todm VALUES(181,'2024-01-01 00:00:00',NULL,0.0,100.0,'Stravování na pracovišti zdaněné');
INSERT INTO todm VALUES(184,'2024-01-01 00:00:00',NULL,0.0,100.0,'FKSP - nepeněžní plnění podléhající dani');
INSERT INTO todm VALUES(186,'2024-01-01 00:00:00',NULL,0.0,100.0,'FKSP-nepeněžní plnění osvobozené od daně');
INSERT INTO todm VALUES(187,'2023-10-01 00:00:00',NULL,0.0,100.0,'DPP - Příplatek za práci ve svátek');
INSERT INTO todm VALUES(188,'2023-10-01 00:00:00',NULL,0.0,10.0,'DPP - Příplatek za práci v SO+NE 10 % z PV');
INSERT INTO todm VALUES(189,'2023-10-01 00:00:00',NULL,0.0,100.0,'DPP - Přípl. za pr. v noci v Kč/hod.,nejm.10% PV');
INSERT INTO todm VALUES(190,'2014-01-01 00:00:00',NULL,0.0,100.0,'Náhrada ztráty výdělku při pracovním úrazu');
INSERT INTO todm VALUES(191,'2023-10-01 00:00:00',NULL,0.0,100.0,'DPP - Přípl. za ztíž. prostř.v Kč/hod.nejm.10%MM');
INSERT INTO todm VALUES(197,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměna člena volební komise');
INSERT INTO todm VALUES(199,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odpracované dny u nepravidelné pracovní doby');
INSERT INTO todm VALUES(200,'2014-01-01 00:00:00',NULL,0.0,100.0,'Základní plat');
INSERT INTO todm VALUES(205,'2014-01-01 00:00:00',NULL,0.0,100.0,'Osobní příplatek (měsíční částka)');
INSERT INTO todm VALUES(206,'2014-01-01 00:00:00',NULL,0.0,100.0,'Osobní příplatek (na hodinu)');
INSERT INTO todm VALUES(210,'2014-01-01 00:00:00',NULL,0.0,100.0,'Paušál příplatku za práci přesčas');
INSERT INTO todm VALUES(211,'2014-01-01 00:00:00',NULL,0.0,100.0,'Paušál přípl. za ztíž. prostř.v kč,nejm10%MM §117');
INSERT INTO todm VALUES(212,'2014-01-01 00:00:00',NULL,0.0,100.0,'Paušál příplatku za vedení čety');
INSERT INTO todm VALUES(214,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odm. čl. stat. a kol.orgánů-nepovinné čl.,rezident');
INSERT INTO todm VALUES(215,'2014-01-01 00:00:00',NULL,0.0,100.0,'Měsíční tarif za práci v dohodě o prac. činnosti');
INSERT INTO todm VALUES(216,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odm. čl. stat., kol.orgánů-nepovinné čl., nerezid.');
INSERT INTO todm VALUES(219,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny neuvolněných zastupitelů');
INSERT INTO todm VALUES(220,'2014-01-01 00:00:00',NULL,0.0,100.0,'Příplatek za vedení');
INSERT INTO todm VALUES(221,'2014-01-01 00:00:00',NULL,0.0,100.0,'Příplatek za zastupování');
INSERT INTO todm VALUES(222,'2014-01-01 00:00:00',NULL,0.0,100.0,'Hodnostní příplatek');
INSERT INTO todm VALUES(223,'2014-01-01 00:00:00',NULL,0.0,100.0,'Zvláštní příplatek');
INSERT INTO todm VALUES(224,'2014-01-01 00:00:00',NULL,0.0,100.0,'Příplatek za ztížené pracovní prostředí §128 ZP');
INSERT INTO todm VALUES(229,'2014-01-01 00:00:00',NULL,0.0,100.0,'Zvláštní přípl., §129 ZP, do zákl.přesč.- směnnost');
INSERT INTO todm VALUES(233,'2014-01-01 00:00:00',NULL,0.0,100.0,'Stipendium nezdaněné trvalé');
INSERT INTO todm VALUES(234,'2014-01-01 00:00:00',NULL,0.0,100.0,'Kapesné žáků trvalé');
INSERT INTO todm VALUES(238,'2014-01-01 00:00:00',NULL,0.0,100.0,'Snížená odměna uvolněných zastupit. za prv. 21d PN');
INSERT INTO todm VALUES(239,'2015-09-01 00:00:00',NULL,0.0,100.0,'Měsíční tarif za práci v dohodě o provedení práce');
INSERT INTO todm VALUES(257,'2015-09-01 00:00:00',NULL,0.0,100.0,'Odměny z OON - DPČ - hodinový tarif');
INSERT INTO todm VALUES(258,'2017-06-01 00:00:00',NULL,0.0,100.0,'Odměny z OON - DPP - hodinový tarif');
INSERT INTO todm VALUES(259,'2014-01-01 00:00:00',NULL,0.0,100.0,'Peněžní odměna ze soc.fondu 50let,SD,ID k zdanění');
INSERT INTO todm VALUES(261,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odměny ze soc. fondu ke zdanění');
INSERT INTO todm VALUES(262,'2014-01-01 00:00:00',NULL,0.0,100.0,'Mot.vozidlo1%vstupní ceny -§6odst.6ZDP');
INSERT INTO todm VALUES(291,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odškodnění prac,úr, poskončení PN');
INSERT INTO todm VALUES(310,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na pojištění dlouhodobé péče');
INSERT INTO todm VALUES(311,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na poj.dlouhodobé péče - osvoboz');
INSERT INTO todm VALUES(312,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na poj.dlouhodobé péče - zdaněný');
INSERT INTO todm VALUES(320,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na dlouhodobý investiční produkt');
INSERT INTO todm VALUES(321,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na dlouhodobý invest.produkt - osvoboz');
INSERT INTO todm VALUES(322,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na dlouhodobý invest.produkt - zdaněný');
INSERT INTO todm VALUES(330,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na penzijní pojištění');
INSERT INTO todm VALUES(331,'2024-01-01 00:00:00',NULL,0.0,100.0,'Penz.poj.-odvod na účet zam.osvoboz');
INSERT INTO todm VALUES(332,'2024-01-01 00:00:00',NULL,0.0,100.0,'Penz.poj.-odvod na účet zam.zdaněný');
INSERT INTO todm VALUES(341,'2014-01-01 00:00:00',NULL,0.0,100.0,'Naturální požitky - automaticky se sráží');
INSERT INTO todm VALUES(350,'2023-12-01 00:00:00',NULL,0.0,100.0,'Příspěvek na doplňkové penzijní spoření');
INSERT INTO todm VALUES(351,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na doplňkové penzijní spoření - od 2024');
INSERT INTO todm VALUES(352,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na doplňkové penzijní spoř. zdaněný 2024');
INSERT INTO todm VALUES(353,'2024-01-01 00:00:00',NULL,0.0,100.0,'Příspěvek na doplňkové penzijní spoř. osvoboz.2024');
INSERT INTO todm VALUES(360,'2014-01-01 00:00:00',NULL,0.0,100.0,'Penz.přip.-odvod na úč.zaměst.');
INSERT INTO todm VALUES(380,'2023-10-01 00:00:00',NULL,0.0,100.0,'Výkon práce/služby z jiného místa');
INSERT INTO todm VALUES(381,'2023-10-01 00:00:00',NULL,0.0,100.0,'Výkon pr./sl. z jiného místa – paušál osvob. část');
INSERT INTO todm VALUES(382,'2023-10-01 00:00:00',NULL,0.0,100.0,'Výkon pr./sl. z jiného místa – paušál podléh. dani');
INSERT INTO todm VALUES(383,'2023-10-01 00:00:00',NULL,0.0,100.0,'Výkon práce/služby z jiného místa  – skut. náklady');
INSERT INTO todm VALUES(384,'2023-12-01 00:00:00',NULL,0.0,100.0,'Příspěvek na doplňkové penzijní spoř. zdaněný');
INSERT INTO todm VALUES(385,'2023-12-01 00:00:00',NULL,0.0,100.0,'Příspěvek na doplňkové penzijní spoř. osvoboz.');
INSERT INTO todm VALUES(386,'2023-12-01 00:00:00',NULL,0.0,100.0,'Penz.přip.-odvod na účet zam.zdaněný');
INSERT INTO todm VALUES(387,'2023-12-01 00:00:00',NULL,0.0,100.0,'Penz.přip.-odvod na účet zam.osvoboz');
INSERT INTO todm VALUES(388,'2023-12-01 00:00:00',NULL,0.0,100.0,'Příspěvek na životní pojištění - zdaněný');
INSERT INTO todm VALUES(389,'2023-12-01 00:00:00',NULL,0.0,100.0,'Příspěvek na životní pojištění - osvoboz');
INSERT INTO todm VALUES(503,'2014-01-01 00:00:00',NULL,0.0,100.0,'Doplatek do průměrného výdělku');
INSERT INTO todm VALUES(507,'2014-01-01 00:00:00',NULL,12.0,100.0,'Doplatek výd. při převed. na jinou práci-prostoje');
INSERT INTO todm VALUES(510,'2014-01-01 00:00:00',NULL,0.0,100.0,'Zůročení vkladů - JEN ke zdanění');
INSERT INTO todm VALUES(511,'2014-01-01 00:00:00',NULL,0.0,100.0,'Zůročení vkladů -  zdanit a vyplatit');
INSERT INTO todm VALUES(569,'2021-01-01 00:00:00',NULL,0.0,100.0,'Odchodné strážníků obec.policie- §8a z.553/91Sb.');
INSERT INTO todm VALUES(570,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odstupné');
INSERT INTO todm VALUES(573,'2014-01-01 00:00:00',NULL,0.0,100.0,'Odchodné ved.zaměstnanců § 29odst.3 ZP');
INSERT INTO todm VALUES(575,'2015-12-01 00:00:00',NULL,0.0,100.0,'Peněžité vyrovnání dle §310 ZP');
INSERT INTO todm VALUES(576,'2014-01-01 00:00:00',NULL,0.0,100.0,'Náhrada mzdy-okamž.zrušení PP zaměstnancem §56 ZP');
INSERT INTO todm VALUES(600,'2014-01-01 00:00:00',NULL,0.0,100.0,'Doplatek do výše minimální mzdy');
INSERT INTO todm VALUES(602,'2014-01-01 00:00:00',NULL,0.0,100.0,'Doplatek do nejnižší úrovně zaručené mzdy');
INSERT INTO todm VALUES(603,'2014-01-01 00:00:00',NULL,0.0,100.0,'Doplatek do výše minimální mzdy z OON');
INSERT INTO todm VALUES(700,'2014-01-01 00:00:00',NULL,0.0,100.0,'Vrácení záporné výplaty');
INSERT INTO todm VALUES(800,'2014-01-01 00:00:00',NULL,0.0,100.0,'Přírůstek náhradního volna za práci přesčas');
INSERT INTO todm VALUES(801,'2014-01-01 00:00:00',NULL,0.0,0.0,'Čerpání náhradního volna za práci přesčas');
INSERT INTO todm VALUES(810,'2023-01-01 00:00:00',NULL,0.0,100.0,'Počet hodin pro vyšší sazbu pojistného');
INSERT INTO todm VALUES(820,'2023-06-01 00:00:00',NULL,0.0,100.0,'Počet hodin pro slevu na pojistném');
CREATE TABLE IF NOT EXISTS "f50"(
                "oscis" INTEGER NOT NULL,
                "cicin" INTEGER NOT NULL,
                "obdz" CHAR(7),
                "kod" INTEGER NOT NULL,
                "odmph" FLOAT,
                "odmcas" FLOAT,
                "odmp" FLOAT,
                "odmnj" FLOAT
            );
CREATE TABLE IF NOT EXISTS "operace"(
                "operace_id" INTEGER NOT NULL,
                "utvar_id" INTEGER NOT NULL,
                "normocas" FLOAT,
                "tarifjed" FLOAT,
                "prostredi" FLOAT,
                "operacet" VARCHAR(150),
                "kododm"  INTEGER NOT NULL DEFAULT 10,
                "genodm" INTEGER DEFAULT NULL
            );
INSERT INTO operace VALUES(1,3,802.99999999999999997,705.99999999999999999,0.0,'Barva 500ml mích.plnění, balení',10,43);
INSERT INTO operace VALUES(2,3,446.99999999999999998,498.0,0.0,'Barva 100ml mích.stroj.pln.balení',10,0);
INSERT INTO operace VALUES(3,3,567.0,498.99999999999999997,0.0,'Barva 100ml.mích.ruč.plnění, balení',10,0);
INSERT INTO operace VALUES(4,3,450.0,391.0,0.0,'Škrobenka 500g stáčení, balení',10,0);
INSERT INTO operace VALUES(5,3,0.0,0.0,0.0,'Škrobenka 1l stroj.plnění, balení',10,0);
INSERT INTO operace VALUES(6,3,1259.9999999999999999,1096.0,0.0,'Škrobenka 1l ruč.plnění, balení',10,0);
INSERT INTO operace VALUES(7,3,584.99999999999999999,505.99999999999999999,0.0,'Aviváž 500g stáčení balení',10,0);
INSERT INTO operace VALUES(8,3,400.0,2000.0,0.0,'Škrobenka 5l stáčení, balení',10,0);
INSERT INTO operace VALUES(9,3,400.0,2000.0,0.0,'Aviváž 5l stáčení, balení',10,0);
INSERT INTO operace VALUES(10,3,800.0,2799.9999999999999999,0.0,'Fóliování MAKRO 5ks včetně plnění',10,0);
INSERT INTO operace VALUES(11,3,25.0,21.5,0.0,'Petardy 20 ks balení',10,0);
INSERT INTO operace VALUES(12,3,55.0,47.299999999999997159,0.0,'Petardy 10 ks balení',10,0);
INSERT INTO operace VALUES(13,3,70.999999999999999999,61.100000000000001419,0.0,'Petardy 5 ks balení /louče/',10,0);
INSERT INTO operace VALUES(14,3,179.99999999999999999,157.0,0.0,'Škrobenka 500ml příprava, míchání',10,0);
INSERT INTO operace VALUES(15,3,300.0,260.99999999999999999,0.0,'Škrobenka 1l příprava, míchání',10,0);
INSERT INTO operace VALUES(16,3,1600.0,3500.0,0.0,'Škrobenka 5l příprava, míchání',10,0);
INSERT INTO operace VALUES(17,3,120.0,103.99999999999999999,0.0,'Aviváž 500ml příprava, míchání',10,0);
INSERT INTO operace VALUES(18,3,1600.0,3500.0,0.0,'Aviváž 5l příprava, míchání',10,0);
INSERT INTO operace VALUES(19,3,450.0,391.0,0.0,'Škrob.P 500g přípr.mích.var.',10,0);
INSERT INTO operace VALUES(20,3,640.0,550.0,0.0,'Škrobenka P stáčení, balení',10,0);
INSERT INTO operace VALUES(21,3,1405.9999999999999999,932.99999999999999999,5.4000000000000003552,'Barva zlatá 35g',10,42);
INSERT INTO operace VALUES(22,3,1035.9999999999999999,686.99999999999999998,5.4000000000000003552,'Barva stříbro 5g',10,0);
INSERT INTO operace VALUES(23,3,1452.9999999999999999,964.00000000000000003,5.4000000000000003552,'Barva stříbro 35g',10,0);
INSERT INTO operace VALUES(24,3,160.0,109.0,0.0,'Šampon 500g příprava, míchání',10,0);
INSERT INTO operace VALUES(25,3,680.00000000000000001,451.00000000000000002,0.0,'Šampon 500g plnění, balení',10,0);
INSERT INTO operace VALUES(26,3,1600.0,1100.0,0.0,'Šampon 5kg příprava, míchání',10,0);
INSERT INTO operace VALUES(27,3,3099.9999999999999999,2099.9999999999999999,0.0,'Šampon 5kg plnění etik.bal.',10,0);
INSERT INTO operace VALUES(28,3,57.630000000000002557,49.600000000000001422,0.0,'Lepení cenovek',10,0);
INSERT INTO operace VALUES(29,3,1090.0,730.99999999999999999,0.0,'Čistící př.přípr.mích.stáč.bal.',10,0);
INSERT INTO operace VALUES(30,3,1405.9999999999999999,932.99999999999999999,5.4000000000000003552,'Práškový škrob přípr.skl.váž.bal.fóliov.',10,0);
INSERT INTO operace VALUES(31,3,74.0,63.600000000000001419,0.0,'Louče 3+3, skl.bal.fólio.et.přípr.kart.',10,0);
INSERT INTO operace VALUES(32,3,400.0,282.99999999999999999,0.0,'Fóliování do svazků',10,0);
INSERT INTO operace VALUES(33,3,25.0,21.5,0.0,'Petardy 20 ks gumička',10,0);
INSERT INTO operace VALUES(34,3,137.99999999999999999,105.99999999999999999,0.0,'Petardy 2x5ks do kompletů - manžeta',10,0);
INSERT INTO operace VALUES(35,3,37.999999999999999999,40.210000000000000854,0.0,'petardy prebal.po 20ti ks',10,0);
INSERT INTO operace VALUES(36,3,1463.0,1647.0,0.0,'Aviváž 2x500 ml fólie vč.plnění, balení',10,0);
INSERT INTO operace VALUES(37,3,2500.0,1647.0,0.0,'Škrobenka P 2x500g Makro vč.př.pln.bal.',10,0);
INSERT INTO operace VALUES(38,3,4409.9999999999999998,2900.0,0.0,'Čistič 1l Makrofólie 2ks',10,0);
INSERT INTO operace VALUES(39,3,889.99999999999999996,696.99999999999999998,0.0,'Škrob S rozprašovač vč.fóliování',10,0);
INSERT INTO operace VALUES(41,3,25.80000000000000071,21.989999999999998436,0.0,'10cm 10 ks do sáčků(špačky)',10,0);
INSERT INTO operace VALUES(42,3,561.99999999999999998,494.0,0.0,'Toalet-míchání, lisování, balení',10,0);
INSERT INTO operace VALUES(43,3,750.0,659.99999999999999999,0.0,'Toalet-náhrada, mích.lis.bal.2ks',10,0);
INSERT INTO operace VALUES(44,3,561.99999999999999998,494.0,0.0,'WC TIP-míchání lisování balení',10,0);
INSERT INTO operace VALUES(45,3,750.0,659.99999999999999999,0.0,'ARO WC TIP Makro(5ks), FIXINELA',10,0);
INSERT INTO operace VALUES(46,3,2799.9999999999999999,2463.9999999999999999,0.0,'PISOÁR kbelíčky-mích, lis, bal.',10,0);
INSERT INTO operace VALUES(47,3,125.0,107.0,0.0,'petardy po 3 ks',10,0);
INSERT INTO operace VALUES(50,3,0.0,0.0,0.0,'',10,0);
INSERT INTO operace VALUES(51,3,10.679999999999999715,9.1999999999999992894,0.0,'17 cm tuzemsko po 25 ks',10,0);
INSERT INTO operace VALUES(52,3,14.060000000000000497,12.099999999999999644,0.0,'17 cm 10 ks do papír. sáčků',10,0);
INSERT INTO operace VALUES(53,3,10.679999999999999715,9.1999999999999992894,0.0,'17 cm exp.po 25 ks do krabičky',10,0);
INSERT INTO operace VALUES(54,3,10.390000000000000568,8.9000000000000003552,0.0,'17 cm exp. 30 ks do krabičky',10,0);
INSERT INTO operace VALUES(55,3,10.119999999999999218,8.6999999999999992894,0.0,'17 cm exp. 40 ks do krabičky',10,0);
INSERT INTO operace VALUES(56,3,16.309999999999998721,13.999999999999999999,0.0,'17 cm 10 ks do pap. sáč.zalepení',10,0);
INSERT INTO operace VALUES(57,3,11.810000000000000497,10.099999999999999644,0.0,'17 cm 20 ks do krabičky',10,0);
INSERT INTO operace VALUES(58,3,7.8700000000000001065,6.7999999999999998223,0.0,'17 cm volně ložené',10,0);
INSERT INTO operace VALUES(59,3,26.440000000000001278,22.699999999999999288,0.0,'17cm, 10ks do sáč.do krab.+Samrok',10,0);
INSERT INTO operace VALUES(60,3,13.369999999999999217,9.4000000000000003552,0.0,'17 cm Betlém 10 ks do krabičky',10,0);
INSERT INTO operace VALUES(61,3,26.440000000000001278,22.699999999999999288,0.0,'17cm-10ks sáč.50sáč.do kr.5kr.do kartonu',10,0);
INSERT INTO operace VALUES(62,3,15.019999999999999573,12.900000000000000355,0.0,'10cm 12ks pap.sáč....10cm vol.100ks gum.',10,0);
INSERT INTO operace VALUES(63,3,18.649999999999998578,16.0,0.0,'10cm-100ks PE sáč.svař.+ SAMROK',10,0);
INSERT INTO operace VALUES(64,3,19.120000000000000994,16.399999999999998578,0.0,'10 cm 20 ks do pap. sáč.',10,0);
INSERT INTO operace VALUES(65,3,13.119999999999999218,11.30000000000000071,0.0,'20 cm 8 ks do pap. sáčků',10,0);
INSERT INTO operace VALUES(66,3,17.999999999999999999,15.499999999999999999,0.0,'20 cm 8 ks do svazků, 100 svaz.do krabic',10,0);
INSERT INTO operace VALUES(67,3,166.28999999999999203,132.30000000000001137,0.0,'50 cm',10,0);
INSERT INTO operace VALUES(69,3,30.929999999999999715,26.600000000000001421,0.0,'Tvary-krabice, karton',10,0);
INSERT INTO operace VALUES(70,3,10.880000000000000781,9.3000000000000007105,0.0,'Tvary-volně',10,0);
INSERT INTO operace VALUES(71,3,10.119999999999999218,8.6999999999999992894,0.0,'16 cm volně do gumičky 100 ks',10,0);
INSERT INTO operace VALUES(72,3,21.370000000000000995,18.399999999999998578,0.0,'18, 20cm 5sáč.24sáč.krab.12kr.karton',10,0);
INSERT INTO operace VALUES(73,3,57.630000000000002557,49.600000000000001422,0.0,'Lepení cenovek',10,0);
INSERT INTO operace VALUES(74,3,57.369999999999997442,49.299999999999997157,0.0,'Skládání krabiček',10,0);
INSERT INTO operace VALUES(75,3,31.140000000000000568,26.800000000000000709,0.0,'27cm-10ks do krab.10kr.gum.10sv.karton',10,0);
INSERT INTO operace VALUES(76,3,18.75,16.100000000000001421,0.0,'28 cm 5 ks do sáčku,  karton',10,0);
INSERT INTO operace VALUES(77,3,41.060000000000002272,35.299999999999997156,0.0,'28cm-5ks sáč.25sáč.do krab.5kr.do karton',10,0);
INSERT INTO operace VALUES(78,3,31.030000000000001136,26.699999999999999289,0.0,'30cm HAKA 10ks do krab.50-100kr karton',10,0);
INSERT INTO operace VALUES(79,3,32.999999999999999999,28.399999999999998578,0.0,'30cm MEDIA 20ks do krab.100kr. karton',10,0);
INSERT INTO operace VALUES(80,3,15.339999999999999857,13.199999999999999289,0.0,'30cm volně ložené,  krab.karton',10,0);
INSERT INTO operace VALUES(81,3,50.0,43.000000000000000001,0.0,'30cm SAMROK 5ks sáč.50sáč.disp.5dis.kart',10,0);
INSERT INTO operace VALUES(82,3,50.0,43.000000000000000001,0.0,'40cm-10ks do krab.30kr. do kartonu',10,0);
INSERT INTO operace VALUES(83,3,60.0,51.600000000000001421,0.0,'40cm-10ks do krab.5ks sv.10sv.kart.folie',10,0);
INSERT INTO operace VALUES(84,3,34.609999999999999432,29.800000000000000711,0.0,'40cm-10ks krab.5kr.sv.10sv.kart.bez fól.',10,0);
INSERT INTO operace VALUES(85,3,32.140000000000000569,27.60000000000000142,0.0,'15cm-8ks do kr.50-100kr.do kartonu',10,0);
INSERT INTO operace VALUES(86,3,52.850000000000001421,45.399999999999998577,0.0,'15cm-8ks do kr.3kr.do sv.30sv.do kartonu',10,0);
INSERT INTO operace VALUES(87,3,90.0,77.400000000000005683,0.0,'70cm-5ks do kr.5kr.gum.10sv.do kart.fól.',10,0);
INSERT INTO operace VALUES(88,3,78.260000000000005115,67.299999999999997159,0.0,'70cm-5ks do kr.5kr.gum.10sv.kart.bez fól',10,0);
INSERT INTO operace VALUES(89,3,247.06000000000000226,217.40000000000000567,0.0,'Bodování a tvarování',10,0);
INSERT INTO operace VALUES(90,3,450.0,313.49999999999999999,0.0,'Ruční bodování USA (5 bodů)',10,0);
INSERT INTO operace VALUES(91,3,247.06000000000000226,172.09999999999999431,0.0,'Tvarování drátu 1',10,0);
INSERT INTO operace VALUES(92,3,32.999999999999999999,28.399999999999998578,0.0,'Samrok 8ks sáč.svařování 100ks displ.kar',10,0);
INSERT INTO operace VALUES(93,3,7.4299999999999997157,6.5999999999999996447,6.0,'snímání vel.tvarú',10,0);
INSERT INTO operace VALUES(94,3,5.2999999999999998223,4.5999999999999996447,0.0,'snímání 10 cm, Anglie',10,0);
INSERT INTO operace VALUES(95,3,29.0,25.499999999999999999,0.0,'mácení 10 cm, Anglie',10,0);
INSERT INTO operace VALUES(101,3,45.0,34.649999999999998578,0.0,'1m-šťouchání krabiček',10,0);
INSERT INTO operace VALUES(103,3,40.999999999999999999,30.780000000000001137,0.0,'1m-ohýbání ruční a strojní',10,0);
INSERT INTO operace VALUES(104,3,95.0,73.120000000000004549,0.0,'1m-balení 3ks/krab.25krab./kart.',10,0);
INSERT INTO operace VALUES(105,3,88.000000000000000001,75.700000000000002842,0.0,'1m-balení 5ks-krab',10,0);
INSERT INTO operace VALUES(106,3,30.0,29.399999999999998578,0.0,'razítkování 10-30 cm',10,0);
INSERT INTO operace VALUES(107,3,60.0,58.700000000000002843,0.0,'razítkování 40cm-1 m',10,0);
INSERT INTO operace VALUES(108,3,45.0,44.0,0.0,'razítkování karacha',10,0);
INSERT INTO operace VALUES(201,3,0.0,120.0,0.0,'Režíjní práce tř.1',1,NULL);
INSERT INTO operace VALUES(202,3,0.0,123.90000000000000568,0.0,'Režíjní práce tř.2',10,0);
INSERT INTO operace VALUES(203,3,0.0,135.30000000000001137,0.0,'Režíjní práce tř.3',10,0);
INSERT INTO operace VALUES(204,3,0.0,147.69999999999998863,0.0,'Režíjní práce tř.4',10,0);
INSERT INTO operace VALUES(205,3,0.0,163.19999999999998863,0.0,'Režíjní práce tř.5',10,0);
INSERT INTO operace VALUES(206,3,0.0,180.09999999999999431,0.0,'Režíjní práce tř.6',10,0);
INSERT INTO operace VALUES(207,3,0.0,0.0,0.0,'Režíjní práce tř.7',10,0);
INSERT INTO operace VALUES(0,5,0.0,0.0,0.0,'',10,0);
INSERT INTO operace VALUES(1,5,1.080000000000000071,1.0,8.5099999999999997868,'Masa 10',10,0);
INSERT INTO operace VALUES(2,5,2.7099999999999999644,2.3999999999999999111,8.5099999999999997868,'Masa 15, 16, 17, 20',10,0);
INSERT INTO operace VALUES(3,5,8.1500000000000003552,7.2999999999999998223,8.5099999999999997868,'Masa 27, 28, 30',10,0);
INSERT INTO operace VALUES(4,5,19.100000000000001421,17.0,8.5099999999999997868,'Masa 40',10,0);
INSERT INTO operace VALUES(5,5,30.899999999999998578,24.749999999999999999,8.5099999999999997868,'Masa 70',10,0);
INSERT INTO operace VALUES(6,5,20.30000000000000071,18.100000000000001421,8.5099999999999997868,'Masa tvary',10,0);
INSERT INTO operace VALUES(7,5,40.780000000000001135,35.799999999999997158,8.5099999999999997868,'Masa 50',10,0);
INSERT INTO operace VALUES(8,5,30.899999999999998578,24.749999999999999999,8.5099999999999997868,'Masa 100',10,0);
INSERT INTO operace VALUES(9,5,4.9100000000000001421,4.2999999999999998223,8.5099999999999997868,'Drátkování strojní 16',10,0);
INSERT INTO operace VALUES(10,5,9.2699999999999995736,8.0999999999999996447,8.5099999999999997868,'Dratkování strojní 27, 28, 30',10,0);
INSERT INTO operace VALUES(11,5,14.55000000000000071,12.80000000000000071,0.0,'Dratkování rucní 10, 17, 20',10,0);
INSERT INTO operace VALUES(12,5,26.019999999999999574,22.899999999999998579,0.0,'Dratkování rucní 30',10,0);
INSERT INTO operace VALUES(13,5,45.0,39.600000000000001421,0.0,'Drátkování ruční 40',10,0);
INSERT INTO operace VALUES(14,5,64.299999999999997157,56.600000000000001421,0.0,'Drátkování ruční 70',10,0);
INSERT INTO operace VALUES(15,5,65.20000000000000284,51.659999999999996591,0.0,'Dratkování ruční1m rám',10,0);
INSERT INTO operace VALUES(16,5,95.500000000000000001,84.099999999999994317,0.0,'Dratkování tvary',10,0);
INSERT INTO operace VALUES(17,5,4.7599999999999997868,4.2999999999999998223,8.5099999999999997868,'Máčení 10, 16, 17, 20',10,0);
INSERT INTO operace VALUES(18,5,10.310000000000000497,9.1999999999999992894,8.5099999999999997868,'Máčení 30',10,0);
INSERT INTO operace VALUES(19,5,21.160000000000000141,18.80000000000000071,8.5099999999999997868,'Máčení 40',10,0);
INSERT INTO operace VALUES(20,5,303.52999999999997272,266.10000000000002273,8.5099999999999997868,'Máčení 50',10,0);
INSERT INTO operace VALUES(21,5,45.0,40.10000000000000142,8.5099999999999997868,'Máčení 70 rám',10,0);
INSERT INTO operace VALUES(22,5,48.000000000000000001,42.70000000000000284,8.5099999999999997868,'Máčení 1m',10,0);
INSERT INTO operace VALUES(23,5,80.0,71.200000000000002843,8.5099999999999997868,'Máčení tvary',10,0);
INSERT INTO operace VALUES(24,5,78.599999999999994315,62.909999999999996591,8.5099999999999997868,'Máčení 1m rám',10,0);
INSERT INTO operace VALUES(25,5,4.7599999999999997868,13.199999999999999289,8.5099999999999997868,'Zlacení 10, 17, 20',10,0);
INSERT INTO operace VALUES(26,5,15.0,13.199999999999999289,8.5099999999999997868,'Zlacení tvary',10,0);
INSERT INTO operace VALUES(27,5,284.56000000000000226,239.49999999999999999,8.5099999999999997868,'Zlacení 50',10,0);
INSERT INTO operace VALUES(28,5,48.000000000000000001,42.200000000000002843,8.5099999999999997868,'Zlacení 1m',10,0);
INSERT INTO operace VALUES(29,5,88.230000000000003979,77.599999999999994316,8.5099999999999997868,'Zlacení tvary',10,0);
INSERT INTO operace VALUES(30,5,5.2999999999999998223,4.5999999999999996447,0.0,'Snímání 10',10,0);
INSERT INTO operace VALUES(31,5,4.25,3.7000000000000001776,0.0,'Snímání17, 20',10,0);
INSERT INTO operace VALUES(32,5,8.0500000000000007105,7.0999999999999996447,0.0,'Snímání 30',10,0);
INSERT INTO operace VALUES(33,5,18.75,16.5,0.0,'Snímání 40',10,0);
INSERT INTO operace VALUES(34,5,38.820000000000000283,32.700000000000002842,0.0,'Snímání 50',10,0);
INSERT INTO operace VALUES(35,5,40.310000000000002274,35.499999999999999999,0.0,'Snímání 70',10,0);
INSERT INTO operace VALUES(36,5,45.500000000000000001,35.640000000000000568,0.0,'Snímání 1m',10,0);
INSERT INTO operace VALUES(37,5,29.0,25.499999999999999999,0.0,'Snímání tvary',10,0);
INSERT INTO operace VALUES(38,5,23.820000000000000283,17.899999999999998579,0.0,'Ohybání strj.50',10,0);
INSERT INTO operace VALUES(39,5,26.469999999999998863,19.80000000000000071,0.0,'Ohybání strj. 1m',10,0);
INSERT INTO operace VALUES(40,5,79.409999999999996587,59.600000000000001422,0.0,'ohybání ruť.50',10,0);
INSERT INTO operace VALUES(41,5,40.999999999999999999,30.780000000000001137,0.0,'ohybaní ruc. 1m',10,0);
INSERT INTO operace VALUES(42,5,450.0,337.5,0.0,'tvarování ruční',10,0);
INSERT INTO operace VALUES(43,5,247.06000000000000226,217.40000000000000567,0.0,'tvarování bodování',10,0);
INSERT INTO operace VALUES(44,5,3.3700000000000001065,3.0,8.5099999999999997868,'Sekání 10, 15, 16, 17, 20',10,0);
INSERT INTO operace VALUES(45,5,4.2300000000000004263,3.7000000000000001776,8.5099999999999997868,'Sekání 30, 40, 70, 1m',10,0);
INSERT INTO operace VALUES(46,5,7.4299999999999997157,6.5999999999999996447,8.5099999999999997868,'máčení 10 cm Anglie',10,0);
INSERT INTO operace VALUES(47,5,0.0,0.0,0.0,'Zavaření 100 ks v PE sáčků 10',10,0);
INSERT INTO operace VALUES(48,5,13.999999999999999999,7.5,0.0,'Balení 8 ks do pap. sáčků 20',10,0);
INSERT INTO operace VALUES(49,5,177.37999999999999545,94.700000000000002838,0.0,'Balení 50',10,0);
INSERT INTO operace VALUES(50,5,25.80000000000000071,21.989999999999998436,0.0,'128cm zapalovace tuba',10,0);
INSERT INTO operace VALUES(51,5,10.679999999999999715,9.1999999999999992894,0.0,'Balení 17 po25tuzem',10,0);
INSERT INTO operace VALUES(52,5,14.060000000000000497,12.099999999999999644,0.0,'Bal.17 pap.sáčku',10,0);
INSERT INTO operace VALUES(53,5,10.679999999999999715,9.1999999999999992894,0.0,'Bal 17 exp.25',10,0);
INSERT INTO operace VALUES(54,5,10.390000000000000568,8.9000000000000003552,0.0,'Balení exp.30/36',10,0);
INSERT INTO operace VALUES(55,5,10.119999999999999218,8.6999999999999992894,0.0,'Balení exp 40/50',10,0);
INSERT INTO operace VALUES(56,5,16.309999999999998721,13.999999999999999999,0.0,'Bal.17 do sáčku 10ks',10,0);
INSERT INTO operace VALUES(57,5,11.810000000000000497,10.099999999999999644,0.0,'Bal.17 po20krab.',10,0);
INSERT INTO operace VALUES(58,5,7.8700000000000001065,6.7999999999999998223,0.0,'Balení 17 volně',10,0);
INSERT INTO operace VALUES(59,5,28.679999999999999716,20.30000000000000071,0.0,'Bal.17 do blistru 20',10,0);
INSERT INTO operace VALUES(60,5,13.369999999999999217,9.4000000000000003552,0.0,'Bal.17 Betlem',10,0);
INSERT INTO operace VALUES(61,5,26.440000000000001278,22.699999999999999288,0.0,'Bal.17 Samrok, 10sáč, 50dokrab, 5kr kart.',10,0);
INSERT INTO operace VALUES(62,5,15.019999999999999573,12.900000000000000355,0.0,'Bal. 10cm á 100 gumicka',10,0);
INSERT INTO operace VALUES(63,5,18.649999999999998578,16.0,0.0,'Bal.10á100ks sáček, samrok',10,0);
INSERT INTO operace VALUES(64,5,19.120000000000000994,16.399999999999998578,0.0,'Bal.10á20kssáč.',10,0);
INSERT INTO operace VALUES(65,5,13.119999999999999218,11.30000000000000071,0.0,'Bal.20á8ks',10,0);
INSERT INTO operace VALUES(66,5,17.999999999999999999,15.499999999999999999,0.0,'Bal.20á8ks svaz., 100kskrab',10,0);
INSERT INTO operace VALUES(67,5,166.28999999999999203,132.30000000000001137,0.0,'Bal.50cm',10,0);
INSERT INTO operace VALUES(68,5,88.000000000000000001,75.700000000000002842,0.0,'Bal,  1 m',10,0);
INSERT INTO operace VALUES(69,5,30.929999999999999715,26.600000000000001421,0.0,'Bal.tvary',10,0);
INSERT INTO operace VALUES(70,5,10.880000000000000781,9.3000000000000007105,0.0,'bal.Tvary volně',10,0);
INSERT INTO operace VALUES(71,5,10.119999999999999218,7.0999999999999996447,0.0,'Bal.16 do gumičky',10,0);
INSERT INTO operace VALUES(72,5,21.370000000000000995,18.399999999999998578,0.0,'Bal.18cm, 20cm, 24sáč.krab, 12kr karton',10,0);
INSERT INTO operace VALUES(73,5,57.630000000000002557,49.600000000000001422,0.0,'Lepení cenovek',10,0);
INSERT INTO operace VALUES(74,5,57.369999999999997442,49.299999999999997157,0.0,'Skladání krabiček',10,0);
INSERT INTO operace VALUES(75,5,31.140000000000000568,26.800000000000000709,0.0,'Bal. 27cmá10á10 folie',10,0);
INSERT INTO operace VALUES(76,5,18.75,16.100000000000001421,0.0,'Bal.28cm, 5kssáček, karton',10,0);
INSERT INTO operace VALUES(77,5,41.060000000000002272,35.299999999999997156,0.0,'Bal.27cm 10sáťek, 50karton',10,0);
INSERT INTO operace VALUES(78,5,31.030000000000001136,26.699999999999999289,0.0,'Bal.30cm Haka, 10ks kr, 50-100 karton',10,0);
INSERT INTO operace VALUES(79,5,32.999999999999999999,28.399999999999998578,0.0,'Bal- Media, 20kskrab, 100kr, karton',10,0);
INSERT INTO operace VALUES(80,5,15.339999999999999857,13.199999999999999289,0.0,'Bal 30cm volně',10,0);
INSERT INTO operace VALUES(81,5,50.0,43.000000000000000001,0.0,'Bal.30cm Samrok',10,0);
INSERT INTO operace VALUES(82,5,50.0,43.000000000000000001,0.0,'Bal. 40cm Haka, 10kskr, 30kr.karton',10,0);
INSERT INTO operace VALUES(83,5,60.0,51.600000000000001421,0.0,'Bal.40cm 5kr, 10svazek, folie',10,0);
INSERT INTO operace VALUES(84,5,34.609999999999999432,29.800000000000000711,0.0,'Bal.40cm 5kr, 50karton brz folie',10,0);
INSERT INTO operace VALUES(85,5,32.140000000000000569,27.60000000000000142,0.0,'Bal. 15cm Haka 8kr, 50-100karton',10,0);
INSERT INTO operace VALUES(86,5,52.850000000000001421,45.399999999999998577,0.0,'Bal.15cm Haka 8kr, 3ke svazek, 30sv.kar.',10,0);
INSERT INTO operace VALUES(87,5,90.0,77.400000000000005683,0.0,'Bal.70cm 5kr, 5sv.karton s folii',10,0);
INSERT INTO operace VALUES(88,5,78.260000000000005115,67.299999999999997159,0.0,'Bal. 70cm 5kr, 50karton bez folie',10,0);
INSERT INTO operace VALUES(89,5,619.99999999999999998,404.69999999999998864,0.0,'Lepení krab. Nmecko',10,0);
INSERT INTO operace VALUES(90,5,11.810000000000000497,10.099999999999999644,0.0,'balení 17 cm',10,0);
INSERT INTO operace VALUES(91,5,55.0,47.299999999999997159,0.0,'Bal. Karacha po 10 ks',10,0);
INSERT INTO operace VALUES(92,5,45.0,44.0,0.0,'razítkování karacha',10,0);
INSERT INTO operace VALUES(1001,5,0.0,120.0,0.0,'Stupeň č.1',10,0);
INSERT INTO operace VALUES(1002,5,0.0,123.90000000000000568,0.0,'Srupeň č.2',10,0);
INSERT INTO operace VALUES(1003,5,0.0,135.30000000000001137,0.0,'Stupeň č.3',10,0);
INSERT INTO operace VALUES(1004,5,0.0,147.69999999999998863,0.0,'Stupeň č.4',10,0);
INSERT INTO operace VALUES(1005,5,0.0,163.19999999999998863,0.0,'Stupeň č.5',10,0);
INSERT INTO operace VALUES(1006,5,0.0,180.09999999999999431,0.0,'Stupeň č.6',10,0);
INSERT INTO operace VALUES(1,4,110.0,95.700000000000002842,6.0,'míchání Belamin',10,0);
INSERT INTO operace VALUES(2,4,830.00000000000000001,721.99999999999999998,6.0,'balení Belamin= Namex',10,0);
INSERT INTO operace VALUES(3,4,81.499999999999999996,70.900000000000005682,6.0,'míchání Roch.sul',10,0);
INSERT INTO operace VALUES(4,4,932.99999999999999999,802.00000000000000004,6.0,'balení Rochova sul',10,0);
INSERT INTO operace VALUES(5,4,81.499999999999999996,70.900000000000005682,6.0,'míchání Roch.sul.PI',10,0);
INSERT INTO operace VALUES(6,4,940.99999999999999998,869.99999999999999998,6.0,'balení Roch.sul.PI',10,0);
INSERT INTO operace VALUES(7,4,700.0,576.99999999999999999,6.0,'lisování Hexa Velká 180g',10,0);
INSERT INTO operace VALUES(8,4,600.0,494.99999999999999998,6.0,'balení Hexa Velká 180 g',10,0);
INSERT INTO operace VALUES(9,4,700.0,609.00000000000000001,6.0,'lisování Hexa kostky 200g',10,0);
INSERT INTO operace VALUES(10,4,490.0,426.00000000000000002,6.0,'balení Hexa kostky 200g',10,0);
INSERT INTO operace VALUES(11,4,45.0,391.0,6.0,'lisování Hexa malá130g',10,0);
INSERT INTO operace VALUES(12,4,860.00000000000000003,748.0,6.0,'balení Hexa malá 130g',10,0);
INSERT INTO operace VALUES(13,4,89.700000000000002838,78.000000000000000001,6.0,'míchání jednotablety',10,0);
INSERT INTO operace VALUES(14,4,44.0,37.999999999999999999,6.0,'lisování jednotablety',10,0);
INSERT INTO operace VALUES(15,4,250.0,218.0,0.0,'balení jednotablety',10,0);
INSERT INTO operace VALUES(16,4,9000.0,7699.9999999999999998,6.0,'balení RO kbelík',10,0);
INSERT INTO operace VALUES(17,4,81.499999999999999996,70.900000000000005682,0.0,'míchání PVC doza',10,0);
INSERT INTO operace VALUES(18,4,1094.0,940.99999999999999998,0.0,'krystaly',10,0);
INSERT INTO operace VALUES(19,4,2700.0,2319.9999999999999999,0.0,'toceni krabicek c2',10,0);
INSERT INTO operace VALUES(20,4,6000.0,5199.9999999999999998,0.0,'toceni krabicek c 3',10,0);
INSERT INTO operace VALUES(21,4,65.999999999999999999,66.999999999999999998,6.0,'míchání RO kbelík',10,0);
INSERT INTO operace VALUES(22,4,1007.9999999999999999,867.0,6.0,'Barva zlatá 5g',10,0);
INSERT INTO operace VALUES(23,4,1405.9999999999999999,1209.0,6.0,'Barva zlatá 35g',10,0);
INSERT INTO operace VALUES(24,4,1360.0,1169.9999999999999999,6.0,'Barva stříbro 5g',10,0);
INSERT INTO operace VALUES(25,4,1619.9999999999999999,1408.9999999999999999,0.0,'Čistící přípravek na koberce',10,0);
INSERT INTO operace VALUES(26,4,939.00000000000000003,806.99999999999999997,6.0,'Práškový škrob',10,0);
INSERT INTO operace VALUES(27,4,2000.0,2349.9999999999999999,0.0,'Čistič 1l-MU 2 ks fólie',10,0);
INSERT INTO operace VALUES(28,4,70.999999999999999999,53.600000000000001419,0.0,'Karacha 5',10,0);
INSERT INTO operace VALUES(29,4,1399.9999999999999999,1217.9999999999999999,6.0,'Hexa 650g kbelík',10,0);
INSERT INTO operace VALUES(30,4,1399.9999999999999999,1204.0,6.0,'RO PI lkg kbelík',10,0);
INSERT INTO operace VALUES(31,4,30.0,26.100000000000001421,0.0,'příprava a míchání čističe',10,0);
INSERT INTO operace VALUES(32,4,900.0,792.0,6.0,'monitory',10,0);
INSERT INTO operace VALUES(33,4,25.0,21.5,0.0,'Karacho 20ks-10folie-12sv.',10,0);
INSERT INTO operace VALUES(34,4,5.2999999999999998223,4.5999999999999996447,0.0,'snímání špačky 10 cm',10,0);
INSERT INTO operace VALUES(37,4,29.0,25.499999999999999999,0.0,'snímání tvary',10,0);
INSERT INTO operace VALUES(38,4,1399.9999999999999999,1204.0,0.0,'krystaly 1 kg kbelík',10,0);
INSERT INTO operace VALUES(39,4,900.0,1100.0,0.0,'Míchání, plnení, balení= vonka',10,0);
INSERT INTO operace VALUES(41,4,25.80000000000000071,21.989999999999998436,0.0,'špačky, tuby 10kssáček, 200 sáčku šedá',10,0);
INSERT INTO operace VALUES(43,4,247.06000000000000226,217.40000000000000567,0.0,'Tvarování tvarů',10,0);
INSERT INTO operace VALUES(46,4,7.4299999999999997157,6.5999999999999996447,6.0,'máčení špačky 10cm',10,0);
INSERT INTO operace VALUES(51,4,10.679999999999999715,9.1999999999999992894,0.0,'17cm tuzem, po 25 ks',10,0);
INSERT INTO operace VALUES(52,4,14.060000000000000497,12.099999999999999644,0.0,'10 ks do pap. sáčku',10,0);
INSERT INTO operace VALUES(53,4,10.679999999999999715,9.1999999999999992894,0.0,'17cm exp. po 25 ks do krabičky',10,0);
INSERT INTO operace VALUES(54,4,10.390000000000000568,8.9000000000000003552,0.0,'17cm po 30 do krabičky',10,0);
INSERT INTO operace VALUES(55,4,10.119999999999999218,8.6999999999999992894,0.0,'17cm po 40 do krabičky',10,0);
INSERT INTO operace VALUES(56,4,16.309999999999998721,13.999999999999999999,0.0,'do pap. sáčku 10 ks a zalepit',10,0);
INSERT INTO operace VALUES(57,4,11.810000000000000497,10.099999999999999644,0.0,'17 cm 20ks do krabičky',10,0);
INSERT INTO operace VALUES(58,4,7.8700000000000001065,6.7999999999999998223,0.0,'17 cm volně ložené',10,0);
INSERT INTO operace VALUES(59,4,0.0,0.0,0.0,'17 cm 20ks do blistru',10,0);
INSERT INTO operace VALUES(60,4,0.0,0.0,0.0,'17 cm Betlém  10ks do krabičky',10,0);
INSERT INTO operace VALUES(61,4,26.440000000000001278,22.699999999999999288,0.0,'17cm 10ks, do sač, 5 kr,  do kart, ',10,0);
INSERT INTO operace VALUES(62,4,15.019999999999999573,12.900000000000000355,0.0,'10 cm    12ks do pap.sáčku',10,0);
INSERT INTO operace VALUES(63,4,18.649999999999998578,16.0,0.0,'10cm     100ks do sač. zavařit Samrok',10,0);
INSERT INTO operace VALUES(64,4,19.120000000000000994,16.399999999999998578,0.0,'10cm     20ks do pap. sáčku',10,0);
INSERT INTO operace VALUES(65,4,13.119999999999999218,11.30000000000000071,0.0,'20cm     8 ks do pap. sáčku',10,0);
INSERT INTO operace VALUES(66,4,17.999999999999999999,15.499999999999999999,0.0,'20cm     8ks do svazku, 100sv. do krab.',10,0);
INSERT INTO operace VALUES(67,4,166.28999999999999203,132.30000000000001137,0.0,'50cm',10,0);
INSERT INTO operace VALUES(68,4,88.000000000000000001,75.700000000000002842,0.0,'1m       3ks  50 do kartonu',10,0);
INSERT INTO operace VALUES(69,4,30.929999999999999715,26.600000000000001421,0.0,'Tvary    krabice,  karton',10,0);
INSERT INTO operace VALUES(70,4,10.880000000000000781,9.3000000000000007105,0.0,'Tvary    volné',10,0);
INSERT INTO operace VALUES(71,4,0.0,0.0,0.0,'16cm     volně do gum. a 100ks',10,0);
INSERT INTO operace VALUES(72,4,21.370000000000000995,18.399999999999998578,0.0,'18cm, 20cm   5sáč.24sáč.krab.12krab.kartn',10,0);
INSERT INTO operace VALUES(73,4,57.630000000000002557,49.600000000000001422,0.0,'lepení cenovek',10,0);
INSERT INTO operace VALUES(74,4,57.369999999999997442,49.299999999999997157,0.0,'skládání krabiček',10,0);
INSERT INTO operace VALUES(75,4,31.140000000000000568,26.800000000000000709,0.0,'27cm,  10 kr, sv, gum, 10 svaz, do kartonu',10,0);
INSERT INTO operace VALUES(76,4,18.75,16.100000000000001421,0.0,'28cm     5ks do sáč. karton',10,0);
INSERT INTO operace VALUES(77,4,41.060000000000002272,35.299999999999997156,0.0,'28cm     5ks do sač.25sač.do kr.5kr.kar.',10,0);
INSERT INTO operace VALUES(78,4,31.030000000000001136,26.699999999999999289,0.0,'30cm     Haka 10ks do kr.50-100kr.karton',10,0);
INSERT INTO operace VALUES(79,4,32.999999999999999999,28.399999999999998578,0.0,'30cm     Media 20ks do kr.100kr.karton',10,0);
INSERT INTO operace VALUES(80,4,15.339999999999999857,13.199999999999999289,0.0,'30cm     volně ložené, kr. karton',10,0);
INSERT INTO operace VALUES(81,4,50.0,43.000000000000000001,0.0,'30cm  Samrok 5 ks.sač.50sač.disp.5 kartn',10,0);
INSERT INTO operace VALUES(82,4,50.0,43.000000000000000001,0.0,'40cm  Haka 10ks do kr.30kr. do kartonu',10,0);
INSERT INTO operace VALUES(83,4,60.0,51.600000000000001421,0.0,'40cm  10ks.do kr.5 kr.sv.10sv.kar.s foli',10,0);
INSERT INTO operace VALUES(84,4,34.609999999999999432,29.800000000000000711,0.0,'40cm 10ks.do kr.5 kr.sv.10sv.kar.bez fol',10,0);
INSERT INTO operace VALUES(85,4,32.140000000000000569,27.60000000000000142,0.0,'15cm 8ks dokr.50-100kr.do kartonu',10,0);
INSERT INTO operace VALUES(86,4,52.850000000000001421,45.399999999999998577,0.0,'15cm 8ks do kr.3kr.svaz.30sv.karton',10,0);
INSERT INTO operace VALUES(87,4,90.0,77.400000000000005683,0.0,'70cm 5ks kr.5kr.gum.10sv.do kar.s folií',10,0);
INSERT INTO operace VALUES(88,4,78.260000000000005115,67.299999999999997159,0.0,'70cm 5ks kr.5kr.gum.10sv.do kar.bez foli',10,0);
INSERT INTO operace VALUES(89,4,74.0,63.600000000000001419,0.0,'karacha 3+3',10,0);
INSERT INTO operace VALUES(90,4,137.99999999999999999,105.99999999999999999,0.0,'karacho 5ks,  2 krab. sácek, 30 karton',10,0);
INSERT INTO operace VALUES(91,4,55.0,47.299999999999997159,0.0,'karacha 10ks krabicka',10,0);
INSERT INTO operace VALUES(104,4,95.0,73.120000000000004549,0.0,'1m-3ks do krab./25 krab. do kart.',10,0);
INSERT INTO operace VALUES(691,4,30.929999999999999715,250.0,0.0,'Tvary-bobofan, samrok sácek',10,0);
INSERT INTO operace VALUES(700,4,30.0,29.399999999999998578,0.0,'razítkování-10, 16, 27, 30 cm',10,0);
INSERT INTO operace VALUES(701,4,60.0,58.700000000000002843,0.0,'razítkování-40, 70, 90 cm, 1m',10,0);
INSERT INTO operace VALUES(702,4,45.0,44.0,0.0,'razítkování karacha',10,0);
INSERT INTO operace VALUES(901,4,1.080000000000000071,1.0,6.0,'masa 10 cm',10,0);
INSERT INTO operace VALUES(902,4,2.7099999999999999644,2.3999999999999999111,6.0,'masa 15, 17, 20 cm',10,0);
INSERT INTO operace VALUES(903,4,8.1500000000000003552,7.2999999999999998223,6.0,'masa 27, 30 cm',10,0);
INSERT INTO operace VALUES(904,4,19.100000000000001421,17.0,6.0,'masa 40 cm',10,0);
INSERT INTO operace VALUES(905,4,30.899999999999998578,24.749999999999999999,6.0,'masa 70cm,  1m',10,0);
INSERT INTO operace VALUES(906,4,20.30000000000000071,18.100000000000001421,6.0,'masa tvary',10,0);
INSERT INTO operace VALUES(909,4,4.9100000000000001421,4.2999999999999998223,6.0,'drátkování stroj 17 cm',10,0);
INSERT INTO operace VALUES(911,4,14.55000000000000071,12.80000000000000071,0.0,'drátkování ruťní 10, 17, 20 cm',10,0);
INSERT INTO operace VALUES(912,4,26.019999999999999574,22.899999999999998579,0.0,'drátkování ruťní 30 cm',10,0);
INSERT INTO operace VALUES(913,4,45.0,39.600000000000001421,0.0,'drátkování ruťní 40 cm',10,0);
INSERT INTO operace VALUES(914,4,64.299999999999997157,56.600000000000001421,0.0,'drtkování rucni 70 cm',10,0);
INSERT INTO operace VALUES(915,4,65.20000000000000284,51.659999999999996591,0.0,'dratkovani rucni 1m',10,0);
INSERT INTO operace VALUES(916,4,95.500000000000000001,84.099999999999994317,0.0,'dratkovani rucni tvary',10,0);
INSERT INTO operace VALUES(917,4,4.7599999999999997868,4.2999999999999998223,6.0,'máťení 10, 16, 17, 20 cm',10,0);
INSERT INTO operace VALUES(918,4,10.310000000000000497,9.1999999999999992894,6.0,'maceni 30 cm',10,0);
INSERT INTO operace VALUES(919,4,21.160000000000000141,18.80000000000000071,6.0,'maceni 40 cm',10,0);
INSERT INTO operace VALUES(921,4,45.0,40.10000000000000142,6.0,'maceni 70 cm',10,0);
INSERT INTO operace VALUES(923,4,80.0,71.200000000000002843,6.0,'maceni tvary',10,0);
INSERT INTO operace VALUES(924,4,78.599999999999994315,62.909999999999996591,6.0,'maceni 1 m',10,0);
INSERT INTO operace VALUES(926,4,15.0,13.199999999999999289,6.0,'zlaceni 30 cm',10,0);
INSERT INTO operace VALUES(929,4,88.230000000000003979,77.599999999999994316,6.0,'zlaceni tvary',10,0);
INSERT INTO operace VALUES(930,4,5.2999999999999998223,4.5999999999999996447,0.0,'snimani 10 cm',10,0);
INSERT INTO operace VALUES(931,4,4.25,3.7000000000000001776,0.0,'snimani 17, 20 cm',10,0);
INSERT INTO operace VALUES(932,4,8.0500000000000007105,7.0999999999999996447,0.0,'snimani 30 cm',10,0);
INSERT INTO operace VALUES(933,4,18.75,16.5,0.0,'snimani 40 cm',10,0);
INSERT INTO operace VALUES(935,4,40.310000000000002274,35.499999999999999999,0.0,'snimani 70 cm',10,0);
INSERT INTO operace VALUES(936,4,45.500000000000000001,35.640000000000000568,0.0,'snimani 1m',10,0);
INSERT INTO operace VALUES(937,4,29.0,25.499999999999999999,0.0,'snimani tvary',10,0);
INSERT INTO operace VALUES(943,4,247.06000000000000226,217.40000000000000567,0.0,'tvarovani,  bodovani',10,0);
INSERT INTO operace VALUES(944,4,3.3700000000000001065,3.0,6.0,'sekání drátu 10, 15, 16, 17, 20 cm',10,0);
INSERT INTO operace VALUES(945,4,4.2300000000000004263,3.7000000000000001776,6.0,'sekání drátu 30, 40, 70 cm',10,0);
INSERT INTO operace VALUES(946,4,7.4299999999999997157,6.5999999999999996447,6.0,'maceni 10 cm Anglie',10,0);
INSERT INTO operace VALUES(1001,4,0.0,120.0,0.0,'1. stupeň 42.40',10,0);
INSERT INTO operace VALUES(1002,4,0.0,123.90000000000000568,0.0,'2. stupeň 44',10,0);
INSERT INTO operace VALUES(1003,4,0.0,135.30000000000001137,0.0,'3. stupeň 45',10,0);
INSERT INTO operace VALUES(1004,4,0.0,147.69999999999998863,0.0,'4. stupeň 49',10,0);
INSERT INTO operace VALUES(1005,4,0.0,163.19999999999998863,0.0,'5. stupeň 53',10,0);
INSERT INTO operace VALUES(1006,4,0.0,180.09999999999999431,0.0,'6. stupeň 63',10,0);
INSERT INTO operace VALUES(1007,4,0.0,0.0,0.0,'7. stupeň 00.00',10,0);
CREATE TABLE IF NOT EXISTS "mesodmeny"(
                "oscis" INTEGER NOT NULL,
                "cicin" INTEGER DEFAULT 0,
                "obd" CHAR(7),
                "kod" INTEGER NOT NULL,
                "jednotek" FLOAT,
                "cas" FLOAT,
                "kc" FLOAT
            );
CREATE TABLE IF NOT EXISTS "utv_stav"(
                "utvar_id" INTEGER,
                "obd" CHAR(7),
                "opened" INT DEFAULT 1
            );
INSERT INTO utv_stav VALUES(3,'05.2024',1);
INSERT INTO utv_stav VALUES(4,'05.2024',1);
INSERT INTO utv_stav VALUES(5,'05.2024',1);
CREATE TABLE IF NOT EXISTS "org"(
                "org_id" INTEGER PRIMARY KEY,
                "name" VARCHAR(100)
            , "active" INTEGER);
INSERT INTO org VALUES(1,'Drutep, výrobní družstvo',1);
CREATE TABLE IF NOT EXISTS "org_stav"(
                "org_id" INTEGER,
                "obd" CHAR(7),
                "opened" INTEGER DEFAULT 1
            , "active" INTEGER);
INSERT INTO org_stav VALUES(1,'05.2024',1,1);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('users',7);
INSERT INTO sqlite_sequence VALUES('roles',4);
INSERT INTO sqlite_sequence VALUES('utv',5);
CREATE INDEX "idx_user_uid" ON "users"("id_users");
CREATE INDEX "idx_user_loghash" ON "users"("loghash");
CREATE INDEX "idx_roles_code" ON "roles"("code");
CREATE INDEX "idx_ru_users" ON "users_roles"("users_id");
CREATE INDEX "idx_ru_roles" ON "users_roles"("roles_id");
CREATE UNIQUE INDEX "unq_utv_utvar" ON "utv" ("utvar");
CREATE INDEX "idx_utv_utvar" ON "utv"("utvar");
CREATE INDEX "idx_user_utv_user" ON "user_utv"("id_users");
CREATE INDEX "idx_user_utv_utvar" ON "user_utv"("utvar");
CREATE UNIQUE INDEX "unq_user_utvar" ON "user_utv"("id_users","utvar");
CREATE INDEX "idx_prac_utvar" ON "prac"("utvar");
CREATE UNIQUE INDEX "unq_todm_kod" ON "todm" ("kod");
CREATE INDEX "idx_todm_kod" ON "todm"("kod");
CREATE INDEX "idx_todm_zapl" ON "todm"("zapl");
CREATE INDEX "idx_todm_kopl" ON "todm"("kopl");
CREATE INDEX "idx_todm_zako" ON "todm"("zapl","kopl");
CREATE INDEX "idx_f50_oscis" ON "f50"("oscis");
CREATE INDEX "idx_f50_obdz" ON "f50"("obdz");
CREATE UNIQUE INDEX "unq_operace_id_kod" ON "operace"("operace_id","utvar_id");
CREATE INDEX "idx_operace_utvar" ON "operace"("utvar_id");
CREATE INDEX "idx_operace_id" ON "operace"("operace_id");
CREATE UNIQUE INDEX "unq_prac_oscis_cicin" ON "prac"("oscis","cicin");
CREATE UNIQUE INDEX "unq_utv_stav" ON "utv_stav"("utvar_id","obd");
CREATE UNIQUE INDEX "unq_org_stav" ON "org_stav" ("org_id","obd");
CREATE INDEX "idx_org_stav_active" ON "org_stav"("active");
COMMIT;
