Server: mysql.puroparty.com

Database: puroparty

Table: email_queues

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	queueid	int(11)			Yes	0
	queuetype	varchar(255)	utf8_general_ci		Yes	NULL
	ownerid	int(11)			No	0
	recipient	int(11)			Yes	0
	processed	char(1)	utf8_general_ci		Yes	0
	sent	char(1)	utf8_general_ci		Yes	0
	processtime	datetime			Yes	NULL
Check All  /  Uncheck All     With selected:

Print view

Relation view

Propose table structure

Add new field:  At End of Table At Beginning of Table After queueid queuetype ownerid recipient processed sent processtime

Indexes: Keyname Type Cardinality Action Field email_queues_id_type_recip_idx INDEX 102086  queueid queuetype recipient email_queues_id_type_processed_idx INDEX 144  queueid queuetype processed email_queuetype_recipient_idx INDEX 51043  queuetype recipient queueid INDEX 4  queueid queuetype INDEX 4  queuetype ownerid INDEX 4  ownerid recipient INDEX 102086  recipient processed INDEX 4  processed sent INDEX 4  sent processtime INDEX 4  processtime processed_2 INDEX 4  processed recipient_2 INDEX 51043  recipient queuetype_2 INDEX 4  queuetype ownerid_2 INDEX 4  ownerid processtime_2 INDEX 4  processtime queueid_2 INDEX 4  queueid sent_2 INDEX 4  sent processed_3 INDEX 4  processed queuetype_3 INDEX 4  queuetype sent_3 INDEX 4  sent processtime_3 INDEX 4  processtime ownerid_3 INDEX 4  ownerid queueid_3 INDEX 4  queueid recipient_3 INDEX 51043  recipient queuetype_4 INDEX 4  queuetype processtime_4 INDEX 34028  processtime ownerid_4 INDEX 4  ownerid queueid_4 INDEX 4  queueid sent_4 INDEX 4  sent recipient_4 INDEX 51043  recipient processed_4 INDEX 4  processed ownerid_5 INDEX 4  ownerid processed_5 INDEX 4  processed queueid_5 INDEX 4  queueid recipient_5 INDEX 51043  recipient queuetype_5 INDEX 4  queuetype processtime_5 INDEX 4  processtime sent_5 INDEX 4  sent queuetype_6 INDEX 4  queuetype queueid_6 INDEX 4  queueid processed_6 INDEX 4  processed ownerid_6 INDEX 4  ownerid sent_6 INDEX 4  sent recipient_6 INDEX 51043  recipient queueid_7 INDEX 4  queueid queuetype_7 INDEX 4  queuetype ownerid_7 INDEX 4  ownerid recipient_7 INDEX 51043  recipient processed_7 INDEX 4  processed sent_7 INDEX 4  sent processtime_6 INDEX 4  processtime processtime_7 INDEX 25521  processtime queueid_8 INDEX 4  queueid sent_8 INDEX 4  sent queueid_9 INDEX 4  queueid Create an index on  columns

Space usage:  Type Usage Data 7,696 KB Index 152,944 KB Total 160,640 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Creation Mar 28, 2024 at 04:42 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_queues` WHERE 1		queueid queuetype ownerid recipient processed sent processtime
Show this query here again
Or Location of the textfile:
Location of the textfile:
(Max: 2,048KB)
Compression:      Autodetect   None   "gzipped"   "bzipped"
Character set of the file: armscii8 ascii big5 binary cp1250 cp1251 cp1256 cp1257 cp850 cp852 cp866 cp932 dec8 euckr gb2312 gbk geostd8 greek hebrew hp8 keybcs2 koi8r koi8u latin1 latin2 latin5 latin7 macce macroman sjis swe7 tis620 ucs2 ujis utf8