Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO ADRES VALUES(1,'Warszawska',120,0,'25065','Kielce');
- INSERT INTO ADRES VALUES(2,'Panska',20,0,'25810','Kielce');
- INSERT INTO ADRES VALUES(3,'Kowaliowa',41,6,'26065','Miedziana Gora');
- INSERT INTO ADRES VALUES(4,'XI Wiekow',2,23,'25411','Kielce');
- INSERT INTO ADRES VALUES(5,'Swietokrzyska',125,0,'22011','Warszawa');
- INSERT INTO ADRES VALUES(6,'Jezuitow',12,14,'22650','Warszawa');
- INSERT INTO ADRES VALUES(7,'Krzysztofa Skalika',12,2,'29065','Krakow');
- INSERT INTO ADRES VALUES(8,'Wygnancow',256,41,'22995','Warszawa');
- INSERT INTO ADRES VALUES(9,'Lesna',5,7,'25551','Kielce');
- INSERT INTO ADRES VALUES(10,'Sciegiennego',56,0,'21025','Poznan');
- INSERT INTO ADRES VALUES(11,'Kazimierza',22,0,'29551','Szczecin');
- INSERT INTO ADRES VALUES(12,'Prosta',99,9,'20025','Wroclaw');
- INSERT INTO KONTAKT VALUES(1,512312000,4121244081,'adam.snoch@gmail.com');
- INSERT INTO KONTAKT VALUES(2,222289289,4183102180,'oscarstermach@gmail.com');
- INSERT INTO KONTAKT VALUES(3,471204117,4118241201,'krzysiek.skalik@gmail.com');
- INSERT INTO KONTAKT VALUES(4,812031728,4194120484,'legend47@gmail.com');
- INSERT INTO KONTAKT VALUES(5,841201811,4191203812,'topornik423@o2.pl');
- INSERT INTO KONTAKT VALUES(6,480128100,4199912831,'kamil-niekurzak@wp.pl');
- INSERT INTO KONTAKT VALUES(7,172475191,4180125480,'wystarczy.kropla@h2o.pl');
- INSERT INTO KONTAKT VALUES(8,518120310,4191024810,'stelmach@gmail.com');
- INSERT INTO KONTAKT VALUES(9,904129101,4192103812,'sanderka12@interia.pl');
- INSERT INTO KONTAKT VALUES(10,602814801,4191238219,'fake-mail-nr12@gmail.com');
- INSERT INTO KONTAKT VALUES(11,512803810,4181023810,'fake-mail-nr24@gmail.com');
- INSERT INTO KONTAKT VALUES(12,691142140,4110238100,'kurier243@gmail.com');
- INSERT INTO KONTO VALUES(1,'Adam.Snoch','Adamsnoch321','ADMIN');
- INSERT INTO KONTO VALUES(2,'Oskar.Stermach','1234qwert','ADMIN');
- INSERT INTO KONTO VALUES(3,'skalny','mow-mi-krzysiek','KLIENT');
- INSERT INTO KONTO VALUES(4,'darek','otworz','KLIENT');
- INSERT INTO KONTO VALUES(5,'krzysiek','Skalik@@','KLIENT');
- INSERT INTO KONTO VALUES(6,'kamil','niekurzaczek','KLIENT');
- INSERT INTO KONTO VALUES(7,'h2o','wystarczykropla','KLIENT');
- INSERT INTO KONTO VALUES(8,'stelmach','legiawarszawa','KLIENT');
- INSERT INTO KONTO VALUES(9,'sandra12','adamo123','KLIENT');
- INSERT INTO KONTO VALUES(10,'fakes12','12fakes','KLIENT');
- INSERT INTO KONTO VALUES(11,'fakes24','24fakes','KLIENT');
- INSERT INTO KONTO VALUES(12,'dpd@kurier','-18-asdlkajsdhba091','KLIENT');
- INSERT INTO PRODUKT VALUES(020,'Monitor ASUS G61v',900,20,1075);
- INSERT INTO PRODUKT VALUES(021,'SAMSUNG GALAXY S8',3200,20,3300);
- INSERT INTO PRODUKT VALUES(022,'HUAWEI P8',1100,20,1275);
- INSERT INTO PRODUKT VALUES(023,'P231 40 CALI',800,20,950);
- INSERT INTO PRODUKT VALUES(024,'HARMAN KARDON PULSAR',900,20,1075);
- INSERT INTO PRODUKT VALUES(025,'LEGINSY BIGSIX',400,20,575);
- INSERT INTO PRODUKT VALUES(026,'SAMSUNG GALAXY S7 Edge',2100,20,2200);
- INSERT INTO PRODUKT VALUES(027,'iPhone 8+',5000,20,4700);
- INSERT INTO PRODUKT VALUES(028,'Buty Adidas Yeezy',899,20,1000);
- INSERT INTO PRODUKT VALUES(029,'Dresy Nike SB',100,20,275);
- INSERT INTO PRODUKT VALUES(030,'iPhone 7',1000,20,1075);
- INSERT INTO DANE VALUES(001,020,1,5,600,650,20);
- INSERT INTO DANE VALUES(002,021,1,10,600,650,20);
- INSERT INTO DANE VALUES(003,022,1,5,600,650,20);
- INSERT INTO DANE VALUES(004,023,1,6,600,650,20);
- INSERT INTO DANE VALUES(005,024,1,2,600,650,20);
- INSERT INTO DANE VALUES(006,025,1,4,200,250,20);
- INSERT INTO DANE VALUES(007,026,1,3,600,650,20);
- INSERT INTO DANE VALUES(008,027,1,12,600,650,20);
- INSERT INTO DANE VALUES(009,028,1,1,600,650,20);
- INSERT INTO DANE VALUES(010,029,1,5,50,65,20);
- INSERT INTO DANE VALUES(011,030,1,20,600,650,20);
- INSERT INTO KLIENT VALUES(10,1,1,1);
- INSERT INTO KLIENT VALUES(11,2,2,2);
- INSERT INTO KLIENT VALUES(12,3,3,3);
- INSERT INTO KLIENT VALUES(13,4,4,4);
- INSERT INTO KLIENT VALUES(14,5,5,5);
- INSERT INTO KLIENT VALUES(15,6,6,6);
- INSERT INTO KLIENT VALUES(16,7,7,7);
- INSERT INTO KLIENT VALUES(17,8,8,8);
- INSERT INTO KLIENT VALUES(18,9,9,9);
- INSERT INTO KLIENT VALUES(19,10,10,10);
- INSERT INTO KLIENT VALUES(20,11,11,11);
- INSERT INTO KLIENT VALUES(21,12,12,12);
- INSERT INTO KATEGORIA VALUES (1,020,'Telewizory');
- INSERT INTO KATEGORIA VALUES (2,021,'Telefony');
- INSERT INTO KATEGORIA VALUES (3,022,'Telefony');
- INSERT INTO KATEGORIA VALUES (4,023,'Telewizory');
- INSERT INTO KATEGORIA VALUES (5,024,'Naglosnienie');
- INSERT INTO KATEGORIA VALUES (6,025,'Odziez');
- INSERT INTO KATEGORIA VALUES (7,026,'Telefony');
- INSERT INTO KATEGORIA VALUES (8,027,'Telefony');
- INSERT INTO KATEGORIA VALUES (9,028,'Buty');
- INSERT INTO KATEGORIA VALUES (10,029,'Odziez');
- INSERT INTO KATEGORIA VALUES (11,030,'Telefony');
- INSERT INTO PRODUCENT VALUES(100,020,'ASUS',2156167334,1);
- INSERT INTO PRODUCENT VALUES(101,021,'SAMSUNG',2245167334,1);
- INSERT INTO PRODUCENT VALUES(102,022,'HUAWEI',1246159819,1);
- INSERT INTO PRODUCENT VALUES(103,023,'HARMAN KARDON',9815120001,1);
- INSERT INTO PRODUCENT VALUES(104,024,'TOM TAILOR',8810292111,1);
- INSERT INTO PRODUCENT VALUES(105,025,'DIESEL',1112223334,5);
- INSERT INTO PRODUCENT VALUES(106,026,'SAMSUNG',2222223334,5);
- INSERT INTO PRODUCENT VALUES(107,027,'IPHONE',110451334,5);
- INSERT INTO PRODUCENT VALUES(108,028,'ADIDAS',9220919824,1);
- INSERT INTO PRODUCENT VALUES(109,029,'NIKE',9208408914,5);
- INSERT INTO PRODUCENT VALUES(110,030,'IPHONE',982111092,5);
- INSERT INTO ZAMOWIENIE VALUES (15000,021,10,101,'24/12/2017/','24/12/2017/','25/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15001,022,10,102,'22/10/2017/','24/12/2017/','25/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15002,024,10,104,'22/12/2017/','24/12/2017/','25/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15003,025,13,105,'21/12/2017/','24/12/2017/','25/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15004,026,14,106,'15/12/2017/','16/12/2017/','20/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15005,029,10,109,'01/12/2017/','02/12/2017/','05/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15006,023,11,103,'02/10/2017/','04/12/2017/','05/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15007,024,12,104,'12/12/2017/','12/12/2017/','15/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15008,025,13,105,'15/12/2017/','16/12/2017/','19/12/2017',0,'ANULOWANE');
- INSERT INTO ZAMOWIENIE VALUES (15009,026,15,106,'15/12/2017/','24/12/2017/','25/12/2017',0,'ANULOWANE');
- INSERT INTO ZAMOWIENIE VALUES (15010,026,15,106,'20/12/2017/','21/12/2017/','25/12/2017',0,'ANULOWANE');
- INSERT INTO PRACOWNIK VALUES(1000,1,1,10,1);
- INSERT INTO PRACOWNIK VALUES(1001,2,2,11,2);
- INSERT INTO ZWROT VALUES(3000,15008,13,1);
- INSERT INTO ZWROT VALUES(3001,15009,15,1);
- INSERT INTO ZWROT VALUES(3002,15010,15,1);
- INSERT INTO ZWROT VALUES(3003,15001,13,1);
- INSERT INTO ZWROT VALUES(3004,15002,15,1);
- INSERT INTO ZWROT VALUES(3005,15003,15,1);
- INSERT INTO ZWROT VALUES(3006,15004,13,1);
- INSERT INTO ZWROT VALUES(3007,15005,15,1);
- INSERT INTO ZWROT VALUES(3008,15006,15,1);
- INSERT INTO ZWROT VALUES(3009,15007,15,1);
- INSERT INTO FAKTURA VALUES (6000,15000,1000,10,'24/12/1995/',2500);
- INSERT INTO FAKTURA VALUES (6001,15001,1000,10,'24/12/1997/',55500);
- INSERT INTO FAKTURA VALUES (6002,15002,1001,10,'24/12/2005/',300);
- INSERT INTO FAKTURA VALUES (6003,15003,1001,13,'24/12/2017/',400);
- INSERT INTO FAKTURA VALUES (6004,15004,1000,14,'24/12/2016/',250);
- INSERT INTO FAKTURA VALUES (6005,15005,1001,11,'24/12/1995/',6500);
- INSERT INTO FAKTURA VALUES (6006,15006,1000,11,'24/12/1997/',55500);
- INSERT INTO FAKTURA VALUES (6007,15007,1001,12,'24/12/2005/',300);
- INSERT INTO FAKTURA VALUES (6008,15008,1001,13,'24/12/2017/',400);
- INSERT INTO FAKTURA VALUES (6009,15009,1001,15,'24/12/2016/',250);
- INSERT INTO FAKTURA VALUES (6010,15010,1001,15,'24/12/2016/',250);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement