drop Table Truffle;

create table Truffle (
TruffleID number,
CoatingFlavor char(10) NOT NULL,
FillingFlavor char(10) NULL,
CONSTRAINT Truffle_PK PRIMARY KEY(TruffleID));


-- Insert into Truffle (CoatingFlavor, FillingFlavor) values ('choc', 'choc');

Insert into Truffle values (
1, 'choc', 'mint');

Insert into Truffle (TruffleID, CoatingFlavor) values (
2, 'choc');
