Perhaps something like this?
CREATE TABLE IMAGE (
ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 ,
INCREMENT BY +1 , CACHE 20 ) ,
SUBMIT_DATE DATE NOT NULL WITH DEFAULT CURRENT DATE ,
SUBMIT_TIME TIME NOT NULL WITH DEFAULT CURRENT TIME ,
EXPIRE_DATE DATE ,
SUBMITTER VARCHAR(50) NOT NULL WITH DEFAULT USER ,
DESCRIPTION VARCHAR(250) ,
FILENAME VARCHAR(50) NOT NULL ,
MIME_TYPE_ID INTEGER NOT NULL ,
IMAGE BLOB(10485760) LOGGED COMPACT NOT NULL
)
HTH
aj
rAinDeEr wrote:
Hi,
Can any one show me a sample create table structure for storing .BMP's
and .GIF images. togther with its description.
Thanks in advance,
rAinDeEr