Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 01:33 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `photopost_sort` PROCEDURE ANALYSE();
Rows: 3
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.photopost_sort.sortid | 1 | 8 | 1 | 1 | 0 | 0 | 4.5000 | 2.2913 | ENUM('1','2','3','4','5','6','7','8') NOT NULL |
puroparty.photopost_sort.name | Image Name | Title | 5 | 13 | 0 | 0 | 9.1250 | NULL | ENUM('Image Name','Latest','Least Popular','Most Active','Most Popular','Most Views','Random','Title') NOT NULL |
puroparty.photopost_sort.code | ORDER BY disporder,bigimage | ORDER BY disporder,views DESC | 24 | 42 | 0 | 0 | 29.7500 | NULL | ENUM('ORDER BY disporder,bigimage','ORDER BY disporder,date DESC','ORDER BY disporder,lastpost DESC','ORDER BY disporder,RAND()','ORDER BY disporder,rating DESC, views DESC','ORDER BY disporder,rating,views','ORDER BY disporder,title','ORDER BY disporder,views DESC') NOT NULL |