|
Drop table Videos;
CREATE TABLE Videos (
VideoID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
VideoName VARCHAR(60) NOT NULL,
Status ENUM('In', 'Out') NOT NULL
)
ENGINE=INNODB;
INSERT INTO Videos (VideoName, Status) VALUES ('Out', 'In'),
('The', 'In'),
('Rocky', 'Out'),
('A Room with a View', 'In'),
('Mash', 'Out');
|