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

Table for event categories

SQL-query
SQL-query: 
SELECT *
FROM `extcal_2categories`
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_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','...
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 t...
puroparty.extcal_2categories.color #000000 #FF9900 7 7 1 0 6.0000 NULL ENUM('','#000000','#3300FF','#66FF00','#FF0033','#...
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


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