field properties on create table

[Fission]

I have a user interface to create tables, but when I pull info out of the database to display on the web I don\'t want all the fields in the table displayed. I need someway to pull \"visible\" fields out of a table. So far my program builds this query:

 

CREATE TABLE testtest (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,feild1 varchar (13),feild2 date,field3 float,field4 int,field5 text,field6 char (14),fulltext(feild1, field5));

 

Is there some way to create an index of fields at the end of the query like:

visible(field1, field2, field4)

 

if so, what is the proper syntax, and if not then is there another, better way?