--
-- Host: localhost    Database: assarbbq_sylcon
-- ------------------------------------------------------

/*!50717 SELECT COUNT(*) INTO @rocksdb_has_p_s_session_variables FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema' AND TABLE_NAME = 'session_variables' */;
/*!50717 PREPARE s FROM @rocksdb_get_is_supported */;
/*!50717 EXECUTE s */;
/*!50717 DEALLOCATE PREPARE s */;
/*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */;
/*!50717 EXECUTE s */;
/*!50717 DEALLOCATE PREPARE s */;

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

CREATE TABLE `enquiry` (
  `custname` text NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` int(11) NOT NULL,
  `sort` int(11) NOT NULL,
  `date` text NOT NULL,
  `post` date NOT NULL,
  `taste` enum('Good','Average','Bad') NOT NULL,
  `portion` enum('Good','Average','Bad') NOT NULL,
  `phone` text NOT NULL,
  `dish` text NOT NULL,
  `service` enum('Good','Average','Bad') NOT NULL,
  `remark` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=latin1;

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

INSERT INTO `enquiry` VALUES ('Test',171,0,0,'December 24, 2021, 7:33 PM','0000-00-00','Good','Average','05426232996','Hjj','Good',''),('Test',189,1,0,'December 30, 2021, 7:04 PM','0000-00-00','Bad','Bad','9072573333',', , , ','Bad','Vvvb'),('aijo',190,1,0,'December 30, 2021, 7:04 PM','0000-00-00','Average','Average','1234567890','d1, d2, d3, d4','Average','vergvregv'),('Test',191,1,0,'December 30, 2021, 7:10 PM','0000-00-00','Bad','Good','9072573333',', , , ','Average','T'),('Ina Hunter',192,1,0,'January 4, 2022, 5:18 PM','0000-00-00','Bad','Bad','+1 (667) 775-1464','Ipsa quo perspiciat, Occaecat animi id l, Magni alias sit qui , Itaque praesentium c','Good','Accusantium saepe se'),('Sinaj',193,1,0,'January 5, 2022, 6:32 AM','0000-00-00','Average','Bad','9847983448','1, 2, 3, 4','Good','Good'),('Dino',194,0,0,'January 5, 2022, 8:47 AM','0000-00-00','Good','Bad','9847731912','Porotta, Kozhi, Appam, Chicken','Average','Thanks'),('Rahul',195,0,0,'January 5, 2022, 11:34 AM','0000-00-00','Good','Good','9020688828','Crispy fried chicken, , , ','Good','Ok'),('Hhhh',196,1,0,'January 5, 2022, 11:41 AM','0000-00-00','Good','Average','9999999999',', , , ','Average','K'),('Midhun',197,1,0,'January 5, 2022, 4:34 PM','0000-00-00','','','9633577599',', , , ','',''),('Midhun',198,0,0,'January 5, 2022, 4:37 PM','0000-00-00','Good','Good','9633577599',', , , ','Good','good'),('Test new',199,1,0,'January 5, 2022, 5:02 PM','0000-00-00','Bad','Good','9009999999','Gg, , , ','Good','Bb'),('jo',200,1,0,'January 13, 2022, 9:24 AM','0000-00-00','Good','Good','1234567890','dw, wdws, wdws, ','Good','asdewd'),('Dino',201,1,0,'January 13, 2022, 9:55 AM','0000-00-00','Average','Bad','9847731912',', , , ','Good','F'),('Binu',202,1,0,'January 13, 2022, 10:33 AM','0000-00-00','Good','Good','8075341677','Gjmm, , , ','Bad','Bhj'),('Y',203,1,0,'January 16, 2022, 9:57 PM','0000-00-00','Good','Average','9645205305',', , , ','Average','H');

--
-- Table structure for table `rating_type`
--

CREATE TABLE `rating_type` (
  `id` int(200) NOT NULL AUTO_INCREMENT,
  `type` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rating_type`
--

INSERT INTO `rating_type` VALUES (1,'Good'),(2,'Average'),(3,'Bad');
/*!50112 PREPARE s FROM @disable_bulk_load */;
/*!50112 EXECUTE s */;
/*!50112 DEALLOCATE PREPARE s */;


