入门指引

介绍

系统安装

VLW机器人接入

可爱猫机器人接入

Web机器人接入

我的机器人接入
WxBot架构

目录结构

数据表字典

消息队列
升级指导

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