phorum_messages

Field	Type	Null	Default
message_id	int(10)	No
forum_id	int(10)	No	0
thread	int(10)	No	0
parent_id	int(10)	No	0
author	varchar(37)	No
subject	varchar(255)	No
body	text	No
email	varchar(100)	No
ip	varchar(255)	No
status	tinyint(4)	No	2
msgid	varchar(100)	No
modifystamp	int(10)	No	0
user_id	int(10)	No	0
thread_count	int(10)	No	0
moderator_post	tinyint(3)	No	0
sort	tinyint(4)	No	2
datestamp	int(10)	No	0
meta	mediumtext	Yes	NULL
viewcount	int(10)	No	0
closed	tinyint(4)	No	0

 Indexes :

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	3	message_id
message_id_2	UNIQUE	3	message_id
subject_2	UNIQUE	3	subject
msgid_2	UNIQUE	3	msgid
modifystamp_2	UNIQUE	3	modifystamp
thread_count_2	UNIQUE	3	thread_count
datestamp_2	UNIQUE	3	datestamp
thread_count_3	UNIQUE	3	thread_count
msgid_5	UNIQUE	3	msgid
subject_4	UNIQUE	3	subject
datestamp_4	UNIQUE	3	datestamp
modifystamp_4	UNIQUE	3	modifystamp
thread_message	INDEX	None	thread
			message_id
thread_forum	INDEX	None	thread
			forum_id
special_threads	INDEX	None	sort
			forum_id
status_forum	INDEX	None	status
			forum_id
list_page_float	INDEX	None	forum_id
			parent_id
			modifystamp
list_page_flat	INDEX	None	forum_id
			parent_id
			thread
post_count	INDEX	None	forum_id
			status
			parent_id
dup_check	INDEX	None	forum_id
			author
			subject
			datestamp
forum_max_message	INDEX	None	forum_id
			message_id
			status
			parent_id
last_post_time	INDEX	None	forum_id
			status
			modifystamp
next_prev_thread	INDEX	None	forum_id
			status
			thread
user_id	INDEX	None	user_id
message_id	INDEX	None	message_id
forum_id	INDEX	None	forum_id
thread	INDEX	None	thread
parent_id	INDEX	None	parent_id
author	INDEX	None	author
subject	INDEX	None	subject
email	INDEX	None	email
ip	INDEX	None	ip
status	INDEX	None	status
msgid	INDEX	None	msgid
modifystamp	INDEX	None	modifystamp
user_id_2	INDEX	None	user_id
thread_count	INDEX	None	thread_count
moderator_post	INDEX	None	moderator_post
sort	INDEX	None	sort
datestamp	INDEX	None	datestamp
viewcount	INDEX	None	viewcount
closed	INDEX	None	closed
user_id_3	INDEX	None	user_id
modifystamp_3	INDEX	None	modifystamp
email_3	INDEX	None	email
msgid_4	INDEX	None	msgid
viewcount_2	INDEX	None	viewcount
forum_id_2	INDEX	None	forum_id
sort_2	INDEX	None	sort
moderator_post_2	INDEX	None	moderator_post
thread_2	INDEX	None	thread
parent_id_2	INDEX	None	parent_id
datestamp_3	INDEX	None	datestamp
thread_count_4	INDEX	None	thread_count
author_2	INDEX	None	author
subject_3	INDEX	None	subject
body	INDEX	None	body
email_2	INDEX	None	email
ip_2	INDEX	None	ip
msgid_3	INDEX	None	msgid
meta	INDEX	None	meta
msgid_6	INDEX	None	msgid
ip_3	INDEX	None	ip
email_4	INDEX	None	email

Space usage : Type Usage Data 868 Bytes Index 4,096 Bytes Total 4,964 Bytes

Row Statistic : Statements Value Format dynamic Rows 3 Row length ø 289 Row size  ø 1,655 Bytes Next Autoindex 4 Creation Oct 19, 2017 at 12:40 PM Last update May 06, 2024 at 03:21 AM Last check May 06, 2024 at 03:21 AM