MYSQL建表语句

CREATE TABLE test(
    id int(10) NOT NULL auto_increment,
    uid varchar(10) not null default '0',
    regdate date not null,
    remark text null,
    PRIMARY KEY (id)
)