Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_jobs
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Function
Null
Value
jobid
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
jobtype
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
jobstatus
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
jobtime
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
jobdetails
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
a:19:{s:16:"NewsletterChosen";i:2;s:5:"Lists";a:1:{i:0;s:1:"1";}s:12:"SendCriteria";a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";}s:8:"SendSize";s:1:"2";s:9:"Multipart";i:1;s:10:"TrackOpens";i:1;s:10:"TrackLinks";i:1;s:11:"EmbedImages";i:0;s:10:"Newsletter";s:1:"2";s:12:"SendFromName";s:9:"PuroParty";s:13:"SendFromEmail";s:19:"ppcru@puroparty.com";s:12:"ReplyToEmail";s:19:"ppcru@puroparty.com";s:11:"BounceEmail";s:19:"ppcru@puroparty.com";s:12:"To_FirstName";b:0;s:11:"To_LastName";b:0;s:7:"Charset";s:5:"UTF-8";s:11:"NotifyOwner";i:0;s:13:"SendStartTime";i:1220654563;s:12:"EmailResults";a:3:{s:7:"success";i:0;s:5:"total";i:0;s:7:"failure";i:0;}}
fkid
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
lastupdatetime
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
fktype
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
queueid
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
approved
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
authorisedtosend
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
resendcount
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