New database SMScrops.com
Download gofile. io/d/rHLD2y
Code:
DROP TABLE IF EXISTS `smssender`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `smssender` (
`id` int NOT NULL AUTO_INCREMENT,
`GroupNumber` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`PhoneNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`PhoneName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`ReportToPhoneNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'Kolom yang digunakan untuk menentukan hiearki jabatan',
`ReportToPhoneName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
`MainNumber` bit(1) DEFAULT NULL,
`NomorWA` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Apikey` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`ManagerCode` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
`AllowedSaveSMSDataPlanting` bit(1) DEFAULT NULL,
`AllowedSaveSMSDataIsolasi` bit(1) DEFAULT NULL,
`AllowedSaveSMSHarvest` bit(1) DEFAULT NULL,
`AllowedSaveSMSFirstDet` bit(1) DEFAULT NULL,
`AllowedSaveSMSMaleCut` bit(1) DEFAULT NULL,
`AllowedSaveSMSDet` bit(1) DEFAULT NULL,
`AllowedSaveSMSRouging` bit(1) DEFAULT NULL,
`AllowedResponseEmail` bit(1) DEFAULT NULL,
`ResponseEmailAdress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`ChangedBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Changeddate` datetime DEFAULT NULL,
`CreatedBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Createdate` datetime DEFAULT NULL,
`ResponseEmailFieldAdmin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`FPMName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`FSName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`ResponseEmail` bit(1) DEFAULT NULL,
`APPROVEDCODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`APPROVALPHONENUMBER` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`APPROVEDDATE` datetime DEFAULT NULL,
`SenderEmailAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`CCEmailReportTo` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`CCEmailReportTo1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`UserPassword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'md5(''WordPass.99'')',
`PasswordLastChange` datetime DEFAULT NULL,
`PasswordExp` datetime DEFAULT NULL,
`IsAdmin` tinyint(1) DEFAULT NULL,
`NotifSend` tinyint(1) DEFAULT '1' COMMENT '1 // menerima notif \r\n0 // tidak menerima notif',
`IsPHO` tinyint(1) DEFAULT '0' COMMENT '1 // PHO // 0 Bukan',
`isConfLanguage` tinyint(1) DEFAULT '0' COMMENT '1 // sudah generate // 0 belum generate\r\n\r\notomatis by system',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `PhoneNumber` (`PhoneNumber`) USING BTREE,
KEY `GroupNumber` (`GroupNumber`) USING BTREE,
KEY `ReportToPhoneNumber` (`ReportToPhoneNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=2570 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;