beemans.51vip.biz / localhost / zentaoep / zt_usertpl

cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.emVudGFvZXA=cm9vdA==.emVudGFvZXA=0
zentaoep

Server: localhost:3306 »

Database: zentaoep »

Table: zt_usertpl

#	Name	Type	Collation	Attributes	Null	Default	Extra	Action
1	id	mediumint(8)		UNSIGNED	No	None	AUTO_INCREMENT	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
2	account	char(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	type	char(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	title	varchar(150)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	content	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	public	enum('0', '1')	utf8_general_ci		No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values

Check AllWith selected:

Print view

Propose table structure

Move columns

Action	Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
Edit	Drop	PRIMARY	BTREE	Yes	No	id	2	A	No
Edit	Drop	account	BTREE	No	No	account		A	No

Information

Space usage
Data	820	B
Index	3	KiB
Overhead	324	B
Effective	3.5	KiB
Total	3.8	KiB
Optimize table

Row statistics
Format	dynamic
Collation	utf8_general_ci
Rows	2
Row length	248 B
Row size	1,946 B
Next autoindex	6
Creation	Jul 17, 2019 at 03:48 PM
Last update	Sep 24, 2021 at 10:17 AM