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

START TRANSACTION;



--
-- Database: `addmyentry_clajob`
--

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

--
-- Table structure for table `blogcomments`
--

CREATE TABLE `blogcomments` (
  `sno` int(11) NOT NULL,
  `postid` varchar(20) NOT NULL,
  `user` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `message` longtext NOT NULL,
  `status` varchar(20) NOT NULL,
  `createdat` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `blogpost`
--

CREATE TABLE `blogpost` (
  `sno` int(5) NOT NULL,
  `idno` int(3) NOT NULL,
  `postid` varchar(50) NOT NULL,
  `category` int(5) NOT NULL,
  `subcategory` int(5) NOT NULL,
  `tags` longtext NOT NULL,
  `description` varchar(200) NOT NULL,
  `postdescription` longtext NOT NULL,
  `logo` varchar(200) NOT NULL,
  `images` varchar(1000) NOT NULL,
  `youtube` varchar(1000) NOT NULL,
  `name` varchar(100) NOT NULL,
  `createdat` datetime NOT NULL,
  `createdby` varchar(50) NOT NULL,
  `status` varchar(15) NOT NULL,
  `applied` int(5) NOT NULL,
  `viewed` int(5) NOT NULL,
  `rating` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blogpost`
--

INSERT INTO `blogpost` (`sno`, `idno`, `postid`, `category`, `subcategory`, `tags`, `description`, `postdescription`, `logo`, `images`, `youtube`, `name`, `createdat`, `createdby`, `status`, `applied`, `viewed`, `rating`) VALUES
(1, 1, 'BLOG0001', 2, 2, '', 'nteger enim purus, posuere at ultricies eu, placerat a felis. Suspendisse aliquet urna pretium eros convallis interdum. Suspendisse aliquet urna pretium eros convallis interdum', '<p>Test Blog with<b> description</b><br></p>', 'blog1.jpg', 'blo1.jpg,blo2.jpg,blo3.jpg', 'https://www.youtube.com/embed/9o9TIwHtOJU', 'Test Blog', '2021-06-21 00:32:41', '', 'Approved', 0, 0, 0),
(2, 2, 'BLOG0002', 2, 2, 'Test, Blog, Technical', 'nteger enim purus, posuere at ultricies eu, placerat a felis. Suspendisse aliquet urna pretium eros convallis interdum. Suspendisse aliquet urna pretium eros convallis interdum', '<p>Test Description with <b>tags</b><br></p>', 'blog2.jpg', 'blo1.jpg,blo2.jpg,blo3.jpg', 'https://www.youtube.com/embed/9o9TIwHtOJU', 'Test Post Updated', '2021-06-21 01:07:55', 'ADMIN001', 'Approved', 0, 0, 0),
(4, 4, 'BLOG0004', 4, 19, '', 'Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providin', '<p>Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;<span style=\"font-size: 1rem;\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;</span><span style=\"font-size: 1rem;\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;<br></span><br></p><p><img src=\"data:image/jpeg;base64,[BLOB]\" style=\"width: 225px; float: left;\" data-filename=\"icareservicephone.jpg\" class=\"note-float-left\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;<span style=\"font-size: 1rem;\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;</span><span style=\"font-size: 1rem;\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;<br></span><br><br>Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;<span style=\"font-size: 1rem;\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;</span><span style=\"font-size: 1rem;\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;<br></span><br><iframe frameborder=\"0\" src=\"//www.youtube.com/embed/lDHgcc9Zt2Y\" width=\"640\" height=\"360\" class=\"note-video-clip\"></iframe><br><br>Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;<span style=\"font-size: 1rem;\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;</span><span style=\"font-size: 1rem;\">Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;Professional Accounting and integrated business solutions provider in Gurgaon and Delhi NCR providing&nbsp;</span><br></p>', 'icareservicephone.jpg', '', '', 'Professional Accounting and ', '2022-05-16 14:23:02', 'ADMIN001', 'Active', 0, 0, 0);
INSERT INTO `blogpost` (`sno`, `idno`, `postid`, `category`, `subcategory`, `tags`, `description`, `postdescription`, `logo`, `images`, `youtube`, `name`, `createdat`, `createdby`, `status`, `applied`, `viewed`, `rating`) VALUES
(5, 5, 'BLOG0005', 4, 19, '', 'dsf gsdh sd s', '<p><span style=\"outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner<br></span><img src=\"data:image/jpeg;base64,[BLOB]\" style=\"width: 25%; float: left;\" data-filename=\"sliderss.jpg\" class=\"note-float-left\"><br><span style=\"outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner<br></span><br><br><span style=\"outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner<br></span><br><span style=\"outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">consulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><span style=\"font-size: 1rem; outline: none; padding: 0px; color: rgb(102, 102, 102); font-family: &quot;Open Sans&quot;, sans-serif; text-align: justify;\">onsulting and professional services, we have been successful in helping our clients to maintain competitive positions in a cost-effective manner</span><br></p>', 'sliderss.jpg', '', '', 'df dgd h', '2022-05-23 11:07:15', 'ADMIN001', 'Active', 0, 0, 0);
INSERT INTO `blogpost` (`sno`, `idno`, `postid`, `category`, `subcategory`, `tags`, `description`, `postdescription`, `logo`, `images`, `youtube`, `name`, `createdat`, `createdby`, `status`, `applied`, `viewed`, `rating`) VALUES
(6, 6, 'BLOG0006', 4, 19, '', 'சிஙà¯கார செனà¯னை 2.0: தெரà¯கà¯களினà¯ பெயரà¯களிலà¯ இரà¯நà¯தà¯ ஜாதியை நீகà¯கà¯மà¯ பணி தொடகï', '<p><img src=\"data:image/jpeg;base64,[BLOB]\" style=\"width: 50%; float: left;\" data-filename=\"streetname.jpg\" class=\"note-float-left\">சிஙà¯கார செனà¯னை 2.0 திடà¯டதினà¯ இலசà¯சினை, தெரà¯வினà¯ பெயரà¯, வாரà¯டà¯, பகà¯தி, மணà¯டலமà¯, அஞà¯சலà¯ கà¯றியீடà¯டà¯ எணà¯ உளà¯ளிடà¯ட அனைதà¯தà¯ தகவலà¯களà¯மà¯ தெரà¯வினà¯ பெயரà¯ பலகைகளிலà¯ இடமà¯ பெறà¯றà¯ளà¯ளன.<br><br><span style=\"font-family: Eczar, serif; font-size: 18px;\">தெரà¯கà¯களினà¯ பெயரà¯களிலà¯ உளà¯ள ஜாதிபà¯ பெயரà¯களை நீகà¯கà¯மà¯ பணியை&nbsp;</span><font color=\"#e1261d\" face=\"Mukta, sans-serif\"><span style=\"outline-color: initial; outline-style: initial; word-break: break-word; font-size: 18px; line-height: 26px; display: inline-block; background-color: rgb(255, 255, 255);\"><b>செனà¯னை</b></span></font><span style=\"font-family: Eczar, serif; font-size: 18px;\">&nbsp;மாநகராடà¯சி தà¯வஙà¯கி உளà¯ளதாக தகவலà¯ வெளியாகி உளà¯ளதà¯.</span><br style=\"margin: 0px; padding: 0px; outline: 0px; font-family: Eczar, serif; font-size: 18px;\"><br style=\"margin: 0px; padding: 0px; outline: 0px; font-family: Eczar, serif; font-size: 18px;\"><span style=\"font-family: Eczar, serif; font-size: 18px;\">செனà¯னை மாநகராடà¯சியிலà¯ 10 ஆயிரதà¯திறà¯கà¯ மேறà¯படà¯ட தெரà¯கà¯களà¯ உளà¯ளதà¯. இநà¯த தெரà¯கà¯களினà¯ பெயரà¯ பலகைகளை சிஙà¯கார செனà¯னை 2.0 திடà¯டதà¯தினà¯ கீழà¯ மாறà¯றியமைகà¯கà¯மà¯ பணியை செனà¯னை மாநகராடà¯சி செயà¯தà¯ வரà¯கிறதà¯. இதனà¯படி 8.43 கோடி ரூபாயà¯ செலவிலà¯ தெரà¯கà¯களினà¯ பெயரà¯ பலகைகளà¯ மாறà¯றியமைகà¯கபà¯படà¯டà¯ வரà¯கிறதà¯.</span><br style=\"margin: 0px; padding: 0px; outline: 0px; font-family: Eczar, serif; font-size: 18px;\"><br style=\"margin: 0px; padding: 0px; outline: 0px; font-family: Eczar, serif; font-size: 18px;\"><span style=\"font-family: Eczar, serif; font-size: 18px;\">கà¯றிபà¯பாக சிஙà¯கார செனà¯னை 2.0 திடà¯டதினà¯ இலசà¯சினை, தெரà¯வினà¯ பெயரà¯, வாரà¯டà¯, பகà¯தி, மணà¯டலமà¯, அஞà¯சலà¯ கà¯றியீடà¯டà¯ எணà¯ உளà¯ளிடà¯ட அனைதà¯தà¯ தகவலà¯களà¯மà¯ இநà¯த பெயரà¯ பலகைகளிலà¯ இடமà¯ பெறà¯றà¯ளà¯ளன.&nbsp;இநà¯நிலையிலà¯ இநà¯த பணியà¯டனà¯ சேரà¯தà¯தà¯ தெரà¯கà¯களினà¯ பெயரà¯களிலà¯ உளà¯ள ஜாதிபà¯ பெயரà¯களை நீகà¯கà¯மà¯ நடவடிகà¯கையையà¯மà¯ செனà¯னை மாநகராடà¯சி தொடஙà¯கி உளà¯ளதாக தகவலà¯ வெளியாகி உளà¯ளதà¯</span><br></p>', 'streetname.jpg', '', '', 'சிஙà¯கார செனà¯னை 2.0: ', '2022-05-29 10:17:48', 'ADMIN001', 'Active', 0, 0, 0);
