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

SQL-query
SQL-query: 
SELECT *
FROM `jos_modules`
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_modules.id 1 857824 1 6 0 0 21466.6250 133924.3630 ENUM('1','2','3','4','5','6','7','8','9','10','11'...
puroparty.jos_modules.title \0 Wrapper 1 21 0 0 10.1250 NULL ENUM('\0','2017-11-29 04:52:43','Admin Menu','Admi...
puroparty.jos_modules.content   <div style="padding: 5px"><p>Congratulations on ch... 0 2534 38 0 63.8250 NULL ENUM('','1969-12-31 19:00:00','<div style="padding...
puroparty.jos_modules.ordering 1 13 1 2 3 0 3.4000 3.5341 ENUM('0','1','2','3','4','5','6','8','9','10','11'...
puroparty.jos_modules.position 0.75424194685579 user4 3 16 0 0 5.4250 NULL ENUM('0.75424194685579','4522','breadcrumb','cpane...
puroparty.jos_modules.checked_out 0 0 1 1 40 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_modules.checked_out_time 0000-00-00 00:00:00 0000-00-00 00:00:00 19 19 0 0 19.0000 NULL ENUM('0000-00-00 00:00:00') NOT NULL
puroparty.jos_modules.published 1 49 1 2 7 0 2.0250 7.5316 ENUM('0','1','49') NOT NULL
puroparty.jos_modules.module 2503 mod_wrapper 4 17 0 0 10.8250 NULL ENUM('2503','3392','mod_archive','mod_banners','mo...
puroparty.jos_modules.numnews 0 2017 1 4 39 0 50.4250 314.9040 ENUM('0','2017') NOT NULL
puroparty.jos_modules.access 0 255 1 3 25 0 8.3250 40.3456 ENUM('0','1','2','53','255') NOT NULL
puroparty.jos_modules.showtitle 1 89 1 2 6 0 3.0500 13.7676 ENUM('0','1','89') NOT NULL
puroparty.jos_modules.params 2017-11-27 X32314521525 7 378 17 0 50.8000 NULL ENUM('','2017-11-27','cache=1\n\n','cache=1\nclass_sf...
puroparty.jos_modules.iscore 1 127 1 3 20 0 3.6500 19.7580 ENUM('0','1','127') NOT NULL
puroparty.jos_modules.client_id 0 127 1 3 25 0 3.5250 19.7775 ENUM('0','1','127') NOT NULL
puroparty.jos_modules.control   88 0 10 38 0 0.3000 NULL ENUM('','1511792735','88') NOT NULL


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