· 8 years ago · Mar 17, 2018, 06:32 AM
1-- MySQL dump 10.13 Distrib 5.5.8, for Win32 (x86)
2--
3-- Host: localhost Database: bank
4-- ------------------------------------------------------
5-- Server version 5.5.8
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 `account`
20--
21
22DROP TABLE IF EXISTS `account`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `account` (
26 `account_no` char(5) NOT NULL DEFAULT '',
27 `branch_name` varchar(15) DEFAULT NULL,
28 `balance` int(11) DEFAULT NULL,
29 PRIMARY KEY (`account_no`),
30 KEY `branch_name` (`branch_name`),
31 CONSTRAINT `account_ibfk_1` FOREIGN KEY (`branch_name`) REFERENCES `branch` (`branch_name`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `account`
37--
38
39LOCK TABLES `account` WRITE;
40/*!40000 ALTER TABLE `account` DISABLE KEYS */;
41INSERT INTO `account` VALUES ('A-101','Downtown',500),('A-102','Perryridge',400),('A-201','Brighton',900),('A-215','Mianus',700),('A-217','Brighton',750),('A-222','Redwood',700),('A-305','Round Hill',350);
42/*!40000 ALTER TABLE `account` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `borrower`
47--
48
49DROP TABLE IF EXISTS `borrower`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `borrower` (
53 `customer_name` varchar(15) NOT NULL DEFAULT '',
54 `loan_no` char(5) NOT NULL DEFAULT '',
55 PRIMARY KEY (`customer_name`,`loan_no`),
56 KEY `loan_no` (`loan_no`),
57 CONSTRAINT `borrower_ibfk_1` FOREIGN KEY (`customer_name`) REFERENCES `customer` (`customer_name`),
58 CONSTRAINT `borrower_ibfk_2` FOREIGN KEY (`loan_no`) REFERENCES `loan` (`loan_no`)
59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Dumping data for table `borrower`
64--
65
66LOCK TABLES `borrower` WRITE;
67/*!40000 ALTER TABLE `borrower` DISABLE KEYS */;
68INSERT INTO `borrower` VALUES ('Smith','L-11'),('Johnson','L-14'),('Hayes','L-15'),('Adams','L-16'),('Jones','L-17'),('Williams','L-17'),('Smith','L-23'),('Curry','L-93');
69/*!40000 ALTER TABLE `borrower` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `branch`
74--
75
76DROP TABLE IF EXISTS `branch`;
77/*!40101 SET @saved_cs_client = @@character_set_client */;
78/*!40101 SET character_set_client = utf8 */;
79CREATE TABLE `branch` (
80 `branch_name` varchar(15) NOT NULL DEFAULT '',
81 `branch_city` varchar(15) DEFAULT NULL,
82 `assets` int(11) DEFAULT NULL,
83 PRIMARY KEY (`branch_name`)
84) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `branch`
89--
90
91LOCK TABLES `branch` WRITE;
92/*!40000 ALTER TABLE `branch` DISABLE KEYS */;
93INSERT INTO `branch` VALUES ('Brighton','Brooklyn',7100000),('Downtown','Brooklyn',9000000),('Mianus','Horseneck',400000),('North Town','Rye',3700000),('Perryridge','Horseneck',1700000),('Pownal','Bennington',300000),('Redwood','Palo Alto',2100000),('Round Hill','Horseneck',8000000);
94/*!40000 ALTER TABLE `branch` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `customer`
99--
100
101DROP TABLE IF EXISTS `customer`;
102/*!40101 SET @saved_cs_client = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `customer` (
105 `customer_name` varchar(15) NOT NULL DEFAULT '',
106 `customer_street` varchar(15) DEFAULT NULL,
107 `customer_city` varchar(15) DEFAULT NULL,
108 PRIMARY KEY (`customer_name`)
109) ENGINE=InnoDB DEFAULT CHARSET=latin1;
110/*!40101 SET character_set_client = @saved_cs_client */;
111
112--
113-- Dumping data for table `customer`
114--
115
116LOCK TABLES `customer` WRITE;
117/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
118INSERT INTO `customer` VALUES ('Adams','Spring','Pittsfield'),('Brooks','Senator','Brooklyn'),('Curry','North','Rye'),('Glenn','Sand Hill','Woodside'),('Green','Walnut','Stamford'),('Hayes','Main','Harrison'),('Johnson','Alma','Palo Alto'),('Jones','Main','Harrison'),('Lindsay','Park','Pittsfield'),('Smith','North','Rye'),('Turner','Putnam','Stamford'),('Williams','Nassau','Princeton');
119/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `depositor`
124--
125
126DROP TABLE IF EXISTS `depositor`;
127/*!40101 SET @saved_cs_client = @@character_set_client */;
128/*!40101 SET character_set_client = utf8 */;
129CREATE TABLE `depositor` (
130 `customer_name` varchar(15) NOT NULL DEFAULT '',
131 `account_no` char(5) NOT NULL DEFAULT '',
132 PRIMARY KEY (`customer_name`,`account_no`),
133 KEY `account_no` (`account_no`),
134 CONSTRAINT `depositor_ibfk_1` FOREIGN KEY (`customer_name`) REFERENCES `customer` (`customer_name`),
135 CONSTRAINT `depositor_ibfk_2` FOREIGN KEY (`account_no`) REFERENCES `account` (`account_no`)
136) ENGINE=InnoDB DEFAULT CHARSET=latin1;
137/*!40101 SET character_set_client = @saved_cs_client */;
138
139--
140-- Dumping data for table `depositor`
141--
142
143LOCK TABLES `depositor` WRITE;
144/*!40000 ALTER TABLE `depositor` DISABLE KEYS */;
145INSERT INTO `depositor` VALUES ('Johnson','A-101'),('Hayes','A-102'),('Johnson','A-201'),('Smith','A-215'),('Jones','A-217'),('Lindsay','A-222'),('Turner','A-305');
146/*!40000 ALTER TABLE `depositor` ENABLE KEYS */;
147UNLOCK TABLES;
148
149--
150-- Table structure for table `loan`
151--
152
153DROP TABLE IF EXISTS `loan`;
154/*!40101 SET @saved_cs_client = @@character_set_client */;
155/*!40101 SET character_set_client = utf8 */;
156CREATE TABLE `loan` (
157 `loan_no` char(5) NOT NULL DEFAULT '',
158 `branch_name` varchar(15) DEFAULT NULL,
159 `amount` int(11) DEFAULT NULL,
160 PRIMARY KEY (`loan_no`),
161 KEY `branch_name` (`branch_name`),
162 CONSTRAINT `loan_ibfk_1` FOREIGN KEY (`branch_name`) REFERENCES `branch` (`branch_name`)
163) ENGINE=InnoDB DEFAULT CHARSET=latin1;
164/*!40101 SET character_set_client = @saved_cs_client */;
165
166--
167-- Dumping data for table `loan`
168--
169
170LOCK TABLES `loan` WRITE;
171/*!40000 ALTER TABLE `loan` DISABLE KEYS */;
172INSERT INTO `loan` VALUES ('L-11','Round Hill',900),('L-14','Downtown',1500),('L-15','Perryridge',1500),('L-16','Perryridge',1300),('L-17','Downtown',1000),('L-23','Redwood',2000),('L-93','Mianus',500);
173/*!40000 ALTER TABLE `loan` ENABLE KEYS */;
174UNLOCK TABLES;
175/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
176
177/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
178/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
179/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
180/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
181/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
182/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
183/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
184
185-- Dump completed on 2011-10-29 11:16:11