CREATE TABLE picture(
cod_picture int PRIMARY KEY,
cod_user int,
pic_name varchar(30) NOT NULL DEFAULT 'no name',
pic_location varchar(80) NOT NULL,
pic_thumb_location varchar(80) NOT NULL,
pic_date date NOT NULL,
pic_comment text NOT NULL,
pic_votes int NOT NULL DEFAULT '0',
CONSTRAINT fk_user FOREIGN KEY(cod_user) REFERENCES user(cod_user));