-- MySQL dump 10.13 Distrib 5.7.23-23, for Linux (x86_64) -- -- Host: localhost Database: assarbbq_sylcon -- ------------------------------------------------------ -- Server version 5.7.23-23 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*!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 SET @rocksdb_get_is_supported = IF (@rocksdb_has_p_s_session_variables, 'SELECT COUNT(*) INTO @rocksdb_is_supported FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'rocksdb_bulk_load\'', 'SELECT 0') */; /*!50717 PREPARE s FROM @rocksdb_get_is_supported */; /*!50717 EXECUTE s */; /*!50717 DEALLOCATE PREPARE s */; /*!50717 SET @rocksdb_enable_bulk_load = IF (@rocksdb_is_supported, 'SET SESSION rocksdb_bulk_load = 1', 'SET @rocksdb_dummy_bulk_load = 0') */; /*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */; /*!50717 EXECUTE s */; /*!50717 DEALLOCATE PREPARE s */; -- -- Table structure for table `admin` -- DROP TABLE IF EXISTS `admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_name` text NOT NULL, `password` text NOT NULL, `name` text NOT NULL, `role` text NOT NULL, `email` text NOT NULL, `date` text NOT NULL, `image` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admin` -- LOCK TABLES `admin` WRITE; /*!40000 ALTER TABLE `admin` DISABLE KEYS */; INSERT INTO `admin` VALUES (1,'sylcon','sylcon','SYLCON','','admin@gmail.com','','1640344419logo2.png'); /*!40000 ALTER TABLE `admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `enquiry` -- DROP TABLE IF EXISTS `enquiry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `enquiry` -- LOCK TABLES `enquiry` WRITE; /*!40000 ALTER TABLE `enquiry` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `enquiry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rating_type` -- DROP TABLE IF EXISTS `rating_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rating_type` -- LOCK TABLES `rating_type` WRITE; /*!40000 ALTER TABLE `rating_type` DISABLE KEYS */; INSERT INTO `rating_type` VALUES (1,'Good'),(2,'Average'),(3,'Bad'); /*!40000 ALTER TABLE `rating_type` ENABLE KEYS */; UNLOCK TABLES; /*!50112 SET @disable_bulk_load = IF (@is_rocksdb_supported, 'SET SESSION rocksdb_bulk_load = @old_rocksdb_bulk_load', 'SET @dummy_rocksdb_bulk_load = 0') */; /*!50112 PREPARE s FROM @disable_bulk_load */; /*!50112 EXECUTE s */; /*!50112 DEALLOCATE PREPARE s */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-05-20 8:00:57