DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo`
(
    `userId`    int(11) NOT NULL auto_increment,
    `loginname` varchar(20) default NULL,
    `password`  varchar(10) default NULL,
    PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `userinfo` (`userId`, `loginname`, `password`)
VALUES (1, 'admin', 'admin');