I am looking to create a database that holds the location of images on my 
server.  I was wondering if anyone could help me understand if I am doing it 
correctly, and if I either need to add, change or remove something from the 
current table code.

img_id    INT    NOT NULL auto_increment PRIMARY KEY,
user_id   INT    NOT NULL,
location  VARCHAR(255) NOT NULL,
imgtype  VARCHAR(20) NOT NULL,
img_tag  VARCHAR(50) NOT NULL,
img_rate VARCHAR(20) NOT NULL,
img_comments    VARCHAR(50) NOT NULL,
KEY (img_id);

Thanks for any help.

nick

Reply via email to