crystalgames数据库更新：



ALTER TABLE `mj_server_list` ADD `onlyWhite` INT(1) NULL AFTER `sortID`, ADD `normalOpen` INT(1) NULL AFTER `onlyWhite`, ADD `forceStatus` INT(4) NULL AFTER `normalOpen`, ADD `gamecenter` INT(4) NULL AFTER `forceStatus`;

ALTER TABLE `mj_server_list` ADD `client_port` INT(4) NULL AFTER `socket_ip`;

ALTER TABLE `mj_server_list` ADD `openTime` INT(10) NULL ;

ALTER TABLE `mj_server_list` ADD `closeTime` INT(10) NULL ;











ALTER TABLE `mj_server_list` ADD `order_register_url` VARCHAR(200) NULL AFTER `closeTime`, ADD `telnet_port` INT(4) NULL AFTER `order_register_url`, ADD `iftest` TINYINT(1) NULL DEFAULT '1' AFTER `telnet_port`, ADD `ifmerge` TINYINT(1) NULL DEFAULT '1' AFTER `iftest`, ADD `pointtoserverid` INT(4) NULL AFTER `ifmerge`, ADD `onlyBlack` TINYINT(1) NULL DEFAULT '1' AFTER `pointtoserverid`, ADD `timezone` INT(4) NULL AFTER `onlyBlack`, ADD `maxloaded` INT(4) NULL AFTER `timezone`, ADD `maxcache` INT(4) NULL AFTER `maxloaded`, ADD `maxqueues` INT(4) NULL AFTER `maxcache`;

ALTER TABLE `mj_server_list` ADD `forbiddenchannel` VARCHAR(200) NULL AFTER `maxqueues`;

ALTER TABLE `mj_server_list` ADD `ifpush` TINYINT(1) NULL DEFAULT '0' AFTER `forbiddenchannel`;

ALTER TABLE `mj_server_list` ADD `show_server_id` VARCHAR(200) NULL AFTER `ifpush`;

ALTER TABLE `mj_server_list` ADD `server_status` TINYINT(1) NULL DEFAULT '1' AFTER `show_server_id`;



ALTER TABLE `mj_server_list` CHANGE `pointtoserverid` `pointtoserverid` VARCHAR(200) NULL;

ALTER TABLE `mj_server_list` ENGINE = InnoDB;







update `mj_server_list` set `gamecenter`=99;

update `mj_server_list` set `iftest`=2;

update `mj_server_list` set `ifmerge`=2;



UPDATE `mj_server_list` SET `order_register_url`='',`timezone`=8,`maxloaded`=10,`maxcache`=10000,`maxqueues`=6000 ;





ALTER TABLE `mj_server_database_conn` ADD `conn_game_ip` VARCHAR(100) NULL AFTER `server_id`;

ALTER TABLE `mj_server_database_conn_vice` ADD `conn_game_ip` VARCHAR(100) NULL AFTER `server_id`;



//youzu

ALTER TABLE `mj_server_database_conn` ADD `conn_game_user` VARCHAR(100) NULL AFTER `conn_game_ip`, ADD `conn_game_pwd` VARCHAR(100) NULL AFTER `conn_game_user`, ADD `conn_game_port` INT(10) NULL AFTER `conn_game_pwd`;

ALTER TABLE `mj_server_database_conn_vice` ADD `conn_game_user` VARCHAR(100) NULL AFTER `conn_game_ip`, ADD `conn_game_pwd` VARCHAR(100) NULL AFTER `conn_game_user`, ADD `conn_game_port` INT(10) NULL AFTER `conn_game_pwd`;





##################

新增表

##################

--

-- 表的结构 `mj_add_silence_log`

--



DROP TABLE IF EXISTS `mj_add_silence_log`;

CREATE TABLE IF NOT EXISTS `mj_add_silence_log` (

`id` int(11) NOT NULL,

  `cid` text COLLATE utf8_unicode_ci COMMENT '玩家的id',

  `server_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '帐号',

  `logofftime` int(10) NOT NULL DEFAULT '0',

  `ordertype` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,

  `cdate` int(10) DEFAULT NULL COMMENT '创建时间',

  `cidate` int(8) DEFAULT NULL COMMENT '创建时间I',

  `status` int(4) DEFAULT '0'

) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `mj_add_silence_log`

 ADD PRIMARY KEY (`id`), ADD KEY `account` (`username`);

ALTER TABLE `mj_add_silence_log`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1; 









-- --------------------------------------------------------



--

-- 表的结构 `mj_center_list`

--



DROP TABLE IF EXISTS `mj_center_list`;

CREATE TABLE IF NOT EXISTS `mj_center_list` (

`id` int(10) NOT NULL,

  `center_id` int(10) DEFAULT NULL,

  `center_con` longtext

) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;



-- --------------------------------------------------------





--

-- 表的结构 `mj_template_list`

--



DROP TABLE IF EXISTS `mj_template_list`;

CREATE TABLE IF NOT EXISTS `mj_template_list` (

`id` int(11) NOT NULL,

  `time` int(11) NOT NULL COMMENT '时间',

  `template_name` varchar(200) NOT NULL,

  `template_key` varchar(20) NOT NULL,

  `url` varchar(100) NOT NULL,

  `version` varchar(100) NOT NULL COMMENT '版本号',

  `content` text NOT NULL COMMENT '内容'

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;



--

-- Indexes for dumped tables

--



--

-- Indexes for table `mj_center_list`

--

ALTER TABLE `mj_center_list`

 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `center_id` (`center_id`);







--

-- Indexes for table `mj_template_list`

--

ALTER TABLE `mj_template_list`

 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `template_key` (`template_key`);



--

-- AUTO_INCREMENT for dumped tables

--



--

-- AUTO_INCREMENT for table `mj_center_list`

--

ALTER TABLE `mj_center_list`

MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=56;



--

-- AUTO_INCREMENT for table `mj_template_list`

--

ALTER TABLE `mj_template_list`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;







ALTER TABLE `mj_operation_log` CHANGE `values` `values` VARCHAR(3000) CHARACTER SET utf8 COLLATE utf8_estonian_ci NULL DEFAULT NULL COMMENT '值', CHANGE `accident` `accident` TEXT CHARACTER SET utf8 COLLATE utf8_estonian_ci NULL DEFAULT NULL COMMENT '内容/事故';





INSERT INTO `mj_template_list` (`id`, `time`, `template_name`, `template_key`, `url`, `version`, `content`) VALUES

(1, 1436497252, '登录服务器参数模板', 'center.txt', '', '', 's:1318:"center_id=8\ncenter_ip=10.0.0.225\ncenter_name=center_clark\ncenter_maintain=false\ncenter_version=\ncenter_client_version=\ncenter_compatibility_version=\ncenter_white_login_ip=\ncenter_black_login_ip=\ncenter_clienturl_cdn=http://cystal.assetbundles.com/\ncenter_clienturl_cdn2=http://cystal.assetbundles.com/\ncenter_clienturl_notcdn=http://cystal.assetbundles.com/\ncenter_gm_port=9500\ncenter_game_server_port=8111\ncenter_client_port=8000\ncenter_telnet_port=2202\ncenter_game_login_pwd=pwd\ncenter_forbidden_channel=\ncenter_dbhost=10.0.0.194:3306\ncenter_dbname=dmyx_center\ncenter_dbuser=root\ncenter_dbpwd=123456\nworld_open=off\nworld_game_ip=\nworld_game_port=20001\nworld_game_pwd=pwd\nworld_gm_port=20002\nworld_dbhost=10.0.0.194:3306\nworld_dbname=dmyx_center\nworld_dbuser=root\nworld_dbpwd=123456\nworld_telnet_port=20003\ngame_server_area=zhcn_ios\ngame_PackageSignChek_NeedSignCheck=false\ngame_PackageSignChek_KickOutFaker=false\ngame_PackageSignChek_PlatformKey=DownJoyForAndroid:e3910c335a4172547c71721b9247c0c1;TWGoogleForAndroid:5896741fa50a9a04fb61b12217b5fd42;TWLemonAPKForAndroid:5896741fa50a9a04fb61b12217b5fd42;\ngame_recharge_channnel=NORMAL\ngame_channnel_name=None\ngame_forbidden_proto=\nforbidden_client_notice=您的客户端版本过低，请及时更新，以便获得最佳体验。\ncenter_recommend_server=\ntest1=test1";'),

(2, 1436498393, '登录服务器配置文件模板', 'center.html', '', '', 's:3235:"# =================== 固定配置 ========================\n#logic log\nlogback.configurationFile = ./conf/logback_center.xml\nLOG_RECEIVEMESSAGE = false\n\n## <---\n\n## telnet\nTelnetServer.IP = 0.0.0.0\nCenterServer.Telnet2Center_Port = <{$rs.center_telnet_port}>\n\n## game\nCenterServer.Game2Center_IP=0.0.0.0\nCenterServer.Game2Center_Port= <{$rs.center_game_server_port}>\nCenterServer.Game2Center_LoginPwd= <{$rs.center_game_login_pwd}>\n\n## web\nCenterServer.Web2Center_Port= <{$rs.center_gm_port}>\n\n## client\nCenterServer.Client2Center_Port= <{$rs.center_client_port}>\n# 客户端登录center服务连接状态检查, 默认false, 设置为true\nCenterServer.isCheckSessionSilent = true\n# 客户端登录center连接对象最大超时时间,单位秒, 默认10分钟\nCenterServer.clientSessionExpiredMaxTime = 6000\n# 客户端登录center连接对象超时检查间隔, 单位毫秒, 默认 30000 毫秒\nCenterServer.checkClientSessionInterval = 30000\n\n## --->\n## platform 10.0.0.22:9622\nPlatform_AUTHCODE = 5AC9CC5A\nCenterServer.PlatformServerIP = <{$rs.platform_ip}>\nCenterServer.PlatfromServerPort = <{$rs.platform_port}>\nCenterServer.PlatformLoginName = LoginServer\nCenterServer.PlatformLoginPwd = 8fb3c1df61a496b091e80b2e2d296fd0\n\n# =================== 动态配置 ========================\n# Center Database info\nCENTERDB_URL=jdbc:mysql://<{$rs.center_dbhost}>/<{$rs.center_dbname}>?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false\nCENTERDB_USER=<{$rs.center_dbuser}>\nCENTERDB_PASSWORD=<{$rs.center_dbpwd}>\n\nCenterServer.CenterVersion = <{$rs.center_version}>\n\n#禁止低版本客户端登陆\nClientConfig.ForbiddenClient= <{$rs.forbidden_client}>\nClientConfig.ForbiddenClientVersion = <{$rs.forbidden_client_version}>\nClientConfig.ForbiddenClientNotice = <{$rs.forbidden_client_notice}>\nClientConfig.ForbiddenClientAssetBundlePath =  <{$rs.forbidden_clienturl_cdn}>;<{$rs.forbidden_clienturl_cdn2}>;<{$rs.forbidden_clienturl_notcdn}>\n\n#兼容的客户端版本\nCenterServer.PermitClientVersion = <{$rs.center_compatibility_version}>\n\n#发送的客户端版本\nClientConfig.ClientVersion = <{$rs.center_client_version}>\n#客户端AssetBundle路径 http://crystal.assetbundles.com/\nClientConfig.AssetBundlePath = <{$rs.center_clienturl_cdn}>;<{$rs.center_clienturl_cdn2}>;<{$rs.center_clienturl_notcdn}>\n\n# 登陆渠道禁登\nCenterServer.FobiddenLogin = <{$rs.center_forbidden_channel}> \n\n#黑白名单 \nCenterServer.BlackLoginIP = <{$rs.center_black_login_ip}>\nCenterServer.WhiteLoginIP = <{$rs.center_white_login_ip}>\n\n#是否在全区维护 true、false\nCenterServer.Maintain = <{$rs.center_maintain}>\n\n#推荐导量服务器列表\nCenterServer.RecommendSserver = <{$rs.center_recommend_server}>\n\n# =================== 世界服配置 ======================\nWorldServer.GameServer_Port = <{$rs.world_game_port}>\nWorldServer.GameServer_Pwd = <{$rs.world_game_pwd}>\nWorldServer.Gm_Port = <{$rs.world_gm_port}>\nWorldServer.Telnet_Port = <{$rs.world_telnet_port}>\n\nWorldServer_DB_URL=jdbc:mysql://<{$rs.world_dbhost}>/<{$rs.world_dbname}>?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false\nWorldServer_DB_USER=<{$rs.world_dbuser}>\nWorldServer_DB_PASSWORD=<{$rs.world_dbpwd}>";'),

(3, 1436500601, '游戏服配置模板文件', 'game.html', '', '', 's:5735:"# =================== config ========================\n#logic log\nlogback.configurationFile = /conf/logback_crystal.xml\nLOG_RECEIVEMESSAGE = false\n\n## <---\n# webgm\nGameServer.WebServer2Game_IP = 0.0.0.0\nGameServer.WebServer2Game_Port = <{$rs.socket_port}>\n\n## telnet\nTelnetServer.IP = 0.0.0.0\nGameServer.Telnet2Game_Port = <{$rs.telnet_port}>\n\n## client\nGameServer.Client2Game_Port = <{$rs.client_port}>\n\n## --->\n## center\nGameServer.Game2Center_IP= <{$rs.center_ip}>\nGameServer.Game2Center_Port= <{$rs.center_game_server_port}>\nGameServer.Game2Center_LoginPwd= <{$rs.center_game_login_pwd}>\n\n## world\n#是否开启跨服服务器 on-开，其他关\nGameServer.WorldOpen=<{$rs.world_open}>\nGameServer.Game2World_IP= <{$rs.world_game_ip}>\nGameServer.Game2World_Port= <{$rs.world_game_port}>\nGameServer.Game2World_Pwd= <{$rs.world_game_pwd}>\n# =================== recharge ========================\n\n#表单密钥KEY\nHTTP_FORM_KEY = 123456\n#HTTP请求最大连接时间\nHTTP_CONN_TIMEOUT_MS = 1000\n#HTTP响应最大读取时间\nHTTP_READ_TIMEOUT_MS = 1000\n#下订单队列最大等待时间\nRECHARGE_MAX_WAIT_TIME = 2200\n#下订单最大队列长度\nRECHARGE_MAX_WAIT_QUEUE = 100\n#充值订单WEB端提交URL\nWEB_RECHARGE_URL = <{$rs.order_register_url}>\n\n#欧美IOS充值产品编号前缀\nRECHARGE_GOODSID_PREFIX_FOR_US_IOS=com.mechanist.crystal.\n\n#IOS内购验证\nIOS_VERIFY_RECHARGE_URL=https://buy.itunes.apple.com/verifyReceipt\nIOS_VERIFY_RECHARGE_URL_SANDBOX=https://sandbox.itunes.apple.com/verifyReceipt\n\n#韩国 谷歌充值结果签名\nGOOGLE_RECHARGE_SIGNATURE=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAoPtxGh0ESDsRsib4JQbdxYAwiJEd0dYy2ULShs7WsJzU2gcObCLGnmrGlACQS7O40xIXXY9rS7/x0ZqQoN/20ouRtZqJQdVzQr6/88umPzP5gOKo/PrhG03BwcPOf5RGNVzZYaKFwiBj8UhSipwcxeBt9I5BgtYQDvwQ2gxCxuUsJFMDCEIXqtmt31cVYRhHg09mTy5S6r6VOGuPWhJ08VwiqrOF+1frAUqVvaU2znVUXu/6FRACWG3XEInxd+8l4lYofYG0Efh7ZJ+AAsnGZbxUltkDByDY6BjHFjcEmbyQFYWCol3KmB3G5trAssLNZ0q8JqU+t1PLxN2rWsDjEQIDAQAB\nGCM_SERVER_KEY=AIzaSyAbvqhsuQF9IxkkadqILGJx4_b2qoa-3Hs\n\n#韩国Naver充值使用的厂商ID\nNaver.DeceloperID=AD_1004522\n#韩国TStore充值使用的厂商ID\nTStore.VerifyAddress=https://iap.tstore.co.kr/digitalsignconfirm.iap\nTStore.APPID=OA00686057\n\n#日版 谷歌充值结果签名\nJP_GOOGLE_RECHARGE_SIGNATURE=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkKrwN+YW1xOkvhIZSS0SSITnGdnhYEOdKKqIeAsUiJqzL4m+TXOt+tb+cGQd8pDDlkjIoG/qXoPPOZafpgA5kgf2VQVduMaw6ydOW2ewMkEckARQkaOCBRiljU25FneaiKfPq1tZwMtzkJszt4WT/LProSu4zgkBv/XaR7fBJDZOz4CJIcl7FOS3AItlqha9I/KvOE7xn9Pqj21PcDQwVItC7fkc0h5KzrHXBMKjGoH6D62lieTtl8tUxYUIXlxMv6DfvH5NpjxNPCMrdG29mOBrUrYixueUsW6Tm7xgzeO8UvG8T4BPqPrmLLJt+pmDA4hawLWVs+qRabQK1noZhwIDAQAB\nJP_GCM_SERVER_KEY=AIzaSyASZs90hlSxAX7jVf8j4SY8zqNz6MO7KZo\n\n#腾讯充值相关 http://msdktest.qq.com（沙箱） http://msdk.qq.com（现网）\nTENCENT_RECHARGE_URL=http://msdk.qq.com\nTENCENT_RECHARGE_URI_GETBALANCE=/mpay/get_balance_m\nTENCENT_RECHARGE_URI_PAY=/mpay/pay_m\n\n# =================== 分渠道的开关，预先在模板里改好 ========================\n\n#【1】充值渠道 NONE未开启充值 | NORMAL普通充值流程 | US_IOS欧美IOS充值流程 | GOOGLE谷歌充值流程\nRECHARGE_CHANNEL=<{$rs.game_recharge_channnel}>\n#【2】渠道类型  ChannelType    None// 0-默认类型	CNYYB// 1-中国	CN360// 2-中国\nCHANNEL_NAME=<{$rs.game_channnel_name}>\n\n#【3】欧美服游族数据中心日志\nYouZuLog=off\n# 发送服务器状态间隔，默认5min 300000\nYouZuLog.ServerStatusInteval=300000\nYouZuLog.GameId=120\n#YouZuLog.ServerId=2075440001\n# ios是2136  android是2135\nYouZuLog.PlatfomId=2136\n\n#【4】区域开关\n## zhcn_ios\n## zhcn_iosyy \n## zhcn_android\n## zhcn_android360\n## zhcn_androidtx\n## rekoo_jp \n## rekoo_ko\n## zhtw_ios\n## youzu_en\nSERVER_AREA = <{$rs.game_server_area}>\n\n# =================== 动态配置 ========================\nGameServer.GameVersion = <{$rs.server_version}>\n\n# player count\nGameServer.LoadCachedPlayerCnt = <{$rs.maxloaded}>\nGameServer.MaxCachedPlayerCnt = <{$rs.maxcache}>\nGameServer.MaxOnlinePlayerCnt = <{$rs.maxqueues}>\n\n# new player gm level [warn: develop set 1, other set 0]\nGameServer.NewPlayerGMLevel = 0\n\n# basic\nSERVER_SID = <{$rs.server_id}>\nSERVER_Name = <{$rs.server_name}>\n\n# server type : QATEST / NORMAL \nSERVER_QATEST = <{$rs.iftest}>\n# is merged server\nSERVER_MERGE = <{$rs.ifmerge}>\n\n# eg: Kor_Android s11\nSERVER_Group = <{$rs.center_id}>\nSERVER_ID = <{$rs.show_server_id}>\n\n# 时区\nTimezone = <{$rs.timezone}>\n#format: "2015-01-01 08:00:00"\nOpenServer_Timestamp = <{$rs.openTime}>\n#2015-03-23 04:41:03\n\n\n# Database info\nDB_URL=jdbc:mysql://<{$rs.DB_PLAYERCHARACTERS_CONN.dbhost}>/<{$rs.DB_PLAYERCHARACTERS_CONN.dbname}>?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false\nDB_USER=<{$rs.DB_PLAYERCHARACTERS_CONN.dbuser}>\nDB_PASSWORD=<{$rs.DB_PLAYERCHARACTERS_CONN.dbpwd}>\n# Log Database info\nLOGDB_URL=jdbc:mysql://<{$rs.DB_LOG_CONN.dbhost}>/<{$rs.DB_LOG_CONN.dbname}>?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false\nLOGDB_USER=<{$rs.DB_LOG_CONN.dbuser}>\nLOGDB_PASSWORD=<{$rs.DB_LOG_CONN.dbpwd}>\n\n\n#充值平台屏蔽 XiaoMiForAndroid;UCForAndroid\nGameServer.FobiddenRecharge = <{$rs.forbiddenchannel}>\n\n#屏蔽协议\nGameServer.FobiddenProto = <{$rs.game_forbidden_proto}>\n\n\n\n# ########### 二次打包配置 ##############\n## PackageSignChek.NeedSignCheck true开启 其他关闭\nPackageSignChek.NeedSignCheck=<{$rs.game_PackageSignChek_NeedSignCheck}>\nPackageSignChek.KickOutFaker=<{$rs.game_PackageSignChek_KickOutFaker}>\nPackageSignChek.PrivateKey=oGS4EYRK7mhSmvZT1Op4MgYQ4h2zuWY9\nPackageSignChek.PlatformKey.MGGame=8682fe90c1cb87af1dc9438a4f423dfc\nPackageSignChek.PlatformKey=<{$rs.game_PackageSignChek_PlatformKey}>";');



ALTER TABLE `mj_server_database_conn` ADD `conn_game_user` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `conn_game_ip` ,

ADD `conn_game_pwd` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `conn_game_user` ,

ADD `conn_game_port` INT( 10 ) NULL AFTER `conn_game_pwd` ;



ALTER TABLE `mj_server_database_conn_vice` ADD `conn_game_user` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `conn_game_ip` ,

ADD `conn_game_pwd` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `conn_game_user` ,

ADD `conn_game_port` INT( 10 ) NULL AFTER `conn_game_pwd` ;



/*mj_data_mailserver_log全服发送日志添加日志表*/



CREATE TABLE IF NOT EXISTS `mj_data_mailserver_log` (

  `localId` int(11) NOT NULL AUTO_INCREMENT,

  `id` int(11) NOT NULL COMMENT '接口ID',

  `server_id` int(11) NOT NULL COMMENT '服务器ID',

  `senderName` varchar(50) NOT NULL COMMENT '发件人',

  `subject` varchar(200) NOT NULL COMMENT '主题',

  `content` varchar(500) NOT NULL COMMENT '内容',

  `cash` int(11) NOT NULL COMMENT '现金',

  `electrum` int(11) NOT NULL COMMENT '水晶',

  `itemIDList` int(11) NOT NULL COMMENT '奖励ID',

  `startDate` varchar(30) NOT NULL COMMENT '开始时间',

  `endDate` varchar(30) NOT NULL COMMENT '结束时间',

  `sendTime` varchar(30) NOT NULL COMMENT '发送时间',

  `effectiveTime` varchar(30) NOT NULL COMMENT '有效时间',

  `nextSendDateTime` varchar(30) NOT NULL COMMENT '下个发送日期',

  `updateTime` varchar(30) NOT NULL COMMENT '更新日期',

  `result` smallint(2) NOT NULL COMMENT '结果',

  `op` smallint(2) NOT NULL COMMENT '操作:1加2删',

  PRIMARY KEY (`localId`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



###########################################################################

datastat库更新:

###########################################################################



ALTER TABLE `mj_survival_rate_area` ADD `all_login` INT(10) NULL AFTER `type`;



ALTER TABLE `mj_adfrom_lv` ADD INDEX(`time`);



--

-- 表的结构 `mj_everyday_login_record`

--



DROP TABLE IF EXISTS `mj_everyday_login_record`;

CREATE TABLE IF NOT EXISTS `mj_everyday_login_record` (

`id` int(10) NOT NULL,

  `cdate` int(4) NOT NULL,

  `type` tinyint(1) NOT NULL COMMENT 'type 1过滤IP 设备数;2不过滤IP 帐号数',

  `area` varchar(100) DEFAULT NULL,

  `server` varchar(100) NOT NULL,

  `current_login_all` longtext,

  `current_login_new` longtext,

  `current_login_allcount` int(10) DEFAULT '0',

  `current_login_newcount` int(10) DEFAULT '0',

  `current_reg_new` longtext,

  `current_reg_newcount` int(11) DEFAULT NULL

) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='每日总登录，新登录';



--

-- Indexes for dumped tables

--



--

-- Indexes for table `mj_everyday_login_record`

--

ALTER TABLE `mj_everyday_login_record`

 ADD PRIMARY KEY (`id`), ADD KEY `cdate` (`cdate`), ADD KEY `area` (`area`), ADD KEY `server` (`server`);



--

-- AUTO_INCREMENT for dumped tables

--



--

-- AUTO_INCREMENT for table `mj_everyday_login_record`

--

ALTER TABLE `mj_everyday_login_record`

MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;









DROP TABLE IF EXISTS `mj_everyday_login_record_pf`;

CREATE TABLE IF NOT EXISTS `mj_everyday_login_record_pf` (

`id` int(10) NOT NULL,

  `cdate` int(4) NOT NULL,

  `type` tinyint(1) NOT NULL COMMENT 'type 1过滤IP 设备数;2不过滤IP 帐号数',

  `area` varchar(100) DEFAULT NULL,

  `server` varchar(100) NOT NULL,

  `current_login_all` longtext,

  `current_login_new` longtext,

  `current_login_allcount` int(10) DEFAULT '0',

  `current_login_newcount` int(10) DEFAULT '0',

  `current_reg_new` longtext,

  `current_reg_newcount` int(11) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='每日总登录，新登录';



--

-- Indexes for dumped tables

--



--

-- Indexes for table `mj_everyday_login_record_pf`

--

ALTER TABLE `mj_everyday_login_record_pf`

 ADD PRIMARY KEY (`id`), ADD KEY `cdate` (`cdate`), ADD KEY `area` (`area`), ADD KEY `server` (`server`);



--

-- AUTO_INCREMENT for dumped tables

--



--

-- AUTO_INCREMENT for table `mj_everyday_login_record_pf`

--

ALTER TABLE `mj_everyday_login_record_pf`

MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;



--

-- 表的结构 `mj_survival_rate_pflog`

--



DROP TABLE IF EXISTS `mj_survival_rate_pflog`;

CREATE TABLE IF NOT EXISTS `mj_survival_rate_pflog` (

`id` int(11) NOT NULL,

  `type` smallint(6) NOT NULL COMMENT '1过/2不过',

  `date` varchar(50) COLLATE utf8_estonian_ci NOT NULL COMMENT '时间',

  `all_login` int(11) DEFAULT NULL,

  `num_l2` int(11) NOT NULL COMMENT '二登数',

  `reg_l2` int(11) NOT NULL COMMENT '二新注册数',

  `num_l3` int(11) NOT NULL,

  `reg_l3` int(11) NOT NULL,

  `num_l4` int(11) NOT NULL,

  `reg_l4` int(11) NOT NULL,

  `num_l5` int(11) NOT NULL,

  `reg_l5` int(11) NOT NULL,

  `num_l6` int(11) NOT NULL,

  `reg_l6` int(11) NOT NULL,

  `num_l7` int(11) NOT NULL,

  `reg_l7` int(11) NOT NULL,

  `num_l8` int(11) NOT NULL,

  `reg_l8` int(11) NOT NULL,

  `num_l14` int(11) NOT NULL,

  `reg_l14` int(11) NOT NULL,

  `num_l30` int(11) NOT NULL,

  `reg_l30` int(11) NOT NULL,

  `area` varchar(100) COLLATE utf8_estonian_ci NOT NULL COMMENT '平台',

  `server` varchar(50) COLLATE utf8_estonian_ci NOT NULL COMMENT '服务器'

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;



--

-- Indexes for dumped tables

--



--

-- Indexes for table `mj_survival_rate_pflog`

--

ALTER TABLE `mj_survival_rate_pflog`

 ADD PRIMARY KEY (`id`);



--

-- AUTO_INCREMENT for dumped tables

--



--

-- AUTO_INCREMENT for table `mj_survival_rate_pflog`

--

ALTER TABLE `mj_survival_rate_pflog`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;

ALTER TABLE `mj_survival_rate_area` CHANGE `all_login` `all_login` INT(10) NULL DEFAULT '0';



###############################################################################################