Server: mysql.puroparty.com

Database: puroparty

Table: photopost_users

Structure Browse SQL Search Insert Export Operations Empty Drop

Field	Type	Function	Null	Value
userid	int(25)	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
usergroupid	int(5)	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
username	varchar(30)	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
password	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
email	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
homepage	varchar(100)	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
icq	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
aim	varchar(30)	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
yahoo	varchar(30)	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
joindate	int(25)	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
posts	int(20)	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
birthday	date	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
ipaddress	varchar(18)	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
location	varchar(100)	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
interests	varchar(250)	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
occupation	varchar(250)	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
bio	varchar(250)	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
site	varchar(30)	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
offset	smallint(2)	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
views	int(10)	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
cellphone	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

Ignore

Field	Type	Function	Null	Value
userid	int(25)	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
usergroupid	int(5)	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
username	varchar(30)	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
password	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
email	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
homepage	varchar(100)	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
icq	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
aim	varchar(30)	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
yahoo	varchar(30)	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
joindate	int(25)	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
posts	int(20)	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
birthday	date	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
ipaddress	varchar(18)	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
location	varchar(100)	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
interests	varchar(250)	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
occupation	varchar(250)	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
bio	varchar(250)	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
site	varchar(30)	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
offset	smallint(2)	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
views	int(10)	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
cellphone	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

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