Server: mysql.puroparty.com

Database: puroparty

Table: poll_user

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	user_id	smallint(5)			No		auto_increment
	username	varchar(30)	latin1_swedish_ci		No
	userpass	varchar(32)	latin1_swedish_ci		No
	session	varchar(32)	latin1_swedish_ci		No
	last_visit	int(11)			No	0
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After user_id username userpass session last_visit

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 1  user_id user_id_2 UNIQUE 1  user_id username_2 UNIQUE 1  username userpass_2 UNIQUE 1  userpass session_2 UNIQUE 1  session last_visit_2 UNIQUE 1  last_visit last_visit_4 UNIQUE 1  last_visit username_4 UNIQUE 1  username session_4 UNIQUE 1  session user_id_3 UNIQUE 1  user_id userpass_6 UNIQUE 1  userpass last_visit_5 UNIQUE 1  last_visit session_7 UNIQUE 1  session user_id_6 UNIQUE 1  user_id username_9 UNIQUE 1  username last_visit_7 UNIQUE 1  last_visit userpass_9 UNIQUE 1  userpass user_id_7 UNIQUE 1  user_id username_11 UNIQUE 1  username session_11 UNIQUE 1  session last_visit_9 UNIQUE 1  last_visit userpass_12 UNIQUE 1  userpass user_id_10 UNIQUE 1  user_id username_14 UNIQUE 1  username userpass_14 UNIQUE 1  userpass session_14 UNIQUE 1  session user_id INDEX None  user_id username INDEX None  username userpass INDEX None  userpass session INDEX None  session last_visit INDEX None  last_visit last_visit_3 INDEX None  last_visit userpass_4 INDEX None  userpass user_id_4 INDEX None  user_id session_5 INDEX None  session username_6 INDEX None  username user_id_5 INDEX None  user_id username_7 INDEX None  username userpass_7 INDEX None  userpass last_visit_6 INDEX None  last_visit session_8 INDEX None  session session_10 INDEX None  session username_12 INDEX None  username user_id_8 INDEX None  user_id userpass_10 INDEX None  userpass last_visit_8 INDEX None  last_visit user_id_9 INDEX None  user_id username_13 INDEX None  username userpass_13 INDEX None  userpass session_13 INDEX None  session username_3 FULLTEXT None  username userpass_3 FULLTEXT None  userpass session_3 FULLTEXT None  session username_5 FULLTEXT None  username userpass_5 FULLTEXT None  userpass session_6 FULLTEXT None  session username_8 FULLTEXT None  username userpass_8 FULLTEXT None  userpass session_9 FULLTEXT None  session username_10 FULLTEXT None  username userpass_11 FULLTEXT None  userpass session_12 FULLTEXT None  session username_15 FULLTEXT None  username userpass_15 FULLTEXT None  userpass Create an index on  columns

Space usage:  Type Usage Data 80 Bytes Index 3,072 Bytes Total 3,152 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 1 Row length ø 80 Row size  ø 3,152 Bytes Next Autoindex 2 Creation Apr 22, 2018 at 02:45 AM Last update Apr 22, 2018 at 02:45 AM Last check Mar 28, 2024 at 08:29 PM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `poll_user` ADD FULLTEXT(`username`)		user_id username userpass session last_visit
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