austintino

INSERT INTO `navigationLevels` (`title`, `subtitle`, `metaTitle`, `defaultMetaDescription`, `slug`, `urlPath`, `mobilePath`, `navigationSetId`, `parentNavigationLevelId`, `externalUrl`, `template`, `forArticles`, `forVideos`, `forPolls`, `forStreams`, `forCollections`, `defaultSubpageType`, `orderBy`, `active`, `public`, `createdAt`, `modifiedAt`, `creatorUserId`, `modifierUserId`, `streamId`, `sitesId`, `internalOnly`)
VALUES
    ('TV Guide', NULL, 'STV Player TV Guide', 'STV Player TV Guide', 'tvguide', 'tvguide', NULL, 119, 0, NULL, 'playerv3-default', 0, 0, 0, 0, 0, X'766964656F73', 1, 1, 1, NULL, '2015-06-02 13:18:55', NULL, NULL, NULL, NULL, 0);
    

/* Remove TV Guide Nav Level */
/* 16:43:53 Dev */ 
DELETE FROM `navigationLevels` WHERE `id` IN ('3126');

austintino

/* Grant permissions for truncate once per hour. */
GRANT DROP ON stv_repoz.playerSchedule TO 'readwrite'@'database-write.prod.stv.tv' WITH MAX_QUERIES_PER_HOUR 1;