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
<html xmlns="http://www.w3.org/1999/xhtml"><head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Email</title> </head><body> <table style="margin: 0px; padding: 0px;" width="100%" bgcolor="#616c77" border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="margin: 0px; padding: 10px;"> <table style="font-family: 'Georgia';" width="600" align="center" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" height="177"> <tbody> <tr> <td> <img title="" style="width: 260px; height: 156px;" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/10/puroparty_logo_450x271.jpg" align="right" border="0"/><br/> <center><font size="3" color="black"><b>Upcoming Hot Events</b></font><br/><br/><font size="2" color="blue"><b>Clubs, Concerts, DJs, Bands, Mariachis<br/>Place Your Ad on the <br/><a href="http://www.puroparty.com/pp_ads/search2.php?fromAdv=1&adType=0&adDate=90&adCategory=0" target="_blank">PuroParty CorkBoard</a> </b></font></center></td> </tr> <tr> <td style="padding: 0px 25px;" height="15"> <p style="padding: 5px 0px; font-family: 'Verdana'; font-size: 11px;"><strong>»</strong> You are subscribed as %%emailaddress%%</p></td> </tr> </tbody> </table> <table style="font-family: 'Verdana';" width="600" align="center" border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="padding: 0px 7px;" valign="top" bgcolor="#ffffff"><div style="text-align: justify;"> </div><table width="100%" bgcolor="#373f4b" border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="padding: 10px;" valign="top"><div style="text-align: justify;"> </div><table style="width: 559px; height: 427px;" bgcolor="#212832" border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="padding: 10px; text-align: center;"> <img title="" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/13/090422-tejanoroundup.jpg" width="258" align="baseline" border="0" height="400"/> <img title="" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/13/090423-fiestahouston.jpg" width="258" align="baseline" border="0" height="400"/></td> </tr> </tbody> </table> </td> </tr> <tr style="color: rgb(204, 204, 204);"><td style="vertical-align: top;">Public Service Announcement:<br/></td></tr><tr align="center"><td style="vertical-align: top;"><img style="width: 563px; height: 240px;" title="" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/13/election2.jpg" align="baseline" border="0"/><br/> </td></tr><tr> <td valign="top"><span style="color: rgb(204, 204, 204);"><br/></span></td> </tr> </tbody> </table> </td> </tr> <tr> <td style="margin: 0px; padding: 3px 15px 3px 25px; font-size: 10px; color: rgb(127, 137, 141);" background="http://puroparty.com/emailmark5/admin/resources/email_templates/Business/Generic%204%20Newsletter/bkg_footer.gif" height="52"> <a href="%%unsubscribelink%%" style="color: rgb(127, 137, 141);">To unsubscribe, please click here.</a><br/> PuroParty.com - 2009<br/></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