CREATE TABLE `accounts` (
`user_id` int(11) NOT NULL auto_increment,
`firstname` varchar(20) NOT NULL,
`lastname` varchar(20) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `accounts`
--
INSERT INTO `accounts` (`user_id`, `firstname`, `lastname`) VALUES
(1, 'John', 'Smith'),
(2, 'Michel', 'Soli'),
(3, 'Tony', 'Tomas'),
(4, 'Steve', 'Roa'),
(5, 'Ana Maria', 'Song'),
(6, 'Peter', 'Johns'),
(7, 'Michel', 'Jacky'),
(8, 'Edward', 'Richy'),
(9, 'Susan', 'Chaker'),
(10, 'Dian', 'Peter');
|