CREATE TABLE img (
    codice serial,
    img1 character varying,
    img1w character varying DEFAULT 640,
    img1h character varying DEFAULT 480,
    img1mime character varying,
    img2 character varying,
    img2w character varying DEFAULT 400,
    img2h character varying DEFAULT 300,
    img2mime character varying,
    img3 character varying,
    img3w character varying DEFAULT 160,
    img3h character varying DEFAULT 120,
    img3mime character varying,
    img4 character varying,
    img4w character varying DEFAULT 80,
    img4h character varying DEFAULT 60,
    img4mime character varying,
    nomefile character varying,
    titolo character varying,
    descrizione character varying,
    codart character varying,
    done boolean DEFAULT false NOT NULL,
    numero_immagine integer DEFAULT 1 NOT NULL,
    utente integer DEFAULT 0 NOT NULL,
    img1nomefile character varying,
    img2nomefile character varying,
    img3nomefile character varying,
    img4nomefile character varying,
    img1size integer,
    img2size integer,
    img3size integer,
    img4size integer
);

CREATE INDEX foto_codice_index ON img USING btree (codice);


