search

laubrence / minchat

基于tomcat 7. 0.56 websocket的在线客服系统
172 stars 90 forks source link

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

Open Neo110 opened 8 years ago

Neo110 commented 8 years ago

zsvc@163.com,谢谢

T1m0n0 commented 8 years ago

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

yingwei008 commented 7 years ago

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

yingwei008 commented 7 years ago

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

yingwei008 commented 7 years ago

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

laubrence commented 7 years ago

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

oceanjaya commented 7 years ago

但似乎你之后修改了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 commented 7 years ago

把没用的字段删掉就行了

2016-10-27 21:14 GMT+08:00 Ocean Jaya notifications@github.com:

但似乎你之后修改了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 commented 7 years ago

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

hudapeng423@163.com

发件人： 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 notifications@github.com:

但似乎你之后修改了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 commented 7 years ago

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

laubrence commented 7 years ago

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

2016-11-01 13:13 GMT+08:00 T1m0n0 notifications@github.com:

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

— 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 .