Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO checks VALUES
- ('1', 'Nákupní centrum', '1500', 'Příště vzít syny');
- INSERT INTO checks VALUES
- ('2', 'ČD', '245', 'Vlak do Prahy');
- INSERT INTO checks VALUES
- ('3', 'Nákupní centrum', '2000', 'Mobilní telefon');
- INSERT INTO checks VALUES
- ('4', 'Místní benzinka', '980', 'Benzín');
- INSERT INTO checks VALUES
- ('5', 'Diskont', '1500', 'Nákup');
- INSERT INTO checks VALUES
- ('6', 'Hospoda', '2500', 'Divoká noc');
- INSERT INTO checks VALUES
- ('7', 'Benzinka ve městě', '250', 'Benzín');
- INSERT INTO deposits VALUES
- ('1', 'Bohatý strýček', '20000', 'Vyzvednout seznam dárků');
- INSERT INTO deposits VALUES
- ('2', 'Zaměstnavatel', '25000', 'Výplata za červenec');
- INSERT INTO deposits VALUES
- ('3', 'Banka', '5000', 'Půjčka');
- INSERT INTO bikes VALUES
- ('TREK 2300', '22.5', 'Uhlíkové vlákno', '3500', 'Závodní');
- INSERT INTO bikes VALUES
- ('Burley', '22', 'Ocel', '2000', 'Dvojkolo');
- INSERT INTO bikes VALUES
- ('Obr', '19', 'Ocel', '15000','Městské');
- INSERT INTO bikes VALUES
- ('Fuji', '20', 'Ocel', '500', 'Trekingové');
- INSERT INTO bikes VALUES
- ('Spec', '16', 'Ocel', '100', 'Horské');
- INSERT INTO bikes VALUES
- ('Dělo', '22.5', 'ALUMINUM', '3000', 'Závodní');
- INSERT INTO hilow VALUES
- ('CZ', '-20', '34',NULL);
- INSERT INTO hilow VALUES
- ('SK', '-23', '33',NULL);
- INSERT INTO hilow VALUES
- ('PL', '-28', '31',NULL);
- INSERT INTO hilow VALUES
- ('GB', '-15', '28',NULL);
- INSERT INTO hilow VALUES
- ('FR', '-20', '35',NULL);
- INSERT INTO remains VALUES
- ('10', '5');
- INSERT INTO remains VALUES
- ('8', '3');
- INSERT INTO remains VALUES
- ('23', '9');
- INSERT INTO remains VALUES
- ('40', '17');
- INSERT INTO remains VALUES
- ('1024', '16');
- INSERT INTO remains VALUES
- ('85', '34');
- INSERT INTO precedence VALUES
- ('1', '2', '3', '4');
- INSERT INTO precedence VALUES
- ('13', '24', '35', '46');
- INSERT INTO precedence VALUES
- ('9', '3', '23', '5');
- INSERT INTO precedence VALUES
- ('63', '2', '45', '3');
- INSERT INTO precedence VALUES
- ('7', '2', '1', '4');
- INSERT INTO parts VALUES
- ('Apendix', 'Střed Břicho', '1');
- INSERT INTO parts VALUES
- ('Ohryzek', 'Hrdlo', '2');
- INSERT INTO parts VALUES
- ('Srdce', 'Hruď', '3');
- INSERT INTO parts VALUES
- ('Páteř', 'Záda', '4');
- INSERT INTO parts VALUES
- ('Kovadlinka', 'Ucho', '5');
- INSERT INTO parts VALUES
- ('Ledvina', 'Střed Záda', '6');
- INSERT INTO vacation VALUES
- ('Huňka', '101', '2', '4');
- INSERT INTO vacation VALUES
- ('Bednář', '104', '5', '23');
- INSERT INTO vacation VALUES
- ('Hruška', '107', '8', '45');
- INSERT INTO vacation VALUES
- ('Zilvar', '233', '4', '80');
- INSERT INTO vacation VALUES
- ('Hrbek', '210', '15', '100');
- INSERT INTO vacation VALUES
- ('Ovčáček', '211', '10', '78');
- INSERT INTO football VALUES
- ('Huňka');
- INSERT INTO football VALUES
- ('Bureš');
- INSERT INTO football VALUES
- ('Cásek');
- INSERT INTO football VALUES
- ('Dokoupil');
- INSERT INTO football VALUES
- ('Edler');
- INSERT INTO football VALUES
- ('Frgál');
- INSERT INTO football VALUES
- ('Grumlich');
- INSERT INTO softball VALUES
- ('Huňka');
- INSERT INTO softball VALUES
- ('Bednář');
- INSERT INTO softball VALUES
- ('Cásek');
- INSERT INTO softball VALUES
- ('Daněk');
- INSERT INTO softball VALUES
- ('Edler');
- INSERT INTO softball VALUES
- ('Fojt');
- INSERT INTO softball VALUES
- ('Grumlich');
- INSERT INTO price VALUES
- ('Rajčata', '34');
- INSERT INTO price VALUES
- ('Brambory', '51');
- INSERT INTO price VALUES
- ('Banány', '67');
- INSERT INTO price VALUES
- ('Tuříny', '45');
- INSERT INTO price VALUES
- ('Sýr', '89');
- INSERT INTO price VALUES
- ('Jablka', '23');
- INSERT INTO friends VALUES
- ('Lužný', 'Bob', '602', '111222', 'OL', '79821');
- INSERT INTO friends VALUES
- ('Matyáš', 'Bob', '773', '123456', 'BR', NULL);
- INSERT INTO friends VALUES
- ('Strouhal', 'Fido', '300', '343434', 'ZL', '76701');
- INSERT INTO friends VALUES
- ('Přikryl', 'Tom', '581', '010101', 'PL', '72000');
- INSERT INTO friends VALUES
- ('Černý', 'Franta', '777', '000999', 'OL', '79801');
- INSERT INTO friends VALUES
- ('Zavadil', 'Olda', '911', '111311', 'OL', '79604');
- INSERT INTO friends VALUES
- ('Berka', 'Standa', '604', '111234', 'ZL', '72801');
- INSERT INTO puzzle VALUES
- ('Dlaždič', 'Dvůr');
- INSERT INTO puzzle VALUES
- ('Major', 'Kuchyně');
- INSERT INTO puzzle VALUES
- ('Speedy', 'Obývák');
- INSERT INTO puzzle VALUES
- ('Waldo', 'Garáž');
- INSERT INTO puzzle VALUES
- ('Chlapec', 'Šatna');
- INSERT INTO puzzle VALUES
- ('Arnold', 'Ložnice');
- INSERT INTO orgchart VALUES
- ('Adamovský', 'Výzkum', '34000.00', '34', '12');
- INSERT INTO orgchart VALUES
- ('Vrba', 'Marketing', '31000.00', '40', '9');
- INSERT INTO orgchart VALUES
- ('Sýkora', 'Marketing', '36000.00', '20', '19');
- INSERT INTO orgchart VALUES
- ('Matyáš', 'Účetní', '40000.00', '30', '27');
- INSERT INTO orgchart VALUES
- ('Strouhal', 'Výzkum', '45000.00', '20', '17');
- INSERT INTO orgchart VALUES
- ('Rozehnal', 'Marketing', '42000.00', '25', '18');
- INSERT INTO orgchart VALUES
- ('Fiala', 'Účetní', '35000.00', '22', '14');
- INSERT INTO orgchart VALUES
- ('Přeslička', 'PR', '37500.00', '24', '24');
- INSERT INTO customer VALUES
- ('Mega Kola', 'Hačice 253', 'Hačice', '58702', '581123456', 'Nic');
- INSERT INTO customer VALUES
- ('CykloSpec', 'Dolní 86', 'Brno', '45678', '771654321', 'Nic');
- INSERT INTO customer VALUES
- ('LX Obchůdek', 'Smetanova 15', 'Brno', '54678', '771333222', 'Nic');
- INSERT INTO customer VALUES
- ('Cyklo ABC', 'Jarní 6', 'Prostějov', '56784', '771111000', 'Honza');
- INSERT INTO customer VALUES
- ('Cyklo Franta', 'Prostějovská 10', 'Bedihošť', '34567', '771789456', 'Nic');
- INSERT INTO part VALUES
- ('54', 'Pedály', '542.50');
- INSERT INTO part VALUES
- ('42', 'Sedla', '245.00');
- INSERT INTO part VALUES
- ('46', 'Pneu', '152.50');
- INSERT INTO part VALUES
- ('23', 'Horské kolo', '3504.50');
- INSERT INTO part VALUES
- ('76', 'Silniční kolo', '5300.00');
- INSERT INTO part VALUES
- ('10', 'Dvojkolo', '12000.00');
- INSERT INTO teamstats VALUES
- ('Jeníček', '1B', '145', '45', '34', '31', '8', '1', '5', '10');
- INSERT INTO teamstats VALUES
- ('Drápal', '3B', '175', '65', '23', '50', '10', '1', '4', '15');
- INSERT INTO teamstats VALUES
- ('Vorel', 'LF', '157', '49', '15', '35', '8', '3', '3', '16');
- INSERT INTO teamstats VALUES
- ('Davídek', 'OF', '187', '70', '24', '48', '4', '0', '17', '42');
- INSERT INTO teamstats VALUES
- ('Hemera', '3B', '50', '12', '10', '10', '2', '0', '0', '13');
- INSERT INTO teamstats VALUES
- ('Cásek', 'DH', '1', '0', '0', '0', '0', '0', '0', '1');
- INSERT INTO numbers VALUES
- ('3.1415', '4');
- INSERT INTO numbers VALUES
- ('-45', '.707');
- INSERT INTO numbers VALUES
- ('5', '9');
- INSERT INTO numbers VALUES
- ('-57.667', '42');
- INSERT INTO numbers VALUES
- ('15', '55');
- INSERT INTO numbers VALUES
- ('-7.2', '5.3');
- INSERT INTO characters VALUES
- ('Pečínka', 'KAMIL', 'A', '32');
- INSERT INTO characters VALUES
- ('Tříska', 'CTIBOR', 'J', '67');
- INSERT INTO characters VALUES
- ('Chasníková', 'LENKA', 'C', '65');
- INSERT INTO characters VALUES
- ('Adamovský', 'FRANTA', 'M', '87');
- INSERT INTO characters VALUES
- ('Ovčáček', 'ADAM', 'A', '77');
- INSERT INTO characters VALUES
- ('Krupička', 'MILAN', 'G', '52');
- INSERT INTO `convert` VALUES
- ('40', '95');
- INSERT INTO `convert` VALUES
- ('13', '23');
- INSERT INTO `convert` VALUES
- ('74', '68');
- INSERT INTO bills VALUES
- ('Telefonní společnost', '125', '1');
- INSERT INTO bills VALUES
- ('Energetická společnost', '75', '1');
- INSERT INTO bills VALUES
- ('Nahrávací klub', '25', '2');
- INSERT INTO bills VALUES
- ('Softwarová společnost', '250', '1');
- INSERT INTO bills VALUES
- ('Kabelovka', '35', '3');
- INSERT INTO bills VALUES
- ('Autosalón Janík', '350', '5');
- INSERT INTO bills VALUES
- ('Půjčovna kol', '200', '6');
- INSERT INTO bills VALUES
- ('Vodárny Žilina', '20', '1');
- INSERT INTO bills VALUES
- ('Pojišťovací společnost', '125', '5');
- INSERT INTO bills VALUES
- ('Kreditní karta', '35', '4');
- INSERT INTO artists VALUES('Soul Asylum','Minneapolis','Rock',1);
- INSERT INTO artists VALUES('Maurice Ravel','Francie','Classical',2);
- INSERT INTO artists VALUES('Dave Matthews Band','Charlottesville','Rock',3);
- INSERT INTO artists VALUES('Vince Gill','Nashville','Country',4);
- INSERT INTO artists VALUES('Oingo Boingo','Los Angeles','Pop',5);
- INSERT INTO artists VALUES('Crowded House','Nový Zéland','Pop',6);
- INSERT INTO artists VALUES('Mary Chapin-Carpenter','Nashville','Country',7);
- INSERT INTO artists VALUES('Edward MacDowell','USA','Classical',8);
- INSERT INTO media VALUES(1,'Nahrávka',49.9);
- INSERT INTO media VALUES(2,'Kazeta',99.9);
- INSERT INTO media VALUES(3,'CD',139.9);
- INSERT INTO media VALUES(4,'CD-ROM',299.9);
- INSERT INTO media VALUES(5,'DAT',199.9);
- INSERT INTO recordings VALUES(1,2,'Hang Time',1988);
- INSERT INTO recordings VALUES(1,3,'Made to Be Broken',1986);
- INSERT INTO recordings VALUES(2,3,'Bolero',1990);
- INSERT INTO recordings VALUES(3,5,'Under the Table and Dreaming',1994);
- INSERT INTO recordings VALUES(4,3,'When Love Finds You',1994);
- INSERT INTO recordings VALUES(5,2,'Boingo',1987);
- INSERT INTO recordings VALUES(5,1,'Dead Man\'s Party',1984);
- INSERT INTO recordings VALUES(6,2,'Woodface',1990);
- INSERT INTO recordings VALUES(6,3,'Together Alone',1993);
- INSERT INTO recordings VALUES(7,5,'Come On, Come On',1992);
- INSERT INTO recordings VALUES(7,3,'Stones in the Road',1994);
- INSERT INTO recordings VALUES(8,5,'Second Piano Concerto',1985);
- INSERT INTO products VALUES
- ('P01', 'Lampička s Rákosníčkem', '299.50');
- INSERT INTO products VALUES
- ('P02', 'Nezlomitelné tužky - 20 kusů', '199');
- INSERT INTO products VALUES
- ('P03', 'Šálek na kávu', '69.50');
- INSERT INTO products VALUES
- ('P04', 'Nástěnný kalendář', '105');
- INSERT INTO products VALUES
- ('P05', 'Přírodní kalendář', '129.90');
- INSERT INTO products VALUES
- ('P06', 'Přehled příkazů jazyka SQL', '299.90');
- INSERT INTO products VALUES
- ('P07', 'Černý kožený kufřík', '999.90');
- INSERT INTO rc_table VALUES
- ('1012819874');
- INSERT INTO rc_table VALUES
- ('3006781111');
- INSERT INTO rc_table VALUES
- ('3010864597');
- INSERT INTO job_tbl VALUES
- ('Aleš Kovařík', 'Zástupce ředitele', 'Marketing');
- INSERT INTO salaries VALUES
- ('Honza', '35000', '29');
- INSERT INTO salaries VALUES
- ('Jana', '48000', '42');
- INSERT INTO salaries VALUES
- ('Jirka', '61000', '55');
- INSERT INTO states VALUES
- ('F');
- INSERT INTO states VALUES
- ('SK');
- INSERT INTO states VALUES
- ('GB');
- INSERT INTO states VALUES
- ('PL');
- INSERT INTO states VALUES
- ('D');
- INSERT INTO states VALUES
- ('CZ');
- INSERT INTO states VALUES
- ('A');
- INSERT INTO EMP_TBL VALUES
- ('324540787','Melčák','Richard','Hezká 10',
- 'Zlín','ZL','45345','178234528',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('234566742','Kovařík','Jindřich','Špačkova 7',
- 'Vyškov','BR','47804','122344434',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('313219830','Procházka','Tomáš','Barevná 13',
- 'Brno','BR','46113','175462918',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('435663121','Raška','Vilém','Partizánská 18',
- 'Brno','BR','45343','177926529',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('412331221','Tučková','Valerie','Ztracená 33',
- 'Brno','BR','46112','179872335',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('453897657','Jeníček','Jan','Botanická 68a',
- 'Brno','BR','46112','179856734',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('453897657','Burget','Kamil','Skácelova 56',
- 'Brno','BR','46112','179874532',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('412453872','Opletal','Jaromír','Pionýrská 15b',
- 'Brno','BR','46112','174539876',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('345608124','Tříska','Jan','Nádražní 15',
- 'Brno','BR','46112','179561234',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('238513942','Nováková','Jitka','Líšeň 89',
- 'Brno','BR','46112','179463248',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('435649765','Suchánek','Stanislav','Padlého 5',
- 'Brno','BR','46123','17453654',NULL,NULL);
- INSERT INTO EMP_TBL VALUES
- ('127643652','FERGUSON','Jan','Svitavská 653',
- 'Brno','BR','46112','174534351',NULL,NULL);
- INSERT INTO EMP_PAY_TBL VALUES
- ('324540787','01-JAN-2006','Úředník',33000.00,NULL,'Kovařík','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('234566742','15-JUL-2004','VP Marketing',250000.00,NULL,'Václav','Marketing');
- INSERT INTO EMP_PAY_TBL VALUES
- ('313219830','08-AUG-2005','Obchodník',30000.00,NULL,'Marie','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('435663121','01-JAN-2005','Úředník',NULL,90.00,'HAMILTON','HQ');
- INSERT INTO EMP_PAY_TBL VALUES
- ('412331221','01-MAY-2005','Služby zákazníkům',NULL,130.00,'Marie','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('143234343','01-JUL-2004','Služby zákazníkům',NULL,131.50,'Marie','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('453897657','15-OCT-2002','Služby zákazníkům',NULL,140.00,'Marie','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('41245.343872','01-FEB-2003','Služby zákazníkům',NULL,127.50,'Marie','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('345608124','15-APR-2002','Služby zákazníkům',NULL,132.50,'Marie','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('238513942','01-AUG-2006','Služby zákazníkům',NULL,130.00,'Marie','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('435649765','01-APR-2003','Služby zákazníkům',NULL,185.00,'Marie','Odbyt');
- INSERT INTO EMP_PAY_TBL VALUES
- ('127643652','01-MAY-2005','Služby zákazníkům',NULL,140.00,'Marie','Odbyt');
- INSERT INTO VENDOR_TBL VALUES
- ('1234','Sony','Chomutovská 15','Praha',
- 'CZ','47802','813545100','813545100','Robert Mára','Hudba');
- INSERT INTO VENDOR_TBL VALUES
- ('4563','Obaly Praha','Kačerov 65b','Praha',
- 'CZ','46312','212703588','212703679','Beáta Cibulková','Krabice');
- INSERT INTO VENDOR_TBL VALUES
- ('3876','Kancelář','Západní 8','Brno',
- 'CZ','46113','317552700',NULL,NULL,'Kancelář');
- INSERT INTO VENDOR_TBL VALUES
- ('9256','Balíkova služba','Úvoz 25','Brno',
- 'CZ','46213','317898230',NULL,NULL,'Přeprava');
- INSERT INTO VENDOR_TBL VALUES
- ('3452','APA Rec','Pod mostem 13','Košice',
- 'SK','12543','213221500','213221500','Cindy Robi','Hudba');
- INSERT INTO VENDOR_TBL VALUES
- ('4352','B-Stud','Šárka 6','Bratislava',
- 'SK','96243',517299601',NULL,NULL,'Hudba');
- INSERT INTO MEMBER_TBL VALUES
- ('1111','Marná','Kamila','D','Úzká 15','Brno',
- 'CZ','54642', '13-MAY-2007','Country','Country','Rock','Classical');
- INSERT INTO MEMBER_TBL VALUES
- ('2222','David','Roubal','T','Dunajská 8','Bratislava',
- 'SK','35246',NULL,'Pop','Pop','Rock','Country');
- INSERT INTO MEMBER_TBL VALUES
- ('3333','Lukáš','Trunečka','C','Pavelčákova 26','Olomouc',
- 'CZ','10324',NULL,'Rock','Rock','Pop','Country');
- INSERT INTO MEMBER_TBL VALUES
- ('4444','Pavel','Bednář','W','Prašná 8','Opava',
- 'CZ','54335', '01-JAN-2009','Classical','Classical',NULL,NULL);
- INSERT INTO MEMBER_TBL VALUES
- ('5555','Beáta','Smutná','F','Dubina 253/20','Ostrava',
- 'CZ','34235','01-NOV-2005','Pop','Rock','Pop', 'Country');
- INSERT INTO MEMBER_TBL VALUES
- ('6666','Jakub','Vydra','Q','Tomkovo nám. 153','Brno',
- 'CZ','46378', '13-AUG-2007','Pop',NULL,NULL,NULL);
- INSERT INTO MEMBER_TBL VALUES
- ('7777','Josef','Eliáš','L','R. Těsnohlídka 3','Prostějov',
- 'CZ','45231',NULL,'Pop','Pop','Rock',NULL);
- INSERT INTO MEMBER_TBL VALUES
- ('8888','Jaroslav','Suchý','G','Hulínská 27d','Zlín',
- 'CZ','46354', '13-MAY-2009','Classical','Classical',NULL,NULL);
- INSERT INTO MEM_PROFILE_TBL VALUES
- ('1111','Jihomoravský','Muž','20-NOV-1950',30000.00);
- INSERT INTO MEM_PROFILE_TBL VALUES
- ('2222','Slovensko','Muž',NULL,NULL);
- INSERT INTO MEM_PROFILE_TBL VALUES
- ('3333','Olomoucký','Muž',NULL,112000.00);
- INSERT INTO MEM_PROFILE_TBL VALUES
- ('4444','Moravskoslezský','Muž','17-JAN-1980',65000.00);
- INSERT INTO MEM_PROFILE_TBL VALUES
- ('5555','Moravskoslezský','Žena','02-JAN-1960',NULL);
- INSERT INTO MEM_PROFILE_TBL VALUES
- ('6666','Jihomoravský','Muž',NULL,35000.00);
- INSERT INTO MEM_PROFILE_TBL VALUES
- ('7777','Olomoucký','Muž','15-JUN-1970','40000.00);
- INSERT INTO MEM_PROFILE_TBL VALUES
- ('8888','Zlínský','Muž','06-JUL-1940',15000000.00);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement