CREATE TABLE `people` (
  `userid` int(10) unsigned NOT NULL auto_increment,
  `LastName` varchar(30) character set ascii collate ascii_bin NOT NULL default '',
  `FirstName` varchar(30) character set ascii collate ascii_bin NOT NULL default '',
  `DateOfBirth` date NOT NULL default '0000-00-00',
  `Username` varchar(20) character set ascii collate ascii_bin NOT NULL default '',
  `Password` varchar(10) character set ascii collate ascii_bin NOT NULL default '',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;



INSERT INTO `people` VALUES (1, 'Smith', 'Joe', '1929-10-11', 'joey', 'blah');
INSERT INTO `people` VALUES (2, 'Jones', 'Sally', '1955-07-13', 'joness', 'elvis');
INSERT INTO `people` VALUES (3, 'cos', 'tan', '1985-06-22', 'sin', 'arctan');
INSERT INTO `people` VALUES (4, 'alpha', 'beta', '2001-02-02', 'gamma', 'delta');
INSERT INTO `people` VALUES (5, 'Schmo', 'Joe', '2002-02-02', 'zippy', 'oslo');
INSERT INTO `people` VALUES (6, 'Winkle', 'Peri', '1975-08-15', 'peri', 'peri');


CREATE TABLE `products` (
  `productid` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(30) NOT NULL default '',
  `Description` text NOT NULL,
  `Price` float NOT NULL default '0',
  PRIMARY KEY  (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;


INSERT INTO `products` VALUES (1, 'Snickers', 'delicious, nutty candy bar. .00234oz size.', 1.29);
INSERT INTO `products` VALUES (2, 'Candy Corn', 'Sugar that almost looks like corn. Popular with the kids!', 0.79);
INSERT INTO `products` VALUES (3, 'Wax Lips:', 'What can be better than the delicious taste of wax and the hilarious sight of oversized lips...', 2.49);
INSERT INTO `products` VALUES (4, 'Bubble Gum: Kids love bubble g', ' Kids love bubble gum.', 0.25);