Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 06:11 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bak_modules` PROCEDURE ANALYSE();
Rows: 16
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.bak_modules.id | 1 | 15 | 1 | 2 | 0 | 0 | 8.0000 | 4.3205 | ENUM('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15') NOT NULL |
puroparty.bak_modules.title | Admin Menu | User Status | 5 | 21 | 0 | 0 | 10.4667 | NULL | ENUM('Admin Menu','Admin SubMenu','Footer','Logged in Users','Login','Main Menu','Menu Stats','Online Users','Popular','Quick Icons','Recent added Articles','Title','Toolbar','Unread Messages','User Status') NOT NULL |
puroparty.bak_modules.content | 0 | 0 | 15 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.bak_modules.ordering | 1 | 5 | 1 | 1 | 1 | 0 | 1.6667 | 1.2996 | ENUM('0','1','2','3','4','5') NOT NULL |
puroparty.bak_modules.position | cpanel | toolbar | 4 | 7 | 0 | 0 | 5.6000 | NULL | ENUM('cpanel','footer','header','icon','left','login','menu','status','submenu','title','toolbar') NOT NULL |
puroparty.bak_modules.checked_out | 0 | 0 | 1 | 1 | 15 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.bak_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.bak_modules.published | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.bak_modules.module | mod_footer | mod_unread | 8 | 13 | 0 | 0 | 10.2000 | NULL | ENUM('mod_footer','mod_latest','mod_logged','mod_login','mod_mainmenu','mod_menu','mod_online','mod_popular','mod_quickicon','mod_stats','mod_status','mod_submenu','mod_title','mod_toolbar','mod_unread') NOT NULL |
puroparty.bak_modules.numnews | 0 | 0 | 1 | 1 | 15 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.bak_modules.access | 0 | 2 | 1 | 1 | 3 | 0 | 1.6000 | 0.8000 | ENUM('0','2') NOT NULL |
puroparty.bak_modules.showtitle | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.bak_modules.params | menutype=mainmenu\nmoduleclass_sfx=_menu\n | ordering=c_dsc\nuser_id=0\ncache=0\n\n | 34 | 40 | 13 | 0 | 4.9333 | NULL | ENUM('','menutype=mainmenu\nmoduleclass_sfx=_menu\n','ordering=c_dsc\nuser_id=0\ncache=0\n\n') NOT NULL |
puroparty.bak_modules.iscore | 1 | 1 | 1 | 1 | 8 | 0 | 0.4667 | 0.4989 | ENUM('0','1') NOT NULL |
puroparty.bak_modules.client_id | 0 | 1 | 1 | 1 | 1 | 0 | 0.9333 | 0.2494 | ENUM('0','1') NOT NULL |
puroparty.bak_modules.control | 0 | 0 | 15 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL |