CREATE TABLE IF NOT EXISTS `pl_VideoSitemapInfo` (
`id` int(11) NOT NULL,
  `content_loc` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `videoType` enum('file', 'youtube') NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

ALTER TABLE `pl_VideoSitemapInfo`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `content_loc` (`content_loc`);

ALTER TABLE `pl_VideoSitemapInfo`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

-- -----------------------------
-- -----------------------------

ALTER TABLE `pl_User` CHANGE `video` `youtubeVideo` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `pl_User` ADD `video` VARCHAR(255) NULL DEFAULT NULL AFTER `photoV`;
ALTER TABLE `pl_User` ADD `videoThumbnail` VARCHAR(255) NULL DEFAULT NULL AFTER `youtubeVideo`;

