Subversion Repositories DevTools

insert into applications (app_id, application_name, acronym, is_running) values (9, 'Access Manager', 'xxx', 'Y');
insert into applications (app_id, application_name, acronym, is_running) values (2, 'Release Manager', 'xxx', 'Y');
insert into applications (app_id, application_name, acronym, is_running) values (1, 'Deployment Manager', 'xxx', 'Y');
insert into applications (app_id, application_name, acronym, is_running) values (10, 'Production Manager', 'xxx', 'Y');

insert into users (user_id, full_name, user_name, user_password) values (1, 'dev', 'dev1', 'dev');
insert into users (user_id, full_name, user_name, user_password) values (2, 'dev', 'dev2', PK_AMUTILS.GET_HASH( 'dev' ));

insert into user_applications (user_id, app_id) values (1, 9);
insert into user_applications (user_id, app_id) values (2, 2);
insert into user_applications (user_id, app_id) values (2, 1);
insert into user_applications (user_id, app_id) values (2, 10);

insert into permission_types (perm_id, perm_name) values (1, 'enumVISIBLE');
insert into permission_types (perm_id, perm_name) values (2, 'enumACTIVE');

insert into control_objects (obj_id, app_id, obj_name) values (1, 1, 'pmoCreator');
insert into control_objects (obj_id, app_id, obj_name) values (2, 1, 'pmoTester');
insert into control_objects (obj_id, app_id, obj_name) values (3, 1, 'pmoExternalTester');
insert into control_objects (obj_id, app_id, obj_name) values (4, 1, 'oProjectList');
insert into control_objects (obj_id, app_id, obj_name) values (5, 1, 'EditPackageInExternalProjects');
insert into control_objects (obj_id, app_id, obj_name) values (6, 1, 'AddReleaseReference');
insert into control_objects (obj_id, app_id, obj_name) values (7, 1, 'pageApplicationConfiguration');
insert into control_objects (obj_id, app_id, obj_name) values (8, 1, 'onApplicationOffline');
insert into control_objects (obj_id, app_id, obj_name) values (10, 1, 'UnlockPackage');
insert into control_objects (obj_id, app_id, obj_name) values (11, 1, 'DestroyPackage');
insert into control_objects (obj_id, app_id, obj_name) values (12, 1, 'EditProjects');
insert into control_objects (obj_id, app_id, obj_name) values (13, 1, 'ApproveForAutoBuild');
insert into control_objects (obj_id, app_id, obj_name) values (14, 1, 'RemoveReleaseReference');
insert into control_objects (obj_id, app_id, obj_name) values (15, 1, 'ApprovePackageReleaseForRestrictiveMode');
insert into control_objects (obj_id, app_id, obj_name) values (16, 1, 'RejectPackageFromPending');
insert into control_objects (obj_id, app_id, obj_name) values (17, 1, 'ChangeModeFromClosed');
insert into control_objects (obj_id, app_id, obj_name) values (18, 1, 'ChangeModeFromRestrictive');
insert into control_objects (obj_id, app_id, obj_name) values (19, 1, 'CloneReleaseContents');
insert into control_objects (obj_id, app_id, obj_name) values (20, 1, 'DestroyRelease');
insert into control_objects (obj_id, app_id, obj_name) values (21, 1, 'CreateNewRelease');
insert into control_objects (obj_id, app_id, obj_name) values (22, 1, 'MergeRelease');
insert into control_objects (obj_id, app_id, obj_name) values (23, 1, 'AlterReleaseContentsInRestrictiveMode');
insert into control_objects (obj_id, app_id, obj_name) values (24, 1, 'ImportOpenIssues');
insert into control_objects (obj_id, app_id, obj_name) values (25, 1, 'CreateNewProject');
insert into control_objects (obj_id, app_id, obj_name) values (26, 1, 'ChangePreviousVersion');
insert into control_objects (obj_id, app_id, obj_name) values (27, 1, 'ImportDependencies');
insert into control_objects (obj_id, app_id, obj_name) values (28, 1, 'ImportVasttrafikIssues');
insert into control_objects (obj_id, app_id, obj_name) values (29, 1, 'AddDeletePackageInRestrictiveMode');
insert into control_objects (obj_id, app_id, obj_name) values (30, 1, 'RemovePackage');
insert into control_objects (obj_id, app_id, obj_name) values (31, 1, 'ApproveForManualBuild');
insert into control_objects (obj_id, app_id, obj_name) values (32, 1, 'RipplePackage');
insert into control_objects (obj_id, app_id, obj_name) values (33, 1, 'ReleasePatch');
insert into control_objects (obj_id, app_id, obj_name) values (34, 1, 'mergeManager');
insert into control_objects (obj_id, app_id, obj_name) values (35, 1, 'MergeReleaseForCCB');
insert into control_objects (obj_id, app_id, obj_name) values (36, 1, 'DeprecatePackage');
insert into control_objects (obj_id, app_id, obj_name) values (37, 1, 'AdminView');
insert into control_objects (obj_id, app_id, obj_name) values (38, 1, 'EditReleaseNotesInPending');
insert into control_objects (obj_id, app_id, obj_name) values (39, 1, 'DeleteOutstandingIssues');
insert into control_objects (obj_id, app_id, obj_name) values (40, 1, 'UnlockPatch');
insert into control_objects (obj_id, app_id, obj_name) values (41, 1, 'ApprovedByManager');
insert into control_objects (obj_id, app_id, obj_name) values (42, 1, 'ApprovedByTester');
insert into control_objects (obj_id, app_id, obj_name) values (44, 1, 'ChangeVersion');
insert into control_objects (obj_id, app_id, obj_name) values (45, 1, 'GMPTE');
insert into control_objects (obj_id, app_id, obj_name) values (46, 1, 'SanFrancisco');
insert into control_objects (obj_id, app_id, obj_name) values (47, 1, 'ConfigureBuildService');
insert into control_objects (obj_id, app_id, obj_name) values (48, 1, 'ConfigureRelease');
insert into control_objects (obj_id, app_id, obj_name) values (49, 1, 'SetToReproducible');
insert into control_objects (obj_id, app_id, obj_name) values (50, 1, 'ApproveForPendingDeployment');
insert into control_objects (obj_id, app_id, obj_name) values (51, 1, 'ApproveForPendingIntegration');
insert into control_objects (obj_id, app_id, obj_name) values (52, 1, 'ApproveForPendingTest');
insert into control_objects (obj_id, app_id, obj_name) values (53, 1, 'RejectProduct');
insert into control_objects (obj_id, app_id, obj_name) values (54, 1, 'ApprovePendingIntegrateAndDeploy');
insert into control_objects (obj_id, app_id, obj_name) values (55, 1, 'DestroyPackageFromRelease');
insert into control_objects (obj_id, app_id, obj_name) values (56, 1, 'EditNonCriticalInfoForLockedPackage');
insert into control_objects (obj_id, app_id, obj_name) values (57, 1, 'EditCriticalInfoForLockedPackage');

insert into roles (role_id, app_id, role_name) values (1, 1, 'Deployment Manager developer');
insert into roles (role_id, app_id, role_name) values (2, 2, 'Release Manager developer');
insert into roles (role_id, app_id, role_name) values (3, 9, 'Access Manager developer');
insert into roles (role_id, app_id, role_name) values (4, 10, 'Production Manager developer');

insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 3, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 3, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 4, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 4, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 5, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 5, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 6, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 6, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 7, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 7, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 8, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 8, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 10, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 10, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 11, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 11, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 12, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 12, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 13, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 13, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 14, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 14, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 15, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 15, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 16, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 16, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 17, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 17, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 18, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 18, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 19, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 19, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 20, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 20, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 21, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 21, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 22, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 22, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 23, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 23, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 24, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 24, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 25, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 25, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 26, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 26, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 27, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 27, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 28, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 28, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 29, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 29, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 30, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 30, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 31, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 31, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 32, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 32, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 33, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 33, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 34, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 34, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 35, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 35, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 36, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 36, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 37, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 37, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 38, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 38, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 39, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 39, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 40, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 40, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 41, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 41, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 42, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 42, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 44, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 44, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 45, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 45, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 46, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 46, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 47, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 47, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 48, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 48, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 49, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 49, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 50, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 50, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 51, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 51, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 52, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 52, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 53, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 53, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 54, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 54, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 55, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 55, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 56, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 56, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 57, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 57, 2, 'Y');

insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 1, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 1, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 2, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 2, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 3, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 3, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 4, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 4, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 5, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 5, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 6, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 6, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 7, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 7, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 8, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 8, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 10, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 10, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 11, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 11, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 12, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 12, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 13, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 13, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 14, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 14, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 15, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 15, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 16, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 16, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 17, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 17, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 18, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 18, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 19, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 19, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 20, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 20, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 21, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 21, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 22, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 22, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 23, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 23, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 24, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 24, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 25, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 25, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 26, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 26, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 27, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 27, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 28, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 28, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 29, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 29, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 30, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 30, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 31, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 31, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 32, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 32, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 33, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 33, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 34, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 34, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 35, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 35, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 36, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 36, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 37, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 37, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 38, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 38, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 39, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 39, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 40, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 40, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 41, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 41, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 42, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 42, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 44, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 44, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 45, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 45, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 46, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 46, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 47, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 47, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 48, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 48, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 49, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 49, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 50, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 50, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 51, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 51, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 52, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 52, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 53, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 53, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 54, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 54, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 55, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 55, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 56, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 56, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 57, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 57, 2, 'Y');

insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 1, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 1, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 2, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 2, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 3, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 3, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 4, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 4, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 5, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 5, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 6, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 6, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 7, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 7, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 8, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 8, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 10, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 10, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 11, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 11, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 12, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 12, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 13, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 13, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 14, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 14, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 15, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 15, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 16, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 16, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 17, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 17, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 18, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 18, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 19, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 19, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 20, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 20, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 21, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 21, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 22, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 22, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 23, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 23, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 24, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 24, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 25, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 25, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 26, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 26, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 27, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 27, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 28, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 28, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 29, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 29, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 30, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 30, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 31, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 31, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 32, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 32, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 33, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 33, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 34, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 34, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 35, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 35, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 36, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 36, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 37, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 37, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 38, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 38, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 39, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 39, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 40, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 40, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 41, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 41, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 42, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 42, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 44, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 44, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 45, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 45, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 46, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 46, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 47, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 47, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 48, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 48, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 49, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 49, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 50, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 50, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 51, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 51, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 52, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 52, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 53, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 53, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 54, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 54, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 55, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 55, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 56, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 56, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 57, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 57, 2, 'Y');

insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 1, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 1, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 2, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 2, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 3, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 3, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 4, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 4, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 5, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 5, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 6, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 6, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 7, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 7, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 8, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 8, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 10, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 10, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 11, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 11, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 12, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 12, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 13, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 13, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 14, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 14, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 15, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 15, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 16, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 16, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 17, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 17, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 18, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 18, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 19, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 19, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 20, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 20, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 21, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 21, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 22, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 22, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 23, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 23, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 24, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 24, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 25, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 25, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 26, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 26, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 27, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 27, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 28, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 28, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 29, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 29, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 30, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 30, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 31, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 31, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 32, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 32, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 33, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 33, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 34, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 34, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 35, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 35, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 36, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 36, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 37, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 37, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 38, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 38, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 39, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 39, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 40, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 40, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 41, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 41, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 42, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 42, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 44, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 44, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 45, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 45, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 46, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 46, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 47, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 47, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 48, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 48, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 49, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 49, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 50, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 50, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 51, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 51, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 52, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 52, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 53, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 53, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 54, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 54, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 55, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 55, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 56, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 56, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 57, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 57, 2, 'Y');

insert into user_roles (user_id, role_id) values (1, 1);
insert into user_roles (user_id, role_id) values (1, 2);
insert into user_roles (user_id, role_id) values (1, 3);
insert into user_roles (user_id, role_id) values (1, 4);
insert into user_roles (user_id, role_id) values (2, 1);
insert into user_roles (user_id, role_id) values (2, 2);
insert into user_roles (user_id, role_id) values (2, 3);
insert into user_roles (user_id, role_id) values (2, 4);

insert into data_tables (dt_id, obj_id, table_name, ref_column_name, display_column_name) values (1, 12, 'PROJECTS', 'x', 'x');

insert into build_standards (BS_ID, BS_NAME) values
(1, 'JATS');
insert into build_standards (BS_ID, BS_NAME) values
(2, 'ANT');
insert into build_standards (BS_ID, BS_NAME) values
(3, 'NONE');

insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
(1, 'Debug', 1);
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
(2, 'Production', 1);
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
(3, 'Production and Debug', 1);
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
(4, 'Java 1.4', 2);
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
(5, 'Java 1.5', 2);
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
(6, 'Java 1.6', 2);

insert into test_types(TEST_TYPE_ID, TEST_TYPE_NAME, DISPLAY_ORDER) values
(1, 'Not Done', null);
insert into test_types(TEST_TYPE_ID, TEST_TYPE_NAME, DISPLAY_ORDER) values
(5, 'Automatic Unit Test', 1);
insert into test_types(TEST_TYPE_ID, TEST_TYPE_NAME, DISPLAY_ORDER) values
(6, 'Interactive Unit Test', 2);
insert into test_types(TEST_TYPE_ID, TEST_TYPE_NAME, DISPLAY_ORDER) values
(7, 'Autobuild UTF', 3);

insert into build_machines(BM_ID, BM_NAME) values
(1, 'Solaris');
insert into build_machines(BM_ID, BM_NAME) values
(2, 'Win32');
insert into build_machines(BM_ID, BM_NAME) values
(3, 'Linux');
insert into build_machines(BM_ID, BM_NAME) values
(4, 'Generic');

insert into projects (proj_id, proj_name) values (1, 'TIMBUKTU');

insert into views (view_id, view_name, owner_id, base_view, public_read) values
(1, 'viewbar', 0, 'Y', 'Y');
insert into views (view_id, view_name, owner_id, base_view, public_read) values
(9999, 'PROJECT WIDE', 0, 'N', 'Y');

insert into release_tags (rtag_id, vtree_id, rtag_name, created_stamp, creator_id, official, rebuild_env, rebuild_stamp, parent_rtag_id, proj_id, display_order) values
(1, 1, 'foobar', '17-JUN-08', 2, 'N', 'N', 0, 1, 1, 1);

insert into packages (pkg_id, pkg_name) values (1, 'aardvark');

insert into package_versions (pv_id, pkg_id, pkg_version, dlocked, modified_stamp, modifier_id, created_stamp, creator_id, comments, v_mm, v_nmm, pkg_label, src_path, pv_description, owner_id, pv_overview, last_pv_id, release_notes_info, is_build_env_required, build_type, bs_id, ripple_field) values
(1, 1, '1.0.0000', 'Y', '19-JUN-08', 2, '17-JUN-08', 2, 'test', '0000', '1.0.', 'aardvark_1.0.0000', '\vob', 'short', 2, 'long', 1, 'MSG:1', 'Y', 'M', 1, 'b');

insert into unit_tests (test_id, pv_id, test_types_fk, completion_date, completed_by) values
(1, 1, 1, '19-JUN-08', 2);

insert into package_build_info (pv_id, bm_id, bsa_id) values
(1, 4, 3);

insert into release_content (rtag_id, pv_id, base_view_id, insert_stamp, insertor_id, pkg_state) values
(1, 1, 1, '24-JUN-08', 2, 0);

insert into licences (licence, name) values (1, 'GPL');
insert into licences (licence, name) values (2, 'LGPL');

insert into ripple_field_states ( state_id, state_acronym, state_name ) values (1, 'M', 'Major Number');
insert into ripple_field_states ( state_id, state_acronym, state_name ) values (2, 'm', 'Minor Number');
insert into ripple_field_states ( state_id, state_acronym, state_name ) values (3, 'p', 'Patch Number');
insert into ripple_field_states ( state_id, state_acronym, state_name ) values (4, 'b', 'Build Number');
insert into ripple_field_states ( state_id, state_acronym, state_name ) values (5, 'L', 'Limited');