Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 10:26 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_2categories` PROCEDURE ANALYSE();
Rows: 8
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.extcal_2categories.cat_id | 1 | 1970 | 1 | 4 | 0 | 0 | 284.4286 | 688.1335 | ENUM('1','2','3','4','5','6','1970') NOT NULL |
| puroparty.extcal_2categories.cat_parent | 0 | 16 | 1 | 2 | 6 | 0 | 2.2857 | 5.5988 | ENUM('0','16') NOT NULL |
| puroparty.extcal_2categories.cat_name | \0 | San Antonio | 1 | 16 | 0 | 0 | 8.5714 | NULL | ENUM('\0','Dallas/Ft. Worth','General','Houston','Mexico','Out of State','San Antonio') NOT NULL |
| puroparty.extcal_2categories.description | 0000-00-00 | This is the default category | 10 | 36 | 0 | 0 | 26.1429 | NULL | ENUM('0000-00-00','Events in Mexico.','Events in the Dallas/Ft. Worth area.','Events in the Houston area.','Events in the San Antonio area.','Events outside the state of Texas.','This is the default category') NOT NULL |
| puroparty.extcal_2categories.color | #000000 | #FF9900 | 7 | 7 | 1 | 0 | 6.0000 | NULL | ENUM('','#000000','#3300FF','#66FF00','#FF0033','#FF00CC','#FF9900') NOT NULL |
| puroparty.extcal_2categories.bgcolor | #EEF0F0 | #EEF0F0 | 7 | 7 | 0 | 1 | 7.0000 | NULL | ENUM('#EEF0F0') |
| puroparty.extcal_2categories.options | 2 | 127 | 1 | 3 | 0 | 0 | 19.8571 | 43.7409 | ENUM('2','127') NOT NULL |
| puroparty.extcal_2categories.enabled | 1 | 1 | 1 | 1 | 1 | 0 | 0.8571 | 0.3499 | ENUM('0','1') NOT NULL |