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

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_bug

The column name 'case' is a MySQL reserved keyword.

The column name 'lines' is a MySQL reserved keyword.

#	Name	Type	Collation	Attributes	Null	Default	Extra	Action
1	id	mediumint(8)			No	None	AUTO_INCREMENT	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
2	product	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	branch	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	module	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	project	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	plan	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	story	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	storyVersion	smallint(6)			No	1		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	task	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	toTask	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	toStory	mediumint(8)			No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	title	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	keywords	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	severity	tinyint(4)			No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	pri	tinyint(3)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	type	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	os	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	browser	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	hardware	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	found	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
21	steps	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
22	status	enum('active', 'resolved', 'closed')	utf8_general_ci		No	active		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
23	subStatus	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
24	color	char(7)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
25	confirmed	tinyint(1)			No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
26	activatedCount	smallint(6)			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
27	activatedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
28	mailto	text	utf8_general_ci		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
29	openedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
30	openedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
31	openedBuild	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
32	assignedTo	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
33	assignedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
34	deadline	date			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
35	resolvedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
36	resolution	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
37	resolvedBuild	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
38	resolvedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
39	closedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
40	closedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
41	duplicateBug	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
42	linkBug	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
43	case	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
44	caseVersion	smallint(6)			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
45	feedback	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
46	result	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
47	repo	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
48	entry	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
49	lines	varchar(10)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
50	v1	varchar(40)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
51	v2	varchar(40)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
52	repoType	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
53	testtask	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
54	lastEditedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
55	lastEditedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
56	deleted	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	6030	A	No
Edit	Drop	product	BTREE	No	No	product	43	A	No
Edit	Drop	project	BTREE	No	No	project	207	A	No
Edit	Drop	status	BTREE	No	No	status	7	A	No
Edit	Drop	plan	BTREE	No	No	plan	4	A	No
Edit	Drop	story	BTREE	No	No	story	502	A	No
Edit	Drop	case	BTREE	No	No	case	167	A	No
Edit	Drop	assignedTo	BTREE	No	No	assignedTo	43	A	No
Edit	Drop	toStory	BTREE	No	No	toStory	2	A	No
Edit	Drop	result	BTREE	No	No	result	158	A	No

Information

Space usage
Data	2	MiB
Index	557	KiB
Total	2.5	MiB

Row statistics
Format	dynamic
Collation	utf8_general_ci
Rows	6,030
Row length	347 B
Row size	442 B
Next autoindex	6,031
Creation	Jan 26, 2021 at 08:10 AM
Last update	Sep 05, 2024 at 08:17 PM
Last check	Jan 26, 2021 at 08:10 AM