INSERT INTO `module` (`module_id`, `is_configurable`, `name`, `title`, `description`, `admin_uri`, `icon`, `maintainers`, `version`, `license`, `state`) VALUES ({SGL_NEXT_ID}, 1, 'subcontractor', 'Subcontractor', 'Generated by ModuleGenerationMgr', '', '48/module_default.png', 'Alouicious Bird', NULL, 'NULL', 'NULL');

SELECT @moduleId := MAX(module_id) FROM module;

INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractormgr', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractormgr_cmd_view', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractormgr_cmd_addview', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractormgr_cmd_add', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractormgr_cmd_editview', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractormgr_cmd_edit', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractormgr_cmd_delete', '', @moduleId);

INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractortypemgr', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractortypemgr_cmd_view', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractortypemgr_cmd_addview', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractortypemgr_cmd_add', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractortypemgr_cmd_editview', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractortypemgr_cmd_edit', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'adminsubcontractortypemgr_cmd_delete', '', @moduleId);

INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'subcontractorViewmgr', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'subcontractorViewmgr_cmd_viewarticle', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'subcontractorViewmgr_cmd_viewarticletype', '', @moduleId);
INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'subcontractorViewmgr_cmd_viewarticlealltype', '', @moduleId);
