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)