Server: mysql.puroparty.com

Database: puroparty

Table: asLinks_links

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	id	smallint(10)		UNSIGNED	No		auto_increment
	name	varchar(255)	latin1_swedish_ci		Yes	NULL
	email	varchar(255)	latin1_swedish_ci		Yes	NULL
	url	varchar(255)	latin1_swedish_ci		Yes	NULL
	title	text	latin1_swedish_ci		Yes	NULL
	description	text	latin1_swedish_ci		Yes	NULL
	category	smallint(10)			No	0
	reciprocal	varchar(255)	latin1_swedish_ci		Yes	NULL
	confirmed	smallint(1)			No	0
	approved	smallint(1)			No	0
	added	int(10)			No	0
	nextcheck	int(10)			No	0
	nocheck	smallint(1)			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 id name email url title description category reciprocal confirmed approved added nextcheck nocheck

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 2  id id_2 UNIQUE 2  id category_2 UNIQUE 2  category confirmed_2 UNIQUE 2  confirmed approved_2 UNIQUE 2  approved nextcheck_2 UNIQUE 2  nextcheck id_3 UNIQUE 2  id approved_3 UNIQUE 2  approved nextcheck_3 UNIQUE 2  nextcheck confirmed_4 UNIQUE 2  confirmed category_4 UNIQUE 2  category id_6 UNIQUE 2  id name_2 UNIQUE None  name email_2 UNIQUE None  email url_2 UNIQUE None  url reciprocal_2 UNIQUE None  reciprocal reciprocal_4 UNIQUE None  reciprocal email_5 UNIQUE None  email name_5 UNIQUE None  name url_4 UNIQUE None  url name_8 UNIQUE None  name email_8 UNIQUE None  email url_8 UNIQUE None  url id INDEX None  id name INDEX None  name email INDEX None  email url INDEX None  url category INDEX None  category reciprocal INDEX None  reciprocal confirmed INDEX None  confirmed approved INDEX None  approved added INDEX None  added nextcheck INDEX None  nextcheck nocheck INDEX None  nocheck category_3 INDEX None  category name_4 INDEX None  name nocheck_2 INDEX None  nocheck id_4 INDEX None  id email_6 INDEX None  email confirmed_3 INDEX None  confirmed approved_4 INDEX None  approved added_2 INDEX None  added reciprocal_6 INDEX None  reciprocal nextcheck_4 INDEX None  nextcheck url_6 INDEX None  url nocheck_3 INDEX None  nocheck id_5 INDEX None  id name_7 INDEX None  name email_7 INDEX None  email url_7 INDEX None  url name_3 FULLTEXT None  name email_3 FULLTEXT None  email url_3 FULLTEXT None  url title FULLTEXT None  title description FULLTEXT None  description reciprocal_3 FULLTEXT None  reciprocal description_2 FULLTEXT None  description email_4 FULLTEXT None  email name_6 FULLTEXT None  name reciprocal_5 FULLTEXT None  reciprocal title_2 FULLTEXT None  title url_5 FULLTEXT None  url name_9 FULLTEXT None  name email_9 FULLTEXT None  email Create an index on  columns

Space usage:  Type Usage Data 444 Bytes Index 4,096 Bytes Total 4,540 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 2 Row length ø 222 Row size  ø 2,270 Bytes Next Autoindex 3 Creation Nov 12, 2017 at 10:12 AM Last update Apr 18, 2024 at 12:34 PM Last check Mar 31, 2018 at 04:29 AM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `asLinks_links` ADD UNIQUE(`url`)		id name email url title description category reciprocal confirmed approved added nextcheck nocheck
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