Host: mysql.puroparty.com
Database: puroparty
Generation Time: Jun 01, 2024 at 05:39 PM
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 | 1717274422 | 1717275007 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('1717274422','1717275007') NOT NULL |
| puroparty.jos_session.session_id | 1137101d77f2218569f26331047f31b6 | 6e075960258214f1c1f34f4c10c0db97 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('1137101d77f2218569f26331047f31b6','6e075960258214f1c1f34f4c10c0db97') 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:7:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1717274422;s:18:"session.timer.last";i:1717274422;s:17:"session.timer.now";i:1717274422;s:22:"session.client.browser";s:73:"facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)";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:9:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1717275007;s:18:"session.timer.last";i:1717275007;s:17:"session.timer.now";i:1717275007;s:24:"session.client.forwarded";s:13:"10.179.80.198";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:"7dbe315ec1c1896ff190c087aa3de2b2";} | 1111 | 1318 | 0 | 0 | 1214.5000 | NULL | ENUM('__default|a:7:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1717274422;s:18:"session.timer.last";i:1717274422;s:17:"session.timer.now";i:1717274422;s:22:"session.client.browser";s:73:"facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)";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:9:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1717275007;s:18:"session.timer.last";i:1717275007;s:17:"session.timer.now";i:1717275007;s:24:"session.client.forwarded";s:13:"10.179.80.198";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:"7dbe315ec1c1896ff190c087aa3de2b2";}') NOT NULL |