Server:
mysql.puroparty.com
Database:
puroparty
Table:
photopost_photos
Modify an index
Index name :
("PRIMARY"
must
be the name of and
only of
a primary key!)
Index type :
INDEX
UNIQUE
FULLTEXT
Fields :
Field
Size
-- Ignore --
id [int(10)]
user [varchar(50)]
userid [int(8)]
cat [int(11)]
storeid [int(12)]
storecat [int(12)]
date [int(15)]
title [varchar(75)]
description [text]
keywords [varchar(150)]
bigimage [varchar(100)]
width [smallint(6)]
height [smallint(4)]
filesize [int(10)]
views [int(10)]
medwidth [int(12)]
medheight [smallint(6)]
medsize [mediumint(9)]
approved [tinyint(2)]
lastpost [int(15)]
rating [float(12,2)]
watermarked [varchar(5)]
allowprint [varchar(5)]
extra1 [varchar(255)]
extra2 [varchar(255)]
extra3 [varchar(255)]
extra4 [varchar(255)]
extra5 [varchar(255)]
extra6 [varchar(255)]
disporder [int(5)]
ipaddress [varchar(32)]
numcom [int(8)]
lastposter [varchar(255)]
lastpid [int(8)]
allowrate [int(1)]
allowcoms [int(1)]
Add to index
column(s)