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.16809" name="GENERATOR"/></head> <body> <table width="100%" bgcolor="#aaaaaa" description="lightestBgcolor" name="tid"> <tbody> <tr> <td> <div style="PADDING-RIGHT: 30px; PADDING-LEFT: 30px; PADDING-BOTTOM: 30px; MARGIN: 0px; PADDING-TOP: 30px"> <table style="FONT-FAMILY: 'Verdana'" cellspacing="0" cellpadding="0" width="600" align="center"> <tbody> <tr> <td> <table cellspacing="0" cellpadding="0" width="100%" border="0"> <tbody> <tr> <td width="10" height="25"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/c1.gif" width="10"/></td> <td bgcolor="#ffffff" colspan="2"> </td> <td width="10" height="25"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/c2.gif" width="10"/></td></tr> <tr bgcolor="#ffffff"> <td valign="top" align="left"> </td> <td style="PADDING-RIGHT: 0px; PADDING-LEFT: 10px; FONT-WEIGHT: bold; PADDING-BOTTOM: 15px; PADDING-TOP: 50px; BORDER-BOTTOM: rgb(51,8,0) 3px solid" valign="top" align="left" width="256"> <h1 style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; FONT-SIZE: 28px; PADDING-BOTTOM: 2px; MARGIN: 0px; COLOR: rgb(85,85,85); LINE-HEIGHT: 26px; PADDING-TOP: 2px; FONT-FAMILY: 'Arial'; LETTER-SPACING: -1px" description="mediumColor" name="tid"><span style="FONT-SIZE: 24pt"><span style="FONT-WEIGHT: bold"><span style="FONT-SIZE: 24pt">Chuly Music</span></span> <span style="FONT-SIZE: 14pt">Presents</span></span><br/></h1><br/><span style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 11px; PADDING-BOTTOM: 2px; MARGIN: 0px; COLOR: rgb(102,102,102); PADDING-TOP: 2px; FONT-FAMILY: 'Verdana'"><strong><span style="FONT-SIZE: 18pt; COLOR: rgb(255,0,0)">I Love the<br/>80s & 90s FEST</span><br/></strong></span></td> <td style="BORDER-BOTTOM: rgb(51,8,0) 3px solid; TEXT-ALIGN: center" valign="top" width="324"><img title="" style="WIDTH: 260px; HEIGHT: 156px" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/10/puroparty_logo_450x271.jpg" align="baseline" 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://www.puroparty.com/pp_ads/search2.php?fromAdv=1&adType=0&adDate=90&adCategory=0" target="_blank">PuroParty CorkBoard</a></b><br/><br/></font></center></td> <td> </td></tr></tbody></table></td></tr> <tr> <td style="PADDING-RIGHT: 7px; PADDING-LEFT: 7px; PADDING-BOTTOM: 7px; PADDING-TOP: 7px" bgcolor="#ffffff"> <table style="WIDTH: 580px; HEIGHT: 103px" cellspacing="0" cellpadding="0" bgcolor="#ffffff" border="0"> <tbody> <tr> <td style="PADDING-LEFT: 15px" valign="top" colspan="2"> <p style="FONT-WEIGHT: normal; FONT-SIZE: 11px; COLOR: rgb(105,110,114); LINE-HEIGHT: 1.5em; FONT-FAMILY: verdana,arial,helvetica,sans-serif"><br/>For More Info: <a href="http://puroparty.com/emails/Chuly_Fest.mp3" target="_self">Listen Here</a><br/><br/>Or Visit: <a href="http://myspace.com/chulymusic" target="_blank">ChulyMusic</a> <a href="http://puroparty.com/xcorkboard.php" target="_blank">The PuroParty CorkBoard</a> <a href="http://arenahouston.com" target="_blank">The Arena Theatre</a></p> <div style="TEXT-ALIGN: center"><a href="http://puroparty.com/emails/Chuly_Fest.mp3" target="_self"><img title="" height="600" alt="" src="http://puroparty.com/emailmark5/admin/temp/newsletters/10/attachments/80s90s.jpg" width="400" align="baseline" border="0"/></a><br/></div></td></tr> <tr> <td style="VERTICAL-ALIGN: top"> <p align="center"><span style="FONT-SIZE: 8pt"> <hr/> <p align="center">Public Service Announcement<br/></p></span> <p align="center">BAR-B-QUE FUNDRAISER FOR<br/><font color="#000099"><strong>RICK GUERRERO</strong><br/></font>City Council District C Candidate<span style="FONT-SIZE: 10pt"></span></p><span style="FONT-SIZE: 10pt"> <p>Saturday, March 28, 2009<br/>2:00 PM - 7:00 PM</p> <p>S. M. Miguel Hidalgo Salon<br/>1107 Satsuma<br/>Pasadena, TX 77506</p> <p>Come and join us to support Rick Guerrero<br/>Tickets available at event - $7.00 per plate</p> <p>Info: <a href="http://www.rickforpasadena.com/">www.RickForPasadena.com</a><br/>Or Call: 832-443-2939</p></span> </p></td> <td style="VERTICAL-ALIGN: top"> </td></tr></tbody></table></td></tr> <tr> <td> <table style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 10px; PADDING-BOTTOM: 0px; COLOR: rgb(153,153,153); 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: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 5px; PADDING-TOP: 5px"><a style="COLOR: rgb(153,153,153)" href="%%unsubscribelink%%">To unsubscribe.</a> <br/></td> <td> </td></tr> <tr> <td width="10" height="25"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/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/Music/Brass%20Drums/c4.gif" width="10"/></td></tr></tbody></table></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