HT9j9Dag

1
2
3CREATE TABLE IF NOT EXISTS `usermaster` (
4  `RecNo` int(11) NOT NULL,
5  `username` varchar(50) NOT NULL DEFAULT '',
6  `password` varchar(50) DEFAULT NULL,
7  `userid` varchar(50) DEFAULT NULL,
8  PRIMARY KEY (`username`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1;
10
11--
12-- Dumping data for table `usermaster`
13--
14
15INSERT INTO `usermaster` (`RecNo`, `username`, `password`, `userid`) VALUES
16(1, 'admin', 'Administrator', 'admin'),
17(2, 'user', 'System User', '123'),
18(3, 'mike', '123', 'Mikee'),
19(4, 'John', '122', 'johnee'),
20(5, 'Tt', 't111', '123'),
21(6, 'Tt1', 't111', '123'),
22(7, 'Krishnan', '123', 'KrishnanL'),
23(8, 'Johnny', '1212', 'JJJ');