Scut accountserver using MySQL

1. AppSettings Add

<add key= "Snscenter_providertype" value= "Mysqldataprovider"/>

<connectionStrings>
<add name= "Snscenter" providername= "Mysqldataprovider" connectionstring= "server=192.168.1.5;database=test;uid= root;pwd=123456 "/>
</connectionStrings>

2. Importing SQL files

SET foreign_key_checks=0;--------------------------------Table structure for ' limitdevice '------------------------ ------DROP TABLE IF EXISTS ' Limitdevice '; CREATE TABLE ' limitdevice ' (' ID ' int (one) not null auto_increment, ' DeviceID ' varchar () DEFAULT NULL, ' Apptime ' Datet IME default NULL, ' Remark ' varchar ($) 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 () not null auto_increment, ' UserID ' bigint () DEFAULT NULL, ' LogTime ' d Atetime default NULL, ' ipaddr ' varchar (all) default null, ' LogType ' smallint (6) default NULL, PRIMARY KEY (' Logid ')) ENG Ine=innodb DEFAULT Charset=utf8;--------------------------------Records of Loguserlogin--------------------------- ----- ------------------------------table structure for ' passportloginlog '------------------------------DROP table IF EXISTS ' Passportloginlog ' ; CREATE TABLE ' passportloginlog ' (' ID ' int (one) not null auto_increment, ' DeviceID ' varchar () DEFAULT NULL, ' Passporti D ' varchar () 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 (one) not null auto_increment, ' createtime ' datetime DEFAULT NULL, ' Mark ' Int (one) 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 (one) ' NOT null auto_increment, ' passportid ' varchar (+) DEFAULT NULL, ' Passport PWD ' varchar ' default null, ' DeviceID ' varchar (default null, ' Regtype ' smallint (6) default null, ' Regtime ' Datet IME default NULL, ' retailid ' varchar (default null, ' retailuser ' varchar () default NULL, ' Mobile ' varchar () DEFA ULT null, ' Mail ' varchar (+) default NULL, ' Pwdtype ' int (one) default null, ' realname ' varchar ' default NULL, ' Idcar DS ' varchar ' default null, ' Activecode ' char (TEN) default null, ' Sendactivedate ' datetime default NULL, ' Activedate ' datetime default NULL, ' weixincode ' varchar (default NULL, PRIMARY KEY (' UserId ')) Engine=innodb auto_increment=13800 The DEFAULT Charset=utf8;--------------------------------Records of snsuserinfo------------------------------------ --------------------------TabLe structure for ' userloginlog '------------------------------DROP TABLE IF EXISTS ' Userloginlog '; CREATE TABLE ' userloginlog ' (' SessionID ' bigint () not null auto_increment, ' UserID ' bigint () DEFAULT NULL, ' Addtim E ' datetime default NULL, ' Md5hash ' varchar (() default null, ' Stat ' tinyint (4) default NULL, PRIMARY KEY (' SessionID ') ) Engine=innodb DEFAULT Charset=utf8;--------------------------------Records of Userloginlog----------------------- -------

　　

Scut accountserver using MySQL