-- -- Dumping data for table module -- INSERT INTO module VALUES ({SGL_NEXT_ID}, 1, 'navigation', 'Navigation', 'The ''Navigation'' module is what you use to build your site navigation, it creates menus that you can customise in terms of look and feel, and allows you to link to any site resource.', 'navigation/page', 'navigation.png', '', NULL, NULL, NULL); -- -- Dumping data for table permission -- INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'navstylemgr', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'navstylemgr_cmd_changeStyle', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'navstylemgr_cmd_list', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'sectionmgr', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'sectionmgr_cmd_add', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'sectionmgr_cmd_insert', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'sectionmgr_cmd_edit', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'sectionmgr_cmd_update', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'sectionmgr_cmd_delete', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'sectionmgr_cmd_reorder', '', (SELECT MAX(module_id) FROM module)); INSERT INTO permission VALUES ({SGL_NEXT_ID}, 'sectionmgr_cmd_list', '', (SELECT MAX(module_id) FROM module)); -- -- Dumping data for table section -- -- -- Creating sequences -- sequence must start on the first free record id -- INSERT INTO section VALUES (1, 'root', 'uriEmpty:', '1', 1, 0, 0, 0, 0, 0, 0, 0, 0, '', ''); INSERT INTO section VALUES (2, 'User menu', 'uriEmpty:', '-2', 2, 0, 2, 1, 2, 1, 1, 1, 0, '', ''); INSERT INTO section VALUES (4, 'Admin menu', 'uriEmpty:', '1', 4, 0, 4, 1, 2, 2, 1, 1, 0, '', ''); -- CREATE SEQUENCE section_seq;