CREATE TABLE `viewhistory` (
`viewid` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`video` varchar(255) NOT NULL,
`viewtime` datetime NOT NULL,
PRIMARY KEY (`viewid`)
)
INSERT INTO viewhistory VALUES
(9,3,'this',NOW()),
(10,3,'is',NOW()),
(11,3,'a',NOW()),
(12,3,'movie',NOW())