DEFAULT NOW() AND DEFAULT USER ...

[Rafael Montoya]

Hi, i'm migrating from oracle to mysql, this is the code to generate a table in oracle:

CREATE TABLE RGMD_GESTION (
V_COD_GESTION VARCHAR(15) NOT NULL,
V_COD_USER VARCHAR(15) NULL,
D_FEC_CRE DATE DEFAULT sysdate() NULL,
V_USU_CRE VARCHAR(30) DEFAULT USER NULL
);

but i'm not sure if the third attribute (the date one) is equivalent with

D_FEC_CRE TIMESTAMP NULL DEFAULT now(),

and I have no idea how to migrate the last attribute. I couldn't find any equivalence in the manual for DEFAULT USER.

I will thank any advice. bye.

Rafael.