Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 10:22 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `photopost_cache` PROCEDURE ANALYSE();
Rows: 9
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.photopost_cache.id | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
| puroparty.photopost_cache.timestamp | 1210046242 | 1210046242 | 10 | 10 | 0 | 0 | 1210046242.0000 | 0.0000 | ENUM('1210046242') NOT NULL |
| puroparty.photopost_cache.statscache | a:1:{s:5:"stats";a:6:{s:9:"usertotal";s:1:"1";s:11... | a:1:{s:5:"stats";a:6:{s:9:"usertotal";s:1:"1";s:11... | 181 | 181 | 0 | 0 | 181.0000 | NULL | ENUM('a:1:{s:5:"stats";a:6:{s:9:"usertotal";s:1:"1... |
| puroparty.photopost_cache.recentcache | a:5:{i:0;a:18:{i:0;s:1:"5";s:2:"id";s:1:"5";i:1;s:... | a:5:{i:0;a:18:{i:0;s:1:"5";s:2:"id";s:1:"5";i:1;s:... | 1877 | 1877 | 0 | 0 | 1877.0000 | NULL | ENUM('a:5:{i:0;a:18:{i:0;s:1:"5";s:2:"id";s:1:"5";... |
| puroparty.photopost_cache.popularcache | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
| puroparty.photopost_cache.randomcache | a:5:{i:0;a:20:{i:0;s:1:"4";s:2:"id";s:1:"4";i:1;s:... | a:5:{i:0;a:20:{i:0;s:1:"4";s:2:"id";s:1:"4";i:1;s:... | 2224 | 2224 | 0 | 0 | 2224.0000 | NULL | ENUM('a:5:{i:0;a:20:{i:0;s:1:"4";s:2:"id";s:1:"4";... |
| puroparty.photopost_cache.calcache | a:1:{i:4;a:5:{i:0;a:4:{i:0;s:10:"1209961909";s:4:"... | a:1:{i:4;a:5:{i:0;a:4:{i:0;s:10:"1209961909";s:4:"... | 575 | 575 | 0 | 0 | 575.0000 | NULL | ENUM('a:1:{i:4;a:5:{i:0;a:4:{i:0;s:10:"1209961909"... |
| puroparty.photopost_cache.catcache | a:3:{i:0;a:25:{i:0;s:1:"2";i:1;s:30:"Photos of a p... | a:3:{i:0;a:25:{i:0;s:1:"2";i:1;s:30:"Photos of a p... | 1022 | 1022 | 0 | 0 | 1022.0000 | NULL | ENUM('a:3:{i:0;a:25:{i:0;s:1:"2";i:1;s:30:"Photos ... |
| puroparty.photopost_cache.catprops | a:3:{i:1;a:20:{i:0;s:1:"1";i:1;N;i:2;N;i:3;N;i:4;N... | a:3:{i:1;a:20:{i:0;s:1:"1";i:1;N;i:2;N;i:3;N;i:4;N... | 645 | 645 | 0 | 0 | 645.0000 | NULL | ENUM('a:3:{i:1;a:20:{i:0;s:1:"1";i:1;N;i:2;N;i:3;N... |