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

START TRANSACTION;



--
-- Database: `ideabang_app20`
--

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

--
-- Table structure for table `address`
--

CREATE TABLE `address` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `house` text NOT NULL,
  `landmark` varchar(200) NOT NULL,
  `pincode` varchar(200) NOT NULL,
  `lat` text NOT NULL,
  `lng` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `cover` text NOT NULL,
  `position` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `type` varchar(200) NOT NULL,
  `message` text NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `cover` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `chat_message`
--

CREATE TABLE `chat_message` (
  `id` int(11) NOT NULL,
  `room_id` text NOT NULL,
  `uid` text NOT NULL,
  `from_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `message_type` varchar(20) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `chat_room`
--

CREATE TABLE `chat_room` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `participants` text NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(11) NOT NULL,
  `lat` text NOT NULL,
  `lng` text NOT NULL,
  `name` text NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `message` text NOT NULL,
  `date` date NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `favourite`
--

CREATE TABLE `favourite` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `ids` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `general`
--

CREATE TABLE `general` (
  `id` int(11) NOT NULL,
  `mobile` text NOT NULL,
  `email` text NOT NULL,
  `address` text NOT NULL,
  `city` text NOT NULL,
  `state` text NOT NULL,
  `zip` int(11) NOT NULL,
  `country` text NOT NULL,
  `min` float(10,2) NOT NULL,
  `free` float(10,2) NOT NULL,
  `tax` float(10,2) NOT NULL,
  `shipping` text NOT NULL,
  `shippingPrice` float(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `lang`
--

CREATE TABLE `lang` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `cover` text NOT NULL,
  `file` text NOT NULL,
  `is_default` tinyint(4) NOT NULL,
  `positions` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `url` text NOT NULL,
  `agent` text NOT NULL,
  `datetime` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `url`, `agent`, `datetime`) VALUES
(7, 'users/adminHome', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en;q=0.9,en-US;q=0.8\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.67 Safari\\/537.36 Edg\\/87.0.664.55\"}', '2020-12-06 12:52:08'),
(8, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en;q=0.9,en-US;q=0.8\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.67 Safari\\/537.36 Edg\\/87.0.664.55\"}', '2020-12-06 12:52:14'),
(9, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"ci_session=oevikfnjvirea9vtk5p723j798t94tiq\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.66 Safari\\/537.36\"}', '2020-12-06 12:53:17'),
(10, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"_ga=GA1.2.1990277462.1605507598; _gid=GA1.2.1912158212.1607331936; _gat_gtag_UA_25459653_14=1\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:83.0) Gecko\\/20100101 Firefox\\/83.0\"}', '2020-12-07 09:12:04'),
(11, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.66 Safari\\/537.36\"}', '2020-12-08 06:25:05'),
(12, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en;q=0.9,en-US;q=0.8\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36 Edg\\/87.0.664.66\"}', '2020-12-18 04:16:52'),
(13, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Cache-Control\":\"no-cache\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Pragma\":\"no-cache\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\"}', '2020-12-19 08:12:44'),
(14, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Cache-Control\":\"no-cache\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Pragma\":\"no-cache\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\"}', '2020-12-19 08:12:44'),
(15, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"_ga=GA1.2.1990277462.1605507598\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:84.0) Gecko\\/20100101 Firefox\\/84.0\"}', '2021-01-03 05:33:59'),
(16, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"_ga=GA1.2.1990277462.1605507598; ci_session=9h71k599rfo69s1oqeu0o459pm4icdl2\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:84.0) Gecko\\/20100101 Firefox\\/84.0\"}', '2021-01-03 05:34:13'),
(17, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en;q=0.9,en-US;q=0.8\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36 Edg\\/87.0.664.66\"}', '2021-01-04 10:53:27'),
(18, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"_ga=GA1.2.1990277462.1605507598\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:84.0) Gecko\\/20100101 Firefox\\/84.0\"}', '2021-01-09 05:30:04'),
(19, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36\"}', '2021-01-10 01:54:16'),
(20, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"ci_session=cv0evskcjr80h8nanlncjvq4b84a5ppp\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36\"}', '2021-01-10 01:54:31'),
(21, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"ci_session=cv0evskcjr80h8nanlncjvq4b84a5ppp\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36\"}', '2021-01-10 01:54:36'),
(22, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36\"}', '2021-01-10 01:56:01'),
(23, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36\"}', '2021-01-10 01:56:01'),
(24, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36\"}', '2021-01-10 06:47:51'),
(25, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36\"}', '2021-01-10 06:49:39'),
(26, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.88 Safari\\/537.36\"}', '2021-01-10 06:49:39'),
(27, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:84.0) Gecko\\/20100101 Firefox\\/84.0\"}', '2021-01-28 08:25:12'),
(28, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:84.0) Gecko\\/20100101 Firefox\\/84.0\"}', '2021-01-28 08:25:12'),
(29, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Safari\\/537.36\"}', '2021-01-28 01:05:53'),
(30, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/87.0.4280.141 Safari\\/537.36\"}', '2021-01-28 01:05:53'),
(31, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Cache-Control\":\"no-cache\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Pragma\":\"no-cache\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\"}', '2021-02-03 06:22:40'),
(32, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Cache-Control\":\"no-cache\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Pragma\":\"no-cache\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\"}', '2021-02-03 06:22:40'),
(33, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/88.0.4324.104 Safari\\/537.36\"}', '2021-02-06 10:48:04'),
(34, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/88.0.4324.104 Safari\\/537.36\"}', '2021-02-06 10:48:04'),
(35, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:85.0) Gecko\\/20100101 Firefox\\/85.0\"}', '2021-02-07 11:17:04'),
(36, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:85.0) Gecko\\/20100101 Firefox\\/85.0\"}', '2021-02-07 11:17:04'),
(37, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:85.0) Gecko\\/20100101 Firefox\\/85.0\"}', '2021-02-07 11:19:53'),
(38, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:85.0) Gecko\\/20100101 Firefox\\/85.0\"}', '2021-02-07 11:19:53'),
(39, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"_ga=GA1.2.1990277462.1605507598; _gid=GA1.2.1738203745.1612690973\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:85.0) Gecko\\/20100101 Firefox\\/85.0\"}', '2021-02-07 11:22:48'),
(40, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Cookie\":\"_ga=GA1.2.1815061596.1614519361; _gid=GA1.2.116619944.1615374274\",\"Host\":\"app20.ideabangla.com\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; Win64; x64; rv:86.0) Gecko\\/20100101 Firefox\\/86.0\"}', '2021-03-10 01:08:21'),
(41, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Cache-Control\":\"no-cache\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Pragma\":\"no-cache\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\"}', '2021-06-06 04:21:59'),
(42, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Cache-Control\":\"no-cache\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Pragma\":\"no-cache\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\"}', '2021-06-06 04:21:59'),
(43, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Cache-Control\":\"no-cache\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Pragma\":\"no-cache\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\"}', '2021-08-07 06:01:07'),
(44, 'users/get_admin', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Encoding\":\"gzip, deflate\",\"Accept-Language\":\"en-US,en;q=0.9\",\"Basic\":\"749384\",\"Cache-Control\":\"no-cache\",\"Connection\":\"keep-alive\",\"Host\":\"app20.ideabangla.com\",\"Origin\":\"http:\\/\\/app-20adminpanel.ideabangla.com\",\"Pragma\":\"no-cache\",\"Referer\":\"http:\\/\\/app-20adminpanel.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\"}', '2021-08-07 06:01:07'),
(45, 'users/get_admin', '{\"Host\":\"app20.ideabangla.com\",\"Connection\":\"keep-alive\",\"Pragma\":\"no-cache\",\"Cache-Control\":\"no-cache\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Basic\":\"749384\",\"Accept-Language\":\"en-US,en;q=0.9\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\",\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Origin\":\"http:\\/\\/www.app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/www.app-20adminpanel.ideabangla.com\\/\",\"Accept-Encoding\":\"gzip, deflate\",\"Content-Length\":\"0\"}', '2022-08-10 04:22:47'),
(46, 'users/get_admin', '{\"Host\":\"app20.ideabangla.com\",\"Connection\":\"keep-alive\",\"Pragma\":\"no-cache\",\"Cache-Control\":\"no-cache\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Basic\":\"749384\",\"Accept-Language\":\"en-US,en;q=0.9\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\",\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Origin\":\"http:\\/\\/www.app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/www.app-20adminpanel.ideabangla.com\\/\",\"Accept-Encoding\":\"gzip, deflate\",\"Content-Length\":\"0\"}', '2022-08-10 04:22:47'),
(47, 'cities', '{\"Host\":\"app20.ideabangla.com\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; rv:103.0) Gecko\\/20100101 Firefox\\/103.0\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Accept-Encoding\":\"gzip, deflate\",\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"Cookie\":\"_ga=GA1.2.139114662.1660014909; bfp_sn_rf_b10ce94cf299b167b74a6944e0aec9d4=Direct; bfp_sn_rt_b10ce94cf299b167b74a6944e0aec9d4=1660219676851; bafp=4155ea80-196e-11ed-9be2-a957df32a463\",\"Content-Length\":\"0\"}', '2022-08-16 01:52:18'),
(48, 'cities', '{\"Host\":\"app20.ideabangla.com\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 6.1; rv:103.0) Gecko\\/20100101 Firefox\\/103.0\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Accept-Encoding\":\"gzip, deflate\",\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Basic\":\"749384\",\"Connection\":\"keep-alive\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"Cookie\":\"_ga=GA1.2.139114662.1660014909; bfp_sn_rf_b10ce94cf299b167b74a6944e0aec9d4=Direct; bfp_sn_rt_b10ce94cf299b167b74a6944e0aec9d4=1660219676851; bafp=4155ea80-196e-11ed-9be2-a957df32a463; ci_session=83997252a31e4e9f2c1b06990a55c9a4326aa347\",\"Content-Length\":\"0\"}', '2022-08-16 01:53:47'),
(49, 'cities', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Basic\":\"749384\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Referer\":\"http:\\/\\/app20.ideabangla.com\\/\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko; compatible; BW\\/1.1; bit.ly\\/2W6Px8S; 60ec7e0ae5) Chrome\\/84.0.4147.105 Safari\\/537.36\",\"Accept-Language\":\"en\",\"Accept-Encoding\":\"gzip, deflate\",\"Host\":\"app20.ideabangla.com\",\"Connection\":\"keep-alive\",\"Content-Length\":\"0\"}', '2022-09-06 05:50:11'),
(50, 'users/get_admin', '{\"Host\":\"app20.ideabangla.com\",\"Connection\":\"keep-alive\",\"Pragma\":\"no-cache\",\"Cache-Control\":\"no-cache\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Basic\":\"749384\",\"Accept-Language\":\"en-US,en;q=0.9\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\",\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Origin\":\"http:\\/\\/www.app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/www.app-20adminpanel.ideabangla.com\\/\",\"Accept-Encoding\":\"gzip, deflate\"}', '2022-10-10 05:49:16'),
(51, 'users/get_admin', '{\"Host\":\"app20.ideabangla.com\",\"Connection\":\"keep-alive\",\"Pragma\":\"no-cache\",\"Cache-Control\":\"no-cache\",\"Accept\":\"application\\/json, text\\/plain, *\\/*\",\"Basic\":\"749384\",\"Accept-Language\":\"en-US,en;q=0.9\",\"User-Agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/76.0.3809.71 Safari\\/537.36\",\"Content-Type\":\"application\\/x-www-form-urlencoded\",\"Origin\":\"http:\\/\\/www.app-20adminpanel.ideabangla.com\",\"Referer\":\"http:\\/\\/www.app-20adminpanel.ideabangla.com\\/\",\"Accept-Encoding\":\"gzip, deflate\"}', '2022-10-10 05:49:16');

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

--
-- Table structure for table `manage`
--

CREATE TABLE `manage` (
  `id` int(11) NOT NULL,
  `app_close` tinyint(4) NOT NULL,
  `message` text NOT NULL,
  `date_time` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `manage`
--

INSERT INTO `manage` (`id`, `app_close`, `message`, `date_time`) VALUES
(1, 1, '', '2020-09-16 12:39:20');

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

--
-- Table structure for table `offers`
--

CREATE TABLE `offers` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `off` varchar(200) NOT NULL,
  `type` varchar(200) NOT NULL,
  `upto` int(11) NOT NULL,
  `min` int(11) NOT NULL,
  `date_time` datetime NOT NULL,
  `descriptions` text NOT NULL,
  `image` varchar(200) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `store_id` text NOT NULL,
  `date_time` datetime NOT NULL,
  `paid_method` text NOT NULL,
  `order_to` varchar(200) NOT NULL,
  `orders` text NOT NULL,
  `notes` text NOT NULL,
  `address` text NOT NULL,
  `driver_id` text NOT NULL,
  `assignee` text NOT NULL,
  `total` double(10,2) NOT NULL,
  `tax` double(10,2) NOT NULL,
  `grand_total` double(10,2) NOT NULL,
  `delivery_charge` double(10,2) NOT NULL,
  `coupon_code` text NOT NULL,
  `discount` double(10,2) NOT NULL,
  `pay_key` text NOT NULL,
  `status` varchar(200) NOT NULL COMMENT 'created, accepted, ongoing ,picked, rejected, cancelled, delivered, refund,'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `content` text NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `name`, `content`, `status`) VALUES
(1, 'About Us', '<h2><strong>About us</strong></h2>\n\n<p>groceryee is a store primarily engaged in retailing a general range of food products, with fresh and packaged groceries.</p>\n\n<p>groceryee&nbsp;is your low price online store where you get the latest products from Patanjali, Aashirvaad, Saffola, Fortune, Nestle, Amul, Mother Dairy, Pepsi, Colgate, Dabur, Surf Excel, Maggi, Vim, Haldiram&#39;s and Pampers amongst other leading brands.</p>\n\n<p>Hygienically Packed &amp; Safely Delivered at your doorstep by our delivery partners. Experience Lower Prices across Products with Safe Delivery at your doorstep. Shop Now! Offers on Fruit Cleaners. Up to 64% off on Atta. Up To 50% off Detergents.</p>\n\n<p>hoose from a wide range of&nbsp;<em>grocery</em>, baby care products, personal care products, fresh fruits &amp; vegetables online. Pay Online.</p>\n\n<p>Buy <em>Groceryee</em>&nbsp;Online at Best Price. Shop from Paytm Mall Mall Online Supermarket which includes Food Range, Home care, Personal Care, Pet Supplies..</p>\n\n<p>Nature&#39;s Basket is an online supermarket &amp;&nbsp;<em>grocery</em>&nbsp;store offering the best online food &amp;&nbsp;<em>grocery</em>&nbsp;shopping experience in India at best prices. Buy daily food&nbsp;..</p>\n\n<p>Buy in bulk online with Boxed. Shop wholesale products such as&nbsp;<em>groceries</em>, household products, and health supplies. Get delivery service right to your door.</p>\n', 1),
(2, 'Privacy', '<h1>Privacy Policy for initappz</h1>\n\n<p>At Groceryee, accessible from https://initappz.com, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by Groceryee and how we use it.</p>\n\n<p>If you have additional questions or require more information about our Privacy Policy, do not hesitate to contact us.</p>\n\n<p>This Privacy Policy applies only to our online activities and is valid for visitors to our website with regards to the information that they shared and/or collect in Groceryee. This policy is not applicable to any information collected offline or via channels other than this website.</p>\n\n<h2>Consent</h2>\n\n<p>By using our website, you hereby consent to our Privacy Policy and agree to its terms.</p>\n\n<h2>Information we collect</h2>\n\n<p>The personal information that you are asked to provide, and the reasons why you are asked to provide it, will be made clear to you at the point we ask you to provide your personal information.</p>\n\n<p>If you contact us directly, we may receive additional information about you such as your name, email address, phone number, the contents of the message and/or attachments you may send us, and any other information you may choose to provide.</p>\n\n<p>When you register for an Account, we may ask for your contact information, including items such as name, company name, address, email address, and telephone number.</p>\n\n<h2>How we use your information</h2>\n\n<p>We use the information we collect in various ways, including to:</p>\n\n<ul>\n	<li>Provide, operate, and maintain our webste</li>\n	<li>Improve, personalize, and expand our webste</li>\n	<li>Understand and analyze how you use our webste</li>\n	<li>Develop new products, services, features, and functionality</li>\n	<li>Communicate with you, either directly or through one of our partners, including for customer service, to provide you with updates and other information relating to the webste, and for marketing and promotional purposes</li>\n	<li>Send you emails</li>\n	<li>Find and prevent fraud</li>\n</ul>\n\n<h2>Log Files</h2>\n\n<p>Groceryee follows a standard procedure of using log files. These files log visitors when they visit websites. All hosting companies do this and a part of hosting services&#39; analytics. The information collected by log files include internet protocol (IP) addresses, browser type, Internet Service Provider (ISP), date and time stamp, referring/exit pages, and possibly the number of clicks. These are not linked to any information that is personally identifiable. The purpose of the information is for analyzing trends, administering the site, tracking users&#39; movement on the website, and gathering demographic information. Our Privacy Policy was created with the help of the&nbsp;<a href=\"https://www.privacypolicygenerator.info/\">Privacy Policy Generator</a>&nbsp;and the&nbsp;<a href=\"https://www.privacypolicyonline.com/privacy-policy-generator/\">Online Privacy Policy Generator</a>.</p>\n\n<h2>Cookies and Web Beacons</h2>\n\n<p>Like any other website, Groceryee uses &#39;cookies&#39;. These cookies are used to store information including visitors&#39; preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users&#39; experience by customizing our web page content based on visitors&#39; browser type and/or other information.</p>\n\n<p>For more general information on cookies, please read&nbsp;<a href=\"https://www.cookieconsent.com/what-are-cookies/\">&quot;What Are Cookies&quot;</a>.</p>\n\n<h2>Advertising Partners Privacy Policies</h2>\n\n<p>You may consult this list to find the Privacy Policy for each of the advertising partners of Groceryee.</p>\n\n<p>Third-party ad servers or ad networks uses technologies like cookies, JavaScript, or Web Beacons that are used in their respective advertisements and links that appear on Groceryee, which are sent directly to users&#39; browser. They automatically receive your IP address when this occurs. These technologies are used to measure the effectiveness of their advertising campaigns and/or to personalize the advertising content that you see on websites that you visit.</p>\n\n<p>Note that Groceryee has no access to or control over these cookies that are used by third-party advertisers.</p>\n\n<h2>Third Party Privacy Policies</h2>\n\n<p>Groceryee&#39;s Privacy Policy does not apply to other advertisers or websites. Thus, we are advising you to consult the respective Privacy Policies of these third-party ad servers for more detailed information. It may include their practices and instructions about how to opt-out of certain options.</p>\n\n<p>You can choose to disable cookies through your individual browser options. To know more detailed information about cookie management with specific web browsers, it can be found at the browsers&#39; respective websites.</p>\n\n<h2>CCPA Privacy Rights (Do Not Sell My Personal Information)</h2>\n\n<p>Under the CCPA, among other rights, California consumers have the right to:</p>\n\n<p>Request that a business that collects a consumer&#39;s personal data disclose the categories and specific pieces of personal data that a business has collected about consumers.</p>\n\n<p>Request that a business delete any personal data about the consumer that a business has collected.</p>\n\n<p>Request that a business that sells a consumer&#39;s personal data, not sell the consumer&#39;s personal data.</p>\n\n<p>If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.</p>\n\n<h2>GDPR Data Protection Rights</h2>\n\n<p>We would like to make sure you are fully aware of all of your data protection rights. Every user is entitled to the following:</p>\n\n<p>The right to access &acirc;&euro;&ldquo; You have the right to request copies of your personal data. We may charge you a small fee for this service.</p>\n\n<p>The right to rectification &acirc;&euro;&ldquo; You have the right to request that we correct any information you believe is inaccurate. You also have the right to request that we complete the information you believe is incomplete.</p>\n\n<p>The right to erasure &acirc;&euro;&ldquo; You have the right to request that we erase your personal data, under certain conditions.</p>\n\n<p>The right to restrict processing &acirc;&euro;&ldquo; You have the right to request that we restrict the processing of your personal data, under certain conditions.</p>\n\n<p>The right to object to processing &acirc;&euro;&ldquo; You have the right to object to our processing of your personal data, under certain conditions.</p>\n\n<p>The right to data portability &acirc;&euro;&ldquo; You have the right to request that we transfer the data that we have collected to another organization, or directly to you, under certain conditions.</p>\n\n<p>If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.</p>\n\n<h2>Children&#39;s Information</h2>\n\n<p>Another part of our priority is adding protection for children while using the internet. We encourage parents and guardians to observe, participate in, and/or monitor and guide their online activity.</p>\n\n<p>Groceryee does not knowingly collect any Personal Identifiable Information from children under the age of 13. If you think that your child provided this kind of information on our website, we strongly encourage you to contact us immediately and we will do our best efforts to promptly remove such information from our records.</p>\n', 1),
(3, 'Terms & Conditions', '<p>&lt;h2&gt;&lt;strong&gt;Terms and Conditions&lt;/strong&gt;&lt;/h2&gt;</p>\n\n<p>&lt;p&gt;Welcome to Initappz!&lt;/p&gt;</p>\n\n<p>&lt;p&gt;These terms and conditions outline the rules and regulations for the use of Groceryee&#39;s Website, located at https//initappz.com.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;By accessing this website we assume you accept these terms and conditions. Do not continue to use Initappz if you do not agree to take all of the terms and conditions stated on this page.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;The following terminology applies to these Terms and Conditions, Privacy Statement and Disclaimer Notice and all Agreements: &quot;Client&quot;, &quot;You&quot; and &quot;Your&quot; refers to you, the person log on this website and compliant to the Company&rsquo;s terms and conditions. &quot;The Company&quot;, &quot;Ourselves&quot;, &quot;We&quot;, &quot;Our&quot; and &quot;Us&quot;, refers to our Company. &quot;Party&quot;, &quot;Parties&quot;, or &quot;Us&quot;, refers to both the Client and ourselves. All terms refer to the offer, acceptance and consideration of payment necessary to undertake the process of our assistance to the Client in the most appropriate manner for the express purpose of meeting the Client&rsquo;s needs in respect of provision of the Company&rsquo;s stated services, in accordance with and subject to, prevailing law of Netherlands. Any use of the above terminology or other words in the singular, plural, capitalization and/or he/she or they, are taken as interchangeable and therefore as referring to same.&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;Cookies&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;We employ the use of cookies. By accessing Initappz, you agreed to use cookies in agreement with the Groceryee&#39;s Privacy Policy. &lt;/p&gt;</p>\n\n<p>&lt;p&gt;Most interactive websites use cookies to let us retrieve the user&rsquo;s details for each visit. Cookies are used by our website to enable the functionality of certain areas to make it easier for people visiting our website. Some of our affiliate/advertising partners may also use cookies.&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;License&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;Unless otherwise stated, Groceryee and/or its licensors own the intellectual property rights for all material on Initappz. All intellectual property rights are reserved. You may access this from Initappz for your own personal use subjected to restrictions set in these terms and conditions.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;You must not:&lt;/p&gt;<br />\n&lt;ul&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;Republish material from Initappz&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;Sell, rent or sub-license material from Initappz&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;Reproduce, duplicate or copy material from Initappz&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;Redistribute content from Initappz&lt;/li&gt;<br />\n&lt;/ul&gt;</p>\n\n<p>&lt;p&gt;This Agreement shall begin on the date hereof. Our Terms and Conditions were created with the help of the &lt;a href=&quot;https://www.termsandconditionsgenerator.com&quot;&gt;Terms And Conditions Generator&lt;/a&gt; and the &lt;a href=&quot;https://www.generateprivacypolicy.com&quot;&gt;Privacy Policy Generator&lt;/a&gt;.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;Parts of this website offer an opportunity for users to post and exchange opinions and information in certain areas of the website. Groceryee does not filter, edit, publish or review Comments prior to their presence on the website. Comments do not reflect the views and opinions of Groceryee,its agents and/or affiliates. Comments reflect the views and opinions of the person who post their views and opinions. To the extent permitted by applicable laws, Groceryee shall not be liable for the Comments or for any liability, damages or expenses caused and/or suffered as a result of any use of and/or posting of and/or appearance of the Comments on this website.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;Groceryee reserves the right to monitor all Comments and to remove any Comments which can be considered inappropriate, offensive or causes breach of these Terms and Conditions.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;You warrant and represent that:&lt;/p&gt;</p>\n\n<p>&lt;ul&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;You are entitled to post the Comments on our website and have all necessary licenses and consents to do so;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;The Comments do not invade any intellectual property right, including without limitation copyright, patent or trademark of any third party;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;The Comments do not contain any defamatory, libelous, offensive, indecent or otherwise unlawful material which is an invasion of privacy&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;The Comments will not be used to solicit or promote business or custom or present commercial activities or unlawful activity.&lt;/li&gt;<br />\n&lt;/ul&gt;</p>\n\n<p>&lt;p&gt;You hereby grant Groceryee a non-exclusive license to use, reproduce, edit and authorize others to use, reproduce and edit any of your Comments in any and all forms, formats or media.&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;Hyperlinking to our Content&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;The following organizations may link to our Website without prior written approval:&lt;/p&gt;</p>\n\n<p>&lt;ul&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;Government agencies;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;Search engines;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;News organizations;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;Online directory distributors may link to our Website in the same manner as they hyperlink to the Websites of other listed businesses; and&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;System wide Accredited Businesses except soliciting non-profit organizations, charity shopping malls, and charity fundraising groups which may not hyperlink to our Web site.&lt;/li&gt;<br />\n&lt;/ul&gt;</p>\n\n<p>&lt;p&gt;These organizations may link to our home page, to publications or to other Website information so long as the link: (a) is not in any way deceptive; (b) does not falsely imply sponsorship, endorsement or approval of the linking party and its products and/or services; and (c) fits within the context of the linking party&rsquo;s site.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;We may consider and approve other link requests from the following types of organizations:&lt;/p&gt;</p>\n\n<p>&lt;ul&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;commonly-known consumer and/or business information sources;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;dot.com community sites;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;associations or other groups representing charities;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;online directory distributors;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;internet portals;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;accounting, law and consulting firms; and&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;educational institutions and trade associations.&lt;/li&gt;<br />\n&lt;/ul&gt;</p>\n\n<p>&lt;p&gt;We will approve link requests from these organizations if we decide that: (a) the link would not make us look unfavorably to ourselves or to our accredited businesses; (b) the organization does not have any negative records with us; (c) the benefit to us from the visibility of the hyperlink compensates the absence of Groceryee; and (d) the link is in the context of general resource information.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;These organizations may link to our home page so long as the link: (a) is not in any way deceptive; (b) does not falsely imply sponsorship, endorsement or approval of the linking party and its products or services; and (c) fits within the context of the linking party&rsquo;s site.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;If you are one of the organizations listed in paragraph 2 above and are interested in linking to our website, you must inform us by sending an e-mail to Groceryee. Please include your name, your organization name, contact information as well as the URL of your site, a list of any URLs from which you intend to link to our Website, and a list of the URLs on our site to which you would like to link. Wait 2-3 weeks for a response.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;Approved organizations may hyperlink to our Website as follows:&lt;/p&gt;</p>\n\n<p>&lt;ul&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;By use of our corporate name; or&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;By use of the uniform resource locator being linked to; or&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;By use of any other description of our Website being linked to that makes sense within the context and format of content on the linking party&rsquo;s site.&lt;/li&gt;<br />\n&lt;/ul&gt;</p>\n\n<p>&lt;p&gt;No use of Groceryee&#39;s logo or other artwork will be allowed for linking absent a trademark license agreement.&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;iFrames&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;Without prior approval and written permission, you may not create frames around our Webpages that alter in any way the visual presentation or appearance of our Website.&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;Content Liability&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;We shall not be hold responsible for any content that appears on your Website. You agree to protect and defend us against all claims that is rising on your Website. No link(s) should appear on any Website that may be interpreted as libelous, obscene or criminal, or which infringes, otherwise violates, or advocates the infringement or other violation of, any third party rights.&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;Your Privacy&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;Please read Privacy Policy&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;Reservation of Rights&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;We reserve the right to request that you remove all links or any particular link to our Website. You approve to immediately remove all links to our Website upon request. We also reserve the right to amen these terms and conditions and it&rsquo;s linking policy at any time. By continuously linking to our Website, you agree to be bound to and follow these linking terms and conditions.&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;Removal of links from our website&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;If you find any link on our Website that is offensive for any reason, you are free to contact and inform us any moment. We will consider requests to remove links but we are not obligated to or so or to respond to you directly.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;We do not ensure that the information on this website is correct, we do not warrant its completeness or accuracy; nor do we promise to ensure that the website remains available or that the material on the website is kept up to date.&lt;/p&gt;</p>\n\n<p>&lt;h3&gt;&lt;strong&gt;Disclaimer&lt;/strong&gt;&lt;/h3&gt;</p>\n\n<p>&lt;p&gt;To the maximum extent permitted by applicable law, we exclude all representations, warranties and conditions relating to our website and the use of this website. Nothing in this disclaimer will:&lt;/p&gt;</p>\n\n<p>&lt;ul&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;limit or exclude our or your liability for death or personal injury;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;limit or exclude our or your liability for fraud or fraudulent misrepresentation;&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;limit any of our or your liabilities in any way that is not permitted under applicable law; or&lt;/li&gt;<br />\n&nbsp; &nbsp; &lt;li&gt;exclude any of our or your liabilities that may not be excluded under applicable law.&lt;/li&gt;<br />\n&lt;/ul&gt;</p>\n\n<p>&lt;p&gt;The limitations and prohibitions of liability set in this Section and elsewhere in this disclaimer: (a) are subject to the preceding paragraph; and (b) govern all liabilities arising under the disclaimer, including liabilities arising in contract, in tort and for breach of statutory duty.&lt;/p&gt;</p>\n\n<p>&lt;p&gt;As long as the website and the information and services on the website are provided free of charge, we will not be liable for any loss or damage of any nature.&lt;/p&gt;</p>\n', 1),
(4, 'Refund Policy', '<pre>\nRefund policy We&#39;re so convinced you&#39;ll absolutely love our products,\nthat we&#39;re willing to offer a 60 day risk-free money back guarantee.\nIf you are not satisfied with the product for any reason you can get a refund within 60 days of making a purchase.\nContacting us If you have any questions about our refund policy, please contact us. \nThis document was last updated on September 11, 2020\n</pre>\n', 1),
(5, 'Frequently Asked Questions', '<p><strong>Q: How should I format my tutorial proposal submission?</strong></p>\n\n<p>A: Each tutorial submission must present its course information through the SC submissions website, where a form will collect basic information (the tutorial&rsquo;s title, length, presenter information, and keywords). A sample form is available at the submissions website. Further details about the proposal, such as goals, targeted audience, and outline, should be written in a PDF and uploaded as an attachment to the submission form. The format for the PDF is documented in the How to Submit section of the submissions website. Submitters are particularly encouraged to include a draft of their full tutorial presentation in the Sample of Visual Material section of the submission form.</p>\n\n<p><strong>Q: Can I make changes to my tutorial materials after I have submitted them?</strong></p>\n\n<p>A: Tutorial presenters are generally expected to use the material submitted, with no changes. Minor extensions may be granted to enable a presenter to include more timely material, or to comply with conditions beyond the presenter&rsquo;s control (e.g., new decisions adopted by standards bodies). In such cases, the submitted material should be as close to a final version as possible, and clearly indicate where changes are anticipated. Also, the deadline for the submission of the material is only one week before the tutorial, so no major updates are expected.<br />\nChanges requested because a presenter had insufficient time to prepare and submit their materials cannot be accommodated.</p>\n\n<p><strong>Q: What are the expectations of tutorial presentations at the conference?</strong></p>\n\n<p>A: SC Tutorials are some of the most popular sessions at the conference, attracting several thousand participants. Tutorial abstracts must clearly present what lessons can be learned, and tutorial presenters are expected to deliver professional presentations and to treat tutorial attendees with respect. Each tutorial will be evaluated in detail by attendees after the session, and these evaluations will play a crucial role in the evaluation of future-year tutorial submissions.</p>\n\n<p><strong>Q: Q: Is the peer-review process double-blind?</strong></p>\n\n<p>A: No. Reviewers have access to the names of tutorial submitters. While Tutorials Committee members are named on the SC19 Planning Committee page, the names of the individuals reviewing each proposal are not made available to the authors.</p>\n\n<p><strong>Q: What are the guidelines for conflicts of interest (COI)?</strong></p>\n\n<p>A: A potential conflict of interest occurs when a person is involved in making a decision that:</p>\n\n<ol>\n	<li>\n	<p>Could result in that person, a close associate of that person, or that person&rsquo;s company or institution receiving significant financial gain, such as a contract or grant.</p>\n	</li>\n	<li>\n	<p>Could result in that person, or a close associate of that person, receiving significant professional recognition, such as an award or the selection of a paper, work, exhibit, or other type of submitted presentation.</p>\n	</li>\n</ol>\n\n<p>Authors and Tutorials Committee members will be given the opportunity to list any potential COIs during the submissions and review processes, respectively. The Tutorials Committee Chair will make every effort to avoid assignments that have a potential COI.</p>\n\n<p>According to the SC Conference you have a conflict of interest with:</p>\n\n<ul>\n	<li>Your PhD advisors, post-doctoral advisors, PhD students, and post-doctoral advisees forever;</li>\n	<li>Family relations by blood or marriage, or equivalent (e.g., a partner);</li>\n	<li>People with whom you collaborated in the past five years. Collaborators include: co-authors on an accepted/rejected/pending research paper; co-PIs on an accepted/pending grant; those who fund your research; researchers whom you fund; or researchers with whom you are actively collaborating;</li>\n	<li>Close personal friends or others with whom you believe a conflict of interest exists;</li>\n	<li>People who were employed by, or a student at, your primary institution(s) in the past five years, or people who are active candidates for employment at your primary institution(s).</li>\n</ul>\n\n<p>Note that &ldquo;service&rdquo; collaborations, such as writing a DOE, NSF, or DARPA report, or serving on a program committee, or serving on the editorial board of a journal do not inherently create a COI.</p>\n\n<p><strong>Q: What rooms and audio/video infrastructure are provided to each tutorial?</strong></p>\n\n<p>A: Tutorials are assigned either a classroom or theater room equipped with standard AV facilities (projector, microphone and podium, wireless lapel microphone or wireless handheld microphone, and projection screen).</p>\n\n<p><strong>Q: Will tutorials&rsquo; material be provided in a USB?</strong></p>\n\n<p>A: No. Tutorials&rsquo; materials will be available for download in a password protected repository.</p>\n', 1),
(6, 'Help', '<p><strong>Q: How should I format my tutorial proposal submission?</strong></p>\n\n<p>A: Each tutorial submission must present its course information through the SC submissions website, where a form will collect basic information (the tutorial&rsquo;s title, length, presenter information, and keywords). A sample form is available at the submissions website. Further details about the proposal, such as goals, targeted audience, and outline, should be written in a PDF and uploaded as an attachment to the submission form. The format for the PDF is documented in the How to Submit section of the submissions website. Submitters are particularly encouraged to include a draft of their full tutorial presentation in the Sample of Visual Material section of the submission form.</p>\n\n<p><strong>Q: Can I make changes to my tutorial materials after I have submitted them?</strong></p>\n\n<p>A: Tutorial presenters are generally expected to use the material submitted, with no changes. Minor extensions may be granted to enable a presenter to include more timely material, or to comply with conditions beyond the presenter&rsquo;s control (e.g., new decisions adopted by standards bodies). In such cases, the submitted material should be as close to a final version as possible, and clearly indicate where changes are anticipated. Also, the deadline for the submission of the material is only one week before the tutorial, so no major updates are expected.<br />\nChanges requested because a presenter had insufficient time to prepare and submit their materials cannot be accommodated.</p>\n\n<p><strong>Q: What are the expectations of tutorial presentations at the conference?</strong></p>\n\n<p>A: SC Tutorials are some of the most popular sessions at the conference, attracting several thousand participants. Tutorial abstracts must clearly present what lessons can be learned, and tutorial presenters are expected to deliver professional presentations and to treat tutorial attendees with respect. Each tutorial will be evaluated in detail by attendees after the session, and these evaluations will play a crucial role in the evaluation of future-year tutorial submissions.</p>\n\n<p><strong>Q: Q: Is the peer-review process double-blind?</strong></p>\n\n<p>A: No. Reviewers have access to the names of tutorial submitters. While Tutorials Committee members are named on the SC19 Planning Committee page, the names of the individuals reviewing each proposal are not made available to the authors.</p>\n\n<p><strong>Q: What are the guidelines for conflicts of interest (COI)?</strong></p>\n\n<p>A: A potential conflict of interest occurs when a person is involved in making a decision that:</p>\n\n<ol>\n	<li>\n	<p>Could result in that person, a close associate of that person, or that person&rsquo;s company or institution receiving significant financial gain, such as a contract or grant.</p>\n	</li>\n	<li>\n	<p>Could result in that person, or a close associate of that person, receiving significant professional recognition, such as an award or the selection of a paper, work, exhibit, or other type of submitted presentation.</p>\n	</li>\n</ol>\n\n<p>Authors and Tutorials Committee members will be given the opportunity to list any potential COIs during the submissions and review processes, respectively. The Tutorials Committee Chair will make every effort to avoid assignments that have a potential COI.</p>\n\n<p>According to the SC Conference you have a conflict of interest with:</p>\n\n<ul>\n	<li>Your PhD advisors, post-doctoral advisors, PhD students, and post-doctoral advisees forever;</li>\n	<li>Family relations by blood or marriage, or equivalent (e.g., a partner);</li>\n	<li>People with whom you collaborated in the past five years. Collaborators include: co-authors on an accepted/rejected/pending research paper; co-PIs on an accepted/pending grant; those who fund your research; researchers whom you fund; or researchers with whom you are actively collaborating;</li>\n	<li>Close personal friends or others with whom you believe a conflict of interest exists;</li>\n	<li>People who were employed by, or a student at, your primary institution(s) in the past five years, or people who are active candidates for employment at your primary institution(s).</li>\n</ul>\n\n<p>Note that &ldquo;service&rdquo; collaborations, such as writing a DOE, NSF, or DARPA report, or serving on a program committee, or serving on the editorial board of a journal do not inherently create a COI.</p>\n\n<p><strong>Q: What rooms and audio/video infrastructure are provided to each tutorial?</strong></p>\n\n<p>A: Tutorials are assigned either a classroom or theater room equipped with standard AV facilities (projector, microphone and podium, wireless lapel microphone or wireless handheld microphone, and projection screen).</p>\n\n<p><strong>Q: Will tutorials&rsquo; material be provided in a USB?</strong></p>\n\n<p>A: No. Tutorials&rsquo; materials will be available for download in a password protected repository.</p>\n', 1);

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

--
-- Table structure for table `popup`
--

CREATE TABLE `popup` (
  `id` int(11) NOT NULL,
  `shown` tinyint(4) NOT NULL,
  `message` text NOT NULL,
  `date_time` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `popup`
--

INSERT INTO `popup` (`id`, `shown`, `message`, `date_time`) VALUES
(1, 1, 'Get upto 30% off on fruits and free delivery over 100$ purchase', '2020-09-03 10:16:84');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `cover` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `images` text NOT NULL,
  `original_price` double(10,2) NOT NULL,
  `sell_price` double(10,2) NOT NULL,
  `discount` int(11) NOT NULL,
  `kind` tinyint(4) NOT NULL COMMENT '1-veg/0-non-veg',
  `cate_id` int(11) NOT NULL,
  `sub_cate_id` int(11) NOT NULL,
  `in_home` tinyint(4) NOT NULL,
  `is_single` tinyint(4) NOT NULL,
  `have_gram` tinyint(4) NOT NULL,
  `gram` varchar(200) NOT NULL,
  `have_kg` tinyint(4) NOT NULL,
  `kg` varchar(200) NOT NULL,
  `have_pcs` tinyint(4) NOT NULL,
  `pcs` varchar(200) NOT NULL,
  `have_liter` tinyint(4) NOT NULL,
  `liter` varchar(200) NOT NULL,
  `have_ml` tinyint(4) NOT NULL,
  `ml` varchar(200) NOT NULL,
  `descriptions` text NOT NULL,
  `key_features` text NOT NULL,
  `disclaimer` text NOT NULL,
  `exp_date` date NOT NULL,
  `type_of` int(11) NOT NULL,
  `in_stoke` tinyint(4) NOT NULL,
  `rating` int(11) NOT NULL,
  `total_rating` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `in_offer` tinyint(4) NOT NULL,
  `variations` text DEFAULT NULL,
  `size` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `did` int(11) NOT NULL,
  `sid` int(11) NOT NULL,
  `rate` int(11) NOT NULL,
  `msg` text NOT NULL,
  `way` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  `timestamp` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `store`
--

CREATE TABLE `store` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `lat` text NOT NULL,
  `lng` text NOT NULL,
  `verified` tinyint(4) NOT NULL,
  `address` text NOT NULL,
  `descriptions` text NOT NULL,
  `images` text NOT NULL,
  `cover` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  `commission` double NOT NULL DEFAULT 5,
  `open_time` time NOT NULL,
  `close_time` time NOT NULL,
  `isClosed` tinyint(4) NOT NULL,
  `certificate_url` varchar(255) NOT NULL,
  `certificate_type` varchar(255) NOT NULL,
  `rating` float NOT NULL,
  `total_rating` int(11) NOT NULL,
  `cid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `sub_category`
--

CREATE TABLE `sub_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `cover` varchar(255) NOT NULL,
  `cate_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `chat_message`
--
ALTER TABLE `chat_message`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reciver_id` (`from_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `address`
--
ALTER TABLE `address`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chat_message`
--
ALTER TABLE `chat_message`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chat_room`
--
ALTER TABLE `chat_room`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `favourite`
--
ALTER TABLE `favourite`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `general`
--
ALTER TABLE `general`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `offers`
--
ALTER TABLE `offers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rating`
--
ALTER TABLE `rating`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `store`
--
ALTER TABLE `store`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sub_category`
--
ALTER TABLE `sub_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

