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 |