· 10 years ago · Sep 17, 2016, 12:02 PM
1DROP TABLE IF EXISTS ‘manager’;
2CREATE TABLE `manager` (
3 `ID` INT(11) NOT NULL AUTO_INCREMENT,
4 `Name` CHAR(35) NOT NULL,
5 `CountryCode` CHAR(3) NOT NULL DEFAULT '',
6 `District` CHAR(20) NOT NULL DEFAULT '',
7 `Population` INT(11) NOT NULL DEFAULT '0',
8 PRIMARY KEY (`ID`)
9 );