123

DROP TABLE IF EXISTS records;
CREATE TABLE records (
id int(11) NOT NULL AUTO_INCREMENT,
openid varchar(255) COLLATE utf8_unicode_ci NOT NULL,
code varchar(255) COLLATE utf8_unicode_ci NOT NULL,
examname varchar(255) COLLATE utf8_unicode_ci NOT NULL,
createTime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;