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

START TRANSACTION;



--
-- Database: `jafamvei_assaindia`
--

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `detail` varchar(5000) NOT NULL,
  `postby` varchar(300) NOT NULL,
  `date` varchar(200) NOT NULL,
  `image` varchar(2000) NOT NULL,
  `url` varchar(200) NOT NULL,
  `metatitle` varchar(1500) NOT NULL,
  `metakeywords` varchar(1500) NOT NULL,
  `metadescription` varchar(2000) NOT NULL,
  `status` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `detail`, `postby`, `date`, `image`, `url`, `metatitle`, `metakeywords`, `metadescription`, `status`) VALUES
(3, 'We Are One Stop Solution Providers', 'We are an architectural product design and innovation company. We bring the latest and greatest from the industry at arm\'s length distance from you. We have been in the industry for almost 2 decades now, having worked with the industry leaders such as Samsung C&amp;T, Armani Casa, Schindler, Marriot just to name a few. We bring innovation and design together. Our Products include, not limiting to, Bespoke Vertical Transportation Design Metal Screens Kinetic and Non-kinetic Façade Stainless Steel Sculpture Decorative Metal Ceiling Bespoke Furniture Metal Signage Renovation of old elevators Escalator Cladding Metal Sculptures Metal Screens and Partitions Metal Décor Stainless Steel Sheets Custom Metal Door', 'Dev It Serv', '14-Jun-2021', 'cx.jpg', 'we-are-one-stop-solution-providers', 'Dev It Serv', 'Dev It Serv', 'Dev It Serv', 0);

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

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

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `detail` varchar(2000) NOT NULL,
  `image` varchar(2000) NOT NULL,
  `designation` varchar(200) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `clients` (`id`, `title`, `detail`, `image`, `designation`, `status`) VALUES
(1, 'Admin', 'consectetur adipisicing elit, Totam mollitia incidunt vero cupiditate obcaecati iusto tempora unde! Numquam officiis, quae adipisci quam laudantium nulla modi. adipisci quam laudantium nulla modi.', '', 'CEO', 0),
(2, 'Admin', 'consectetur adipisicing elit, Totam mollitia incidunt vero cupiditate obcaecati iusto tempora unde! Numquam officiis, quae adipisci quam laudantium nulla modi. adipisci quam laudantium nulla modi.', '', 'Founder & CEO', 0),
(3, 'Admin', 'consectetur adipisicing elit, Totam mollitia incidunt vero cupiditate obcaecati iusto tempora unde! Numquam officiis, quae adipisci quam laudantium nulla modi. adipisci quam laudantium nulla modi.', '', 'Manager', 0);

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `address` varchar(400) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `fb` varchar(199) NOT NULL,
  `instagram` varchar(199) NOT NULL,
  `in` varchar(200) NOT NULL,
  `footerabout` varchar(900) NOT NULL,
  `madeby` varchar(200) NOT NULL,
  `favicon` varchar(500) NOT NULL,
  `owner` varchar(200) NOT NULL,
  `image` varchar(1000) NOT NULL,
  `website` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`id`, `name`, `address`, `email`, `phone`, `fb`, `instagram`, `in`, `footerabout`, `madeby`, `favicon`, `owner`, `image`, `website`) VALUES
(1, 'ASSA Group', '1497, MIE, Part B, Bahadurgarh Haryana - 124507 (India) Haryana - 124105', 'info@assaindia.com', '9999634613', 'https://www.facebook.com/', '#', 'https://www.linkedin.com/company/assaindia/', 'Our company, A S Shoe Accessories Pvt. Ltd., is equipped with highly skilled professionals having more than 30-years of experience in Polyurethane Industry.', 'xcv', 'vcxbvxcb', 'ASSA Group', 'assa-logo.svg', 'http://assaindia.com/');

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

--
-- Table structure for table `enquire`
--

CREATE TABLE `enquire` (
  `id` int(11) NOT NULL,
  `state_id` varchar(20) NOT NULL,
  `test_id` varchar(20) NOT NULL,
  `subtest_id` text NOT NULL,
  `name` varchar(400) NOT NULL,
  `email` varchar(400) NOT NULL,
  `number` varchar(20) NOT NULL,
  `message` varchar(1500) NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `image` varchar(1000) NOT NULL,
  `type` varchar(200) NOT NULL,
  `price` varchar(200) NOT NULL,
  `pname` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `enquire`
--

INSERT INTO `enquire` (`id`, `state_id`, `test_id`, `subtest_id`, `name`, `email`, `number`, `message`, `created`, `image`, `type`, `price`, `pname`) VALUES
(1, '', '', '', 'Zylo Pvt Ltd', 'shivam.softree@gmail.com', '94122825555', 'bncvn', '2021-10-08 16:39:18', '', 'contact', '', ''),
(2, '', '', '', 'Zylo Pvt Ltd', 'shivam.softree@gmail.com', '879897897898', '    gvncvncvn', '2021-10-08 16:39:33', '', 'contact', '', ''),
(3, '', '', '', 'fdvxc', 's@gmail.com', '35', 'asdfvasdf', '2021-10-09 09:43:40', '', 'contact', '', ''),
(4, '', '', '', 'Zylo Pvt Ltd', 'shivam.softree@gmail.com', '9412514555', 'dfvxcvzxc', '2021-10-12 17:21:34', '', 'contact', '', ''),
(5, '', '', '', 'Zylo Pvt Ltd', 'shivam.softree@gmail.com', '9412514555', 'cbxbvxc', '2021-10-12 17:22:15', '', 'contact', '', ''),
(6, '', '', '', 'Zylo Pvt Ltd', 'shivam.softree@gmail.com', '946855644454', 'vbzxcv', '2021-10-12 17:22:48', '', 'contact', '', '');

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

--
-- Table structure for table `industries`
--

CREATE TABLE `industries` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `detail` varchar(1000) NOT NULL,
  `url` varchar(20) NOT NULL,
  `image` varchar(2000) NOT NULL,
  `metatitle` varchar(500) NOT NULL,
  `tag` varchar(2000) NOT NULL,
  `metakeywords` varchar(1500) NOT NULL,
  `metadescription` varchar(1500) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `type` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `industries`
--

INSERT INTO `industries` (`id`, `title`, `detail`, `url`, `image`, `metatitle`, `tag`, `metakeywords`, `metadescription`, `status`, `type`) VALUES
(1, 'dfv', 'xvczvxc', 'fi', 'lotus2.png', 'Welcome To Iitmus Foodanalytics', 'dfsgg--gvdxf--vxzcvxczxvc--xbxcvb', 'Welcome To Iitmus Foodanalytics', 'Welcome To Iitmus Foodanalytics', 0, ''),
(2, 'dfv', 'xvczvxc', 'ci', 'lotus4.png', 'Welcome To Iitmus Foodanalytics', 'dfsgg--gvdxf--vxzcvxczxvc--xbxcvb', 'Welcome To Iitmus Foodanalytics', 'Welcome To Iitmus Foodanalytics', 0, ''),
(3, 'dfv', 'xvczvxc', 'mi', 'lotus6.png', 'Welcome To Iitmus Foodanalytics', 'dfsgg--gvdxf--vxzcvxczxvc--xbxcvb', 'Welcome To Iitmus Foodanalytics', 'Welcome To Iitmus Foodanalytics', 0, ''),
(4, 'dfv', 'xvczvxc', 'ri', 'lotus8.png', 'Welcome To Iitmus Foodanalytics', 'dfsgg--gvdxf--vxzcvxczxvc--xbxcvb', 'Welcome To Iitmus Foodanalytics', 'Welcome To Iitmus Foodanalytics', 0, '');

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

--
-- Table structure for table `industries_image`
--

CREATE TABLE `industries_image` (
  `id` int(11) NOT NULL,
  `industries_id` varchar(10) NOT NULL,
  `file_name` varchar(2000) NOT NULL,
  `status` varchar(20) NOT NULL,
  `created_at` varchar(20) NOT NULL,
  `updated_at` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `industries_image`
--

INSERT INTO `industries_image` (`id`, `industries_id`, `file_name`, `status`, `created_at`, `updated_at`) VALUES
(1, '4', 'lotus9.png', '', '2021-07-06 13:12:25', ''),
(2, '4', 'Untitled_design3.png', '', '2021-07-06 13:12:25', '');

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

--
-- Table structure for table `partner`
--

CREATE TABLE `partner` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `image` varchar(2000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `partner`
--

INSERT INTO `partner` (`id`, `title`, `image`) VALUES
(1, 'Ministry of Environment  and Forest (MOEF) India.', 'Ministry-of-Environment1.png'),
(2, 'Pollution Control Board  (PCB)', 'Pollution-Control-Board.png'),
(3, 'Rajasthan State Pollution  Control Board (RSPCB)', 'Rajasthan-State-Pollution.png'),
(4, 'Udaipur Chamber Of  Commerce Industry (UCCI)', 'Udaipur-Chamber-Of.png'),
(5, 'Certification For Responsible Recycling', 'Certification-For-Responsible.png');

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

--
-- Table structure for table `price`
--

CREATE TABLE `price` (
  `id` int(11) NOT NULL,
  `state_id` varchar(20) NOT NULL,
  `test_id` varchar(20) NOT NULL,
  `subtest_id` varchar(20) NOT NULL,
  `price` varchar(20) NOT NULL,
  `mprice` varchar(20) NOT NULL,
  `type` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `price`
--

INSERT INTO `price` (`id`, `state_id`, `test_id`, `subtest_id`, `price`, `mprice`, `type`) VALUES
(1, '2', '1', '2', '1200', '', 'book-test'),
(2, '2', '1', '3', '4200', '', 'book-test'),
(7, '1', '10', '8', '1000', '1200', 'know-your-test');

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

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `id` int(11) NOT NULL,
  `uploaded_on` varchar(300) NOT NULL,
  `file_name` varchar(200) NOT NULL,
  `project_id` varchar(2000) NOT NULL,
  `file_type` varchar(200) NOT NULL,
  `file_path` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `project`
--

INSERT INTO `project` (`id`, `uploaded_on`, `file_name`, `project_id`, `file_type`, `file_path`) VALUES
(1, '2021-06-12 17:26:49', 'blog-details.jpg', '1', '', ''),
(2, '2021-06-12 17:26:49', 'choose.png', '1', '', ''),
(3, '2021-06-12 17:26:49', 'emergency-bg.jpg', '1', '', ''),
(7, '2021-06-12 17:26:49', 'main-banner-bg.jpg', '1', '', ''),
(8, '2021-06-14 13:24:52', 'Beautiful_Beginnings.png', '2', '', ''),
(9, '2021-06-14 13:24:52', 'Better_Deal_Small.png', '2', '', ''),
(10, '2021-06-14 13:24:52', 'Black_Ink_Tattoos.png', '2', '', ''),
(11, '2021-06-14 13:24:52', 'Blue_Fish_Tales.jpg', '2', '', ''),
(12, '2021-06-14 13:24:52', 'Final-Logo.png', '2', '', ''),
(13, '2021-06-14 14:05:59', 'IMG_2168.JPG', '3', '', ''),
(14, '2021-06-14 14:05:59', 'IMG_2174.JPG', '3', '', ''),
(15, '2021-06-14 14:05:59', 'Picture7.jpg', '3', '', ''),
(16, '2021-06-14 14:05:59', 'Picture9.jpg', '3', '', ''),
(17, '2021-06-14 14:05:59', 'Picture10.jpg', '3', '', ''),
(18, '2021-06-14 14:05:59', 'Picture12.jpg', '3', '', ''),
(19, '2021-06-14 14:05:59', 'Picture13.jpg', '3', '', ''),
(20, '2021-06-14 14:05:59', 'Picture14.jpg', '3', '', ''),
(21, '2021-06-14 14:05:59', 'Picture15.jpg', '3', '', ''),
(22, '2021-06-14 14:05:59', 'Picture16.jpg', '3', '', ''),
(23, '2021-06-14 14:06:34', 'IMG_9995.jpg', '4', '', ''),
(24, '2021-06-14 14:06:34', 'IMG_9998.jpg', '4', '', ''),
(25, '2021-06-14 14:06:34', 'WhatsApp_Image_2021-03-24_at_12_55_17_PM.jpeg', '4', '', ''),
(26, '2021-06-14 14:06:34', 'WhatsApp_Image_2021-03-24_at_12_55_27_PM.jpeg', '4', '', ''),
(27, '2021-06-14 14:07:12', '20190917_1624511.jpg', '5', '', ''),
(28, '2021-06-14 14:07:12', '20190917_162535.jpg', '5', '', ''),
(29, '2021-06-14 14:07:12', '20190917_162540.jpg', '5', '', ''),
(30, '2021-06-14 14:07:12', '20190917_162602.jpg', '5', '', ''),
(31, '2021-06-14 14:07:12', '20190917_162606.jpg', '5', '', ''),
(32, '2021-06-14 14:07:12', '20190917_162641.jpg', '5', '', ''),
(33, '2021-06-14 14:07:12', '20190917_162700.jpg', '5', '', ''),
(34, '2021-06-14 14:07:12', '20190917_162810.jpg', '5', '', ''),
(35, '2021-06-14 14:07:12', '20190917_162835.jpg', '5', '', ''),
(36, '2021-06-14 14:07:12', '20190917_162846.jpg', '5', '', ''),
(37, '2021-06-14 14:07:12', '20190917_162904.jpg', '5', '', ''),
(38, '2021-06-14 14:07:12', '20190917_162938.jpg', '5', '', ''),
(39, '2021-06-14 14:07:12', '20190917_162956.jpg', '5', '', ''),
(40, '2021-06-14 14:07:12', 'Picture4.jpg', '5', '', ''),
(41, '2021-06-14 14:07:12', 'Picture98.png', '5', '', ''),
(42, '2021-06-14 14:07:52', 'IMG_2460.JPG', '6', '', ''),
(43, '2021-06-14 14:07:52', 'IMG_2920.JPG', '6', '', ''),
(44, '2021-06-14 14:07:52', 'IMG_6599.JPG', '6', '', ''),
(45, '2021-06-14 14:07:52', 'IMG_6605.JPG', '6', '', ''),
(46, '2021-06-14 14:07:52', 'IMG_20180323_122343.jpg', '6', '', ''),
(47, '2021-06-14 14:08:33', 'Picture24.jpg', '7', '', ''),
(48, '2021-06-14 14:08:33', 'Picture25.jpg', '7', '', ''),
(49, '2021-06-14 14:08:33', 'Picture26.jpg', '7', '', ''),
(50, '2021-06-14 14:08:33', 'Picture27.jpg', '7', '', ''),
(51, '2021-06-14 14:08:33', 'Picture28.jpg', '7', '', ''),
(52, '2021-06-14 14:08:33', 'Picture29.jpg', '7', '', ''),
(53, '2021-06-14 14:08:33', 'Picture30.jpg', '7', '', ''),
(54, '2021-06-14 14:08:33', 'Picture31.jpg', '7', '', ''),
(55, '2021-06-14 14:08:33', 'Picture32.jpg', '7', '', ''),
(56, '2021-06-14 14:08:33', 'Picture33.jpg', '7', '', ''),
(57, '2021-06-14 14:08:33', 'Picture34.jpg', '7', '', ''),
(58, '2021-06-14 14:08:33', 'Picture35.jpg', '7', '', ''),
(59, '2021-06-14 14:08:33', 'Picture36.jpg', '7', '', ''),
(60, '2021-06-14 14:08:33', 'Picture37.jpg', '7', '', ''),
(61, '2021-06-14 14:08:33', 'Picture38.jpg', '7', '', ''),
(62, '2021-06-14 14:08:33', 'Picture39.jpg', '7', '', ''),
(63, '2021-06-14 14:08:33', 'Picture40.jpg', '7', '', ''),
(64, '2021-06-14 14:08:33', 'Picture41.jpg', '7', '', ''),
(65, '2021-06-14 14:08:33', 'Picture42.jpg', '7', '', ''),
(66, '2021-06-14 14:09:25', 'IMG_20190718_144658.jpg', '8', '', ''),
(67, '2021-06-14 14:09:25', 'IMG_20190826_160434.jpg', '8', '', ''),
(68, '2021-06-14 14:09:25', 'IMG_20190826_160545.jpg', '8', '', ''),
(69, '2021-06-14 14:09:25', 'WhatsApp_Image_2020-02-17_at_4_55_12_PM_(1)1.jpeg', '8', '', ''),
(70, '2021-06-14 14:09:25', 'WhatsApp_Image_2020-02-17_at_4_55_12_PM_(2).jpeg', '8', '', ''),
(71, '2021-06-14 14:09:25', 'WhatsApp_Image_2020-02-17_at_4_55_12_PM.jpeg', '8', '', ''),
(72, '2021-06-14 14:09:25', 'WhatsApp_Image_2021-03-24_at_1_53_57_PM_(1).jpeg', '8', '', ''),
(73, '2021-06-14 14:09:25', 'WhatsApp_Image_2021-03-24_at_1_53_57_PM_(2).jpeg', '8', '', ''),
(74, '2021-06-14 14:09:25', 'WhatsApp_Image_2021-03-24_at_1_53_57_PM_(3).jpeg', '8', '', ''),
(75, '2021-06-14 14:09:25', 'WhatsApp_Image_2021-03-24_at_1_53_57_PM.jpeg', '8', '', ''),
(76, '2021-06-14 14:09:56', 'IMG_9870.jpg', '9', '', ''),
(77, '2021-06-14 14:09:56', 'Picture1.png', '9', '', ''),
(78, '2021-06-14 14:09:56', 'Picture43.jpg', '9', '', ''),
(79, '2021-06-14 14:09:56', 'Picture44.jpg', '9', '', ''),
(80, '2021-06-14 14:09:56', 'Picture45.jpg', '9', '', ''),
(81, '2021-06-14 14:09:56', 'Picture46.png', '9', '', ''),
(82, '2021-06-14 14:09:56', 'Picture47.jpg', '9', '', ''),
(83, '2021-06-14 14:09:56', 'Picture80.jpg', '9', '', ''),
(84, '2021-06-14 14:10:32', 'Picture100.png', '10', '', ''),
(85, '2021-06-14 14:10:32', 'Picture101.jpg', '10', '', ''),
(86, '2021-06-14 14:10:32', 'Picture102.jpg', '10', '', ''),
(87, '2021-06-14 14:10:32', 'Picture103.png', '10', '', ''),
(88, '2021-06-14 14:11:06', 'Picture1.jpg', '11', '', ''),
(89, '2021-06-14 14:11:06', 'Picture2.png', '11', '', ''),
(90, '2021-06-14 14:11:06', 'Picture3.png', '11', '', ''),
(91, '2021-06-14 14:11:43', 'Picture6.png', '12', '', ''),
(92, '2021-06-14 14:11:43', 'Picture53.jpg', '12', '', ''),
(93, '2021-06-14 14:11:43', 'Picture54.jpg', '12', '', ''),
(94, '2021-06-14 14:11:43', 'Picture55.jpg', '12', '', ''),
(95, '2021-06-14 14:11:43', 'Picture92.jpg', '12', '', ''),
(96, '2021-06-14 14:11:43', 'Picture99.jpg', '12', '', ''),
(97, '2021-06-14 14:11:43', 'Picture123.png', '12', '', ''),
(98, '2021-06-14 14:11:43', 'Picture125.png', '12', '', ''),
(99, '2021-06-14 14:11:43', 'Picture126.png', '12', '', ''),
(100, '2021-06-14 14:11:43', 'Picture127.png', '12', '', ''),
(101, '2021-06-14 14:11:43', 'Picture128.png', '12', '', ''),
(102, '2021-06-14 14:11:43', 'Picture129.png', '12', '', ''),
(103, '2021-06-14 14:12:10', 'Picture77.png', '13', '', ''),
(104, '2021-06-14 14:12:10', 'Picture78.png', '13', '', ''),
(105, '2021-06-14 14:12:10', 'Picture79.png', '13', '', ''),
(106, '2021-06-14 14:12:40', 'IMG_0840.jpg', '14', '', ''),
(107, '2021-06-14 14:12:40', 'IMG_0851.jpg', '14', '', ''),
(108, '2021-06-14 14:12:40', 'WhatsApp_Image_2021-03-24_at_3_20_16_PM_(1).jpeg', '14', '', ''),
(109, '2021-06-14 14:12:40', 'WhatsApp_Image_2021-03-24_at_3_20_16_PM.jpeg', '14', '', ''),
(110, '2021-06-14 14:13:12', 'Picture118.jpg', '15', '', ''),
(111, '2021-06-14 14:13:12', 'Picture1191.jpg', '15', '', ''),
(112, '2021-06-14 14:13:12', 'Picture120.jpg', '15', '', ''),
(113, '2021-06-14 14:13:12', 'Picture121.jpg', '15', '', ''),
(114, '2021-06-14 14:13:12', 'Picture122.jpg', '15', '', ''),
(115, '2021-06-14 14:13:39', 'Picture50.jpg', '16', '', ''),
(116, '2021-06-14 14:13:39', 'Picture51.jpg', '16', '', ''),
(117, '2021-06-14 14:13:39', 'Picture52.jpg', '16', '', ''),
(118, '2021-06-14 14:14:06', 'Picture46.jpg', '17', '', ''),
(119, '2021-06-14 14:14:06', 'Picture5.png', '17', '', ''),
(120, '2021-06-14 14:14:06', 'Picture6.jpg', '17', '', ''),
(121, '2021-06-14 14:14:39', 'Picture48.jpg', '18', '', ''),
(122, '2021-06-14 14:14:39', 'Picture49.jpg', '18', '', ''),
(123, '2021-06-14 14:15:06', 'IMG_20210317_174353.jpg', '19', '', ''),
(124, '2021-06-14 14:15:06', 'IMG_20210318_001019.jpg', '19', '', ''),
(125, '2021-06-14 14:15:06', 'Picture70.jpg', '19', '', ''),
(126, '2021-06-14 14:15:06', 'Picture71.jpg', '19', '', ''),
(127, '2021-06-14 14:15:06', 'Picture72.jpg', '19', '', ''),
(128, '2021-06-14 14:15:38', 'Picture66.png', '20', '', ''),
(129, '2021-06-14 14:15:38', 'Picture67.png', '20', '', ''),
(130, '2021-06-14 14:15:38', 'Picture68.png', '20', '', ''),
(131, '2021-06-14 14:15:38', 'Picture69.png', '20', '', ''),
(132, '2021-06-14 14:15:38', 'Picture90.jpg', '20', '', ''),
(133, '2021-06-14 14:15:38', 'Picture91.jpg', '20', '', ''),
(134, '2021-06-14 14:15:38', 'Picture109.png', '20', '', ''),
(135, '2021-06-14 14:15:38', 'Picture110.png', '20', '', ''),
(136, '2021-06-14 14:15:38', 'Picture111.jpg', '20', '', ''),
(137, '2021-06-14 14:15:38', 's.jpg', '20', '', ''),
(138, '2021-06-14 14:16:15', 'Picture88.jpg', '21', '', ''),
(139, '2021-06-14 14:16:15', 'Picture89.jpg', '21', '', ''),
(140, '2021-06-14 14:16:15', 'Picture124.jpg', '21', '', ''),
(141, '2021-06-14 14:16:44', 'Picture87.png', '22', '', '');

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

--
-- Table structure for table `seo`
--

CREATE TABLE `seo` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `detail` varchar(1000) NOT NULL,
  `keyword` varchar(1000) NOT NULL,
  `page` varchar(100) NOT NULL,
  `image` varchar(5000) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `seo`
--

INSERT INTO `seo` (`id`, `title`, `detail`, `keyword`, `page`, `image`, `status`) VALUES
(1, 'Vision', 'ASSA GROUP aims to build a self-sustaining business organisation, thriving for growth for every Individual and Company as a whole. We aim towards Technical Excellence, Product Leadership, Business Ethics and Team building.', 'Mobile App & Website Development Company In Gurgaon', 'Our Vision', '04.jpg', 0),
(2, 'Mission', 'ASSA GROUP aims to establish itself as India’s leading supplier of polyester polyols, PU systems, and PU specialties through a solid commitment to consistent efforts towards innovation, consistency and customer intimacy.<br>Our mission has been to identify potential markets and cater to different market needs with our impeccable research team and equipped with the necessary machinery and subject expertise to manufacture high quality polyurethanes and polyester polyols.', 'Mobile App & Website Development Company In Gurgaon', 'Our Mission', 'mission.jpg', 0),
(3, 'Why Choose Us?', 'We assure guaranteed quality, not only with our core products, but also with our product packaging, technical support, competitive pricing, and nationwide distribution network. We Assure our following commitments:', 'Mobile App & Website Development Company In Gurgaon', 'Why Us?', 'why-us-800x400.jpg', 0),
(4, 'Quality Management Standards', 'We have a very efficient quality management system. Adhering to the quality code of conduct, the company ensures top notch quality of the products. We have streamlined our operations, and sourced our raw materials only from verified and trusted vendors. Each stage in the process is monitored and inspected to avoid any kind of rework. The final product is matched with the company set standards and is then rolled into the market.', 'Mobile App & Website Development Company In Gurgaon', 'Quality Management', 'automotive-neu_small.jpeg', 0),
(5, 'Having a monthly production capacity of more than 900 metric tonnes', 'Appropriate attention is given to the quality of raw material used, the reaction conditions, and the proportions of the reactants. The company’s monthly production capacity is 900 metric tonne. We also provide custom tailored products to our customers, according to their requirements and applications.', 'v', 'Manufacturing Capability', 'manufacturing.jpg', 0);

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `detail` mediumtext NOT NULL,
  `image` varchar(2000) NOT NULL,
  `designation` varchar(1000) NOT NULL,
  `date` varchar(200) NOT NULL,
  `url` varchar(200) NOT NULL,
  `metatitle` varchar(500) NOT NULL,
  `metakeywords` varchar(1000) NOT NULL,
  `metadescription` varchar(1000) NOT NULL,
  `faqa` varchar(1500) NOT NULL,
  `faqq` varchar(2000) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `detail` varchar(1000) NOT NULL,
  `image` varchar(2000) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `title`, `detail`, `image`, `status`) VALUES
(9, 'Welcome to ASSA Group.', 'Our company, A S Shoe Accessories Pvt. Ltd., is equipped with highly skilled professionals having more than 30-years of experience in Polyurethane Industry. ASSA Group is one of the leading manufacturers of Polyurethane System, Pigments, Lacquers, Varnish and Release Agents for Polyurethanes, shoe finishing chemicals and chemicals for leather industries.', '6.jpg', '0'),
(12, 'Welcome to ASSA Group', 'Our company, A S Shoe Accessories Pvt. Ltd., is equipped with highly skilled professionals having more than 30-years of experience in Polyurethane Industry. ASSA Group is one of the leading manufacturers of Polyurethane System, Pigments, Lacquers, Varnish and Release Agents for Polyurethanes, shoe finishing chemicals and chemicals for leather industries.', '7.jpg', '0'),
(14, 'Welcome to ASSA Group.', 'Our company, A S Shoe Accessories Pvt. Ltd., is equipped with highly skilled professionals having more than 30-years of experience in Polyurethane Industry. ASSA Group is one of the leading manufacturers of Polyurethane System, Pigments, Lacquers, Varnish and Release Agents for Polyurethanes, shoe finishing chemicals and chemicals for leather industries.', '8.jpg', '0'),
(15, 'Welcome to ASSA Group.', 'Our company, A S Shoe Accessories Pvt. Ltd., is equipped with highly skilled professionals having more than 30-years of experience in Polyurethane Industry. ASSA Group is one of the leading manufacturers of Polyurethane System, Pigments, Lacquers, Varnish and Release Agents for Polyurethanes, shoe finishing chemicals and chemicals for leather industries.', '9.jpg', '0');

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

--
-- Table structure for table `state`
--

CREATE TABLE `state` (
  `id` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `url` varchar(200) NOT NULL,
  `image` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `state`
--

INSERT INTO `state` (`id`, `name`, `url`, `image`) VALUES
(1, ' Form-2 Facilitation', 'andhra-pradesh', 'Picture11.png'),
(2, ' Form-6/Form-10', 'arunachal-pradesh', 'Picture2.png'),
(3, 'Green Certificate', 'assam', 'Picture3.png'),
(4, 'ESI', 'tamil-nadu', 'Picture4.png'),
(5, 'EPF', '', 'Picture5.png'),
(6, 'Group Insurance', '', 'Picture6.png'),
(7, 'SOP Driven  Processes', '', 'Picture7.png'),
(8, 'Safety, Health and  Environment', '', 'Picture15png3.png');

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

--
-- Table structure for table `subtest`
--

CREATE TABLE `subtest` (
  `id` int(11) NOT NULL,
  `cat_id` varchar(20) NOT NULL,
  `title` varchar(300) NOT NULL,
  `detail` varchar(3000) NOT NULL,
  `url` varchar(200) NOT NULL,
  `image` varchar(3000) NOT NULL,
  `metatitle` varchar(1000) NOT NULL,
  `metadescription` varchar(1000) NOT NULL,
  `metakeywords` varchar(1000) NOT NULL,
  `tag` varchar(5000) NOT NULL,
  `faqa` varchar(1500) NOT NULL,
  `type` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `subtest`
--

INSERT INTO `subtest` (`id`, `cat_id`, `title`, `detail`, `url`, `image`, `metatitle`, `metadescription`, `metakeywords`, `tag`, `faqa`, `type`) VALUES
(2, '1', 'Dairy products', 'Ahen an unknown printer took a galley of type and scrambled it to make a type specimen book areIt hasear survived not only five centuries', 'dairy-products', 'fg.png', 'Best PPC Management Service & Company in Gurgaon', 'Best PPC Management Service & Company in Gurgaon', 'Best PPC Management Service & Company in Gurgaon', '', '', 'book-test'),
(3, '1', 'Fats and oils', 'Ahen an unknown printer took a galley of type and scrambled it to make a type specimen book areIt hasear survived not only five centuries', 'fats-and-oils', 'DietDoctor_Monosaturatedfats.jpg', 'Best PPC Management Service & Company in Gurgaon', 'Best PPC Management Service & Company in Gurgaon', 'Best PPC Management Service & Company in Gurgaon', '', '', 'book-test'),
(8, '10', 'Milk and dairy-based drinks', 'Our passion for science and innovation along with our customer’s dreams and ambitions have pushed our limits to a distinct place of commitment.\r\nWe deal with areas that impact our senses and everyday life in the form of food. A food business consultancy, who have transitioned from working in a confined industry to exploring all the food sectors and their requisites.', 'milk-and-dairy-based-drinks', 'sad1.jpg', 'Welcome To Iitmus Foodanalytics', 'Welcome To Iitmus Foodanalytics', 'Welcome To Iitmus Foodanalytics', 'Milk fat--Milk solid not fat (SNF)--Urea', 'Aerobic plate count--Coliform--Staphylococcus aureus--Yeast and mold--E.coli--Salmonella--Listeria monocytogene', 'know-your-test');

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

--
-- Table structure for table `team`
--

CREATE TABLE `team` (
  `id` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `designation` varchar(300) NOT NULL,
  `detail` varchar(2000) NOT NULL,
  `image` varchar(2000) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `team`
--

INSERT INTO `team` (`id`, `title`, `designation`, `detail`, `image`, `status`) VALUES
(4, 'Rakesh Kumar Rastogi', 'Founder & Chairman, ASSA Group', ' Education: M. Tech. from HBTI, Kanpur Diploma in Project Management from Punjab University, Patiala Born to a Lower middle class family, Shri Rakesh Kumar Rastogi aspired to set up a business legacy. His prudent management skills, dedication, Hard-work, Compassion for his team and Self Sacrifice led to the establishment of ASSA Group.', 'founder.jpg', 0),
(5, 'Chinmoy Bose', 'Managing Director, A S Shoe Accessories Private Limited', 'Education: B.Tech Electronics and Telecommunications from VSSUT ( Veer Surendra Sai University of Technology). A Highly skilled Professional of Polyurethane Industry, A great Mentor and an Excellent Friend. Joined ASSA in 1992 and since then, he has been Pioneering ASSA in the field of Polyurethanes. Serving as Managing director of A S Shoe Accessories Private Limited since 2012. ', 'founder1.jpg', 0),
(6, 'Ashish Rastogi', 'Director, A S Shoe Accessories Private Limited', 'Education: Bachelor of Engineering, Polymer Science and Chemical Technology Delhi College of Engineering (Now Delhi Technological University) Joined his company in 2013 after completing his graduation. Since then he has been tirelessly involved in streamlining the business operations. He played a pivotal role in establishment of the new PU manufacturing facility in Barhi and currently working as the Executive Head of the company.', 'founder2.jpg', 0);

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

--
-- Table structure for table `test`
--

CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `detail` longtext NOT NULL,
  `url` varchar(300) NOT NULL,
  `image` varchar(2000) NOT NULL,
  `metatitle` varchar(1000) NOT NULL,
  `metakeywords` varchar(2000) NOT NULL,
  `metadescription` varchar(2000) NOT NULL,
  `faqa` varchar(3000) NOT NULL,
  `faqq` varchar(2000) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `type` varchar(200) NOT NULL,
  `designation` varchar(3000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`id`, `title`, `detail`, `url`, `image`, `metatitle`, `metakeywords`, `metadescription`, `faqa`, `faqq`, `status`, `type`, `designation`) VALUES
(17, 'Polyurethane System for Footwear', '<span id=\"docs-internal-guid-86a7b127-7fff-1bf7-b307-297ea3cc77c8\"><p class=\"font-italic\" style=\"margin-bottom: 1rem; color: rgb(68, 68, 68); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 16px;\">We specialize in Polyurethane systems for various Footwear applications, namely PU DIP slippers, Open Sandals, Safety shoes, Unit Soles for Gents/ Ladies Footwear. Our systems have been designed to achieve:</p><ol style=\"margin-bottom: 1rem; color: rgb(68, 68, 68); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 16px;\"><li><i class=\"ri-check-double-line\"></i>Excellent Flexural Resistance.</li><li><i class=\"ri-check-double-line\"></i>Excellent Abrasion Resistance.</li><li><i class=\"ri-check-double-line\"></i>Anti-Hydrolysis/ Anti-Ageing Properties</li><li><i class=\"ri-check-double-line\"></i>Excellent surface Finishes</li><li><i class=\"ri-check-double-line\"></i>Ease in Production</li></ol></span>', 'polyurethane-system-for-footwear', 'as-pu.jpg', 'Welcome to ASSA Group.', 'Welcome to ASSA Group.', 'Welcome to ASSA Group.', '', '', 0, 'book-test', 'We specialize in Polyurethane systems for various Footwear applications, namely PU DIP slippers, Open Sandals, Safety shoes, Unit Soles for Gents/ Ladies Footwear. Our systems have been designed to achieve'),
(18, 'Auxiliary Chemicals for Polyurethanes', '<span id=\"docs-internal-guid-b84622d3-7fff-b83e-356e-ad62a0bb1834\"><p class=\"font-italic\" style=\"margin-bottom: 1rem; color: rgb(68, 68, 68); font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" font-size:=\"\" 16px;\"=\"\">Auxiliary Chemicals are equally important as Polyurethane system since they impact the final outcome, look and feel of the finished product. ASSA has been committed to Provide consistent and quality Auxiliaries for the past 25 years to its customers:</p><ul style=\"margin-bottom: 1rem; color: rgb(68, 68, 68); font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" font-size:=\"\" 16px;\"=\"\"><li><i class=\"ri-check-double-line\"></i>Polyurethane Colorants</li><li><i class=\"ri-check-double-line\"></i>Mould release agents</li></ul></span>', 'auxiliary-chemicals-for-polyurethanes', 'as-ac.jpg', 'Welcome to ASSA Group.', 'Welcome to ASSA Group.', 'Welcome to ASSA Group.', '', '', 0, 'book-test', 'Auxiliary Chemicals are equally important as Polyurethane system since they impact the final outcome, look and feel of the finished product. ASSA has been committed to Provide consistent and quality Auxiliaries for the past 25 years to its customers'),
(19, 'Leather Finishing Chemicals and Solid Waxes', '<span id=\"docs-internal-guid-e37002d7-7fff-1b4e-1b96-bf31eb69faa6\"><p class=\"font-italic\" style=\"margin-bottom: 1rem; color: rgb(68, 68, 68); font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" font-size:=\"\" 16px;=\"\" font-style:=\"\" italic=\"\" !important;\"=\"\">ASSA is an agent for an Italian Companies “<span style=\"font-weight: bolder;\">Industrie Chimiche Rindi S.p.A, Italy</span>” to provide high quality Leather Finishes and Solid Waxes. Along with this we have developed our in-house products to match customer requirements. Given below details of imported and in-house products:</p><ul style=\"margin-bottom: 1rem; color: rgb(68, 68, 68); font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" font-size:=\"\" 16px;\"=\"\"><li><i class=\"ri-check-double-line\"></i>Self-Shine and Brushable Creams</li><li><i class=\"ri-check-double-line\"></i>Products for Leather Goods for Edge Coloring</li><li><i class=\"ri-check-double-line\"></i>Solid Waxes</li></ul></span>', 'leather-finishing-chemicals-and-solid-waxes', 'red-landing-page.jpg', 'Welcome to ASSA Group.', 'Welcome to ASSA Group.', 'Welcome to ASSA Group.', 'On our asset management system, all the assets are categorized broadly like It assets, non-IT assets, software, groups, etc. You can create the product type and list as per the products you have and fill in the fields for identifying a product whenever it is added to the list. The details of the vendor can be added which will include vendor name, warranty period, price, etc. --With asset management in the service desk model, you can make informed decisions and manage the IT service desk software. Keeping track of all the assets hardware and software will be easy. The service desk model has been made in a thoughtful way. It is packed with incredible features to scan the assets. For importing the assets barcode scans, network scans and other important help will be provided. The tickets raised can be tracked as well that will mention all kinds of problems, change management and other important details related to a certain issue. --', 'Scan and discover the assets to manage and monitor them--Make informed business decisions using the service desk model--Grouping the assets and managing them', 0, 'book-test', 'ASSA is an agent for an Italian Companies “Industrie Chimiche Rindi S.p.A, Italy” to provide high quality Leather Finishes and Solid Waxes. Along with this we have developed our in-house products to match customer requirements. Given below details of imported and in-house products'),
(25, 'Automatic PU Rotary Machine for PU Soles/Slippers', '<p class=\"font-italic\" style=\"margin-bottom: 1rem; color: rgb(68, 68, 68); font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" font-size:=\"\" 16px;\"=\"\">Introducing Automatic PU Rotary Machine for Indian Market. Economically priced with Superb Quality &amp; Service !</p><h4 style=\"margin-top: 0px; margin-bottom: 0.5rem; line-height: 1.2; font-size: 1.5rem; font-family: Raleway, sans-serif; color: rgb(68, 68, 68);\">ADVANTAGES</h4><ul style=\"margin-bottom: 1rem; color: rgb(68, 68, 68); font-family: \" open=\"\" sans\",=\"\" sans-serif;=\"\" font-size:=\"\" 16px;\"=\"\"><li>Latest PLC Controlled Technology</li><li>Properly controlled Mould and Tank temperatures for quality production</li><li>High productivity and efficiency with minimum rejection</li><li>Less labour involvement and lower power consumption per unit of finished Goods</li><li>Technical support by Professionals having more than 20 years experience in</li><li>Polyurethane footwear industry</li><li>Easy availability of Spare Parts at economical Prices.</li></ul>', 'automatic-pu-rotary-machine', 'as-pm.jpg', 'Welcome to ASSA Group.', 'Welcome to ASSA Group.', 'Welcome to ASSA Group.', '', '', 0, 'book-test', 'Introducing Automatic PU Rotary Machine for Indian Market. Economically priced with Superb Quality & Service !<br><br>');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `test`
--
ALTER TABLE `test`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
COMMIT;

