首页 > 代码库 > scut AccountServer 使用mysql
scut AccountServer 使用mysql
1. appSettings 添加
<add key="Snscenter_ProviderType" value="http://www.mamicode.com/MySqlDataProvider" />
<connectionStrings>
<add name="SnsCenter" providerName="MySqlDataProvider" connectionString="server=192.168.1.5;database=test;uid=root;pwd=123456"/>
</connectionStrings>
2.导入sql文件
SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `limitdevice` -- ---------------------------- DROP TABLE IF EXISTS `limitdevice`; CREATE TABLE `limitdevice` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `DeviceID` varchar(50) DEFAULT NULL, `AppTime` datetime DEFAULT NULL, `Remark` varchar(200) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of limitdevice -- ---------------------------- -- ---------------------------- -- Table structure for `loguserlogin` -- ---------------------------- DROP TABLE IF EXISTS `loguserlogin`; CREATE TABLE `loguserlogin` ( `LogID` bigint(20) NOT NULL AUTO_INCREMENT, `UserID` bigint(20) DEFAULT NULL, `LogTime` datetime DEFAULT NULL, `IPAddr` varchar(15) DEFAULT NULL, `LogType` smallint(6) DEFAULT NULL, PRIMARY KEY (`LogID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of loguserlogin -- ---------------------------- -- ---------------------------- -- Table structure for `passportloginlog` -- ---------------------------- DROP TABLE IF EXISTS `passportloginlog`; CREATE TABLE `passportloginlog` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `DeviceID` varchar(50) DEFAULT NULL, `PassportID` varchar(50) DEFAULT NULL, `LoginTime` datetime DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of passportloginlog -- ---------------------------- -- ---------------------------- -- Table structure for `snspassportlog` -- ---------------------------- DROP TABLE IF EXISTS `snspassportlog`; CREATE TABLE `snspassportlog` ( `PassportID` int(11) NOT NULL AUTO_INCREMENT, `CreateTime` datetime DEFAULT NULL, `Mark` int(11) DEFAULT NULL, `RegPushTime` datetime DEFAULT NULL, `RegTime` datetime DEFAULT NULL, PRIMARY KEY (`PassportID`) ) ENGINE=InnoDB AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of snspassportlog -- ---------------------------- -- ---------------------------- -- Table structure for `snsuserinfo` -- ---------------------------- DROP TABLE IF EXISTS `snsuserinfo`; CREATE TABLE `snsuserinfo` ( `UserId` int(11) NOT NULL AUTO_INCREMENT, `PassportID` varchar(32) DEFAULT NULL, `PassportPwd` varchar(50) DEFAULT NULL, `DeviceID` varchar(50) DEFAULT NULL, `RegType` smallint(6) DEFAULT NULL, `RegTime` datetime DEFAULT NULL, `RetailID` varchar(50) DEFAULT NULL, `RetailUser` varchar(50) DEFAULT NULL, `Mobile` varchar(12) DEFAULT NULL, `Mail` varchar(50) DEFAULT NULL, `PwdType` int(11) DEFAULT NULL, `RealName` varchar(20) DEFAULT NULL, `IDCards` varchar(20) DEFAULT NULL, `ActiveCode` char(10) DEFAULT NULL, `SendActiveDate` datetime DEFAULT NULL, `ActiveDate` datetime DEFAULT NULL, `WeixinCode` varchar(50) DEFAULT NULL, PRIMARY KEY (`UserId`) ) ENGINE=InnoDB AUTO_INCREMENT=1380000 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of snsuserinfo -- ---------------------------- -- ---------------------------- -- Table structure for `userloginlog` -- ---------------------------- DROP TABLE IF EXISTS `userloginlog`; CREATE TABLE `userloginlog` ( `SessionID` bigint(20) NOT NULL AUTO_INCREMENT, `UserID` bigint(20) DEFAULT NULL, `AddTime` datetime DEFAULT NULL, `Md5Hash` varchar(50) DEFAULT NULL, `Stat` tinyint(4) DEFAULT NULL, PRIMARY KEY (`SessionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of userloginlog -- ----------------------------
scut AccountServer 使用mysql
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。