Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 11, 2024 at 11:51 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_bannerclient` PROCEDURE ANALYSE();
Rows: 8
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) |