· 5 years ago · Feb 12, 2020, 04:14 AM
1-- MariaDB dump 10.17 Distrib 10.4.10-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: chat
4-- ------------------------------------------------------
5-- Server version 10.4.10-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `says`
20--
21
22DROP TABLE IF EXISTS `says`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `says` (
26 `id` int(11) NOT NULL,
27 `t1` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
28 `t2` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
29 `t3` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
30 `t4` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
31 `opt` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
32 `var` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
33 `next` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
34 `type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
35 `cq` varchar(600) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
36 `cqb` int(11) DEFAULT NULL,
37 PRIMARY KEY (`id`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Dumping data for table `says`
43--
44
45LOCK TABLES `says` WRITE;
46/*!40000 ALTER TABLE `says` DISABLE KEYS */;
47INSERT INTO `says` VALUES (0,'Hello, I\'m King','Tell me your name first',NULL,NULL,NULL,'user_name','1','input',NULL,NULL),(1,'Hey there user_name.','Here are my scopes I can help you with',NULL,NULL,'About Me,College,Studnet,Department,Principal','user_deatils_req','2,3,4,5,6','opt',NULL,NULL),(2,'I am Awcator, Designed by <b> Awcaotr.','I am created using <b>JavaScript,Jquery & PHP , I coomunicate with the help of JSon Requests','I am here for helping you guys with a virtual introduction of this college','I represent Virtual Receptionist','Send me back to Main Menu,End',NULL,'1,99','opt',NULL,NULL),(3,'<img src=\'https://schoolbook.getmyuni.com/assets/images/rev_img/63731__28926/15186800131518679987139.jpg\'>','Welcome to GECH ',NULL,NULL,'Administration,Scholorships','college_details','15,20','opt',NULL,NULL),(4,'Alright user_name, Right now I\'m limitied within databse power','I can help with these many students now',NULL,NULL,NULL,'student_name','5&sname=student_name','input','select distinct name from student;',1),(5,'Result of student_name is as shown below',NULL,NULL,NULL,NULL,NULL,'6&sname=student_name','msg',NULL,NULL),(6,'RESULT',NULL,NULL,NULL,NULL,NULL,'1','msg',NULL,NULL);
48/*!40000 ALTER TABLE `says` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `student`
53--
54
55DROP TABLE IF EXISTS `student`;
56/*!40101 SET @saved_cs_client = @@character_set_client */;
57/*!40101 SET character_set_client = utf8 */;
58CREATE TABLE `student` (
59 `usn` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
60 `Name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
61 `M1` int(11) DEFAULT NULL,
62 `M2` int(11) DEFAULT NULL,
63 `M3` int(11) DEFAULT NULL,
64 `M4` int(11) DEFAULT NULL
65) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `student`
70--
71
72LOCK TABLES `student` WRITE;
73/*!40000 ALTER TABLE `student` DISABLE KEYS */;
74INSERT INTO `student` VALUES ('4gh16cs011','Dev',10,20,30,40),('4gh16cs012','Dev2',11,22,30,40),('4gh14cs012','Dexzcv2',141,22,30,40),('45sx14cs012','Muklari',141,22,30,40);
75/*!40000 ALTER TABLE `student` ENABLE KEYS */;
76UNLOCK TABLES;
77/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
78
79/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
80/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
81/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
82/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
83/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
84/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
85/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
86
87-- Dump completed on 2020-02-12 9:41:02