Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 08:10 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_form_pages` PROCEDURE ANALYSE();
Rows: 12
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.email_form_pages.pageid | 1 | 24 | 1 | 2 | 0 | 0 | 13.0000 | 8.6410 | ENUM('1','2','3','13','14','15','22','23','24') NOT NULL |
puroparty.email_form_pages.formid | 1 | 3 | 1 | 1 | 0 | 0 | 2.0000 | 0.8165 | ENUM('1','2','3') NOT NULL |
puroparty.email_form_pages.pagetype | ConfirmPage | ThanksPage | 9 | 11 | 0 | 0 | 10.0000 | NULL | ENUM('ConfirmPage','ErrorPage','ThanksPage') NOT NULL |
puroparty.email_form_pages.html | \r\n<html>\r\n<head>\r\n<style>\r\nbody {\r\n margin: 0px;\r\n}\r\n\r\n#content {\r\n border: 1px solid #EFECBA;\r\n width: 300px;\r\n height: 150px;\r\n background-color: #FBFAE7;\r\n padding:20px;\r\n top: 50%;\r\n left: 50%;\r\n position: absolute;\r\n}\r\n\r\n#container {\r\n width: 100%;\r\n height: 100%;\r\n font: 11px tahoma;\r\n position: absolute;\r\n top: -75px;\r\n left: -150px;\r\n}\r\n\r\n</style>\r\n</head>\r\n<body>\r\n<div id="container">\r\n <div id="content">\r\n <b>Your email subscription is almost complete...</b><br><br>\r\n An email has been sent to the email address you entered. In this email is a confirmation link. Please click on this link to confirm your subscription.<br><br>\r\n Once you've done this your subscription will be complete.<br><br>\r\n <a href="javascript:history.back()">« Go Back</a>\r\n </div>\r\n</div>\r\n</body>\r\n</html> | <html><head>\r\n\r\n\r\n<style>BODY {\r\n MARGIN: 0px\r\n}\r\n#content {\r\n BORDER-RIGHT: #efecba 1px solid; PADDING-RIGHT: 20px; BORDER-TOP: #efecba 1px solid; PADDING-LEFT: 20px; LEFT: 50%; PADDING-BOTTOM: 20px; BORDER-LEFT: #efecba 1px solid; WIDTH: 300px; PADDING-TOP: 20px; BORDER-BOTTOM: #efecba 1px solid; POSITION: absolute; TOP: 50%; HEIGHT: 150px; BACKGROUND-COLOR: #fbfae7\r\n}\r\n#container {\r\n LEFT: -150px; FONT: 11px tahoma; WIDTH: 100%; POSITION: absolute; TOP: -75px; HEIGHT: 100%\r\n}\r\n</style>\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body>\r\n<div id="container">\r\n<div id="content"><b>An error has occurred.</b><br/><br/>An error(s) has occurred while trying to subscribe you to our contact list:<br/>%%GLOBAL_Errors%% <br/><br/><a href="javascript:history.back()">« Go Back</a> </div></div></body></html> | 599 | 846 | 1 | 0 | 654.5556 | NULL | ENUM('\r\n<html>\r\n<head>\r\n<style>\r\nbody {\r\n margin: 0px;\r\n}\r\n\r\n#content {\r\n border: 1px solid #EFECBA;\r\n width: 300px;\r\n height: 150px;\r\n background-color: #FBFAE7;\r\n padding:20px;\r\n top: 50%;\r\n left: 50%;\r\n position: absolute;\r\n}\r\n\r\n#container {\r\n width: 100%;\r\n height: 100%;\r\n font: 11px tahoma;\r\n position: absolute;\r\n top: -75px;\r\n left: -150px;\r\n}\r\n\r\n</style>\r\n</head>\r\n<body>\r\n<div id="container">\r\n <div id="content">\r\n <b>Your email subscription is almost complete...</b><br><br>\r\n An email has been sent to the email address you entered. In this email is a confirmation link. Please click on this link to confirm your subscription.<br><br>\r\n Once you\'ve done this your subscription will be complete.<br><br>\r\n <a href="javascript:history.back()">« Go Back</a>\r\n </div>\r\n</div>\r\n</body>\r\n</html>','\r\n<html>\r\n<head>\r\n<style>\r\nbody {\r\n margin: 0px;\r\n}\r\n\r\n#content {\r\n border: 1px solid #EFECBA;\r\n width: 300px;\r\n height: 150px;\r\n background-color: #FBFAE7;\r\n padding:20px;\r\n top: 50%;\r\n left: 50%;\r\n position: absolute;\r\n}\r\n\r\n#container {\r\n width: 100%;\r\n height: 100%;\r\n font: 11px tahoma;\r\n position: absolute;\r\n top: -75px;\r\n left: -150px;\r\n}\r\n\r\n</style>\r\n</head>\r\n<body>\r\n<div id="container">\r\n <div id="content">\r\n <b>Your subscription is now complete.</b><br><br>\r\n Thank you for subscribing to our contact list. Your subscription is now complete.<br><br>\r\n </div>\r\n</div>\r\n</body>\r\n</html>','\r\n<html><head>\r\n\r\n\r\n<style>\r\nbody {\r\n margin: 0px;\r\n}\r\n\r\n#content {\r\n border: 1px solid #EFECBA;\r\n width: 300px;\r\n height: 150px;\r\n background-color: #FBFAE7;\r\n padding:20px;\r\n top: 50%;\r\n left: 50%;\r\n position: absolute;\r\n}\r\n\r\n#container {\r\n width: 100%;\r\n height: 100%;\r\n font: 11px tahoma;\r\n position: absolute;\r\n top: -75px;\r\n left: -150px;\r\n}\r\n\r\n</style>\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body>\r\n<div id="container">\r\n<div id="content"><b>Your email subscription is almost complete...</b><br/><br/>An email has been sent to the email address you entered. In this email is a confirmation link. Please click on this link to confirm your subscription.<br/><br/>Once you\'ve done this your subscription will be complete.<br/><br/><a href="javascript:history.back()">« Go Back</a> </div></div></body></html>','\r\n<html><head>\r\n\r\n\r\n<style>\r\nbody {\r\n margin: 0px;\r\n}\r\n\r\n#content {\r\n border: 1px solid #EFECBA;\r\n width: 300px;\r\n height: 150px;\r\n background-color: #FBFAE7;\r\n padding:20px;\r\n top: 50%;\r\n left: 50%;\r\n position: absolute;\r\n}\r\n\r\n#container {\r\n width: 100%;\r\n height: 100%;\r\n font: 11px tahoma;\r\n position: absolute;\r\n top: -75px;\r\n left: -150px;\r\n}\r\n\r\n</style>\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body>\r\n<div id="container">\r\n<div id="content"><b>Your subscription is now complete.</b><br/><br/>Thank you for subscribing to our contact list. Your subscription is now complete.<br/><br/></div></div></body></html>\r\n','\r\n<html><head>\r\n\r\n\r\n<style>BODY {\r\n MARGIN: 0px\r\n}\r\n#content {\r\n BORDER-RIGHT: #efecba 1px solid; PADDING-RIGHT: 20px; BORDER-TOP: #efecba 1px solid; PADDING-LEFT: 20px; LEFT: 50%; PADDING-BOTTOM: 20px; BORDER-LEFT: #efecba 1px solid; WIDTH: 300px; PADDING-TOP: 20px; BORDER-BOTTOM: #efecba 1px solid; POSITION: absolute; TOP: 50%; HEIGHT: 150px; BACKGROUND-COLOR: #fbfae7\r\n}\r\n#container {\r\n LEFT: -150px; FONT: 11px tahoma; WIDTH: 100%; POSITION: absolute; TOP: -75px; HEIGHT: 100%\r\n}\r\n</style>\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body>\r\n<div id="container">\r\n<div id="content"><b>Your subscription is now complete.</b><br/><br/>Thank you for subscribing to the PuroParty Newsletter. Your subscription is now complete.<br/><br/></div></div></body></html>\r\n','','<html>\r\n<head>\r\n<style>\r\nbody {\r\n margin: 0px;\r\n}\r\n\r\n#content {\r\n border: 1px solid #EFECBA;\r\n width: 300px;\r\n height: 150px;\r\n background-color: #FBFAE7;\r\n padding:20px;\r\n top: 50%;\r\n left: 50%;\r\n position: absolute;\r\n}\r\n\r\n#container {\r\n width: 100%;\r\n height: 100%;\r\n font: 11px tahoma;\r\n position: absolute;\r\n top: -75px;\r\n left: -150px;\r\n}\r\n\r\n</style>\r\n</head>\r\n<body>\r\n<div id="container">\r\n <div id="content">\r\n <b>An error has occurred.</b><br><br>\r\n An error(s) has occurred while trying to subscribe you to our contact list:<br>\r\n %%GLOBAL_Errors%%\r\n <br><br>\r\n <a href="javascript:history.back()">« Go Back</a>\r\n </div>\r\n</div>\r\n</body>\r\n</html>','<html><head>\r\n\r\n\r\n<style>\r\nbody {\r\n margin: 0px;\r\n}\r\n\r\n#content {\r\n border: 1px solid #EFECBA;\r\n width: 300px;\r\n height: 150px;\r\n background-color: #FBFAE7;\r\n padding:20px;\r\n top: 50%;\r\n left: 50%;\r\n position: absolute;\r\n}\r\n\r\n#container {\r\n width: 100%;\r\n height: 100%;\r\n font: 11px tahoma;\r\n position: absolute;\r\n top: -75px;\r\n left: -150px;\r\n}\r\n\r\n</style>\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body>\r\n<div id="container">\r\n<div id="content"><b>An error has occurred.</b><br/><br/>An error(s) has occurred while trying to subscribe you to our contact list:<br/>%%GLOBAL_Errors%% <br/><br/><a href="javascript:history.back()">« Go Back</a> </div></div></body></html>','<html><head>\r\n\r\n\r\n<style>BODY {\r\n MARGIN: 0px\r\n}\r\n#content {\r\n BORDER-RIGHT: #efecba 1px solid; PADDING-RIGHT: 20px; BORDER-TOP: #efecba 1px solid; PADDING-LEFT: 20px; LEFT: 50%; PADDING-BOTTOM: 20px; BORDER-LEFT: #efecba 1px solid; WIDTH: 300px; PADDING-TOP: 20px; BORDER-BOTTOM: #efecba 1px solid; POSITION: absolute; TOP: 50%; HEIGHT: 150px; BACKGROUND-COLOR: #fbfae7\r\n}\r\n#container {\r\n LEFT: -150px; FONT: 11px tahoma; WIDTH: 100%; POSITION: absolute; TOP: -75px; HEIGHT: 100%\r\n}\r\n</style>\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body>\r\n<div id="container">\r\n<div id="content"><b>An error has occurred.</b><br/><br/>An error(s) has occurred while trying to subscribe you to our contact list:<br/>%%GLOBAL_Errors%% <br/><br/><a href="javascript:history.back()">« Go Back</a> </div></div></body></html>') NOT NULL |
puroparty.email_form_pages.url | http:// | http:// | 7 | 7 | 1 | 0 | 6.2222 | NULL | ENUM('','http://') NOT NULL |
puroparty.email_form_pages.sendfromname | Hispanic Democrats For McCain | PuroParty | 9 | 29 | 4 | 0 | 9.4444 | NULL | ENUM('','Hispanic Democrats For McCain','PuroParty') NOT NULL |
puroparty.email_form_pages.sendfromemail | ppcru@puroparty.com | subscribe@hispanicdemocratsformccain.com | 19 | 40 | 4 | 0 | 15.2222 | NULL | ENUM('','ppcru@puroparty.com','subscribe@hispanicdemocratsformccain.com') NOT NULL |
puroparty.email_form_pages.replytoemail | ppcru@puroparty.com | subscribe@hispanicdemocratsformccain.com | 19 | 40 | 4 | 0 | 15.2222 | NULL | ENUM('','ppcru@puroparty.com','subscribe@hispanicdemocratsformccain.com') NOT NULL |
puroparty.email_form_pages.bounceemail | ppcru@puroparty.com | subscribe@hispanicdemocratsformccain.com | 19 | 40 | 4 | 0 | 15.2222 | NULL | ENUM('','ppcru@puroparty.com','subscribe@hispanicdemocratsformccain.com') NOT NULL |
puroparty.email_form_pages.emailsubject | Confirm your subscription | Your subscription is now complete. | 25 | 44 | 4 | 0 | 18.0000 | NULL | ENUM('','Confirm your subscription','Thank you for signing up to our contact list','Your subscription is now complete.') NOT NULL |
puroparty.email_form_pages.emailhtml | \r\n<html><head>\r\n\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body style="FONT: 12px tahoma"><b>Please confirm your subscription</b> <br/><br/>Thank you for subscribing to our newsletter.<br/><br/>To finalize your subscription, please click on the confirmation link below. Once you've done this, your subscription will be complete.<br/><br/><a href="%%CONFIRMLINK%%" target="_blank">Please click here to confirm your subscription</a><br/><br/>or copy and paste the following URL into your browser:<br/>%%CONFIRMLINK%%</body></html> | \r\n<html><head></head>\r\n<body style='font:12px tahoma'>\r\n<b>Please confirm your subscription</b>\r\n<br><br>\r\nThank you for subscribing to our newsletter.<br><br>To finalize your subscription, please click on the confirmation link below. Once you've done this, your subscription will be complete.<br><br>\r\n<a href='%%CONFIRMLINK%%' target='_blank'>Please click here to confirm your subscription</a><br><br>or copy and paste the following URL into your browser:<br>\r\n%%CONFIRMLINK%% | 274 | 556 | 4 | 0 | 213.6667 | NULL | ENUM('\r\n<html><head>\r\n\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body style="FONT: 12px tahoma"><b>Please confirm your subscription</b> <br/><br/>Thank you for subscribing to our newsletter.<br/><br/>To finalize your subscription, please click on the confirmation link below. Once you\'ve done this, your subscription will be complete.<br/><br/><a href="%%CONFIRMLINK%%" target="_blank">Please click here to confirm your subscription</a><br/><br/>or copy and paste the following URL into your browser:<br/>%%CONFIRMLINK%%</body></html>','\r\n<html><head>\r\n\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body style="FONT: 12px tahoma"><b>Your subscription is complete</b><br/><br/>Thank you for subscribing to our contact list. Your subscription is now complete. If you have any questions you can contact us by replying to this email. </body></html>\r\n','\r\n<html><head>\r\n\r\n\r\n<meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head>\r\n<body style="FONT: 12px tahoma">Thank you for signing up to our contact list and/or contacting us.<br/><br/>If you have any problems you can contact us by replying to this email. </body></html>\r\n','\r\n<html><head></head>\r\n<body style=\'font: 12px tahoma\'>\r\n<b>Your subscription is complete</b><br><br>\r\nThank you for subscribing to our contact list. Your subscription is now complete. If you have any questions you can contact us by replying to this email.\r\n</body>\r\n</html>','\r\n<html><head></head>\r\n<body style=\'font:12px tahoma\'>\r\n<b>Please confirm your subscription</b>\r\n<br><br>\r\nThank you for subscribing to our newsletter.<br><br>To finalize your subscription, please click on the confirmation link below. Once you\'ve done this, your subscription will be complete.<br><br>\r\n<a href=\'%%CONFIRMLINK%%\' target=\'_blank\'>Please click here to confirm your subscription</a><br><br>or copy and paste the following URL into your browser:<br>\r\n%%CONFIRMLINK%%','') NOT NULL |
puroparty.email_form_pages.emailtext | Thank you for signing up to our contact list and/or contacting us.\r\n\r\nIf you have any problems you can contact us by replying to this email. | Thank you for subscribing to our newsletter.\r\n\r\nTo finalize your subscription, please click on the confirmation link below. Once you've done this, your subscription will be complete.\r\n\r\n%%CONFIRMLINK%%\r\n\r\n | 140 | 205 | 4 | 0 | 95.7778 | NULL | ENUM('','Thank you for signing up to our contact list and/or contacting us.\r\n\r\nIf you have any problems you can contact us by replying to this email.','Thank you for subscribing to our contact list.\r\n\r\nYour subscription is now complete. If you have any questions you can contact us by replying to this email.','Thank you for subscribing to our newsletter.\r\n\r\nTo finalize your subscription, please click on the confirmation link below. Once you\'ve done this, your subscription will be complete.\r\n\r\n%%CONFIRMLINK%%\r\n\r\n') NOT NULL |