-- customer
INSERT INTO `customer` VALUES 
(1,'Marko','Markovski','marko@example.com','Street 123, Skopje','070123456','marko123'),
(2,'Elena','Stojanova','elena@example.com','Boulevard 45, Bitola','071987654','elena123'),
(3,'David','Trajchev','davidtrajchev@gmail.com','UL.ANASTAS MITREV BR.4/1-2','076999813','$2b$10$1zc9OAt9TJLKGx7qQe2p7.8kVFao1dqOiPNacw4eT7EXGVFNQ1AsW'),
(4,'David-v2','Trajchev','V2davidtrajchev@gmail.com','UL.ANASTAS MITREV BR.4/1-2','077999813','$2b$10$4IlcLjFqjDtQd0bOMxLP7eyU4hUBlUm.iBp2mOoHtX3KnDKYtXQPe'),
(5,'Davidd','Trajchev','ddavidtrajchev@gmail.com','UL.ANASTAS MITREV BR.4/1-2','076999813','$2b$10$Ujq1p39MmCJob/lP7mrW5.Z12rjApH8mKAVBQyYzc0IJMHhoB86GC');

-- employee
INSERT INTO `employee` VALUES 
(1,'Ivan','Petrov','Sales Manager','Sales','ivan@example.com','ivan123'),
(2,'Ana','Kostova','Maintenance Specialist','Maintenance','ana@example.com','ana123'),
(1000,'Admin','User','Admin','Admin','admin@example.com','admin123'),
(1001,'David','Trajchev','Test','Maintenance','david@example.com','david123'),
(1002,'Leon','Zlatkovski','Test 2','Sales','leon@example.com','leon123'),
(1003,'Test','test','Test 3','Sales','test@example.com','test123'),
(1004,'v2 test','v2 test','v2 test','Sales','v2 test@example.com','v2 test123'),
(1005,'V2','TEST','V2 tESTER','Maintenance','v2@example.com','v2123');

-- product
INSERT INTO `product` VALUES 
(1,'Volvo FH16',3500.00,'SK-1234-AB','sold'),
(2,'Scania R500',100.00,'BT-5678-CD','sold'),
(3,'Kögel Trailer',300.00,'SK-2468-EF','available'),
(4,'DAF(808)',100.00,'SK-1111-LL','sold'),
(5,'Test V2',3300.00,'SK-1111-TT','rented'),
(6,'Volvo FH16',3500.00,'SK-1235-AB','available'),
(7,'Volvo FH16',3500.00,'SK-1236-AB','available'),
(8,'Kögel Trailer',300.00,'SK-2469-EF','sold'),
(9,'Kögel Trailer',300.00,'SK-2470-EF','available'),
(10,'DAF(808)',100.00,'SK-1112-LL','available'),
(11,'DAF(808)',100.00,'SK-1113-LL','available'),
(12,'Scania R500',100.00,'BT-5679-CD','available'),
(13,'Scania R500',100.00,'BT-5680-CD','available');

-- maintenance
INSERT INTO `maintenance` VALUES 
(2,2,2,'2025-05-04','0',0.00,'Completed','2025-06-01 13:27:50',NULL),
(3,2,NULL,'2025-05-22','',0.00,'Pending','2025-06-01 13:27:50',NULL),
(4,2,NULL,'2025-05-22','',0.00,'Pending','2025-06-01 13:27:50',NULL),
(5,2,1,'2025-05-22','test test',100.00,'Completed','2025-06-01 13:27:50',NULL),
(6,2,1,'2025-05-22','asasasasasa',0.00,'Completed','2025-06-01 13:27:50',NULL),
(7,2,2,'2025-05-22','0',0.00,'Completed','2025-06-01 13:27:50',NULL),
(8,2,2,'2025-05-22','test2-0 completed',100.00,'Completed','2025-06-01 13:27:50',NULL),
(9,2,3,'2025-05-26','Zavrshen Test',100.00,'Completed','2025-06-01 13:27:50',NULL),
(10,2,3,'2025-05-26','ss',1.00,'Completed','2025-06-01 13:27:50',NULL),
(11,2,1,'2025-05-26','test 22',100.00,'Completed','2025-06-01 13:27:50',NULL),
(12,2,1,'2025-05-27','test v2 works',0.00,'Completed','2025-06-01 13:27:50',NULL),
(13,2,1,'2025-05-29','works',0.00,'Completed','2025-06-01 13:27:50',NULL),
(14,2,1,'2025-05-29','xx',0.00,'Completed','2025-06-01 13:27:50',NULL),
(15,2,1,'2025-06-01','test 3 done',10.00,'Completed','2025-06-01 13:32:02','2025-06-01 13:33:58'),
(16,2,2,'2025-06-04','ff',0.00,'Completed','2025-06-04 00:36:29','2025-06-04 00:40:40');

-- procurement
INSERT INTO `procurement` VALUES 
(1,1,1,1,'2025-04-01',1,'Rejected',0,NULL),
(2,1,2,2,'2025-04-10',1,'Rejected',0,NULL),
(3,1,2,3,'2025-05-04',1,'Rejected',0,NULL),
(4,1,3,1,'2025-05-20',1,'Approved',1,NULL),
(5,1,3,2,'2025-05-20',1,'Approved',1,NULL),
(6,1,3,1,'2025-05-20',1,'Rejected',1,NULL),
(7,1,3,1,'2025-05-20',1,'Rejected',1,NULL),
(8,1,3,3,'2025-05-20',1,'Rejected',1,NULL),
(9,1,3,3,'2025-05-20',1,'Approved',1,NULL),
(10,2,3,3,'2025-05-20',1,'Rejected',1,NULL),
(11,2,3,1,'2025-05-20',1,'Approved',1,NULL),
(12,2,3,2,'2025-05-20',1,'Rejected',1,NULL),
(13,2,3,3,'2025-05-20',1,'Approved',1,NULL),
(14,2,3,2,'2025-05-20',1,'Approved',1,NULL),
(15,2,3,3,'2025-05-20',1,'Approved',1,NULL),
(16,2,3,1,'2025-05-20',1,'Approved',1,NULL),
(17,2,3,2,'2025-05-20',1,'Approved',1,NULL),
(18,2,3,1,'2025-05-20',1,'Approved',1,NULL),
(19,2,3,1,'2025-05-20',1,'Rejected',1,NULL),
(20,2,3,1,'2025-05-20',1,'Approved',1,NULL),
(21,2,3,2,'2025-05-20',1,'Rejected',1,NULL),
(22,1,3,1,'2025-05-22',1,'Approved',1,NULL),
(23,1,3,2,'2025-05-26',1,'Approved',1,NULL),
(24,1,3,2,'2025-05-26',1,'Approved',1,NULL),
(25,NULL,3,1,'2025-05-26',1,'Rejected',1,NULL),
(26,1,3,3,'2025-05-27',1,'Approved',1,NULL),
(27,1,3,4,'2025-05-28',1,'Approved',1,NULL),
(28,1,3,2,'2025-05-29',1,'Approved',1,NULL),
(29,1,3,1,'2025-05-29',1,'Approved',1,NULL),
(30,1,3,5,'2025-05-31',1,'Approved',1,NULL),
(31,1,3,3,'2025-05-31',1,'Approved',1,NULL),
(32,1,3,2,'2025-05-31',1,'Approved',1,NULL),
(33,1,3,1,'2025-05-31',1,'Approved',1,NULL),
(34,1,3,2,'2025-05-31',1,'Approved',1,'59fa5a1c-1057-4d73-8c52-0452a016e540'),
(35,1,3,2,'2025-05-31',1,'Approved',1,'59fa5a1c-1057-4d73-8c52-0452a016e540'),
(36,1,3,2,'2025-05-31',1,'Approved',1,'59fa5a1c-1057-4d73-8c52-0452a016e540'),
(37,1,3,4,'2025-05-31',1,'Approved',1,'59fa5a1c-1057-4d73-8c52-0452a016e540'),
(38,1,3,5,'2025-05-31',1,'Approved',1,'4eddd7f5-c077-453a-9c92-7319764eb2d9'),
(39,1,3,4,'2025-05-31',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
(40,1,3,4,'2025-05-31',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
(41,1,3,4,'2025-06-01',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
(42,1,3,4,'2025-06-01',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
(43,1,3,2,'2025-06-01',1,'Approved',1,'3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
(44,1,3,1,'2025-06-01',1,'Approved',1,'4f4d2173-9167-40f7-bdd3-223316070bd8'),
(45,1,3,4,'2025-06-01',1,'Approved',1,'06392197-9788-4af9-b2c5-18482655ef0b'),
(46,1,3,2,'2025-06-01',1,'Approved',1,'06392197-9788-4af9-b2c5-18482655ef0b'),
(47,1,3,2,'2025-06-01',1,'Approved',1,'09909582-a574-4a4c-9ee7-52e443345ed9'),
(48,1,3,4,'2025-06-01',1,'Approved',1,'09909582-a574-4a4c-9ee7-52e443345ed9'),
(49,1,3,5,'2025-06-01',1,'Approved',1,'a1e0a1de-14eb-45fa-b58c-682a5ea5f357'),
(50,1,3,1,'2025-06-01',1,'Approved',1,'cecc23a9-21a8-4dce-9b90-b3e7980fdecf'),
(51,1,3,3,'2025-06-01',1,'Approved',1,'cecc23a9-21a8-4dce-9b90-b3e7980fdecf'),
(52,1,3,2,'2025-06-01',1,'Approved',1,'74589bc5-00b8-4914-9bc4-640a6e9653d9'),
(53,1,3,4,'2025-06-01',1,'Approved',1,'74589bc5-00b8-4914-9bc4-640a6e9653d9'),
(54,1,5,4,'2025-06-03',1,'Approved',1,'38a3bb62-7d7f-413d-81c5-b89e2b44cb22'),
(55,1,3,1,'2025-06-03',1,'Approved',1,'f4b1417e-8695-469a-a36f-a0819ed61ac3'),
(56,1,3,2,'2025-06-03',1,'Approved',1,'54fecf01-70e3-4e48-b2aa-0dad10ea2138'),
(57,1,3,2,'2025-06-03',1,'Approved',1,'27e5fd60-78b0-4ba2-aca5-9bd6243e7940'),
(58,1,3,4,'2025-06-03',1,'Approved',1,'b0d94491-5ef1-458b-b55e-6e291702fb16'),
(59,1,3,2,'2025-06-03',1,'Approved',1,'2963e415-3cd8-4ce1-8ac4-f6b400646447'),
(60,1,3,3,'2025-06-04',1,'Approved',1,'f8e05dc9-cb2d-4c1a-bac4-c6eaf0ad03b8'),
(61,1,3,4,'2025-06-04',1,'Approved',1,'f8e05dc9-cb2d-4c1a-bac4-c6eaf0ad03b8'),
(62,1,3,2,'2025-06-04',1,'Approved',1,'26c2e101-ea4c-42c0-b1f4-0b70e4370c22'),
(63,1,3,4,'2025-06-04',1,'Approved',1,'26c2e101-ea4c-42c0-b1f4-0b70e4370c22'),
(64,1,3,8,'2025-06-04',1,'Approved',1,'52485536-17f9-42f5-8706-e2a6f14dc86b');

-- procurement_request
INSERT INTO `procurement_request` VALUES 
(1,3,2,1,'2025-05-28 18:48:35','Rejected',NULL,'Reserved',95000.00,2280000.00,24,NULL,'Buy',NULL),
(2,3,2,1,'2025-05-28 19:30:58','Rejected',NULL,'Reserved',95000.00,2280000.00,24,NULL,'Buy',NULL),
(3,3,2,1,'2025-05-28 19:43:39','Rejected',NULL,'Reserved',95000.00,2280000.00,24,NULL,'Buy',NULL),
(4,3,2,1,'2025-05-28 19:49:48','Rejected',NULL,'Reserved',NULL,95000.00,NULL,NULL,'Buy',NULL),
(5,3,1,1,'2025-05-28 19:54:24','Rejected',NULL,'Reserved',120000.00,2880000.00,24,NULL,'Buy',NULL),
(6,3,2,1,'2025-05-28 19:54:53','Rejected',NULL,'Reserved',95000.00,2280000.00,24,NULL,'Buy',NULL),
(7,3,2,1,'2025-05-28 19:56:40','Rejected',NULL,'Reserved',100.00,2400.00,24,NULL,'Buy',NULL),
(38,3,2,1,'2025-05-29 00:59:48','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy',NULL),
(39,3,1,1,'2025-05-29 03:25:03','Rejected','Card','Reserved',2.81,36.53,13,5,'Rent',NULL),
(40,3,1,1,'2025-05-29 23:35:28','Approved','Card','Reserved',NULL,101.00,NULL,5,'Buy',NULL),
(41,3,1,1,'2025-05-30 00:10:51','Rejected','Card','Reserved',2.81,64.63,23,5,'Rent',NULL),
(47,3,1,1,'2025-05-31 18:43:41','Rejected','Card','Reserved',NULL,3500.00,NULL,5,'Buy',NULL),
(48,3,5,1,'2025-05-31 18:43:41','Approved','Card','Reserved',NULL,3300.00,NULL,5,'Buy',NULL),
(49,3,1,1,'2025-05-31 18:57:00','Approved','Card','Reserved',NULL,3500.00,NULL,5,'Buy',NULL),
(50,3,2,1,'2025-05-31 18:57:00','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy',NULL),
(51,3,3,1,'2025-05-31 18:57:00','Approved','Card','Reserved',NULL,30000.00,NULL,5,'Buy',NULL),
(52,3,4,1,'2025-05-31 19:07:38','Rejected','Card','Reserved',NULL,100.00,NULL,5,'Buy',NULL),
(53,3,5,1,'2025-05-31 19:07:38','Rejected','Card','Reserved',NULL,3300.00,NULL,5,'Buy',NULL),
(54,3,4,1,'2025-05-31 20:21:09','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','a3a71529-9c8d-4a0a-9d5a-aa454801b4ff'),
(55,3,5,1,'2025-05-31 20:21:09','Rejected','Card','Refunded',NULL,3300.00,NULL,5,'Buy','a3a71529-9c8d-4a0a-9d5a-aa454801b4ff'),
(56,3,4,1,'2025-05-31 20:26:49','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','ec53361e-8cc9-40e7-bb4f-1367573b76f8'),
(57,3,5,1,'2025-05-31 20:26:49','Rejected','Card','Refunded',NULL,3300.00,NULL,5,'Buy','ec53361e-8cc9-40e7-bb4f-1367573b76f8'),
(58,3,4,1,'2025-05-31 20:32:22','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','ab516bca-b99e-4c3a-8654-2c0116f60ef1'),
(59,3,5,1,'2025-05-31 20:32:22','Rejected','Card','Refunded',NULL,3300.00,NULL,5,'Buy','ab516bca-b99e-4c3a-8654-2c0116f60ef1'),
(60,3,4,1,'2025-05-31 21:43:51','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','d2f79fc8-dc44-4110-9abc-15a46d792e45'),
(61,3,4,1,'2025-05-31 22:08:55','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','e07e9e86-66fd-437a-b2e1-d0fafce7690a'),
(62,3,2,1,'2025-05-31 22:15:55','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','59fa5a1c-1057-4d73-8c52-0452a016e540'),
(63,3,4,1,'2025-05-31 22:15:55','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','59fa5a1c-1057-4d73-8c52-0452a016e540'),
(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'),
(65,3,4,1,'2025-05-31 23:46:50','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
(66,3,2,1,'2025-05-31 23:46:50','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','3d2fefa9-f9ba-4c15-a33d-8554f554a289'),
(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'),
(68,3,4,1,'2025-06-01 00:19:19','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','06392197-9788-4af9-b2c5-18482655ef0b'),
(69,3,2,1,'2025-06-01 00:19:19','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','06392197-9788-4af9-b2c5-18482655ef0b'),
(70,3,2,1,'2025-06-01 02:28:44','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','09909582-a574-4a4c-9ee7-52e443345ed9'),
(71,3,4,1,'2025-06-01 02:28:44','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','09909582-a574-4a4c-9ee7-52e443345ed9'),
(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'),
(73,3,1,1,'2025-06-01 02:40:15','Rejected','Card','Refunded',NULL,3500.00,NULL,5,'Buy','de010939-bd22-4e53-beb4-64a1839d0705'),
(74,3,3,1,'2025-06-01 02:40:15','Rejected','Card','Refunded',NULL,30000.00,NULL,5,'Buy','de010939-bd22-4e53-beb4-64a1839d0705'),
(75,3,1,1,'2025-06-01 02:52:09','Rejected','Card','Refunded',NULL,3500.00,NULL,5,'Buy','896e19a0-3948-49d3-ad1a-b342a958c298'),
(76,3,3,1,'2025-06-01 02:52:09','Rejected','Card','Refunded',NULL,30000.00,NULL,5,'Buy','896e19a0-3948-49d3-ad1a-b342a958c298'),
(77,3,1,1,'2025-06-01 02:59:13','Approved','Card','Reserved',NULL,3500.00,NULL,5,'Buy','cecc23a9-21a8-4dce-9b90-b3e7980fdecf'),
(78,3,3,1,'2025-06-01 02:59:13','Approved','Card','Reserved',NULL,30000.00,NULL,5,'Buy','cecc23a9-21a8-4dce-9b90-b3e7980fdecf'),
(79,3,2,1,'2025-06-01 03:12:18','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','74589bc5-00b8-4914-9bc4-640a6e9653d9'),
(80,3,4,1,'2025-06-01 03:12:18','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','74589bc5-00b8-4914-9bc4-640a6e9653d9'),
(81,5,2,1,'2025-06-02 11:52:48','Rejected','Card','Refunded',NULL,100.00,NULL,9,'Buy','a9420694-235d-4f22-b622-1a77e03f737e'),
(82,5,4,1,'2025-06-02 11:52:48','Rejected','Card','Refunded',NULL,100.00,NULL,9,'Buy','a9420694-235d-4f22-b622-1a77e03f737e'),
(83,3,1,1,'2025-06-02 12:31:02','Rejected','Card','Refunded',NULL,3500.00,NULL,5,'Buy','197813dc-a87f-49a4-8b8b-7ecc92b3619d'),
(84,3,2,1,'2025-06-02 12:31:02','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','197813dc-a87f-49a4-8b8b-7ecc92b3619d'),
(85,3,4,1,'2025-06-03 19:51:32','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','74f61e0d-69bf-42e2-8558-2d2167822b59'),
(86,5,4,1,'2025-06-03 19:53:55','Approved','Card','Reserved',NULL,100.00,NULL,9,'Buy','38a3bb62-7d7f-413d-81c5-b89e2b44cb22'),
(87,3,2,1,'2025-06-03 20:59:36','Rejected','Card','Refunded',NULL,100.00,NULL,5,'Buy','5ce75e52-6001-4688-b4b1-79fe0e720506'),
(88,3,1,1,'2025-06-03 21:00:11','Approved','Card','Reserved',NULL,3500.00,NULL,5,'Buy','f4b1417e-8695-469a-a36f-a0819ed61ac3'),
(89,3,2,1,'2025-06-03 21:17:28','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','54fecf01-70e3-4e48-b2aa-0dad10ea2138'),
(90,3,2,1,'2025-06-03 21:33:19','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','27e5fd60-78b0-4ba2-aca5-9bd6243e7940'),
(91,3,4,1,'2025-06-03 21:42:16','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','b0d94491-5ef1-458b-b55e-6e291702fb16'),
(92,3,2,1,'2025-06-03 21:44:21','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','2963e415-3cd8-4ce1-8ac4-f6b400646447'),
(93,3,3,1,'2025-06-04 00:34:15','Approved','Card','Reserved',NULL,300.00,NULL,5,'Buy','f8e05dc9-cb2d-4c1a-bac4-c6eaf0ad03b8'),
(94,3,4,1,'2025-06-04 00:34:15','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','f8e05dc9-cb2d-4c1a-bac4-c6eaf0ad03b8'),
(95,3,2,1,'2025-06-04 13:10:35','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','26c2e101-ea4c-42c0-b1f4-0b70e4370c22'),
(96,3,4,1,'2025-06-04 13:10:35','Approved','Card','Reserved',NULL,100.00,NULL,5,'Buy','26c2e101-ea4c-42c0-b1f4-0b70e4370c22'),
(97,3,8,1,'2025-06-04 13:50:20','Approved','Card','Reserved',NULL,300.00,NULL,5,'Buy','52485536-17f9-42f5-8706-e2a6f14dc86b');

-- customerfeedback
INSERT INTO `customerfeedback` VALUES 
(1,1,1,5,'Odlichen kamion, mnogu zadovolen!','2025-04-05',1),
(2,2,2,4,'Dobar kamion, no malo skapo.','2025-04-15',2),
(3,3,1,1,'test 1 feedback','2025-05-22',22),
(4,3,1,5,'test 2 feedback','2025-05-22',20),
(5,3,1,3,'test 3 feedback','2025-05-22',11),
(6,3,2,5,'Test za Procurement','2025-05-26',23),
(7,3,2,3,'test test','2025-05-26',24),
(8,3,3,5,'ff','2025-05-28',26),
(9,3,2,5,'test so wallet ','2025-05-29',28),
(10,3,1,1,'dd','2025-05-29',29),
(11,3,1,5,'tt','2025-06-01',44),
(12,3,2,1,'rtrf','2025-06-01',43),
(13,3,4,5,'test v3','2025-06-01',48),
(14,3,4,5,'sdsd','2025-06-04',61);

-- truck
INSERT INTO `truck` VALUES 
(1,750),(2,500),(4,999),(6,750),(7,750),(10,999),(11,999),(12,500),(13,500);

-- trailer
INSERT INTO `trailer` VALUES 
(3,20.50),(5,99.00),(8,20.50),(9,20.50);

-- t_type
INSERT INTO `t_type` VALUES 
(3,'Buy',NULL,NULL,30000.00),
(11,'Buy',NULL,NULL,120000.00),
(12,'Rent',24,3958.33,95000.00),
(13,'Rent',2,15000.00,30000.00),
(14,'Rent',2,2638.89,5277.78),
(15,'Buy',NULL,NULL,30000.00),
(16,'Rent',36,3333.33,119999.88),
(17,'Buy',NULL,NULL,95000.00),
(18,'Buy',NULL,NULL,120000.00),
(19,'Rent',2,3333.33,6666.66),
(20,'Rent',20,3333.33,66666.60),
(21,'Buy',NULL,NULL,95000.00),
(22,'Buy',NULL,NULL,120000.00),
(23,'Rent',1,2638.89,2638.89),
(24,'Buy',NULL,NULL,95000.00),
(25,'Buy',NULL,NULL,120000.00),
(26,'Buy',NULL,NULL,30000.00),
(27,'Rent',2,2.78,5.56),
(28,'Buy',NULL,NULL,100.00),
(29,'Buy',NULL,NULL,101.00),
(30,'Buy',NULL,NULL,3300.00),
(31,'Buy',NULL,NULL,30000.00),
(32,'Buy',NULL,NULL,100.00),
(33,'Buy',NULL,NULL,3500.00),
(40,'Buy',NULL,NULL,100.00),
(41,'Buy',NULL,NULL,100.00),
(42,'Buy',NULL,NULL,100.00),
(43,'Buy',NULL,NULL,100.00),
(44,'Rent',36,97.22,3499.92),
(45,'Buy',NULL,NULL,100.00),
(46,'Buy',NULL,NULL,100.00),
(47,'Buy',NULL,NULL,100.00),
(48,'Buy',NULL,NULL,100.00),
(49,'Rent',30,91.67,2750.10),
(50,'Buy',NULL,NULL,3500.00),
(51,'Buy',NULL,NULL,30000.00),
(52,'Buy',NULL,NULL,100.00),
(53,'Buy',NULL,NULL,100.00),
(54,'Buy',NULL,NULL,100.00),
(55,'Buy',NULL,NULL,3500.00),
(56,'Buy',NULL,NULL,100.00),
(57,'Buy',NULL,NULL,100.00),
(58,'Buy',NULL,NULL,100.00),
(59,'Buy',NULL,NULL,100.00),
(60,'Buy',NULL,NULL,300.00),
(61,'Buy',NULL,NULL,100.00),
(62,'Buy',NULL,NULL,100.00),
(63,'Buy',NULL,NULL,100.00),
(64,'Buy',NULL,NULL,300.00);

-- views
INSERT INTO `views` VALUES 
(1,1),(2,2),(1,3);

-- wallet
INSERT INTO `wallet` VALUES 
(5,3,27010854.31,'4444444444444444','2027-12-31','123','David Trajchev'),
(6,4,3000.00,'5500000000000004','2028-11-30','456','David-v2 Trajchev'),
(7,2,3000.00,'5500000000000000','2026-11-30','456','Elena Stojanova'),
(8,2,3000.00,'5500000000000001','2026-11-30','456','David Trajchev'),
(9,5,2705.56,'5500000000000001','2026-11-30','456','David Trajchev');
```

---

Оваа скрипта можеш да ја извршиш во MySQL Workbench, phpMyAdmin или преку MySQL командна линија за да ги внесеш сите податоци во твојата база[1].  
Ако ти треба и DDL (структурна) скрипта, слободно прашај!

[1] https://ppl-ai-file-upload.s3.amazonaws.com/web/direct-files/attachments/45354281/264db44a-986b-4227-8c93-895c3208f4fd/paste.txt
[2] https://www.youtube.com/watch?v=7sGFa6Q3LXU
[3] https://docs.tdengine.com/cloud/programming/insert/
[4] https://www.sourcecodester.com/tutorials/php/9221/inserting-data-using-php-mysql-database.html
[5] https://www.lenovo.com/in/en/glossary/data-dump/
[6] https://stackoverflow.com/questions/982568/what-is-the-best-way-to-auto-generate-insert-statements-for-a-sql-server-table
[7] https://forum.dcs.world/topic/290975-dml-mission-creation-toolbox-no-lua-required/page/58/
[8] https://forum.cfx.re/t/release-paid-trucking-simulator-euro-truck-simulator-esx-vrp/3525311?page=2
[9] https://forum.cfx.re/t/release-paid-trucking-simulator-euro-truck-simulator-esx-vrp/3525311?page=3
[10] http://cdn.akamai.steamstatic.com/steam/apps/270880/manuals/ATS_manual_digital.pdf
[11] https://www.gta5-mods.com/scripts/farim-mod