CREATE DATABASE IF NOT EXISTS game DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

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 */;