Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 24, 2024 at 10:16 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','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30') NOT NULL |
puroparty.extcal2_events.title | 2nd event | xxxxxx | 3 | 28 | 0 | 0 | 10.7143 | NULL | ENUM('2nd event','Avizo & Los Hermanos Cortez','BIC','c ecbebcikenc','dhdhuwdh','dnv dnvNN','hey','Jaime y Los Chamacos','Jay Perez','La Tropa F','Los Desperadoz','Mad Mondays','nvkrnv`','ONB','Original Neighborhood Bar','Roberto Pulido & Johnny Cruz','Tejano Boys & Los Amables','test','test27','test45','test46','Tourney tuesdays','trying','xxxxxx') NOT NULL |
puroparty.extcal2_events.description | Beas Island Club\r\ndrink specials til 11pm\r\n$1.50 frozen margaritas\r\n$1.50 domestic beer\r\n$2.00 after | xxxxxxxxxxxxxxxx | 4 | 220 | 0 | 0 | 55.1429 | NULL | ENUM('Beas Island Club\r\ndrink specials til 11pm\r\n$1.50 frozen margaritas\r\n$1.50 domestic beer\r\n$2.00 after','cniewcbiwn','gcyegvcyec','heyyyyy','Jaime y Los Chamacos at Bea\'s Island Club.\r\n\r\n2719 S. Richey','La Tropa F live on stage at Hallabaloos.','Live on stage Beas Island Club\r\ndrink specials til 10 pm\r\n$2 well drinks\r\n$2 margaritas\r\n$2 domestic beer','Live on stage Beas Island Club\r\ndrink specials til 10pm\r\n$2 well drinks\r\n$2 margaritas\r\n$2 domestic beer','New Year\'s Eve at the Original Neighborhood Bar.\r\n\r\nChampagne, Food, & Party Favors.\r\n\r\n[URL=http://www.puroparty.com/onb]puroparty.com/onb[/URL]','New Year\'s Eve Party at Bea\'s Island Club with Houston\'s Powerhouse Avizo & Los Hermanos Cortez performing live.\r\n\r\nChampagne & Party Favors!\r\n\r\n2719 S. Richey\r\n[URL=http://www.puroparty.com/beas]puroparty.com/beas[/URL]','New Year\'s Eve Party at Hallabaloos with Roberto Pulido & Johnny Cruz. \r\n\r\n$1000 Cash Prize Balloon Drop.\r\nChampagne & Party Favors.','New Year\'s Eve Party with Los Desperadoz at Graham Central Station in San Antonio, TX.\r\n\r\n','nfeknik','NKNKNKNV KDM ','Original Neighborhood Bar\r\n$1.50 domestic beer\r\nfrom 4-7pm\r\n','Original Neighborhood Bar\r\nFree Pool\r\n$1.50 domestic beer \r\nfrom 2pm-2am','Original Neighborhood Bar\r\npool tournament every tuesday\r\n$10 entry fee minimum 15 players starts at 8pm\r\n1st place $125\r\n2nd place $75\r\n3rd place $50\r\n$1.50 domestic beer 4-7pm\r\n','segundo','Tejano Boys & Los Amables live at Hallablaoos.\r\n\r\n\r\n[URL=http://www.puroparty.com/hallabaloo]puroparty.com/hallabaloo[/URL]','test','test28','test45','test46','TRTETETEET','xxxxxxxxxxxxxxxx') NOT NULL |
puroparty.extcal2_events.contact | dfdsfdsfsdaf | 0 | 17 | 19 | 0 | 3.9286 | NULL | ENUM('','713-910-3004','713-944-2720','713-9442720','call 123-456-7890','dfaredfgfds','dfdsfdsfsdaf') NOT NULL | |
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','20','27','28','29','30','31') NOT NULL |
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','2006-12-29 08:00:00','2006-12-30 08:00:00','2006-12-31 08:00:00','2006-12-31 20:00:00','2007-01-02 08:00:00','2007-01-03 08:00:00','2007-01-04 08:00:00','2007-01-05 08:00:00','2007-01-06 08:00:00','2007-01-08 08:00:00','2007-01-11 08:00:00','2007-01-13 08:00:00','2007-01-18 08:00:00','2007-01-20 08:00:00','2007-01-27 08:00:00','2007-01-31 08:00:00') NOT NULL |
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','2006-12-29 23:59:59','2006-12-30 23:59:59','2006-12-31 23:59:59','2007-01-02 23:59:59','2007-01-03 23:59:59','2007-01-04 23:59:59','2007-01-05 23:59:59','2007-01-06 23:59:59','2007-01-08 23:59:59','2007-01-11 23:59:59','2007-01-13 23:59:59','2007-01-18 23:59:59','2007-01-20 23:59:59','2007-01-27 23:59:59','2007-01-31 23:59:59') NOT NULL |
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-12-31','2007-01-02','2007-01-04','2007-01-11','2007-01-20','2007-01-26','2007-01-27','2007-01-29','2007-01-30','2007-01-31') NOT NULL |