Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_lists
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Function
Null
Value
listid
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
ownername
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
owneremail
varchar(100)
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
bounceemail
varchar(100)
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
replytoemail
varchar(100)
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
bounceserver
varchar(100)
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
bounceusername
varchar(100)
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
bouncepassword
varchar(100)
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
extramailsettings
varchar(100)
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
companyname
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
companyaddress
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
companyphone
varchar(20)
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
notifyowner
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
imapaccount
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
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
subscribecount
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
unsubscribecount
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
bouncecount
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
processbounce
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
agreedelete
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
visiblefields
text
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
emailaddress,subscribedate,format,status,confirmed
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