Server: mysql.puroparty.com

Database: puroparty

Table: photopost_cache

Structure Browse SQL Search Insert Export Operations Empty Drop

Field	Type	Function	Null	Value
id	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
timestamp	int(15)	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
statscache	mediumtext	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		a:1:{s:5:"stats";a:6:{s:9:"usertotal";s:1:"1";s:11:"totalphotos";s:1:"5";s:7:"diskuse";s:7:"1024026";s:10:"totalviews";s:1:"6";s:9:"posttotal";s:1:"0";s:9:"diskspace";s:5:"1.0mb";}}
recentcache	mediumtext	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		a:5:{i:0;a:18:{i:0;s:1:"5";s:2:"id";s:1:"5";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:1:"2";s:3:"cat";s:1:"2";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:6:"Forest";s:5:"title";s:6:"Forest";i:6;s:10:"Forest.jpg";s:8:"bigimage";s:10:"Forest.jpg";i:7;s:3:"768";s:6:"height";s:3:"768";i:8;s:4:"1024";s:5:"width";s:4:"1024";}i:1;a:18:{i:0;s:1:"4";s:2:"id";s:1:"4";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:1:"2";s:3:"cat";s:1:"2";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:16:"Desert_Landscape";s:5:"title";s:16:"Desert_Landscape";i:6;s:20:"Desert_Landscape.jpg";s:8:"bigimage";s:20:"Desert_Landscape.jpg";i:7;s:3:"768";s:6:"height";s:3:"768";i:8;s:4:"1024";s:5:"width";s:4:"1024";}i:2;a:18:{i:0;s:1:"3";s:2:"id";s:1:"3";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:1:"2";s:3:"cat";s:1:"2";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:16:"50_Cent_-_Curtis";s:5:"title";s:16:"50_Cent_-_Curtis";i:6;s:20:"50_Cent_-_Curtis.jpg";s:8:"bigimage";s:20:"50_Cent_-_Curtis.jpg";i:7;s:3:"240";s:6:"height";s:3:"240";i:8;s:3:"240";s:5:"width";s:3:"240";}i:3;a:18:{i:0;s:1:"2";s:2:"id";s:1:"2";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:3:"500";s:3:"cat";s:3:"500";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:6:"ff08-b";s:5:"title";s:6:"ff08-b";i:6;s:10:"ff08-b.jpg";s:8:"bigimage";s:10:"ff08-b.jpg";i:7;s:3:"184";s:6:"height";s:3:"184";i:8;s:3:"300";s:5:"width";s:3:"300";}i:4;a:18:{i:0;s:1:"1";s:2:"id";s:1:"1";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:3:"500";s:3:"cat";s:3:"500";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:6:"alicia";s:5:"title";s:6:"alicia";i:6;s:10:"alicia.jpg";s:8:"bigimage";s:10:"alicia.jpg";i:7;s:3:"613";s:6:"height";s:3:"613";i:8;s:3:"800";s:5:"width";s:3:"800";}}
popularcache	mediumtext	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
randomcache	mediumtext	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		a:5:{i:0;a:20:{i:0;s:1:"4";s:2:"id";s:1:"4";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:1:"2";s:3:"cat";s:1:"2";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:16:"Desert_Landscape";s:5:"title";s:16:"Desert_Landscape";i:6;s:20:"Desert_Landscape.jpg";s:8:"bigimage";s:20:"Desert_Landscape.jpg";i:7;s:3:"768";s:6:"height";s:3:"768";i:8;s:4:"1024";s:5:"width";s:4:"1024";i:9;s:17:"0.520019082836825";s:8:"rand_col";s:17:"0.520019082836825";}i:1;a:20:{i:0;s:1:"3";s:2:"id";s:1:"3";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:1:"2";s:3:"cat";s:1:"2";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:16:"50_Cent_-_Curtis";s:5:"title";s:16:"50_Cent_-_Curtis";i:6;s:20:"50_Cent_-_Curtis.jpg";s:8:"bigimage";s:20:"50_Cent_-_Curtis.jpg";i:7;s:3:"240";s:6:"height";s:3:"240";i:8;s:3:"240";s:5:"width";s:3:"240";i:9;s:17:"0.511536290414199";s:8:"rand_col";s:17:"0.511536290414199";}i:2;a:20:{i:0;s:1:"1";s:2:"id";s:1:"1";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:3:"500";s:3:"cat";s:3:"500";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:6:"alicia";s:5:"title";s:6:"alicia";i:6;s:10:"alicia.jpg";s:8:"bigimage";s:10:"alicia.jpg";i:7;s:3:"613";s:6:"height";s:3:"613";i:8;s:3:"800";s:5:"width";s:3:"800";i:9;s:17:"0.405967024533047";s:8:"rand_col";s:17:"0.405967024533047";}i:3;a:20:{i:0;s:1:"2";s:2:"id";s:1:"2";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:3:"500";s:3:"cat";s:3:"500";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:6:"ff08-b";s:5:"title";s:6:"ff08-b";i:6;s:10:"ff08-b.jpg";s:8:"bigimage";s:10:"ff08-b.jpg";i:7;s:3:"184";s:6:"height";s:3:"184";i:8;s:3:"300";s:5:"width";s:3:"300";i:9;s:17:"0.345887466655939";s:8:"rand_col";s:17:"0.345887466655939";}i:4;a:20:{i:0;s:1:"5";s:2:"id";s:1:"5";i:1;s:9:"puroparty";s:4:"user";s:9:"puroparty";i:2;s:1:"1";s:6:"userid";s:1:"1";i:3;s:1:"2";s:3:"cat";s:1:"2";i:4;s:1:"0";s:8:"storecat";s:1:"0";i:5;s:6:"Forest";s:5:"title";s:6:"Forest";i:6;s:10:"Forest.jpg";s:8:"bigimage";s:10:"Forest.jpg";i:7;s:3:"768";s:6:"height";s:3:"768";i:8;s:4:"1024";s:5:"width";s:4:"1024";i:9;s:18:"0.0654865736751692";s:8:"rand_col";s:18:"0.0654865736751692";}}
calcache	mediumtext	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		a:1:{i:4;a:5:{i:0;a:4:{i:0;s:10:"1209961909";s:4:"date";s:10:"1209961909";i:1;s:6:"alicia";s:5:"title";s:6:"alicia";}i:1;a:4:{i:0;s:10:"1209962011";s:4:"date";s:10:"1209962011";i:1;s:6:"ff08-b";s:5:"title";s:6:"ff08-b";}i:2;a:4:{i:0;s:10:"1209962840";s:4:"date";s:10:"1209962840";i:1;s:16:"50_Cent_-_Curtis";s:5:"title";s:16:"50_Cent_-_Curtis";}i:3;a:4:{i:0;s:10:"1209963517";s:4:"date";s:10:"1209963517";i:1;s:16:"Desert_Landscape";s:5:"title";s:16:"Desert_Landscape";}i:4;a:4:{i:0;s:10:"1209963519";s:4:"date";s:10:"1209963519";i:1;s:6:"Forest";s:5:"title";s:6:"Forest";}}}
catcache	mediumtext	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		a:3:{i:0;a:25:{i:0;s:1:"2";i:1;s:30:"Photos of a particular subject";i:2;s:1:"1";i:3;s:1:"3";i:4;s:1:"0";i:5;N;i:6;s:1:"5";i:7;s:10:"Forest.jpg";i:8;s:1:"2";i:9;s:1:"1";i:10;s:9:"puroparty";i:11;s:1:"1";i:12;s:10:"1209963519";i:13;s:4:"1024";i:14;s:3:"768";i:15;s:20:"50_Cent_-_Curtis.jpg";i:16;s:1:"2";i:17;s:1:"0";i:18;s:1:"1";i:19;s:3:"240";i:20;s:3:"240";i:21;N;i:22;N;i:23;N;i:24;N;}i:1;a:25:{i:0;s:3:"500";i:1;s:46:"Individual user galleries - any photo category";i:2;s:1:"1";i:3;s:1:"5";i:4;s:1:"0";i:5;N;i:6;s:1:"5";i:7;s:10:"Forest.jpg";i:8;s:1:"2";i:9;s:1:"1";i:10;s:9:"puroparty";i:11;s:1:"1";i:12;s:10:"1209963519";i:13;s:4:"1024";i:14;s:3:"768";i:15;N;i:16;N;i:17;N;i:18;N;i:19;N;i:20;N;i:21;N;i:22;N;i:23;N;i:24;N;}i:2;a:25:{i:0;s:1:"1";i:1;s:0:"";i:2;s:1:"2";i:3;s:1:"0";i:4;s:1:"0";i:5;N;i:6;s:1:"5";i:7;s:10:"Forest.jpg";i:8;s:1:"2";i:9;s:1:"1";i:10;s:9:"puroparty";i:11;s:1:"1";i:12;s:10:"1209963519";i:13;s:4:"1024";i:14;s:3:"768";i:15;N;i:16;N;i:17;N;i:18;N;i:19;N;i:20;N;i:21;N;i:22;N;i:23;N;i:24;N;}}
catprops	mediumtext	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		a:3:{i:1;a:20:{i:0;s:1:"1";i:1;N;i:2;N;i:3;N;i:4;N;i:5;N;i:6;N;i:7;s:0:"";i:8;s:1:"c";i:9;s:1:"0";i:10;s:4:"Main";i:11;s:1:"0";i:12;s:1:"2";i:13;s:2:"no";i:14;s:2:"no";i:15;N;i:16;N;i:17;N;i:18;N;i:19;s:1:"0";}i:2;a:20:{i:0;s:1:"2";i:1;N;i:2;N;i:3;N;i:4;N;i:5;N;i:6;N;i:7;s:0:"";i:8;s:1:"c";i:9;s:1:"0";i:10;s:10:"A Category";i:11;s:1:"1";i:12;s:0:"";i:13;s:3:"yes";i:14;s:2:"no";i:15;N;i:16;N;i:17;N;i:18;N;i:19;s:1:"0";}i:500;a:20:{i:0;s:3:"500";i:1;N;i:2;N;i:3;N;i:4;N;i:5;N;i:6;N;i:7;s:0:"";i:8;s:1:"c";i:9;s:1:"0";i:10;s:16:"Member Galleries";i:11;s:1:"0";i:12;s:0:"";i:13;s:3:"yes";i:14;s:2:"no";i:15;N;i:16;N;i:17;N;i:18;N;i:19;s:1:"0";}}

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