CREATE TABLE IF NOT EXISTS `user` ( `userid` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(30) NOT NULL, `password` varchar(30) NOT NULL, PRIMARY KEY (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 
/*!40000 ALTER TABLE `user` DISABLE KEYS */; 
INSERT INTO `user` (`userid`, `username`, `password`) VALUES (1, 'admin', '123456'), (2, 'sales', '123456');