uM7hjn9w

1CREATE TABLE IF NOT EXISTS video
2(
3	videoID		INT				NOT NULL,
4	stockitemID	INT				NOT NULL,
5	video		VARCHAR(255)	NULL,
6 FOREIGN KEY (stockitemID) REFERENCES stockitems(StockItemID)
7)
8ENGINE=InnoDB
9DEFAULT CHARSET=latin1;
10
11ALTER TABLE video
12  ADD PRIMARY KEY (videoID);
13  
14ALTER TABLE video
15  MODIFY videoID INT NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
16COMMIT;
17
18INSERT INTO video (stockitemID, video) VALUES (1, 'resources/video/1/usb1.mp4');
19INSERT INTO video (stockitemID, video) VALUES (2, 'resources/video/2/usb1.mp4');
20INSERT INTO video (stockitemID, video) VALUES (3, 'resources/video/3/usb1.mp4');
21INSERT INTO video (stockitemID, video) VALUES (25, 'resources/video/25/mug1.mp4');
22INSERT INTO video (stockitemID, video) VALUES (26, 'resources/video/26/mug1.mp4');
23INSERT INTO video (stockitemID, video) VALUES (27, 'resources/video/27/mug1.mp4');