Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -rcca0aeef737c2612fef34d566ad367ce6dba0643 -r6dfed16eaf2c7908cfa35e7209ddf9248ea5ef83 --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision cca0aeef737c2612fef34d566ad367ce6dba0643) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 6dfed16eaf2c7908cfa35e7209ddf9248ea5ef83) @@ -36,7 +36,7 @@ role_id INT(6) NOT NULL DEFAULT 0 , name VARCHAR(64) NOT NULL , description TEXT - , create_date BIGINT(20) + , create_date DATETIME , PRIMARY KEY (role_id) )TYPE=InnoDB; CREATE INDEX gname ON lams_role (name ASC);