· 7 years ago · Oct 31, 2018, 03:42 PM
1CREATE TABLE IF NOT EXISTS `borrow` (
2 `bname` varchar(200) NOT NULL,
3 `loanno` int(6) unsigned NOT NULL,
4 `cname` varchar(200) NOT NULL,
5 `amount` int(6) unsigned NOT NULL,
6 PRIMARY KEY (`loanno`)
7) DEFAULT CHARSET=utf8;
8CREATE TABLE IF NOT EXISTS `deposit` (
9 `bname` varchar(200) NOT NULL,
10 `accno` int(6) unsigned NOT NULL,
11 `cname` varchar(200) NOT NULL,
12 `balance` int(6) unsigned NOT NULL,
13 PRIMARY KEY (`accno`)
14) DEFAULT CHARSET=utf8;
15
16INSERT INTO `borrow` (`bname`, `loanno`, `cname`, `amount`) VALUES
17 ('Alps', 1, 'Peter', 1000),
18 ('Downtown', 2, 'Peter', 1000),
19 ('Alps', 3, 'Paul', 1000),
20 ('Downtown', 4, 'Paul', 1000),
21 ('Lake', 5, 'Mary', 1000),
22 ('Alps', 6, 'Mary', 1000);
23
24INSERT INTO `deposit` (`bname`, `accno`, `cname`, `balance`) VALUES
25 ('Lake', 1, 'Peter', 2000),
26 ('Lake', 2, 'Paul', 2000),
27 ('Alps', 3, 'Paul', 2000),
28 ('Downtown', 4, 'Paul', 2000),
29 ('Downtown', 5, 'Mary', 2000),
30 ('Alps', 6, 'Mary', 2000);