CREATE TABLE IF NOT EXISTS `lab2` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `category` varchar(10) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `username` varchar(50) NOT NULL DEFAULT '',
  `regnum` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(50) NOT NULL DEFAULT '',
  KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `lab2`
--

INSERT INTO `lab2` (`id`, `category`, `name`, `username`, `regnum`, `password`) VALUES
('1', 'guest', 'Chung Kristina H', '32422', '1', '2c2c5fd01b61e3e0e687573af8f7e1fa'),
('2', 'guest', 'Chen Paige H', '19731', '2', 'd5a92a68f9af953b26eafb935a054ce7'),
('3', 'admin', 'Melton Sherri E', '7040', '3', '1def1713ebf17722cbe300cfc1c88558'),
('4', 'guest', 'Hill Gretchen I', '27117', '4', '9aea3c940f8665926c97b3d3c64ace44'),
('5', 'user', 'Puckett Karen U.', '14426', '5', 'fc5f86251458722c799d1830fa0c2c1f'),
('6', 'user', 'Song Patrick O.', '1735', '6', 'c4492cbe90fbdbf88a5aec486aa81ed5'),
('7', 'user', 'Hamilton Elsie A.', '21812', '7', '82aafca3e03771835c2e1acb19fde2d4'),
('8', 'user', 'Bender Hazel E.', '9121', '8', '94fee470b43270a912c27d56c27b3211'),
('9', 'moderator', 'Wagner Malcolm A.', '29198', '9', 'df584d514eb49beffdd8b37311204fc9'),
('10', 'moderator', 'McLaughlin Dolores C.', '16507', '10', '800502ddc965d56e79f6545ee7c75f50'),
('11', 'user', 'McNamara Francis C.', '3816', '11', 'c911241d00294e8bb714eee2e83fa475'),
('12', 'moderator', 'Raynor Sandy A.', '23893', '12', '1f3ecb87f576752202975d3e0b868bdc'),
('13', 'moderator', 'Moon  Marion O.', '11202', '13', 'fe998b49c41c4208c968bce204fa1cbb');