Y4FwVVVn

1CREATE TABLE IF NOT EXISTS `Storage` (
2`Id` int(1) NOT NULL auto_increment,
3`Name` varchar(40) NOT NULL, 
4`HardDrive` varchar(40) NOT NULL,
5`Phone`  varchar(7) NOT NULL,
6`Pickedup` varchar(3) NOT NULL,
7PRIMARY KEY (`Id`)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
9
10INSERT INTO `Storage` (`Name`, `HardDrive`, `Phone`, `Pickedup`) VALUES
11    ('John',' IDE',  '3456789', 'NO'),
12    ('Mason', 'SAS', '5551234', 'YES'),
13    ('Jake', 'SCSI', '6570123', 'NO'),
14    ('Matt', 'SCSI', '1239090', 'NO'),
15    ('Helen', 'SATA','5471423', 'YES');