Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_newsletters
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 727040 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> <title>Email</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta content="MSHTML 6.00.6000.16809" name="GENERATOR"></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-size: 11px; font-family: 'Verdana';"><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;"> <a href="http://puroparty.com/emails/pop/fiestahouston-04-23-09.png" target="_blank"><img title="" alt="" id="de_element_image" src="http://puroparty.com/emailmark5/admin/temp/newsletters/14/090507-fitoolivares.jpg" width="266" align="" border="0" height="400"/><img id="de_element_image" src="http://puroparty.com/emailmark5/admin/temp/newsletters/14/YoMTV-RapFest_Arena2009.jpg"/><br/></a></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;"> <a href="http://puroparty.com/emails/pop/joesoto-election2.jpg"><img title="" style="width: 563px; height: 240px;" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/14/election3.jpg" align="baseline" border="0"/></a><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 style="color: rgb(127, 137, 141);" href="%%unsubscribelink%%">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