-- 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;

--
-- Dumping data for table `actionreq`
--

INSERT INTO `actionreq` (`AcR_Code`, `AcR_Name`, `AcR_Co1_Code`, `AcR_Signature`, `AcR_DateModified`) VALUES
(1, 'Call', 1, 0, '2023-01-06 10:24:54'),
(2, 'Visit', 1, 0, '2023-01-06 10:24:54'),
(3, 'Send Quote', 1, 0, '2023-01-06 10:24:54'),
(4, 'Negotiate', 1, 0, '2023-01-06 10:24:54');

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

--
-- 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;

--
-- Dumping data for table `businesscat`
--

INSERT INTO `businesscat` (`BuC_Code`, `BuC_Name`, `BuC_Co1_Code`, `BuC_Signature`, `BuC_DateModified`) VALUES
(1, 'Consultancy', 1, 0, '2023-01-06 10:24:26'),
(2, 'Services', 1, 0, '2023-01-06 10:24:26'),
(3, 'Business', 1, 0, '2023-01-06 10:24:26'),
(4, 'Manufacturing', 1, 0, '2023-01-06 10:24:26');

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

--
-- 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;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`Cli_Code`, `Cli_Name`, `Cli_BusinessName`, `Cli_BuC_Code`, `Cli_Address`, `Cli_City`, `Cli_Website`, `Cli_Email`, `Cli_Phone`, `Cli_ContactPerson`, `Cli_ContactPersonPhone`, `Cli_Ref_Code`, `Cli_Co1_Code`, `Cli_Signature`, `Cli_DateModified`) VALUES
(1, 'ABC ', 'ABC Consultancy', 1, '', '', '', '', '9876543210', '', '', 0, 1, 0, '2023-01-06 10:28:48'),
(2, 'New Client 1', 'Sales and Services', 2, '', '', '', '', '9876543210', 'XYZ', '7894563210', 0, 1, 0, '2023-01-07 05:09:49');

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

--
-- 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;

--
-- Dumping data for table `enquiry`
--

INSERT INTO `enquiry` (`Enq_RecNo`, `Enq_VouNo`, `Enq_RequiredOn`, `Enq_Date`, `Enq_Cli_Code`, `Enq_Value`, `Enq_Notes`, `Enq_Sta_Code`, `Enq_ResEmp_Code`, `Enq_AssignToEmp_Code`, `Enq_AcR_Code`, `Enq_AttachFileName`, `Enq_EnterByEmp_Code`, `Enq_SIgnature`, `Enq_DateModified`, `Enq_Co1_Code`, `Enq_NextFollowUpOn`) VALUES
('1', '00000001', '2023-01-06', '2023-01-06', 1, '20000', 'Send quotation to the customer first', 2, 2, 2, 1, '', 1, 0, '2023-01-06 10:28:48', 1, '2023-01-07'),
('2', '00000002', '2023-01-07', '2023-01-07', 2, '25000', 'Contact first', 4, 2, 2, 1, '', 1, 0, '2023-01-07 05:09:49', 1, '2023-01-10'),
('3', '00000003', '2023-01-07', '2023-01-07', 2, '3500', 'New enquiry', 2, 2, 2, 1, '', 1, 0, '2023-01-07 05:18:29', 1, ' ');

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

--
-- 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
(1, 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),
(1, 3, 1),
(3, 5, 1),
(0, 6, 1),
(2, 7, 1),
(2, 8, 1),
(2, 9, 1),
(5, 10, 1),
(4, 13, 1),
(4, 14, 1),
(4, 15, 1),
(4, 13, 1);

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

--
-- 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;

--
-- Dumping data for table `followup`
--

INSERT INTO `followup` (`FoU_RecNo`, `FoU_Date`, `FoU_FollowUpOn`, `FoU_ContactPerson`, `FoU_Signature`, `FoU_DateModified`, `FoU_Enq_RecNo`, `FoU_Cli_Code`, `FoU_Notes`, `FoU_Sta_Code`, `FoU_NextFollowUoOn`, `FoU_AttachFileName`, `FoU_Co1_Code`, `FoU_AcR_Code`, `FoU_FollowUpByEmp_Code`, `FoU_FollowUpReq`) VALUES
('0000000001', '2023-01-06', '2023-01-06', 'ABC', 0, '2023-01-06 10:34:34', '1', 1, 'Talked to the client', 4, '2023-01-07', '', 1, 2, 2, 'Y'),
('0000000002', '2023-01-06', '2023-01-07', 'ABC', 0, '2023-01-06 10:36:33', '1', 1, '', 3, '2023-01-07', '', 1, 3, 1, 'Y'),
('0000000003', '2023-01-06', '2023-01-06', 'ABC', 0, '2023-01-06 12:01:19', '1', 1, 'Data changed', 2, '', '', 1, 2, 2, ''),
('0000000004', '2023-01-07', '2023-01-07', 'Niranjan', 0, '2023-01-07 05:13:18', '2', 2, 'call back again', 3, '2023-01-09', '', 1, 2, 2, 'Y'),
('0000000005', '2023-01-07', '2023-01-07', 'XYZ', 0, '2023-01-07 05:17:14', '2', 2, 'followed up again', 4, '2023-01-10', '', 1, 2, 2, 'Y');

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

--
-- 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;

--
-- Dumping data for table `referenceby`
--

INSERT INTO `referenceby` (`Ref_Code`, `Ref_Name`, `Ref_CreatedOn`, `Ref_Co1_Code`, `Ref_Signature`, `Ref_DateModified`) VALUES
(1, 'Raj ', '', 1, 0, '2023-01-06 10:22:29'),
(2, 'Nishanth', '', 1, 0, '2023-01-06 10:22:29');

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

--
-- 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(),
  `Sta_ShowInDashboard` varchar(1) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`Sta_Code`, `Sta_Status`, `Sta_Co1_Code`, `Sta_Signature`, `Sta_DateModified`, `Sta_ShowInDashboard`) VALUES
(1, 'Closed', 1, 2, '2023-01-07 05:30:07', 'N'),
(2, 'Pending Prospective', 1, 2, '2023-01-07 05:30:07', 'Y'),
(3, 'In-Progress', 1, 2, '2023-01-07 05:30:07', 'Y'),
(4, 'Approved', 1, 2, '2023-01-07 05:30:07', 'Y');

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

--
-- 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(),
  `Sta_ShowInDashboard` varchar(1) NOT NULL DEFAULT ' '
) 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;

