Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_newsletters
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Function
Null
Value
newsletterid
int(11)
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
name
varchar(255)
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
format
char(1)
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
subject
varchar(255)
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
textbody
longtext
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
Your email client cannot read this email. To view it online, please go here: %%webversion%% To stop receiving these emails:%%unsubscribelink%%
htmlbody
longtext
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" /> <html xmlns="http://www.w3.org/1999/xhtml"><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <meta http-equiv="Content-Language" content="en-us"/> <meta content="MSHTML 6.00.6000.16705" name="GENERATOR"/></head> <body> <table width="100%" bgcolor="#cee4e2"> <tbody></tbody></table> <table style="FONT-FAMILY: 'Verdana'" cellspacing="0" cellpadding="0" width="600" align="center"> <tbody> <tr> <td> <table style="BORDER-BOTTOM: #fff 1px solid" cellspacing="0" cellpadding="0" width="100%" border="0"> <tbody> <tr> <td width="10"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Business/Global/c1.gif" width="10"/></td> <td width="580" bgcolor="#ffffff"></td> <td width="10"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Business/Global/c2.gif" width="10"/></td></tr> <tr bgcolor="#ffffff"> <td valign="top" align="left" width="10" bgcolor="#ffffff"> </td> <td style="PADDING-RIGHT: 0px; PADDING-LEFT: 20px; PADDING-BOTTOM: 20px; PADDING-TOP: 10px" valign="top" align="left" width="580"> <h1 style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; FONT-SIZE: 32px; PADDING-BOTTOM: 2px; MARGIN: 0px; COLOR: #5e899b; LINE-HEIGHT: 32px; PADDING-TOP: 2px; FONT-FAMILY: georgia, 'Times New Roman', Times, serif; LETTER-SPACING: -1px" description="mediumColor" name="tid"> </h1></td> <td width="10"> </td></tr></tbody></table> <table cellspacing="0" cellpadding="0" width="600" border="0"> <tbody> <tr> <td><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Business/Global/MainImg.jpg" width="600"/></td></tr></tbody></table></td></tr> <tr> <td style="PADDING-RIGHT: 25px; PADDING-LEFT: 25px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px" bgcolor="#ffffff"> <table cellspacing="0" cellpadding="0" width="100%" bgcolor="#ffffff" border="0"> <tbody> <tr> <td valign="top" colspan="2"> <p style="FONT-WEIGHT: normal; FONT-SIZE: 11px; COLOR: #6b5c48; LINE-HEIGHT: 1.5em; FONT-FAMILY: verdana, arial, helvetica, sans-serif">You are subscribed as %%emailaddress%%</p></td></tr> <tr> <td style="PADDING-RIGHT: 25px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px" valign="top"><!-- StartBlockNoDelete --> <h1 style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; FONT-SIZE: 22px; PADDING-BOTTOM: 5px; MARGIN: 0px; COLOR: #4087b2; PADDING-TOP: 5px; BORDER-BOTTOM: #cccccc 1px dashed; FONT-FAMILY: 'Georgia'" description="lightestColor" name="tid">Presidential Poll</h1> <p style="FONT-SIZE: 12px; COLOR: #333333; LINE-HEIGHT: 1.5em; FONT-FAMILY: 'Verdana'"><img title="" height="162" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/3/mccain_obama.jpg" width="248" align="left" border="0"/><br/>The National Hispanic Professional Organization (NHPO) is taking part in a nationwide presidential poll.</p> <p style="FONT-SIZE: 12px; COLOR: #333333; LINE-HEIGHT: 1.5em; FONT-FAMILY: 'Verdana'">The purpose of this poll is to determine how Hispanic professionals would vote if the elections were held today.</p> <p style="FONT-SIZE: 12px; COLOR: #333333; LINE-HEIGHT: 1.5em; FONT-FAMILY: 'Verdana'">Simply click on the link below to take part in this poll:<br/>http://puroparty.com/prespoll<br/><br/><a href="http://www.puroparty.com/prespoll">http://www.puroparty.com/prespoll</a><br/><br/><a href="http://www.surveymonkey.com/s.aspx?sm=a4SnGV24GlpGAjzPT0DUrw_3d_3d">http://www.surveymonkey.com/s.aspx?sm=a4SnGV24GlpGAjzPT0DUrw_3d_3d</a></p> <p style="FONT-SIZE: 12px; COLOR: #333333; LINE-HEIGHT: 1.5em; FONT-FAMILY: 'Verdana'">If the link above is not clickable, just cut and paste in your browser address window.</p> <p style="FONT-SIZE: 12px; COLOR: #333333; LINE-HEIGHT: 1.5em; FONT-FAMILY: 'Verdana'">Results will be published at <a href="http://www.nhpo.us">www.nhpo.us</a> on Monday, Sep 8, 2008.<br/><br/>Thank you for taking the time to particpate!</p><!-- EndBlockNoDelete --></td> <td style="PADDING-RIGHT: 15px; PADDING-LEFT: 0px; PADDING-BOTTOM: 10px; PADDING-TOP: 15px" valign="top"><!-- StartBlockNoDelete --> <h1 style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; FONT-SIZE: 16px; PADDING-BOTTOM: 5px; MARGIN: 0px; COLOR: #4087b2; PADDING-TOP: 0px; BORDER-BOTTOM: #cccccc 1px dashed; FONT-FAMILY: 'Georgia'" description="lightestColor" name="tid">Count Me In</h1> <p style="FONT-SIZE: 12px; COLOR: #333333; LINE-HEIGHT: 1.5em; FONT-FAMILY: 'Verdana'">This Poll should take less than "1 Minute" to complete.<br/><br/>All answers are anonymous.<br/><br/>NO personally identifiable information is collected.<br/><br/>Your input is important, so please take a minute and "be counted".</p><!-- EndBlockNoDelete --></td></tr></tbody></table></td></tr> <tr> <td> <table style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 10px; PADDING-BOTTOM: 0px; COLOR: #999; LINE-HEIGHT: 1.5em; PADDING-TOP: 0px; FONT-FAMILY: 'Verdana'" cellspacing="0" cellpadding="0" width="100%" border="0"> <tbody> <tr bgcolor="#ffffff"> <td></td> <td style="PADDING-RIGHT: 15px; PADDING-LEFT: 15px; PADDING-BOTTOM: 15px; PADDING-TOP: 5px"><a style="COLOR: #999" href="%%unsubscribelink%%">To stop receiving these emails please unsubscribe.</a> </td> <td></td></tr> <tr> <td width="10" height="25"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Business/Global/c3.gif" width="10"/></td> <td bgcolor="#ffffff"></td> <td width="10" height="25"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Business/Global/c4.gif" width="10"/></td></tr></tbody></table></td></tr></tbody></table></body></html>
createdate
int(11)
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
active
int(11)
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
archive
int(11)
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
ownerid
int(11)
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
Save
Or
Insert as a new row
-- And --
Go back to previous page
Or
Insert another new row
Or
Go back to this page