CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL auto_increment,
`username` varchar(20) default NULL,
`password` varchar(20) default NULL,
`user_type` enum('regular','admin') NOT NULL default 'regular',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`user_id`, `username`, `password`, `user_type`) VALUES
(10, 'dummy1', 'dummy001', 'regular'),
(11, 'dummy2', 'dummy002', 'regular'),
(12, 'dummy3', 'dummy003', 'regular'),
(20, 'tadd', 'tadd', 'admin'),
(30, 'alfonso', 'jiggerofgin', 'regular'),
(35, 'juan', 'drymartini', 'regular'),
(40, 'scott', 'scotchandsoda', 'admin'),
(50, 'admin-il', 'shalom', 'regular'),
(60, 'avi', 'avi', 'regular'),
(70, 'akiva', 'akiva', 'regular');
|