File: feedbacker.sql

Recommend this page to a friend!
  Classes of Kishor Mali  >  PHP User Feedback System  >  feedbacker.sql  >  Download  
File: feedbacker.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP User Feedback System
Application to record feedback from customers
Author: By
Last change:
Date: 4 months ago
Size: 27,639 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 13, 2018 at 08:11 AM
-- Server version: 10.1.16-MariaDB
-- PHP Version: 5.6.24

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `feedbacker`
--

-- --------------------------------------------------------

--
-- Table structure for table `fb_attachments`
--

CREATE TABLE `fb_attachments` (
  `at_id` int(11) NOT NULL,
  `comp_id` int(11) NOT NULL,
  `at_type_id` int(11) NOT NULL,
  `at_path` varchar(128) NOT NULL,
  `is_deleted` tinyint(4) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Attaments of porfolio''s and profile''s';

-- --------------------------------------------------------

--
-- Table structure for table `fb_attach_type`
--

CREATE TABLE `fb_attach_type` (
  `at_type_id` int(11) NOT NULL,
  `at_type` enum('PORTFOLIO','PROFILE','PORTFOLIO WITH PROFILE') NOT NULL,
  `at_text` varchar(512) NOT NULL,
  `is_deleted` tinyint(4) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Attachment Types';

--
-- Dumping data for table `fb_attach_type`
--

INSERT INTO `fb_attach_type` (`at_type_id`, `at_type`, `at_text`, `is_deleted`, `created_by`, `created_dtm`, `updated_by`, `updated_dtm`) VALUES
(1, 'PORTFOLIO', 'Portfolio', 0, 1, '2016-05-25 00:00:00', NULL, NULL),
(2, 'PROFILE', 'Profile', 0, 1, '2016-05-25 12:50:12', NULL, NULL),
(3, 'PORTFOLIO WITH PROFILE', 'Portfolio with Profile', 0, 1, '2016-05-25 00:00:00', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `fb_company`
--

CREATE TABLE `fb_company` (
  `comp_id` int(11) NOT NULL,
  `comp_name` varchar(512) NOT NULL,
  `comp_url` varchar(128) DEFAULT NULL,
  `address` varchar(1024) DEFAULT NULL,
  `contact` varchar(20) DEFAULT NULL,
  `comp_email` varchar(128) NOT NULL,
  `comp_pass` varchar(128) NOT NULL,
  `is_deleted` tinyint(4) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='lead proposing company';

--
-- Dumping data for table `fb_company`
--

INSERT INTO `fb_company` (`comp_id`, `comp_name`, `comp_url`, `address`, `contact`, `comp_email`, `comp_pass`, `is_deleted`, `created_by`, `created_dtm`, `updated_by`, `updated_dtm`) VALUES
(1, 'CodeInsect', 'http://www.codeinsect.com', 'Pune, India', NULL, 'admin@example.com', 'codeinsect', 0, 1, '2016-05-25 12:24:42', NULL, NULL),
(2, 'Company 2', 'http://www.codeinsect.com', 'Pune, India', '', 'admin@example.com', 'codeinsect', 0, 1, '2016-05-25 12:24:42', NULL, NULL),
(3, 'Company 3', 'http://www.codeinsect.com', 'Pune, India', NULL, 'admin@example.com', 'codeinsect', 0, 1, '2016-05-26 10:41:38', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `fb_cron_counter`
--

CREATE TABLE `fb_cron_counter` (
  `fb_ofid` bigint(20) NOT NULL,
  `fb_ofcount` bigint(20) NOT NULL DEFAULT '0',
  `fb_totcount` bigint(20) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  `created_dtm` datetime NOT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fb_cust_followup`
--

CREATE TABLE `fb_cust_followup` (
  `fp_id` bigint(20) NOT NULL,
  `fp_type` enum('EMAIL','CALL') NOT NULL DEFAULT 'CALL',
  `cust_id` bigint(20) NOT NULL,
  `currently_served_by` bigint(20) NOT NULL,
  `fp_dtm` datetime DEFAULT NULL,
  `fp_summary` text,
  `fbt_id` int(11) NOT NULL,
  `fp_next_call` datetime DEFAULT NULL,
  `fp_status` tinyint(4) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  `created_by` bigint(20) NOT NULL,
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fb_cust_reqment`
--

CREATE TABLE `fb_cust_reqment` (
  `rem_id` bigint(20) NOT NULL,
  `cust_id` bigint(20) NOT NULL,
  `currently_served_by` bigint(20) NOT NULL,
  `rem_summary` text,
  `interested_in` varchar(512) DEFAULT NULL,
  `cust_cost` varchar(50) DEFAULT NULL,
  `estimated_cost` varchar(50) DEFAULT NULL,
  `conversion_cost` varchar(50) DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  `created_by` bigint(20) NOT NULL,
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fb_cust_scr`
--

CREATE TABLE `fb_cust_scr` (
  `scr_id` bigint(20) NOT NULL,
  `cust_id` bigint(20) NOT NULL,
  `scr_img_desk` varchar(50) DEFAULT NULL,
  `scr_img_mobile` varchar(50) DEFAULT NULL,
  `scr_dtm` datetime DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  `created_by` bigint(20) NOT NULL,
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fb_email_template`
--

CREATE TABLE `fb_email_template` (
  `temp_id` int(11) NOT NULL,
  `comp_id` int(11) NOT NULL,
  `temp_name` varchar(512) NOT NULL,
  `temp_html` text NOT NULL,
  `temp_type` int(11) DEFAULT NULL,
  `is_deleted` tinyint(4) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email templates by company id';

--
-- Dumping data for table `fb_email_template`
--

INSERT INTO `fb_email_template` (`temp_id`, `comp_id`, `temp_name`, `temp_html`, `temp_type`, `is_deleted`, `created_by`, `created_dtm`, `updated_by`, `updated_dtm`) VALUES
(1, 1, 'Portfolio Template', '<div>\n<table style="width: 100%; border-spacing: 0;" cellspacing="0" cellpadding="0">\n<tbody>\n<tr style="height: 78px;">\n<th style="border-top: 5px solid #f56400; font-weight: normal; text-align: center; background: #ffffff none repeat scroll 0% 0%; border-bottom: 1px solid #e3e5e1; height: 78px;">\n<table style="width: 100%; max-width: 596px; border-spacing: 0; margin: 0 auto;" cellspacing="0" cellpadding="0" align="center">\n<tbody>\n<tr style="height: 74px;">\n<td style="height: 74px;">\n<table style="margin: 0%; width: 100%; border-spacing: 0; table-layout: fixed;" cellspacing="0" cellpadding="0">\n<tbody>\n<tr style="height: 38px;">\n<td style="padding: 17px 3.358% 15px; height: 38px;"><cite style="text-align: center; display: block; font-style: normal;"><cite style="text-align: center; display: block; font-style: normal;"> <span style="font-size: 1px; min-height: 0; color: #fff; width: 0; display: block;">The portfolio is on the way</span></cite></cite>\n<div style="font-size: 15px; display: inline-block; width: 100%; margin: 0px; vertical-align: top;">CodeInsect</div>\n</td>\n</tr>\n</tbody>\n</table>\n</td>\n</tr>\n</tbody>\n</table>\n</th>\n</tr>\n<tr style="height: 28px;">\n<th style="background: #f5f5f1; height: 28px;">&nbsp;</th>\n</tr>\n<tr style="height: 318px;">\n<th style="background: #f5f5f1 none repeat scroll 0% 0%; font-weight: normal; text-align: left; height: 318px;">\n<table style="width: 100%; max-width: 596px; border-spacing: 0; margin: 0 auto;" cellspacing="0" cellpadding="0" align="center">\n<tbody>\n<tr>\n<td>\n<table style="margin: 0%; width: 100%; border-spacing: 0; table-layout: fixed;" cellspacing="0" cellpadding="0">\n<tbody>\n<tr>\n<td style="padding: 0 3.358%; font-size: 15px; color: #555; line-height: 24px;">\n<div style="min-height: 28px;">&nbsp;</div>\n<div style="padding: 24px 3.6% 24px; background: #fff; border: 1px solid #e3e5e1;">\n<table style="width: 100%; margin: 0; padding: 0;" cellspacing="0" cellpadding="0">\n<tbody>\n<tr>\n<td align="center">\n<div style="width: 100%;">Hi, You got the portfolio, please download the attachment.\n<div style="min-height: 20px;">&nbsp;</div>\n</div>\n</td>\n</tr>\n</tbody>\n</table>\n</div>\n<div style="min-height: 28px;">&nbsp;</div>\n<table style="width: 100%; margin: 0; padding: 0;" cellspacing="0" cellpadding="0">\n<tbody>\n<tr>\n<td align="center">\n<div style="width: 100%;"><span style="font-size: 12px; line-height: 18px; color: #555;">If you have any query, <a style="text-decoration: none; color: #0192b5;" href="#" target="_blank"> please contact CodeInsect support</a>.</span></div>\n</td>\n</tr>\n</tbody>\n</table>\n<div style="min-height: 28px;">&nbsp;</div>\n<div style="text-align: center; padding: 0 6% 24px; font-size: 12px; line-height: 18px; color: #555;">You are receiving this email from CodeInsect because you <span class="il"> subscribed </span> <a style="color: #555; font-weight: normal; text-decoration: underline;" href="http://codeinsect.com" target="_blank"> CodeInsect </a> with this email address.<br /><br /> Copyright CodeInsect 2017 - All Rights Reserved</div>\n</td>\n</tr>\n</tbody>\n</table>\n</td>\n</tr>\n</tbody>\n</table>\n</th>\n</tr>\n</tbody>\n</table>\n<div class="yj6qo">&nbsp;</div>\n<div class="adL">&nbsp;</div>\n</div>', 1, 0, 1, '2016-05-25 00:00:00', 1, '2016-05-26 11:51:41'),
(2, 2, 'Portfolio Template', '<div>\r\n<table style="width: 100%; border-spacing: 0;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr style="height: 78px;">\r\n<th style="border-top: 5px solid #f56400; font-weight: normal; text-align: center; background: #ffffff none repeat scroll 0% 0%; border-bottom: 1px solid #e3e5e1; height: 78px;">\r\n<table style="width: 100%; max-width: 596px; border-spacing: 0; margin: 0 auto;" cellspacing="0" cellpadding="0" align="center">\r\n<tbody>\r\n<tr style="height: 74px;">\r\n<td style="height: 74px;">\r\n<table style="margin: 0%; width: 100%; border-spacing: 0; table-layout: fixed;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr style="height: 38px;">\r\n<td style="padding: 17px 3.358% 15px; height: 38px;"><cite style="text-align: center; display: block; font-style: normal;"><cite style="text-align: center; display: block; font-style: normal;"> <span style="font-size: 1px; min-height: 0; color: #fff; width: 0; display: block;">The portfolio is on the way</span></cite></cite>\r\n<div style="font-size: 15px; display: inline-block; width: 100%; margin: 0px; vertical-align: top;">CodeInsect</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</th>\r\n</tr>\r\n<tr style="height: 28px;">\r\n<th style="background: #f5f5f1; height: 28px;">&nbsp;</th>\r\n</tr>\r\n<tr style="height: 318px;">\r\n<th style="background: #f5f5f1 none repeat scroll 0% 0%; font-weight: normal; text-align: left; height: 318px;">\r\n<table style="width: 100%; max-width: 596px; border-spacing: 0; margin: 0 auto;" cellspacing="0" cellpadding="0" align="center">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<table style="margin: 0%; width: 100%; border-spacing: 0; table-layout: fixed;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr>\r\n<td style="padding: 0 3.358%; font-size: 15px; color: #555; line-height: 24px;">\r\n<div style="min-height: 28px;">&nbsp;</div>\r\n<div style="padding: 24px 3.6% 24px; background: #fff; border: 1px solid #e3e5e1;">\r\n<table style="width: 100%; margin: 0; padding: 0;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr>\r\n<td align="center">\r\n<div style="width: 100%;">Hi, You got the portfolio, please download the attachment.\r\n<div style="min-height: 20px;">&nbsp;</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n<div style="min-height: 28px;">&nbsp;</div>\r\n<table style="width: 100%; margin: 0; padding: 0;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr>\r\n<td align="center">\r\n<div style="width: 100%;"><span style="font-size: 12px; line-height: 18px; color: #555;">If you have any query, <a style="text-decoration: none; color: #0192b5;" href="#" target="_blank"> please contact CodeInsect support</a>.</span></div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<div style="min-height: 28px;">&nbsp;</div>\r\n<div style="text-align: center; padding: 0 6% 24px; font-size: 12px; line-height: 18px; color: #555;">You are receiving this email from CodeInsect because you <span class="il"> subscribed </span> <a style="color: #555; font-weight: normal; text-decoration: underline;" href="http://codeinsect.com" target="_blank"> CodeInsect </a> with this email address.<br /><br /> Copyright CodeInsect 2016 - All Rights Reserved</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</th>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<div class="yj6qo">&nbsp;</div>\r\n<div class="adL">&nbsp;</div>\r\n</div>', 1, 0, 1, '2016-05-25 00:00:00', 1, '2018-02-13 08:04:21'),
(3, 3, 'Portfolio Template', '<div>\r\n<table style="width: 100%; border-spacing: 0;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr style="height: 78px;">\r\n<th style="border-top: 5px solid #f56400; font-weight: normal; text-align: center; background: #ffffff none repeat scroll 0% 0%; border-bottom: 1px solid #e3e5e1; height: 78px;">\r\n<table style="width: 100%; max-width: 596px; border-spacing: 0; margin: 0 auto;" cellspacing="0" cellpadding="0" align="center">\r\n<tbody>\r\n<tr style="height: 74px;">\r\n<td style="height: 74px;">\r\n<table style="margin: 0%; width: 100%; border-spacing: 0; table-layout: fixed;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr style="height: 38px;">\r\n<td style="padding: 17px 3.358% 15px; height: 38px;"><cite style="text-align: center; display: block; font-style: normal;"><cite style="text-align: center; display: block; font-style: normal;"> <span style="font-size: 1px; min-height: 0; color: #fff; width: 0; display: block;">The portfolio is on the way</span></cite></cite>\r\n<div style="font-size: 15px; display: inline-block; width: 100%; margin: 0px; vertical-align: top;">CodeInsect</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</th>\r\n</tr>\r\n<tr style="height: 28px;">\r\n<th style="background: #f5f5f1; height: 28px;">&nbsp;</th>\r\n</tr>\r\n<tr style="height: 318px;">\r\n<th style="background: #f5f5f1 none repeat scroll 0% 0%; font-weight: normal; text-align: left; height: 318px;">\r\n<table style="width: 100%; max-width: 596px; border-spacing: 0; margin: 0 auto;" cellspacing="0" cellpadding="0" align="center">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<table style="margin: 0%; width: 100%; border-spacing: 0; table-layout: fixed;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr>\r\n<td style="padding: 0 3.358%; font-size: 15px; color: #555; line-height: 24px;">\r\n<div style="min-height: 28px;">&nbsp;</div>\r\n<div style="padding: 24px 3.6% 24px; background: #fff; border: 1px solid #e3e5e1;">\r\n<table style="width: 100%; margin: 0; padding: 0;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr>\r\n<td align="center">\r\n<div style="width: 100%;">Hi, You got the portfolio, please download the attachment.\r\n<div style="min-height: 20px;">&nbsp;</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n<div style="min-height: 28px;">&nbsp;</div>\r\n<table style="width: 100%; margin: 0; padding: 0;" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr>\r\n<td align="center">\r\n<div style="width: 100%;"><span style="font-size: 12px; line-height: 18px; color: #555;">If you have any query, <a style="text-decoration: none; color: #0192b5;" href="#" target="_blank"> please contact CodeInsect support</a>.</span></div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<div style="min-height: 28px;">&nbsp;</div>\r\n<div style="text-align: center; padding: 0 6% 24px; font-size: 12px; line-height: 18px; color: #555;">You are receiving this email from CodeInsect because you <span class="il"> subscribed </span> <a style="color: #555; font-weight: normal; text-decoration: underline;" href="http://codeinsect.com" target="_blank"> CodeInsect</a> with this email address.<br /><br /> Copyright CodeInsect 2016 - All Rights Reserved</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</th>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<div class="yj6qo">&nbsp;</div>\r\n<div class="adL">&nbsp;</div>\r\n</div>', 1, 0, 1, '2016-05-25 00:00:00', 1, '2018-02-13 08:04:58');

-- --------------------------------------------------------

--
-- Table structure for table `fb_fbtype`
--

CREATE TABLE `fb_fbtype` (
  `fbt_id` int(11) NOT NULL,
  `fbt_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='these are feedback types';

--
-- Dumping data for table `fb_fbtype`
--

INSERT INTO `fb_fbtype` (`fbt_id`, `fbt_name`) VALUES
(1, 'Good'),
(2, 'Bad'),
(3, 'Interested'),
(4, 'Not Interested'),
(5, 'Abused'),
(6, 'Not Received'),
(7, 'Unable to connect');

-- --------------------------------------------------------

--
-- Table structure for table `fb_packages`
--

CREATE TABLE `fb_packages` (
  `pkg_id` int(11) NOT NULL,
  `pkg_name` varchar(128) DEFAULT NULL,
  `pkg_cost` double NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  `created_by` bigint(20) NOT NULL DEFAULT '1',
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fb_packages`
--

INSERT INTO `fb_packages` (`pkg_id`, `pkg_name`, `pkg_cost`, `status`, `is_deleted`, `created_by`, `created_dtm`, `updated_by`, `updated_dtm`) VALUES
(1, 'SEO', 10000, 1, 0, 1, '2016-05-17 16:27:43', NULL, NULL),
(2, 'Static Pages', 20000, 1, 0, 1, '2016-05-17 16:29:31', NULL, NULL),
(3, 'Dynamic Site', 50000, 1, 0, 1, '2016-05-17 16:29:45', NULL, NULL),
(4, 'PHP Development', 400000, 1, 0, 1, '2016-05-17 16:30:11', NULL, NULL),
(5, 'Android App', 500000, 1, 0, 1, '2016-05-17 16:30:26', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `fb_raw_cust`
--

CREATE TABLE `fb_raw_cust` (
  `cust_id` bigint(20) NOT NULL,
  `domain_name` varchar(1024) NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `expiry_date` datetime DEFAULT NULL,
  `domain_registrar_name` varchar(128) DEFAULT NULL,
  `registrant_name` varchar(128) DEFAULT NULL,
  `registrant_company` varchar(100) DEFAULT NULL,
  `registrant_address` varchar(1024) DEFAULT NULL,
  `registrant_city` varchar(50) DEFAULT NULL,
  `registrant_state` varchar(50) DEFAULT NULL,
  `registrant_zip` varchar(10) DEFAULT NULL,
  `registrant_country` varchar(50) DEFAULT NULL,
  `registrant_email` varchar(128) DEFAULT NULL,
  `registrant_phone` varchar(20) DEFAULT NULL,
  `registrant_alt_email` varchar(128) DEFAULT NULL,
  `registrant_alt_phone` varchar(20) DEFAULT NULL,
  `registrant_fax` varchar(20) DEFAULT NULL,
  `conversion_flag` tinyint(4) NOT NULL DEFAULT '0',
  `scr_dtm` datetime DEFAULT NULL,
  `scr_img_desk` varchar(512) DEFAULT NULL,
  `scr_img_mobile` varchar(512) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `assigned_to` bigint(20) NOT NULL DEFAULT '0',
  `currently_served_by` bigint(20) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  `created_by` bigint(20) NOT NULL,
  `created_dtm` datetime NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_dtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_last_login`
--

CREATE TABLE `tbl_last_login` (
  `id` bigint(20) NOT NULL,
  `userId` bigint(20) NOT NULL,
  `sessionData` varchar(2048) NOT NULL,
  `machineIp` varchar(1024) NOT NULL,
  `userAgent` varchar(128) NOT NULL,
  `agentString` varchar(1024) NOT NULL,
  `platform` varchar(128) NOT NULL,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_last_login`
--

INSERT INTO `tbl_last_login` (`id`, `userId`, `sessionData`, `machineIp`, `userAgent`, `agentString`, `platform`, `createdDtm`) VALUES
(1, 1, '{"role":"1","roleText":"System Administrator","name":"Administrator"}', '::1', 'Firefox 58.0', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', 'Windows 10', '2018-02-13 12:40:36');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_reset_password`
--

CREATE TABLE `tbl_reset_password` (
  `id` bigint(20) NOT NULL,
  `email` varchar(128) NOT NULL,
  `activation_id` varchar(32) NOT NULL,
  `agent` varchar(512) NOT NULL,
  `client_ip` varchar(32) NOT NULL,
  `isDeleted` tinyint(4) NOT NULL DEFAULT '0',
  `createdBy` bigint(20) NOT NULL DEFAULT '1',
  `createdDtm` datetime NOT NULL,
  `updatedBy` bigint(20) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_roles`
--

CREATE TABLE `tbl_roles` (
  `roleId` tinyint(4) NOT NULL COMMENT 'role id',
  `role` varchar(50) NOT NULL COMMENT 'role text'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_roles`
--

INSERT INTO `tbl_roles` (`roleId`, `role`) VALUES
(1, 'System Administrator'),
(2, 'Manager'),
(3, 'Employee');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `userId` int(11) NOT NULL,
  `email` varchar(128) NOT NULL COMMENT 'login email',
  `password` varchar(128) NOT NULL COMMENT 'login password md5',
  `name` varchar(128) DEFAULT NULL COMMENT 'full name of user',
  `mobile` varchar(20) DEFAULT NULL,
  `roleId` tinyint(4) NOT NULL,
  `isDeleted` tinyint(4) NOT NULL DEFAULT '0',
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`userId`, `email`, `password`, `name`, `mobile`, `roleId`, `isDeleted`, `createdBy`, `createdDtm`, `updatedBy`, `updatedDtm`) VALUES
(1, 'admin@example.com', '$2y$10$gbQl4Dbtl7m9wwKC3ABTVeVDUar/ko/zW.PCHZ8DxGJPwOXiq9QuS', 'Administrator', '9890098900', 1, 0, 0, '2015-07-01 18:56:49', 1, '2018-02-13 07:57:55'),
(2, 'emp1@example.com', '$2y$10$/raL8WKiJjyRiPazkPeuYu3DCAJE5DOsoWPErmpYPUgLtYjXArpJ6', 'Employee 1', '9890098900', 3, 0, 1, '2016-05-10 14:21:51', 1, '2018-02-12 09:57:16'),
(3, 'emp2@example.com', '$2y$10$/raL8WKiJjyRiPazkPeuYu3DCAJE5DOsoWPErmpYPUgLtYjXArpJ6', 'Employee 2', '9890098900', 3, 0, 1, '2016-05-16 11:18:58', NULL, NULL),
(4, 'emp3@example.com', '$2y$10$/raL8WKiJjyRiPazkPeuYu3DCAJE5DOsoWPErmpYPUgLtYjXArpJ6', 'Employee 3', '9890098900', 3, 0, 1, '2016-05-16 11:19:29', NULL, NULL),
(5, 'emp4@example.com', '$2y$10$/raL8WKiJjyRiPazkPeuYu3DCAJE5DOsoWPErmpYPUgLtYjXArpJ6', 'Employee 4', '9890098900', 3, 0, 1, '2016-06-01 18:24:13', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `fb_attachments`
--
ALTER TABLE `fb_attachments`
  ADD PRIMARY KEY (`at_id`);

--
-- Indexes for table `fb_attach_type`
--
ALTER TABLE `fb_attach_type`
  ADD PRIMARY KEY (`at_type_id`);

--
-- Indexes for table `fb_company`
--
ALTER TABLE `fb_company`
  ADD PRIMARY KEY (`comp_id`);

--
-- Indexes for table `fb_cron_counter`
--
ALTER TABLE `fb_cron_counter`
  ADD PRIMARY KEY (`fb_ofid`);

--
-- Indexes for table `fb_cust_followup`
--
ALTER TABLE `fb_cust_followup`
  ADD PRIMARY KEY (`fp_id`);

--
-- Indexes for table `fb_cust_reqment`
--
ALTER TABLE `fb_cust_reqment`
  ADD PRIMARY KEY (`rem_id`);

--
-- Indexes for table `fb_cust_scr`
--
ALTER TABLE `fb_cust_scr`
  ADD PRIMARY KEY (`scr_id`);

--
-- Indexes for table `fb_email_template`
--
ALTER TABLE `fb_email_template`
  ADD PRIMARY KEY (`temp_id`);

--
-- Indexes for table `fb_fbtype`
--
ALTER TABLE `fb_fbtype`
  ADD PRIMARY KEY (`fbt_id`);

--
-- Indexes for table `fb_packages`
--
ALTER TABLE `fb_packages`
  ADD PRIMARY KEY (`pkg_id`);

--
-- Indexes for table `fb_raw_cust`
--
ALTER TABLE `fb_raw_cust`
  ADD PRIMARY KEY (`cust_id`);

--
-- Indexes for table `tbl_last_login`
--
ALTER TABLE `tbl_last_login`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_reset_password`
--
ALTER TABLE `tbl_reset_password`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_roles`
--
ALTER TABLE `tbl_roles`
  ADD PRIMARY KEY (`roleId`);

--
-- Indexes for table `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`userId`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `fb_attachments`
--
ALTER TABLE `fb_attachments`
  MODIFY `at_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fb_attach_type`
--
ALTER TABLE `fb_attach_type`
  MODIFY `at_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `fb_company`
--
ALTER TABLE `fb_company`
  MODIFY `comp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `fb_cron_counter`
--
ALTER TABLE `fb_cron_counter`
  MODIFY `fb_ofid` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fb_cust_followup`
--
ALTER TABLE `fb_cust_followup`
  MODIFY `fp_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fb_cust_reqment`
--
ALTER TABLE `fb_cust_reqment`
  MODIFY `rem_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fb_cust_scr`
--
ALTER TABLE `fb_cust_scr`
  MODIFY `scr_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fb_email_template`
--
ALTER TABLE `fb_email_template`
  MODIFY `temp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `fb_fbtype`
--
ALTER TABLE `fb_fbtype`
  MODIFY `fbt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `fb_packages`
--
ALTER TABLE `fb_packages`
  MODIFY `pkg_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `fb_raw_cust`
--
ALTER TABLE `fb_raw_cust`
  MODIFY `cust_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_last_login`
--
ALTER TABLE `tbl_last_login`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_reset_password`
--
ALTER TABLE `tbl_reset_password`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_roles`
--
ALTER TABLE `tbl_roles`
  MODIFY `roleId` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT 'role id', AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `userId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
/*!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 */;

For more information send a message to info at phpclasses dot org.