/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: weblinkltd_ispsoft
-- ------------------------------------------------------
-- Server version	10.11.16-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 */;

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `email` varchar(250) NOT NULL,
  `password` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES
(1,'admin@site.com','e10adc3949ba59abbe56e057f20f883e');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `area`
--

DROP TABLE IF EXISTS `area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `area` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `area`
--

LOCK TABLES `area` WRITE;
/*!40000 ALTER TABLE `area` DISABLE KEYS */;
INSERT INTO `area` VALUES
(5,'Mayfair'),
(6,'St. James\'s'),
(7,'Westminster'),
(8,'London'),
(9,'DC'),
(10,'Silicon Valley'),
(11,'Chicago'),
(12,'Mayfair'),
(13,'St. James\'s'),
(14,'Westminster'),
(15,'New York'),
(16,'DC'),
(17,'Silicon Valley'),
(18,'Chicago');
/*!40000 ALTER TABLE `area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `balance`
--

DROP TABLE IF EXISTS `balance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `balance` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `balance`
--

LOCK TABLES `balance` WRITE;
/*!40000 ALTER TABLE `balance` DISABLE KEYS */;
INSERT INTO `balance` VALUES
(4,'Purchase Cable ','3','Expense','2018-03-24'),
(5,'Collect Bills 2','20','Income','2018-03-24'),
(6,'Manual Payment Cash Hand To Hand','5','Income','2018-03-25'),
(7,'Manual Payment Cash Don','5','Income','2018-03-25'),
(8,'Stripe Payment4242','3.45','Income','2018-03-25'),
(9,'Stripe Payment (4242)','3.45','Income','2018-03-25'),
(10,'Manual Payment (Cash) (Office)','10','Income','2018-03-25'),
(11,'Manual Payment (Cash) (Office)','5','Income','2018-03-25'),
(12,'Manual Payment (Cash) (Office)','10','Income','2018-03-25'),
(13,'Manual Payment (Cash) (Office)','10','Income','2018-03-25'),
(14,'Manual Payment (Cash) (Office)','10','Income','2018-03-25'),
(15,'Stripe Payment (4242)','3.45','Income','2018-03-25'),
(16,'Stripe Payment (4242)','3.45','Income','2018-03-27'),
(17,'Stripe Payment (4242)','3.45','Income','2018-03-27'),
(18,'Stripe Payment (4242)','13.8','Income','2018-03-29');
/*!40000 ALTER TABLE `balance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bills`
--

DROP TABLE IF EXISTS `bills`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `bills` (
  `billid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(100) NOT NULL,
  `billstatus` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `month` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `year` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `package` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `matchid` varchar(255) NOT NULL,
  PRIMARY KEY (`billid`)
) ENGINE=MyISAM AUTO_INCREMENT=226 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bills`
--

LOCK TABLES `bills` WRITE;
/*!40000 ALTER TABLE `bills` DISABLE KEYS */;
INSERT INTO `bills` VALUES
(218,348,'Paid','August','2018','12',''),
(217,355,'Paid','August','2018','12',''),
(224,343,'Paid','August','2018','12',''),
(220,344,'Paid','August','2018','12',''),
(225,365,'Unpaid','September','2022','13','07-09-2022-03-365-1');
/*!40000 ALTER TABLE `bills` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email`
--

DROP TABLE IF EXISTS `email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `email` (
  `emailID` int(11) NOT NULL AUTO_INCREMENT,
  `time` varchar(50) NOT NULL,
  `emailTo` varchar(50) NOT NULL,
  `emailSubject` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `network` varchar(50) NOT NULL,
  PRIMARY KEY (`emailID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email`
--

LOCK TABLES `email` WRITE;
/*!40000 ALTER TABLE `email` DISABLE KEYS */;
/*!40000 ALTER TABLE `email` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice`
--

DROP TABLE IF EXISTS `invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice` (
  `invoiceID` int(255) NOT NULL AUTO_INCREMENT,
  `userid` varchar(255) NOT NULL,
  `createdate` varchar(255) NOT NULL,
  `duedate` varchar(255) NOT NULL,
  `paymentmethod` varchar(255) NOT NULL,
  `paymentacc` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `paidamount` float DEFAULT NULL,
  `paidmethod` varchar(255) DEFAULT NULL,
  `paidacc` varchar(255) DEFAULT NULL,
  `package` varchar(255) NOT NULL,
  `price` float NOT NULL,
  `discount` float NOT NULL,
  `matchid` varchar(255) DEFAULT NULL,
  `cost1` varchar(255) DEFAULT NULL,
  `cost2` mediumtext DEFAULT NULL,
  `cost3` varchar(255) DEFAULT NULL,
  `cost4` varchar(255) DEFAULT NULL,
  `cost5` varchar(255) DEFAULT NULL,
  `value1` float DEFAULT NULL,
  `value2` float DEFAULT NULL,
  `value3` float DEFAULT NULL,
  `value4` float DEFAULT NULL,
  `value5` float DEFAULT NULL,
  PRIMARY KEY (`invoiceID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice`
--

LOCK TABLES `invoice` WRITE;
/*!40000 ALTER TABLE `invoice` DISABLE KEYS */;
INSERT INTO `invoice` VALUES
(1,'365','2022-09-06','2022-09-30','',NULL,'Unpaid',NULL,NULL,NULL,'',0,0,'07-09-2022-03-365-1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `package`
--

DROP TABLE IF EXISTS `package`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `package` (
  `packid` int(100) NOT NULL AUTO_INCREMENT,
  `packname` varchar(255) NOT NULL,
  `packvolume` varchar(255) NOT NULL,
  `packprice` float NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `cost1` varchar(255) DEFAULT NULL,
  `cost2` varchar(255) DEFAULT NULL,
  `cost3` varchar(255) DEFAULT NULL,
  `cost4` varchar(255) DEFAULT NULL,
  `cost5` varchar(255) DEFAULT NULL,
  `value1` float DEFAULT NULL,
  `value2` float DEFAULT NULL,
  `value3` float DEFAULT NULL,
  `value4` float DEFAULT NULL,
  `value5` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  PRIMARY KEY (`packid`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `package`
--

LOCK TABLES `package` WRITE;
/*!40000 ALTER TABLE `package` DISABLE KEYS */;
INSERT INTO `package` VALUES
(12,'Basic','5 MB',500,'P-01','','','','','',0,0,0,0,0,0),
(13,'Standard','8 MB',700,'P-02','','','','','',0,0,0,0,0,0),
(14,'Professional','10 MB',800,'P-03','','','','','',0,0,0,0,0,0),
(15,'Premium','15 MB',1000,'P-04','','','','','',0,0,0,0,0,0),
(16,'Business','20 MB',1200,'P-05','','','','','',0,0,0,0,0,0),
(17,'IT Farm','25 MB',1500,'P-06','','','','','',0,0,0,0,0,0),
(18,'Startup','40 MB',2000,'P-07','','','','','',0,0,0,0,0,0),
(19,'Ultra Fast','50 MB',2500,'P-07','','','','','',0,0,0,0,0,0);
/*!40000 ALTER TABLE `package` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payments` (
  `paymentid` int(100) NOT NULL AUTO_INCREMENT,
  `invoiceid` int(100) NOT NULL,
  `transactionid` varchar(255) NOT NULL,
  `amount` float NOT NULL,
  `currency` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL,
  `payerid` varchar(255) NOT NULL,
  `payeremail` varchar(255) NOT NULL,
  `payerfname` varchar(255) NOT NULL,
  `payerlname` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `saleid` varchar(255) NOT NULL,
  `saletime` varchar(255) NOT NULL,
  PRIMARY KEY (`paymentid`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payments`
--

LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
INSERT INTO `payments` VALUES
(20,48,'txn_1C7OXUA4JNh6ZWXnFFn0YeJy',3.45,'usd','Stripe_4242','card_1C7OXRA4JNh6ZWXnkZtY2riK_4242','ch_1C7OXTA4JNh6ZWXnY1WFRF0x','ch_1C7OXTA4JNh6ZWXnY1WFRF0x','ch_1C7OXTA4JNh6ZWXnY1WFRF0x','Paid','ch_1C7OXTA4JNh6ZWXnY1WFRF0x','1970-01-01'),
(23,52,'N/A',3.45,'USD','Cash','','Hand To Hand','','','Paid','',''),
(26,52,'txn_1C93UoA4JNh6ZWXnoBy5D9PZ',3.45,'USD','Stripe_4242','card_1C93UlA4JNh6ZWXn1XZRBn5M_4242','ch_1C93UoA4JNh6ZWXnUqiWVDE9','ch_1C93UoA4JNh6ZWXnUqiWVDE9','ch_1C93UoA4JNh6ZWXnUqiWVDE9','Paid','ch_1C93UoA4JNh6ZWXnUqiWVDE9','1521863806'),
(27,53,'txn_1C93c6A4JNh6ZWXnJiZyrW3B',3.45,'USD','Stripe_4242','card_1C93c4A4JNh6ZWXncDFdDc0s_4242','ch_1C93c6A4JNh6ZWXn1ZtIqp7u','ch_1C93c6A4JNh6ZWXn1ZtIqp7u','ch_1C93c6A4JNh6ZWXn1ZtIqp7u','Paid','ch_1C93c6A4JNh6ZWXn1ZtIqp7u','2018-03-24'),
(28,54,'N/A',2.5,'USD','Cash','','Hand To Hand','','','Paid','','2018-03-24'),
(29,58,'N/A',5,'USD','Cash','','Hand To Hand','','','Paid','','2018-03-25'),
(30,65,'N/A',5,'USD','Cash','','Don','','','Paid','','2018-03-25'),
(31,64,'txn_1C9SuXA4JNh6ZWXnSAJs0VhE',3.45,'USD','Stripe_4242','card_1C9SuVA4JNh6ZWXnWHeYZC8P_4242','ch_1C9SuXA4JNh6ZWXna3PbnHcY','ch_1C9SuXA4JNh6ZWXna3PbnHcY','ch_1C9SuXA4JNh6ZWXna3PbnHcY','Paid','ch_1C9SuXA4JNh6ZWXna3PbnHcY','2018-03-25'),
(32,63,'txn_1C9SxBA4JNh6ZWXnHjZrNKJC',3.45,'USD','Stripe_4242','card_1C9Sx9A4JNh6ZWXn7Li9GvLG_4242','ch_1C9SxBA4JNh6ZWXnTTKoL6D2','ch_1C9SxBA4JNh6ZWXnTTKoL6D2','ch_1C9SxBA4JNh6ZWXnTTKoL6D2','Paid','ch_1C9SxBA4JNh6ZWXnTTKoL6D2','2018-03-25'),
(33,61,'N/A',10,'USD','Cash','','Office','','','Paid','','2018-03-25'),
(34,62,'N/A',5,'USD','Cash','','Office','','','Paid','','2018-03-25'),
(35,60,'N/A',10,'USD','Cash','','Office','','','Paid','','2018-03-25'),
(36,93,'N/A',10,'USD','Cash','','Office','','','Paid','','2018-03-25'),
(37,111,'N/A',10,'USD','Cash','','Office','','','Paid','','2018-03-25'),
(38,107,'txn_1C9aQZA4JNh6ZWXnRF0imqbW',3.45,'USD','Stripe_4242','card_1C9aQWA4JNh6ZWXnJbftwcKF_4242','ch_1C9aQZA4JNh6ZWXn9O3w35S2','ch_1C9aQZA4JNh6ZWXn9O3w35S2','ch_1C9aQZA4JNh6ZWXn9O3w35S2','Paid','ch_1C9aQZA4JNh6ZWXn9O3w35S2','2018-03-25'),
(39,126,'txn_1CABzXA4JNh6ZWXnRzhQmInc',3.45,'USD','Stripe_4242','card_1CABzUA4JNh6ZWXnd2ocQyEy_4242','ch_1CABzWA4JNh6ZWXnNGqgbjZh','ch_1CABzWA4JNh6ZWXnNGqgbjZh','ch_1CABzWA4JNh6ZWXnNGqgbjZh','Paid','ch_1CABzWA4JNh6ZWXnNGqgbjZh','2018-03-27'),
(40,125,'txn_1CAIYOA4JNh6ZWXnH5zPfWq8',3.45,'USD','Stripe_4242','card_1CAIYKA4JNh6ZWXnL3J1uhRe_4242','ch_1CAIYOA4JNh6ZWXntRz3UR56','ch_1CAIYOA4JNh6ZWXntRz3UR56','ch_1CAIYOA4JNh6ZWXntRz3UR56','Paid','ch_1CAIYOA4JNh6ZWXntRz3UR56','2018-03-27'),
(41,127,'txn_1CB0GAA4JNh6ZWXn5XWeMTT1',13.8,'USD','Stripe_4242','card_1CB0G5A4JNh6ZWXnK5BdUPBx_4242','ch_1CB0GAA4JNh6ZWXn6rwTb1h2','ch_1CB0GAA4JNh6ZWXn6rwTb1h2','ch_1CB0GAA4JNh6ZWXn6rwTb1h2','Paid','ch_1CB0GAA4JNh6ZWXn6rwTb1h2','2018-03-29');
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `logo` varchar(255) NOT NULL,
  `favicon` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slogan` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `paymentmethod` varchar(255) NOT NULL,
  `paymentacc` varchar(255) NOT NULL,
  `vat` float NOT NULL,
  `smsapi` varchar(50) NOT NULL,
  `emailapi` varchar(50) NOT NULL,
  `smsonbills` int(11) NOT NULL,
  `emailonbills` int(11) NOT NULL,
  `mkipadd` varchar(50) DEFAULT NULL,
  `mkuser` varchar(50) DEFAULT NULL,
  `mkpassword` varchar(50) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `copyright` varchar(255) NOT NULL,
  `kenadekha` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES
(1,'20220905_102129_264428.png','20220905_102129_264428.png','WCL','ISP Management System','00000000000','support@weblinkltd.com','BDT','Paypal','support@weblinkltd.com',15,'Nexmo','Mailgun',1,1,'58.84.34.53','test','123','1634 Sussex Court','TX','USA','76566','','Copyright @ 2022','15bbe179-2445-477d-bdb7-b15c570616f5');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sms`
--

DROP TABLE IF EXISTS `sms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms` (
  `smsid` int(11) NOT NULL AUTO_INCREMENT,
  `time` varchar(50) NOT NULL,
  `to` varchar(50) NOT NULL,
  `message` varchar(255) NOT NULL,
  `messageid` varchar(100) NOT NULL,
  `remainingbalance` varchar(100) NOT NULL,
  `messageprice` varchar(100) NOT NULL,
  `network` varchar(100) NOT NULL,
  PRIMARY KEY (`smsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms`
--

LOCK TABLES `sms` WRITE;
/*!40000 ALTER TABLE `sms` DISABLE KEYS */;
/*!40000 ALTER TABLE `sms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `staff` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `photo` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `area` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff`
--

LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES
(5,'20180322_042702_967493.jpeg','John Smith','714-579-8533','Mayfair'),
(6,'20180322_042702_967493.jpeg','John Doe','714-579-8533','');
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticket`
--

DROP TABLE IF EXISTS `ticket`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticket` (
  `ticketID` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `ticketdate` varchar(50) NOT NULL,
  `status` varchar(100) NOT NULL,
  `adminID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ticketID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket`
--

LOCK TABLES `ticket` WRITE;
/*!40000 ALTER TABLE `ticket` DISABLE KEYS */;
INSERT INTO `ticket` VALUES
(1,340,'Net Connection is very slow 2','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.','2018-08-13 10:07:57','Closed',0),
(2,340,'Net Connection is very slow','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.','2018-08-15 11:02:15','Closed',NULL),
(3,367,'test','this is a test','2022-11-02 03:22:50','Pending',NULL);
/*!40000 ALTER TABLE `ticket` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticketcomment`
--

DROP TABLE IF EXISTS `ticketcomment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ticketcomment` (
  `commentID` int(11) NOT NULL AUTO_INCREMENT,
  `ticketID` int(11) NOT NULL,
  `comment` text NOT NULL,
  `commentdate` varchar(100) NOT NULL,
  `usertype` varchar(50) NOT NULL,
  PRIMARY KEY (`commentID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticketcomment`
--

LOCK TABLES `ticketcomment` WRITE;
/*!40000 ALTER TABLE `ticketcomment` DISABLE KEYS */;
INSERT INTO `ticketcomment` VALUES
(1,1,'Hi, we are checking the issue. \r\nThanks for being with us. ','2018-08-15 10:16:25',''),
(2,1,'Hi, we are checking the issue. \r\nThanks for being with us. ','2018-08-15 10:17:26',''),
(3,1,'dfsdfsdfsd','2018-08-15 10:32:46','1'),
(4,1,'dsfsdfsdf','2018-08-15 10:50:53','2');
/*!40000 ALTER TABLE `ticketcomment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `photo` varchar(255) NOT NULL,
  `name` varchar(250) NOT NULL,
  `mobile` varchar(250) NOT NULL,
  `package` varchar(250) NOT NULL,
  `area` varchar(255) NOT NULL,
  `staff` varchar(255) NOT NULL,
  `amount` varchar(250) NOT NULL,
  `user_id` varchar(250) NOT NULL,
  `password` varchar(250) NOT NULL,
  `join_date` varchar(250) NOT NULL,
  `advance` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `location` varchar(250) NOT NULL,
  `role` varchar(255) NOT NULL,
  `status` varchar(250) NOT NULL,
  `pppoe_name` varchar(50) DEFAULT NULL,
  `pppoe_password` varchar(50) DEFAULT NULL,
  `pppoe_service` varchar(50) DEFAULT NULL,
  `pppoe_profile` varchar(50) DEFAULT NULL,
  `hotspot_server` varchar(100) DEFAULT NULL,
  `hotspot_name` varchar(50) DEFAULT NULL,
  `hotspot_pass` varchar(50) DEFAULT NULL,
  `hotspot_profile` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=369 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(361,'20181107_055631_867452.png','Paul Shen','000','12','Mayfair','5',' ','shen','123456','2018-11-07',' ','shen@gmail.com','e10adc3949ba59abbe56e057f20f883e','London','User','Pending',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(360,'','Simon Doe','1726562944','13','St. James\'s','5',' ','admin','123456','2018-11-07',' ','user@site.com','e10adc3949ba59abbe56e057f20f883e','Dhaka','User','Pending','simon','123456','pppoe','default',NULL,NULL,NULL,NULL),
(359,'20181106_080942_811237.jpeg','John Doe','1726562944','12','Mayfair','6',' ','admin','123456','2018-11-07',' ','admin@site.com','e10adc3949ba59abbe56e057f20f883e','Dhaka','Admin','Pending',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(364,'20220905_101845_329352.png','Kafi','0130043333','12','DC','5',' ','198.168.44.16','123456','2022-09-05',' ','admin@site2.com','e10adc3949ba59abbe56e057f20f883e','Dhaka','User','Pending',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(365,'','Azad','01992029423','13','Chicago','5',' ','test','123','2022-09-06',' ','azadwcl@gmail.com','4739c5c11d833bb199c16ff95a92b267','Dhaka','User','Active',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(366,'','test','01992029423','12','Mayfair','6',' ','test','123','2022-09-08',' ','azadete04@gmail.com','678bb33fb7a52e0f19fa4921a867a0b4','Dhaka','User','Pending',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(367,'','simon','0098914321765','8 MB','','','','ID20221102','PASS20221102','2022-11-02','','simoncrans@gmail.com','31f43af563e2dbc3370d34225f1f766c','135764','User','Pending',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(368,'','Admin','01300432335','13','Dhaka','6','','Demo_admin','e10adc3949ba59abbe56e057f20f883e','2022-09-05','','demoadmin@gmail.com','e10adc3949ba59abbe56e057f20f883e','Dhaka','Admin','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `users` 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 2026-05-05 15:29:14
