gistfile1.sql

CREATE TABLE IF NOT EXISTS `comds` (
  `id` int(11) NOT NULL  COMMENT 'lookup',
  `TotalExp` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TotalExp',
  `FirstLoginTime` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'FirstLoginTime',
  `FirstLogin` date DEFAULT NULL COMMENT 'lookup',
  `TotalDollorGet` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TotalDollorGet',
  `TodayGameTime` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayGameTime',
  `TodayTCrystalLose` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayTCrystalLose',
  `Crystal` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Crystal',
  `TodayGoldGet` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayGoldGet',
  `TodayGoldLose` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayGoldLose',
  `Cracked` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Cracked',
  `WeaponList` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'WeaponList',
  `TodayExp` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayExp',
  `TodayIapInfo` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayIapInfo',
  `099cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `099cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `new499cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `new499cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `new999cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `new999cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `new1999cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `new1999cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `new4999cents1` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `new4999cents2` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `ChoosePointsUI` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ChoosePointsUI',
  `ShopUI_Weapon` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ShopUI_Weapon',
  `ShopUI_Avatar` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ShopUI_Avatar',
  `ShopUI_PowerUPS` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ShopUI_PowerUPS',
  `ShopUI_Bank` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ShopUI_Bank',
  `BoostUI_Skill` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'BoostUI_Skill',
  `TeamUI_Friend` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TeamUI_Friend',
  `TeamUI_MERC` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TeamUI_MERC',
  `MERC_UI` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'MERC_UI',
  `OptionUI` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'OptionUI',
  `BattleUI_Pause` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'BattleUI_Pause',
  `BattleUI_Item` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'BattleUI_Item',
  `BattleUI_Dead` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'BattleUI_Dead',
  `ExchangeUI` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ExchangeUI',
  `Gold` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Gold',
  `Level` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'lookup',
  `GameActiveTime` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'GameActiveTime',
  `TotalGoldGet` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TotalGoldGet',
  `UILastId` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'UILastId',
  `HireoutSelfTimes` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'HireoutSelfTimes',
  `TotalGameTime` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TotalGameTime',
  `TodayTCrystalGet` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'TodayTCrystalGet',
  `deviceid` varchar(128) COLLATE utf8_bin DEFAULT '0' COMMENT 'lookup',
  `gamename` varchar(24) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'gamename',
  `createdate` datetime DEFAULT NULL COMMENT 'createdate',
  `date` date NOT NULL COMMENT 'lookup'
) ENGINE=BRIGHTHOUSE  DEFAULT CHARSET=utf8  ;