入门指引

介绍

系统安装

西瓜机器人接入

可爱猫机器人接入

Web机器人接入
WxBot架构

目录结构

数据表字典

消息队列
HttpApi

前言（必看）

消息回调

常量表

常用端口号

API - OutPut // 在框架记录页输出一行信息

API - GetContact // 获取通讯录

API - GetRobotList // 获取登录账号列表

API - GetRobotInfo // 获取登录账号信息

API - SendTextMsg // 发送文字消息

API - SendGroupMsgAndAt // 发送群消息并艾特成员

API - SendImageMsg // 发送图片消息

API - SendCardMsg // 发送名片消息

API - SendMessageRecord // 发送聊天记录

API - SendLinkMsg // 发送链接消息

API - SendShareLinkMsg // 发送普通分享链接

API - SendMusicLinkMsg // 发送一条可播放的歌曲链接

API - SendXmlMsg // 发送小程序消息

API - SendFileMsg // 发送文件消息

API - SendVideoMsg // 发送视频消息

API - SendEmojiMsg // 发送动态表情消息

API - ModifyFriendNote // 修改好友备注

API - DeleteFriend // 删除好友

API - AgreeFriendVerify // 同意好友请求

API - AddFriendBySearch // 添加好友

API - QuitGroup // 退出群聊

API - AccepteTransfer // 同意转账

API - ModifyGroupName // 修改群名称

API - ModifyGroupNotice // 修改群公告

API - AgreeGroupInvite // 同意进群

API - RemoveGroupMember // 踢出一位群成员

API - OnTopContact // 置顶联系人

API - OffTopContact // 取消置顶联系人

API - OnNotDisturb // 开启消息免打扰

API - OffNotDisturb // 关闭消息免打扰

API - InviteInGroupByLink // 邀请好友入群_发链接

API - InviteInGroup // 邀请好友入群_直接拉

API - BuildingGroup // 建立新群

API - GetLoginWxid // 获取登录微信ID

API - GetHeadimgByWxid // 获取某个好友头像

API - GetNameByWxid // 通过ID获取好友,群聊,公众号的昵称(缓存获取)

API - GetNoteByWxid // 获取好友的备注(缓存获取)

API - GetChatnumByWxid // 获取好友微信号(缓存获取)

API - GetGroupChatnumByWxid // 获取群成员微信号(缓存获取)

API - GetGrouplist // 获取群列表

API - GetFriendlist // 获取好友列表

API - GetSubscriptionlist // 获取公众号列表

API - SearchAccount // 搜索好友

API - GetDetailInfoByWxid // 获取某个好友详细

API - GetGroupMemberDetailInfo // 获取某个群成员详细

API - GetGroupMember // 获取群成员列表

API - GetGroupcardByWxid // 获取某个群成员详细

API - GetFileFoBase64 // 获取文件返回该文件的Base64编码

API - ExitWeChat // 退出指定微信

API - RestartFramework // 重启框架

API - GetMoments // 获取朋友圈

API - GetMomentsForFriend // 获取好友朋友圈

API - MomentsLike // 朋友圈点赞

API - MomentsComment // 朋友圈评论

API - MomentsSend // 发朋友圈

API - ContactSave // 保存到通讯录

API - ContactRemove // 移出通讯录

API - OpenWeChatBrowser // 打开内置浏览器

API - FavoritesGetList // 获取收藏列表

API - FavoritesMsg // 收藏消息

API - SendFavoritesMsg // 发送收藏消息

API - GetGroupNoticeList // 获取群公告列表

API - AntiWithdrawON // 开启防撤回

API - AntiWithdrawOFF // 关闭防撤回

API - WithdrawOwnMessage // 撤回自身消息

API - SubscriptionOfficialAccounts // 关注公众号

API - UnsubscribeOfficialAccounts // 取关公众号

API - SpeechToText // 语音转文本

API - GetInfoByWxid // wxid查详细信息

API - RejectTransfer // 拒收转账

API - ForwardMsg // 转发消息

API - SesNicknameInGroup // 修改我在群里的昵称

API - AddFriendByGroup // 添加群成员好友

API - GetInviteInInfo // 获取群成员邀请信息

API - SetHaveread // 设置会话已读

API - GetFriendsStatus // 好友状态检测

API - CleanChathistory // 清理微信聊天记录

API - SendMsgAtAll // 发送群消息并艾特所有人

API - GetRuntime // 获取框架运行时长

API - GetWxidRecmsgNum // 获取微信收信数量

API - GetWxidSendmsgNum // 获取微信发信数量

API - GetWxidLogintime // 获取微信登录时长

API - SendMoments_Like // 发链接朋友圈

API - SendMoments_Video // 发视频朋友圈

API - SendMoments_Img // 发图片朋友圈

API - StartWeChat // 启动个人微信

API - SendMoments_Str // 发文本朋友圈

API - ExitWeChatLoginWin // 关闭已启动的个人扫码登录窗口

API - GetCfg // 读取httpApi功能配置

API - SetCfg // 写入httpApi功能配置

企微API - SendTextMsgEnterprise // 发送文字消息_企业

企微API - SendGroupMsgAndAtEnterprise // 发送群消息并艾特成员_企业

企微API - SendImageMsgEnterprise // 发送图片消息_企业

企微API - SendCardMsgEnterprise // 发送名片消息_企业

企微API - SendLinkMsgEnterprise // 发送链接消息_企业

企微API - SendXmlMsgEnterprise // 发送小程序消息_企业

企微API - SendFileMsgEnterprise // 发送文件消息_企业

企微API - SendVideoMsgEnterprise // 发送视频消息_企业

企微API - SendEmojiMsgEnterprise // 发送动态表情消息_企业
升级指导

2.0.4 升级到2.0.5版本

2.0.2 升级到2.0.4版本

2.0.1 升级到2.0.2版本

2.0.0 升级到2.0.1版本

1.7.0 升级到2.0.0版本

1.6.0 升级到1.7.0版本

1.5.1 升级到1.6.0版本

1.5.0 升级到1.5.1版本

1.4.0 升级到1.5.0版本

1.3.0 升级到1.4.0版本

1.2.2 升级到1.3.0版本

1.0.0 升级到1.2.2版本

数据表字典

Snapshot on 2022-08-02 00:17:57

Database: wxbot

ky_admin

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	group_id	int(10)	No	1
	username	varchar(50)	No
	password	char(60)	No
	email	varchar(100)	No
	mobile	varchar(15)	No
	realname	varchar(20)	No
	ip	varchar(15)	No
	status	tinyint(1)	No	1
	last_time	int(10) UNSIGNED	No	0
	create_time	int(10)	No	0
	update_time	int(10)	No	0

ky_admin_group

	Field	Type	Allow Null	Default Value
P	id	smallint(5) UNSIGNED	No
	name	varchar(15)	No
	title	char(100)	No
	status	tinyint(1)	No	1
	rules	text	No
	sort	tinyint(3)	No	0
	pid	int(10) UNSIGNED	No	0
	create_time	int(11)	No	0
	remark	varchar(255)	No
	update_time	int(10) UNSIGNED	No	0

ky_admin_rule

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	name	varchar(30)	No
	title	varchar(30)	No
	pid	int(10) UNSIGNED	No	0
	icon	varchar(30)	No
	href	varchar(50)	No
	target	enum('_self','_blank')	No	'_self'
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	sort	int(6) UNSIGNED	No	0
	type	tinyint(1) UNSIGNED	No	1

ky_bot

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10)	No	1
	title	varchar(50)	No
	app_key	varchar(32)	No
	nickname	varchar(50)	No
	headimgurl	varchar(255)	No
	status	tinyint(1)	No	1
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	uuid	varchar(30)	No
	uin	varchar(32)	No	'0'
	is_current	tinyint(1) UNSIGNED	No	0
	login_time	int(10) UNSIGNED	No	0
	protocol	varchar(20)	No	'vlw'
	url	varchar(200)	No
	alive	tinyint(1) UNSIGNED	No	0
	free	tinyint(1) UNSIGNED	No	1

ky_bot_groupmember

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	bot_id	int(10) UNSIGNED	No	0
	group_id	int(10) UNSIGNED	No	0
	wxid	varchar(100)	No	'0'
	nickname	varchar(50)	No
	group_nickname	varchar(50)	No
	username	varchar(100)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0

ky_bot_member

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	uin	varchar(32)	No
	alias	varchar(30)	No
	nickname	varchar(50)	No
	remark_name	varchar(50)	No
	username	varchar(100)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	type	varchar(10)	No	'friend'
	headimgurl	varchar(200)	No
	wxid	varchar(100)	No
	internal	tinyint(1) UNSIGNED	No	1

ky_district

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	title	varchar(50)	No
	pid	int(10) UNSIGNED	No	0

ky_emoji_code

	Field	Type	Allow Null	Default Value
P	id	int(11)	No
	class	varchar(30)	No
	name	varchar(40)	No
	unified	varchar(20)	No
	docomo	varchar(20)	No
	kddi	varchar(20)	No
	softbank	varchar(20)	No
	google	varchar(20)	No
	softb_unicode	varchar(20)	No

ky_forward

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10)	No
	bot_id	int(10) UNSIGNED	No	0
	group_id	int(10) UNSIGNED	No	0
	officer	varchar(200)	No
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	status	tinyint(1) UNSIGNED	No	1
	wxids	text	Yes

ky_group_rule

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	wxids	text	Yes
	rule	varchar(20)	No	'rm'
	status	tinyint(1) UNSIGNED	No	0
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	value	varchar(100)	No

ky_hanzi_config

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	key	varchar(30)	No
	value	text	Yes
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	wxids	text	Yes

ky_keyword

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10)	No
	bot_id	int(10) UNSIGNED	No	0
	keyword	varchar(50)	No
	media_type	varchar(20)	No
	media_id	int(10)	No	0
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	wxids	text	Yes
	sort	int(6) UNSIGNED	No	0
	user_type	tinyint(1) UNSIGNED	No	0

ky_media_file_1

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(255)	No
	location	varchar(20)	No	'qiniu'

ky_media_file_2

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(255)	No
	location	varchar(20)	No	'qiniu'

ky_media_file_3

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(255)	No
	location	varchar(20)	No	'qiniu'

ky_media_file_4

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(255)	No
	location	varchar(20)	No	'qiniu'

ky_media_file_5

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(255)	No
	location	varchar(20)	No	'qiniu'

ky_media_image_1

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	enum('bmp','jpg','jpeg','png','gif')	No	'jpg'
	location	varchar(50)	No

ky_media_image_2

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	enum('bmp','jpg','jpeg','png','gif')	No	'jpg'
	location	varchar(50)	No

ky_media_image_3

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	enum('bmp','jpg','jpeg','png','gif')	No	'jpg'
	location	varchar(50)	No

ky_media_image_4

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	enum('bmp','jpg','jpeg','png','gif')	No	'jpg'
	location	varchar(50)	No

ky_media_image_5

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	enum('bmp','jpg','jpeg','png','gif')	No	'jpg'
	location	varchar(50)	No

ky_media_link_1

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	desc	varchar(255)	No
	url	varchar(200)	No
	image_url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0

ky_media_link_2

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	desc	varchar(255)	No
	url	varchar(200)	No
	image_url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0

ky_media_link_3

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	desc	varchar(255)	No
	url	varchar(200)	No
	image_url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0

ky_media_link_4

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	desc	varchar(255)	No
	url	varchar(200)	No
	image_url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0

ky_media_link_5

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	desc	varchar(255)	No
	url	varchar(200)	No
	image_url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0

ky_media_text_1

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	title	varchar(30)	No
	content	text	No
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_media_text_2

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	title	varchar(30)	No
	content	text	No
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_media_text_3

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	title	varchar(30)	No
	content	text	No
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_media_text_4

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	title	varchar(30)	No
	content	text	No
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_media_text_5

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	title	varchar(30)	No
	content	text	No
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_media_video_1

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(8)	No

ky_media_video_2

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(8)	No

ky_media_video_3

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(8)	No

ky_media_video_4

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(8)	No

ky_media_video_5

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(11) UNSIGNED	No	0
	title	varchar(50)	No
	url	varchar(200)	No
	create_time	int(10)	No	0
	update_time	int(10)	No	0
	size	int(10) UNSIGNED	No	0
	ext	varchar(8)	No

ky_reply

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10)	No
	bot_id	int(10) UNSIGNED	No	0
	event	varchar(10)	No	'beadded'
	media_type	varchar(20)	No
	media_id	int(10)	No	0
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	wxids	text	Yes
	sort	int(6) UNSIGNED	No	0
	need_at	tinyint(1) UNSIGNED	No	0
	handle_type	varchar(20)	No	'msg'
	msg_type	smallint(6) UNSIGNED	No	1

ky_setting

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	name	varchar(30)	No
	title	varchar(30)	No
	value	text	Yes
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_task

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	title	varchar(100)	No
	wxids	text	Yes
	plan_time	int(10) UNSIGNED	No	0
	complete_time	int(10) UNSIGNED	No	0
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	status	tinyint(1) UNSIGNED	No	1
	medias	text	Yes
	circle	tinyint(1) UNSIGNED	No	1
	plan_hour	char(5)	No	'00:00'
	atall	tinyint(1) UNSIGNED	No	0

ky_tj_group

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	group_id	int(10) UNSIGNED	No	0
	day	char(10)	No	'0000-00-00'
	add_num	int(10) UNSIGNED	No	1
	decr_num	int(10) UNSIGNED	No	0
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0

ky_tpzs_channel

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	title	varchar(50)	No
	contact_name	varchar(30)	No
	contact_tel	varchar(15)	No
	ckid	varchar(20)	No
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_tpzs_config

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	key	varchar(30)	No
	value	text	Yes
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_tpzs_gather

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10)	No
	bot_id	int(10) UNSIGNED	No	0
	group_id	int(10) UNSIGNED	No	0
	officer	varchar(200)	No
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	status	tinyint(1) UNSIGNED	No	1
	wxids	text	Yes
	universal	tinyint(1) UNSIGNED	No	1

ky_tpzs_grouppos

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	bot_id	int(10) UNSIGNED	No	0
	group_id	int(10) UNSIGNED	No	0
	position_id	int(10) UNSIGNED	No	0
	channel_id	int(10) UNSIGNED	No	0
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_tpzs_position

	Field	Type	Allow Null	Default Value
P	id	int(11) UNSIGNED	No
	title	varchar(100)	No
	union_id	int(10) UNSIGNED	No	0
	position_id	varchar(64)	No
	type	tinyint(1) UNSIGNED	No	1
	admin_id	int(11) UNSIGNED	No	0
	create_time	int(11) UNSIGNED	No	0
	update_time	int(11) UNSIGNED	No	0
	status	tinyint(1) UNSIGNED	No	1
	jd_type	tinyint(1) UNSIGNED	No	0
	siteid	varchar(200)	No
	default	tinyint(1) UNSIGNED	No	0
	union_type	tinyint(1) UNSIGNED	No	3

ky_tpzs_task

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	members	text	Yes
	sku_id	varchar(50)	No
	content	text	Yes
	img	varchar(200)	No
	plan_time	int(10) UNSIGNED	No	0
	complete_time	int(10) UNSIGNED	No	0
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	status	tinyint(1) UNSIGNED	No	1
	type	varchar(20)	No	'basic'
	title	varchar(50)	No

ky_tpzs_team

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	groups	text	Yes
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_tpzs_union

	Field	Type	Allow Null	Default Value
P	id	int(11) UNSIGNED	No
	title	varchar(50)	No
	unionid	varchar(20)	No
	app_key	varchar(200)	No
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(11) UNSIGNED	No	0
	update_time	int(11) UNSIGNED	No	0
	admin_id	int(11) UNSIGNED	No	0
	default	tinyint(1) UNSIGNED	No	0
	type	varchar(20)	No	'jd'

ky_whiteid

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	group_wxid	varchar(32)	No
	wxids	text	Yes
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_yhq_code

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	coupon_id	int(10) UNSIGNED	No	0
	code	varchar(50)	No
	code_url	varchar(200)	No
	wxid	varchar(64)	No
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(10) UNSIGNED	No
	update_time	int(10) UNSIGNED	No	0
	send_time	int(10) UNSIGNED	No	0

ky_yhq_config

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	key	varchar(30)	No
	value	text	Yes
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0

ky_yhq_coupon

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	title	varchar(50)	No
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(10) UNSIGNED	No
	update_time	int(10) UNSIGNED	No	0

ky_yhq_reply

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10)	No
	bot_id	int(10) UNSIGNED	No	0
	event	varchar(10)	No	'beadded'
	content	text	No
	status	tinyint(1) UNSIGNED	No	1
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0
	wxids	text	Yes
	sort	int(6) UNSIGNED	No	0
	coupon_id	int(10) UNSIGNED	No	0

ky_ai_config

	Field	Type	Allow Null	Default Value
P	id	int(10) UNSIGNED	No
	admin_id	int(10) UNSIGNED	No	0
	bot_id	int(10) UNSIGNED	No	0
	key	varchar(30)	No
	value	text	Yes
	create_time	int(10) UNSIGNED	No	0
	update_time	int(10) UNSIGNED	No	0