create database hdd;
use hdd;

CREATE TABLE `festplatten` (
`festplattenNr` int(8) NOT NULL AUTO_INCREMENT,
  `hersteller` varchar(50) NOT NULL,
  `typ` varchar(50) NOT NULL,
  `gb` int(8) NOT NULL,
  `preis` double(6,2) NOT NULL,
  `artnummer` varchar(50) NOT NULL,
  `prod` date NOT NULL,
   PRIMARY KEY (festplattenNr)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



INSERT INTO `festplatten` (`hersteller`, `typ`, `gb`, `preis`, `artnummer`, `prod`) VALUES
('Quanttum', 'Fireball CX', 500, 58.00, 'HDA-208', '2024-03-14'),
('IBM', 'DJNA 372200', 250, 49.00, 'HD-140', '2024-03-14'),
('Seagate', '310232A', 800, 49.99, 'HDA-144', '2024-03-04'),
('Quanttum', 'Fireball Plus', 2000, 65.00, 'HDA-163', '2024-03-10'),
('Fujitsu', 'MPE 3136', 350, 38.00, 'HDA-171', '2024-03-02'),
('Quanttum', '310232A', 1000, 45.00, 'HDA-208', '2024-03-05'),
('WD', 'WD10EZEX', 1000, 37.66, '', '2024-12-03');


