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
<!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.7600.16490"/></head> <body> <table style="PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px" width="100%" bgcolor="black" description="lightBgcolor" name="tid"> <tbody> <tr> <td> <div style="PADDING-BOTTOM: 30px; MARGIN: 0px; PADDING-LEFT: 30px; PADDING-RIGHT: 30px; PADDING-TOP: 30px"> <table style="BORDER-BOTTOM: #f3f0e7 1px solid; BORDER-LEFT: #f3f0e7 1px solid; FONT-FAMILY: 'Verdana'; BORDER-TOP: #f3f0e7 1px solid; BORDER-RIGHT: #f3f0e7 1px solid" cellspacing="0" cellpadding="0" width="600" bgcolor="#eee9db" align="center" description="lightestBgcolor" name="tid"> <tbody> <tr> <td style="PADDING-BOTTOM: 0px; PADDING-LEFT: 15px; PADDING-RIGHT: 15px; PADDING-TOP: 15px"> <table border="0" cellspacing="0" cellpadding="0" width="100%"> <tbody> <tr> <td style="PADDING-BOTTOM: 15px; PADDING-LEFT: 20px; PADDING-RIGHT: 20px; COLOR: #993300; PADDING-TOP: 0px" valign="top" align="center"><span style="PADDING-BOTTOM: 5px; LINE-HEIGHT: 40px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: 'Georgia'; LETTER-SPACING: -1px; COLOR: #663300; FONT-SIZE: 40px; FONT-WEIGHT: normal; PADDING-TOP: 5px" description="darkestColor" name="tid" align="center">Census Expo!</span></td></tr> <tr> <td style="PADDING-BOTTOM: 15px; PADDING-LEFT: 20px; PADDING-RIGHT: 20px; PADDING-TOP: 15px" bgcolor="#ffb600" valign="top" align="center" description="mediumBgcolor" name="tid"> <div align="center"><span style="PADDING-BOTTOM: 5px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: 'Georgia'; COLOR: #663300; FONT-SIZE: 13px; PADDING-TOP: 5px" description="darkestColor" name="tid"><strong>Be Counted! Hagase Contar!</strong> </span></div></td></tr></tbody></table></td></tr> <tr> <td style="PADDING-BOTTOM: 0px; PADDING-LEFT: 15px; PADDING-RIGHT: 15px; PADDING-TOP: 0px"> <table border="0" cellspacing="20" cellpadding="0" width="100%" bgcolor="#ffffff"> <tbody> <tr> <td style="PADDING-BOTTOM: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px" valign="top" align="center"> <p style="LINE-HEIGHT: 1.5em; FONT-FAMILY: verdana, arial, helvetica, sans-serif; COLOR: #696e72; FONT-SIZE: 10px; FONT-WEIGHT: bold" align="center">You are subscribed as %%emailaddress%%</p> <div></div> <div></div><!-- EndBlockNoDelete --> <table> <tbody> <tr> <td><a href="http://puroparty.com/emails/census/census_eng.jpg"><img src="http://puroparty.com/emails/census/census_eng.jpg" width="400"/></a> </td> <td><a href="http://puroparty.com/emails/census/census_eng.jpg"><img src="http://puroparty.com/emails/census/census_span.jpg" width="400"/></a> </td></tr></tbody></table></td></tr></tbody></table></td></tr> <tr> <td> <table style="PADDING-BOTTOM: 5px; PADDING-LEFT: 30px; PADDING-RIGHT: 30px; COLOR: #aea48b; FONT-SIZE: 10px; PADDING-TOP: 5px" border="0" cellspacing="0" cellpadding="0" width="100%"> <tbody> <tr> <td width="100%"> <p style="LINE-HEIGHT: 1.5em; FONT-FAMILY: 'Verdana'; COLOR: #aea48b; FONT-SIZE: 10px" align="center"><a style="COLOR: #aea48b" href="%%unsubscribelink%%">To stop receiving these emails please unsubscribe.</a> </p></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