Server:
mysql.puroparty.com
Database:
puroparty
Table:
jos_contact_details
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(11)]
name [varchar(255)]
alias [varchar(255)]
con_position [varchar(255)]
address [text]
suburb [varchar(100)]
state [varchar(100)]
country [varchar(100)]
postcode [varchar(100)]
telephone [varchar(255)]
fax [varchar(255)]
misc [mediumtext]
image [varchar(255)]
imagepos [varchar(20)]
email_to [varchar(255)]
default_con [tinyint(1) unsigned]
published [tinyint(1) unsigned]
checked_out [int(11) unsigned]
checked_out_time [datetime]
ordering [int(11)]
params [text]
user_id [int(11)]
catid [int(11)]
access [tinyint(3) unsigned]
mobile [varchar(255)]
webpage [varchar(255)]
Add to index
column(s)