jos_users

Field	Type	Null	Default
id	int(11)	No
name	varchar(255)	No
username	varchar(150)	No
email	varchar(100)	No
password	varchar(100)	No
usertype	varchar(25)	No
block	tinyint(4)	No	0
sendEmail	tinyint(4)	Yes	0
gid	tinyint(3)	No	1
registerDate	datetime	No	0000-00-00 00:00:00
lastvisitDate	datetime	No	0000-00-00 00:00:00
activation	varchar(100)	No
params	text	No

 Indexes :

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	2	id
id_2	UNIQUE	2	id
name_2	UNIQUE	2	name
username_3	UNIQUE	2	username
email_3	UNIQUE	2	email
password_2	UNIQUE	2	password
usertype_3	UNIQUE	2	usertype
block_2	UNIQUE	2	block
gid_2	UNIQUE	2	gid
registerDate_2	UNIQUE	2	registerDate
lastvisitDate_2	UNIQUE	2	lastvisitDate
activation_2	UNIQUE	2	activation
activation_4	UNIQUE	2	activation
name_4	UNIQUE	2	name
id_3	UNIQUE	2	id
password_4	UNIQUE	2	password
block_3	UNIQUE	2	block
email_5	UNIQUE	2	email
username_7	UNIQUE	2	username
lastvisitDate_3	UNIQUE	2	lastvisitDate
usertype_6	UNIQUE	2	usertype
sendEmail_2	UNIQUE	None	sendEmail
usertype	INDEX	None	usertype
idx_name	INDEX	None	name
gid_block	INDEX	None	gid
			block
username	INDEX	None	username
email	INDEX	None	email
id	INDEX	None	id
name	INDEX	None	name
username_2	INDEX	None	username
email_2	INDEX	None	email
password	INDEX	None	password
usertype_2	INDEX	None	usertype
block	INDEX	None	block
sendEmail	INDEX	None	sendEmail
gid	INDEX	None	gid
registerDate	INDEX	None	registerDate
lastvisitDate	INDEX	None	lastvisitDate
activation	INDEX	None	activation
activation_5	INDEX	None	activation
username_5	INDEX	None	username
email_6	INDEX	None	email
id_4	INDEX	None	id
sendEmail_3	INDEX	None	sendEmail
block_4	INDEX	None	block
password_6	INDEX	None	password
gid_3	INDEX	None	gid
registerDate_3	INDEX	None	registerDate
usertype_7	INDEX	None	usertype
name_6	INDEX	None	name
lastvisitDate_4	INDEX	None	lastvisitDate
name_3	INDEX	None	name
username_4	INDEX	None	username
email_4	INDEX	None	email
password_3	INDEX	None	password
usertype_4	INDEX	None	usertype
activation_3	INDEX	None	activation
params	INDEX	None	params
usertype_5	INDEX	None	usertype
name_5	INDEX	None	name
password_5	INDEX	None	password
username_6	INDEX	None	username
email_7	INDEX	None	email
activation_6	INDEX	None	activation

Space usage : Type Usage Data 320 Bytes Index 4,096 Bytes Total 4,416 Bytes

Row Statistic : Statements Value Format dynamic Rows 2 Row length ø 160 Row size  ø 2,208 Bytes Next Autoindex 64 Creation Oct 23, 2017 at 07:51 AM Last update Apr 18, 2024 at 08:45 PM Last check Apr 18, 2024 at 08:45 PM