Server: mysql.puroparty.com

Database: puroparty

Table: bos_ads

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	ad_id	int(10)			No		auto_increment
	ad_status	tinyint(1)			No	0
	ad_user_id	int(5)			No	0
	ad_category	int(5)			No	0
	ad_date_begin	varchar(10)	latin1_swedish_ci		No
	ad_date_end	varchar(10)	latin1_swedish_ci		No
	ad_type	tinyint(3)			No	0
	ad_title	varchar(255)	latin1_swedish_ci		No
	ad_description	text	latin1_swedish_ci		No
	ad_image1	varchar(255)	latin1_swedish_ci		No
	ad_image2	varchar(255)	latin1_swedish_ci		No
	ad_image3	varchar(255)	latin1_swedish_ci		No
	ad_image4	varchar(255)	latin1_swedish_ci		No
	ad_image5	varchar(255)	latin1_swedish_ci		No
	ad_options	int(10)			No	0
	ad_optional_1	varchar(255)	latin1_swedish_ci		No
	ad_optional_2	varchar(255)	latin1_swedish_ci		No
	ad_optional_3	varchar(255)	latin1_swedish_ci		No
	ad_optional_4	varchar(255)	latin1_swedish_ci		No
	ad_optional_5	varchar(255)	latin1_swedish_ci		No
	ad_type_optional1	varchar(255)	latin1_swedish_ci		No
	ad_type_optional2	varchar(255)	latin1_swedish_ci		No
	ad_type_optional3	varchar(255)	latin1_swedish_ci		No
	ad_type_optional4	varchar(255)	latin1_swedish_ci		No
	ad_type_optional5	varchar(255)	latin1_swedish_ci		No
	ad_type_optional6	varchar(255)	latin1_swedish_ci		No
	ad_type_optional7	varchar(255)	latin1_swedish_ci		No
	ad_type_optional8	varchar(255)	latin1_swedish_ci		No
	ad_type_optional9	varchar(255)	latin1_swedish_ci		No
	ad_type_optional10	varchar(255)	latin1_swedish_ci		No
	ad_price	varchar(255)	latin1_swedish_ci		No	0.00
	ad_condition	tinyint(4)			No	0
	ad_views	int(4)			No	0
	ad_address	varchar(255)	latin1_swedish_ci		No
	ad_city	varchar(255)	latin1_swedish_ci		No
	ad_state	varchar(255)	latin1_swedish_ci		No
	ad_postal	varchar(255)	latin1_swedish_ci		No
	ad_country	varchar(255)	latin1_swedish_ci		No
	ad_city_code	int(11)			No	0
	ad_state_code	int(4)			No	0
	ad_country_code	int(3)			No	0
	ad_fee	float(6,2)			No	0.00
	ad_anon_name	varchar(255)	latin1_swedish_ci		No
	ad_anon_email	varchar(255)	latin1_swedish_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 ad_id ad_status ad_user_id ad_category ad_date_begin ad_date_end ad_type ad_title ad_description ad_image1 ad_image2 ad_image3 ad_image4 ad_image5 ad_options ad_optional_1 ad_optional_2 ad_optional_3 ad_optional_4 ad_optional_5 ad_type_optional1 ad_type_optional2 ad_type_optional3 ad_type_optional4 ad_type_optional5 ad_type_optional6 ad_type_optional7 ad_type_optional8 ad_type_optional9 ad_type_optional10 ad_price ad_condition ad_views ad_address ad_city ad_state ad_postal ad_country ad_city_code ad_state_code ad_country_code ad_fee ad_anon_name ad_anon_email

---

Structure Browse SQL Search Insert Export Operations Empty Drop

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  ad_id ad_id_2 UNIQUE 0  ad_id ad_status_2 UNIQUE 0  ad_status ad_user_id_2 UNIQUE 0  ad_user_id ad_category_2 UNIQUE 0  ad_category ad_date_begin_2 UNIQUE 0  ad_date_begin ad_date_end_2 UNIQUE 0  ad_date_end ad_type_2 UNIQUE 0  ad_type ad_title_2 UNIQUE 0  ad_title ad_image1_2 UNIQUE 0  ad_image1 ad_image2_2 UNIQUE 0  ad_image2 ad_image3_2 UNIQUE 0  ad_image3 ad_image4_2 UNIQUE 0  ad_image4 ad_image5_2 UNIQUE 0  ad_image5 ad_options_2 UNIQUE 0  ad_options ad_optional_1_2 UNIQUE 0  ad_optional_1 ad_optional_2_2 UNIQUE 0  ad_optional_2 ad_optional_3_2 UNIQUE 0  ad_optional_3 ad_optional_4_2 UNIQUE 0  ad_optional_4 ad_optional_5_2 UNIQUE 0  ad_optional_5 ad_type_optional1_2 UNIQUE 0  ad_type_optional1 ad_type_optional2_2 UNIQUE 0  ad_type_optional2 ad_type_optional3_2 UNIQUE 0  ad_type_optional3 ad_type_optional4_2 UNIQUE 0  ad_type_optional4 ad_id INDEX None  ad_id ad_status INDEX None  ad_status ad_user_id INDEX None  ad_user_id ad_category INDEX None  ad_category ad_date_begin INDEX None  ad_date_begin ad_date_end INDEX None  ad_date_end ad_type INDEX None  ad_type ad_title INDEX None  ad_title ad_image1 INDEX None  ad_image1 ad_image2 INDEX None  ad_image2 ad_image3 INDEX None  ad_image3 ad_image4 INDEX None  ad_image4 ad_image5 INDEX None  ad_image5 ad_options INDEX None  ad_options ad_optional_1 INDEX None  ad_optional_1 ad_optional_2 INDEX None  ad_optional_2 ad_optional_3 INDEX None  ad_optional_3 ad_optional_4 INDEX None  ad_optional_4 ad_optional_5 INDEX None  ad_optional_5 ad_type_optional1 INDEX None  ad_type_optional1 ad_type_optional2 INDEX None  ad_type_optional2 ad_type_optional3 INDEX None  ad_type_optional3 ad_type_optional4 INDEX None  ad_type_optional4 ad_date_begin_3 FULLTEXT None  ad_date_begin ad_date_end_3 FULLTEXT None  ad_date_end ad_title_3 FULLTEXT None  ad_title ad_description FULLTEXT None  ad_description ad_image1_3 FULLTEXT None  ad_image1 ad_image2_3 FULLTEXT None  ad_image2 ad_image3_3 FULLTEXT None  ad_image3 ad_image4_3 FULLTEXT None  ad_image4 ad_image5_3 FULLTEXT None  ad_image5 ad_optional_1_3 FULLTEXT None  ad_optional_1 ad_optional_2_3 FULLTEXT None  ad_optional_2 ad_optional_3_3 FULLTEXT None  ad_optional_3 ad_optional_4_3 FULLTEXT None  ad_optional_4 ad_optional_5_3 FULLTEXT None  ad_optional_5 ad_type_optional1_3 FULLTEXT None  ad_type_optional1 ad_type_optional2_3 FULLTEXT None  ad_type_optional2 ad_type_optional3_3 FULLTEXT None  ad_type_optional3 Create an index on  columns

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

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 0 Next Autoindex 264 Creation Oct 07, 2017 at 09:13 PM Last update Apr 03, 2018 at 04:17 AM Last check Mar 25, 2024 at 10:02 PM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `bos_ads` ADD INDEX(`ad_postal`)		ad_id ad_status ad_user_id ad_category ad_date_begin ad_date_end ad_type ad_title ad_description ad_image1 ad_image2 ad_image3 ad_image4 ad_image5 ad_options ad_optional_1 ad_optional_2 ad_optional_3 ad_optional_4 ad_optional_5 ad_type_optional1 ad_type_optional2 ad_type_optional3 ad_type_optional4 ad_type_optional5 ad_type_optional6 ad_type_optional7 ad_type_optional8 ad_type_optional9 ad_type_optional10 ad_price ad_condition ad_views ad_address ad_city ad_state ad_postal ad_country ad_city_code ad_state_code ad_country_code ad_fee ad_anon_name ad_anon_email
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