Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 04:47 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `photopost_sortmemb` 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_sortmemb.sortid | 1 | 4 | 1 | 1 | 0 | 0 | 2.5000 | 1.1180 | ENUM('1','2','3','4') NOT NULL |
puroparty.photopost_sortmemb.name | Alphabetical Order | Views (high to low) | 11 | 19 | 0 | 0 | 16.7500 | NULL | ENUM('Alphabetical Order','Date (newest first)','Most Active','Views (high to low)') NOT NULL |
puroparty.photopost_sortmemb.code | ORDER BY maxdate DESC | ORDER BY user ASC | 17 | 21 | 0 | 0 | 19.7500 | NULL | ENUM('ORDER BY maxdate DESC','ORDER BY maxlast DESC','ORDER BY tviews DESC','ORDER BY user ASC') NOT NULL |