· 7 years ago · Oct 11, 2018, 06:18 AM
1
2CREATE TABLE IF NOT EXISTS `usermaster` (
3 `username` varchar(50) NOT NULL DEFAULT '',
4 `password` varchar(50) DEFAULT NULL,
5 `userid` varchar(50) DEFAULT NULL,
6 PRIMARY KEY (`username`)
7) ENGINE=MyISAM DEFAULT CHARSET=latin1;
8
9--
10-- Dumping data for table `usermaster`
11--
12
13INSERT INTO `usermaster` (`username`, `password`, `userid`) VALUES
14('Administrator', '123', 'admin'),
15('John', '122', 'johnee');