Da

✏️ Editing: chatwith_mcomsys.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: chatwith_mcomsys
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `chatwith_mcomsys`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `chatwith_mcomsys` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `chatwith_mcomsys`;

--
-- Table structure for table `tbl_user`
--

DROP TABLE IF EXISTS `tbl_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_user` (
  `id` int(10) NOT NULL,
  `userName` varchar(40) NOT NULL,
  `name` varchar(40) NOT NULL,
  `Initial` varchar(15) NOT NULL,
  `accessCode` int(11) NOT NULL,
  `password` varchar(20) NOT NULL,
  `sessionID` int(11) NOT NULL,
  `languageID` int(11) NOT NULL,
  `userGroupID` int(11) NOT NULL,
  `superUser` int(11) NOT NULL,
  `lastLoginDate` varchar(30) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `sponsorPoints` int(11) NOT NULL,
  `deposit` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_user`
--

LOCK TABLES `tbl_user` WRITE;
/*!40000 ALTER TABLE `tbl_user` DISABLE KEYS */;
INSERT INTO `tbl_user` VALUES (11,'cheuping','Cheu Ping','',0,'ping5040',0,0,1,1,'1/2/2018','',0,0),(13,'billy','Billy Ho','',0,'lpchew00',0,0,1,1,'1/18/2018','',0,6),(18,'lpchew','LP Chew','',0,'lpchew1968',0,0,1,1,'8/19/2015','',0,0),(21,'thai','MCOM Thai','',0,'2013mcommsg',0,0,1,0,'2/14/2015','',0,0),(22,'jenny','Jenny','',0,'wangli',0,0,10,1,'5/11/2017','',0,0),(26,'Hafizal','hafizal','',0,'haf051211',0,0,1,1,'1/19/2018','',0,0),(44,'chchin','chchin','',0,'chin9988',0,0,1,1,'1/18/2018','',0,0),(50,'chinasupport','ChinaSupport','',0,'password',0,0,1,1,'1/18/2018','',0,0),(55,'sharon','sharon','',0,'123456',0,0,1,1,'11/1/2017','',0,0),(57,'dede','dede','',0,'dede123',0,0,1,1,'1/15/2018','',0,0),(60,'mardyana','Mardyana','',0,'mardyana031213',0,0,11,1,'1/18/2018','',0,0),(65,'kim','Beh Kim Hiok','',0,'kim1234',0,0,1,1,'12/28/2017','',0,0),(66,'thaisupport','Thailand Support','',0,'thaisupport123',0,0,11,1,'1/18/2018','',0,0),(68,'ksaeung','ksaeung','',0,'ksaeung1234',0,0,1,1,'1/18/2018','',0,0),(69,'csteam','CS Team','',0,'cst123456',0,0,1,1,'4/26/2016','',0,0),(70,'kiat','Kiat','',0,'kiat1234',0,0,1,1,'1/18/2018','',0,0),(73,'Tuty','tuty','',0,'123456',0,0,1,1,'8/28/2014','',0,0),(75,'elena','elena','',0,'elena123456',0,0,10,1,'4/16/2015','',0,0),(86,'phyllis','phyllis','',0,'phyllis123',0,0,1,1,'1/18/2018','',0,0),(87,'yoyo','??','',0,'yoyo2016',0,0,1,1,'4/7/2016','',0,0),(88,'Leeany','??','',0,'Leeany123',0,0,1,1,'','',0,0),(89,'VivianRao','???','',0,'123321',0,0,1,1,'','',0,0),(90,'chenxiaoxia','???','',0,'123321',0,0,1,1,'','',0,0),(91,'nancy','??','',0,'123654',0,0,1,1,'','',0,0),(95,'sirapat','sirapat','',0,'sirapat@2017',0,0,1,1,'1/18/2018','',0,0),(96,'tavinan','tavinan','',0,'tavinan@2017',0,0,1,1,'1/18/2018','',0,0),(97,'paul','paul allan','',0,'1',0,0,1,1,'1/18/2018','',0,0),(98,'weisan','wei san','',0,'we1S@nCH',0,0,1,1,'1/15/2018','',0,0),(99,'winnie','winnie','',0,'winnie@2017',0,0,1,1,'1/18/2018','',0,0),(100,'dara','dara','',0,'123456',0,0,1,1,'1/19/2018','',0,0),(101,'simon','simon','',0,'simon2017',0,0,1,1,'11/24/2017','',0,0),(103,'sinyi','sinyi','',0,'sinyi@2017',0,0,1,1,'1/5/2018','',0,0),(104,'stella','stella','',0,'Jmd@5030',0,0,1,1,'8/10/2017','',0,0),(106,'NBA','Needsbridge','',0,'nba1234',0,0,10,0,'','',0,0),(107,'NBA123','Needsbridge','',0,'nba12345',0,0,10,0,'9/4/2017','',0,0),(108,'Nba2345','Nba','',0,'123456billy',0,0,1,1,'9/6/2017','',0,0),(109,'choonwan','choon wan','',0,'wan2017',0,0,1,1,'1/18/2018','',0,0),(110,'chianwen','chian wen','',0,'xws285',0,0,1,1,'1/15/2018','',0,0),(111,'joeyi','joeyi','',0,'joeyi2018',0,0,1,1,'1/18/2018','',0,0),(112,'Surachai','surachai','',0,'surachai2561',0,0,1,1,'1/19/2018','',0,0);
/*!40000 ALTER TABLE `tbl_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_usergroup`
--

DROP TABLE IF EXISTS `tbl_usergroup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_usergroup` (
  `id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `description` varchar(200) NOT NULL,
  `type` varchar(15) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_usergroup`
--

LOCK TABLES `tbl_usergroup` WRITE;
/*!40000 ALTER TABLE `tbl_usergroup` DISABLE KEYS */;
INSERT INTO `tbl_usergroup` VALUES (1,'ADMIN','ADMINISTRATOR','1'),(10,'ADMIN1','ADMINISTRATOR-1','1'),(11,'System Support','Cannot view income related pages','1'),(12,'Content Editor','Setting CMS, Package, Service, Service Message','1'),(13,'New user','view report for document purpose','1');
/*!40000 ALTER TABLE `tbl_usergroup` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-22 16:48:12

📁 Sid Gifari File Manager