SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 23, 2024 at 02:43 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_users` PROCEDURE ANALYSE();
Rows: 32

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.email_users.userid 1 2 1 1 0 0 1.5000 0.5000 ENUM('1','2') NOT NULL
puroparty.email_users.username admin benmendez 5 9 0 0 7.0000 NULL ENUM('admin','benmendez') NOT NULL
puroparty.email_users.password 0c6569ce8038c6e8558c8f49ae5f505b d2cfcb745a74ab8ccdcd9e1e63e534d2 32 32 0 0 32.0000 NULL ENUM('0c6569ce8038c6e8558c8f49ae5f505b','d2cfcb745a74ab8ccdcd9e1e63e534d2') NOT NULL
puroparty.email_users.admintype a c 1 1 0 0 1.0000 NULL ENUM('a','c') NOT NULL
puroparty.email_users.listadmintype a c 1 1 0 0 1.0000 NULL ENUM('a','c') NOT NULL
puroparty.email_users.templateadmintype a a 1 1 0 0 1.0000 NULL ENUM('a') NOT NULL
puroparty.email_users.segmentadmintype a c 1 1 0 0 1.0000 NULL ENUM('a','c') NOT NULL
puroparty.email_users.status 1 1 1 1 0 0 1.0000 NULL ENUM('1') NOT NULL
puroparty.email_users.fullname     0 0 2 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_users.emailaddress benmendez@pmgunited.com events@puroparty.com 20 23 0 0 21.5000 NULL ENUM('benmendez@pmgunited.com','events@puroparty.com') NOT NULL
puroparty.email_users.settings a:3:{s:10:"LoginCheck";s:14:"148ec3aefadad0";s:15:"DisplaySettings";a:1:{s:4:"Sort";a:1:{s:5:"lists";a:4:{s:6:"SortBy";s:11:"subscribers";s:9:"Direction";s:4:"desc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}}}s:8:"Calendar";a:0:{}} a:5:{s:10:"LoginCheck";s:14:"14babc49d9880a";s:15:"DisplaySettings";a:3:{s:4:"Sort";a:10:{s:5:"lists";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:3:"asc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:11:"subscribers";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:3:"asc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:12:"customfields";a:4:{s:6:"SortBy";s:4:"name";s:9:"Direction";s:2:"Up";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:11:"newsletters";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:4:"desc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:17:"stats_newsletters";a:4:{s:6:"SortBy";s:10:"finishdate";s:9:"Direction";s:4:"desc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:7:"unknown";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:4:"desc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:5:"users";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:3:"asc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:10:"stats_list";a:4:{s:6:"SortBy";s:4:"name";s:9:"Direction";s:3:"asc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:10:"stats_user";a:4:{s:6:"SortBy";s:10:"finishtime";s:9:"Direction";s:2:"up";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:7:"segment";a:4:{s:6:"SortBy";s:11:"SegmentName";s:9:"Direction";s:2:"up";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}}s:11:"DisplayPage";a:4:{s:11:"subscribers";i:1;s:17:"stats_newsletters";i:1;s:11:"newsletters";i:1;s:5:"lists";i:1;}s:12:"NumberToShow";a:4:{s:17:"stats_newsletters";i:100;s:11:"newsletters";i:50;s:11:"subscribers";i:500;s:5:"lists";i:30;}}s:8:"Calendar";a:3:{s:8:"DateType";s:7:"AllTime";s:4:"From";a:3:{s:3:"Day";s:2:"23";s:3:"Mth";s:2:"10";s:2:"Yr";s:4:"2008";}s:2:"To";a:3:{s:3:"Day";s:2:"25";s:3:"Mth";s:2:"10";s:2:"Yr";s:4:"2008";}}s:13:"CalendarDates";a:8:{s:5:"opens";s:0:"";s:6:"clicks";s:0:"";s:8:"forwards";s:0:"";s:7:"bounces";s:0:"";s:12:"unsubscribes";s:0:"";s:10:"recipients";s:0:"";s:11:"subscribers";a:4:{s:10:"subscribes";s:0:"";s:12:"unsubscribes";s:0:"";s:7:"bounces";s:0:"";s:8:"forwards";s:0:"";}s:11:"usersummary";s:0:"";}s:20:"ShowFilteringOptions";s:1:"2";} 240 2171 0 0 1205.5000 NULL ENUM('a:3:{s:10:"LoginCheck";s:14:"148ec3aefadad0";s:15:"DisplaySettings";a:1:{s:4:"Sort";a:1:{s:5:"lists";a:4:{s:6:"SortBy";s:11:"subscribers";s:9:"Direction";s:4:"desc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}}}s:8:"Calendar";a:0:{}}','a:5:{s:10:"LoginCheck";s:14:"14babc49d9880a";s:15:"DisplaySettings";a:3:{s:4:"Sort";a:10:{s:5:"lists";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:3:"asc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:11:"subscribers";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:3:"asc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:12:"customfields";a:4:{s:6:"SortBy";s:4:"name";s:9:"Direction";s:2:"Up";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:11:"newsletters";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:4:"desc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:17:"stats_newsletters";a:4:{s:6:"SortBy";s:10:"finishdate";s:9:"Direction";s:4:"desc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:7:"unknown";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:4:"desc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:5:"users";a:4:{s:6:"SortBy";s:12:"emailaddress";s:9:"Direction";s:3:"asc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:10:"stats_list";a:4:{s:6:"SortBy";s:4:"name";s:9:"Direction";s:3:"asc";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:10:"stats_user";a:4:{s:6:"SortBy";s:10:"finishtime";s:9:"Direction";s:2:"up";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}s:7:"segment";a:4:{s:6:"SortBy";s:11:"SegmentName";s:9:"Direction";s:2:"up";s:9:"Secondary";b:0;s:18:"SecondaryDirection";b:0;}}s:11:"DisplayPage";a:4:{s:11:"subscribers";i:1;s:17:"stats_newsletters";i:1;s:11:"newsletters";i:1;s:5:"lists";i:1;}s:12:"NumberToShow";a:4:{s:17:"stats_newsletters";i:100;s:11:"newsletters";i:50;s:11:"subscribers";i:500;s:5:"lists";i:30;}}s:8:"Calendar";a:3:{s:8:"DateType";s:7:"AllTime";s:4:"From";a:3:{s:3:"Day";s:2:"23";s:3:"Mth";s:2:"10";s:2:"Yr";s:4:"2008";}s:2:"To";a:3:{s:3:"Day";s:2:"25";s:3:"Mth";s:2:"10";s:2:"Yr";s:4:"2008";}}s:13:"CalendarDates";a:8:{s:5:"opens";s:0:"";s:6:"clicks";s:0:"";s:8:"forwards";s:0:"";s:7:"bounces";s:0:"";s:12:"unsubscribes";s:0:"";s:10:"recipients";s:0:"";s:11:"subscribers";a:4:{s:10:"subscribes";s:0:"";s:12:"unsubscribes";s:0:"";s:7:"bounces";s:0:"";s:8:"forwards";s:0:"";}s:11:"usersummary";s:0:"";}s:20:"ShowFilteringOptions";s:1:"2";}') NOT NULL
puroparty.email_users.editownsettings 1 1 1 1 0 0 1.0000 NULL ENUM('1') NOT NULL
puroparty.email_users.usertimezone GMT-5:00 GMT-6:00 8 8 0 0 8.0000 NULL ENUM('GMT-5:00','GMT-6:00') NOT NULL
puroparty.email_users.textfooter     0 0 2 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_users.htmlfooter     0 0 2 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_users.maxlists 0 0 1 1 2 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.email_users.perhour 0 0 1 1 2 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.email_users.permonth 0 0 1 1 2 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.email_users.unlimitedmaxemails 1 1 1 1 0 0 1.0000 NULL ENUM('1') NOT NULL
puroparty.email_users.maxemails 0 0 1 1 2 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.email_users.infotips 1 1 1 1 0 0 1.0000 NULL ENUM('1') NOT NULL
puroparty.email_users.smtpserver     0 0 2 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_users.smtpusername     0 0 2 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_users.smtppassword     0 0 2 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_users.smtpport 25 25 2 2 0 0 25.0000 0.0000 ENUM('25') NOT NULL
puroparty.email_users.createdate 1219268515 1223456349 10 10 0 0 1221362432.0000 2093917.0000 ENUM('1219268515','1223456349') NOT NULL
puroparty.email_users.lastloggedin 1223459135 1269566189 10 10 0 0 1246512662.0000 23053527.0000 ENUM('1223459135','1269566189') NOT NULL
puroparty.email_users.forgotpasscode     0 0 2 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_users.usewysiwyg 1 1 1 1 0 0 1.0000 NULL ENUM('1') NOT NULL
puroparty.email_users.xmlapi 0 0 1 1 0 0 1.0000 NULL ENUM('0') NOT NULL
puroparty.email_users.xmltoken     0 0 2 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_users.gettingstarted 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL