· 7 years ago · Oct 31, 2018, 03:38 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;