-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `crm`
--

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

--
-- Table structure for table `actionreq`
--

CREATE TABLE `actionreq` (
  `AcR_Code` int(11) NOT NULL DEFAULT 0,
  `AcR_Name` varchar(30) NOT NULL DEFAULT ' ',
  `AcR_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `AcR_Signature` int(11) NOT NULL DEFAULT 0,
  `AcR_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `actionreqdemo`
--

CREATE TABLE `actionreqdemo` (
  `AcR_Code` int(11) NOT NULL DEFAULT 0,
  `AcR_Name` varchar(30) NOT NULL DEFAULT ' ',
  `AcR_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `AcR_Signature` int(11) NOT NULL DEFAULT 0,
  `AcR_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `businesscat`
--

CREATE TABLE `businesscat` (
  `BuC_Code` int(11) NOT NULL DEFAULT 0,
  `BuC_Name` varchar(30) NOT NULL DEFAULT ' ',
  `BuC_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `BuC_Signature` int(11) NOT NULL DEFAULT 0,
  `BuC_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `businesscatdemo`
--

CREATE TABLE `businesscatdemo` (
  `BuC_Code` int(11) NOT NULL DEFAULT 0,
  `BuC_Name` varchar(30) NOT NULL DEFAULT ' ',
  `BuC_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `BuC_Signature` int(11) NOT NULL DEFAULT 0,
  `BuC_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `Cli_Code` int(11) NOT NULL DEFAULT 0,
  `Cli_Name` varchar(30) NOT NULL DEFAULT ' ',
  `Cli_BusinessName` varchar(50) NOT NULL DEFAULT ' ',
  `Cli_BuC_Code` int(11) NOT NULL DEFAULT 0,
  `Cli_Address` varchar(250) NOT NULL DEFAULT ' ',
  `Cli_City` varchar(30) NOT NULL DEFAULT ' ',
  `Cli_Website` varchar(100) NOT NULL DEFAULT ' ',
  `Cli_Email` varchar(50) NOT NULL DEFAULT ' ',
  `Cli_Phone` varchar(15) NOT NULL DEFAULT ' ',
  `Cli_ContactPerson` varchar(30) NOT NULL DEFAULT ' ',
  `Cli_ContactPersonPhone` varchar(15) NOT NULL DEFAULT ' ',
  `Cli_Ref_Code` int(11) NOT NULL DEFAULT 0,
  `Cli_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Cli_Signature` int(11) NOT NULL DEFAULT 0,
  `Cli_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `clientsdemo`
--

CREATE TABLE `clientsdemo` (
  `Cli_Code` int(11) NOT NULL DEFAULT 0,
  `Cli_Name` varchar(30) NOT NULL DEFAULT ' ',
  `Cli_BusinessName` varchar(50) NOT NULL DEFAULT ' ',
  `Cli_BuC_Code` int(11) NOT NULL DEFAULT 0,
  `Cli_Address` varchar(250) NOT NULL DEFAULT ' ',
  `Cli_City` varchar(30) NOT NULL DEFAULT ' ',
  `Cli_Website` varchar(100) NOT NULL DEFAULT ' ',
  `Cli_Email` varchar(50) NOT NULL DEFAULT ' ',
  `Cli_Phone` varchar(15) NOT NULL DEFAULT ' ',
  `Cli_ContactPerson` varchar(30) NOT NULL DEFAULT ' ',
  `Cli_ContactPersonPhone` varchar(15) NOT NULL DEFAULT ' ',
  `Cli_Ref_Code` int(11) NOT NULL DEFAULT 0,
  `Cli_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Cli_Signature` int(11) NOT NULL DEFAULT 0,
  `Cli_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `company2`
--

CREATE TABLE `company2` (
  `Co2_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Co2_SlNo` int(11) NOT NULL DEFAULT 0,
  `Co2_Year` varchar(4) NOT NULL DEFAULT ''' ''',
  `Co2_Signature` int(11) NOT NULL DEFAULT 0,
  `Co2_DateModified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `company3renewed`
--

CREATE TABLE `company3renewed` (
  `Co3_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Co3_SlNo` int(11) NOT NULL DEFAULT 0,
  `Co3_StartDate` varchar(10) NOT NULL DEFAULT ' ',
  `Co3_EndDate` varchar(10) NOT NULL DEFAULT ' ',
  `Co3_RenewedOn` varchar(10) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `enquiry`
--

CREATE TABLE `enquiry` (
  `Enq_RecNo` varchar(10) NOT NULL DEFAULT ' ',
  `Enq_VouNo` varchar(8) NOT NULL DEFAULT ' ',
  `Enq_RequiredOn` varchar(10) NOT NULL DEFAULT ' ',
  `Enq_Date` varchar(10) NOT NULL DEFAULT ' ',
  `Enq_Cli_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_Value` varchar(100) NOT NULL DEFAULT ' ',
  `Enq_Notes` varchar(250) NOT NULL DEFAULT ' ',
  `Enq_Sta_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_ResEmp_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_AssignToEmp_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_AcR_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_AttachFileName` varchar(100) NOT NULL DEFAULT ' ',
  `Enq_EnterByEmp_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_SIgnature` int(11) NOT NULL DEFAULT 0,
  `Enq_DateModified` timestamp NOT NULL DEFAULT current_timestamp(),
  `Enq_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_NextFollowUpOn` varchar(10) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `enquirydemo`
--

CREATE TABLE `enquirydemo` (
  `Enq_RecNo` varchar(10) NOT NULL DEFAULT ' ',
  `Enq_VouNo` varchar(8) NOT NULL DEFAULT ' ',
  `Enq_RequiredOn` varchar(10) NOT NULL DEFAULT ' ',
  `Enq_Date` varchar(10) NOT NULL DEFAULT ' ',
  `Enq_Cli_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_Value` varchar(100) NOT NULL DEFAULT ' ',
  `Enq_Notes` varchar(250) NOT NULL DEFAULT ' ',
  `Enq_Sta_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_ResEmp_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_AssignToEmp_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_AcR_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_AttachFileName` varchar(100) NOT NULL DEFAULT ' ',
  `Enq_EnterByEmp_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_SIgnature` int(11) NOT NULL DEFAULT 0,
  `Enq_DateModified` timestamp NOT NULL DEFAULT current_timestamp(),
  `Enq_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Enq_NextFollowUpOn` varchar(10) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `entryrecnos`
--

CREATE TABLE `entryrecnos` (
  `Eny_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Mdl_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Co1_Code` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `entryrecnos`
--

INSERT INTO `entryrecnos` (`Eny_Code`, `Eny_Mdl_Code`, `Eny_Co1_Code`) VALUES
(0, 3, 0),
(0, 5, 0),
(0, 6, 0),
(0, 7, 0),
(0, 8, 0),
(0, 9, 0),
(0, 10, 0),
(0, 13, 0),
(0, 14, 0),
(0, 15, 0),
(0, 13, 0);

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

--
-- Table structure for table `entryrecnosdemo`
--

CREATE TABLE `entryrecnosdemo` (
  `Eny_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Mdl_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Co1_Code` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `entryyearrecnos`
--

CREATE TABLE `entryyearrecnos` (
  `Eny_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Mdl_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Bra_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Co1_Code` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `entryyearrecnosdemo`
--

CREATE TABLE `entryyearrecnosdemo` (
  `Eny_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Mdl_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Bra_Code` int(11) NOT NULL DEFAULT 0,
  `Eny_Co1_Code` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `followup`
--

CREATE TABLE `followup` (
  `FoU_RecNo` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_Date` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_FollowUpOn` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_ContactPerson` varchar(30) NOT NULL DEFAULT ' ',
  `FoU_Signature` int(11) NOT NULL DEFAULT 0,
  `FoU_DateModified` timestamp NOT NULL DEFAULT current_timestamp(),
  `FoU_Enq_RecNo` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_Cli_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_Notes` varchar(250) NOT NULL DEFAULT ' ',
  `FoU_Sta_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_NextFollowUoOn` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_AttachFileName` varchar(100) NOT NULL DEFAULT ' ',
  `FoU_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_AcR_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_FollowUpByEmp_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_FollowUpReq` varchar(1) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `followupdemo`
--

CREATE TABLE `followupdemo` (
  `FoU_RecNo` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_Date` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_FollowUpOn` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_ContactPerson` varchar(30) NOT NULL DEFAULT ' ',
  `FoU_Signature` int(11) NOT NULL DEFAULT 0,
  `FoU_DateModified` timestamp NOT NULL DEFAULT current_timestamp(),
  `FoU_Enq_RecNo` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_Cli_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_Notes` varchar(250) NOT NULL DEFAULT ' ',
  `FoU_Sta_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_NextFollowUoOn` varchar(10) NOT NULL DEFAULT ' ',
  `FoU_AttachFileName` varchar(100) NOT NULL DEFAULT ' ',
  `FoU_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_AcR_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_FollowUpByEmp_Code` int(11) NOT NULL DEFAULT 0,
  `FoU_FollowUpReq` varchar(1) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `Mdl_Code` int(11) NOT NULL DEFAULT 0,
  `Mdl_Name` varchar(50) NOT NULL DEFAULT '',
  `Mdl_IsTran` varchar(1) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`Mdl_Code`, `Mdl_Name`, `Mdl_IsTran`) VALUES
(3, 'Company', 'N'),
(5, 'Enquiry', 'N'),
(6, 'Todo', 'N'),
(7, 'Employees', 'N'),
(8, 'ClientEntry', 'N'),
(9, 'ReferenceEntry', 'N'),
(10, 'FollowUp', 'N'),
(13, 'StatusEntry', 'N'),
(14, 'ActionRequired', 'N'),
(15, 'BusinesCategory', 'N');

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

--
-- Table structure for table `referenceby`
--

CREATE TABLE `referenceby` (
  `Ref_Code` int(11) NOT NULL DEFAULT 0,
  `Ref_Name` varchar(30) NOT NULL DEFAULT ' ',
  `Ref_CreatedOn` varchar(10) NOT NULL DEFAULT ' ',
  `Ref_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Ref_Signature` int(11) NOT NULL DEFAULT 0,
  `Ref_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `referencebydemo`
--

CREATE TABLE `referencebydemo` (
  `Ref_Code` int(11) NOT NULL DEFAULT 0,
  `Ref_Name` varchar(30) NOT NULL DEFAULT ' ',
  `Ref_CreatedOn` varchar(10) NOT NULL DEFAULT ' ',
  `Ref_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Ref_Signature` int(11) NOT NULL DEFAULT 0,
  `Ref_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `Sta_Code` int(11) NOT NULL DEFAULT 0,
  `Sta_Status` varchar(30) NOT NULL DEFAULT ' ',
  `Sta_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Sta_Signature` int(11) NOT NULL DEFAULT 0,
  `Sta_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `statusdemo`
--

CREATE TABLE `statusdemo` (
  `Sta_Code` int(11) NOT NULL DEFAULT 0,
  `Sta_Status` varchar(30) NOT NULL DEFAULT ' ',
  `Sta_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `Sta_Signature` int(11) NOT NULL DEFAULT 0,
  `Sta_DateModified` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `todo`
--

CREATE TABLE `todo` (
  `ToD_RecNo` int(11) NOT NULL DEFAULT 0,
  `ToD_Date` varchar(10) NOT NULL DEFAULT '',
  `ToD_ToDoText` varchar(250) NOT NULL DEFAULT ' ',
  `ToD_ToDoDate` varchar(10) NOT NULL DEFAULT ' ',
  `ToD_Status` varchar(1) NOT NULL DEFAULT ' ',
  `ToD_Signature` int(11) NOT NULL DEFAULT 0,
  `ToD_DateModified` timestamp NOT NULL DEFAULT current_timestamp(),
  `ToD_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `ToD_Emp_Code` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tododemo`
--

CREATE TABLE `tododemo` (
  `ToD_RecNo` int(11) NOT NULL DEFAULT 0,
  `ToD_Date` varchar(10) NOT NULL DEFAULT '',
  `ToD_ToDoText` varchar(250) NOT NULL DEFAULT ' ',
  `ToD_ToDoDate` varchar(10) NOT NULL DEFAULT ' ',
  `ToD_Status` varchar(1) NOT NULL DEFAULT ' ',
  `ToD_Signature` int(11) NOT NULL DEFAULT 0,
  `ToD_DateModified` timestamp NOT NULL DEFAULT current_timestamp(),
  `ToD_Co1_Code` int(11) NOT NULL DEFAULT 0,
  `ToD_Emp_Code` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
COMMIT;

