Following up on the SQL error with the Default timestamp value, it needs to be corrected to:
DROP TABLE IF EXISTS visual_verify_code;
CREATE TABLE visual_verify_code (
oscsid varchar(32) NOT NULL,
code varchar(6) NOT NULL,
dt TIMESTAMP(12) NOT NULL DEFAULT NOW(),
PRIMARY KEY (oscsid)
);
More...




LinkBack URL
About LinkBacks









Bookmarks