CREATE DATABASE IF NOT EXISTS game DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
--
-- Table structure for table `account`
--
DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account` (
`accountId` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`loginzoneId` int(11) DEFAULT NULL,
`freezedTime` int(11) DEFAULT NULL,
`freezedDays` int(11) DEFAULT NULL,
PRIMARY KEY (`accountId`),
KEY `name` (`name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=99900143 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;