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(022,'HUAWEI P8',999,76,1075);
- INSERT INTO PRODUKT VALUES(023,'P231 40 CALI',999,76,1075);
- INSERT INTO PRODUKT VALUES(024,'HARMAN KARDON PULSAR',999,76,1075);
- INSERT INTO PRODUKT VALUES(025,'LEGINSY BIGSIX',999,76,1075);
- INSERT INTO PRODUKT VALUES(026,'LETHERJACKET LONDON',999,76,1075);
- INSERT INTO DANE VALUES(001,022,1,123,600,650,50);
- INSERT INTO DANE VALUES(002,023,1,123,600,650,50);
- INSERT INTO DANE VALUES(003,024,1,123,600,650,50);
- INSERT INTO DANE VALUES(004,025,1,123,600,650,50);
- INSERT INTO DANE VALUES(005,026,1,123,600,650,50);
- INSERT INTO KLIENT VALUES(900,100,501,302);
- INSERT INTO KLIENT VALUES(901,101,502,303);
- INSERT INTO KLIENT VALUES(902,102,503,304);
- INSERT INTO KLIENT VALUES(903,103,504,300);
- INSERT INTO KLIENT VALUES(904,104,505,301);
- INSERT INTO KATEGORIA VALUES (10,022,'TELEWIZORY');
- INSERT INTO KATEGORIA VALUES (11,023,'TELEFONY');
- INSERT INTO KATEGORIA VALUES (12,024,'NAGLOSNIENIE');
- INSERT INTO KATEGORIA VALUES (13,025,'ODZIEZ');
- INSERT INTO KATEGORIA VALUES (14,026,'ODZIEZ');
- INSERT INTO PRODUCENT VALUES(7000,022,'PANASONIC',94312312,500);
- INSERT INTO PRODUCENT VALUES(7001,023,'HUAWEI',94312312,500);
- INSERT INTO PRODUCENT VALUES(7002,024,'HARMAN KARDON',94312312,500);
- INSERT INTO PRODUCENT VALUES(7003,025,'DIESEL',94312312,500);
- INSERT INTO PRODUCENT VALUES(7004,026,'TOM TAILOR',94312312,500);
- INSERT INTO ZAMOWIENIE VALUES (15000,022,900,7000,'24/12/2017/','24/12/2017/','25/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15001,023,901,7001,'22/10/2017/','24/12/2017/','25/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15002,024,902,7002,'22/12/2017/','24/12/2017/','25/12/2017',1,'WYSLANE');
- INSERT INTO ZAMOWIENIE VALUES (15003,025,903,7003,'21/12/2017/','24/12/2017/','25/12/2017',1,'ANULOWANE');
- INSERT INTO ZAMOWIENIE VALUES (15004,026,904,7004,'15/12/2017/','24/12/2017/','25/12/2017',0,'ANULOWANE');
- INSERT INTO PRACOWNIK VALUES(600,100,500,900,300);
- INSERT INTO PRACOWNIK VALUES(601,100,500,900,301);
- INSERT INTO ZWROT VALUES(3000,15000,900,1);
- INSERT INTO ZWROT VALUES(3001,15003,904,1);
- INSERT INTO FAKTURA VALUES (6000,15000,600,900,'24/12/1995/',2500);
- INSERT INTO FAKTURA VALUES (6001,15001,601,901,'24/12/1997/',55500);
- INSERT INTO FAKTURA VALUES (6002,15002,600,902,'24/12/2005/',300);
- INSERT INTO FAKTURA VALUES (6003,15003,600,903,'24/12/2017/',400);
- INSERT INTO FAKTURA VALUES (6004,15004,601,904,'24/12/2016/',250);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement