· 8 years ago · Aug 04, 2018, 09:12 PM
1CREATE TABLE IF NOT EXISTS `house_upgrades` (
2 `upgradeId` int(11) NOT NULL AUTO_INCREMENT,
3 `upgradeName` varchar(255) NOT NULL,
4 `upgradeMood` int(11) NOT NULL,
5 `upgradeCost` int(11) NOT NULL DEFAULT '0',
6 `upgradeHouse` int(11) NOT NULL DEFAULT '0',
7 `upgradeNO` int(11) NOT NULL DEFAULT '0',
8 `upgradeimage` varchar(225) NOT NULL,
9 PRIMARY KEY (`upgradeId`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;