SQL & DDL: Truck Simulator DML Final.txt

File Truck Simulator DML Final.txt, 18.6 KB (added by 213231, 5 months ago)

DML Final

Line 
1-- customer
2INSERT INTO `customer` VALUES
3(1,'Marko','Markovski','marko@example.com','Street 123, Skopje','070123456','marko123'),
4(2,'Elena','Stojanova','elena@example.com','Boulevard 45, Bitola','071987654','elena123'),
5(3,'David','Trajchev','davidtrajchev@gmail.com','UL.ANASTAS MITREV BR.4/1-2','076999813','$2b$10$1zc9OAt9TJLKGx7qQe2p7.8kVFao1dqOiPNacw4eT7EXGVFNQ1AsW'),
6(4,'David-v2','Trajchev','V2davidtrajchev@gmail.com','UL.ANASTAS MITREV BR.4/1-2','077999813','$2b$10$4IlcLjFqjDtQd0bOMxLP7eyU4hUBlUm.iBp2mOoHtX3KnDKYtXQPe'),
7(5,'Davidd','Trajchev','ddavidtrajchev@gmail.com','UL.ANASTAS MITREV BR.4/1-2','076999813','$2b$10$Ujq1p39MmCJob/lP7mrW5.Z12rjApH8mKAVBQyYzc0IJMHhoB86GC');
8
9-- employee
10INSERT INTO `employee` VALUES
11(1,'Ivan','Petrov','Sales Manager','Sales','ivan@example.com','ivan123'),
12(2,'Ana','Kostova','Maintenance Specialist','Maintenance','ana@example.com','ana123'),
13(1000,'Admin','User','Admin','Admin','admin@example.com','admin123'),
14(1001,'David','Trajchev','Test','Maintenance','david@example.com','david123'),
15(1002,'Leon','Zlatkovski','Test 2','Sales','leon@example.com','leon123'),
16(1003,'Test','test','Test 3','Sales','test@example.com','test123'),
17(1004,'v2 test','v2 test','v2 test','Sales','v2 test@example.com','v2 test123'),
18(1005,'V2','TEST','V2 tESTER','Maintenance','v2@example.com','v2123');
19
20-- product
21INSERT INTO `product` VALUES
22(1,'Volvo FH16',3500.00,'SK-1234-AB','sold'),
23(2,'Scania R500',100.00,'BT-5678-CD','sold'),
24(3,'Kögel Trailer',300.00,'SK-2468-EF','available'),
25(4,'DAF(808)',100.00,'SK-1111-LL','sold'),
26(5,'Test V2',3300.00,'SK-1111-TT','rented'),
27(6,'Volvo FH16',3500.00,'SK-1235-AB','available'),
28(7,'Volvo FH16',3500.00,'SK-1236-AB','available'),
29(8,'Kögel Trailer',300.00,'SK-2469-EF','sold'),
30(9,'Kögel Trailer',300.00,'SK-2470-EF','available'),
31(10,'DAF(808)',100.00,'SK-1112-LL','available'),
32(11,'DAF(808)',100.00,'SK-1113-LL','available'),
33(12,'Scania R500',100.00,'BT-5679-CD','available'),
34(13,'Scania R500',100.00,'BT-5680-CD','available');
35
36-- maintenance
37INSERT INTO `maintenance` VALUES
38(2,2,2,'2025-05-04','0',0.00,'Completed','2025-06-01 13:27:50',NULL),
39(3,2,NULL,'2025-05-22','',0.00,'Pending','2025-06-01 13:27:50',NULL),
40(4,2,NULL,'2025-05-22','',0.00,'Pending','2025-06-01 13:27:50',NULL),
41(5,2,1,'2025-05-22','test test',100.00,'Completed','2025-06-01 13:27:50',NULL),
42(6,2,1,'2025-05-22','asasasasasa',0.00,'Completed','2025-06-01 13:27:50',NULL),
43(7,2,2,'2025-05-22','0',0.00,'Completed','2025-06-01 13:27:50',NULL),
44(8,2,2,'2025-05-22','test2-0 completed',100.00,'Completed','2025-06-01 13:27:50',NULL),
45(9,2,3,'2025-05-26','Zavrshen Test',100.00,'Completed','2025-06-01 13:27:50',NULL),
46(10,2,3,'2025-05-26','ss',1.00,'Completed','2025-06-01 13:27:50',NULL),
47(11,2,1,'2025-05-26','test 22',100.00,'Completed','2025-06-01 13:27:50',NULL),
48(12,2,1,'2025-05-27','test v2 works',0.00,'Completed','2025-06-01 13:27:50',NULL),
49(13,2,1,'2025-05-29','works',0.00,'Completed','2025-06-01 13:27:50',NULL),
50(14,2,1,'2025-05-29','xx',0.00,'Completed','2025-06-01 13:27:50',NULL),
51(15,2,1,'2025-06-01','test 3 done',10.00,'Completed','2025-06-01 13:32:02','2025-06-01 13:33:58'),
52(16,2,2,'2025-06-04','ff',0.00,'Completed','2025-06-04 00:36:29','2025-06-04 00:40:40');
53
54-- procurement
55INSERT INTO `procurement` VALUES
56(1,1,1,1,'2025-04-01',1,'Rejected',0,NULL),
57(2,1,2,2,'2025-04-10',1,'Rejected',0,NULL),
58(3,1,2,3,'2025-05-04',1,'Rejected',0,NULL),
59(4,1,3,1,'2025-05-20',1,'Approved',1,NULL),
60(5,1,3,2,'2025-05-20',1,'Approved',1,NULL),
61(6,1,3,1,'2025-05-20',1,'Rejected',1,NULL),
62(7,1,3,1,'2025-05-20',1,'Rejected',1,NULL),
63(8,1,3,3,'2025-05-20',1,'Rejected',1,NULL),
64(9,1,3,3,'2025-05-20',1,'Approved',1,NULL),
65(10,2,3,3,'2025-05-20',1,'Rejected',1,NULL),
66(11,2,3,1,'2025-05-20',1,'Approved',1,NULL),
67(12,2,3,2,'2025-05-20',1,'Rejected',1,NULL),
68(13,2,3,3,'2025-05-20',1,'Approved',1,NULL),
69(14,2,3,2,'2025-05-20',1,'Approved',1,NULL),
70(15,2,3,3,'2025-05-20',1,'Approved',1,NULL),
71(16,2,3,1,'2025-05-20',1,'Approved',1,NULL),
72(17,2,3,2,'2025-05-20',1,'Approved',1,NULL),
73(18,2,3,1,'2025-05-20',1,'Approved',1,NULL),
74(19,2,3,1,'2025-05-20',1,'Rejected',1,NULL),
75(20,2,3,1,'2025-05-20',1,'Approved',1,NULL),
76(21,2,3,2,'2025-05-20',1,'Rejected',1,NULL),
77(22,1,3,1,'2025-05-22',1,'Approved',1,NULL),
78(23,1,3,2,'2025-05-26',1,'Approved',1,NULL),
79(24,1,3,2,'2025-05-26',1,'Approved',1,NULL),
80(25,NULL,3,1,'2025-05-26',1,'Rejected',1,NULL),
81(26,1,3,3,'2025-05-27',1,'Approved',1,NULL),
82(27,1,3,4,'2025-05-28',1,'Approved',1,NULL),
83(28,1,3,2,'2025-05-29',1,'Approved',1,NULL),
84(29,1,3,1,'2025-05-29',1,'Approved',1,NULL),
85(30,1,3,5,'2025-05-31',1,'Approved',1,NULL),
86(31,1,3,3,'2025-05-31',1,'Approved',1,NULL),
87(32,1,3,2,'2025-05-31',1,'Approved',1,NULL),
88(33,1,3,1,'2025-05-31',1,'Approved',1,NULL),
89(34,1,3,2,'2025-05-31',1,'Approved',1,'59fa5a1c-1057-4d73-8c52-0452a016e540'),
90(35,1,3,2,'2025-05-31',1,'Approved',1,'59fa5a1c-1057-4d73-8c52-0452a016e540'),
91(36,1,3,2,'2025-05-31',1,'Approved',1,'59fa5a1c-1057-4d73-8c52-0452a016e540'),
92(37,1,3,4,'2025-05-31',1,'Approved',1,'59fa5a1c-1057-4d73-8c52-0452a016e540'),
93(38,1,3,5,'2025-05-31',1,'Approved',1,'4eddd7f5-c077-453a-9c92-7319764eb2d9'),
94(39,1,3,4,'2025-05-31',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
95(40,1,3,4,'2025-05-31',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
96(41,1,3,4,'2025-06-01',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
97(42,1,3,4,'2025-06-01',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
98(43,1,3,2,'2025-06-01',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
99(44,1,3,1,'2025-06-01',1,'Approved',1,'4f4d2173-9167-40f7-bdd3-223316070bd8'),
100(45,1,3,4,'2025-06-01',1,'Approved',1,'06392197-9788-4af9-b2c5-18482655ef0b'),
101(46,1,3,2,'2025-06-01',1,'Approved',1,'06392197-9788-4af9-b2c5-18482655ef0b'),
102(47,1,3,2,'2025-06-01',1,'Approved',1,'09909582-a574-4a4c-9ee7-52e443345ed9'),
103(48,1,3,4,'2025-06-01',1,'Approved',1,'09909582-a574-4a4c-9ee7-52e443345ed9'),
104(49,1,3,5,'2025-06-01',1,'Approved',1,'a1e0a1de-14eb-45fa-b58c-682a5ea5f357'),
105(50,1,3,1,'2025-06-01',1,'Approved',1,'cecc23a9-21a8-4dce-9b90-b3e7980fdecf'),
106(51,1,3,3,'2025-06-01',1,'Approved',1,'cecc23a9-21a8-4dce-9b90-b3e7980fdecf'),
107(52,1,3,2,'2025-06-01',1,'Approved',1,'74589bc5-00b8-4914-9bc4-640a6e9653d9'),
108(53,1,3,4,'2025-06-01',1,'Approved',1,'74589bc5-00b8-4914-9bc4-640a6e9653d9'),
109(54,1,5,4,'2025-06-03',1,'Approved',1,'38a3bb62-7d7f-413d-81c5-b89e2b44cb22'),
110(55,1,3,1,'2025-06-03',1,'Approved',1,'f4b1417e-8695-469a-a36f-a0819ed61ac3'),
111(56,1,3,2,'2025-06-03',1,'Approved',1,'54fecf01-70e3-4e48-b2aa-0dad10ea2138'),
112(57,1,3,2,'2025-06-03',1,'Approved',1,'27e5fd60-78b0-4ba2-aca5-9bd6243e7940'),
113(58,1,3,4,'2025-06-03',1,'Approved',1,'b0d94491-5ef1-458b-b55e-6e291702fb16'),
114(59,1,3,2,'2025-06-03',1,'Approved',1,'2963e415-3cd8-4ce1-8ac4-f6b400646447'),
115(60,1,3,3,'2025-06-04',1,'Approved',1,'f8e05dc9-cb2d-4c1a-bac4-c6eaf0ad03b8'),
116(61,1,3,4,'2025-06-04',1,'Approved',1,'f8e05dc9-cb2d-4c1a-bac4-c6eaf0ad03b8'),
117(62,1,3,2,'2025-06-04',1,'Approved',1,'26c2e101-ea4c-42c0-b1f4-0b70e4370c22'),
118(63,1,3,4,'2025-06-04',1,'Approved',1,'26c2e101-ea4c-42c0-b1f4-0b70e4370c22'),
119(64,1,3,8,'2025-06-04',1,'Approved',1,'52485536-17f9-42f5-8706-e2a6f14dc86b');
120
121-- procurement_request
122INSERT INTO `procurement_request` VALUES
123(1,3,2,1,'2025-05-28 18:48:35','Rejected',NULL,'Reserved',95000.00,2280000.00,24,NULL,'Buy',NULL),
124(2,3,2,1,'2025-05-28 19:30:58','Rejected',NULL,'Reserved',95000.00,2280000.00,24,NULL,'Buy',NULL),
125(3,3,2,1,'2025-05-28 19:43:39','Rejected',NULL,'Reserved',95000.00,2280000.00,24,NULL,'Buy',NULL),
126(4,3,2,1,'2025-05-28 19:49:48','Rejected',NULL,'Reserved',NULL,95000.00,NULL,NULL,'Buy',NULL),
127(5,3,1,1,'2025-05-28 19:54:24','Rejected',NULL,'Reserved',120000.00,2880000.00,24,NULL,'Buy',NULL),
128(6,3,2,1,'2025-05-28 19:54:53','Rejected',NULL,'Reserved',95000.00,2280000.00,24,NULL,'Buy',NULL),
129(7,3,2,1,'2025-05-28 19:56:40','Rejected',NULL,'Reserved',100.00,2400.00,24,NULL,'Buy',NULL),
130(38,3,2,1,'2025-05-29 00:59:48','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy',NULL),
131(39,3,1,1,'2025-05-29 03:25:03','Rejected','Card','Reserved',2.81,36.53,13,5,'Rent',NULL),
132(40,3,1,1,'2025-05-29 23:35:28','Approved','Card','Reserved',NULL,101.00,NULL,5,'Buy',NULL),
133(41,3,1,1,'2025-05-30 00:10:51','Rejected','Card','Reserved',2.81,64.63,23,5,'Rent',NULL),
134(47,3,1,1,'2025-05-31 18:43:41','Rejected','Card','Reserved',NULL,3500.00,NULL,5,'Buy',NULL),
135(48,3,5,1,'2025-05-31 18:43:41','Approved','Card','Reserved',NULL,3300.00,NULL,5,'Buy',NULL),
136(49,3,1,1,'2025-05-31 18:57:00','Approved','Card','Reserved',NULL,3500.00,NULL,5,'Buy',NULL),
137(50,3,2,1,'2025-05-31 18:57:00','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy',NULL),
138(51,3,3,1,'2025-05-31 18:57:00','Approved','Card','Reserved',NULL,30000.00,NULL,5,'Buy',NULL),
139(52,3,4,1,'2025-05-31 19:07:38','Rejected','Card','Reserved',NULL,100.00,NULL,5,'Buy',NULL),
140(53,3,5,1,'2025-05-31 19:07:38','Rejected','Card','Reserved',NULL,3300.00,NULL,5,'Buy',NULL),
141(54,3,4,1,'2025-05-31 20:21:09','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','a3a71529-9c8d-4a0a-9d5a-aa454801b4ff'),
142(55,3,5,1,'2025-05-31 20:21:09','Rejected','Card','Refunded',NULL,3300.00,NULL,5,'Buy','a3a71529-9c8d-4a0a-9d5a-aa454801b4ff'),
143(56,3,4,1,'2025-05-31 20:26:49','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','ec53361e-8cc9-40e7-bb4f-1367573b76f8'),
144(57,3,5,1,'2025-05-31 20:26:49','Rejected','Card','Refunded',NULL,3300.00,NULL,5,'Buy','ec53361e-8cc9-40e7-bb4f-1367573b76f8'),
145(58,3,4,1,'2025-05-31 20:32:22','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','ab516bca-b99e-4c3a-8654-2c0116f60ef1'),
146(59,3,5,1,'2025-05-31 20:32:22','Rejected','Card','Refunded',NULL,3300.00,NULL,5,'Buy','ab516bca-b99e-4c3a-8654-2c0116f60ef1'),
147(60,3,4,1,'2025-05-31 21:43:51','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','d2f79fc8-dc44-4110-9abc-15a46d792e45'),
148(61,3,4,1,'2025-05-31 22:08:55','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','e07e9e86-66fd-437a-b2e1-d0fafce7690a'),
149(62,3,2,1,'2025-05-31 22:15:55','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','59fa5a1c-1057-4d73-8c52-0452a016e540'),
150(63,3,4,1,'2025-05-31 22:15:55','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','59fa5a1c-1057-4d73-8c52-0452a016e540'),
151(64,3,5,1,'2025-05-31 22:27:56','Approved','Card','Reserved',91.67,91.67,1,5,'Rent','4eddd7f5-c077-453a-9c92-7319764eb2d9'),
152(65,3,4,1,'2025-05-31 23:46:50','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
153(66,3,2,1,'2025-05-31 23:46:50','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
154(67,3,1,1,'2025-06-01 00:12:25','Approved','Card','Reserved',97.22,3499.92,36,5,'Rent','4f4d2173-9167-40f7-bdd3-223316070bd8'),
155(68,3,4,1,'2025-06-01 00:19:19','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','06392197-9788-4af9-b2c5-18482655ef0b'),
156(69,3,2,1,'2025-06-01 00:19:19','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','06392197-9788-4af9-b2c5-18482655ef0b'),
157(70,3,2,1,'2025-06-01 02:28:44','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','09909582-a574-4a4c-9ee7-52e443345ed9'),
158(71,3,4,1,'2025-06-01 02:28:44','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','09909582-a574-4a4c-9ee7-52e443345ed9'),
159(72,3,5,1,'2025-06-01 02:29:14','Approved','Card','Reserved',91.67,2750.10,30,5,'Rent','a1e0a1de-14eb-45fa-b58c-682a5ea5f357'),
160(73,3,1,1,'2025-06-01 02:40:15','Rejected','Card','Refunded',NULL,3500.00,NULL,5,'Buy','de010939-bd22-4e53-beb4-64a1839d0705'),
161(74,3,3,1,'2025-06-01 02:40:15','Rejected','Card','Refunded',NULL,30000.00,NULL,5,'Buy','de010939-bd22-4e53-beb4-64a1839d0705'),
162(75,3,1,1,'2025-06-01 02:52:09','Rejected','Card','Refunded',NULL,3500.00,NULL,5,'Buy','896e19a0-3948-49d3-ad1a-b342a958c298'),
163(76,3,3,1,'2025-06-01 02:52:09','Rejected','Card','Refunded',NULL,30000.00,NULL,5,'Buy','896e19a0-3948-49d3-ad1a-b342a958c298'),
164(77,3,1,1,'2025-06-01 02:59:13','Approved','Card','Reserved',NULL,3500.00,NULL,5,'Buy','cecc23a9-21a8-4dce-9b90-b3e7980fdecf'),
165(78,3,3,1,'2025-06-01 02:59:13','Approved','Card','Reserved',NULL,30000.00,NULL,5,'Buy','cecc23a9-21a8-4dce-9b90-b3e7980fdecf'),
166(79,3,2,1,'2025-06-01 03:12:18','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','74589bc5-00b8-4914-9bc4-640a6e9653d9'),
167(80,3,4,1,'2025-06-01 03:12:18','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','74589bc5-00b8-4914-9bc4-640a6e9653d9'),
168(81,5,2,1,'2025-06-02 11:52:48','Rejected','Card','Refunded',NULL,100.00,NULL,9,'Buy','a9420694-235d-4f22-b622-1a77e03f737e'),
169(82,5,4,1,'2025-06-02 11:52:48','Rejected','Card','Refunded',NULL,100.00,NULL,9,'Buy','a9420694-235d-4f22-b622-1a77e03f737e'),
170(83,3,1,1,'2025-06-02 12:31:02','Rejected','Card','Refunded',NULL,3500.00,NULL,5,'Buy','197813dc-a87f-49a4-8b8b-7ecc92b3619d'),
171(84,3,2,1,'2025-06-02 12:31:02','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','197813dc-a87f-49a4-8b8b-7ecc92b3619d'),
172(85,3,4,1,'2025-06-03 19:51:32','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','74f61e0d-69bf-42e2-8558-2d2167822b59'),
173(86,5,4,1,'2025-06-03 19:53:55','Approved','Card','Reserved',NULL,100.00,NULL,9,'Buy','38a3bb62-7d7f-413d-81c5-b89e2b44cb22'),
174(87,3,2,1,'2025-06-03 20:59:36','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','5ce75e52-6001-4688-b4b1-79fe0e720506'),
175(88,3,1,1,'2025-06-03 21:00:11','Approved','Card','Reserved',NULL,3500.00,NULL,5,'Buy','f4b1417e-8695-469a-a36f-a0819ed61ac3'),
176(89,3,2,1,'2025-06-03 21:17:28','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','54fecf01-70e3-4e48-b2aa-0dad10ea2138'),
177(90,3,2,1,'2025-06-03 21:33:19','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','27e5fd60-78b0-4ba2-aca5-9bd6243e7940'),
178(91,3,4,1,'2025-06-03 21:42:16','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','b0d94491-5ef1-458b-b55e-6e291702fb16'),
179(92,3,2,1,'2025-06-03 21:44:21','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','2963e415-3cd8-4ce1-8ac4-f6b400646447'),
180(93,3,3,1,'2025-06-04 00:34:15','Approved','Card','Reserved',NULL,300.00,NULL,5,'Buy','f8e05dc9-cb2d-4c1a-bac4-c6eaf0ad03b8'),
181(94,3,4,1,'2025-06-04 00:34:15','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','f8e05dc9-cb2d-4c1a-bac4-c6eaf0ad03b8'),
182(95,3,2,1,'2025-06-04 13:10:35','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','26c2e101-ea4c-42c0-b1f4-0b70e4370c22'),
183(96,3,4,1,'2025-06-04 13:10:35','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','26c2e101-ea4c-42c0-b1f4-0b70e4370c22'),
184(97,3,8,1,'2025-06-04 13:50:20','Approved','Card','Reserved',NULL,300.00,NULL,5,'Buy','52485536-17f9-42f5-8706-e2a6f14dc86b');
185
186-- customerfeedback
187INSERT INTO `customerfeedback` VALUES
188(1,1,1,5,'Odlichen kamion, mnogu zadovolen!','2025-04-05',1),
189(2,2,2,4,'Dobar kamion, no malo skapo.','2025-04-15',2),
190(3,3,1,1,'test 1 feedback','2025-05-22',22),
191(4,3,1,5,'test 2 feedback','2025-05-22',20),
192(5,3,1,3,'test 3 feedback','2025-05-22',11),
193(6,3,2,5,'Test za Procurement','2025-05-26',23),
194(7,3,2,3,'test test','2025-05-26',24),
195(8,3,3,5,'ff','2025-05-28',26),
196(9,3,2,5,'test so wallet ','2025-05-29',28),
197(10,3,1,1,'dd','2025-05-29',29),
198(11,3,1,5,'tt','2025-06-01',44),
199(12,3,2,1,'rtrf','2025-06-01',43),
200(13,3,4,5,'test v3','2025-06-01',48),
201(14,3,4,5,'sdsd','2025-06-04',61);
202
203-- truck
204INSERT INTO `truck` VALUES
205(1,750),(2,500),(4,999),(6,750),(7,750),(10,999),(11,999),(12,500),(13,500);
206
207-- trailer
208INSERT INTO `trailer` VALUES
209(3,20.50),(5,99.00),(8,20.50),(9,20.50);
210
211-- t_type
212INSERT INTO `t_type` VALUES
213(3,'Buy',NULL,NULL,30000.00),
214(11,'Buy',NULL,NULL,120000.00),
215(12,'Rent',24,3958.33,95000.00),
216(13,'Rent',2,15000.00,30000.00),
217(14,'Rent',2,2638.89,5277.78),
218(15,'Buy',NULL,NULL,30000.00),
219(16,'Rent',36,3333.33,119999.88),
220(17,'Buy',NULL,NULL,95000.00),
221(18,'Buy',NULL,NULL,120000.00),
222(19,'Rent',2,3333.33,6666.66),
223(20,'Rent',20,3333.33,66666.60),
224(21,'Buy',NULL,NULL,95000.00),
225(22,'Buy',NULL,NULL,120000.00),
226(23,'Rent',1,2638.89,2638.89),
227(24,'Buy',NULL,NULL,95000.00),
228(25,'Buy',NULL,NULL,120000.00),
229(26,'Buy',NULL,NULL,30000.00),
230(27,'Rent',2,2.78,5.56),
231(28,'Buy',NULL,NULL,100.00),
232(29,'Buy',NULL,NULL,101.00),
233(30,'Buy',NULL,NULL,3300.00),
234(31,'Buy',NULL,NULL,30000.00),
235(32,'Buy',NULL,NULL,100.00),
236(33,'Buy',NULL,NULL,3500.00),
237(40,'Buy',NULL,NULL,100.00),
238(41,'Buy',NULL,NULL,100.00),
239(42,'Buy',NULL,NULL,100.00),
240(43,'Buy',NULL,NULL,100.00),
241(44,'Rent',36,97.22,3499.92),
242(45,'Buy',NULL,NULL,100.00),
243(46,'Buy',NULL,NULL,100.00),
244(47,'Buy',NULL,NULL,100.00),
245(48,'Buy',NULL,NULL,100.00),
246(49,'Rent',30,91.67,2750.10),
247(50,'Buy',NULL,NULL,3500.00),
248(51,'Buy',NULL,NULL,30000.00),
249(52,'Buy',NULL,NULL,100.00),
250(53,'Buy',NULL,NULL,100.00),
251(54,'Buy',NULL,NULL,100.00),
252(55,'Buy',NULL,NULL,3500.00),
253(56,'Buy',NULL,NULL,100.00),
254(57,'Buy',NULL,NULL,100.00),
255(58,'Buy',NULL,NULL,100.00),
256(59,'Buy',NULL,NULL,100.00),
257(60,'Buy',NULL,NULL,300.00),
258(61,'Buy',NULL,NULL,100.00),
259(62,'Buy',NULL,NULL,100.00),
260(63,'Buy',NULL,NULL,100.00),
261(64,'Buy',NULL,NULL,300.00);
262
263-- views
264INSERT INTO `views` VALUES
265(1,1),(2,2),(1,3);
266
267-- wallet
268INSERT INTO `wallet` VALUES
269(5,3,27010854.31,'4444444444444444','2027-12-31','123','David Trajchev'),
270(6,4,3000.00,'5500000000000004','2028-11-30','456','David-v2 Trajchev'),
271(7,2,3000.00,'5500000000000000','2026-11-30','456','Elena Stojanova'),
272(8,2,3000.00,'5500000000000001','2026-11-30','456','David Trajchev'),
273(9,5,2705.56,'5500000000000001','2026-11-30','456','David Trajchev');
274```
275
276---
277
278Оваа скрипта можеш да ја извршиш во MySQL Workbench, phpMyAdmin или преку MySQL командна линија за да ги внесеш сите податоци во твојата база[1].
279Ако ти треба и DDL (структурна) скрипта, слободно прашај!
280
281[1] https://ppl-ai-file-upload.s3.amazonaws.com/web/direct-files/attachments/45354281/264db44a-986b-4227-8c93-895c3208f4fd/paste.txt
282[2] https://www.youtube.com/watch?v=7sGFa6Q3LXU
283[3] https://docs.tdengine.com/cloud/programming/insert/
284[4] https://www.sourcecodester.com/tutorials/php/9221/inserting-data-using-php-mysql-database.html
285[5] https://www.lenovo.com/in/en/glossary/data-dump/
286[6] https://stackoverflow.com/questions/982568/what-is-the-best-way-to-auto-generate-insert-statements-for-a-sql-server-table
287[7] https://forum.dcs.world/topic/290975-dml-mission-creation-toolbox-no-lua-required/page/58/
288[8] https://forum.cfx.re/t/release-paid-trucking-simulator-euro-truck-simulator-esx-vrp/3525311?page=2
289[9] https://forum.cfx.re/t/release-paid-trucking-simulator-euro-truck-simulator-esx-vrp/3525311?page=3
290[10] http://cdn.akamai.steamstatic.com/steam/apps/270880/manuals/ATS_manual_digital.pdf
291[11] https://www.gta5-mods.com/scripts/farim-mod