1 create table userinfo 2 ( 3 id varchar2(36) primary key, 4 username varchar2(50) not null, 5 password varchar2(50) not null, 6 auth_limit varchar2(10) not null, 7 register_time varchar2(40), 8 create_time varchar2(40), 9 remarks varchar2(1024) 10 );