Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 24, 2024 at 04:30 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','d2cfcb745... |
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.c... |
puroparty.email_users.settings | a:3:{s:10:"LoginCheck";s:14:"148ec3aefadad0";s:15:... | a:5:{s:10:"LoginCheck";s:14:"14babc49d9880a";s:15:... | 240 | 2171 | 0 | 0 | 1205.5000 | NULL | ENUM('a:3:{s:10:"LoginCheck";s:14:"148ec3aefadad0"... |
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 |