-- Database Backup
-- Filename: backup_01pncamdn-Panca_Net_2025-12-08_14-03-02.sql
-- Generated: 2025-12-08 14:03:02
-- User: Unknown (Tenant: 01pncamdn)


-- Dumping data for table `tbl_company`
DELETE FROM `tbl_company` WHERE `company_code` = '01pncamdn';
INSERT INTO `tbl_company` VALUES ('6', '01pncamdn', 'Panca Net', 'active', '2025-11-11', NULL, 'jl. raya nglongko', '062334110259', 'tes@g.coms', '2025-12-06 03:06:58', '2025-12-08 20:28:24', NULL);


-- Dumping data for table `tbl_metode_pembayaran`
DELETE FROM `tbl_metode_pembayaran` WHERE `company_code` = '01pncamdn';
INSERT INTO `tbl_metode_pembayaran` VALUES ('7', 'Cash', '-', '01pncamdn', '2025-12-06 03:26:58', '2025-12-06 03:26:58', NULL);
INSERT INTO `tbl_metode_pembayaran` VALUES ('8', 'OVO - 546546464', '-', '01pncamdn', '2025-12-06 03:27:11', '2025-12-08 08:56:51', NULL);


-- Dumping data for table `tbl_pasang_baru`
DELETE FROM `tbl_pasang_baru` WHERE `company_code` = '01pncamdn';
INSERT INTO `tbl_pasang_baru` VALUES ('2', 'tes pelanggan panca', 'ksjfajdsf', '09823498', '2', NULL, NULL, '2025-12-19', '2025-12-10', '2025-12-10', '-7.5498146796793355, 111.62521362304689', NULL, NULL, 'inactive', NULL, 'sudah', '01pncamdn', '2025-12-07 14:57:07', '2025-12-07 14:57:19', NULL);


-- Dumping data for table `tbl_pelanggan`
DELETE FROM `tbl_pelanggan` WHERE `company_code` = '01pncamdn';
INSERT INTO `tbl_pelanggan` VALUES ('9', 'tes pelanggan panca', 'ksjfajdsf', '09823498', '2', NULL, NULL, '2025-12-19', '2025-12-10', '2025-12-10', '-7.5498146796793355, 111.62521362304689', NULL, NULL, 'inactive', NULL, '01pncamdn', '2025-12-07 14:58:05', '2025-12-07 14:58:05', NULL);


-- Dumping data for table `tbl_pelaporan_gangguan`
DELETE FROM `tbl_pelaporan_gangguan` WHERE `company_code` = '01pncamdn';


-- Dumping data for table `tbl_pengguna`
DELETE FROM `tbl_pengguna` WHERE `company_code` = '01pncamdn';
INSERT INTO `tbl_pengguna` VALUES ('6', '01pncamdn', 'owner panca', 'ownerpanca', '$2y$12$mQbKCgAUn75m81.Ci7NKqOZgGvmnfnjxx.LOCK6A6P8RHPHImVuCy', 'admin@gmail.coms', '8', '062334110259', '-', NULL, '2025-12-06 03:13:14', '2025-12-06 03:13:14', NULL);
INSERT INTO `tbl_pengguna` VALUES ('8', '01pncamdn', 'Siti Mualimah', 'siti', '$2y$12$Vo2b013FdxlTq.ky704X/ufNmuIxMFlDC0ChPwy8k53s7lLR/4Bya', 'sdf@gmailc.om', '9', '0813334982163', '-', 'hQzBUiceFiVfrdPIDFbXOOpV6sWbt6wnD7rPy2lqkwEgZ7MuoZTp0ox9Ppm6', '2025-12-06 03:25:45', '2025-12-06 03:25:45', NULL);


-- Dumping data for table `tbl_product`
DELETE FROM `tbl_product` WHERE `company_code` = '01pncamdn';
INSERT INTO `tbl_product` VALUES ('2', 'Paket 1', '120000.00', '01pncamdn', '2025-12-06 07:11:45', '2025-12-06 07:11:51', NULL);


-- Dumping data for table `tbl_role`
DELETE FROM `tbl_role` WHERE `company_code` = '01pncamdn';
INSERT INTO `tbl_role` VALUES ('8', '01pncamdn', 'owner panca', '-', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '2025-12-06 03:09:34', '2025-12-06 03:12:19', NULL);
INSERT INTO `tbl_role` VALUES ('9', '01pncamdn', 'admin', '-', '0', '1', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '2025-12-06 03:10:09', '2025-12-08 13:25:06', NULL);


