Server: mysql.puroparty.com

Database: puroparty

Table: jos_menu

Structure Browse SQL Search Insert Export Operations Empty Drop

Field	Type	Function	Null	Value
id	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
menutype	varchar(75)	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
name	varchar(255)	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
alias	varchar(255)	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
link	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		http://www.joomla.org
type	varchar(50)	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
published	tinyint(1)	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
parent	int(11) 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
componentid	int(11) 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
sublevel	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
ordering	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
checked_out	int(11) 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
checked_out_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
pollid	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
browserNav	tinyint(4)	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
access	tinyint(3) 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
utaccess	tinyint(3) 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
params	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		menu_image=-1
lft	int(11) 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
rgt	int(11) 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
home	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

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