pFTMmi1f

1CREATE TABLE IF NOT EXISTS `usermaster` (
2  `userid` varchar(30) NOT NULL,
3  `username` varchar(30) NOT NULL,
4  `userlevel` int(11) NOT NULL,
5  `status` varchar(20) NOT NULL,
6  `password` varchar(20) NOT NULL
7) ENGINE=MyISAM DEFAULT CHARSET=latin1;
8
9--
10-- Dumping data for table `usermaster`
11--
12
13INSERT INTO `usermaster` (`userid`, `username`, `userlevel`, `status`, `password`) VALUES
14('admin', 'Administrator', 1, 'Active', 'admin'),
15('user', 'System User', 2, 'Active', '123'),
16('mike', 'Mike Mamba', 2, 'Active', '321'),
17('joeee', 'John Joee', 2, 'Active', '32134479'),
18('romo', 'Romo Boy', 1, 'Active', '98085hj'),
19('idec', 'IDEC User', 2, 'Active', '4567890');