Server: mysql.puroparty.com

Database: puroparty

Table: jos_bannerclient

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	cid	int(11)			No		auto_increment
	name	varchar(255)	utf8_general_ci		No
	contact	varchar(255)	utf8_general_ci		No
	email	varchar(255)	utf8_general_ci		No
	extrainfo	text	utf8_general_ci		No
	checked_out	tinyint(1)			No	0
	checked_out_time	time			Yes	NULL
	editor	varchar(50)	utf8_general_ci		Yes	NULL
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After cid name contact email extrainfo checked_out checked_out_time editor

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 1  cid cid_2 UNIQUE 1  cid name_2 UNIQUE 1  name contact_2 UNIQUE 1  contact email_2 UNIQUE 1  email checked_out_2 UNIQUE 1  checked_out checked_out_3 UNIQUE 1  checked_out cid_3 UNIQUE 1  cid contact_4 UNIQUE 1  contact name_5 UNIQUE 1  name email_6 UNIQUE 1  email name_7 UNIQUE 1  name checked_out_6 UNIQUE 1  checked_out cid_5 UNIQUE 1  cid email_9 UNIQUE 1  email contact_8 UNIQUE 1  contact checked_out_7 UNIQUE 1  checked_out contact_11 UNIQUE 1  contact email_10 UNIQUE 1  email checked_out_time_2 UNIQUE None  checked_out_time editor_2 UNIQUE None  editor editor_4 UNIQUE None  editor checked_out_time_3 UNIQUE None  checked_out_time checked_out_time_5 UNIQUE None  checked_out_time editor_9 UNIQUE None  editor cid INDEX None  cid name INDEX None  name contact INDEX None  contact email INDEX None  email checked_out INDEX None  checked_out checked_out_time INDEX None  checked_out_time editor INDEX None  editor email_4 INDEX None  email name_4 INDEX None  name editor_5 INDEX None  editor checked_out_4 INDEX None  checked_out contact_5 INDEX None  contact cid_4 INDEX None  cid checked_out_time_4 INDEX None  checked_out_time contact_7 INDEX None  contact name_8 INDEX None  name checked_out_5 INDEX None  checked_out email_8 INDEX None  email editor_8 INDEX None  editor cid_6 INDEX None  cid checked_out_time_6 INDEX None  checked_out_time contact_10 INDEX None  contact name_3 FULLTEXT None  name contact_3 FULLTEXT None  contact email_3 FULLTEXT None  email extrainfo FULLTEXT None  extrainfo editor_3 FULLTEXT None  editor editor_6 FULLTEXT None  editor name_6 FULLTEXT None  name email_5 FULLTEXT None  email extrainfo_2 FULLTEXT None  extrainfo contact_6 FULLTEXT None  contact editor_7 FULLTEXT None  editor email_7 FULLTEXT None  email name_9 FULLTEXT None  name extrainfo_3 FULLTEXT None  extrainfo contact_9 FULLTEXT None  contact extrainfo_4 FULLTEXT None  extrainfo editor_10 FULLTEXT None  editor Create an index on  columns

Space usage:  Type Usage Data 72 Bytes Index 3,072 Bytes Total 3,144 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Rows 1 Row length ø 72 Row size  ø 3,144 Bytes Next Autoindex 2 Creation Dec 13, 2017 at 08:00 AM Last update Mar 28, 2024 at 02:31 PM Last check Mar 28, 2024 at 02:31 PM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `jos_bannerclient` ADD INDEX(`name`)		cid name contact email extrainfo checked_out checked_out_time editor
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