-- MySQL dump 10.19  Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: cdc
-- ------------------------------------------------------
-- Server version	10.3.38-MariaDB-0ubuntu0.20.04.1

/*!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 `accounts`
--

DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `balance` double(18,2) NOT NULL DEFAULT 0.00,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `accounts`
--

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

--
-- Table structure for table `appointment`
--

DROP TABLE IF EXISTS `appointment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `appointment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appointment_id` varchar(20) NOT NULL,
  `doctor_id` varchar(20) NOT NULL,
  `patient_id` varchar(20) NOT NULL,
  `consultation_fees` varchar(20) NOT NULL,
  `discount` decimal(18,2) NOT NULL,
  `schedule` varchar(50) NOT NULL,
  `remarks` text NOT NULL,
  `appointment_date` date NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `appointment`
--

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

--
-- Table structure for table `chemical`
--

DROP TABLE IF EXISTS `chemical`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chemical` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `code` varchar(50) NOT NULL,
  `category_id` int(11) NOT NULL,
  `purchase_unit_id` int(11) NOT NULL,
  `sales_unit_id` int(11) NOT NULL,
  `unit_ratio` varchar(20) DEFAULT '1',
  `purchase_price` decimal(18,2) NOT NULL DEFAULT 0.00,
  `sales_price` decimal(18,2) NOT NULL DEFAULT 0.00,
  `available_stock` varchar(11) NOT NULL DEFAULT '0',
  `photo` varchar(100) DEFAULT NULL,
  `remarks` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chemical`
--

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

--
-- Table structure for table `chemical_assigned`
--

DROP TABLE IF EXISTS `chemical_assigned`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chemical_assigned` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `test_id` int(11) NOT NULL,
  `chemical_id` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chemical_assigned`
--

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

--
-- Table structure for table `chemical_category`
--

DROP TABLE IF EXISTS `chemical_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chemical_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chemical_category`
--

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

--
-- Table structure for table `chemical_stock`
--

DROP TABLE IF EXISTS `chemical_stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chemical_stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inovice_no` varchar(25) NOT NULL,
  `chemical_id` varchar(20) NOT NULL,
  `date` date DEFAULT NULL,
  `stock_quantity` varchar(20) NOT NULL,
  `remarks` varchar(255) NOT NULL,
  `stock_by` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chemical_stock`
--

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

--
-- Table structure for table `chemical_unit`
--

DROP TABLE IF EXISTS `chemical_unit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chemical_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chemical_unit`
--

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

--
-- Table structure for table `ci_sessions`
--

DROP TABLE IF EXISTS `ci_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ci_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  `data` blob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ci_sessions`
--

LOCK TABLES `ci_sessions` WRITE;
/*!40000 ALTER TABLE `ci_sessions` DISABLE KEYS */;
INSERT INTO `ci_sessions` VALUES ('17daokp9biq0kc6uemua6bvn98kn3iqt','103.197.204.175',1688283168,'__ci_last_regenerate|i:1688283040;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('2iab4igm4qhgtacugdkcm608u0ohabjp','37.111.226.24',1687889512,'__ci_last_regenerate|i:1687889512;'),('32avrs2ealsl6fpp50sh0b1pe3f5q5qi','103.180.244.161',1688643287,'__ci_last_regenerate|i:1688643287;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('3trl8t4r1rbhdhv5n8f9km16b6vijl7b','103.197.204.175',1688281027,'__ci_last_regenerate|i:1688281027;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('460uteg6n5sh0no7ddkd12nb5hlm5dhk','103.197.204.175',1688298244,'__ci_last_regenerate|i:1688298231;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('5q2hndvak814s0356u8ebjuohrkn93vf','103.197.204.175',1688296295,'__ci_last_regenerate|i:1688296295;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('707i726ph65fp4fp80iifb5b5hnsu14j','103.197.204.175',1688279866,'__ci_last_regenerate|i:1688279609;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('96e833tct23fcnlo9a08r2qb28j43hs9','103.181.42.122',1687888461,'__ci_last_regenerate|i:1687888461;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('9ek8122iobvpq9figm854ujvv5tarmlp','103.180.244.161',1688648521,'__ci_last_regenerate|i:1688648521;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('9v2j8kp7fkk9v8lk0829atmtk43jpqpq','103.180.244.161',1688648521,'__ci_last_regenerate|i:1688648521;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('ai59o7gmpgp7451j7s7221o5huiq3rb2','103.180.244.161',1688623169,'__ci_last_regenerate|i:1688622930;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('atqrgopnlgdv1da0qurvnaotgtbqu1ck','103.181.42.122',1687888461,'__ci_last_regenerate|i:1687888461;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('b0mpaf6pj7ag4mobb8bujddfqpapc0q6','103.181.42.122',1687889310,'__ci_last_regenerate|i:1687889071;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('bl7df3g19opoh68noc3a9te6no8u0gtt','103.197.204.175',1688283040,'__ci_last_regenerate|i:1688283040;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('c0nv3e7hkmvu2b16e5ia2salsiqmp76g','103.180.244.161',1688635271,'__ci_last_regenerate|i:1688635271;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('dfc70ouu65vdkaqp08ivs4o8atbuehgq','103.197.204.175',1688298231,'__ci_last_regenerate|i:1688298231;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('e4q36j5pnqim16dfpg9pot2b5i9fsvgo','37.111.226.24',1687889817,'__ci_last_regenerate|i:1687889817;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('fgie0he90pqin9j2h8vo7d9me8d6mgh4','103.197.204.175',1687936505,'__ci_last_regenerate|i:1687936505;'),('j89m0bjns9re8v19g8q2r5ncs5hakcqa','103.180.244.161',1688466054,'__ci_last_regenerate|i:1688466026;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('jluuigegutaglaveloehm6l2einbc1ko','103.180.244.161',1688638237,'__ci_last_regenerate|i:1688638237;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('k09lo8sabcjm4jkgsb3ut5sal469tutt','37.111.221.77',1687889380,'__ci_last_regenerate|i:1687889368;'),('m5nkbvoc5fkvllbubpr80e9d4berph7e','37.111.221.77',1687889368,'__ci_last_regenerate|i:1687889368;'),('nmndek3j6momhpst4gqh96q8qgfq6ia4','103.197.204.175',1688284055,'__ci_last_regenerate|i:1688284055;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('nt3pj8037a8rmajri49lsrl41paui2e8','103.197.204.175',1688282482,'__ci_last_regenerate|i:1688282482;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('or9duk3mo4p4kjuoofhttra2cr9ak8sv','103.197.204.175',1688280510,'__ci_last_regenerate|i:1688280510;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('psece5g70e7jafdq0thfgugud0eed0r5','103.180.244.161',1688646979,'__ci_last_regenerate|i:1688646979;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('q2vupa3n594h4plpjre3fp9b3pjhi3jt','103.180.244.161',1688634777,'__ci_last_regenerate|i:1688634777;'),('topmhi225frhtsqvct59fhc7ntom7hm9','191.101.237.76',1687888996,'__ci_last_regenerate|i:1687888996;'),('toui0k1somtnmeh5kkg3uhituf89b98s','103.197.204.175',1688284057,'__ci_last_regenerate|i:1688284055;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('tplf5444c0q4r8bekcbicmn7e6gips6g','103.180.244.161',1688638856,'__ci_last_regenerate|i:1688638856;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('ua2t18uob5n68g42ejdcd65q5kdnfuju','103.180.244.161',1688466026,'__ci_last_regenerate|i:1688466026;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('us0uloeaacka2ipki0i2a2i0odna880f','103.181.42.122',1687889071,'__ci_last_regenerate|i:1687889071;'),('va22e02ff85b0foeq9vcj8vg7ckmpab8','103.181.42.122',1688673454,'__ci_last_regenerate|i:1688673441;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;'),('voj6v75msebqpqin9tnbof4h0d02nfe8','37.111.226.24',1687890010,'__ci_last_regenerate|i:1687889817;name|s:11:\"Super Admin\";uniqueid|s:7:\"b195808\";logger_photo|N;loggedin_id|s:1:\"1\";loggedin_role_id|s:1:\"1\";loggedin_userid|s:1:\"1\";date_format|s:8:\"%d-%b-%Y\";set_lang|s:7:\"english\";loggedin|b:1;');
/*!40000 ALTER TABLE `ci_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email_config`
--

DROP TABLE IF EXISTS `email_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `email_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(200) DEFAULT NULL,
  `email_protocol` varchar(10) NOT NULL,
  `smtp_host` varchar(25) NOT NULL,
  `smtp_user` varchar(25) DEFAULT NULL,
  `smtp_pass` text NOT NULL,
  `smtp_port` varchar(100) NOT NULL,
  `smtp_encryption` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_config`
--

LOCK TABLES `email_config` WRITE;
/*!40000 ALTER TABLE `email_config` DISABLE KEYS */;
INSERT INTO `email_config` VALUES (1,'example@gmail.com','sendmail','smtp.gmail.com','example@gmail.com','1234','25','ssl');
/*!40000 ALTER TABLE `email_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email_templates`
--

DROP TABLE IF EXISTS `email_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_type` varchar(200) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `template_body` longtext NOT NULL,
  `tags` longtext NOT NULL,
  `notified` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_templates`
--

LOCK TABLES `email_templates` WRITE;
/*!40000 ALTER TABLE `email_templates` DISABLE KEYS */;
INSERT INTO `email_templates` VALUES (1,'account_registered','Account Registered','','{institute_name}, {name}, {username}, {password}, {user_role}, {login_url}',0),(2,'forgot_password','Forgot Password','','{institute_name}, {name}, {username}, {reset_url}',0),(5,'payslip_generated','Payslip generated','','{institute_name}, {name}, {month_year}, {payslip_no}, {payslip_url}',0),(6,'absent','Absent Notice','','{institute_name}, {name}, {date}',0),(7,'leave_approve','Your leave request has been approved','','{institute_name}, {name}, {admin_comments}, {start_date}, {end_date}',0),(8,'leave_reject','Your leave request has been reject','','{institute_name}, {name}, {admin_comments}, {start_date}, {end_date}',0),(9,'appointment_confirmation','Appointment Confirmation','','{institute_name}, {patient_name}, {doctor_name}, {consultation_fees}, {schedule_time}, {appointment_date}',0),(10,'appointment_canceled','Appointment Canceled','','{institute_name}, {patient_name}, {doctor_name}, {consultation_fees}, {schedule_time}, {appointment_date}',0);
/*!40000 ALTER TABLE `email_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_about`
--

DROP TABLE IF EXISTS `front_cms_about`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_about` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `page_title` varchar(255) NOT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `banner_image` varchar(255) DEFAULT NULL,
  `about_image` varchar(255) NOT NULL,
  `elements` mediumtext NOT NULL,
  `meta_description` text NOT NULL,
  `meta_keyword` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_about`
--

LOCK TABLES `front_cms_about` WRITE;
/*!40000 ALTER TABLE `front_cms_about` DISABLE KEYS */;
INSERT INTO `front_cms_about` VALUES (1,'Welcome to Hospitals','Best Medical &amp; Healthcare Needs to Our Patients','About Us','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut volutpat rutrum eros amet sollicitudin interdum. Suspendisse pulvinar, velit nec pharetra interdum, ante tellus ornare mi, et mollis tellus neque vitae elit. Mauris adipiscing mauris fringilla turpis interdum sed pulvinar nisi malesuada. Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>\r\n\r\n<p>Donec sed odio dui. Nulla vitae elit libero, a pharetra augue. Nullam id dolor id nibh ultricies vehicula ut id elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Duis mollis, est non commodo luctus, nisi erat porttitor ligula. Mauris sit amet neque nec nunc gravida.</p>\r\n\r\n<div class=\"row\">\r\n<div class=\"col-sm-6 col-12\">\r\n<ul class=\"list-unstyled list-style-3\">\r\n	<li><a href=\"#\">Cardiothoracic Surgery</a></li>\r\n	<li><a href=\"#\">Cardiovascular Diseases</a></li>\r\n	<li><a href=\"#\">Ophthalmology</a></li>\r\n	<li><a href=\"#\">Dermitology</a></li>\r\n</ul>\r\n</div>\r\n\r\n<div class=\"col-sm-6 col-12\">\r\n<ul class=\"list-unstyled list-style-3\">\r\n	<li><a href=\"#\">Cardiothoracic Surgery</a></li>\r\n	<li><a href=\"#\">Cardiovascular Diseases</a></li>\r\n	<li><a href=\"#\">Ophthalmology</a></li>\r\n</ul>\r\n</div>\r\n</div>','about.jpg','about.jpg','{\"cta_title\":\"Get in touch to join our community\",\"button_text\":\"Contact Our Office\",\"button_url\":\"contact\"}','','');
/*!40000 ALTER TABLE `front_cms_about` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_appointment`
--

DROP TABLE IF EXISTS `front_cms_appointment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_appointment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `page_title` varchar(255) DEFAULT NULL,
  `banner_image` varchar(255) DEFAULT NULL,
  `meta_description` text NOT NULL,
  `meta_keyword` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_appointment`
--

LOCK TABLES `front_cms_appointment` WRITE;
/*!40000 ALTER TABLE `front_cms_appointment` DISABLE KEYS */;
INSERT INTO `front_cms_appointment` VALUES (1,'Make An Appoinment','<p><span style=\"color: rgb(156, 156, 156); font-family: Poppins, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">Lorem ipsum dolor sit amet, eum illum dolore concludaturque ex, ius latine adipisci no. Pro at nullam laboramus definitiones. Mandamusconceptam omittantur cu cum. Brute appetere it scriptorem ei eam, ne vim velit novum nominati. Causae volutpat percipitur at sed ne.</span></p>\r\n','Appointment','appointment.jpg','','');
/*!40000 ALTER TABLE `front_cms_appointment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_contact`
--

DROP TABLE IF EXISTS `front_cms_contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `box_title` varchar(255) DEFAULT NULL,
  `box_description` varchar(500) DEFAULT NULL,
  `box_image` varchar(255) DEFAULT NULL,
  `form_title` varchar(355) DEFAULT NULL,
  `address` varchar(355) DEFAULT NULL,
  `phone` varchar(355) DEFAULT NULL,
  `email` varchar(355) DEFAULT NULL,
  `submit_text` varchar(355) NOT NULL,
  `map_iframe` text DEFAULT NULL,
  `page_title` varchar(255) NOT NULL,
  `banner_image` varchar(255) DEFAULT NULL,
  `meta_description` text NOT NULL,
  `meta_keyword` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_contact`
--

LOCK TABLES `front_cms_contact` WRITE;
/*!40000 ALTER TABLE `front_cms_contact` DISABLE KEYS */;
INSERT INTO `front_cms_contact` VALUES (1,'WE\'D LOVE TO HEAR FROM YOU','Fusce convallis diam vitae velit tempus rutrum. Donec nisl nisl, vulputate eu sapien sed, adipiscing vehicula massa. Mauris eget commodo neque, id molestie enim.','contact-info-box.png','Get in touch by filling the form below','4896  Romrog Way, LOS ANGELES,\r\nCalifornia','954-648-1802, \r\n963-612-1782','info@example.com\r\nsupport@example.com','Send','<iframe width=\"100%\" height=\"350\" id=\"gmap_canvas\" src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3313.3833161665298!2d-118.03745848530627!3d33.85401093559897!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x80dd2c6c97f8f3ed%3A0x47b1bde165dcc056!2sOak+Dr%2C+La+Palma%2C+CA+90623%2C+USA!5e0!3m2!1sen!2sbd!4v1544238752504\" frameborder=\"0\" scrolling=\"no\" marginheight=\"0\" marginwidth=\"0\"></iframe>','Contact Us','contact.jpg','','');
/*!40000 ALTER TABLE `front_cms_contact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_doctor_bio`
--

DROP TABLE IF EXISTS `front_cms_doctor_bio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_doctor_bio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doctor_id` varchar(20) NOT NULL,
  `biography` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_doctor_bio`
--

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

--
-- Table structure for table `front_cms_doctors`
--

DROP TABLE IF EXISTS `front_cms_doctors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_doctors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) DEFAULT NULL,
  `banner_image` varchar(255) DEFAULT NULL,
  `meta_description` text NOT NULL,
  `meta_keyword` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_doctors`
--

LOCK TABLES `front_cms_doctors` WRITE;
/*!40000 ALTER TABLE `front_cms_doctors` DISABLE KEYS */;
INSERT INTO `front_cms_doctors` VALUES (1,'Doctors','doctors.jpg','',''),(2,'Doctor Profile','doctor_profile.jpg','','');
/*!40000 ALTER TABLE `front_cms_doctors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_faq`
--

DROP TABLE IF EXISTS `front_cms_faq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_faq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `page_title` varchar(255) DEFAULT NULL,
  `banner_image` varchar(255) DEFAULT NULL,
  `meta_description` text NOT NULL,
  `meta_keyword` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_faq`
--

LOCK TABLES `front_cms_faq` WRITE;
/*!40000 ALTER TABLE `front_cms_faq` DISABLE KEYS */;
INSERT INTO `front_cms_faq` VALUES (1,'Frequently Asked Questions','<p>Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident.</p>\r\n\r\n<p>Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven&#39;t heard of them accusamus labore sustainable VHS.</p>','Faq','faq.jpg','','');
/*!40000 ALTER TABLE `front_cms_faq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_faq_list`
--

DROP TABLE IF EXISTS `front_cms_faq_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_faq_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_faq_list`
--

LOCK TABLES `front_cms_faq_list` WRITE;
/*!40000 ALTER TABLE `front_cms_faq_list` DISABLE KEYS */;
INSERT INTO `front_cms_faq_list` VALUES (1,'Any Information you provide on applications for disability, life or accidental insurance ?','<p>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco quat. It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.\r\n</p>\r\n<ul>\r\n<li>Lorem ipsum dolor sit amet, consectetur adipisicing elit.</li>\r\n<li>Sed do eiusmod tempor incididunt ut labore et dolore magna aliq.</li>\r\n<li>Ut enim ad minim veniam, quis nostrud exercitation ullamco quat. It is a long established fact.</li>\r\n<li>That a reader will be distracted by the readable content of a page when looking at its layout.</li>\r\n<li>Lorem ipsum dolor sit amet, consectetur adipisicing elit.</li>\r\n<li>Eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.</li>\r\n<li>Quis nostrud exercitation ullamco quat. It is a long established fact that a reader will be distracted.</li>\r\n<li>Readable content of a page when looking at its layout.</li>\r\n<li>The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters.</li>\r\n<li>Opposed to using \'Content here, content here\', making it look like readable English.</li>\r\n</ul>'),(2,'Readable content of a page when looking at its layout ?','<p>\r\n                                Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.\r\n                            </p>\r\n                            <ol>\r\n                                <li>Quis nostrud exercitation ullamco quat. It is a long established fact that a reader will be distracted.</li>\r\n                                <li>Readable content of a page when looking at its layout.</li>\r\n                                <li>The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters.</li>\r\n                                <li>Opposed to using \'Content here, content here\', making it look like readable English.</li>\r\n                            </ol>\r\n                            <p>\r\n                                Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et.\r\n                            </p>'),(3,'Opposed to using \'Content here, content here\', making it look like readable English ?','<p>\r\n                                Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.\r\n                            </p>\r\n                            <ol>\r\n                                <li>Quis nostrud exercitation ullamco quat. It is a long established fact that a reader will be distracted.</li>\r\n                                <li>Readable content of a page when looking at its layout.</li>\r\n                                <li>The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters.</li>\r\n                                <li>Opposed to using \'Content here, content here\', making it look like readable English.</li>\r\n                            </ol>\r\n                            <p>\r\n                                Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et.\r\n                            </p>'),(4,'Readable content of a page when looking at its layout ?','<p>\r\n                                Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven\'t heard of them accusamus labore sustainable VHS.\r\n                            </p>\r\n                            <ol>\r\n                                <li>Quis nostrud exercitation ullamco quat. It is a long established fact that a reader will be distracted.</li>\r\n                                <li>Readable content of a page when looking at its layout.</li>\r\n                                <li>The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters.</li>\r\n                                <li>Opposed to using \'Content here, content here\', making it look like readable English.</li>\r\n                            </ol>\r\n                            <p>\r\n                                Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et.\r\n                            </p>'),(5,'What types of documents are required to travel?','<p><strong>Lorem ipsum</strong> dolor sit amet, an labores explicari qui, eu nostrum copiosae argumentum has. Latine propriae quo no, unum ridens expetenda id sit, at usu eius eligendi singulis. Sea ocurreret principes ne. At nonumy aperiri pri, nam quodsi copiosae intellegebat et, ex deserunt euripidis usu. Per ad ullum lobortis. Duo volutpat imperdiet ut, postea salutatus imperdiet ut per, ad utinam debitis invenire has.</p>\r\n\r\n<ol>\r\n	<li>labores explicari qui</li>\r\n	<li>labores explicari qui</li>\r\n	<li>labores explicari quilabores explicari qui</li>\r\n	<li>labores explicari qui</li>\r\n</ol>');
/*!40000 ALTER TABLE `front_cms_faq_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_home`
--

DROP TABLE IF EXISTS `front_cms_home`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_home` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `item_type` varchar(20) NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `elements` mediumtext NOT NULL,
  `active` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_home`
--

LOCK TABLES `front_cms_home` WRITE;
/*!40000 ALTER TABLE `front_cms_home` DISABLE KEYS */;
INSERT INTO `front_cms_home` VALUES (1,'We Offer Fast &amp; Reliable','Medical &amp; Healthcare Needs','wellcome','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using content.\r\n\r\nMaking it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).','{\"image\":\"wellcome.jpg\"}',0),(2,'Experience Doctor Team',NULL,'doctors','Making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident.','{\"doctor_start\":\"1\",\"image\":\"featured-parallax.jpg\"}',0),(3,'Our Best Medical Services',NULL,'services','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','',0),(4,'Online Hassle Free Appointment Booking','Medical Services','cta','','{\"mobile_no\":\"+2484-398-8987\",\"button_text\":\"Book your Appointment\",\"button_url\":\"appointment\",\"image\":\"appointment-booking-img.png\"}',0),(5,'Best <span>Digital</span> Experience',NULL,'slider','Lorem Ipsum is simply dummy text printer took a galley of type and scrambled it to make a type specimen book.','{\"position\":\"c-left\",\"button_text1\":\"View Services\",\"button_url1\":\"#\",\"button_text2\":\"Learn More\",\"button_url2\":\"#\",\"image\":\"home-slider-1578743357.jpg\"}',0),(6,'Main Heading <span>Some Caption</span> Here',NULL,'slider','Lorem Ipsum is simply dummy text printer took a galley of type and scrambled it to make a type specimen book.','{\"position\":\"c-center\",\"button_text1\":\"Read More\",\"button_url1\":\"#\",\"button_text2\":\"Get Started\",\"button_url2\":\"#\",\"image\":\"home-slider-1578743366.jpg\"}',0),(7,'Here creative & professional <span>PHP</span> template',NULL,'slider','Lorem Ipsum is simply dummy text printer took a galley of type and scrambled it to make a type specimen book.','{\"position\":\"c-right\",\"button_text1\":\"Read More\",\"button_url1\":\"#\",\"button_text2\":\"Contact us\",\"button_url2\":\"contact\",\"image\":\"home-slider-1578743373.jpg\"}',0),(8,'Qualified Doctors',NULL,'features','Nulla metus metus ullamcorper vel tincidunt sed euismod nibh Quisque volutpat condimentum velit class aptent taciti sociosqu.','{\"button_text\":\"Read More\",\"button_url\":\"#\",\"icon\":\"fas fa-user-md\"}',0),(9,'Regular Checkup',NULL,'features','Nulla metus metus ullamcorper vel tincidunt sed euismod nibh Quisque volutpat condimentum velit class aptent taciti sociosqu.','{\"button_text\":\"Read More\",\"button_url\":\"#\",\"icon\":\"fas fa-stethoscope\"}',0),(10,'Neurosurgeon',NULL,'features','Nulla metus metus ullamcorper vel tincidunt sed euismod nibh Quisque volutpat condimentum velit class aptent taciti sociosqu.','{\"button_text\":\"Read More\",\"button_url\":\"#\",\"icon\":\"fas fa-vial\"}',0),(11,'24 Hours  Service',NULL,'features','Nulla metus metus ullamcorper vel tincidunt sed euismod nibh Quisque volutpat condimentum velit class aptent taciti sociosqu.','{\"button_text\":\"Read More\",\"button_url\":\"#\",\"icon\":\"far fa-clock\"}',0),(12,'Our Happy Patients Opinion',NULL,'testimonial','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','',0);
/*!40000 ALTER TABLE `front_cms_home` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_home_seo`
--

DROP TABLE IF EXISTS `front_cms_home_seo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_home_seo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) NOT NULL,
  `meta_keyword` text NOT NULL,
  `meta_description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_home_seo`
--

LOCK TABLES `front_cms_home_seo` WRITE;
/*!40000 ALTER TABLE `front_cms_home_seo` DISABLE KEYS */;
INSERT INTO `front_cms_home_seo` VALUES (1,'Home','','');
/*!40000 ALTER TABLE `front_cms_home_seo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_menu`
--

DROP TABLE IF EXISTS `front_cms_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `alias` varchar(100) NOT NULL,
  `ordering` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT 0,
  `open_new_tab` int(11) NOT NULL DEFAULT 0,
  `ext_url` int(11) NOT NULL DEFAULT 0,
  `ext_url_address` text DEFAULT NULL,
  `publish` int(11) NOT NULL,
  `system` varchar(10) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_menu`
--

LOCK TABLES `front_cms_menu` WRITE;
/*!40000 ALTER TABLE `front_cms_menu` DISABLE KEYS */;
INSERT INTO `front_cms_menu` VALUES (1,'Home','index',1,0,0,0,'',1,'1','2019-08-09 18:18:54'),(2,'Appointment','appointment',3,0,0,0,'',1,'1','2019-08-09 18:18:54'),(3,'Doctors','doctors',2,0,0,0,'',1,'1','2019-08-09 18:18:54'),(4,'About Us','about',4,0,0,0,'',1,'1','2019-08-09 18:18:54'),(5,'FAQ','faq',5,0,0,0,'',1,'1','2019-08-09 18:18:54'),(6,'Contact Us','contact',6,0,0,0,'',1,'1','2019-08-09 18:18:54');
/*!40000 ALTER TABLE `front_cms_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_pages`
--

DROP TABLE IF EXISTS `front_cms_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) NOT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `menu_id` int(11) NOT NULL,
  `banner_image` varchar(255) DEFAULT NULL,
  `meta_description` text NOT NULL,
  `meta_keyword` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_pages`
--

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

--
-- Table structure for table `front_cms_services`
--

DROP TABLE IF EXISTS `front_cms_services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `parallax_image` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_services`
--

LOCK TABLES `front_cms_services` WRITE;
/*!40000 ALTER TABLE `front_cms_services` DISABLE KEYS */;
INSERT INTO `front_cms_services` VALUES (1,'Get Well Soon','Our Hosptial <span>Services</span>','service_parallax.jpg');
/*!40000 ALTER TABLE `front_cms_services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_services_list`
--

DROP TABLE IF EXISTS `front_cms_services_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_services_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_services_list`
--

LOCK TABLES `front_cms_services_list` WRITE;
/*!40000 ALTER TABLE `front_cms_services_list` DISABLE KEYS */;
INSERT INTO `front_cms_services_list` VALUES (1,'First Aid','Making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text.','fas fa-medal'),(2,'Dental Care','Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover.','fas fa-heartbeat'),(3,'24x7 Ambulance','Making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model.','fas fa-ambulance'),(4,'Qualified Doctors','Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will.','fas fa-capsules'),(5,'Medical Pharmacy','Making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover.','fas fa-stethoscope'),(6,'Pulmonary','Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a for \'lorem ipsum\' will uncover.','fas fa-medkit');
/*!40000 ALTER TABLE `front_cms_services_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_setting`
--

DROP TABLE IF EXISTS `front_cms_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `application_title` varchar(255) NOT NULL,
  `captcha_status` varchar(20) NOT NULL,
  `recaptcha_site_key` varchar(255) NOT NULL,
  `recaptcha_secret_key` varchar(255) NOT NULL,
  `address` varchar(350) NOT NULL,
  `mobile_no` varchar(60) NOT NULL,
  `fax` varchar(60) NOT NULL,
  `receive_contact_email` varchar(255) NOT NULL,
  `email` varchar(60) NOT NULL,
  `footer_text` varchar(255) NOT NULL,
  `fav_icon` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `working_hours` varchar(300) NOT NULL,
  `facebook_url` varchar(100) NOT NULL,
  `twitter_url` varchar(100) NOT NULL,
  `youtube_url` varchar(100) NOT NULL,
  `google_plus` varchar(100) NOT NULL,
  `linkedin_url` varchar(100) NOT NULL,
  `pinterest_url` varchar(100) NOT NULL,
  `instagram_url` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_setting`
--

LOCK TABLES `front_cms_setting` WRITE;
/*!40000 ALTER TABLE `front_cms_setting` DISABLE KEYS */;
INSERT INTO `front_cms_setting` VALUES (1,'Ramom - Diagnostic Management System With CMS','disable','','','','+1-954-648-1802','001 - 785 987 1234','info@example.com','info@demo.com','© 2019 <span>Ramom</span>. All Rights Reserved.','fav_icon.ico','logo.png','<span>Hours : </span>  Mon To Fri - 9:00 - 20:00,  Sunday Closed','https://facebook.com','https://twitter.com','https://youtube.com','https://google.com','https://linkedin.com','https://pinterest.com','https://instagram.com');
/*!40000 ALTER TABLE `front_cms_setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `front_cms_testimonial`
--

DROP TABLE IF EXISTS `front_cms_testimonial`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `front_cms_testimonial` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_name` varchar(255) NOT NULL,
  `surname` varchar(355) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `rank` int(5) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `front_cms_testimonial`
--

LOCK TABLES `front_cms_testimonial` WRITE;
/*!40000 ALTER TABLE `front_cms_testimonial` DISABLE KEYS */;
INSERT INTO `front_cms_testimonial` VALUES (1,'Gartrell Wright','Los Angeles','defualt.png','Intexure have done an excellent job presenting the analysis & insights. I am confident in saying  have helped encounter  is to be welcomed and every pain avoided”.',1,1,'2019-08-23 18:26:42'),(2,'Clifton Hyde','Newyork City','defualt.png','“Owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted always holds”.',4,1,'2019-08-23 18:26:42'),(3,'Emily Lemus','Los Angeles','defualt.png','“Intexure have done an excellent job presenting the analysis & insights. I am confident in saying  have helped encounter  is to be welcomed and every pain avoided”.',5,1,'2019-08-23 18:26:42'),(4,'Michel Jhon','CEO','defualt.png','“Owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted always holds”.',3,1,'2019-08-23 18:26:42'),(5,'Hilda Howard','Chicago City','defualt.png','“Owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted always holds”.',4,1,'2019-08-23 18:26:42');
/*!40000 ALTER TABLE `front_cms_testimonial` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `global_settings`
--

DROP TABLE IF EXISTS `global_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `global_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `institute_name` varchar(255) NOT NULL,
  `institute_email` varchar(100) NOT NULL,
  `address` text NOT NULL,
  `mobileno` varchar(50) NOT NULL,
  `currency` varchar(50) NOT NULL,
  `currency_symbol` varchar(50) NOT NULL,
  `translation` varchar(20) NOT NULL,
  `footer_text` text NOT NULL,
  `animations` varchar(50) NOT NULL,
  `timezone` varchar(30) NOT NULL,
  `date_format` varchar(20) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
  `facebook_url` varchar(255) NOT NULL,
  `twitter_url` varchar(255) NOT NULL,
  `linkedin_url` varchar(255) NOT NULL,
  `youtube_url` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `global_settings`
--

LOCK TABLES `global_settings` WRITE;
/*!40000 ALTER TABLE `global_settings` DISABLE KEYS */;
INSERT INTO `global_settings` VALUES (1,'Care Diagonstic Center','Ramom@example.com','','','USD','৳','english','Care Diagonstic Center','fadeInUp','Asia/Dhaka','%d-%b-%Y','','','','','2018-10-22 15:07:49','2023-06-27 17:30:22');
/*!40000 ALTER TABLE `global_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lab_report_template`
--

DROP TABLE IF EXISTS `lab_report_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lab_report_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `template` longtext NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lab_report_template`
--

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

--
-- Table structure for table `lab_test`
--

DROP TABLE IF EXISTS `lab_test`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lab_test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `name` varchar(155) NOT NULL,
  `patient_price` decimal(18,2) NOT NULL DEFAULT 0.00,
  `production_cost` decimal(18,2) NOT NULL DEFAULT 0.00,
  `test_code` varchar(20) NOT NULL,
  `date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lab_test`
--

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

--
-- Table structure for table `lab_test_category`
--

DROP TABLE IF EXISTS `lab_test_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lab_test_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lab_test_category`
--

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

--
-- Table structure for table `labtest_bill`
--

DROP TABLE IF EXISTS `labtest_bill`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `labtest_bill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bill_no` varchar(10) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `referral_id` int(11) NOT NULL,
  `total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `tax_amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `commission` decimal(18,2) DEFAULT 0.00,
  `paid` decimal(18,2) NOT NULL DEFAULT 0.00,
  `due` decimal(18,2) NOT NULL DEFAULT 0.00,
  `status` tinyint(1) NOT NULL,
  `date` date DEFAULT NULL,
  `hash` varchar(50) NOT NULL,
  `prepared_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `labtest_bill`
--

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

--
-- Table structure for table `labtest_bill_details`
--

DROP TABLE IF EXISTS `labtest_bill_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `labtest_bill_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `labtest_bill_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `test_id` int(11) NOT NULL,
  `price` decimal(18,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `commission_amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `labtest_bill_details`
--

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

--
-- Table structure for table `labtest_payment_history`
--

DROP TABLE IF EXISTS `labtest_payment_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `labtest_payment_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `labtest_bill_id` int(11) NOT NULL,
  `collect_by` int(11) DEFAULT NULL,
  `amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `method_id` int(11) NOT NULL,
  `remarks` text NOT NULL,
  `paid_on` date NOT NULL,
  `coll_type` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `labtest_payment_history`
--

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

--
-- Table structure for table `labtest_report`
--

DROP TABLE IF EXISTS `labtest_report`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `labtest_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `labtest_bill_id` int(11) NOT NULL,
  `reporting_date` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `delivery_time` time DEFAULT NULL,
  `report_description` longtext DEFAULT NULL,
  `report_remarks` text DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `labtest_report`
--

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

--
-- Table structure for table `language_list`
--

DROP TABLE IF EXISTS `language_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `language_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `lang_field` varchar(100) NOT NULL,
  `status` varchar(11) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `language_list`
--

LOCK TABLES `language_list` WRITE;
/*!40000 ALTER TABLE `language_list` DISABLE KEYS */;
INSERT INTO `language_list` VALUES (1,'English','english','1','2018-11-15 17:36:31','2020-01-09 11:45:23'),(2,'Bengali','bengali','0','2018-11-15 17:36:31','2020-01-11 18:11:42'),(3,'Arabic','arabic','0','2018-11-15 17:36:31','2020-01-07 13:22:02'),(4,'German','german','0','2018-11-15 17:36:31','2019-06-17 03:05:26'),(5,'Greek','greek','0','2018-11-15 17:36:31','2019-06-17 03:05:28'),(6,'Spanish','spanish','0','2018-11-15 17:36:31','2019-06-17 03:05:29'),(7,'French','french','0','2018-11-15 17:36:31','2019-06-17 03:05:31'),(8,'Hindi','hindi','0','2018-11-15 17:36:31','2019-06-17 03:05:33'),(9,'Hungarian','hungarian','0','2018-11-15 17:36:31','2019-06-17 03:05:34'),(10,'Indonesian','indonesian','0','2018-11-15 17:36:31','2019-06-17 03:05:35'),(11,'Italian','italian','0','2018-11-15 17:36:31','2019-06-17 03:05:37'),(12,'Japanese','japanese','0','2018-11-15 17:36:31','2019-06-17 03:05:38'),(13,'Korean','korean','0','2018-11-15 17:36:31','2019-06-17 03:05:40'),(14,'Latin','latin','0','2018-11-15 17:36:31','2019-06-17 03:05:41'),(15,'Dutch','dutch','0','2018-11-15 17:36:31','2019-06-17 03:05:43'),(16,'Portuguese','portuguese','0','2018-11-15 17:36:31','2019-06-17 03:05:44'),(17,'Russian','russian','0','2018-11-15 17:36:31','2019-06-17 03:05:46'),(18,'Thai','thai','0','2018-11-15 17:36:31','2019-06-17 03:05:47'),(19,'Turkish','turkish','0','2018-11-15 17:36:31','2019-06-17 03:05:49'),(20,'Urdu','urdu','0','2018-11-15 17:36:31','2019-06-17 03:05:50'),(21,'Chinese','chinese','0','2018-11-15 17:36:31','2019-06-17 03:05:51');
/*!40000 ALTER TABLE `language_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `languages`
--

DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `languages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `word` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `english` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bengali` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `arabic` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `german` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `greek` varchar(100) NOT NULL,
  `spanish` varchar(100) NOT NULL,
  `french` varchar(100) NOT NULL,
  `hindi` varchar(100) NOT NULL,
  `hungarian` varchar(100) NOT NULL,
  `indonesian` varchar(100) NOT NULL,
  `italian` varchar(100) NOT NULL,
  `japanese` varchar(100) NOT NULL,
  `korean` varchar(100) NOT NULL,
  `latin` varchar(100) NOT NULL,
  `dutch` varchar(100) NOT NULL,
  `portuguese` varchar(100) NOT NULL,
  `russian` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `thai` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `turkish` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `urdu` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `chinese` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=457 DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `languages`
--

LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
INSERT INTO `languages` VALUES (1,'dashboard','Dashboard','','','','','','','','','','','','','','','','','','','',''),(2,'create','Create','','','','','','','','','','','','','','','','','','','',''),(3,'patient','Patient','','','','','','','','','','','','','','','','','','','',''),(4,'test','Test','','','','','','','','','','','','','','','','','','','',''),(5,'bill','Bill','','','','','','','','','','','','','','','','','','','',''),(6,'commission','Commission','','','','','','','','','','','','','','','','','','','',''),(7,'withdrawal','Withdrawal','','','','','','','','','','','','','','','','','','','',''),(8,'appointment','Appointment','','','','','','','','','','','','','','','','','','','',''),(9,'voucher','Voucher','','','','','','','','','','','','','','','','','','','',''),(10,'income_vs_expense','Income Vs Expense','','','','','','','','','','','','','','','','','','','',''),(11,'search','Search','','','','','','','','','','','','','','','','','','','',''),(12,'visit_home_page','Visit Home Page','','','','','','','','','','','','','','','','','','','',''),(13,'language','Language','','','','','','','','','','','','','','','','','','','',''),(14,'logout','Logout','','','','','','','','','','','','','','','','','','','',''),(15,'profile','Profile','','','','','','','','','','','','','','','','','','','',''),(16,'reset_password','Reset Password','','','','','','','','','','','','','','','','','','','',''),(17,'global','Global','','','','','','','','','','','','','','','','','','','',''),(18,'settings','Settings','','','','','','','','','','','','','','','','','','','',''),(19,'frontend','Frontend','','','','','','','','','','','','','','','','','','','',''),(20,'setting','Setting','','','','','','','','','','','','','','','','','','','',''),(21,'menu','Menu','','','','','','','','','','','','','','','','','','','',''),(22,'page','Page','','','','','','','','','','','','','','','','','','','',''),(23,'section','Section','','','','','','','','','','','','','','','','','','','',''),(24,'manage','Manage','','','','','','','','','','','','','','','','','','','',''),(25,'slider','Slider','','','','','','','','','','','','','','','','','','','',''),(26,'features','Features','','','','','','','','','','','','','','','','','','','',''),(27,'testimonial','Testimonial','','','','','','','','','','','','','','','','','','','',''),(28,'service','Service','','','','','','','','','','','','','','','','','','','',''),(29,'faq','Faq','','','','','','','','','','','','','','','','','','','',''),(30,'details','Details','','','','','','','','','','','','','','','','','','','',''),(31,'list','List','','','','','','','','','','','','','','','','','','','',''),(32,'category','Category','','','','','','','','','','','','','','','','','','','',''),(33,'login_deactivate','Login Deactivate','','','','','','','','','','','','','','','','','','','',''),(34,'inventory','Inventory','','','','','','','','','','','','','','','','','','','',''),(35,'chemical','Chemical','','','','','','','','','','','','','','','','','','','',''),(36,'supplier','Supplier','','','','','','','','','','','','','','','','','','','',''),(37,'unit','Unit','','','','','','','','','','','','','','','','','','','',''),(38,'purchase','Purchase','','','','','','','','','','','','','','','','','','','',''),(39,'stock','Stock','','','','','','','','','','','','','','','','','','','',''),(40,'reagent','Reagent','','','','','','','','','','','','','','','','','','','',''),(41,'assigned','Assigned','','','','','','','','','','','','','','','','','','','',''),(42,'reports','Reports','','','','','','','','','','','','','','','','','','','',''),(43,'report','Report','','','','','','','','','','','','','','','','','','','',''),(44,'payment','Payment','','','','','','','','','','','','','','','','','','','',''),(45,'schedule','Schedule','','','','','','','','','','','','','','','','','','','',''),(46,'add','Add','','','','','','','','','','','','','','','','','','','',''),(47,'requested_list','Requested List','','','','','','','','','','','','','','','','','','','',''),(48,'employee','Employee','','','','','','','','','','','','','','','','','','','',''),(49,'department','Department','','','','','','','','','','','','','','','','','','','',''),(50,'designation','Designation','','','','','','','','','','','','','','','','','','','',''),(51,'hrm','Human Resource','','','','','','','','','','','','','','','','','','','',''),(52,'payroll','Payroll','','','','','','','','','','','','','','','','','','','',''),(53,'salary','Salary','','','','','','','','','','','','','','','','','','','',''),(54,'template','Template','','','','','','','','','','','','','','','','','','','',''),(55,'assign','Assign','','','','','','','','','','','','','','','','','','','',''),(56,'summary','Summary','','','','','','','','','','','','','','','','','','','',''),(57,'leaves','Leaves','','','','','','','','','','','','','','','','','','','',''),(58,'my_leave','My Leave','','','','','','','','','','','','','','','','','','','',''),(59,'leave_manage','Leave Manage','','','','','','','','','','','','','','','','','','','',''),(60,'attendance','Attendance','','','','','','','','','','','','','','','','','','','',''),(61,'set','Set','','','','','','','','','','','','','','','','','','','',''),(62,'pathology','Pathology','','','','','','','','','','','','','','','','','','','',''),(63,'lab','Lab','','','','','','','','','','','','','','','','','','','',''),(64,'refer_manager','Refer Manager','','','','','','','','','','','','','','','','','','','',''),(65,'referral','Referral','','','','','','','','','','','','','','','','','','','',''),(66,'my_commission','My Commission','','','','','','','','','','','','','','','','','','','',''),(67,'statement','Statement','','','','','','','','','','','','','','','','','','','',''),(68,'payout','Payout','','','','','','','','','','','','','','','','','','','',''),(69,'office_accounting','Office Accounting','','','','','','','','','','','','','','','','','','','',''),(70,'account','Account','','','','','','','','','','','','','','','','','','','',''),(71,'head','Head','','','','','','','','','','','','','','','','','','','',''),(72,'income','Income','','','','','','','','','','','','','','','','','','','',''),(73,'repots','Repots','','','','','','','','','','','','','','','','','','','',''),(74,'expense','Expense','','','','','','','','','','','','','','','','','','','',''),(75,'transitions','Transitions','','','','','','','','','','','','','','','','','','','',''),(76,'balance','Balance','','','','','','','','','','','','','','','','','','','',''),(77,'sheet','Sheet','','','','','','','','','','','','','','','','','','','',''),(78,'billing','Billing','','','','','','','','','','','','','','','','','','','',''),(79,'due','Due','','','','','','','','','','','','','','','','','','','',''),(80,'paid','Paid','','','','','','','','','','','','','','','','','','','',''),(81,'collect','Collect','','','','','','','','','','','','','','','','','','','',''),(82,'investigation','Investigation','','','','','','','','','','','','','','','','','','','',''),(83,'sms','Sms','','','','','','','','','','','','','','','','','','','',''),(84,'email','Email','','','','','','','','','','','','','','','','','','','',''),(85,'role','Role','','','','','','','','','','','','','','','','','','','',''),(86,'permission','Permission','','','','','','','','','','','','','','','','','','','',''),(87,'database','Database','','','','','','','','','','','','','','','','','','','',''),(88,'backup','Backup','','','','','','','','','','','','','','','','','','','',''),(89,'invoice','Invoice','','','','','','','','','','','','','','','','','','','',''),(90,'today_total','Today Total','','','','','','','','','','','','','','','','','','','',''),(91,'annual','Annual','','','','','','','','','','','','','','','','','','','',''),(92,'total_strength','Total Strength','','','','','','','','','','','','','','','','','','','',''),(93,'doctor','Doctor','','','','','','','','','','','','','','','','','','','',''),(94,'pending','Pending','','','','','','','','','','','','','','','','','','','',''),(95,'request','Request','','','','','','','','','','','','','','','','','','','',''),(96,'fees','Fees','','','','','','','','','','','','','','','','','','','',''),(97,'net','Net','','','','','','','','','','','','','','','','','','','',''),(98,'payable','Payable','','','','','','','','','','','','','','','','','','','',''),(99,'total','Total','','','','','','','','','','','','','','','','','','','',''),(100,'this_value_is_required','This Value Is Required','','','','','','','','','','','','','','','','','','','',''),(101,'enter_valid_email','Enter Valid Email','','','','','','','','','','','','','','','','','','','',''),(102,'are_you_sure','Are You Sure','','','','','','','','','','','','','','','','','','','',''),(103,'delete_this_information','Delete This Information','','','','','','','','','','','','','','','','','','','',''),(104,'yes_continue','Yes Continue','','','','','','','','','','','','','','','','','','','',''),(105,'cancel','Cancel','','','','','','','','','','','','','','','','','','','',''),(106,'deleted_note','*Note : This Data Will Be Permanently Deleted','','','','','','','','','','','','','','','','','','','',''),(107,'deleted','Deleted','','','','','','','','','','','','','','','','','','','',''),(108,'information_deleted','Information Deleted','','','','','','','','','','','','','','','','','','','',''),(109,'website','Website','','','','','','','','','','','','','','','','','','','',''),(110,'application','Application','','','','','','','','','','','','','','','','','','','',''),(111,'name','Name','','','','','','','','','','','','','','','','','','','',''),(112,'receive_email_to','Receive Email To','','','','','','','','','','','','','','','','','','','',''),(113,'captcha_status','Captcha Status','','','','','','','','','','','','','','','','','','','',''),(114,'select','Select','','','','','','','','','','','','','','','','','','','',''),(115,'disable','Disable','','','','','','','','','','','','','','','','','','','',''),(116,'enable','Enable','','','','','','','','','','','','','','','','','','','',''),(117,'recaptcha_site_key','Recaptcha Site Key','','','','','','','','','','','','','','','','','','','',''),(118,'recaptcha_secret_key','Recaptcha Secret Key','','','','','','','','','','','','','','','','','','','',''),(119,'working_hours','Working Hours','','','','','','','','','','','','','','','','','','','',''),(120,'logo','Logo','','','','','','','','','','','','','','','','','','','',''),(121,'fav_icon','Fav Icon','','','','','','','','','','','','','','','','','','','',''),(122,'address','Address','','','','','','','','','','','','','','','','','','','',''),(123,'mobile_no','Mobile No','','','','','','','','','','','','','','','','','','','',''),(124,'fax','Fax','','','','','','','','','','','','','','','','','','','',''),(125,'footer_text','Footer Text','','','','','','','','','','','','','','','','','','','',''),(126,'facebook_url','Facebook Url','','','','','','','','','','','','','','','','','','','',''),(127,'twitter_url','Twitter Url','','','','','','','','','','','','','','','','','','','',''),(128,'youtube_url','Youtube Url','','','','','','','','','','','','','','','','','','','',''),(129,'google_plus','Google Plus','','','','','','','','','','','','','','','','','','','',''),(130,'linkedin_url','Linkedin Url','','','','','','','','','','','','','','','','','','','',''),(131,'pinterest_url','Pinterest Url','','','','','','','','','','','','','','','','','','','',''),(132,'instagram_url','Instagram Url','','','','','','','','','','','','','','','','','','','',''),(133,'save','Save','','','','','','','','','','','','','','','','','','','',''),(134,'website_page','Website Page','','','','','','','','','','','','','','','','','','','',''),(135,'welcome','Welcome','','','','','','','','','','','','','','','','','','','',''),(136,'message','Message','','','','','','','','','','','','','','','','','','','',''),(137,'doctors','Doctors','','','','','','','','','','','','','','','','','','','',''),(138,'services','Services','','','','','','','','','','','','','','','','','','','',''),(139,'call_to_action_section','Call To Action Section','','','','','','','','','','','','','','','','','','','',''),(140,'options','Options','','','','','','','','','','','','','','','','','','','',''),(141,'title','Title','','','','','','','','','','','','','','','','','','','',''),(142,'subtitle','Subtitle','','','','','','','','','','','','','','','','','','','',''),(143,'description','Description','','','','','','','','','','','','','','','','','','','',''),(144,'photo','Photo','','','','','','','','','','','','','','','','','','','',''),(145,'cta','Cta','','','','','','','','','','','','','','','','','','','',''),(146,'button_text','Button Text','','','','','','','','','','','','','','','','','','','',''),(147,'button_url','Button Url','','','','','','','','','','','','','','','','','','','',''),(148,'_title',' Title','','','','','','','','','','','','','','','','','','','',''),(149,'meta','Meta','','','','','','','','','','','','','','','','','','','',''),(150,'keyword','Keyword','','','','','','','','','','','','','','','','','','','',''),(151,'banner_photo','Banner Photo','','','','','','','','','','','','','','','','','','','',''),(152,'about','About','','','','','','','','','','','','','','','','','','','',''),(153,'content','Content','','','','','','','','','','','','','','','','','','','',''),(154,'about_photo','About Photo','','','','','','','','','','','','','','','','','','','',''),(155,'parallax_photo','Parallax Photo','','','','','','','','','','','','','','','','','','','',''),(156,'sl','Sl','','','','','','','','','','','','','','','','','','','',''),(157,'url','Url','','','','','','','','','','','','','','','','','','','',''),(158,'action','Action','','','','','','','','','','','','','','','','','','','',''),(159,'my_appointment','My Appointment','','','','','','','','','','','','','','','','','','','',''),(160,'appointment_status','Appointment Status','','','','','','','','','','','','','','','','','','','',''),(161,'date','Date','','','','','','','','','','','','','','','','','','','',''),(162,'time_slot','Time Slot','','','','','','','','','','','','','','','','','','','',''),(163,'consultation_fees','Consultation Fees','','','','','','','','','','','','','','','','','','','',''),(164,'discount','Discount','','','','','','','','','','','','','','','','','','','',''),(165,'remarks','Remarks','','','','','','','','','','','','','','','','','','','',''),(166,'exploring','Exploring','','','','','','','','','','','','','','','','','','','',''),(167,'no_schedule_found','No Schedule Found','','','','','','','','','','','','','','','','','','','',''),(168,'information_has_been_saved_successfully','Information Has Been Saved Successfully','','','','','','','','','','','','','','','','','','','',''),(169,'id','Id','','','','','','','','','','','','','','','','','','','',''),(170,'consultation','Consultation','','','','','','','','','','','','','','','','','','','',''),(171,'serial','Serial','','','','','','','','','','','','','','','','','','','',''),(172,'status','Status','','','','','','','','','','','','','','','','','','','',''),(173,'confirmed','Confirmed','','','','','','','','','','','','','','','','','','','',''),(174,'available','Available','','','','','','','','','','','','','','','','','','','',''),(175,'staff_id','Staff Id','','','','','','','','','','','','','','','','','','','',''),(176,'general','General','','','','','','','','','','','','','','','','','','','',''),(177,'theme','Theme','','','','','','','','','','','','','','','','','','','',''),(178,'institute_name','Institute Name','','','','','','','','','','','','','','','','','','','',''),(179,'currency','Currency','','','','','','','','','','','','','','','','','','','',''),(180,'currency_symbol','Currency Symbol','','','','','','','','','','','','','','','','','','','',''),(181,'timezone','Timezone','','','','','','','','','','','','','','','','','','','',''),(182,'date_format','Date Format','','','','','','','','','','','','','','','','','','','',''),(183,'system_logo','System Logo','','','','','','','','','','','','','','','','','','','',''),(184,'text_logo','Text Logo','','','','','','','','','','','','','','','','','','','',''),(185,'upload','Upload','','','','','','','','','','','','','','','','','','','',''),(186,'select_ground','Select Ground','','','','','','','','','','','','','','','','','','','',''),(187,'filter','Filter','','','','','','','','','','','','','','','','','','','',''),(188,'bill_no','Bill No','','','','','','','','','','','','','','','','','','','',''),(189,'delivery','Delivery','','','','','','','','','','','','','','','','','','','',''),(190,'lab_test','Lab Test','','','','','','','','','','','','','','','','','','','',''),(191,'edit','Edit','','','','','','','','','','','','','','','','','','','',''),(192,'code','Code','','','','','','','','','','','','','','','','','','','',''),(193,'purchase_unit','Purchase Unit','','','','','','','','','','','','','','','','','','','',''),(194,'sale_unit','Sale Unit','','','','','','','','','','','','','','','','','','','',''),(195,'unit_ratio','Unit Ratio','','','','','','','','','','','','','','','','','','','',''),(196,'purchase_price','Purchase Price','','','','','','','','','','','','','','','','','','','',''),(197,'sales_price','Sales Price','','','','','','','','','','','','','','','','','','','',''),(198,'all_select','All Select','','','','','','','','','','','','','','','','','','','',''),(199,'unpaid','Unpaid','','','','','','','','','','','','','','','','','','','',''),(200,'partly_paid','Partly Paid','','','','','','','','','','','','','','','','','','','',''),(201,'total_paid','Total Paid','','','','','','','','','','','','','','','','','','','',''),(202,'type','Type','','','','','','','','','','','','','','','','','','','',''),(203,'ref_no','Ref No','','','','','','','','','','','','','','','','','','','',''),(204,'pay_via','Pay Via','','','','','','','','','','','','','','','','','','','',''),(205,'amount','Amount','','','','','','','','','','','','','','','','','','','',''),(206,'dr','Dr','','','','','','','','','','','','','','','','','','','',''),(207,'cr','Cr','','','','','','','','','','','','','','','','','','','',''),(208,'ref','Ref','','','','','','','','','','','','','','','','','','','',''),(209,'attachment','Attachment','','','','','','','','','','','','','','','','','','','',''),(210,'login','Login','','','','','','','','','','','','','','','','','','','',''),(211,'welcome_to','Welcome To','','','','','','','','','','','','','','','','','','','',''),(212,'username','Username','','','','','','','','','','','','','','','','','','','',''),(213,'password','Password','','','','','','','','','','','','','','','','','','','',''),(214,'remember','Remember','','','','','','','','','','','','','','','','','','','',''),(215,'lose_your_password','Lose Your Password','','','','','','','','','','','','','','','','','','','',''),(216,'position','Position','','','','','','','','','','','','','','','','','','','',''),(217,'publish','Publish','','','','','','','','','','','','','','','','','','','',''),(218,'target_new_window','Target New Window','','','','','','','','','','','','','','','','','','','',''),(219,'external_url','External Url','','','','','','','','','','','','','','','','','','','',''),(220,'external_link','External Link','','','','','','','','','','','','','','','','','','','',''),(221,'successfully','Successfully','','','','','','','','','','','','','','','','','','','',''),(222,'access_denied','Access Denied','','','','','','','','','','','','','','','','','','','',''),(223,'username_has_already_been_used','Username Has Already Been Used','','','','','','','','','','','','','','','','','','','',''),(224,'week_day','Week Day','','','','','','','','','','','','','','','','','','','',''),(225,'time_start','Time Start','','','','','','','','','','','','','','','','','','','',''),(226,'time_end','Time End','','','','','','','','','','','','','','','','','','','',''),(227,'per_patient_duration','Per Patient Duration','','','','','','','','','','','','','','','','','','','',''),(228,'make_closed','Make Closed','','','','','','','','','','','','','','','','','','','',''),(229,'the_consultation_completed','The Consultation Completed','','','','','','','','','','','','','','','','','','','',''),(230,'done','Done','','','','','','','','','','','','','','','','','','','',''),(231,'the_consultation_has_been_closed','The Consultation Has Been Closed','','','','','','','','','','','','','','','','','','','',''),(232,'requested','Requested','','','','','','','','','','','','','','','','','','','',''),(233,'create_at','Create At','','','','','','','','','','','','','','','','','','','',''),(234,'canceled','Canceled','','','','','','','','','','','','','','','','','','','',''),(235,'apply','Apply','','','','','','','','','','','','','','','','','','','',''),(236,'close','Close','','','','','','','','','','','','','','','','','','','',''),(237,'information_has_been_updated_successfully','Information Has Been Updated Successfully','','','','','','','','','','','','','','','','','','','',''),(238,'birthday','Birthday','','','','','','','','','','','','','','','','','','','',''),(239,'joining_date','Joining Date','','','','','','','','','','','','','','','','','','','',''),(240,'basic_details','Basic Details','','','','','','','','','','','','','','','','','','','',''),(241,'gender','Gender','','','','','','','','','','','','','','','','','','','',''),(242,'male','Male','','','','','','','','','','','','','','','','','','','',''),(243,'female','Female','','','','','','','','','','','','','','','','','','','',''),(244,'religion','Religion','','','','','','','','','','','','','','','','','','','',''),(245,'blood_group','Blood Group','','','','','','','','','','','','','','','','','','','',''),(246,'marital_status','Marital Status','','','','','','','','','','','','','','','','','','','',''),(247,'single','Single','','','','','','','','','','','','','','','','','','','',''),(248,'married','Married','','','','','','','','','','','','','','','','','','','',''),(249,'profile_picture','Profile Picture','','','','','','','','','','','','','','','','','','','',''),(250,'login_details','Login Details','','','','','','','','','','','','','','','','','','','',''),(251,'office_details','Office Details','','','','','','','','','','','','','','','','','','','',''),(252,'qualification','Qualification','','','','','','','','','','','','','','','','','','','',''),(253,'social_links','Social Links','','','','','','','','','','','','','','','','','','','',''),(254,'update','Update','','','','','','','','','','','','','','','','','','','',''),(255,'patient_id','Patient Id','','','','','','','','','','','','','','','','','','','',''),(256,'guardian','Guardian','','','','','','','','','','','','','','','','','','','',''),(257,'authentication','Authentication','','','','','','','','','','','','','','','','','','','',''),(258,'basic','Basic','','','','','','','','','','','','','','','','','','','',''),(259,'age','Age','','','','','','','','','','','','','','','','','','','',''),(260,'blood_pressure','Blood Pressure','','','','','','','','','','','','','','','','','','','',''),(261,'height','Height','','','','','','','','','','','','','','','','','','','',''),(262,'weight','Weight','','','','','','','','','','','','','','','','','','','',''),(263,'emergency_contact','Emergency Contact','','','','','','','','','','','','','','','','','','','',''),(264,'relationship','Relationship','','','','','','','','','','','','','','','','','','','',''),(265,'history','History','','','','','','','','','','','','','','','','','','','',''),(266,'completed','Completed','','','','','','','','','','','','','','','','','','','',''),(267,'undelivered','Undelivered','','','','','','','','','','','','','','','','','','','',''),(268,'login_authentication_deactivate','Login Authentication Deactivate','','','','','','','','','','','','','','','','','','','',''),(269,'deactivate_account','Deactivate Account','','','','','','','','','','','','','','','','','','','',''),(270,'authentication_activate','Authentication Activate','','','','','','','','','','','','','','','','','','','',''),(271,'referred_by','Referred By','','','','','','','','','','','','','','','','','','','',''),(272,'time','Time','','','','','','','','','','','','','','','','','','','',''),(273,'price','Price','','','','','','','','','','','','','','','','','','','',''),(274,'add_rows','Add Rows','','','','','','','','','','','','','','','','','','','',''),(275,'sub_total','Sub Total','','','','','','','','','','','','','','','','','','','',''),(276,'tax','Tax','','','','','','','','','','','','','','','','','','','',''),(277,'received','Received','','','','','','','','','','','','','','','','','','','',''),(278,'enter_payment_amount','Enter Payment Amount','','','','','','','','','','','','','','','','','','','',''),(279,'write_your_remarks','Write Your Remarks','','','','','','','','','','','','','','','','','','','',''),(280,'roles','Roles','','','','','','','','','','','','','','','','','','','',''),(281,'system_role','System Role','','','','','','','','','','','','','','','','','','','',''),(282,'yes','Yes','','','','','','','','','','','','','','','','','','','',''),(283,'role_permission_for','Role Permission For','','','','','','','','','','','','','','','','','','','',''),(284,'feature','Feature','','','','','','','','','','','','','','','','','','','',''),(285,'view','View','','','','','','','','','','','','','','','','','','','',''),(286,'delete','Delete','','','','','','','','','','','','','','','','','','','',''),(287,'ordered','Ordered','','','','','','','','','','','','','','','','','','','',''),(288,'quantity','Quantity','','','','','','','','','','','','','','','','','','','',''),(289,'net_total','Net Total','','','','','','','','','','','','','','','','','','','',''),(290,'bill_view','Bill View','','','','','','','','','','','','','','','','','','','',''),(291,'add_payment','Add Payment','','','','','','','','','','','','','','','','','','','',''),(292,'to','To','','','','','','','','','','','','','','','','','','','',''),(293,'company','Company','','','','','','','','','','','','','','','','','','','',''),(294,'sub','Sub','','','','','','','','','','','','','','','','','','','',''),(295,'paid_amount','Paid Amount','','','','','','','','','','','','','','','','','','','',''),(296,'prepared_by','Prepared By','','','','','','','','','','','','','','','','','','','',''),(297,'authorised_by','Authorised By','','','','','','','','','','','','','','','','','','','',''),(298,'print','Print','','','','','','','','','','','','','','','','','','','',''),(299,'paid_on','Paid On','','','','','','','','','','','','','','','','','','','',''),(300,'attach_document','Attach Document','','','','','','','','','','','','','','','','','','','',''),(301,'the_configuration_has_been_updated','The Configuration Has Been Updated','','','','','','','','','','','','','','','','','','','',''),(302,'retype_password','Retype Password','','','','','','','','','','','','','','','','','','','',''),(303,'contact_number','Contact Number','','','','','','','','','','','','','','','','','','','',''),(304,'company_name','Company Name','','','','','','','','','','','','','','','','','','','',''),(305,'product','Product','','','','','','','','','','','','','','','','','','','',''),(306,'stock_by','Stock By','','','','','','','','','','','','','','','','','','','',''),(307,'inovice_no','Inovice No','','','','','','','','','','','','','','','','','','','',''),(308,'sales_unit','Sales Unit','','','','','','','','','','','','','','','','','','','',''),(309,'for','For','','','','','','','','','','','','','','','','','','','',''),(310,'select_multiple_chemical','Select Multiple Chemical','','','','','','','','','','','','','','','','','','','',''),(311,'payment_history','Payment History','','','','','','','','','','','','','','','','','','','',''),(312,'sex','Sex','','','','','','','','','','','','','','','','','','','',''),(313,'from','From','','','','','','','','','','','','','','','','','','','',''),(314,'net_payable','Net Payable','','','','','','','','','','','','','','','','','','','',''),(315,'collect_by','Collect By','','','','','','','','','','','','','','','','','','','',''),(316,'unpublished_on_website','Unpublished On Website','','','','','','','','','','','','','','','','','','','',''),(317,'published_on_website','Published On Website','','','','','','','','','','','','','','','','','','','',''),(318,'grade','Grade','','','','','','','','','','','','','','','','','','','',''),(319,'overtime','Overtime','','','','','','','','','','','','','','','','','','','',''),(320,'allowances','Allowances','','','','','','','','','','','','','','','','','','','',''),(321,'name_of_allowance','Name Of Allowance','','','','','','','','','','','','','','','','','','','',''),(322,'deductions','Deductions','','','','','','','','','','','','','','','','','','','',''),(323,'name_of_deductions','Name Of Deductions','','','','','','','','','','','','','','','','','','','',''),(324,'allowance','Allowance','','','','','','','','','','','','','','','','','','','',''),(325,'deduction','Deduction','','','','','','','','','','','','','','','','','','','',''),(326,'salary_details','Salary Details','','','','','','','','','','','','','','','','','','','',''),(327,'no_information_available','No Information Available','','','','','','','','','','','','','','','','','','','',''),(328,'transactions','Transactions','','','','','','','','','','','','','','','','','','','',''),(329,'sms_config','Sms Config','','','','','','','','','','','','','','','','','','','',''),(330,'sms_template','Sms Template','','','','','','','','','','','','','','','','','','','',''),(331,'select_a_sms_service','Select A Sms Service','','','','','','','','','','','','','','','','','','','',''),(332,'disabled','Disabled','','','','','','','','','','','','','','','','','','','',''),(333,'clickatell_username','Clickatell Username','','','','','','','','','','','','','','','','','','','',''),(334,'clickatell_password','Clickatell Password','','','','','','','','','','','','','','','','','','','',''),(335,'clickatell_api_key','Clickatell Api Key','','','','','','','','','','','','','','','','','','','',''),(336,'registered_number','Registered Number','','','','','','','','','','','','','','','','','','','',''),(337,'account_sid','Account Sid','','','','','','','','','','','','','','','','','','','',''),(338,'auth_token','Auth Token','','','','','','','','','','','','','','','','','','','',''),(339,'account_registered','Account Registered','','','','','','','','','','','','','','','','','','','',''),(340,'notify_enable','Notify Enable','','','','','','','','','','','','','','','','','','','',''),(341,'body','Body','','','','','','','','','','','','','','','','','','','',''),(342,'appointment_confirmation','Appointment Confirmation','','','','','','','','','','','','','','','','','','','',''),(343,'appointment_canceled','Appointment Canceled','','','','','','','','','','','','','','','','','','','',''),(344,'appointment_request','Appointment Request','','','','','','','','','','','','','','','','','','','',''),(345,'reporting','Reporting','','','','','','','','','','','','','','','','','','','',''),(346,'button_text_1','Button Text 1','','','','','','','','','','','','','','','','','','','',''),(347,'button_url_1','Button Url 1','','','','','','','','','','','','','','','','','','','',''),(348,'button_text_2','Button Text 2','','','','','','','','','','','','','','','','','','','',''),(349,'button_url_2','Button Url 2','','','','','','','','','','','','','','','','','','','',''),(350,'left','Left','','','','','','','','','','','','','','','','','','','',''),(351,'center','Center','','','','','','','','','','','','','','','','','','','',''),(352,'right','Right','','','','','','','','','','','','','','','','','','','',''),(353,'icon','Icon','','','','','','','','','','','','','','','','','','','',''),(354,'surname','Surname','','','','','','','','','','','','','','','','','','','',''),(355,'rank','Rank','','','','','','','','','','','','','','','','','','','',''),(356,'staff','Staff','','','','','','','','','','','','','','','','','','','',''),(357,'paid_by','Paid By','','','','','','','','','','','','','','','','','','','',''),(358,'user','User','','','','','','','','','','','','','','','','','','','',''),(359,'payslip','Payslip','','','','','','','','','','','','','','','','','','','',''),(360,'add_employee','Add Employee','','','','','','','','','','','','','','','','','','','',''),(361,'bank_details','Bank Details','','','','','','','','','','','','','','','','','','','',''),(362,'skipped_bank_details','Skipped Bank Details','','','','','','','','','','','','','','','','','','','',''),(363,'bank_name','Bank Name','','','','','','','','','','','','','','','','','','','',''),(364,'holder_name','Holder Name','','','','','','','','','','','','','','','','','','','',''),(365,'bank','Bank','','','','','','','','','','','','','','','','','','','',''),(366,'branch','Branch','','','','','','','','','','','','','','','','','','','',''),(367,'ifsc_code','Ifsc Code','','','','','','','','','','','','','','','','','','','',''),(368,'account_no','Account No','','','','','','','','','','','','','','','','','','','',''),(369,'restore','Restore','','','','','','','','','','','','','','','','','','','',''),(370,'create_backup','Create Backup','','','','','','','','','','','','','','','','','','','',''),(371,'file','File','','','','','','','','','','','','','','','','','','','',''),(372,'backup_size','Backup Size','','','','','','','','','','','','','','','','','','','',''),(373,'file_upload','File Upload','','','','','','','','','','','','','','','','','','','',''),(374,'flag','Flag','','','','','','','','','','','','','','','','','','','',''),(375,'stats','Stats','','','','','','','','','','','','','','','','','','','',''),(376,'created_at','Created At','','','','','','','','','','','','','','','','','','','',''),(377,'updated_at','Updated At','','','','','','','','','','','','','','','','','','','',''),(378,'edit_word','Edit Word','','','','','','','','','','','','','','','','','','','',''),(379,'flag_icon','Flag Icon','','','','','','','','','','','','','','','','','','','',''),(380,'language_unpublished','Language Unpublished','','','','','','','','','','','','','','','','','','','',''),(381,'language_published','Language Published','','','','','','','','','','','','','','','','','','','',''),(382,'transaction','Transaction','','','','','','','','','','','','','','','','','','','',''),(383,'month_of_salary','Month Of Salary','','','','','','','','','','','','','','','','','','','',''),(384,'basic_salary','Basic Salary','','','','','','','','','','','','','','','','','','','',''),(385,'payment_type','Payment Type','','','','','','','','','','','','','','','','','','','',''),(386,'bank_account','Bank Account','','','','','','','','','','','','','','','','','','','',''),(387,'actions','Actions','','','','','','','','','','','','','','','','','','','',''),(388,'document','Document','','','','','','','','','','','','','','','','','','','',''),(389,'download','Download','','','','','','','','','','','','','','','','','','','',''),(390,'opening_balance','Opening Balance','','','','','','','','','','','','','','','','','','','',''),(391,'total_dr','Total Dr','','','','','','','','','','','','','','','','','','','',''),(392,'total_cr','Total Cr','','','','','','','','','','','','','','','','','','','',''),(393,'contact','Contact','','','','','','','','','','','','','','','','','','','',''),(394,'box_title','Box Title','','','','','','','','','','','','','','','','','','','',''),(395,'box_description','Box Description','','','','','','','','','','','','','','','','','','','',''),(396,'box_photo','Box Photo','','','','','','','','','','','','','','','','','','','',''),(397,'form_title','Form Title','','','','','','','','','','','','','','','','','','','',''),(398,'phone','Phone','','','','','','','','','','','','','','','','','','','',''),(399,'submit_button_text','Submit Button Text','','','','','','','','','','','','','','','','','','','',''),(400,'map_iframe','Map Iframe','','','','','','','','','','','','','','','','','','','',''),(401,'system_name','System Name','','','','','','','','','','','','','','','','','','','',''),(402,'month','Month','','','','','','','','','','','','','','','','','','','',''),(403,'patient_price','Patient Price','','','','','','','','','','','','','','','','','','','',''),(404,'production_cost','Production Cost','','','','','','','','','','','','','','','','','','','',''),(405,'created_by','Created By','','','','','','','','','','','','','','','','','','','',''),(406,'test_category','Test Category','','','','','','','','','','','','','','','','','','','',''),(407,'test_name','Test Name','','','','','','','','','','','','','','','','','','','',''),(408,'test_code','Test Code','','','','','','','','','','','','','','','','','','','',''),(409,'staff_name','Staff Name','','','','','','','','','','','','','','','','','','','',''),(410,'percentage','Percentage','','','','','','','','','','','','','','','','','','','',''),(411,'salary_assign','Salary Assign','','','','','','','','','','','','','','','','','','','',''),(412,'pay_now','Pay Now','','','','','','','','','','','','','','','','','','','',''),(413,'overtime_total_hour','Overtime Total Hour','','','','','','','','','','','','','','','','','','','',''),(414,'overtime_amount','Overtime Amount','','','','','','','','','','','','','','','','','','','',''),(415,'leave_category','Leave Category','','','','','','','','','','','','','','','','','','','',''),(416,'days','Days','','','','','','','','','','','','','','','','','','','',''),(417,'leave','Leave','','','','','','','','','','','','','','','','','','','',''),(418,'date_of_start','Date Of Start','','','','','','','','','','','','','','','','','','','',''),(419,'date_of_end','Date Of End','','','','','','','','','','','','','','','','','','','',''),(420,'leave_type','Leave Type','','','','','','','','','','','','','','','','','','','',''),(421,'reason','Reason','','','','','','','','','','','','','','','','','','','',''),(422,'comments','Comments','','','','','','','','','','','','','','','','','','','',''),(423,'accepted','Accepted','','','','','','','','','','','','','','','','','','','',''),(424,'start_date','Start Date','','','','','','','','','','','','','','','','','','','',''),(425,'end_date','End Date','','','','','','','','','','','','','','','','','','','',''),(426,'approved','Approved','','','','','','','','','','','','','','','','','','','',''),(427,'reject','Reject','','','','','','','','','','','','','','','','','','','',''),(428,'select_all','Select All','','','','','','','','','','','','','','','','','','','',''),(429,'not_selected','Not Selected','','','','','','','','','','','','','','','','','','','',''),(430,'present','Present','','','','','','','','','','','','','','','','','','','',''),(431,'absent','Absent','','','','','','','','','','','','','','','','','','','',''),(432,'holiday','Holiday','','','','','','','','','','','','','','','','','','','',''),(433,'late','Late','','','','','','','','','','','','','','','','','','','',''),(434,'current_balance','Current Balance','','','','','','','','','','','','','','','','','','','',''),(435,'no','No','','','','','','','','','','','','','','','','','','','',''),(436,'current','Current','','','','','','','','','','','','','','','','','','','',''),(437,'qty','Qty','','','','','','','','','','','','','','','','','','','',''),(438,'payment_successfull','Payment Successfull','','','','','','','','','','','','','','','','','','','',''),(439,'payment_by','Payment By','','','','','','','','','','','','','','','','','','','',''),(440,'chemical_wise_stock','Chemical Wise Stock','','','','','','','','','','','','','','','','','','','',''),(441,'sale','Sale','','','','','','','','','','','','','','','','','','','',''),(442,'in_qty','In Qty','','','','','','','','','','','','','','','','','','','',''),(443,'out_qty','Out Qty','','','','','','','','','','','','','','','','','','','',''),(444,'sale_profit','Sale Profit','','','','','','','','','','','','','','','','','','','',''),(445,'paid_via','Paid Via','','','','','','','','','','','','','','','','','','','',''),(446,'collected_by','Collected By','','','','','','','','','','','','','','','','','','','',''),(447,'all','All','','','','','','','','','','','','','','','','','','','',''),(448,'add_short_bio','Add Short Bio','','','','','','','','','','','','','','','','','','','',''),(449,'email_config','Email Config','','','','','','','','','','','','','','','','','','','',''),(450,'email_triggers','Email Triggers','','','','','','','','','','','','','','','','','','','',''),(451,'system_email','System Email','','','','','','','','','','','','','','','','','','','',''),(452,'subject','Subject','','','','','','','','','','','','','','','','','','','',''),(453,'forgot_password','Forgot Password','','','','','','','','','','','','','','','','','','','',''),(454,'payslip_generated','Payslip Generated','','','','','','','','','','','','','','','','','','','',''),(455,'leave_approve','Leave Approve','','','','','','','','','','','','','','','','','','','',''),(456,'leave_reject','Leave Reject','','','','','','','','','','','','','','','','','','','','');
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leave_application`
--

DROP TABLE IF EXISTS `leave_application`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leave_application` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `category_id` varchar(20) NOT NULL,
  `reason` text CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `leave_days` varchar(20) NOT NULL DEFAULT '0',
  `status` varchar(10) NOT NULL DEFAULT '1',
  `apply_date` datetime NOT NULL,
  `orig_file_name` varchar(255) NOT NULL,
  `enc_file_name` varchar(255) NOT NULL,
  `approved_by` longtext NOT NULL,
  `comments` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leave_application`
--

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

--
-- Table structure for table `leave_category`
--

DROP TABLE IF EXISTS `leave_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leave_category` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
  `days` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leave_category`
--

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

--
-- Table structure for table `login_credential`
--

DROP TABLE IF EXISTS `login_credential`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `login_credential` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(250) NOT NULL,
  `role` int(11) NOT NULL,
  `active` int(11) NOT NULL COMMENT '1(active) 0(deactivate)',
  `last_login` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `login_credential`
--

LOCK TABLES `login_credential` WRITE;
/*!40000 ALTER TABLE `login_credential` DISABLE KEYS */;
INSERT INTO `login_credential` VALUES (1,1,'superman','$2y$10$Fc88bs4Y1qcPDm8qQ9ms5ORx/PgdBQOiiJBN.tbu9rtLjwL5FKUaa',1,1,'2023-07-07 01:57:25','2023-06-27 17:28:08','2023-07-06 19:57:25');
/*!40000 ALTER TABLE `login_credential` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `patient`
--

DROP TABLE IF EXISTS `patient`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `patient` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `patient_id` varchar(10) NOT NULL,
  `category_id` int(11) NOT NULL,
  `birthday` date NOT NULL,
  `sex` varchar(10) NOT NULL,
  `blood_group` varchar(10) NOT NULL,
  `blood_pressure` varchar(100) NOT NULL,
  `height` varchar(10) NOT NULL,
  `weight` varchar(10) NOT NULL,
  `marital_status` varchar(10) NOT NULL,
  `age` varchar(10) DEFAULT NULL,
  `address` text NOT NULL,
  `mobileno` varchar(30) NOT NULL,
  `email` varchar(200) NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `guardian` varchar(200) NOT NULL,
  `relationship` varchar(200) NOT NULL,
  `gua_mobileno` varchar(30) NOT NULL,
  `source` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `patient`
--

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

--
-- Table structure for table `patient_category`
--

DROP TABLE IF EXISTS `patient_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `patient_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `patient_category`
--

LOCK TABLES `patient_category` WRITE;
/*!40000 ALTER TABLE `patient_category` DISABLE KEYS */;
INSERT INTO `patient_category` VALUES (1,'Test');
/*!40000 ALTER TABLE `patient_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `patient_documents`
--

DROP TABLE IF EXISTS `patient_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `patient_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(100) NOT NULL,
  `remarks` text NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `enc_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `patient_documents`
--

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

--
-- Table structure for table `payment_type`
--

DROP TABLE IF EXISTS `payment_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_type`
--

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

--
-- Table structure for table `payout_commission`
--

DROP TABLE IF EXISTS `payout_commission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payout_commission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `bill_no` varchar(11) NOT NULL,
  `before_payout` decimal(18,2) NOT NULL DEFAULT 0.00,
  `amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `pay_via` int(11) NOT NULL,
  `remarks` text DEFAULT NULL,
  `paid_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payout_commission`
--

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

--
-- Table structure for table `payslip`
--

DROP TABLE IF EXISTS `payslip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payslip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `month` varchar(20) DEFAULT NULL,
  `year` varchar(20) NOT NULL,
  `basic_salary` decimal(18,2) NOT NULL DEFAULT 0.00,
  `total_allowance` decimal(18,2) NOT NULL DEFAULT 0.00,
  `total_deduction` decimal(18,2) NOT NULL DEFAULT 0.00,
  `net_salary` decimal(18,2) NOT NULL DEFAULT 0.00,
  `bill_no` varchar(25) NOT NULL,
  `remarks` text NOT NULL,
  `pay_via` tinyint(1) NOT NULL,
  `hash` varchar(255) DEFAULT NULL,
  `paid_by` int(11) NOT NULL,
  `payment_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payslip`
--

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

--
-- Table structure for table `payslip_details`
--

DROP TABLE IF EXISTS `payslip_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payslip_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payslip_id` varchar(20) NOT NULL,
  `name` varchar(200) NOT NULL,
  `amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `type` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payslip_details`
--

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

--
-- Table structure for table `permission`
--

DROP TABLE IF EXISTS `permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `prefix` varchar(100) NOT NULL,
  `show_view` tinyint(2) DEFAULT 1,
  `show_add` tinyint(2) DEFAULT 1,
  `show_edit` tinyint(2) DEFAULT 1,
  `show_delete` tinyint(2) DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permission`
--

LOCK TABLES `permission` WRITE;
/*!40000 ALTER TABLE `permission` DISABLE KEYS */;
INSERT INTO `permission` VALUES (1,2,'Patient','patient',1,1,1,1,'2019-05-27 16:28:52'),(2,2,'Patient Category','patient_category',1,1,1,1,'2019-05-27 16:28:52'),(3,6,'Employee','employee',1,1,1,1,'2019-05-27 16:28:52'),(4,6,'Department','department',1,1,1,1,'2019-05-27 16:28:52'),(5,6,'Designation','designation',1,1,1,1,'2019-05-27 16:28:52'),(6,6,'Login Deactivate','employee_disable_authentication',1,0,1,0,'2019-05-27 23:56:59'),(7,7,'Salary Template','salary_template',1,1,1,1,'2019-05-27 17:09:28'),(8,7,'Salary Assign','salary_assign',1,1,0,0,'2019-05-27 17:09:34'),(9,8,'Lab Test','lab_test',1,1,1,1,'2019-05-27 16:28:52'),(10,8,'Test Category','test_category',1,1,1,1,'2019-05-27 16:28:53'),(11,12,'Test Report','test_report',1,1,1,0,'2019-05-27 16:28:53'),(12,12,'Test Report Template','test_report_template',1,1,1,1,'2019-05-27 16:28:53'),(13,11,'Lab Test Bill','lab_test_bill',1,1,0,1,'2019-05-27 23:12:14'),(14,11,'Test Bill Report','test_bill_report',1,0,0,0,'2019-05-27 23:12:28'),(15,11,'Test Bill Payment','test_bill_payment',1,1,0,0,'2019-05-27 23:12:28'),(16,9,'Referral Assign','referral_assign',1,1,1,1,'2019-05-27 23:34:50'),(17,9,'Commission Withdrawal','commission_withdrawal',1,1,0,1,'2019-05-27 23:34:59'),(18,9,'Referral Reports','referral_reports',1,0,0,0,'2019-05-27 23:35:02'),(19,2,'Login Deactivate','patient_disable_authentication',1,0,1,0,'2019-05-27 16:28:52'),(20,3,'Purchase Payment','purchase_payment',1,1,0,0,'2019-05-28 01:02:18'),(21,13,'Global Setting','global_setting',1,1,0,0,'2019-05-28 02:28:04'),(22,13,'Email Setting','email_setting',1,1,0,0,'2019-05-29 12:42:40'),(23,13,'Language','language',1,1,1,1,'2019-05-29 01:10:08'),(24,13,'Database Backup','database_backup',1,1,0,1,'2019-05-28 12:54:40'),(25,13,'Database Restore','database_restore',0,1,0,0,'2019-05-28 13:07:49'),(26,7,'Salary Payment','salary_payment',1,1,0,0,'2019-05-30 14:27:03'),(27,7,'Salary Summary Report','salary_summary_report',1,0,0,0,'2019-05-31 19:46:17'),(28,7,'Leave Category','leave_category',1,1,1,1,'2019-06-02 01:12:59'),(29,7,'My Leave','my_leave',1,1,0,1,'2019-06-03 21:01:42'),(30,7,'Leave Manage','leave_manage',1,1,0,1,'2019-06-04 14:40:20'),(31,7,'Staff Attendance','staff_attendance',1,1,0,0,'2019-06-05 01:53:37'),(32,10,'Account','account',1,1,1,1,'2019-06-07 16:58:38'),(33,10,'Voucher','voucher',1,1,1,1,'2019-06-09 01:17:14'),(34,10,'Voucher Head','voucher_head',1,1,1,1,'2019-06-08 19:00:33'),(35,10,'Accounting Reports','accounting_reports',1,0,0,0,'2019-06-09 20:56:59'),(36,4,'Schedule','schedule',1,1,1,1,'2019-06-13 05:47:17'),(37,5,'Appointment','appointment',1,1,1,1,'2019-06-13 05:56:41'),(38,5,'Appointment Request','appointment_request',1,0,1,1,'2019-06-14 16:21:02'),(39,1,'Today Invoice Widget','today_invoice_widget',1,0,0,0,'2019-06-17 00:02:40'),(40,1,'Today Commission Widget','today_commission_widget',1,0,0,0,'2019-06-17 00:02:40'),(41,1,'Today Income Widget','today_income_widget',1,0,0,0,'2019-06-17 00:02:40'),(42,1,'Today Expense Widget','today_expense_widget',1,0,0,0,'2019-06-17 00:02:40'),(43,1,'Annual Income Vs Expense Chart','annual_income_vs_expense_chart',1,0,0,0,'2019-06-17 00:27:47'),(44,1,'Patient Count Widget','patient_count_widget',1,0,0,0,'2019-06-17 00:38:33'),(45,1,'Doctor Count Widget','doctor_count_widget',1,0,0,0,'2019-06-17 00:38:33'),(46,1,'Employee Count Widget','employee_count_widget',1,0,0,0,'2019-06-17 00:38:33'),(47,1,'Appointment Count Widget','appointment_count_widget',1,0,0,0,'2019-06-17 00:38:33'),(48,1,'Pathology Fees Summary Chart','pathology_fees_summary_chart',1,0,0,0,'2019-06-17 00:48:28'),(49,14,'Frontend Setting','frontend_setting',1,1,0,0,'2019-09-11 03:24:07'),(50,14,'Frontend Menu','frontend_menu',1,1,1,1,'2019-09-11 04:03:39'),(51,14,'Frontend Section','frontend_section',1,1,0,0,'2019-09-11 04:26:11'),(52,14,'Manage Page','manage_page',1,1,1,1,'2019-09-11 05:54:08'),(53,14,'Frontend Slider','frontend_slider',1,1,1,1,'2019-09-11 06:12:31'),(54,14,'Frontend Features','frontend_features',1,1,1,1,'2019-09-11 06:47:51'),(55,14,'Frontend Testimonial','frontend_testimonial',1,1,1,1,'2019-09-11 06:54:30'),(56,14,'Frontend Services','frontend_services',1,1,1,1,'2019-09-11 07:01:44'),(57,14,'Frontend Faq','frontend_faq',1,1,1,1,'2019-09-11 07:06:16'),(58,13,'Sms Setting','sms_setting',1,1,0,0,'2019-09-13 11:41:37'),(59,14,'Doctor Short Bio','doctor_short_bio',0,1,0,0,'2019-09-17 20:13:12'),(60,1,'Appointment Status Chart','appointment_status_chart',1,0,0,0,'2019-06-17 00:48:28'),(61,9,'My Commission','my_commission',1,0,0,0,'2019-06-17 00:48:28');
/*!40000 ALTER TABLE `permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permission_modules`
--

DROP TABLE IF EXISTS `permission_modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permission_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `prefix` varchar(50) NOT NULL,
  `system` tinyint(1) NOT NULL,
  `sorted` tinyint(10) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permission_modules`
--

LOCK TABLES `permission_modules` WRITE;
/*!40000 ALTER TABLE `permission_modules` DISABLE KEYS */;
INSERT INTO `permission_modules` VALUES (1,'Dashboard','dashboard',1,1,'2019-05-27 04:23:00'),(2,'Patient Details','patient_details',1,3,'2019-05-27 04:23:00'),(4,'Schedule','schedule',1,5,'2019-05-27 04:23:00'),(5,'Appointment','appointment',1,6,'2019-05-27 04:23:00'),(6,'Employee','employee',1,7,'2019-05-27 04:23:00'),(7,'Human Resources','human_resources',1,8,'2019-05-27 04:23:00'),(8,'Pathology','test_manager',1,9,'2019-05-27 04:23:00'),(9,'Refer Manager','refer_manager',1,10,'2019-05-27 04:23:00'),(10,'Office Accounting','office_accounting',1,11,'2019-05-27 04:23:00'),(11,'Pathology Billing','billing',1,12,'2019-05-27 04:23:00'),(12,'Investigation Report','investigation_report',1,13,'2019-05-27 04:23:00'),(13,'Settings','settings',1,14,'2019-05-27 04:23:00'),(14,'Website','website',1,2,'2019-05-27 04:23:00');
/*!40000 ALTER TABLE `permission_modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchase_bill`
--

DROP TABLE IF EXISTS `purchase_bill`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purchase_bill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bill_no` varchar(200) NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `remarks` text NOT NULL,
  `total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `paid` decimal(18,2) NOT NULL DEFAULT 0.00,
  `due` decimal(18,2) NOT NULL DEFAULT 0.00,
  `payment_status` int(11) NOT NULL,
  `purchase_status` int(11) NOT NULL,
  `hash` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `prepared_by` int(11) DEFAULT NULL,
  `modifier_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_bill`
--

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

--
-- Table structure for table `purchase_bill_details`
--

DROP TABLE IF EXISTS `purchase_bill_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purchase_bill_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_bill_id` int(11) NOT NULL,
  `chemical_id` varchar(20) NOT NULL,
  `unit_price` decimal(18,2) NOT NULL DEFAULT 0.00,
  `quantity` varchar(20) NOT NULL,
  `discount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `sub_total` decimal(18,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_bill_details`
--

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

--
-- Table structure for table `purchase_payment_history`
--

DROP TABLE IF EXISTS `purchase_payment_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purchase_payment_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_bill_id` varchar(11) NOT NULL,
  `payment_by` int(11) DEFAULT NULL,
  `amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `pay_via` varchar(25) NOT NULL,
  `remarks` text NOT NULL,
  `attach_orig_name` varchar(255) DEFAULT NULL,
  `attach_file_name` varchar(255) DEFAULT NULL,
  `paid_on` date DEFAULT NULL,
  `coll_type` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_payment_history`
--

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

--
-- Table structure for table `referral_commission`
--

DROP TABLE IF EXISTS `referral_commission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `referral_commission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `test_id` int(11) NOT NULL,
  `percentage` varchar(10) NOT NULL,
  `assign_by` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `referral_commission`
--

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

--
-- Table structure for table `reset_password`
--

DROP TABLE IF EXISTS `reset_password`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reset_password` (
  `key` longtext NOT NULL,
  `username` varchar(100) NOT NULL,
  `login_credential_id` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reset_password`
--

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

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `is_system` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'Super Admin','superadmin','1'),(2,'Admin','admin','1'),(3,'Doctor','doctor','1'),(4,'Accountant','accountant','1'),(5,'Laboratorist','laboratorist','1'),(6,'Receptionist','receptionist','1'),(7,'Patient','patient','1');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salary_template`
--

DROP TABLE IF EXISTS `salary_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salary_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `basic_salary` decimal(18,2) NOT NULL DEFAULT 0.00,
  `overtime_salary` varchar(100) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salary_template`
--

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

--
-- Table structure for table `salary_template_details`
--

DROP TABLE IF EXISTS `salary_template_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salary_template_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `salary_template_id` varchar(20) NOT NULL,
  `name` varchar(200) NOT NULL,
  `amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `type` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salary_template_details`
--

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

--
-- Table structure for table `schedule`
--

DROP TABLE IF EXISTS `schedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` varchar(100) NOT NULL,
  `doctor_id` varchar(11) NOT NULL,
  `time_start` time NOT NULL,
  `time_end` time NOT NULL,
  `per_patient_time` varchar(50) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `consultation_fees` decimal(18,2) DEFAULT 0.00,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `schedule`
--

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

--
-- Table structure for table `sms_config`
--

DROP TABLE IF EXISTS `sms_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sms_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clickatell_username` varchar(255) NOT NULL,
  `clickatell_password` varchar(255) NOT NULL,
  `clickatell_api_key` varchar(255) NOT NULL,
  `clickatell_number` varchar(255) NOT NULL,
  `twilio_account_sid` varchar(255) NOT NULL,
  `twilio_auth_token` varchar(255) NOT NULL,
  `twilio_number` varchar(255) NOT NULL,
  `active_gateway` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms_config`
--

LOCK TABLES `sms_config` WRITE;
/*!40000 ALTER TABLE `sms_config` DISABLE KEYS */;
INSERT INTO `sms_config` VALUES (1,'','','','','','','','disabled');
/*!40000 ALTER TABLE `sms_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sms_templates`
--

DROP TABLE IF EXISTS `sms_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sms_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sms_type` varchar(200) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `template_body` longtext NOT NULL,
  `tags` longtext NOT NULL,
  `notified` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms_templates`
--

LOCK TABLES `sms_templates` WRITE;
/*!40000 ALTER TABLE `sms_templates` DISABLE KEYS */;
INSERT INTO `sms_templates` VALUES (1,'account_registered','','','{institute_name}, {name}, {username}, {password}, {user_role}, {login_url}',0),(2,'appointment_confirmation','','','{institute_name}, {patient_name}, {doctor_name}, {appointment_id}, {schedule_time}, {appointment_date}',0),(3,'appointment_canceled','','','{institute_name}, {patient_name}, {doctor_name}, {appointment_id}, {schedule_time}, {appointment_date}',0),(4,'appointment_request','','','{institute_name}, {patient_name}, {doctor_name}, {appointment_id}, {schedule_time}, {appointment_date}',0);
/*!40000 ALTER TABLE `sms_templates` 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 = utf8 */;
CREATE TABLE `staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `department` int(11) NOT NULL,
  `qualification` varchar(200) NOT NULL,
  `designation` int(11) NOT NULL,
  `joining_date` date NOT NULL,
  `birthday` date NOT NULL,
  `gender` varchar(12) NOT NULL,
  `religion` varchar(200) NOT NULL,
  `blood_group` varchar(11) NOT NULL,
  `marital_status` varchar(10) NOT NULL,
  `address` mediumtext NOT NULL,
  `state` varchar(255) NOT NULL,
  `city` varchar(200) NOT NULL,
  `mobileno` varchar(30) NOT NULL,
  `email` varchar(255) NOT NULL,
  `salary_template_id` int(11) DEFAULT 0,
  `photo` varchar(255) DEFAULT NULL,
  `nid` varchar(200) NOT NULL,
  `facebook_url` varchar(255) NOT NULL,
  `linkedin_url` varchar(255) NOT NULL,
  `twitter_url` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_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 (1,'b195808','Super Admin',0,'',0,'2023-06-27','0000-00-00','','','','','','','','','super@admin.com',0,NULL,'','','','','2023-06-27 17:28:07','2023-06-27 17:28:07');
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff_attendance`
--

DROP TABLE IF EXISTS `staff_attendance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` varchar(20) NOT NULL,
  `status` varchar(2) DEFAULT NULL,
  `remark` varchar(255) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_attendance`
--

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

--
-- Table structure for table `staff_balance`
--

DROP TABLE IF EXISTS `staff_balance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_balance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_balance`
--

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

--
-- Table structure for table `staff_bank_account`
--

DROP TABLE IF EXISTS `staff_bank_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_bank_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `bank_name` varchar(200) NOT NULL,
  `holder_name` varchar(255) NOT NULL,
  `bank_branch` varchar(255) NOT NULL,
  `bank_address` varchar(255) NOT NULL,
  `ifsc_code` varchar(200) NOT NULL,
  `account_no` varchar(200) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_bank_account`
--

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

--
-- Table structure for table `staff_department`
--

DROP TABLE IF EXISTS `staff_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_department`
--

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

--
-- Table structure for table `staff_designation`
--

DROP TABLE IF EXISTS `staff_designation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_designation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_designation`
--

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

--
-- Table structure for table `staff_documents`
--

DROP TABLE IF EXISTS `staff_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category_id` varchar(20) NOT NULL,
  `remarks` text NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `enc_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_documents`
--

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

--
-- Table structure for table `staff_privileges`
--

DROP TABLE IF EXISTS `staff_privileges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff_privileges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `is_add` tinyint(1) NOT NULL,
  `is_edit` tinyint(1) NOT NULL,
  `is_view` tinyint(1) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=353 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_privileges`
--

LOCK TABLES `staff_privileges` WRITE;
/*!40000 ALTER TABLE `staff_privileges` DISABLE KEYS */;
INSERT INTO `staff_privileges` VALUES (1,2,39,0,0,1,0),(2,2,40,0,0,1,0),(3,2,41,0,0,1,0),(4,2,42,0,0,1,0),(5,2,43,0,0,1,0),(6,2,44,0,0,1,0),(7,2,45,0,0,1,0),(8,2,46,0,0,1,0),(9,2,47,0,0,1,0),(10,2,48,0,0,1,0),(11,2,49,1,0,1,0),(12,2,50,1,1,1,1),(13,2,51,1,0,1,0),(14,2,52,1,1,1,1),(15,2,53,1,1,1,1),(16,2,54,1,1,1,1),(17,2,55,1,1,1,1),(18,2,56,1,1,1,1),(19,2,57,1,1,1,1),(20,2,59,1,0,0,0),(21,2,1,1,1,1,1),(22,2,2,1,1,1,1),(23,2,19,0,1,1,0),(24,2,36,1,1,1,1),(25,2,37,1,1,1,1),(26,2,38,0,1,1,1),(27,2,3,1,1,1,1),(28,2,4,1,1,1,1),(29,2,5,1,1,1,1),(30,2,6,0,1,1,0),(31,2,7,1,1,1,1),(32,2,8,1,0,1,0),(33,2,26,1,0,1,0),(34,2,27,0,0,1,0),(35,2,28,1,1,1,1),(36,2,29,1,0,1,1),(37,2,30,1,0,1,1),(38,2,31,1,0,1,0),(39,2,9,1,1,1,1),(40,2,10,1,1,1,1),(41,2,16,1,1,1,1),(42,2,17,1,0,1,1),(43,2,18,0,0,1,0),(44,2,32,1,1,1,1),(45,2,33,1,1,1,1),(46,2,34,1,1,1,1),(47,2,35,0,0,1,0),(48,2,13,1,0,1,1),(49,2,14,0,0,1,0),(50,2,15,1,0,1,0),(51,2,11,1,1,1,0),(52,2,12,1,1,1,1),(53,2,21,1,0,1,0),(54,2,22,1,0,1,0),(55,2,23,1,1,1,1),(56,2,24,1,0,1,1),(57,2,25,1,0,0,0),(58,2,58,1,0,1,0),(59,3,39,0,0,0,0),(60,3,40,0,0,0,0),(61,3,41,0,0,0,0),(62,3,42,0,0,0,0),(63,3,43,0,0,0,0),(64,3,44,0,0,1,0),(65,3,45,0,0,1,0),(66,3,46,0,0,1,0),(67,3,47,0,0,1,0),(68,3,48,0,0,0,0),(69,3,49,0,0,0,0),(70,3,50,0,0,0,0),(71,3,51,0,0,0,0),(72,3,52,0,0,0,0),(73,3,53,0,0,0,0),(74,3,54,0,0,0,0),(75,3,55,0,0,0,0),(76,3,56,0,0,0,0),(77,3,57,0,0,0,0),(78,3,59,0,0,0,0),(79,3,1,0,0,1,0),(80,3,2,0,0,0,0),(81,3,19,0,0,0,0),(82,3,36,0,0,1,0),(83,3,37,0,0,1,0),(84,3,38,0,0,1,0),(85,3,3,0,0,1,0),(86,3,4,0,0,0,0),(87,3,5,0,0,0,0),(88,3,6,0,0,0,0),(89,3,7,0,0,0,0),(90,3,8,0,0,0,0),(91,3,26,0,0,0,0),(92,3,27,0,0,0,0),(93,3,28,0,0,0,0),(94,3,29,0,0,0,0),(95,3,30,0,0,0,0),(96,3,31,0,0,0,0),(97,3,9,0,0,0,0),(98,3,10,0,0,0,0),(99,3,16,0,0,0,0),(100,3,17,0,0,1,0),(101,3,18,0,0,0,0),(102,3,32,0,0,0,0),(103,3,33,0,0,0,0),(104,3,34,0,0,0,0),(105,3,35,0,0,0,0),(106,3,13,0,0,0,0),(107,3,14,0,0,0,0),(108,3,15,0,0,0,0),(109,3,11,0,0,0,0),(110,3,12,0,0,0,0),(111,3,21,0,0,0,0),(112,3,22,0,0,0,0),(113,3,23,0,0,0,0),(114,3,24,0,0,0,0),(115,3,25,0,0,0,0),(116,3,58,0,0,0,0),(117,4,39,0,0,1,0),(118,4,40,0,0,1,0),(119,4,41,0,0,1,0),(120,4,42,0,0,1,0),(121,4,43,0,0,1,0),(122,4,44,0,0,1,0),(123,4,45,0,0,1,0),(124,4,46,0,0,1,0),(125,4,47,0,0,0,0),(126,4,48,0,0,1,0),(127,4,49,0,0,0,0),(128,4,50,0,0,0,0),(129,4,51,0,0,0,0),(130,4,52,0,0,0,0),(131,4,53,0,0,0,0),(132,4,54,0,0,0,0),(133,4,55,0,0,0,0),(134,4,56,0,0,0,0),(135,4,57,0,0,0,0),(136,4,59,0,0,0,0),(137,4,1,1,1,1,1),(138,4,2,1,1,1,1),(139,4,19,0,0,0,0),(140,4,36,0,0,0,0),(141,4,37,0,0,0,0),(142,4,38,0,0,0,0),(143,4,3,0,0,1,0),(144,4,4,0,0,0,0),(145,4,5,0,0,0,0),(146,4,6,0,0,0,0),(147,4,7,1,1,1,1),(148,4,8,1,0,1,0),(149,4,26,1,0,1,0),(150,4,27,0,0,1,0),(151,4,28,1,1,1,1),(152,4,29,1,0,1,1),(153,4,30,1,0,1,1),(154,4,31,1,0,1,0),(155,4,9,0,0,0,0),(156,4,10,0,0,0,0),(157,4,16,0,0,0,0),(158,4,17,0,0,0,0),(159,4,18,0,0,0,0),(160,4,32,1,1,1,1),(161,4,33,1,1,1,1),(162,4,34,1,1,1,1),(163,4,35,0,0,1,0),(164,4,13,1,0,1,0),(165,4,14,0,0,1,0),(166,4,15,1,0,1,0),(167,4,11,0,0,0,0),(168,4,12,0,0,0,0),(169,4,21,0,0,0,0),(170,4,22,0,0,0,0),(171,4,23,0,0,0,0),(172,4,24,0,0,0,0),(173,4,25,0,0,0,0),(174,4,58,0,0,0,0),(175,5,39,0,0,0,0),(176,5,40,0,0,0,0),(177,5,41,0,0,0,0),(178,5,42,0,0,0,0),(179,5,43,0,0,0,0),(180,5,44,0,0,1,0),(181,5,45,0,0,1,0),(182,5,46,0,0,1,0),(183,5,47,0,0,0,0),(184,5,48,0,0,0,0),(185,5,49,0,0,0,0),(186,5,50,0,0,0,0),(187,5,51,0,0,0,0),(188,5,52,0,0,0,0),(189,5,53,0,0,0,0),(190,5,54,0,0,0,0),(191,5,55,0,0,0,0),(192,5,56,0,0,0,0),(193,5,57,0,0,0,0),(194,5,59,0,0,0,0),(195,5,1,0,0,0,0),(196,5,2,0,0,0,0),(197,5,19,0,0,0,0),(198,5,36,0,0,0,0),(199,5,37,0,0,0,0),(200,5,38,0,0,0,0),(201,5,3,0,0,0,0),(202,5,4,0,0,0,0),(203,5,5,0,0,0,0),(204,5,6,0,0,0,0),(205,5,7,0,0,0,0),(206,5,8,0,0,0,0),(207,5,26,0,0,0,0),(208,5,27,0,0,0,0),(209,5,28,0,0,0,0),(210,5,29,0,0,0,0),(211,5,30,0,0,0,0),(212,5,31,0,0,0,0),(213,5,9,0,0,0,0),(214,5,10,0,0,0,0),(215,5,16,0,0,0,0),(216,5,17,0,0,0,0),(217,5,18,0,0,0,0),(218,5,32,0,0,0,0),(219,5,33,0,0,0,0),(220,5,34,0,0,0,0),(221,5,35,0,0,0,0),(222,5,13,0,0,0,0),(223,5,14,0,0,0,0),(224,5,15,0,0,0,0),(225,5,11,1,1,1,0),(226,5,12,1,1,1,1),(227,5,21,0,0,0,0),(228,5,22,0,0,0,0),(229,5,23,0,0,0,0),(230,5,24,0,0,0,0),(231,5,25,0,0,0,0),(232,5,58,0,0,0,0),(233,6,39,0,0,1,0),(234,6,40,0,0,1,0),(235,6,41,0,0,0,0),(236,6,42,0,0,0,0),(237,6,43,0,0,0,0),(238,6,44,0,0,1,0),(239,6,45,0,0,1,0),(240,6,46,0,0,1,0),(241,6,47,0,0,0,0),(242,6,48,0,0,0,0),(243,6,49,0,0,0,0),(244,6,50,0,0,0,0),(245,6,51,0,0,0,0),(246,6,52,0,0,0,0),(247,6,53,0,0,0,0),(248,6,54,0,0,0,0),(249,6,55,0,0,0,0),(250,6,56,0,0,0,0),(251,6,57,0,0,0,0),(252,6,59,0,0,0,0),(253,6,1,1,1,1,1),(254,6,2,1,1,1,1),(255,6,19,0,0,0,0),(256,6,36,0,0,0,0),(257,6,37,0,0,0,0),(258,6,38,0,0,0,0),(259,6,3,0,0,0,0),(260,6,4,0,0,0,0),(261,6,5,0,0,0,0),(262,6,6,0,0,0,0),(263,6,7,0,0,0,0),(264,6,8,0,0,0,0),(265,6,26,0,0,0,0),(266,6,27,0,0,0,0),(267,6,28,0,0,0,0),(268,6,29,0,0,0,0),(269,6,30,0,0,0,0),(270,6,31,0,0,0,0),(271,6,9,0,0,0,0),(272,6,10,0,0,0,0),(273,6,16,0,0,0,0),(274,6,17,0,0,0,0),(275,6,18,0,0,0,0),(276,6,32,0,0,0,0),(277,6,33,0,0,0,0),(278,6,34,0,0,0,0),(279,6,35,0,0,0,0),(280,6,13,1,0,1,1),(281,6,14,0,0,1,0),(282,6,15,1,0,1,0),(283,6,11,0,0,0,0),(284,6,12,0,0,0,0),(285,6,21,0,0,0,0),(286,6,22,0,0,0,0),(287,6,23,0,0,0,0),(288,6,24,0,0,0,0),(289,6,25,0,0,0,0),(290,6,58,0,0,0,0),(291,7,39,0,0,0,0),(292,7,40,0,0,0,0),(293,7,41,0,0,0,0),(294,7,42,0,0,0,0),(295,7,43,0,0,0,0),(296,7,44,0,0,1,0),(297,7,45,0,0,1,0),(298,7,46,0,0,0,0),(299,7,47,0,0,0,0),(300,7,48,0,0,0,0),(301,7,49,0,0,0,0),(302,7,50,0,0,0,0),(303,7,51,0,0,0,0),(304,7,52,0,0,0,0),(305,7,53,0,0,0,0),(306,7,54,0,0,0,0),(307,7,55,0,0,0,0),(308,7,56,0,0,0,0),(309,7,57,0,0,0,0),(310,7,59,0,0,0,0),(311,7,1,0,0,0,0),(312,7,2,0,0,0,0),(313,7,19,0,0,0,0),(314,7,36,0,0,1,0),(315,7,37,0,0,0,0),(316,7,38,0,0,0,0),(317,7,3,0,0,0,0),(318,7,4,0,0,0,0),(319,7,5,0,0,0,0),(320,7,6,0,0,0,0),(321,7,7,0,0,0,0),(322,7,8,0,0,0,0),(323,7,26,0,0,0,0),(324,7,27,0,0,0,0),(325,7,28,0,0,0,0),(326,7,29,0,0,0,0),(327,7,30,0,0,0,0),(328,7,31,0,0,0,0),(329,7,9,0,0,1,0),(330,7,10,0,0,0,0),(331,7,16,0,0,0,0),(332,7,17,0,0,0,0),(333,7,18,0,0,0,0),(334,7,32,0,0,0,0),(335,7,33,0,0,0,0),(336,7,34,0,0,0,0),(337,7,35,0,0,0,0),(338,7,13,0,0,1,0),(339,7,14,0,0,0,0),(340,7,15,0,0,0,0),(341,7,11,0,0,1,0),(342,7,12,0,0,0,0),(343,7,21,0,0,0,0),(344,7,22,0,0,0,0),(345,7,23,0,0,0,0),(346,7,24,0,0,0,0),(347,7,25,0,0,0,0),(348,7,58,0,0,0,0),(349,2,60,0,0,1,0),(350,7,60,0,0,0,0),(351,3,60,0,0,0,0),(352,3,61,0,0,1,0);
/*!40000 ALTER TABLE `staff_privileges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `supplier`
--

DROP TABLE IF EXISTS `supplier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `supplier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `mobileno` varchar(30) NOT NULL,
  `email` varchar(100) NOT NULL,
  `company_name` varchar(200) NOT NULL,
  `product_list` mediumtext NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `supplier`
--

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

--
-- Table structure for table `theme_settings`
--

DROP TABLE IF EXISTS `theme_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `theme_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `border_mode` varchar(20) NOT NULL,
  `dark_skin` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `theme_settings`
--

LOCK TABLES `theme_settings` WRITE;
/*!40000 ALTER TABLE `theme_settings` DISABLE KEYS */;
INSERT INTO `theme_settings` VALUES (1,'true','false','2019-12-23 22:59:38','2023-06-27 18:04:14');
/*!40000 ALTER TABLE `theme_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` varchar(20) NOT NULL,
  `voucher_head_id` varchar(200) NOT NULL,
  `type` varchar(100) NOT NULL,
  `category` varchar(20) NOT NULL,
  `ref` varchar(255) NOT NULL,
  `amount` decimal(18,2) NOT NULL DEFAULT 0.00,
  `dr` decimal(18,2) NOT NULL DEFAULT 0.00,
  `cr` decimal(18,2) NOT NULL DEFAULT 0.00,
  `bal` decimal(18,2) NOT NULL DEFAULT 0.00,
  `date` date NOT NULL,
  `pay_via` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `attachments` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

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

--
-- Table structure for table `voucher_head`
--

DROP TABLE IF EXISTS `voucher_head`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `voucher_head` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `voucher_head`
--

LOCK TABLES `voucher_head` WRITE;
/*!40000 ALTER TABLE `voucher_head` DISABLE KEYS */;
/*!40000 ALTER TABLE `voucher_head` 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 2023-07-06 19:58:52
