Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_newsletters
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 722944 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 content="text/html; charset=utf-8" http-equiv="Content-Type"/> <meta content="en-us" http-equiv="Content-Language"/> <meta name="GENERATOR" content="MSHTML 8.00.6001.18372"/></head> <body> <table width="100%" bgcolor="#aaaaaa" name="tid" description="lightestBgcolor"> <tbody> <tr> <td> <div style="padding-bottom: 30px; margin: 0px; padding-left: 30px; padding-right: 30px; padding-top: 30px"> <table style="font-family: 'Verdana'" cellspacing="0" cellpadding="0" width="600" align="center"> <tbody> <tr> <td> <table border="0" cellspacing="0" cellpadding="0" width="100%"> <tbody> <tr> <td height="25" width="10"><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/c1.gif" width="10" height="25"/></td> <td bgcolor="#ffffff" colspan="2"> </td> <td height="25" width="10"><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/c2.gif" width="10" height="25"/></td></tr> <tr bgcolor="#ffffff"> <td valign="top" align="left"> </td> <td style="border-bottom: rgb(51,8,0) 3px solid; padding-bottom: 15px; padding-left: 10px; padding-right: 0px; font-weight: bold; padding-top: 50px" valign="top" width="256" align="left"> <h1 style="padding-bottom: 2px; line-height: 26px; margin: 0px; padding-left: 0px; padding-right: 0px; font-family: 'Arial'; LETTER-SPACING: -1px; COLOR: rgb(85,85,85); FONT-SIZE: 28px; FONT-WEIGHT: normal; PADDING-TOP: 2px" name="tid" description="mediumColor"><span style="font-size: 24pt"><span style="font-weight: bold"><span style="font-size: 24pt">Smokin' Tejanos</span></span></span></h1> <h1 style="padding-bottom: 2px; line-height: 26px; margin: 0px; padding-left: 0px; padding-right: 0px; font-family: 'Arial'; LETTER-SPACING: -1px; COLOR: rgb(85,85,85); FONT-SIZE: 28px; FONT-WEIGHT: normal; PADDING-TOP: 2px" name="tid" description="mediumColor"><span style="font-size: 24pt"><span style="font-weight: bold"><span style="font-size: 24pt">Party Tent<br/></span></span></span><span style="padding-bottom: 2px; margin: 0px; padding-left: 0px; padding-right: 0px; font-family: 'Verdana'; COLOR: rgb(102,102,102); FONT-SIZE: 11px; PADDING-TOP: 2px"><strong><span style="color: rgb(255,0,0); font-size: 18pt"><br/>Frontier Fiesta <br/>Cook-off<br/><span style="font-size: 12pt"><font color="#999999">Thur March 26 - Sat March 28</font></span></span></strong></span></h1><span style="padding-bottom: 2px; margin: 0px; padding-left: 0px; padding-right: 0px; font-family: 'Verdana'; COLOR: rgb(102,102,102); FONT-SIZE: 11px; PADDING-TOP: 2px"></span> <td style="border-bottom: rgb(51,8,0) 3px solid; text-align: center" valign="top" width="324"><font color="#999999"><img style="width: 260px; height: 156px" title="" border="0" alt="" align="baseline" src="http://puroparty.com/emailmark5/admin/temp/newsletters/12/puroparty_logo_450x271.jpg"/><br/></font> <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://www.puroparty.com/xcorkboard.php" target="_blank">PuroParty CorkBoard</a></b><br/><br/></font></center></td> <td> </td></td></tr></tbody> </table> </td></tr> <tr> <td style="padding-bottom: 7px; padding-left: 7px; padding-right: 7px; padding-top: 7px" bgcolor="#ffffff"> <table style="width: 580px; height: 103px" border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff"> <tbody> <tr> <td style="padding-left: 15px" valign="top" colspan="2"> <div style="text-align: center"><img title="" border="0" alt="" align="baseline" src="http://puroparty.com/emails/smokintejanos-ff09.jpg"/><br/></div></td></tr> <tr> <td> <table style="padding-bottom: 0px; line-height: 1.5em; padding-left: 0px; padding-right: 0px; font-family: 'Verdana'; COLOR: rgb(153,153,153); FONT-SIZE: 10px; PADDING-TOP: 0px" border="0" cellspacing="0" cellpadding="0" width="100%"> <tbody> <tr bgcolor="#ffffff"> <td> </td> <td style="padding-bottom: 5px; padding-left: 10px; padding-right: 10px; padding-top: 5px"><a style="color: rgb(153,153,153)" href="%%unsubscribelink%%">To unsubscribe.</a> <br/></td> <td> </td></tr> <tr> <td height="25" width="10"><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/c3.gif" width="10" height="25"/></td> <td bgcolor="#ffffff"> </td> <td height="25" width="10"><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/c4.gif" width="10" height="25"/></td></tr></tbody> </table> </td></tr></tbody> </table> <div></div></td></tr></tbody> </table> </div></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