· 7 years ago · Nov 07, 2018, 02:48 AM
1CREATE TABLE IF NOT EXISTS `deposit` (
2 `bname` varchar(200) NOT NULL,
3 `accno` int(6) unsigned NOT NULL,
4 `cname` varchar(200) NOT NULL,
5 `balance` int(6) unsigned NOT NULL,
6 PRIMARY KEY (`accno`)
7) DEFAULT CHARSET=utf8;
8
9CREATE TABLE IF NOT EXISTS `customer` (
10 `cname` varchar(188) NOT NULL,
11 `street` varchar(300) NOT NULL,
12 `ccity` varchar(100) NOT NULL,
13 PRIMARY KEY (`cname`)
14) DEFAULT CHARSET=utf8;
15
16INSERT INTO `deposit` (`bname`, `accno`, `cname`, `balance`) VALUES
17 ('Lake', 1, 'Peter', 2000),
18 ('Lake', 2, 'Paul', 2000),
19 ('Alps', 3, 'Paul', 2000),
20 ('Downtown', 4, 'Paul', 2000),
21 ('Alps', 6, 'Mary', 2000);
22
23INSERT INTO `customer` (`cname`, `street`, `ccity`) VALUES
24 ('Mary', 'River Road', 'Athens'),
25 ('Peter', 'Jefferson River Road', 'Athens'),
26 ('Paul', 'College Street', 'Macon');