Server: mysql.puroparty.com

Database: puroparty

Table: photopost_photos

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	id	int(10)			No		auto_increment
	user	varchar(50)	latin1_swedish_ci		No
	userid	int(8)			No	0
	cat	int(11)			No	0
	storeid	int(12)			No	0
	storecat	int(12)			No	0
	date	int(15)			No	0
	title	varchar(75)	latin1_swedish_ci		Yes
	description	text	latin1_swedish_ci		Yes	NULL
	keywords	varchar(150)	latin1_swedish_ci		Yes	NULL
	bigimage	varchar(100)	latin1_swedish_ci		No
	width	smallint(6)			Yes	NULL
	height	smallint(4)			Yes	NULL
	filesize	int(10)			Yes	0
	views	int(10)			No	0
	medwidth	int(12)			Yes	0
	medheight	smallint(6)			Yes	0
	medsize	mediumint(9)			Yes	0
	approved	tinyint(2)			No	0
	lastpost	int(15)			No	0
	rating	float(12,2)			No	0.00
	watermarked	varchar(5)	latin1_swedish_ci		No	no
	allowprint	varchar(5)	latin1_swedish_ci		No	yes
	extra1	varchar(255)	latin1_swedish_ci		Yes	NULL
	extra2	varchar(255)	latin1_swedish_ci		Yes	NULL
	extra3	varchar(255)	latin1_swedish_ci		Yes	NULL
	extra4	varchar(255)	latin1_swedish_ci		Yes	NULL
	extra5	varchar(255)	latin1_swedish_ci		Yes	NULL
	extra6	varchar(255)	latin1_swedish_ci		Yes	NULL
	disporder	int(5)			No	99999
	ipaddress	varchar(32)	latin1_swedish_ci		Yes	0
	numcom	int(8)			No	0
	lastposter	varchar(255)	latin1_swedish_ci		Yes	NULL
	lastpid	int(8)			No	0
	allowrate	int(1)			No	1
	allowcoms	int(1)			No	1
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After id user userid cat storeid storecat date title description keywords bigimage width height filesize views medwidth medheight medsize approved lastpost rating watermarked allowprint extra1 extra2 extra3 extra4 extra5 extra6 disporder ipaddress numcom lastposter lastpid allowrate allowcoms

---

Structure Browse SQL Search Insert Export Operations Empty Drop

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 5  id id_2 UNIQUE 5  id date_2 UNIQUE 5  date bigimage_3 UNIQUE 5  bigimage lastpost_2 UNIQUE 5  lastpost title_2 UNIQUE None  title filesize_2 UNIQUE None  filesize lastposter_2 UNIQUE None  lastposter userid INDEX None  userid cat INDEX None  cat bigimage INDEX None  bigimage cat id INDEX None  id user INDEX None  user userid_2 INDEX None  userid cat_2 INDEX None  cat storeid INDEX None  storeid storecat INDEX None  storecat date INDEX None  date title INDEX None  title keywords INDEX None  keywords bigimage_2 INDEX None  bigimage width INDEX None  width height INDEX None  height filesize INDEX None  filesize views INDEX None  views medwidth INDEX None  medwidth medheight INDEX None  medheight medsize INDEX None  medsize approved INDEX None  approved lastpost INDEX None  lastpost rating INDEX None  rating watermarked INDEX None  watermarked allowprint INDEX None  allowprint extra1 INDEX None  extra1 extra2 INDEX None  extra2 extra3 INDEX None  extra3 extra4 INDEX None  extra4 extra5 INDEX None  extra5 extra6 INDEX None  extra6 disporder INDEX None  disporder ipaddress INDEX None  ipaddress numcom INDEX None  numcom lastposter INDEX None  lastposter lastpid INDEX None  lastpid allowrate INDEX None  allowrate allowcoms INDEX None  allowcoms lastposter_4 INDEX None  lastposter lastpost_3 INDEX None  lastpost approved_2 INDEX None  approved user_2 FULLTEXT None  user title_3 FULLTEXT None  title description FULLTEXT None  description keywords_2 FULLTEXT None  keywords bigimage_4 FULLTEXT None  bigimage watermarked_2 FULLTEXT None  watermarked allowprint_2 FULLTEXT None  allowprint extra1_2 FULLTEXT None  extra1 extra2_2 FULLTEXT None  extra2 extra3_2 FULLTEXT None  extra3 extra4_2 FULLTEXT None  extra4 extra5_2 FULLTEXT None  extra5 extra6_2 FULLTEXT None  extra6 ipaddress_2 FULLTEXT None  ipaddress lastposter_3 FULLTEXT None  lastposter Create an index on  columns

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

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 5 Row length ø 125 Row size  ø 945 Bytes Next Autoindex 6 Creation Oct 16, 2017 at 10:00 PM Last update Oct 16, 2017 at 10:00 PM Last check Mar 29, 2024 at 06:59 AM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `photopost_photos` ADD UNIQUE(`userid`)		id user userid cat storeid storecat date title description keywords bigimage width height filesize views medwidth medheight medsize approved lastpost rating watermarked allowprint extra1 extra2 extra3 extra4 extra5 extra6 disporder ipaddress numcom lastposter lastpid allowrate allowcoms
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