Host: mysql.puroparty.com
Database: puroparty
Generation Time: Jun 17, 2024 at 03:09 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 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.jos_session.time | 1718592636 | 1718592636 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('1718592636') NOT NULL |
puroparty.jos_session.session_id | 1551e93ddc39395253dc606655a2a6d4 | 1551e93ddc39395253dc606655a2a6d4 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('1551e93ddc39395253dc606655a2a6d4') 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 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_session.usertype | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.jos_session.gid | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_session.client_id | 0 | 0 | 1 | 1 | 1 | 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:1718592636;s:18:"session.timer.last";i:1718592636;s:17:"session.timer.now";i:1718592636;s:24:"session.client.forwarded";s:13:"10.179.80.105";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:{}}} | __default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1718592636;s:18:"session.timer.last";i:1718592636;s:17:"session.timer.now";i:1718592636;s:24:"session.client.forwarded";s:13:"10.179.80.105";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:{}}} | 1257 | 1257 | 0 | 0 | 1257.0000 | NULL | ENUM('__default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1718592636;s:18:"session.timer.last";i:1718592636;s:17:"session.timer.now";i:1718592636;s:24:"session.client.forwarded";s:13:"10.179.80.105";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:{}}}') NOT NULL |