All pastes #498874 Raw Edit

Stuff

public text v1 · immutable
·published 2007-05-20 18:51 UTC
rendered paste body
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));