Server: mysql.puroparty.com

Database: puroparty

Table: email_customfields

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	fieldid	int(11)			No		auto_increment
	name	varchar(255)	utf8_general_ci		Yes	NULL
	fieldtype	varchar(100)	utf8_general_ci		Yes	NULL
	defaultvalue	varchar(255)	utf8_general_ci		Yes	NULL
	required	char(1)	utf8_general_ci		Yes	0
	fieldsettings	mediumtext	utf8_general_ci		Yes	NULL
	createdate	int(11)			Yes	0
	ownerid	int(11)			Yes	0
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 fieldid name fieldtype defaultvalue required fieldsettings createdate ownerid

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 9  fieldid fieldid_2 UNIQUE 9  fieldid fieldid_4 UNIQUE 9  fieldid fieldid_6 UNIQUE 9  fieldid fieldid_7 UNIQUE 9  fieldid fieldid_9 UNIQUE 9  fieldid fieldid_12 UNIQUE 9  fieldid name_2 UNIQUE 9  name createdate_2 UNIQUE 9  createdate name_3 UNIQUE 9  name createdate_4 UNIQUE 9  createdate createdate_5 UNIQUE 9  createdate name_6 UNIQUE 9  name createdate_7 UNIQUE 9  createdate name_7 UNIQUE 9  name createdate_9 UNIQUE 9  createdate name_10 UNIQUE 9  name createdate_11 UNIQUE 9  createdate createdate_12 UNIQUE 9  createdate email_customfields_owner_idx INDEX 2  ownerid email_customfield_id_name INDEX 9  fieldid name fieldid INDEX 9  fieldid name INDEX 9  name fieldtype INDEX 9  fieldtype defaultvalue INDEX 4  defaultvalue required INDEX 2  required createdate INDEX 9  createdate ownerid INDEX 2  ownerid fieldid_3 INDEX 9  fieldid createdate_3 INDEX 9  createdate ownerid_2 INDEX 2  ownerid defaultvalue_2 INDEX 4  defaultvalue required_2 INDEX 2  required fieldtype_2 INDEX 9  fieldtype name_4 INDEX 9  name fieldid_5 INDEX 9  fieldid name_5 INDEX 9  name fieldtype_3 INDEX 9  fieldtype defaultvalue_3 INDEX 4  defaultvalue required_3 INDEX 2  required createdate_6 INDEX 9  createdate ownerid_3 INDEX 2  ownerid required_4 INDEX 2  required ownerid_4 INDEX 2  ownerid defaultvalue_4 INDEX 4  defaultvalue createdate_8 INDEX 9  createdate fieldtype_4 INDEX 9  fieldtype name_8 INDEX 9  name fieldid_8 INDEX 9  fieldid ownerid_5 INDEX 2  ownerid name_9 INDEX 9  name required_5 INDEX 2  required required_6 INDEX 2  required createdate_10 INDEX 9  createdate ownerid_6 INDEX 2  ownerid defaultvalue_5 INDEX 4  defaultvalue fieldtype_5 INDEX 9  fieldtype fieldtype_6 INDEX 9  fieldtype defaultvalue_6 INDEX 4  defaultvalue name_11 INDEX 9  name createdate_13 INDEX 9  createdate fieldid_10 INDEX 9  fieldid fieldid_11 INDEX 9  fieldid name_12 INDEX 9  name Create an index on  columns

Space usage:  Type Usage Data 16,384 Bytes Index 1,008 KB Total 1,024 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Next Autoindex 11 Creation Jun 19, 2018 at 10:10 PM

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `email_customfields` ADD INDEX(`fieldsettings`)		fieldid name fieldtype defaultvalue required fieldsettings createdate ownerid
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