Server: mysql.puroparty.com

Database: puroparty

Table: jos_messages

Structure Browse SQL Search Insert Export Operations Empty Drop

Field	Type	Function	Null	Value
message_id	int(10) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
user_id_from	int(10) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
user_id_to	int(10) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
folder_id	int(10) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
date_time	datetime	NOW CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP WEEKDAY -------- ASCII CHAR SOUNDEX LCASE UCASE PASSWORD MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM USER CONCAT
state	int(11)	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
priority	int(1) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
subject	text	ASCII CHAR SOUNDEX LCASE UCASE PASSWORD MD5 SHA1 ENCRYPT LAST_INSERT_ID USER CONCAT -------- NOW RAND COUNT AVG SUM CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP WEEKDAY
message	text	ASCII CHAR SOUNDEX LCASE UCASE PASSWORD MD5 SHA1 ENCRYPT LAST_INSERT_ID USER CONCAT -------- NOW RAND COUNT AVG SUM CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP WEEKDAY

Ignore

Field	Type	Function	Null	Value
message_id	int(10) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
user_id_from	int(10) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
user_id_to	int(10) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
folder_id	int(10) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
date_time	datetime	NOW CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP WEEKDAY -------- ASCII CHAR SOUNDEX LCASE UCASE PASSWORD MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM USER CONCAT
state	int(11)	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
priority	int(1) unsigned	ASCII CHAR MD5 SHA1 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
subject	text	ASCII CHAR SOUNDEX LCASE UCASE PASSWORD MD5 SHA1 ENCRYPT LAST_INSERT_ID USER CONCAT -------- NOW RAND COUNT AVG SUM CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP WEEKDAY
message	text	ASCII CHAR SOUNDEX LCASE UCASE PASSWORD MD5 SHA1 ENCRYPT LAST_INSERT_ID USER CONCAT -------- NOW RAND COUNT AVG SUM CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP WEEKDAY

Insert as a new row	-- And --	Go back to previous page       Or Insert another new row