INSERT INTO `smd__default_role`(`defaultRoleID`,`name`,`description`,`status`,`admin`) VALUES
( 'admin', 'Admin', 'Admin default role.', 'active', 'yes' ),
( 'analyst', 'Analyst', 'Analyst default role.', 'active', 'no' ),
( 'approver', 'Approver', 'Approver default role.', 'active', 'yes' ),
( 'client', 'Client', 'Client default role.', 'active', 'no' ),
( 'creator', 'Creator', 'Creator default role.', 'active', 'no' ),
( 'editor', 'Editor', 'Editor default role.', 'active', 'no' ),
( 'superAdmin', 'Super Admin', 'Super admin default role.', 'active', 'yes' );

INSERT INTO `smd__default_role_has_resources`(`defaultRoleID`,`resourceID`) VALUES
( 'admin', 'analytics.analytics.activitiesByOrganizations' ),
( 'admin', 'analytics.analytics.activitiesByTeamMembers' ),
( 'admin', 'analytics.analytics.interactions' ),
( 'admin', 'analytics.analytics.mentions' ),
( 'admin', 'analytics.analytics.organizationGraphData' ),
( 'admin', 'analytics.analytics.pageClicks' ),
( 'admin', 'analytics.analytics.pageEngagement' ),
( 'admin', 'analytics.analytics.pageEngagementRate' ),
( 'admin', 'analytics.analytics.pageImpressions' ),
( 'admin', 'analytics.analytics.pageLikeGrowth' ),
( 'admin', 'analytics.analytics.pageLikeOverview' ),
( 'admin', 'analytics.analytics.pageOverallLikes' ),
( 'admin', 'analytics.analytics.pagePostComments' ),
( 'admin', 'analytics.analytics.pagePostEngagement' ),
( 'admin', 'analytics.analytics.pagePostLikes' ),
( 'admin', 'analytics.analytics.pagePostShares' ),
( 'admin', 'analytics.analytics.pageReach' ),
( 'admin', 'analytics.analytics.pageVideoViews' ),
( 'admin', 'analytics.analytics.pageViews' ),
( 'admin', 'analytics.analytics.topPostsByEngagement' ),
( 'admin', 'analytics.analytics.topPostsByImpression' ),
( 'admin', 'analytics.dashboard.create' ),
( 'admin', 'analytics.dashboard.dashboards' ),
( 'admin', 'analytics.dashboard.delete' ),
( 'admin', 'analytics.dashboard.modify' ),
( 'admin', 'auth.activity.list' ),
( 'admin', 'auth.user.changePassword' ),
( 'admin', 'auth.user.create' ),
( 'admin', 'auth.user.delete' ),
( 'admin', 'auth.user.twoFactor' ),
( 'admin', 'auth.user.update' ),
( 'admin', 'auth.user.users' ),
( 'admin', 'background.administration.bitlyTokenEdit' ),
( 'admin', 'background.administration.partnerDelete' ),
( 'admin', 'carousel.create' ),
( 'admin', 'carousel.item.list' ),
( 'admin', 'carousel.remove' ),
( 'admin', 'carousel.update' ),
( 'admin', 'organization.media.fileDelete' ),
( 'admin', 'organization.media.fileUpdate' ),
( 'admin', 'organization.media.fileUpload' ),
( 'admin', 'organization.media.listTags' ),
( 'admin', 'organization.media.mediaList' ),
( 'admin', 'organization.organization.organizations' ),
( 'admin', 'organization.organization.organizationTree' ),
( 'admin', 'organization.organization.update' ),
( 'admin', 'organization.role.create' ),
( 'admin', 'organization.role.groupDelete' ),
( 'admin', 'organization.role.groupModify' ),
( 'admin', 'organization.role.list' ),
( 'admin', 'organization.role.update' ),
( 'admin', 'post.autoFeed.createPostTime' ),
( 'admin', 'post.autoFeed.order' ),
( 'admin', 'post.autoFeed.postTimes' ),
( 'admin', 'post.autoFeed.removePostTime' ),
( 'admin', 'post.autoFeed.settings.list' ),
( 'admin', 'post.autoFeed.settings.update' ),
( 'admin', 'post.autoFeed.update' ),
( 'admin', 'post.category.categories' ),
( 'admin', 'post.category.create' ),
( 'admin', 'post.category.remove' ),
( 'admin', 'post.category.update' ),
( 'admin', 'post.comment.comment' ),
( 'admin', 'post.comment.comments' ),
( 'admin', 'post.post.approvement' ),
( 'admin', 'post.post.create' ),
( 'admin', 'post.post.instantPost' ),
( 'admin', 'post.post.posts' ),
( 'admin', 'post.post.remove' ),
( 'admin', 'post.post.status' ),
( 'admin', 'post.post.statuses' ),
( 'admin', 'post.post.update' ),
( 'admin', 'post.template.create' ),
( 'admin', 'post.template.remove' ),
( 'admin', 'post.template.status' ),
( 'admin', 'post.template.templates' ),
( 'admin', 'post.template.update' ),
( 'admin', 'social.site.create' ),
( 'admin', 'social.site.list' ),
( 'admin', 'social.site.remove' ),
( 'admin', 'social.site.timezones' ),
( 'admin', 'social.site.update' ),
( 'analyst', 'analytics.analytics.activitiesByOrganizations' ),
( 'analyst', 'analytics.analytics.activitiesByTeamMembers' ),
( 'analyst', 'analytics.analytics.interactions' ),
( 'analyst', 'analytics.analytics.mentions' ),
( 'analyst', 'analytics.analytics.organizationGraphData' ),
( 'analyst', 'analytics.analytics.pageClicks' ),
( 'analyst', 'analytics.analytics.pageEngagement' ),
( 'analyst', 'analytics.analytics.pageEngagementRate' ),
( 'analyst', 'analytics.analytics.pageImpressions' ),
( 'analyst', 'analytics.analytics.pageLikeGrowth' ),
( 'analyst', 'analytics.analytics.pageLikeOverview' ),
( 'analyst', 'analytics.analytics.pageOverallLikes' ),
( 'analyst', 'analytics.analytics.pagePostComments' ),
( 'analyst', 'analytics.analytics.pagePostEngagement' ),
( 'analyst', 'analytics.analytics.pagePostLikes' ),
( 'analyst', 'analytics.analytics.pagePostShares' ),
( 'analyst', 'analytics.analytics.pageReach' ),
( 'analyst', 'analytics.analytics.pageVideoViews' ),
( 'analyst', 'analytics.analytics.pageViews' ),
( 'analyst', 'analytics.analytics.topPostsByEngagement' ),
( 'analyst', 'analytics.analytics.topPostsByImpression' ),
( 'analyst', 'analytics.dashboard.create' ),
( 'analyst', 'analytics.dashboard.dashboards' ),
( 'analyst', 'analytics.dashboard.modify' ),
( 'analyst', 'auth.activity.list' ),
( 'analyst', 'auth.user.changePassword' ),
( 'analyst', 'auth.user.twoFactor' ),
( 'analyst', 'background.administration.bitlyTokenEdit' ),
( 'analyst', 'carousel.item.list' ),
( 'analyst', 'organization.media.listTags' ),
( 'analyst', 'organization.media.mediaList' ),
( 'analyst', 'organization.organization.organizations' ),
( 'analyst', 'organization.organization.organizationTree' ),
( 'analyst', 'post.category.categories' ),
( 'analyst', 'post.comment.comment' ),
( 'analyst', 'post.comment.comments' ),
( 'analyst', 'post.post.posts' ),
( 'analyst', 'post.post.statuses' ),
( 'analyst', 'post.template.templates' ),
( 'analyst', 'social.site.list' ),
( 'approver', 'analytics.analytics.activitiesByOrganizations' ),
( 'approver', 'analytics.analytics.activitiesByTeamMembers' ),
( 'approver', 'analytics.analytics.interactions' ),
( 'approver', 'analytics.analytics.mentions' ),
( 'approver', 'analytics.analytics.organizationGraphData' ),
( 'approver', 'analytics.analytics.pageClicks' ),
( 'approver', 'analytics.analytics.pageEngagement' ),
( 'approver', 'analytics.analytics.pageEngagementRate' ),
( 'approver', 'analytics.analytics.pageImpressions' ),
( 'approver', 'analytics.analytics.pageLikeGrowth' ),
( 'approver', 'analytics.analytics.pageLikeOverview' ),
( 'approver', 'analytics.analytics.pageOverallLikes' ),
( 'approver', 'analytics.analytics.pagePostComments' ),
( 'approver', 'analytics.analytics.pagePostEngagement' ),
( 'approver', 'analytics.analytics.pagePostLikes' ),
( 'approver', 'analytics.analytics.pagePostShares' ),
( 'approver', 'analytics.analytics.pageReach' ),
( 'approver', 'analytics.analytics.pageVideoViews' ),
( 'approver', 'analytics.analytics.pageViews' ),
( 'approver', 'analytics.analytics.topPostsByEngagement' ),
( 'approver', 'analytics.analytics.topPostsByImpression' ),
( 'approver', 'analytics.dashboard.create' ),
( 'approver', 'analytics.dashboard.dashboards' ),
( 'approver', 'analytics.dashboard.modify' ),
( 'approver', 'auth.activity.list' ),
( 'approver', 'auth.user.changePassword' ),
( 'approver', 'auth.user.twoFactor' ),
( 'approver', 'background.administration.bitlyTokenEdit' ),
( 'approver', 'carousel.create' ),
( 'approver', 'carousel.item.list' ),
( 'approver', 'carousel.update' ),
( 'approver', 'organization.media.fileUpdate' ),
( 'approver', 'organization.media.fileUpload' ),
( 'approver', 'organization.media.listTags' ),
( 'approver', 'organization.media.mediaList' ),
( 'approver', 'organization.organization.organizations' ),
( 'approver', 'organization.organization.organizationTree' ),
( 'approver', 'post.autoFeed.createPostTime' ),
( 'approver', 'post.autoFeed.order' ),
( 'approver', 'post.autoFeed.postTimes' ),
( 'approver', 'post.autoFeed.settings.list' ),
( 'approver', 'post.autoFeed.settings.update' ),
( 'approver', 'post.autoFeed.update' ),
( 'approver', 'post.category.categories' ),
( 'approver', 'post.category.create' ),
( 'approver', 'post.category.update' ),
( 'approver', 'post.comment.comment' ),
( 'approver', 'post.comment.comments' ),
( 'approver', 'post.post.approvement' ),
( 'approver', 'post.post.create' ),
( 'approver', 'post.post.instantPost' ),
( 'approver', 'post.post.posts' ),
( 'approver', 'post.post.status' ),
( 'approver', 'post.post.statuses' ),
( 'approver', 'post.post.update' ),
( 'approver', 'post.template.create' ),
( 'approver', 'post.template.status' ),
( 'approver', 'post.template.templates' ),
( 'approver', 'post.template.update' ),
( 'approver', 'social.site.list' ),
( 'client', 'analytics.analytics.activitiesByOrganizations' ),
( 'client', 'analytics.analytics.activitiesByTeamMembers' ),
( 'client', 'analytics.analytics.interactions' ),
( 'client', 'analytics.analytics.mentions' ),
( 'client', 'analytics.analytics.organizationGraphData' ),
( 'client', 'analytics.analytics.pageClicks' ),
( 'client', 'analytics.analytics.pageEngagement' ),
( 'client', 'analytics.analytics.pageEngagementRate' ),
( 'client', 'analytics.analytics.pageImpressions' ),
( 'client', 'analytics.analytics.pageLikeGrowth' ),
( 'client', 'analytics.analytics.pageLikeOverview' ),
( 'client', 'analytics.analytics.pageOverallLikes' ),
( 'client', 'analytics.analytics.pagePostComments' ),
( 'client', 'analytics.analytics.pagePostEngagement' ),
( 'client', 'analytics.analytics.pagePostLikes' ),
( 'client', 'analytics.analytics.pagePostShares' ),
( 'client', 'analytics.analytics.pageReach' ),
( 'client', 'analytics.analytics.pageVideoViews' ),
( 'client', 'analytics.analytics.pageViews' ),
( 'client', 'analytics.analytics.topPostsByEngagement' ),
( 'client', 'analytics.analytics.topPostsByImpression' ),
( 'client', 'analytics.dashboard.dashboards' ),
( 'client', 'auth.user.changePassword' ),
( 'client', 'auth.user.twoFactor' ),
( 'client', 'background.administration.bitlyTokenEdit' ),
( 'client', 'organization.organization.organizations' ),
( 'client', 'organization.organization.organizationTree' ),
( 'client', 'post.autoFeed.createPostTime' ),
( 'client', 'post.autoFeed.order' ),
( 'client', 'post.autoFeed.postTimes' ),
( 'client', 'post.autoFeed.removePostTime' ),
( 'client', 'post.autoFeed.settings.list' ),
( 'client', 'post.autoFeed.settings.update' ),
( 'client', 'post.autoFeed.update' ),
( 'client', 'post.comment.comments' ),
( 'client', 'post.post.approvement' ),
( 'client', 'post.post.instantPost' ),
( 'client', 'post.post.posts' ),
( 'client', 'post.post.status' ),
( 'client', 'post.post.statuses' ),
( 'client', 'social.site.list' ),
( 'creator', 'auth.activity.list' ),
( 'creator', 'auth.user.changePassword' ),
( 'creator', 'auth.user.twoFactor' ),
( 'creator', 'background.administration.bitlyTokenEdit' ),
( 'creator', 'carousel.item.list' ),
( 'creator', 'organization.media.listTags' ),
( 'creator', 'organization.media.mediaList' ),
( 'creator', 'organization.organization.organizations' ),
( 'creator', 'organization.organization.organizationTree' ),
( 'creator', 'post.category.categories' ),
( 'creator', 'post.category.create' ),
( 'creator', 'post.comment.comment' ),
( 'creator', 'post.comment.comments' ),
( 'creator', 'post.post.create' ),
( 'creator', 'post.post.instantPost' ),
( 'creator', 'post.post.posts' ),
( 'creator', 'post.post.statuses' ),
( 'creator', 'post.template.templates' ),
( 'creator', 'social.site.list' ),
( 'editor', 'analytics.analytics.activitiesByOrganizations' ),
( 'editor', 'analytics.analytics.activitiesByTeamMembers' ),
( 'editor', 'analytics.analytics.interactions' ),
( 'editor', 'analytics.analytics.mentions' ),
( 'editor', 'analytics.analytics.organizationGraphData' ),
( 'editor', 'analytics.analytics.pageClicks' ),
( 'editor', 'analytics.analytics.pageEngagement' ),
( 'editor', 'analytics.analytics.pageEngagementRate' ),
( 'editor', 'analytics.analytics.pageImpressions' ),
( 'editor', 'analytics.analytics.pageLikeGrowth' ),
( 'editor', 'analytics.analytics.pageLikeOverview' ),
( 'editor', 'analytics.analytics.pageOverallLikes' ),
( 'editor', 'analytics.analytics.pagePostComments' ),
( 'editor', 'analytics.analytics.pagePostEngagement' ),
( 'editor', 'analytics.analytics.pagePostLikes' ),
( 'editor', 'analytics.analytics.pagePostShares' ),
( 'editor', 'analytics.analytics.pageReach' ),
( 'editor', 'analytics.analytics.pageVideoViews' ),
( 'editor', 'analytics.analytics.pageViews' ),
( 'editor', 'analytics.analytics.topPostsByEngagement' ),
( 'editor', 'analytics.analytics.topPostsByImpression' ),
( 'editor', 'analytics.dashboard.create' ),
( 'editor', 'analytics.dashboard.dashboards' ),
( 'editor', 'analytics.dashboard.modify' ),
( 'editor', 'auth.activity.list' ),
( 'editor', 'auth.user.changePassword' ),
( 'editor', 'auth.user.twoFactor' ),
( 'editor', 'background.administration.bitlyTokenEdit' ),
( 'editor', 'carousel.create' ),
( 'editor', 'carousel.item.list' ),
( 'editor', 'carousel.update' ),
( 'editor', 'organization.media.fileUpdate' ),
( 'editor', 'organization.media.fileUpload' ),
( 'editor', 'organization.media.listTags' ),
( 'editor', 'organization.media.mediaList' ),
( 'editor', 'organization.organization.organizations' ),
( 'editor', 'organization.organization.organizationTree' ),
( 'editor', 'post.autoFeed.createPostTime' ),
( 'editor', 'post.autoFeed.order' ),
( 'editor', 'post.autoFeed.postTimes' ),
( 'editor', 'post.autoFeed.settings.list' ),
( 'editor', 'post.autoFeed.settings.update' ),
( 'editor', 'post.autoFeed.update' ),
( 'editor', 'post.category.categories' ),
( 'editor', 'post.category.create' ),
( 'editor', 'post.category.update' ),
( 'editor', 'post.comment.comment' ),
( 'editor', 'post.comment.comments' ),
( 'editor', 'post.post.create' ),
( 'editor', 'post.post.instantPost' ),
( 'editor', 'post.post.posts' ),
( 'editor', 'post.post.remove' ),
( 'editor', 'post.post.statuses' ),
( 'editor', 'post.post.update' ),
( 'editor', 'post.template.create' ),
( 'editor', 'post.template.templates' ),
( 'editor', 'post.template.update' ),
( 'editor', 'social.site.list' ),
( 'superAdmin', 'analytics.analytics.activitiesByOrganizations' ),
( 'superAdmin', 'analytics.analytics.activitiesByTeamMembers' ),
( 'superAdmin', 'analytics.analytics.interactions' ),
( 'superAdmin', 'analytics.analytics.mentions' ),
( 'superAdmin', 'analytics.analytics.organizationGraphData' ),
( 'superAdmin', 'analytics.analytics.pageClicks' ),
( 'superAdmin', 'analytics.analytics.pageEngagement' ),
( 'superAdmin', 'analytics.analytics.pageEngagementRate' ),
( 'superAdmin', 'analytics.analytics.pageImpressions' ),
( 'superAdmin', 'analytics.analytics.pageLikeGrowth' ),
( 'superAdmin', 'analytics.analytics.pageLikeOverview' ),
( 'superAdmin', 'analytics.analytics.pageOverallLikes' ),
( 'superAdmin', 'analytics.analytics.pagePostComments' ),
( 'superAdmin', 'analytics.analytics.pagePostEngagement' ),
( 'superAdmin', 'analytics.analytics.pagePostLikes' ),
( 'superAdmin', 'analytics.analytics.pagePostShares' ),
( 'superAdmin', 'analytics.analytics.pageReach' ),
( 'superAdmin', 'analytics.analytics.pageVideoViews' ),
( 'superAdmin', 'analytics.analytics.pageViews' ),
( 'superAdmin', 'analytics.analytics.topPostsByEngagement' ),
( 'superAdmin', 'analytics.analytics.topPostsByImpression' ),
( 'superAdmin', 'analytics.dashboard.create' ),
( 'superAdmin', 'analytics.dashboard.dashboards' ),
( 'superAdmin', 'analytics.dashboard.delete' ),
( 'superAdmin', 'analytics.dashboard.modify' ),
( 'superAdmin', 'auth.activity.list' ),
( 'superAdmin', 'auth.user.changePassword' ),
( 'superAdmin', 'auth.user.create' ),
( 'superAdmin', 'auth.user.delete' ),
( 'superAdmin', 'auth.user.twoFactor' ),
( 'superAdmin', 'auth.user.update' ),
( 'superAdmin', 'auth.user.users' ),
( 'superAdmin', 'background.administration.bitlyTokenEdit' ),
( 'superAdmin', 'background.administration.partnerDelete' ),
( 'superAdmin', 'carousel.create' ),
( 'superAdmin', 'carousel.item.list' ),
( 'superAdmin', 'carousel.remove' ),
( 'superAdmin', 'carousel.update' ),
( 'superAdmin', 'organization.media.fileDelete' ),
( 'superAdmin', 'organization.media.fileUpdate' ),
( 'superAdmin', 'organization.media.fileUpload' ),
( 'superAdmin', 'organization.media.listTags' ),
( 'superAdmin', 'organization.media.mediaList' ),
( 'superAdmin', 'organization.organization.create' ),
( 'superAdmin', 'organization.organization.organizations' ),
( 'superAdmin', 'organization.organization.organizationTree' ),
( 'superAdmin', 'organization.organization.remove' ),
( 'superAdmin', 'organization.organization.update' ),
( 'superAdmin', 'organization.role.create' ),
( 'superAdmin', 'organization.role.groupDelete' ),
( 'superAdmin', 'organization.role.groupModify' ),
( 'superAdmin', 'organization.role.list' ),
( 'superAdmin', 'organization.role.update' ),
( 'superAdmin', 'post.autoFeed.createPostTime' ),
( 'superAdmin', 'post.autoFeed.order' ),
( 'superAdmin', 'post.autoFeed.postTimes' ),
( 'superAdmin', 'post.autoFeed.removePostTime' ),
( 'superAdmin', 'post.autoFeed.settings.list' ),
( 'superAdmin', 'post.autoFeed.settings.update' ),
( 'superAdmin', 'post.autoFeed.update' ),
( 'superAdmin', 'post.category.categories' ),
( 'superAdmin', 'post.category.create' ),
( 'superAdmin', 'post.category.remove' ),
( 'superAdmin', 'post.category.update' ),
( 'superAdmin', 'post.comment.comment' ),
( 'superAdmin', 'post.comment.comments' ),
( 'superAdmin', 'post.post.approvement' ),
( 'superAdmin', 'post.post.create' ),
( 'superAdmin', 'post.post.instantPost' ),
( 'superAdmin', 'post.post.posts' ),
( 'superAdmin', 'post.post.remove' ),
( 'superAdmin', 'post.post.status' ),
( 'superAdmin', 'post.post.statuses' ),
( 'superAdmin', 'post.post.update' ),
( 'superAdmin', 'post.template.create' ),
( 'superAdmin', 'post.template.remove' ),
( 'superAdmin', 'post.template.status' ),
( 'superAdmin', 'post.template.templates' ),
( 'superAdmin', 'post.template.update' ),
( 'superAdmin', 'social.site.create' ),
( 'superAdmin', 'social.site.list' ),
( 'superAdmin', 'social.site.remove' ),
( 'superAdmin', 'social.site.timezones' ),
( 'superAdmin', 'social.site.update' );