Subversion Repositories DevTools

Rev

Rev 51 | Rev 57 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 51 Rev 53
Line 1... Line 1...
1 
insert into applications (app_id, application_name, acronym, is_running) values (9, 'Access Manager', 'xxx', 'Y')
 1 
insert into applications (app_id, application_name, acronym, is_running) values (9, 'Access Manager', 'xxx', 'Y');
2 
insert into applications (app_id, application_name, acronym, is_running) values (2, 'Release Manager', 'xxx', 'Y')
 2 
insert into applications (app_id, application_name, acronym, is_running) values (2, 'Release Manager', 'xxx', 'Y');
3 
insert into applications (app_id, application_name, acronym, is_running) values (1, 'Deployment Manager', 'xxx', 'Y')
 3 
insert into applications (app_id, application_name, acronym, is_running) values (1, 'Deployment Manager', 'xxx', 'Y');
4 
insert into applications (app_id, application_name, acronym, is_running) values (10, 'Production Manager', 'xxx', 'Y')
 4 
insert into applications (app_id, application_name, acronym, is_running) values (10, 'Production Manager', 'xxx', 'Y');
5 
 
 5 
 
6 
insert into users (user_id, full_name, user_name, user_password) values (1, 'dev', 'dev1', 'dev')
 6 
insert into users (user_id, full_name, user_name, user_password) values (1, 'dev', 'dev1', 'dev');
7 
 
 - 
 
8 
either
 - 
 
9 
insert into users (user_id, full_name, user_name, user_password) values (2, 'dev', 'dev2', chr(to_number('8e','XX'))||chr(to_number('ec','XX'))||chr(to_number('1e','XX'))||chr(to_number('97','XX'))||chr(to_number('ac','XX'))||chr(to_number('60','XX'))||chr(to_number('2d','XX'))||chr(to_number('32','XX'))||chr(to_number('28','XX'))||chr(to_number('ba','XX'))||chr(to_number('d3','XX'))||chr(to_number('3b','XX'))||chr(to_number('61','XX'))||chr(to_number('ef','XX'))||chr(to_number('ea','XX'))||chr(to_number('ae','XX')))
 - 
 
10 
 
 - 
 
11 
or
 - 
 
12 
insert into users (user_id, full_name, user_name, user_password) values (2, 'dev', 'dev2', PK_AMUTILS.GET_HASH( 'dev' ))
 7 
insert into users (user_id, full_name, user_name, user_password) values (2, 'dev', 'dev2', PK_AMUTILS.GET_HASH( 'dev' ));
13 
 
 8 
 
14 
insert into user_applications (user_id, app_id) values (1, 9)
 9 
insert into user_applications (user_id, app_id) values (1, 9);
15 
insert into user_applications (user_id, app_id) values (2, 2)
 10 
insert into user_applications (user_id, app_id) values (2, 2);
16 
insert into user_applications (user_id, app_id) values (2, 1)
 11 
insert into user_applications (user_id, app_id) values (2, 1);
17 
insert into user_applications (user_id, app_id) values (2, 10)
 12 
insert into user_applications (user_id, app_id) values (2, 10);
18 
 
 13 
 
19 
insert into permission_types (perm_id, perm_name) values (1, 'enumVISIBLE')
 14 
insert into permission_types (perm_id, perm_name) values (1, 'enumVISIBLE');
20 
insert into permission_types (perm_id, perm_name) values (2, 'enumACTIVE')
 15 
insert into permission_types (perm_id, perm_name) values (2, 'enumACTIVE');
21 
 
 16 
 
22 
insert into control_objects (obj_id, app_id, obj_name) values (1, 1, 'pmoCreator')
 17 
insert into control_objects (obj_id, app_id, obj_name) values (1, 1, 'pmoCreator');
23 
insert into control_objects (obj_id, app_id, obj_name) values (2, 1, 'pmoTester')
 18 
insert into control_objects (obj_id, app_id, obj_name) values (2, 1, 'pmoTester');
24 
insert into control_objects (obj_id, app_id, obj_name) values (3, 1, 'pmoExternalTester')
 19 
insert into control_objects (obj_id, app_id, obj_name) values (3, 1, 'pmoExternalTester');
25 
insert into control_objects (obj_id, app_id, obj_name) values (4, 1, 'oProjectList')
 20 
insert into control_objects (obj_id, app_id, obj_name) values (4, 1, 'oProjectList');
26 
insert into control_objects (obj_id, app_id, obj_name) values (5, 1, 'EditPackageInExternalProjects')
 21 
insert into control_objects (obj_id, app_id, obj_name) values (5, 1, 'EditPackageInExternalProjects');
27 
insert into control_objects (obj_id, app_id, obj_name) values (6, 1, 'AddReleaseReference')
 22 
insert into control_objects (obj_id, app_id, obj_name) values (6, 1, 'AddReleaseReference');
28 
insert into control_objects (obj_id, app_id, obj_name) values (7, 1, 'pageApplicationConfiguration')
 23 
insert into control_objects (obj_id, app_id, obj_name) values (7, 1, 'pageApplicationConfiguration');
29 
insert into control_objects (obj_id, app_id, obj_name) values (8, 1, 'onApplicationOffline')
 24 
insert into control_objects (obj_id, app_id, obj_name) values (8, 1, 'onApplicationOffline');
30 
insert into control_objects (obj_id, app_id, obj_name) values (10, 1, 'UnlockPackage')
 25 
insert into control_objects (obj_id, app_id, obj_name) values (10, 1, 'UnlockPackage');
31 
insert into control_objects (obj_id, app_id, obj_name) values (11, 1, 'DestroyPackage')
 26 
insert into control_objects (obj_id, app_id, obj_name) values (11, 1, 'DestroyPackage');
32 
insert into control_objects (obj_id, app_id, obj_name) values (12, 1, 'EditProjects')
 27 
insert into control_objects (obj_id, app_id, obj_name) values (12, 1, 'EditProjects');
33 
insert into control_objects (obj_id, app_id, obj_name) values (13, 1, 'ApproveForAutoBuild')
 28 
insert into control_objects (obj_id, app_id, obj_name) values (13, 1, 'ApproveForAutoBuild');
34 
insert into control_objects (obj_id, app_id, obj_name) values (14, 1, 'RemoveReleaseReference')
 29 
insert into control_objects (obj_id, app_id, obj_name) values (14, 1, 'RemoveReleaseReference');
35 
insert into control_objects (obj_id, app_id, obj_name) values (15, 1, 'ApprovePackageReleaseForRestrictiveMode')
 30 
insert into control_objects (obj_id, app_id, obj_name) values (15, 1, 'ApprovePackageReleaseForRestrictiveMode');
36 
insert into control_objects (obj_id, app_id, obj_name) values (16, 1, 'RejectPackageFromPending')
 31 
insert into control_objects (obj_id, app_id, obj_name) values (16, 1, 'RejectPackageFromPending');
37 
insert into control_objects (obj_id, app_id, obj_name) values (17, 1, 'ChangeModeFromClosed')
 32 
insert into control_objects (obj_id, app_id, obj_name) values (17, 1, 'ChangeModeFromClosed');
38 
insert into control_objects (obj_id, app_id, obj_name) values (18, 1, 'ChangeModeFromRestrictive')
 33 
insert into control_objects (obj_id, app_id, obj_name) values (18, 1, 'ChangeModeFromRestrictive');
39 
insert into control_objects (obj_id, app_id, obj_name) values (19, 1, 'CloneReleaseContents')
 34 
insert into control_objects (obj_id, app_id, obj_name) values (19, 1, 'CloneReleaseContents');
40 
insert into control_objects (obj_id, app_id, obj_name) values (20, 1, 'DestroyRelease')
 35 
insert into control_objects (obj_id, app_id, obj_name) values (20, 1, 'DestroyRelease');
41 
insert into control_objects (obj_id, app_id, obj_name) values (21, 1, 'CreateNewRelease')
 36 
insert into control_objects (obj_id, app_id, obj_name) values (21, 1, 'CreateNewRelease');
42 
insert into control_objects (obj_id, app_id, obj_name) values (22, 1, 'MergeRelease')
 37 
insert into control_objects (obj_id, app_id, obj_name) values (22, 1, 'MergeRelease');
43 
insert into control_objects (obj_id, app_id, obj_name) values (23, 1, 'AlterReleaseContentsInRestrictiveMode')
 38 
insert into control_objects (obj_id, app_id, obj_name) values (23, 1, 'AlterReleaseContentsInRestrictiveMode');
44 
insert into control_objects (obj_id, app_id, obj_name) values (24, 1, 'ImportOpenIssues')
 39 
insert into control_objects (obj_id, app_id, obj_name) values (24, 1, 'ImportOpenIssues');
45 
insert into control_objects (obj_id, app_id, obj_name) values (25, 1, 'CreateNewProject')
 40 
insert into control_objects (obj_id, app_id, obj_name) values (25, 1, 'CreateNewProject');
46 
insert into control_objects (obj_id, app_id, obj_name) values (26, 1, 'ChangePreviousVersion')
 41 
insert into control_objects (obj_id, app_id, obj_name) values (26, 1, 'ChangePreviousVersion');
47 
insert into control_objects (obj_id, app_id, obj_name) values (27, 1, 'ImportDependencies')
 42 
insert into control_objects (obj_id, app_id, obj_name) values (27, 1, 'ImportDependencies');
48 
insert into control_objects (obj_id, app_id, obj_name) values (28, 1, 'ImportVasttrafikIssues')
 43 
insert into control_objects (obj_id, app_id, obj_name) values (28, 1, 'ImportVasttrafikIssues');
49 
insert into control_objects (obj_id, app_id, obj_name) values (29, 1, 'AddDeletePackageInRestrictiveMode')
 44 
insert into control_objects (obj_id, app_id, obj_name) values (29, 1, 'AddDeletePackageInRestrictiveMode');
50 
insert into control_objects (obj_id, app_id, obj_name) values (30, 1, 'RemovePackage')
 45 
insert into control_objects (obj_id, app_id, obj_name) values (30, 1, 'RemovePackage');
51 
insert into control_objects (obj_id, app_id, obj_name) values (31, 1, 'ApproveForManualBuild')
 46 
insert into control_objects (obj_id, app_id, obj_name) values (31, 1, 'ApproveForManualBuild');
52 
insert into control_objects (obj_id, app_id, obj_name) values (32, 1, 'RipplePackage')
 47 
insert into control_objects (obj_id, app_id, obj_name) values (32, 1, 'RipplePackage');
53 
insert into control_objects (obj_id, app_id, obj_name) values (33, 1, 'ReleasePatch')
 48 
insert into control_objects (obj_id, app_id, obj_name) values (33, 1, 'ReleasePatch');
54 
insert into control_objects (obj_id, app_id, obj_name) values (34, 1, 'mergeManager')
 49 
insert into control_objects (obj_id, app_id, obj_name) values (34, 1, 'mergeManager');
55 
insert into control_objects (obj_id, app_id, obj_name) values (35, 1, 'MergeReleaseForCCB')
 50 
insert into control_objects (obj_id, app_id, obj_name) values (35, 1, 'MergeReleaseForCCB');
56 
insert into control_objects (obj_id, app_id, obj_name) values (36, 1, 'DeprecatePackage')
 51 
insert into control_objects (obj_id, app_id, obj_name) values (36, 1, 'DeprecatePackage');
57 
insert into control_objects (obj_id, app_id, obj_name) values (37, 1, 'AdminView')
 52 
insert into control_objects (obj_id, app_id, obj_name) values (37, 1, 'AdminView');
58 
insert into control_objects (obj_id, app_id, obj_name) values (38, 1, 'EditReleaseNotesInPending')
 53 
insert into control_objects (obj_id, app_id, obj_name) values (38, 1, 'EditReleaseNotesInPending');
59 
insert into control_objects (obj_id, app_id, obj_name) values (39, 1, 'DeleteOutstandingIssues')
 54 
insert into control_objects (obj_id, app_id, obj_name) values (39, 1, 'DeleteOutstandingIssues');
60 
insert into control_objects (obj_id, app_id, obj_name) values (40, 1, 'UnlockPatch')
 55 
insert into control_objects (obj_id, app_id, obj_name) values (40, 1, 'UnlockPatch');
61 
insert into control_objects (obj_id, app_id, obj_name) values (41, 1, 'ApprovedByManager')
 56 
insert into control_objects (obj_id, app_id, obj_name) values (41, 1, 'ApprovedByManager');
62 
insert into control_objects (obj_id, app_id, obj_name) values (42, 1, 'ApprovedByTester')
 57 
insert into control_objects (obj_id, app_id, obj_name) values (42, 1, 'ApprovedByTester');
63 
insert into control_objects (obj_id, app_id, obj_name) values (44, 1, 'ChangeVersion')
 58 
insert into control_objects (obj_id, app_id, obj_name) values (44, 1, 'ChangeVersion');
64 
insert into control_objects (obj_id, app_id, obj_name) values (45, 1, 'GMPTE')
 59 
insert into control_objects (obj_id, app_id, obj_name) values (45, 1, 'GMPTE');
65 
insert into control_objects (obj_id, app_id, obj_name) values (46, 1, 'SanFrancisco')
 60 
insert into control_objects (obj_id, app_id, obj_name) values (46, 1, 'SanFrancisco');
66 
insert into control_objects (obj_id, app_id, obj_name) values (47, 1, 'ConfigureBuildService')
 61 
insert into control_objects (obj_id, app_id, obj_name) values (47, 1, 'ConfigureBuildService');
67 
insert into control_objects (obj_id, app_id, obj_name) values (48, 1, 'ConfigureRelease')
 62 
insert into control_objects (obj_id, app_id, obj_name) values (48, 1, 'ConfigureRelease');
68 
insert into control_objects (obj_id, app_id, obj_name) values (49, 1, 'SetToReproducible')
 63 
insert into control_objects (obj_id, app_id, obj_name) values (49, 1, 'SetToReproducible');
69 
insert into control_objects (obj_id, app_id, obj_name) values (50, 1, 'ApproveForPendingDeployment')
 64 
insert into control_objects (obj_id, app_id, obj_name) values (50, 1, 'ApproveForPendingDeployment');
70 
insert into control_objects (obj_id, app_id, obj_name) values (51, 1, 'ApproveForPendingIntegration')
 65 
insert into control_objects (obj_id, app_id, obj_name) values (51, 1, 'ApproveForPendingIntegration');
71 
insert into control_objects (obj_id, app_id, obj_name) values (52, 1, 'ApproveForPendingTest')
 66 
insert into control_objects (obj_id, app_id, obj_name) values (52, 1, 'ApproveForPendingTest');
72 
insert into control_objects (obj_id, app_id, obj_name) values (53, 1, 'RejectProduct')
 67 
insert into control_objects (obj_id, app_id, obj_name) values (53, 1, 'RejectProduct');
73 
insert into control_objects (obj_id, app_id, obj_name) values (54, 1, 'ApprovePendingIntegrateAndDeploy')
 68 
insert into control_objects (obj_id, app_id, obj_name) values (54, 1, 'ApprovePendingIntegrateAndDeploy');
74 
insert into control_objects (obj_id, app_id, obj_name) values (55, 1, 'DestroyPackageFromRelease')
 69 
insert into control_objects (obj_id, app_id, obj_name) values (55, 1, 'DestroyPackageFromRelease');
75 
insert into control_objects (obj_id, app_id, obj_name) values (56, 1, 'EditNonCriticalInfoForLockedPackage')
 70 
insert into control_objects (obj_id, app_id, obj_name) values (56, 1, 'EditNonCriticalInfoForLockedPackage');
76 
insert into control_objects (obj_id, app_id, obj_name) values (57, 1, 'EditCriticalInfoForLockedPackage')
 71 
insert into control_objects (obj_id, app_id, obj_name) values (57, 1, 'EditCriticalInfoForLockedPackage');
77 
 
 72 
 
78 
insert into roles (role_id, app_id, role_name) values (1, 1, 'Deployment Manager developer')
 73 
insert into roles (role_id, app_id, role_name) values (1, 1, 'Deployment Manager developer');
79 
insert into roles (role_id, app_id, role_name) values (2, 2, 'Release Manager developer')
 74 
insert into roles (role_id, app_id, role_name) values (2, 2, 'Release Manager developer');
80 
insert into roles (role_id, app_id, role_name) values (3, 9, 'Access Manager developer')
 75 
insert into roles (role_id, app_id, role_name) values (3, 9, 'Access Manager developer');
81 
insert into roles (role_id, app_id, role_name) values (4, 10, 'Production Manager developer')
 76 
insert into roles (role_id, app_id, role_name) values (4, 10, 'Production Manager developer');
82 
 
 77 
 
83 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 1, 'Y');
 78 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 1, 'Y');
84 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 2, 'Y');
 79 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 2, 'Y');
85 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 1, 'Y');
 80 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 1, 'Y');
86 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 2, 'Y');
 81 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 2, 'Y');
Line 530... Line 525...
530 
insert into user_roles (user_id, role_id) values (1, 4);
 525 
insert into user_roles (user_id, role_id) values (1, 4);
531 
insert into user_roles (user_id, role_id) values (2, 1);
 526 
insert into user_roles (user_id, role_id) values (2, 1);
532 
insert into user_roles (user_id, role_id) values (2, 2);
 527 
insert into user_roles (user_id, role_id) values (2, 2);
533 
insert into user_roles (user_id, role_id) values (2, 3);
 528 
insert into user_roles (user_id, role_id) values (2, 3);
534 
insert into user_roles (user_id, role_id) values (2, 4);
 529 
insert into user_roles (user_id, role_id) values (2, 4);
- 
 
 530 
 
- 
 
 531 
insert into data_tables (dt_id, obj_id, table_name, ref_column_name, display_column_name) values (1, 12, 'PROJECTS', 'x', 'x');
- 
 
 532 
 
- 
 
 533 
insert into build_standards (BS_ID, BS_NAME) values
- 
 
 534 
(1, 'JATS');
- 
 
 535 
insert into build_standards (BS_ID, BS_NAME) values
- 
 
 536 
(2, 'ANT');
- 
 
 537 
insert into build_standards (BS_ID, BS_NAME) values
- 
 
 538 
(3, 'NONE');
- 
 
 539 
 
- 
 
 540 
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
- 
 
 541 
(1, 'Debug', 1);
- 
 
 542 
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
- 
 
 543 
(2, 'Production', 1);
- 
 
 544 
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
- 
 
 545 
(3, 'Production and Debug', 1);
- 
 
 546 
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
- 
 
 547 
(4, 'Java 1.4', 2);
- 
 
 548 
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
- 
 
 549 
(5, 'Java 1.5', 2);
- 
 
 550 
insert into build_standards_addendum (BSA_ID, BSA_NAME, BS_ID) values
- 
 
 551 
(6, 'Java 1.6', 2);
- 
 
 552 
 
- 
 
 553 
insert into test_types(TEST_TYPE_ID, TEST_TYPE_NAME, DISPLAY_ORDER) values
- 
 
 554 
(1, 'Not Done', null);
- 
 
 555 
insert into test_types(TEST_TYPE_ID, TEST_TYPE_NAME, DISPLAY_ORDER) values
- 
 
 556 
(5, 'Automatic Unit Test', 1);
- 
 
 557 
insert into test_types(TEST_TYPE_ID, TEST_TYPE_NAME, DISPLAY_ORDER) values
- 
 
 558 
(6, 'Interactive Unit Test', 2);
- 
 
 559 
insert into test_types(TEST_TYPE_ID, TEST_TYPE_NAME, DISPLAY_ORDER) values
- 
 
 560 
(7, 'Autobuild UTF', 3);
- 
 
 561 
 
- 
 
 562 
insert into build_machines(BM_ID, BM_NAME) values
- 
 
 563 
(1, 'Solaris');
- 
 
 564 
insert into build_machines(BM_ID, BM_NAME) values
- 
 
 565 
(2, 'Win32');
- 
 
 566 
insert into build_machines(BM_ID, BM_NAME) values
- 
 
 567 
(3, 'Linux');
- 
 
 568 
insert into build_machines(BM_ID, BM_NAME) values
- 
 
 569 
(4, 'Generic');
- 
 
 570 
 
- 
 
 571 
insert into projects (proj_id, proj_name) values (1, 'TIMBUKTU');
- 
 
 572 
 
- 
 
 573 
insert into views (view_id, view_name, owner_id, base_view, public_read) values
- 
 
 574 
(1, 'viewbar', 0, 'Y', 'Y');
- 
 
 575 
insert into views (view_id, view_name, owner_id, base_view, public_read) values
- 
 
 576 
(9999, 'PROJECT WIDE', 0, 'N', 'Y');
- 
 
 577 
 
- 
 
 578 
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
- 
 
 579 
(1, 1, 'foobar', '17-JUN-08', 2, 'N', 'N', 0, 1, 1, 1);
- 
 
 580 
 
- 
 
 581 
insert into packages (pkg_id, pkg_name) values (1, 'aardvark');
- 
 
 582 
 
- 
 
 583 
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
- 
 
 584 
(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');
- 
 
 585 
 
- 
 
 586 
insert into unit_tests (test_id, pv_id, test_types_fk, completion_date, completed_by) values
- 
 
 587 
(1, 1, 1, '19-JUN-08', 2);
- 
 
 588 
 
- 
 
 589 
insert into package_build_info (pv_id, bm_id, bsa_id) values
- 
 
 590 
(1, 4, 3);
- 
 
 591 
 
- 
 
 592 
insert into release_content (rtag_id, pv_id, base_view_id, insert_stamp, insertor_id, pkg_state) values
- 
 
 593 
(1, 1, 1, '24-JUN-08', 2, 0);