SQLite

field with the current unix timestamp by default

    "unix_timestamp" INTEGER NOT NULL DEFAULT(CAST(STRFTIME('%s', 'now') AS INT))

autogenerated UUID

    CAST(uuid_generate_v1mc() AS BLOB)
    CAST(uuid_generate_v4() AS BLOB)