Оценка: 12260

Сгенерированные файлы и таблицы

Generated SQL:

        SET FOREIGN_KEY_CHECKS = 0;



                DROP TABLE IF EXISTS `client`;
                CREATE TABLE `client` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `user_id` int(11) DEFAULT NULL,

                        `city_id` int(11) DEFAULT NULL,

                        `client_category_id` int(11) DEFAULT NULL,

                        `type` int(2) DEFAULT NULL,

                        `birthday_at` INT(11) null,

                        `age` int(3) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `client_user_id__user`
                        FOREIGN KEY (`user_id`)
                        REFERENCES `user` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `client_city_id__city`
                        FOREIGN KEY (`city_id`)
                        REFERENCES `city` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `client_client_category_id__client_category`
                        FOREIGN KEY (`client_category_id`)
                        REFERENCES `client_category` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `city`;
                CREATE TABLE `city` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `title` VARCHAR(255) DEFAULT NULL,

                        `country` VARCHAR(255) DEFAULT NULL,

                        `flag` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `client_category`;
                CREATE TABLE `client_category` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `name` VARCHAR(255) DEFAULT NULL,

                        `description` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `consultation`;
                CREATE TABLE `consultation` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `consultation_category_id` int(11) DEFAULT NULL,

                        `client_id` int(11) DEFAULT NULL,

                        `name` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `consultation_consultation_category_id__consultation_category`
                        FOREIGN KEY (`consultation_category_id`)
                        REFERENCES `consultation_category` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `consultation_client_id__client`
                        FOREIGN KEY (`client_id`)
                        REFERENCES `client` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `consultation_category`;
                CREATE TABLE `consultation_category` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `name` VARCHAR(255) DEFAULT NULL,

                        `description` VARCHAR(255) DEFAULT NULL,

                        `tags` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `client_answer`;
                CREATE TABLE `client_answer` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `client_id` int(11) DEFAULT NULL,

                        `test_question_id` int(11) DEFAULT NULL,

                        `test_answer_id` int(11) DEFAULT NULL,

                        `test_answer_text` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `client_answer_client_id__client`
                        FOREIGN KEY (`client_id`)
                        REFERENCES `client` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `client_answer_test_question_id__test_question`
                        FOREIGN KEY (`test_question_id`)
                        REFERENCES `test_question` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `client_answer_test_answer_id__test_answer`
                        FOREIGN KEY (`test_answer_id`)
                        REFERENCES `test_answer` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_category`;
                CREATE TABLE `test_category` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `title` VARCHAR(255) NOT NULL,

                        `description` VARCHAR(255) DEFAULT NULL,

                        `status` VARCHAR(255) DEFAULT NULL,

                        `is_disabled` TINYINT(1) DEFAULT NULL,

                        `order` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_block`;
                CREATE TABLE `test_block` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `title` VARCHAR(255) NOT NULL,

                        `is_disabled` TINYINT(1) DEFAULT NULL,

                        `order` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_question`;
                CREATE TABLE `test_question` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `test_category_id` int(11) NOT NULL,

                        `test_block_id` int(11) DEFAULT NULL,

                        `title` VARCHAR(255) NOT NULL,

                        `description` text DEFAULT NULL,

                        `type` tinyint(1) DEFAULT '1',

                        `is_disabled` TINYINT(1) DEFAULT NULL,

                        `order` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `test_question_test_category_id__test_category`
                        FOREIGN KEY (`test_category_id`)
                        REFERENCES `test_category` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `test_question_test_block_id__test_block`
                        FOREIGN KEY (`test_block_id`)
                        REFERENCES `test_block` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_answer`;
                CREATE TABLE `test_answer` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `test_question_id` int(11) DEFAULT NULL,

                        `title` VARCHAR(255) NOT NULL,

                        `is_disabled` TINYINT(1) DEFAULT NULL,

                        `order` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `test_answer_test_question_id__test_question`
                        FOREIGN KEY (`test_question_id`)
                        REFERENCES `test_question` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_question_requires`;
                CREATE TABLE `test_question_requires` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `test_answer_id` int(11) DEFAULT NULL,

                        `test_question_id` int(11) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `test_question_requires_test_answer_id__test_answer`
                        FOREIGN KEY (`test_answer_id`)
                        REFERENCES `test_answer` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `test_question_requires_test_question_id__test_question`
                        FOREIGN KEY (`test_question_id`)
                        REFERENCES `test_question` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_answer_context`;
                CREATE TABLE `test_answer_context` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `test_answer_id` int(11) DEFAULT NULL,

                        `test_question_id` int(11) DEFAULT NULL,

                        `test_answer_context_id` int(11) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `test_answer_context_test_answer_id__test_answer`
                        FOREIGN KEY (`test_answer_id`)
                        REFERENCES `test_answer` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `test_answer_context_test_question_id__test_question`
                        FOREIGN KEY (`test_question_id`)
                        REFERENCES `test_question` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `test_answer_context_test_answer_context_id__test_answer_context`
                        FOREIGN KEY (`test_answer_context_id`)
                        REFERENCES `test_answer_context` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


        SET FOREIGN_KEY_CHECKS = 0;



                DROP TABLE IF EXISTS `client`;
                CREATE TABLE `client` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `user_id` int(11) DEFAULT NULL,

                        `city_id` int(11) DEFAULT NULL,

                        `client_category_id` int(11) DEFAULT NULL,

                        `type` int(2) DEFAULT NULL,

                        `birthday_at` INT(11) null,

                        `age` int(3) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `client_user_id__user`
                        FOREIGN KEY (`user_id`)
                        REFERENCES `user` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `client_city_id__city`
                        FOREIGN KEY (`city_id`)
                        REFERENCES `city` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `client_client_category_id__client_category`
                        FOREIGN KEY (`client_category_id`)
                        REFERENCES `client_category` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `city`;
                CREATE TABLE `city` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `title` VARCHAR(255) DEFAULT NULL,

                        `country` VARCHAR(255) DEFAULT NULL,

                        `flag` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `client_category`;
                CREATE TABLE `client_category` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `name` VARCHAR(255) DEFAULT NULL,

                        `description` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `consultation`;
                CREATE TABLE `consultation` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `consultation_category_id` int(11) DEFAULT NULL,

                        `client_id` int(11) DEFAULT NULL,

                        `name` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `consultation_consultation_category_id__consultation_category`
                        FOREIGN KEY (`consultation_category_id`)
                        REFERENCES `consultation_category` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `consultation_client_id__client`
                        FOREIGN KEY (`client_id`)
                        REFERENCES `client` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `consultation_category`;
                CREATE TABLE `consultation_category` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `name` VARCHAR(255) DEFAULT NULL,

                        `description` VARCHAR(255) DEFAULT NULL,

                        `tags` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `client_answer`;
                CREATE TABLE `client_answer` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `client_id` int(11) DEFAULT NULL,

                        `test_question_id` int(11) DEFAULT NULL,

                        `test_answer_id` int(11) DEFAULT NULL,

                        `test_answer_text` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `client_answer_client_id__client`
                        FOREIGN KEY (`client_id`)
                        REFERENCES `client` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `client_answer_test_question_id__test_question`
                        FOREIGN KEY (`test_question_id`)
                        REFERENCES `test_question` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `client_answer_test_answer_id__test_answer`
                        FOREIGN KEY (`test_answer_id`)
                        REFERENCES `test_answer` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_category`;
                CREATE TABLE `test_category` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `title` VARCHAR(255) NOT NULL,

                        `description` VARCHAR(255) DEFAULT NULL,

                        `status` VARCHAR(255) DEFAULT NULL,

                        `is_disabled` TINYINT(1) DEFAULT NULL,

                        `order` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_block`;
                CREATE TABLE `test_block` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `title` VARCHAR(255) NOT NULL,

                        `is_disabled` TINYINT(1) DEFAULT NULL,

                        `order` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_question`;
                CREATE TABLE `test_question` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `test_category_id` int(11) NOT NULL,

                        `test_block_id` int(11) DEFAULT NULL,

                        `title` VARCHAR(255) NOT NULL,

                        `description` text DEFAULT NULL,

                        `type` tinyint(1) DEFAULT '1',

                        `is_disabled` TINYINT(1) DEFAULT NULL,

                        `order` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `test_question_test_category_id__test_category`
                        FOREIGN KEY (`test_category_id`)
                        REFERENCES `test_category` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `test_question_test_block_id__test_block`
                        FOREIGN KEY (`test_block_id`)
                        REFERENCES `test_block` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_answer`;
                CREATE TABLE `test_answer` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `test_question_id` int(11) DEFAULT NULL,

                        `title` VARCHAR(255) NOT NULL,

                        `is_disabled` TINYINT(1) DEFAULT NULL,

                        `order` VARCHAR(255) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `test_answer_test_question_id__test_question`
                        FOREIGN KEY (`test_question_id`)
                        REFERENCES `test_question` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_question_requires`;
                CREATE TABLE `test_question_requires` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `test_answer_id` int(11) DEFAULT NULL,

                        `test_question_id` int(11) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `test_question_requires_test_answer_id__test_answer`
                        FOREIGN KEY (`test_answer_id`)
                        REFERENCES `test_answer` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `test_question_requires_test_question_id__test_question`
                        FOREIGN KEY (`test_question_id`)
                        REFERENCES `test_question` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



                DROP TABLE IF EXISTS `test_answer_context`;
                CREATE TABLE `test_answer_context` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,

                        `test_answer_id` int(11) DEFAULT NULL,

                        `test_question_id` int(11) DEFAULT NULL,

                        `test_answer_context_id` int(11) DEFAULT NULL,

                  PRIMARY KEY (`id`)
                  ,
                        CONSTRAINT `test_answer_context_test_answer_id__test_answer`
                        FOREIGN KEY (`test_answer_id`)
                        REFERENCES `test_answer` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `test_answer_context_test_question_id__test_question`
                        FOREIGN KEY (`test_question_id`)
                        REFERENCES `test_question` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE
                    ,
                        CONSTRAINT `test_answer_context_test_answer_context_id__test_answer_context`
                        FOREIGN KEY (`test_answer_context_id`)
                        REFERENCES `test_answer_context` (`id`)
                        ON UPDATE CASCADE
                        ON DELETE CASCADE

                ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


                    -- ------------------------------------------------
        INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendCityFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendCityEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendCityView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationCityFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationCityEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationCityView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientCategoryFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientCategoryEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientCategoryView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientCategoryFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientCategoryEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientCategoryView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendConsultationFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendConsultationEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendConsultationView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationConsultationFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationConsultationEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationConsultationView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendConsultationCategoryFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendConsultationCategoryEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendConsultationCategoryView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationConsultationCategoryFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationConsultationCategoryEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationConsultationCategoryView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientAnswerFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientAnswerEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendClientAnswerView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientAnswerFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientAnswerEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationClientAnswerView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestCategoryFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestCategoryEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestCategoryView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestCategoryFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestCategoryEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestCategoryView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestBlockFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestBlockEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestBlockView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestBlockFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestBlockEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestBlockView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestQuestionFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestQuestionEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestQuestionView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestQuestionFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestQuestionEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestQuestionView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestAnswerFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestAnswerEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestAnswerView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestAnswerFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestAnswerEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestAnswerView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestQuestionRequiresFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestQuestionRequiresEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestQuestionRequiresView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestQuestionRequiresFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestQuestionRequiresEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestQuestionRequiresView', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestAnswerContextFull', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestAnswerContextEdit', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('BackendTestAnswerContextView', 1) ;INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestAnswerContextFull', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestAnswerContextEdit', 1);INSERT INTO rbac_auth_item (name, type) VALUES ('ApplicationTestAnswerContextView', 1);