Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 18, 2024 at 02:30 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_session` PROCEDURE ANALYSE();
Rows: 9
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.jos_session.username | 0 | 0 | 2 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.jos_session.time | 1716010331 | 1716010963 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('1716010331','1716010963') NOT NULL |
| puroparty.jos_session.session_id | 6d44c277f0727b5f22df302180efe88d | ef63b77f512fc217aaec00f71fba5710 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('6d44c277f0727b5f22df302180efe88d','ef63b77f512fc217aaec00f71fba5710') NOT NULL |
| puroparty.jos_session.guest | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
| puroparty.jos_session.userid | 0 | 0 | 1 | 1 | 2 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_session.usertype | 0 | 0 | 2 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.jos_session.gid | 0 | 0 | 1 | 1 | 2 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_session.client_id | 0 | 0 | 1 | 1 | 2 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_session.data | __default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1716010963;s:18:"session.timer.last";i:1716010963;s:17:"session.timer.now";i:1716010963;s:22:"session.client.browser";s:75:"Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:70:"/home/79/46/2934679/web/joomla/libraries/joomla/html/parameter/element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"ed54b971a96cfe8b8c336044db77ff5c";} | __default|a:9:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1716010331;s:18:"session.timer.last";i:1716010331;s:17:"session.timer.now";i:1716010331;s:24:"session.client.forwarded";s:14:"114.119.141.30";s:22:"session.client.browser";s:165:"Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:70:"/home/79/46/2934679/web/joomla/libraries/joomla/html/parameter/element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"10784df7e87e4c58f323a9a1a0c3df0b";} | 1174 | 1319 | 0 | 0 | 1246.5000 | NULL | ENUM('__default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1716010963;s:18:"session.timer.last";i:1716010963;s:17:"session.timer.now";i:1716010963;s:22:"session.client.browser";s:75:"Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:70:"/home/79/46/2934679/web/joomla/libraries/joomla/html/parameter/element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"ed54b971a96cfe8b8c336044db77ff5c";}','__default|a:9:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1716010331;s:18:"session.timer.last";i:1716010331;s:17:"session.timer.now";i:1716010331;s:24:"session.client.forwarded";s:14:"114.119.141.30";s:22:"session.client.browser";s:165:"Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:70:"/home/79/46/2934679/web/joomla/libraries/joomla/html/parameter/element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"10784df7e87e4c58f323a9a1a0c3df0b";}') NOT NULL |