Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 12:09 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_1events` PROCEDURE ANALYSE();
Rows: 22
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.extcal_1events.id | 2 | 1222 | 1 | 4 | 0 | 0 | 720.4724 | 503.3503 | SMALLINT(4) UNSIGNED NOT NULL |
puroparty.extcal_1events.title | "5 Star Band" CD Release Party | yBVtBiDPjKVX | 5 | 81 | 0 | 0 | 13.2403 | NULL | ENUM('"5 Star Band" CD Release Party','2... |
puroparty.extcal_1events.description | MADCOW COOKER`S \r\n We will be at Sylvan Beach 51s... | [url=http://www.stordproduksjonslag.no/images/4638... | 10 | 6588 | 0 | 0 | 2314.6878 | NULL | TEXT NOT NULL |
puroparty.extcal_1events.contact | 0 | 0 | 362 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal_1events.url | 0 | 0 | 362 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal_1events.email | 0 | 0 | 362 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal_1events.picture | 0 | 0 | 362 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal_1events.cat | 1 | 19 | 1 | 2 | 0 | 0 | 7.9641 | 5.7811 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.extcal_1events.day | 1 | 31 | 1 | 2 | 0 | 0 | 16.7265 | 8.5563 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.extcal_1events.month | 1 | 12 | 1 | 2 | 0 | 0 | 6.0608 | 2.9219 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.extcal_1events.year | 2006 | 2010 | 4 | 4 | 0 | 0 | 2007.2818 | 0.4796 | ENUM('2006','2007','2008','2009','2010') NOT NULL |
puroparty.extcal_1events.approved | 1 | 1 | 1 | 1 | 237 | 0 | 0.3453 | 0.4755 | ENUM('0','1') NOT NULL |
puroparty.extcal_1events.start_date | 2006-04-30 18:15:00 | 2010-06-17 04:00:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-04-30 18:15:00','2007-01-01 14:15:00','... |
puroparty.extcal_1events.end_date | 2006-04-30 19:15:00 | 2010-06-17 05:00:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-04-30 19:15:00','2007-01-01 15:15:00','... |
puroparty.extcal_1events.recur_type | week | 0 | 5 | 346 | 0 | 0.1436 | NULL | ENUM('','day','month','week') NOT NULL | |
puroparty.extcal_1events.recur_val | 0 | 6 | 1 | 1 | 346 | 0 | 0.0663 | 0.4218 | ENUM('0','1','4','6') NOT NULL |
puroparty.extcal_1events.recur_end_type | 0 | 2 | 1 | 1 | 340 | 0 | 0.0691 | 0.2844 | ENUM('0','1','2') NOT NULL |
puroparty.extcal_1events.recur_count | 1 | 4 | 1 | 1 | 0 | 0 | 1.0083 | 0.1575 | ENUM('1','4') NOT NULL |
puroparty.extcal_1events.recur_until | 2000-01-01 | 2011-08-31 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('2000-01-01','2000-01-02','2000-01-06','2000-... |
puroparty.extcal_1events.user_id | 1 | 1 | 1 | 1 | 245 | 0 | 0.3232 | 0.4677 | ENUM('0','1') NOT NULL |
puroparty.extcal_1events.group_id | 1 | 1 | 1 | 1 | 245 | 0 | 0.3232 | 0.4677 | ENUM('0','1') NOT NULL |
puroparty.extcal_1events.showevent | 1 | 3 | 1 | 1 | 241 | 0 | 0.3343 | NULL | ENUM('','1','3') NOT NULL |