CREATE TABLE IF NOT EXISTS `clients` (
  `firstname` text NOT NULL,
  `lastname` text NOT NULL,
  `userid` text NOT NULL,
  `password` text NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`firstname`, `lastname`, `userid`, `password`, `id`) VALUES
('Joe', 'Mama', 'Shopink', 'bling', 1),
('William', 'Lee', 'wlee', 'tulip', 2),
('Kevin', 'Hinds', 'khinds', 'daisy', 3),
('ret', 'ytrytr', 'trytr', '', 4),
('xxx', '', '', '', 5);