[708a5bc] | 1 | insert into users (firstname,lastname,username,email,userpassword) values
|
---|
| 2 | ('Bojan','Trpeski','BojanT','bojan@gmail.com','1234'),
|
---|
| 3 | ('Darko','Sasanski','DarkoS','darko@gmail.com','1111'),
|
---|
| 4 | ('Trajko','Trajkovski','TrajkoT','trajko@gmail.com','2222'),
|
---|
| 5 | ('Petko','Petkovski','PetkoP','petko@gmail.com','3333'),
|
---|
| 6 | ('Andrej','Todorovski','AndrejT','andrej@gmail.com','4444'),
|
---|
| 7 | ('Hristijan','Hristovski','HristijanH','hristijan@gmail.com','55555'),
|
---|
| 8 | ('Stefan','Stefanovski','StefanS','stefan@gmail.com','6666'),
|
---|
| 9 | ('Dimitar','Dimovski','DimitarD','dimitar@gmail.com','7777'),
|
---|
| 10 | ('David','Davidovski','DavidD','david@gmail.com','8888');
|
---|
| 11 |
|
---|
| 12 | insert into managers (userid) values
|
---|
| 13 | (2),(3),(6);
|
---|
| 14 |
|
---|
| 15 | insert into workers (userid) values
|
---|
| 16 | (4),(5),(7);
|
---|
| 17 |
|
---|
| 18 | insert into suppliers (userid,supplierinfo,phone,street,streetnumber,city) values
|
---|
| 19 | (8,'DHL','070123456','Ilindenska',123,'Skopje'),
|
---|
| 20 | (9,'FedEx','070555111','Partizanski Oderdi',15,'Skopje'),
|
---|
| 21 | (1,'Kargo Express','070789456','Jane Sandanski',55,'Skopje');
|
---|
| 22 |
|
---|
| 23 |
|
---|
| 24 | insert into orders (status,supplierremark,priority,manageruserid,supplieruserid) values
|
---|
| 25 | ('IN_PROGRESS','To be delivered','Low',2,1);
|
---|
| 26 | insert into orders (status,managerremark,priority,manageruserid,supplieruserid) values
|
---|
| 27 | ('IN_PROGRESS','To be packed','Medium',3,8);
|
---|
| 28 | insert into orders (status,datecreated,dateapproved ,priority,manageruserid,supplieruserid) values
|
---|
| 29 | ('DELIVERED','2022-10-11 11:53:45','2022-10-12 12:13:14','High',6,9);
|
---|
| 30 |
|
---|
| 31 | insert into articles (description,articlename,maxquantityperlocation) values
|
---|
| 32 | ('Del za velosiped','Osovina',10),
|
---|
| 33 | ('Novi televizori','Samsung TV 4K',15),
|
---|
| 34 | ('Bluetooth audio','JBL GO 2',50),
|
---|
| 35 | ('Domasen enterier','Agolna garnitura',5),
|
---|
| 36 | ('Novi laptopi','Apple M1',100),
|
---|
| 37 | ('Novi velosipedi','Focus',10),
|
---|
| 38 | ('Domasen enterier','Biro',20),
|
---|
| 39 | ('Debela Jakna','Addidas jakna',120),
|
---|
| 40 | ('Jakna za skijanje','Nike jakna',150);
|
---|
| 41 |
|
---|
| 42 | insert into categories (categoryName,description) values
|
---|
| 43 | ('Garderoba','Zimski jakni'),
|
---|
| 44 | ('Tehnologija','Najnovi televizori, kompjuteri i audio uredi'),
|
---|
| 45 | ('Velosipedizam','Se za velosipedi'),
|
---|
| 46 | ('Mebel','Mebel za sekoj dom');
|
---|
| 47 |
|
---|
| 48 | insert into locations (locationname,phone,street,streetnumber,city) values
|
---|
| 49 | ('Magacin 1','078894563','Metodija Shatorov Sharlo',53,'Skopje'),
|
---|
| 50 | ('Magacin 2','075321654','Boris Trajkovski',81,'Skopje'),
|
---|
| 51 | ('Magacin 3','072125874','1.Maj',45,'Bitola');
|
---|
| 52 |
|
---|
| 53 | update workers set locationid =1 where userid =4;
|
---|
| 54 | update workers set locationid =2 where userid =5;
|
---|
| 55 | update workers set locationid =3 where userid =7;
|
---|
| 56 |
|
---|
| 57 | insert into invoices (customername,customerphone,street,streetnumber,city,workeruserid) values
|
---|
| 58 | ('Stojan','0789654123','Bulervar Srbija','155','Skopje',7),
|
---|
| 59 | ('Marko','070456321','Ruzveltova','3','Skopje',4),
|
---|
| 60 | ('Kristijan','075897125','ASNOM','47','Veles',5);
|
---|
| 61 |
|
---|
| 62 | insert into invoicedarticles (price,quantity,invoiceid,articleid) values
|
---|
| 63 | (6000,3,1,3),
|
---|
| 64 | (50000,1,3,5),
|
---|
| 65 | (20000,2,2,7);
|
---|
| 66 |
|
---|
| 67 | insert into storedarticles (quantity,locationid,articleid) values
|
---|
| 68 | (5,1,6),
|
---|
| 69 | (10,3,3),
|
---|
| 70 | (20,3,8),
|
---|
| 71 | (2,2,5),
|
---|
| 72 | (8,1,7);
|
---|
| 73 |
|
---|
| 74 | insert into orderedarticles (price,quantity,orderid,locationid,articleid, articlestatus) values
|
---|
| 75 | (100000,2,1,1,4, 'ORDERED'),
|
---|
| 76 | (2000,1,2,2,1, 'ORDERED'),
|
---|
| 77 | (15000,5,3,3,9, 'DELIVERED');
|
---|
| 78 |
|
---|
| 79 | insert into questions (questiontext,datecreated,workeruserid,manageruserid) values
|
---|
| 80 | ('Dali ke moze da naracate uste Focus velosipedi, nemame na zaliha?','2022-10-10 14:15:23',7,6),
|
---|
| 81 | ('Dali se dosta 100 jakni?','2022-11-11 11:12:12',5,2),
|
---|
| 82 | ('Dali ke moze da naracate novi JBL GO2 zvucnici, imame uste 10?','2022-11-15 13:51:23',4,3);
|
---|
| 83 |
|
---|
| 84 | insert into answers (questionId,answertext,datecreated) values
|
---|
| 85 | (1,'Da, ke naracam uste 5.','2022-10-11 08:14:14'),
|
---|
| 86 | (2,'Dovolno e 100 jakni.','2022-11-12 09:16:23'),
|
---|
| 87 | (3,'Sekako, ke naracam 100 parcinja.','2022-11-17 12:42:24');
|
---|
| 88 |
|
---|
| 89 | insert into question_availability_for_storedarticle (questionId,sarticleid) values
|
---|
| 90 | (1,1),
|
---|
| 91 | (2,3),
|
---|
| 92 | (3,2);
|
---|
| 93 |
|
---|
| 94 | insert into supplier_supplies_category (userid,categoryid) values
|
---|
| 95 | (8,1),
|
---|
| 96 | (8,2),
|
---|
| 97 | (9,3),
|
---|
| 98 | (9,4),
|
---|
| 99 | (9,2),
|
---|
| 100 | (1,1),
|
---|
| 101 | (1,3),
|
---|
| 102 | (1,4);
|
---|
| 103 |
|
---|
| 104 | insert into article_belongs_to_category (articleId,categoryid) values
|
---|
| 105 | (1,2),
|
---|
| 106 | (2,1),
|
---|
| 107 | (3,1),
|
---|
| 108 | (4,3),
|
---|
| 109 | (5,1),
|
---|
| 110 | (6,2),
|
---|
| 111 | (7,3),
|
---|
| 112 | (8,4),
|
---|
| 113 | (9,4); |
---|