Server: mysql.puroparty.com

Database: puroparty

Table: wp_blogs

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	blog_id	bigint(20)			No		auto_increment
	site_id	bigint(20)			No	0
	domain	varchar(200)	utf8_general_ci		No
	path	varchar(100)	utf8_general_ci		No
	registered	datetime			No	0000-00-00 00:00:00
	last_updated	datetime			No	0000-00-00 00:00:00
	public	tinyint(2)			No	1
	archived	enum('0', '1')	utf8_general_ci		No	0
	mature	tinyint(2)			No	0
	spam	tinyint(2)			No	0
	deleted	tinyint(2)			No	0
	lang_id	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 blog_id site_id domain path registered last_updated public archived mature spam deleted lang_id

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 8  blog_id blog_id_2 UNIQUE 8  blog_id path_2 UNIQUE 8  path registered_2 UNIQUE 8  registered last_updated_2 UNIQUE 8  last_updated last_updated_3 UNIQUE 8  last_updated registered_4 UNIQUE 8  registered path_5 UNIQUE 8  path blog_id_4 UNIQUE 8  blog_id blog_id_5 UNIQUE 8  blog_id last_updated_5 UNIQUE 8  last_updated path_8 UNIQUE 8  path registered_6 UNIQUE 8  registered registered_7 UNIQUE 8  registered last_updated_7 UNIQUE 8  last_updated domain INDEX None  domain 50 path 5 lang_id INDEX None  lang_id blog_id INDEX None  blog_id site_id INDEX None  site_id domain_2 INDEX None  domain path INDEX None  path registered INDEX None  registered last_updated INDEX None  last_updated public INDEX None  public archived INDEX None  archived mature INDEX None  mature spam INDEX None  spam deleted INDEX None  deleted lang_id_2 INDEX None  lang_id archived_2 INDEX None  archived registered_3 INDEX None  registered public_2 INDEX None  public deleted_2 INDEX None  deleted last_updated_4 INDEX None  last_updated blog_id_3 INDEX None  blog_id lang_id_3 INDEX None  lang_id site_id_2 INDEX None  site_id mature_2 INDEX None  mature domain_5 INDEX None  domain path_6 INDEX None  path spam_2 INDEX None  spam spam_3 INDEX None  spam public_3 INDEX None  public path_7 INDEX None  path archived_3 INDEX None  archived deleted_3 INDEX None  deleted lang_id_4 INDEX None  lang_id site_id_3 INDEX None  site_id mature_3 INDEX None  mature domain_6 INDEX None  domain last_updated_6 INDEX None  last_updated registered_5 INDEX None  registered blog_id_6 INDEX None  blog_id registered_8 INDEX None  registered last_updated_8 INDEX None  last_updated archived_4 INDEX None  archived blog_id_7 INDEX None  blog_id domain_3 FULLTEXT None  domain path_3 FULLTEXT None  path path_4 FULLTEXT None  path domain_4 FULLTEXT None  domain path_9 FULLTEXT None  path domain_7 FULLTEXT None  domain path_10 FULLTEXT None  path Create an index on  columns

Space usage:  Type Usage Data 576 Bytes Index 4,096 Bytes Total 4,672 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Rows 8 Row length ø 72 Row size  ø 584 Bytes Next Autoindex 10 Creation Dec 14, 2017 at 08:20 AM Last update Dec 14, 2017 at 08:20 AM Last check Mar 23, 2024 at 11:51 AM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `wp_blogs` ADD UNIQUE(`lang_id`)		blog_id site_id domain path registered last_updated public archived mature spam deleted lang_id
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