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