Server: mysql.puroparty.com

Database: puroparty

Table: bak_components

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	id	int(11)			No		auto_increment
	name	varchar(50)	utf8_general_ci		No
	link	varchar(255)	utf8_general_ci		No
	menuid	int(11)		UNSIGNED	No	0
	parent	int(11)		UNSIGNED	No	0
	admin_menu_link	varchar(255)	utf8_general_ci		No
	admin_menu_alt	varchar(255)	utf8_general_ci		No
	option	varchar(50)	utf8_general_ci		No
	ordering	int(11)			No	0
	admin_menu_img	varchar(255)	utf8_general_ci		No
	iscore	tinyint(4)			No	0
	params	text	utf8_general_ci		No
	enabled	tinyint(4)			No	1
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After id name link menuid parent admin_menu_link admin_menu_alt option ordering admin_menu_img iscore params enabled

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 32  id id_2 UNIQUE 32  id id_3 UNIQUE 32  id id_5 UNIQUE 32  id id_8 UNIQUE 32  id parent_option INDEX None  parent option 32 id INDEX None  id name INDEX None  name link INDEX None  link menuid INDEX None  menuid parent INDEX None  parent admin_menu_link INDEX None  admin_menu_link admin_menu_alt INDEX None  admin_menu_alt option INDEX None  option ordering INDEX None  ordering admin_menu_img INDEX None  admin_menu_img iscore INDEX None  iscore enabled INDEX None  enabled admin_menu_alt_3 INDEX None  admin_menu_alt menuid_2 INDEX None  menuid admin_menu_img_4 INDEX None  admin_menu_img ordering_2 INDEX None  ordering id_4 INDEX None  id iscore_2 INDEX None  iscore link_3 INDEX None  link parent_2 INDEX None  parent option_4 INDEX None  option enabled_2 INDEX None  enabled name_4 INDEX None  name admin_menu_link_4 INDEX None  admin_menu_link option_5 INDEX None  option menuid_3 INDEX None  menuid admin_menu_img_5 INDEX None  admin_menu_img id_6 INDEX None  id admin_menu_link_6 INDEX None  admin_menu_link parent_3 INDEX None  parent ordering_3 INDEX None  ordering admin_menu_alt_6 INDEX None  admin_menu_alt enabled_3 INDEX None  enabled iscore_3 INDEX None  iscore name_6 INDEX None  name link_6 INDEX None  link id_7 INDEX None  id name_2 FULLTEXT None  name link_2 FULLTEXT None  link admin_menu_link_2 FULLTEXT None  admin_menu_link admin_menu_alt_2 FULLTEXT None  admin_menu_alt option_2 FULLTEXT None  option admin_menu_img_2 FULLTEXT None  admin_menu_img params FULLTEXT None  params admin_menu_img_3 FULLTEXT None  admin_menu_img admin_menu_alt_4 FULLTEXT None  admin_menu_alt option_3 FULLTEXT None  option name_3 FULLTEXT None  name link_4 FULLTEXT None  link params_2 FULLTEXT None  params admin_menu_link_3 FULLTEXT None  admin_menu_link name_5 FULLTEXT None  name link_5 FULLTEXT None  link admin_menu_link_5 FULLTEXT None  admin_menu_link params_3 FULLTEXT None  params admin_menu_alt_5 FULLTEXT None  admin_menu_alt option_6 FULLTEXT None  option admin_menu_img_6 FULLTEXT None  admin_menu_img Create an index on  columns

Space usage:  Type Usage Data 4,364 Bytes Index 4,096 Bytes Total 8,460 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Rows 32 Row length ø 136 Row size  ø 264 Bytes Next Autoindex 34 Creation Nov 21, 2017 at 10:57 PM Last update Mar 18, 2024 at 12:32 AM Last check Mar 29, 2024 at 08:18 AM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `bak_components` ADD UNIQUE(`parent`)		id name link menuid parent admin_menu_link admin_menu_alt option ordering admin_menu_img iscore params enabled
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