Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: extcal_1eventsextcal_1events
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Table holding events and their attributes

SQL-query
SQL-query: 
SELECT *
FROM `extcal_1events`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport