-- Database Backup
-- Filename: backup_01agldpmdn-Agung_LDP_Madiun_2025-12-08_14-03-18.sql
-- Generated: 2025-12-08 14:03:18
-- User: Unknown (Tenant: 01agldpmdn)


-- Dumping data for table `tbl_company`
DELETE FROM `tbl_company` WHERE `company_code` = '01agldpmdn';
INSERT INTO `tbl_company` VALUES ('5', '01agldpmdn', 'Agung LDP Madiun', 'active', '2025-11-11', NULL, 'jl. raya nglongko', '062334110259', 'bam@g.com', '2025-12-06 03:06:02', '2025-12-06 03:06:02', NULL);


-- Dumping data for table `tbl_metode_pembayaran`
DELETE FROM `tbl_metode_pembayaran` WHERE `company_code` = '01agldpmdn';
INSERT INTO `tbl_metode_pembayaran` VALUES ('4', 'Dana - 082334110259', '-', '01agldpmdn', '2025-12-06 03:16:19', '2025-12-06 03:22:03', NULL);
INSERT INTO `tbl_metode_pembayaran` VALUES ('5', 'Cash', '-', '01agldpmdn', '2025-12-06 03:22:12', '2025-12-06 03:22:12', NULL);
INSERT INTO `tbl_metode_pembayaran` VALUES ('6', 'Bri - 214643123', '-', '01agldpmdn', '2025-12-06 03:22:26', '2025-12-06 03:22:26', NULL);


-- Dumping data for table `tbl_pasang_baru`
DELETE FROM `tbl_pasang_baru` WHERE `company_code` = '01agldpmdn';
INSERT INTO `tbl_pasang_baru` VALUES ('1', 'YOPINO WIDAYANTO', 'eereaw', '08213123', '1', '21211', '12313', '2025-11-12', NULL, NULL, '-7.631559212838677, 111.5215301513672', 'pasangbaru_fotos/S8o7dqFuMPWMm76gZQzO2dTeWsCW9yOJXRY1lQGf.jpg', 'pasangbaru_fotos/RcKdV4ixNHby5zJ0bT3T3nN6Fq7bWNR5orF4qLws.jpg', 'active', '-', 'sudah', '01agldpmdn', '2025-12-06 20:23:32', '2025-12-07 15:06:20', NULL);


-- Dumping data for table `tbl_pelanggan`
DELETE FROM `tbl_pelanggan` WHERE `company_code` = '01agldpmdn';
INSERT INTO `tbl_pelanggan` VALUES ('6', 'YOPINO WIDAYANTO', 'eereaw', '08213123', '1', '21211', '12313', '2025-11-12', NULL, '2025-11-12', '-7.631559212838677, 111.5215301513672', 'pasangbaru_fotos/O7DwOavpHjnmbak0RDoOxS7PTMiX2SRQ0Be5Nl3A.jpg', 'pasangbaru_fotos/qxi0ekcYMAnD5h5m2Q0UrXMZNnXQNVcAYy9s9Z6g.jpg', 'active', '-', '01agldpmdn', '2025-12-06 21:10:22', '2025-12-06 21:10:22', NULL);
INSERT INTO `tbl_pelanggan` VALUES ('8', 'YOPINO WIDAYANTO', 'eereaw', '08213123', '1', '21211', '12313', '2025-11-12', NULL, '2025-11-12', '-7.7255167, 111.4889748', 'pasangbaru_fotos/S8o7dqFuMPWMm76gZQzO2dTeWsCW9yOJXRY1lQGf.jpg', 'pasangbaru_fotos/RcKdV4ixNHby5zJ0bT3T3nN6Fq7bWNR5orF4qLws.jpg', 'active', '-', '01agldpmdn', '2025-12-07 14:14:24', '2025-12-08 13:48:52', '2025-12-08 13:48:52');
INSERT INTO `tbl_pelanggan` VALUES ('10', 'YOPINO WIDAYANTO', 'eereaw', '08213123', '1', '21211', '12313', '2025-11-12', NULL, '2025-11-12', '-7.631559212838677, 111.5215301513672', 'pasangbaru_fotos/S8o7dqFuMPWMm76gZQzO2dTeWsCW9yOJXRY1lQGf.jpg', 'pasangbaru_fotos/RcKdV4ixNHby5zJ0bT3T3nN6Fq7bWNR5orF4qLws.jpg', 'active', '-', '01agldpmdn', '2025-12-07 15:06:20', '2025-12-08 13:32:23', '2025-12-08 13:32:23');


-- Dumping data for table `tbl_pelaporan_gangguan`
DELETE FROM `tbl_pelaporan_gangguan` WHERE `company_code` = '01agldpmdn';
INSERT INTO `tbl_pelaporan_gangguan` VALUES ('7', '00001-071225-01agldpmdn', '01agldpmdn', 'YOPINO WIDAYANTO', 'eereaw', '08213123', 'a', '2025-12-07 17:16:00', 'doni don', '2025-12-07 17:16:00', 'doni don', '2025-12-07 19:24:00', 'pelaporan_gangguan_fotos/X0dNFAaO8HUBjerpDDRWqG1rsqjJred2ysI5FCVq.jpg', 'pelaporan_gangguan_fotos/uhpA1cv2Mi6CPznNFAbfim0ic9qafKZAlWtnEeLP.jpg', NULL, '1', '2025-12-07 08:16:14', '2025-12-08 13:36:10', NULL);
INSERT INTO `tbl_pelaporan_gangguan` VALUES ('8', '00002-071225-01agldpmdn', '01agldpmdn', 'YOPINO WIDAYANTO', 'eereaw', '08213123', 'te', '2025-12-05 21:02:00', 'doni don', '2025-12-17 21:02:00', 'doni don', NULL, 'pelaporan_gangguan_fotos/Hfd2usVumzhRbhU0J3PRn0n3J6onFyb6fzn9Jecp.jpg', 'pelaporan_gangguan_fotos/gqpKrcCGpuLCVQ8nlam5N63zN9Jqmp5ArHSqqejc.jpg', NULL, '0', '2025-12-07 14:02:56', '2025-12-07 14:09:57', NULL);


-- Dumping data for table `tbl_pengguna`
DELETE FROM `tbl_pengguna` WHERE `company_code` = '01agldpmdn';
INSERT INTO `tbl_pengguna` VALUES ('5', '01agldpmdn', 'Owner Agung', 'owneragung', '$2y$12$9aruzP9DESXwDyxq7sVuL.4IODrCkMDIZjw/EL5n2f0nOZsb2mIYC', 'admin@gmail.com', '6', '062334110259', '-', NULL, '2025-12-06 03:11:31', '2025-12-06 03:11:31', NULL);
INSERT INTO `tbl_pengguna` VALUES ('7', '01agldpmdn', 'doni don', 'doni', '$2y$12$LXWXNgva.nM/xk.hS0TkW.Nwjj6InNu6ThqUuk4lIW2VbFHA6P83G', 'doni@gmail.com', '7', '0813334982163', 'e', 'Z4XSaFF5Kw5byCRQE1F4SyrvV9mjuIeB20K1jvVPV8LQivD6O6RU2SDaAIur', '2025-12-06 03:14:54', '2025-12-08 09:32:26', NULL);


-- Dumping data for table `tbl_product`
DELETE FROM `tbl_product` WHERE `company_code` = '01agldpmdn';
INSERT INTO `tbl_product` VALUES ('1', 'Paket 1', '100000.00', '01agldpmdn', '2025-12-06 07:10:09', '2025-12-06 07:10:09', NULL);
INSERT INTO `tbl_product` VALUES ('4', 'peket2', '150000.00', '01agldpmdn', '2025-12-06 14:04:36', '2025-12-06 14:04:36', NULL);


-- Dumping data for table `tbl_role`
DELETE FROM `tbl_role` WHERE `company_code` = '01agldpmdn';
INSERT INTO `tbl_role` VALUES ('6', '01agldpmdn', 'owner_agung', '-', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '2025-12-06 03:08:20', '2025-12-06 03:08:20', NULL);
INSERT INTO `tbl_role` VALUES ('7', '01agldpmdn', 'admin', '-', '0', '1', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '2025-12-06 03:09:02', '2025-12-06 03:10:21', NULL);


