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

SQL-query
SQL-query: 
SELECT *
FROM `jos_bannerclient`
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.jos_bannerclient.cid 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_bannerclient.name Open Source Matters Open Source Matters 19 19 0 0 19.0000 NULL ENUM('Open Source Matters') NOT NULL
puroparty.jos_bannerclient.contact Administrator Administrator 13 13 0 0 13.0000 NULL ENUM('Administrator') NOT NULL
puroparty.jos_bannerclient.email admin@opensourcematters.org admin@opensourcematters.org 27 27 0 0 27.0000 NULL ENUM('admin@opensourcematters.org') NOT NULL
puroparty.jos_bannerclient.extrainfo     0 0 1 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_bannerclient.checked_out 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_bannerclient.checked_out_time 00:00:00 00:00:00 8 8 0 0 8.0000 NULL ENUM('00:00:00') NOT NULL
puroparty.jos_bannerclient.editor NULL NULL 0 0 0 1 0.0 NULL CHAR(0)


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