Server: mysql.puroparty.com

Database: puroparty

Table: wp_4_posts

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	ID	bigint(20)		UNSIGNED	No		auto_increment
	post_author	bigint(20)			No	0
	post_date	datetime			No	0000-00-00 00:00:00
	post_date_gmt	datetime			No	0000-00-00 00:00:00
	post_content	longtext	utf8_general_ci		No
	post_title	text	utf8_general_ci		No
	post_category	int(4)			No	0
	post_excerpt	text	utf8_general_ci		No
	post_status	varchar(20)	utf8_general_ci		No	publish
	comment_status	varchar(20)	utf8_general_ci		No	open
	ping_status	varchar(20)	utf8_general_ci		No	open
	post_password	varchar(20)	utf8_general_ci		No
	post_name	varchar(200)	utf8_general_ci		No
	to_ping	text	utf8_general_ci		No
	pinged	text	utf8_general_ci		No
	post_modified	datetime			No	0000-00-00 00:00:00
	post_modified_gmt	datetime			No	0000-00-00 00:00:00
	post_content_filtered	text	utf8_general_ci		No
	post_parent	bigint(20)			No	0
	guid	varchar(255)	utf8_general_ci		No
	menu_order	int(11)			No	0
	post_type	varchar(20)	utf8_general_ci		No	post
	post_mime_type	varchar(100)	utf8_general_ci		No
	comment_count	bigint(20)			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 post_author post_date post_date_gmt post_content post_title post_category post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count

---

Structure Browse SQL Search Insert Export Operations Empty Drop

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 5  ID ID_2 UNIQUE 5  ID post_date_2 UNIQUE 5  post_date post_date_gmt_2 UNIQUE 5  post_date_gmt post_name_3 UNIQUE 5  post_name post_modified_2 UNIQUE 5  post_modified post_modified_gmt_2 UNIQUE 5  post_modified_gmt guid_2 UNIQUE 5  guid post_modified_gmt_3 UNIQUE 5  post_modified_gmt post_modified_3 UNIQUE 5  post_modified ID_3 UNIQUE 5  ID post_name_6 UNIQUE 5  post_name post_name INDEX None  post_name type_status_date INDEX None  post_type post_status post_date ID ID INDEX None  ID post_author INDEX None  post_author post_date INDEX None  post_date post_date_gmt INDEX None  post_date_gmt post_category INDEX None  post_category post_status INDEX None  post_status comment_status INDEX None  comment_status ping_status INDEX None  ping_status post_password INDEX None  post_password post_name_2 INDEX None  post_name post_modified INDEX None  post_modified post_modified_gmt INDEX None  post_modified_gmt post_parent INDEX None  post_parent guid INDEX None  guid menu_order INDEX None  menu_order post_type INDEX None  post_type post_mime_type INDEX None  post_mime_type comment_count INDEX None  comment_count post_mime_type_3 INDEX None  post_mime_type post_name_5 INDEX None  post_name post_password_3 INDEX None  post_password guid_4 INDEX None  guid post_date_3 INDEX None  post_date comment_status_3 INDEX None  comment_status post_modified_4 INDEX None  post_modified menu_order_2 INDEX None  menu_order post_author_2 INDEX None  post_author post_type_4 INDEX None  post_type ID_4 INDEX None  ID post_content FULLTEXT None  post_content post_title FULLTEXT None  post_title post_excerpt FULLTEXT None  post_excerpt post_status_2 FULLTEXT None  post_status comment_status_2 FULLTEXT None  comment_status ping_status_2 FULLTEXT None  ping_status post_password_2 FULLTEXT None  post_password post_name_4 FULLTEXT None  post_name to_ping FULLTEXT None  to_ping pinged FULLTEXT None  pinged post_content_filtered FULLTEXT None  post_content_filtered guid_3 FULLTEXT None  guid post_type_2 FULLTEXT None  post_type post_mime_type_2 FULLTEXT None  post_mime_type to_ping_2 FULLTEXT None  to_ping post_content_2 FULLTEXT None  post_content post_excerpt_2 FULLTEXT None  post_excerpt post_password_4 FULLTEXT None  post_password post_type_3 FULLTEXT None  post_type post_status_3 FULLTEXT None  post_status post_name_7 FULLTEXT None  post_name Create an index on  columns

Space usage:  Type Usage Data 5,008 Bytes Index 4,096 Bytes Total 9,104 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Rows 5 Row length ø 1,001 Row size  ø 1,821 Bytes Next Autoindex 11 Creation Oct 20, 2017 at 09:28 PM Last update Oct 20, 2017 at 09:28 PM Last check Mar 28, 2024 at 07:26 PM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `wp_4_posts` ADD UNIQUE(`menu_order`)		ID post_author post_date post_date_gmt post_content post_title post_category post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count
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