use museum;

create table admin
(
    id int(3) auto_increment not null primary key,  
    user char(20) not null, 
    pwd char(32) not null, 
    level char(1) not null,
    p_insert char(1) not null,
    p_delete char(1) not null,
    p_modify char(1) not null
);
insert into admin values('','sqian','1fc32ec8c8ae41fa30031e8292f28a23','3','1','1','1');

create table ethnobot
( 
    id int(3) auto_increment not null primary key, 
    cat int(3),
    subcat int(3),
    name varchar(50) not null, 
    url varchar(100) not null,
    description text
);

