u48YGEBh

1-- MySQL dump 10.13  Distrib 5.7.26, for Linux (x86_64)
2--
3-- Host: localhost    Database: speedrecords
4-- ------------------------------------------------------
5-- Server version	5.7.26-0ubuntu0.16.04.1
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 utf8 */;
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 `album`
20--
21
22DROP TABLE IF EXISTS `album`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `album` (
26  `id_no` int(10) unsigned NOT NULL,
27  `title` varchar(20) NOT NULL,
28  `copy` varchar(15) DEFAULT NULL,
29  `aadhar_no` smallint(5) unsigned NOT NULL,
30  PRIMARY KEY (`id_no`),
31  KEY `aadhar_no` (`aadhar_no`),
32  CONSTRAINT `album_ibfk_1` FOREIGN KEY (`aadhar_no`) REFERENCES `musician` (`aadhar_no`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `album`
38--
39
40LOCK TABLES `album` WRITE;
41/*!40000 ALTER TABLE `album` DISABLE KEYS */;
42/*!40000 ALTER TABLE `album` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `instrument`
47--
48
49DROP TABLE IF EXISTS `instrument`;
50/*!40101 SET @saved_cs_client     = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `instrument` (
53  `id_no` int(10) unsigned NOT NULL,
54  `name` varchar(20) NOT NULL,
55  `ins_key` varchar(5) DEFAULT NULL,
56  PRIMARY KEY (`id_no`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `instrument`
62--
63
64LOCK TABLES `instrument` WRITE;
65/*!40000 ALTER TABLE `instrument` DISABLE KEYS */;
66/*!40000 ALTER TABLE `instrument` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `musician`
71--
72
73DROP TABLE IF EXISTS `musician`;
74/*!40101 SET @saved_cs_client     = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `musician` (
77  `aadhar_no` smallint(5) unsigned NOT NULL,
78  `name` varchar(20) NOT NULL,
79  `place` varchar(20) DEFAULT NULL,
80  PRIMARY KEY (`aadhar_no`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82/*!40101 SET character_set_client = @saved_cs_client */;
83
84--
85-- Dumping data for table `musician`
86--
87
88LOCK TABLES `musician` WRITE;
89/*!40000 ALTER TABLE `musician` DISABLE KEYS */;
90/*!40000 ALTER TABLE `musician` ENABLE KEYS */;
91UNLOCK TABLES;
92
93--
94-- Table structure for table `performs`
95--
96
97DROP TABLE IF EXISTS `performs`;
98/*!40101 SET @saved_cs_client     = @@character_set_client */;
99/*!40101 SET character_set_client = utf8 */;
100CREATE TABLE `performs` (
101  `aadhar_no` smallint(5) unsigned NOT NULL,
102  `title` varchar(20) DEFAULT NULL
103) ENGINE=InnoDB DEFAULT CHARSET=latin1;
104/*!40101 SET character_set_client = @saved_cs_client */;
105
106--
107-- Dumping data for table `performs`
108--
109
110LOCK TABLES `performs` WRITE;
111/*!40000 ALTER TABLE `performs` DISABLE KEYS */;
112/*!40000 ALTER TABLE `performs` ENABLE KEYS */;
113UNLOCK TABLES;
114
115--
116-- Table structure for table `plays`
117--
118
119DROP TABLE IF EXISTS `plays`;
120/*!40101 SET @saved_cs_client     = @@character_set_client */;
121/*!40101 SET character_set_client = utf8 */;
122CREATE TABLE `plays` (
123  `aadhar_no` smallint(5) unsigned NOT NULL,
124  `id_no` int(10) unsigned NOT NULL
125) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126/*!40101 SET character_set_client = @saved_cs_client */;
127
128--
129-- Dumping data for table `plays`
130--
131
132LOCK TABLES `plays` WRITE;
133/*!40000 ALTER TABLE `plays` DISABLE KEYS */;
134/*!40000 ALTER TABLE `plays` ENABLE KEYS */;
135UNLOCK TABLES;
136
137--
138-- Table structure for table `song`
139--
140
141DROP TABLE IF EXISTS `song`;
142/*!40101 SET @saved_cs_client     = @@character_set_client */;
143/*!40101 SET character_set_client = utf8 */;
144CREATE TABLE `song` (
145  `title` varchar(20) NOT NULL,
146  `author` varchar(15) DEFAULT NULL,
147  `id_no` int(10) unsigned NOT NULL,
148  PRIMARY KEY (`title`)
149) ENGINE=InnoDB DEFAULT CHARSET=latin1;
150/*!40101 SET character_set_client = @saved_cs_client */;
151
152--
153-- Dumping data for table `song`
154--
155
156LOCK TABLES `song` WRITE;
157/*!40000 ALTER TABLE `song` DISABLE KEYS */;
158/*!40000 ALTER TABLE `song` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `uses`
163--
164
165DROP TABLE IF EXISTS `uses`;
166/*!40101 SET @saved_cs_client     = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `uses` (
169  `id_no` int(10) unsigned NOT NULL,
170  `title` varchar(20) NOT NULL
171) ENGINE=InnoDB DEFAULT CHARSET=latin1;
172/*!40101 SET character_set_client = @saved_cs_client */;
173
174--
175-- Dumping data for table `uses`
176--
177
178LOCK TABLES `uses` WRITE;
179/*!40000 ALTER TABLE `uses` DISABLE KEYS */;
180/*!40000 ALTER TABLE `uses` ENABLE KEYS */;
181UNLOCK TABLES;
182/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
183
184/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
185/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
186/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
187/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
188/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
189/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
190/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
191
192-- Dump completed on 2019-07-17 15:41:56