SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 02:43 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal2_events` PROCEDURE ANALYSE();
Rows: 19

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.extcal2_events.id 2 30 1 2 0 0 16.1786 8.4602 ENUM('2','3','4','5','6','7','8','9','10','12','13...
puroparty.extcal2_events.title 2nd event xxxxxx 3 28 0 0 10.7143 NULL ENUM('2nd event','Avizo & Los Hermanos Cortez','BI...
puroparty.extcal2_events.description Beas Island Club\r\ndrink specials til 11pm\r\n$1.50 f... xxxxxxxxxxxxxxxx 4 220 0 0 55.1429 NULL ENUM('Beas Island Club\r\ndrink specials til 11pm\r\n$...
puroparty.extcal2_events.contact   dfdsfdsfsdaf 0 17 19 0 3.9286 NULL ENUM('','713-910-3004','713-944-2720','713-9442720...
puroparty.extcal2_events.url   puroparty.com 0 13 21 0 3.2500 NULL ENUM('','puroparty.com') NOT NULL
puroparty.extcal2_events.email   puroparty@puroparty.com 0 23 27 0 0.8214 NULL ENUM('','puroparty@puroparty.com') NOT NULL
puroparty.extcal2_events.picture   ec5f_jump.jpg 0 13 27 0 0.4643 NULL ENUM('','ec5f_jump.jpg') NOT NULL
puroparty.extcal2_events.cat 1 10 1 2 0 0 5.0357 3.0057 ENUM('1','2','3','5','7','8','9','10') NOT NULL
puroparty.extcal2_events.day 2 31 1 2 0 0 16.2500 11.9631 ENUM('2','3','4','5','6','8','11','13','15','18','...
puroparty.extcal2_events.month 1 12 1 2 0 0 4.1429 4.9693 ENUM('1','12') NOT NULL
puroparty.extcal2_events.year 2006 2007 4 4 0 0 2006.6786 0.4670 ENUM('2006','2007') NOT NULL
puroparty.extcal2_events.approved 1 1 1 1 10 0 0.6429 0.4792 ENUM('0','1') NOT NULL
puroparty.extcal2_events.start_date 2006-01-15 08:00:00 2007-01-31 08:00:00 19 19 0 0 19.0000 NULL ENUM('2006-01-15 08:00:00','2006-12-28 08:00:00','...
puroparty.extcal2_events.end_date 2006-01-15 23:59:59 2007-01-31 23:59:59 19 19 0 0 19.0000 NULL ENUM('2006-01-15 23:59:59','2006-12-28 23:59:59','...
puroparty.extcal2_events.recur_type   day 0 3 24 0 0.4286 NULL ENUM('','day') NOT NULL
puroparty.extcal2_events.recur_val 0 7 1 1 24 0 1.0000 2.4495 ENUM('0','7') NOT NULL
puroparty.extcal2_events.recur_end_type 0 2 1 1 24 0 0.2500 0.6339 ENUM('0','1','2') NOT NULL
puroparty.extcal2_events.recur_count 1 4 1 1 0 0 1.4286 1.0498 ENUM('1','4') NOT NULL
puroparty.extcal2_events.recur_until 2006-12-28 2007-01-31 10 10 0 0 10.0000 NULL ENUM('2006-12-28','2006-12-29','2006-12-30','2006-...