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><title>Email</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/> <meta content="MSHTML 6.00.6000.16825" name="GENERATOR"/></head> <body> <table style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px" cellspacing="0" cellpadding="0" width="100%" bgcolor="#616c77" border="0"> <tbody> <tr> <td style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; MARGIN: 0px; PADDING-TOP: 10px"> <table style="FONT-FAMILY: 'Georgia'" height="177" cellspacing="0" cellpadding="0" width="600" align="center" bgcolor="#ffffff" border="0"> <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 color="black" size="3"><b>Upcoming Hot Events</b></font><br/><br/><font color="blue" size="2"><b>Clubs, Concerts, DJs, Bands, Mariachis<br/>Place Your Ad on the <br/><a href="http://puroparty.com/xcorkboard.php" target="_blank">PuroParty CorkBoard</a> </b></font></center></td></tr> <tr> <td style="PADDING-RIGHT: 25px; PADDING-LEFT: 25px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px" height="15"> <p style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 11px; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY: 'Verdana'"><strong>»</strong> You are subscribed as %%emailaddress%%</p></td></tr></tbody></table> <table style="FONT-FAMILY: 'Verdana'" cellspacing="0" cellpadding="0" width="600" align="center" border="0"> <tbody> <tr> <td style="PADDING-RIGHT: 7px; PADDING-LEFT: 7px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px" valign="top" bgcolor="#ffffff"> <div style="TEXT-ALIGN: justify"></div> <table cellspacing="0" cellpadding="0" width="100%" bgcolor="#373f4b" border="0"> <tbody> <tr> <td style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px" valign="top"> <div style="TEXT-ALIGN: justify"></div> <table style="WIDTH: 559px; HEIGHT: 427px" cellspacing="0" cellpadding="0" bgcolor="#212832" border="0"> <tbody> <tr> <td style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px; TEXT-ALIGN: center"><a href="http://puroparty.com/emails/emilianos/stampede.jpg" target="_blank"><img title="" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/21/stampede612x1008.jpg" width="500" align="baseline" border="0"/></a> </td></tr></tbody> <tbody> <tr></tr></tbody></table></td></tr></tbody></table></td></tr> <tr> <td style="PADDING-RIGHT: 15px; PADDING-LEFT: 25px; FONT-SIZE: 10px; PADDING-BOTTOM: 3px; MARGIN: 0px; COLOR: rgb(127,137,141); PADDING-TOP: 3px" 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%%">Unsubscribe</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