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.16705" name="GENERATOR"/></head> <body> <table style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px" width="100%" bgcolor="#344e91" description="darkestBgcolor" 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 style="BORDER-BOTTOM: #fff 1px solid" cellspacing="0" cellpadding="0" width="100%" bgcolor="#ffffff" border="0"> <tbody> <tr> <td valign="top" width="10"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Travel%20and%20Tourism/Beach%20Paradise/c1.gif" width="10"/></td> <td valign="top" width="580" bgcolor="#ffffff" height="25"><span></span></td> <td valign="top" width="10"><img height="25" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Travel%20and%20Tourism/Beach%20Paradise/c2.gif" width="10"/></td></tr> <tr> <td valign="top" align="left" width="10" bgcolor="#ffffff"> </td> <td style="PADDING-RIGHT: 0px; PADDING-LEFT: 20px; PADDING-BOTTOM: 20px; PADDING-TOP: 0px" valign="top" align="left" width="580"><span style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; FONT-SIZE: 32px; PADDING-BOTTOM: 2px; MARGIN: 0px; COLOR: #4f7ee1; LINE-HEIGHT: 32px; PADDING-TOP: 2px; FONT-FAMILY: Georgia, 'Times New Roman', Times, serif; LETTER-SPACING: -1px" description="darkColor" name="tid">PuroParty</span><br/><span style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 10px; PADDING-BOTTOM: 2px; MARGIN: 0px; COLOR: #4b4925; PADDING-TOP: 2px; FONT-FAMILY: 'Verdana'"><strong> Reaching Hispanics!</strong></span></td> <td width="10"> </td></tr></tbody></table> <table cellspacing="0" cellpadding="0" width="600" border="0"> <tbody> <tr> <td><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Travel%20and%20Tourism/Beach%20Paradise/MainImg.jpg" width="600"/></td></tr></tbody></table></td></tr> <tr> <td style="PADDING-RIGHT: 25px; PADDING-LEFT: 25px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px" bgcolor="#ffffff"> <table cellspacing="0" cellpadding="0" width="100%" bgcolor="#ffffff" border="0"> <tbody> <tr> <td valign="top" colspan="2"> <p style="FONT-WEIGHT: normal; FONT-SIZE: 11px; COLOR: #4b4925; LINE-HEIGHT: 1.5em; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif">You are subscribed as %%emailaddress%%</p></td></tr> <tr> <td style="PADDING-RIGHT: 25px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px" valign="top"><!-- StartBlockNoDelete --> <span style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; FONT-SIZE: 22px; PADDING-BOTTOM: 5px; MARGIN: 0px; COLOR: #3769ce; PADDING-TOP: 5px; BORDER-BOTTOM: #cccccc 1px dashed; FONT-FAMILY: 'Georgia'" description="darkColor" name="tid">Concert 2Nite!</span> <p style="FONT-SIZE: 12px; COLOR: #333333; LINE-HEIGHT: 1.4em; FONT-FAMILY: 'Verdana'"><img style="MARGIN-BOTTOM: 10px; MARGIN-RIGHT: 15px" src="http://puroparty.com/emailmark5/admin/resources/email_templates/Travel%20and%20Tourism/Beach%20Paradise/MainImg1.jpg" align="left"/>This is a block of text for your email campaign. Enter in your content here. To create another block, click on the Green + icon at the top right hand corner. <br/><br/>This is a block of text for your email campaign. Enter in your content here. To create another text block, click on the Green [+] icon at the top right hand corner.<br/><br/>This is a block of text for your email campaign. Enter in your content here. To create another block, click on the Green + icon at the top right hand corner. This is a block of text for your email campaign. Enter in your content here. To create another text block, click on the Green [+] icon at the top right hand corner.</p><!-- EndBlockNoDelete --><!-- StartBlockCanDelete --> <br/><span style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; FONT-SIZE: 22px; PADDING-BOTTOM: 5px; MARGIN: 0px; COLOR: #3769ce; PADDING-TOP: 5px; BORDER-BOTTOM: #cccccc 1px dashed; FONT-FAMILY: 'Georgia'" description="darkColor" name="tid">Concert #2</span><br/> <p style="FONT-SIZE: 12px; COLOR: #333333; LINE-HEIGHT: 1.4em; FONT-FAMILY: 'Verdana'">This is a block of text for your email campaign. Enter in your content here. To create another block, click on the Green + icon at the top right hand corner. <br/><br/>This is a block of text for your email campaign. Enter in your content here. To create another text block, click on the Green [+] icon at the top right hand corner.<br/><br/>This is a block of text for your email campaign. Enter in your content here. To create another block, click on the Green + icon at the top right hand corner. This is a block of text for your email campaign. Enter in your content here. To create another text block, click on the Green [+] icon at the top right hand corner.</p><!-- EndBlockNoDelete --></td> <td style="PADDING-RIGHT: 15px; PADDING-LEFT: 0px; PADDING-BOTTOM: 10px; PADDING-TOP: 15px" valign="top"><!-- StartBlockNoDelete --> La Sabrosura <p style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 12px; PADDING-BOTTOM: 5px; MARGIN: 0px; COLOR: #576164; LINE-HEIGHT: 17px; PADDING-TOP: 5px; FONT-FAMILY: 'Verdana'">This is the small right column block of text. Here you can place short text items such as event notices, news items and other short notices. To create another Small Block, click on the green [+] icon on the top right hand corner.</p><!-- EndBlockNoDelete --></td></tr></tbody></table></td></tr> <tr> <td> <table style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 10px; PADDING-BOTTOM: 0px; COLOR: #999; LINE-HEIGHT: 1.5em; PADDING-TOP: 0px; FONT-FAMILY: 'Verdana'" cellspacing="0" cellpadding="0" width="100%" bgcolor="#ffffff" border="0"> <tbody> <tr> <td></td> <td style="PADDING-RIGHT: 15px; PADDING-LEFT: 15px; PADDING-BOTTOM: 15px; PADDING-TOP: 5px"><a style="COLOR: #999" href="%%unsubscribelink%%">To stop receiving these emails please unsubscribe.</a> <br/>Type your Company Name, Address and Contact Details</td> <td></td></tr> <tr valign="bottom"> <td width="10" height="25"><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Travel%20and%20Tourism/Beach%20Paradise/c3.gif" width="10"/></td> <td height="25"><span></span></td> <td width="10" height="25"><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Travel%20and%20Tourism/Beach%20Paradise/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