· 9 years ago · Nov 18, 2016, 01:32 AM
1
2CREATE TABLE IF NOT EXISTS `usermaster` (
3 `userid` varchar(50) NOT NULL,
4 `username` varchar(50) NOT NULL,
5 `password` varchar(30) NOT NULL,
6 `userlevel` int(11) NOT NULL,
7 `status` varchar(10) NOT NULL
8) ENGINE=MyISAM DEFAULT CHARSET=latin1;
9
10--
11-- Dumping data for table `usermaster`
12--
13
14INSERT INTO `usermaster` (`userid`, `username`, `password`, `userlevel`, `status`) VALUES
15('admin', 'Administrator', 'admin', 1, 'Active'),
16('vsk', 'VIGSHAKRI', '15', 1, 'Active'),
17('Orion', 'Belt Dee', '555', 2, 'InActive'),
18('krishnan', 'Krishnan', '5551', 1, 'Active'),
19('mike', 'Mike Mamba', '123', 2, 'Active');