
CREATE TABLE file
    ( file_id       INTEGER PRIMARY KEY AUTOINCREMENT
    , file_sha1     BINARY(20)
    , file_name     TEXT UNIQUE
    , file_size     INTEGER NOT NULL
    , file_mime     TEXT NOT NULL
    , file_add_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
    );


CREATE TABLE file
    ( file_id       INTEGER PRIMARY KEY AUTOINCREMENT
    , file_sha1     BINARY(20)
    , file_name     TEXT NOT NULL UNIQUE
    , file_size     INTEGER NOT NULL
    , file_mime     TEXT NOT NULL
    , file_add_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
    );

Add NOT NULL constraint to file.file_name
mdb: Add NOT NULL constraint to file.file_name
