· 6 years ago · Jun 25, 2019, 10:20 AM
1DROP TABLE IF EXISTS `customerdb`.`customer`;
2CREATE TABLE `customerdb`.`customer` (
3 `customerId` int(10) unsigned NOT NULL,
4 `customerFullName` varchar(45) NOT NULL,
5 `email` varchar(45) NOT NULL,
6 `mobile` varchar(45) NOT NULL,
7 `city` varchar(45) NOT NULL,
8 `gender` varchar(45) NOT NULL,
9 `customerType` varchar(45) NOT NULL,
10 `billDate` datetime NOT NULL,
11 `isActive` tinyint(1) NOT NULL,
12 PRIMARY KEY (`customerId`)
13) ENGINE=InnoDB DEFAULT CHARSET=latin1;