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); |
---|