您好，databases／sql 不是最新的，能否给我发一份新的？

[Neo110]

[email protected],谢谢

[T1m0n0]

您好，同样求一份minchatdb.sql 看您这个写的很好，想学习下。谢谢您了。方便的话麻烦发我邮箱[email protected]。谢谢了

[yingwei008]

你好 想请问下 那个minchat的最新的sql发给你了没？

[yingwei008]

你好 想请问下 那个minchat的最新的sql发给你了没？

[yingwei008]

你好 想请问下 那的最新的sqlminchatdb.sql发给你了没？

[laubrence]

SQL在github 这个目录下面 https://github.com/laubrence/minchat/tree/master/database

[oceanjaya]

但似乎你之后修改了sys_user表呢 登录时的SQL语句为
select USERID, FULLNAME, NICKNAME, ACCOUNT, PASSWORD, ISEXPIRED, ISLOCK, CREATETIME, STATUS, EMAIL, MOBILE, PHONE, SEX, PICTURE, ORIGINAL_PICTURE, FROMTYPE, ACCOUNTTYPE, REF_TABLE, REF_ID, WEIXIN, WEIXIN_USERID, WEIXIN_STATUS, IS_FIRST_LOGIN, WELMSGSEND_STATUS, MSGSEND_STATUS, ENT_ID, WXENT_ID, RECORD_STATUS from sys_user where account = ? AND record_status=100003; ORIGINAL_PICTURE, FROMTYPE, ACCOUNTTYPE, REF_TABLE, REF_ID, WEIXIN, WEIXIN_USERID, WEIXIN_STATUS, IS_FIRST_LOGIN, WELMSGSEND_STATUS, MSGSEND_STATUS, ENT_ID, WXENT_ID, RECORD_STATUS这些属性都没有呢。请问你是不是在把这个系统部署到微信公众上呀，能继续更新您的项目吗?

[laubrence]

把没用的字段删掉就行了

2016-10-27 21:14 GMT+08:00 Ocean Jaya [email protected]:

但似乎你之后修改了sys_user表呢 登录时的SQL语句为

select USERID, FULLNAME, NICKNAME, ACCOUNT, PASSWORD, ISEXPIRED, ISLOCK, CREATETIME, STATUS, EMAIL, MOBILE, PHONE, SEX, PICTURE, ORIGINAL_PICTURE, FROMTYPE, ACCOUNTTYPE, REF_TABLE, REF_ID, WEIXIN, WEIXIN_USERID, WEIXIN_STATUS, IS_FIRST_LOGIN, WELMSGSEND_STATUS, MSGSEND_STATUS, ENT_ID, WXENT_ID, RECORD_STATUS from sys_user where account = ? AND record_status=100003; ORIGINAL_PICTURE, FROMTYPE, ACCOUNTTYPE, REF_TABLE, REF_ID, WEIXIN, WEIXIN_USERID, WEIXIN_STATUS, IS_FIRST_LOGIN, WELMSGSEND_STATUS, MSGSEND_STATUS, ENT_ID, WXENT_ID, RECORD_STATUS这些属性都没有呢。 请问你是不是在把这个系统部署到微信公众上呀，能继续更新您的项目吗?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/laubrence/minchat/issues/5#issuecomment-256636901, or mute the thread https://github.com/notifications/unsubscribe-auth/ACF-sBLp_bnTHTBLWCeWiMHLgxsvAmkdks5q4KOagaJpZM4Jqeqc .

[yingwei008]

没有部署起来，发现还少了其他数据库表结构！

[email protected]

发件人： zhaohongfeng 发送时间： 2016-10-31 09:35 收件人： laubrence/minchat 抄送： yingwei008; Comment 主题： Re: [laubrence/minchat] 您好，databases／sql 不是最新的，能否给我发一份新的？ (#5) 把没用的字段删掉就行了

2016-10-27 21:14 GMT+08:00 Ocean Jaya [email protected]:

但似乎你之后修改了sys_user表呢 登录时的SQL语句为

select USERID, FULLNAME, NICKNAME, ACCOUNT, PASSWORD, ISEXPIRED, ISLOCK, CREATETIME, STATUS, EMAIL, MOBILE, PHONE, SEX, PICTURE, ORIGINAL_PICTURE, FROMTYPE, ACCOUNTTYPE, REF_TABLE, REF_ID, WEIXIN, WEIXIN_USERID, WEIXIN_STATUS, IS_FIRST_LOGIN, WELMSGSEND_STATUS, MSGSEND_STATUS, ENT_ID, WXENT_ID, RECORD_STATUS from sys_user where account = ? AND record_status=100003; ORIGINAL_PICTURE, FROMTYPE, ACCOUNTTYPE, REF_TABLE, REF_ID, WEIXIN, WEIXIN_USERID, WEIXIN_STATUS, IS_FIRST_LOGIN, WELMSGSEND_STATUS, MSGSEND_STATUS, ENT_ID, WXENT_ID, RECORD_STATUS这些属性都没有呢。 请问你是不是在把这个系统部署到微信公众上呀，能继续更新您的项目吗?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/laubrence/minchat/issues/5#issuecomment-256636901, or mute the thread https://github.com/notifications/unsubscribe-auth/ACF-sBLp_bnTHTBLWCeWiMHLgxsvAmkdks5q4KOagaJpZM4Jqeqc .

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[T1m0n0]

删了字段部署好了，谢谢您了

[laubrence]

应该都全了，真少的话你看程序里用到的表 自己创建下就行了

2016-11-01 13:13 GMT+08:00 T1m0n0 [email protected]:

删了字段部署好了，谢谢您了

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/laubrence/minchat/issues/5#issuecomment-257490312, or mute the thread https://github.com/notifications/unsubscribe-auth/ACF-sKwLTkiWVNtGq2ScdA6-JQ05-WoCks5q5splgaJpZM4Jqeqc .