ALTER TABLE `#__youtubegallery` ADD COLUMN `orderby` varchar(50) NOT NULL;
ALTER TABLE `#__youtubegallery` CHANGE `openinnewwindow` `openinnewwindow` smallint(6) NOT NULL;
ALTER TABLE `#__youtubegallery` ADD COLUMN `customnavlayout` text NOT NULL;
ALTER TABLE `#__youtubegallery` CHANGE `updateperiod` `updateperiod` float NOT NULL default 7;

ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `publisheddate` datetime NOT NULL;
ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `duration` int(11) NOT NULL default 0;
ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `rating_average` float NOT NULL default 0;
ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `rating_max` smallint(6) NOT NULL default 0;
ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `rating_min` smallint(6) NOT NULL default 0;
ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `rating_numRaters` int(11) NOT NULL default 0;
ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `statistics_favoriteCount` smallint(6) NOT NULL default 0;
ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `statistics_viewCount` smallint(6) NOT NULL default 0;
ALTER TABLE `#__youtubegallery_videos` ADD COLUMN `keywords` text NOT NULL;
