CREATE OR REPLACE VIEW sw3_permissions.user_has_permission_over_category_positive AS

    SELECT

        id_user,
        id_category,
        CAST(bit_or(article_topication::INT) AS BIT(16))    AS article_topication,
        CAST(bit_or(article_redaction::INT) AS BIT(16))     AS article_redaction,
        CAST(bit_or(article_review::INT) AS BIT(16))        AS article_review,
        CAST(bit_or(article_admin::INT) AS BIT(16))         AS article_admin,
        CAST(bit_or(user_basics::INT) AS BIT(16))           AS user_basics,
        CAST(bit_or(user_admin::INT) AS BIT(16))            AS user_admin,
        CAST(bit_or(forum_basics::INT) AS BIT(16))          AS forum_basics,
        CAST(bit_or(forum_admin::INT) AS BIT(16))           AS forum_admin,
        CAST(bit_or(other::INT) AS BIT(16))                 AS other

    FROM
    (
        -- Droits sur une catégorie par rapport à un role

        SELECT
            id_user,
            id_category,
            article_topication,
            article_redaction,
            article_review,
            article_admin,
            user_basics,
            user_admin,
            forum_basics,
            forum_admin,
            other
        FROM sw3_permissions.user_has_role_over_category
        INNER JOIN sw3_permissions.user_role
            ON
                sw3_permissions.user_role.id
                =
                sw3_permissions.user_has_role_over_category.id_role

        UNION

        -- Droits sur une catégorie par rapport au niveau

        SELECT
            id_user,
            id_category,
            article_topication,
            article_redaction,
            article_review,
            article_admin,
            user_basics,
            user_admin,
            forum_basics,
            forum_admin,
            other
        FROM sw3_permissions.user_has_role_over_category_through_level
        INNER JOIN sw3_permissions.user_role
            ON
                sw3_permissions.user_role.id
                =
                sw3_permissions.user_has_role_over_category_through_level.id_role

        UNION

        -- Droits sur un univers par rapport à un role

        SELECT
            id_user,
            category.id AS id_category,
            article_topication,
            article_redaction,
            article_review,
            article_admin,
            user_basics,
            user_admin,
            forum_basics,
            forum_admin,
            other
        FROM sw3_main.category
        INNER JOIN sw3_permissions.user_has_role_over_universe
            ON
                sw3_main.category.id_universe
                =
                sw3_permissions.user_has_role_over_universe.id_universe
        INNER JOIN sw3_permissions.user_role
            ON
                sw3_permissions.user_role.id
                =
                sw3_permissions.user_has_role_over_universe.id_role

        UNION

        -- Droits sur une marketplace par rapport à un role

        SELECT
            id_user,
            category.id AS id_category,
            article_topication,
            article_redaction,
            article_review,
            article_admin,
            user_basics,
            user_admin,
            forum_basics,
            forum_admin,
            other
        FROM sw3_main.category
        INNER JOIN sw3_permissions.user_has_role_over_marketplace
            ON
                sw3_main.category.id_marketplace
                =
                sw3_permissions.user_has_role_over_marketplace.id_marketplace
        INNER JOIN sw3_permissions.user_role
            ON
                sw3_permissions.user_role.id
                =
                sw3_permissions.user_has_role_over_marketplace.id_role

        UNION

        -- Droits globaux par rapport à un role

        SELECT
            id_user,
            category.id AS id_category,
            article_topication,
            article_redaction,
            article_review,
            article_admin,
            user_basics,
            user_admin,
            forum_basics,
            forum_admin,
            other
        FROM sw3_main.category, sw3_permissions.user_has_role
        INNER JOIN sw3_permissions.user_role
            ON
                sw3_permissions.user_role.id
                =
                sw3_permissions.user_has_role.id_role

        UNION

        -- Premissions directes sur une catégorie

        SELECT *
        FROM sw3_permissions.user_has_permission_over_category

        UNION

        -- Permissions directes sur une marketplace

        SELECT
            id_user,
            category.id AS id_category,
            article_topication,
            article_redaction,
            article_review,
            article_admin,
            user_basics,
            user_admin,
            forum_basics,
            forum_admin,
            other
        FROM sw3_main.category
        INNER JOIN sw3_permissions.user_has_permission_over_marketplace
            ON
                sw3_main.category.id_marketplace
                =
                sw3_permissions.user_has_permission_over_marketplace.id_marketplace

        UNION

        -- Permissions directes sur une marketplace

        SELECT
            id_user,
            category.id AS id_category,
            article_topication,
            article_redaction,
            article_review,
            article_admin,
            user_basics,
            user_admin,
            forum_basics,
            forum_admin,
            other
        FROM sw3_main.category
        INNER JOIN sw3_permissions.user_has_permission_over_universe
            ON
                sw3_main.category.id_universe
                =
                sw3_permissions.user_has_permission_over_universe.id_universe

        UNION

        -- Permissions directes globales

        SELECT
            id_user,
            category.id AS id_category,
            article_topication,
            article_redaction,
            article_review,
            article_admin,
            user_basics,
            user_admin,
            forum_basics,
            forum_admin,
            other
        FROM sw3_main.category, sw3_permissions.user_has_permission
    ) t1
    GROUP BY id_user, id_category;