Server: mysql.puroparty.com

Database: puroparty

Table: jos_content

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	id	int(11)		UNSIGNED	No		auto_increment
	title	varchar(255)	utf8_general_ci		No
	alias	varchar(255)	utf8_general_ci		No
	title_alias	varchar(255)	utf8_general_ci		No
	introtext	mediumtext	utf8_general_ci		No
	fulltext	mediumtext	utf8_general_ci		No
	state	tinyint(3)			No	0
	sectionid	int(11)		UNSIGNED	No	0
	mask	int(11)		UNSIGNED	No	0
	catid	int(11)		UNSIGNED	No	0
	created	datetime			No	0000-00-00 00:00:00
	created_by	int(11)		UNSIGNED	No	0
	created_by_alias	varchar(255)	utf8_general_ci		No
	modified	datetime			No	0000-00-00 00:00:00
	modified_by	int(11)		UNSIGNED	No	0
	checked_out	int(11)		UNSIGNED	No	0
	checked_out_time	datetime			No	0000-00-00 00:00:00
	publish_up	datetime			No	0000-00-00 00:00:00
	publish_down	datetime			No	0000-00-00 00:00:00
	images	text	utf8_general_ci		No
	urls	text	utf8_general_ci		No
	attribs	text	utf8_general_ci		No
	version	int(11)		UNSIGNED	No	1
	parentid	int(11)		UNSIGNED	No	0
	ordering	int(11)			No	0
	metakey	text	utf8_general_ci		No
	metadesc	text	utf8_general_ci		No
	access	int(11)		UNSIGNED	No	0
	hits	int(11)		UNSIGNED	No	0
	metadata	text	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 id title alias title_alias introtext fulltext state sectionid mask catid created created_by created_by_alias modified modified_by checked_out checked_out_time publish_up publish_down images urls attribs version parentid ordering metakey metadesc access hits metadata

---

Structure Browse SQL Search Insert Export Operations Empty Drop

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 43  id id_2 UNIQUE 43  id title_2 UNIQUE 43  title alias_2 UNIQUE 43  alias modified_2 UNIQUE 43  modified idx_section INDEX None  sectionid idx_access INDEX None  access idx_checkout INDEX None  checked_out idx_state INDEX None  state idx_catid INDEX None  catid idx_createdby INDEX None  created_by id INDEX None  id title INDEX None  title alias INDEX None  alias title_alias INDEX None  title_alias state INDEX None  state sectionid INDEX None  sectionid mask INDEX None  mask catid INDEX None  catid created INDEX None  created created_by INDEX None  created_by created_by_alias INDEX None  created_by_alias modified INDEX None  modified modified_by INDEX None  modified_by checked_out INDEX None  checked_out checked_out_time INDEX None  checked_out_time publish_up INDEX None  publish_up publish_down INDEX None  publish_down version INDEX None  version parentid INDEX None  parentid ordering INDEX None  ordering access INDEX None  access hits INDEX None  hits hits_2 INDEX None  hits title_alias_3 INDEX None  title_alias catid_2 INDEX None  catid alias_4 INDEX None  alias checked_out_time_2 INDEX None  checked_out_time parentid_2 INDEX None  parentid access_2 INDEX None  access created_2 INDEX None  created mask_2 INDEX None  mask state_2 INDEX None  state created_by_2 INDEX None  created_by ordering_2 INDEX None  ordering title_3 FULLTEXT None  title alias_3 FULLTEXT None  alias title_alias_2 FULLTEXT None  title_alias introtext FULLTEXT None  introtext fulltext FULLTEXT None  fulltext created_by_alias_2 FULLTEXT None  created_by_alias images FULLTEXT None  images urls FULLTEXT None  urls attribs FULLTEXT None  attribs metakey FULLTEXT None  metakey metadesc FULLTEXT None  metadesc metadata FULLTEXT None  metadata attribs_2 FULLTEXT None  attribs fulltext_2 FULLTEXT None  fulltext created_by_alias_3 FULLTEXT None  created_by_alias title_alias_4 FULLTEXT None  title_alias title_4 FULLTEXT None  title metadesc_2 FULLTEXT None  metadesc metakey_2 FULLTEXT None  metakey Create an index on  columns

Space usage:  Type Usage Data 65,924 Bytes Index 4,096 Bytes Total 70,020 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Rows 43 Row length ø 1,533 Row size  ø 1,628 Bytes Next Autoindex 44 Creation Oct 20, 2017 at 08:35 AM Last update Apr 16, 2024 at 11:46 AM Last check Mar 29, 2024 at 08:39 AM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `jos_content` ADD UNIQUE(`title_alias`)		id title alias title_alias introtext fulltext state sectionid mask catid created created_by created_by_alias modified modified_by checked_out checked_out_time publish_up publish_down images urls attribs version parentid ordering metakey metadesc access hits metadata
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