Server: mysql.puroparty.com

Database: puroparty

Table: wp_8_links

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	link_id	bigint(20)			No		auto_increment
	link_url	varchar(255)	utf8_general_ci		No
	link_name	varchar(255)	utf8_general_ci		No
	link_image	varchar(255)	utf8_general_ci		No
	link_target	varchar(25)	utf8_general_ci		No
	link_category	bigint(20)			No	0
	link_description	varchar(255)	utf8_general_ci		No
	link_visible	varchar(20)	utf8_general_ci		No	Y
	link_owner	int(11)			No	1
	link_rating	int(11)			No	0
	link_updated	datetime			No	0000-00-00 00:00:00
	link_rel	varchar(255)	utf8_general_ci		No
	link_notes	mediumtext	utf8_general_ci		No
	link_rss	varchar(255)	utf8_general_ci		No
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After link_id link_url link_name link_image link_target link_category link_description link_visible link_owner link_rating link_updated link_rel link_notes link_rss

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 2  link_id link_id_2 UNIQUE 2  link_id link_url_2 UNIQUE 2  link_url link_name_2 UNIQUE 2  link_name link_rss_2 UNIQUE 2  link_rss link_id_3 UNIQUE 2  link_id link_url_5 UNIQUE 2  link_url link_name_5 UNIQUE 2  link_name link_rss_6 UNIQUE 2  link_rss link_id_5 UNIQUE 2  link_id link_updated_3 UNIQUE 2  link_updated link_category INDEX None  link_category link_visible INDEX None  link_visible link_id INDEX None  link_id link_url INDEX None  link_url link_name INDEX None  link_name link_image INDEX None  link_image link_target INDEX None  link_target link_category_2 INDEX None  link_category link_description INDEX None  link_description link_visible_2 INDEX None  link_visible link_owner INDEX None  link_owner link_rating INDEX None  link_rating link_updated INDEX None  link_updated link_rel INDEX None  link_rel link_rss INDEX None  link_rss link_description_4 INDEX None  link_description link_rel_4 INDEX None  link_rel link_rss_4 INDEX None  link_rss link_visible_4 INDEX None  link_visible link_rating_2 INDEX None  link_rating link_image_4 INDEX None  link_image link_target_4 INDEX None  link_target link_name_6 INDEX None  link_name link_updated_2 INDEX None  link_updated link_category_3 INDEX None  link_category link_url_6 INDEX None  link_url link_id_4 INDEX None  link_id link_owner_2 INDEX None  link_owner link_description_6 INDEX None  link_description link_rss_7 INDEX None  link_rss link_url_3 FULLTEXT None  link_url link_name_3 FULLTEXT None  link_name link_image_2 FULLTEXT None  link_image link_target_2 FULLTEXT None  link_target link_description_2 FULLTEXT None  link_description link_visible_3 FULLTEXT None  link_visible link_rel_2 FULLTEXT None  link_rel link_notes FULLTEXT None  link_notes link_rss_3 FULLTEXT None  link_rss link_rel_3 FULLTEXT None  link_rel link_description_3 FULLTEXT None  link_description link_url_4 FULLTEXT None  link_url link_image_3 FULLTEXT None  link_image link_visible_5 FULLTEXT None  link_visible link_notes_2 FULLTEXT None  link_notes link_target_3 FULLTEXT None  link_target link_name_4 FULLTEXT None  link_name link_rss_5 FULLTEXT None  link_rss link_notes_3 FULLTEXT None  link_notes link_description_5 FULLTEXT None  link_description link_image_5 FULLTEXT None  link_image link_name_7 FULLTEXT None  link_name link_target_5 FULLTEXT None  link_target Create an index on  columns

Space usage:  Type Usage Data 204 Bytes Index 4,096 Bytes Total 4,300 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Rows 2 Row length ø 102 Row size  ø 2,150 Bytes Next Autoindex 3 Creation Dec 13, 2017 at 02:29 AM Last update Mar 10, 2024 at 10:14 PM Last check Mar 10, 2024 at 10:14 PM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `wp_8_links` ADD UNIQUE(`link_owner`)		link_id link_url link_name link_image link_target link_category link_description link_visible link_owner link_rating link_updated link_rel link_notes link_rss
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