Subversion Repositories DevTools

Rev

Rev 53 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
53 mhunt 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');
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');
51 mhunt 5 
 
53 mhunt 6 
insert into users (user_id, full_name, user_name, user_password) values (1, 'dev', 'dev1', 'dev');
7 
insert into users (user_id, full_name, user_name, user_password) values (2, 'dev', 'dev2', PK_AMUTILS.GET_HASH( 'dev' ));
51 mhunt 8 
 
53 mhunt 9 
insert into user_applications (user_id, app_id) values (1, 9);
10 
insert into user_applications (user_id, app_id) values (2, 2);
11 
insert into user_applications (user_id, app_id) values (2, 1);
12 
insert into user_applications (user_id, app_id) values (2, 10);
51 mhunt 13 
 
53 mhunt 14 
insert into permission_types (perm_id, perm_name) values (1, 'enumVISIBLE');
15 
insert into permission_types (perm_id, perm_name) values (2, 'enumACTIVE');
51 mhunt 16 
 
53 mhunt 17 
insert into control_objects (obj_id, app_id, obj_name) values (1, 1, 'pmoCreator');
18 
insert into control_objects (obj_id, app_id, obj_name) values (2, 1, 'pmoTester');
19 
insert into control_objects (obj_id, app_id, obj_name) values (3, 1, 'pmoExternalTester');
20 
insert into control_objects (obj_id, app_id, obj_name) values (4, 1, 'oProjectList');
21 
insert into control_objects (obj_id, app_id, obj_name) values (5, 1, 'EditPackageInExternalProjects');
22 
insert into control_objects (obj_id, app_id, obj_name) values (6, 1, 'AddReleaseReference');
23 
insert into control_objects (obj_id, app_id, obj_name) values (7, 1, 'pageApplicationConfiguration');
24 
insert into control_objects (obj_id, app_id, obj_name) values (8, 1, 'onApplicationOffline');
25 
insert into control_objects (obj_id, app_id, obj_name) values (10, 1, 'UnlockPackage');
26 
insert into control_objects (obj_id, app_id, obj_name) values (11, 1, 'DestroyPackage');
27 
insert into control_objects (obj_id, app_id, obj_name) values (12, 1, 'EditProjects');
28 
insert into control_objects (obj_id, app_id, obj_name) values (13, 1, 'ApproveForAutoBuild');
29 
insert into control_objects (obj_id, app_id, obj_name) values (14, 1, 'RemoveReleaseReference');
30 
insert into control_objects (obj_id, app_id, obj_name) values (15, 1, 'ApprovePackageReleaseForRestrictiveMode');
31 
insert into control_objects (obj_id, app_id, obj_name) values (16, 1, 'RejectPackageFromPending');
32 
insert into control_objects (obj_id, app_id, obj_name) values (17, 1, 'ChangeModeFromClosed');
33 
insert into control_objects (obj_id, app_id, obj_name) values (18, 1, 'ChangeModeFromRestrictive');
34 
insert into control_objects (obj_id, app_id, obj_name) values (19, 1, 'CloneReleaseContents');
35 
insert into control_objects (obj_id, app_id, obj_name) values (20, 1, 'DestroyRelease');
36 
insert into control_objects (obj_id, app_id, obj_name) values (21, 1, 'CreateNewRelease');
37 
insert into control_objects (obj_id, app_id, obj_name) values (22, 1, 'MergeRelease');
38 
insert into control_objects (obj_id, app_id, obj_name) values (23, 1, 'AlterReleaseContentsInRestrictiveMode');
39 
insert into control_objects (obj_id, app_id, obj_name) values (24, 1, 'ImportOpenIssues');
40 
insert into control_objects (obj_id, app_id, obj_name) values (25, 1, 'CreateNewProject');
41 
insert into control_objects (obj_id, app_id, obj_name) values (26, 1, 'ChangePreviousVersion');
42 
insert into control_objects (obj_id, app_id, obj_name) values (27, 1, 'ImportDependencies');
43 
insert into control_objects (obj_id, app_id, obj_name) values (28, 1, 'ImportVasttrafikIssues');
44 
insert into control_objects (obj_id, app_id, obj_name) values (29, 1, 'AddDeletePackageInRestrictiveMode');
45 
insert into control_objects (obj_id, app_id, obj_name) values (30, 1, 'RemovePackage');
46 
insert into control_objects (obj_id, app_id, obj_name) values (31, 1, 'ApproveForManualBuild');
47 
insert into control_objects (obj_id, app_id, obj_name) values (32, 1, 'RipplePackage');
48 
insert into control_objects (obj_id, app_id, obj_name) values (33, 1, 'ReleasePatch');
49 
insert into control_objects (obj_id, app_id, obj_name) values (34, 1, 'mergeManager');
50 
insert into control_objects (obj_id, app_id, obj_name) values (35, 1, 'MergeReleaseForCCB');
51 
insert into control_objects (obj_id, app_id, obj_name) values (36, 1, 'DeprecatePackage');
52 
insert into control_objects (obj_id, app_id, obj_name) values (37, 1, 'AdminView');
53 
insert into control_objects (obj_id, app_id, obj_name) values (38, 1, 'EditReleaseNotesInPending');
54 
insert into control_objects (obj_id, app_id, obj_name) values (39, 1, 'DeleteOutstandingIssues');
55 
insert into control_objects (obj_id, app_id, obj_name) values (40, 1, 'UnlockPatch');
56 
insert into control_objects (obj_id, app_id, obj_name) values (41, 1, 'ApprovedByManager');
57 
insert into control_objects (obj_id, app_id, obj_name) values (42, 1, 'ApprovedByTester');
58 
insert into control_objects (obj_id, app_id, obj_name) values (44, 1, 'ChangeVersion');
59 
insert into control_objects (obj_id, app_id, obj_name) values (45, 1, 'GMPTE');
60 
insert into control_objects (obj_id, app_id, obj_name) values (46, 1, 'SanFrancisco');
61 
insert into control_objects (obj_id, app_id, obj_name) values (47, 1, 'ConfigureBuildService');
62 
insert into control_objects (obj_id, app_id, obj_name) values (48, 1, 'ConfigureRelease');
63 
insert into control_objects (obj_id, app_id, obj_name) values (49, 1, 'SetToReproducible');
64 
insert into control_objects (obj_id, app_id, obj_name) values (50, 1, 'ApproveForPendingDeployment');
65 
insert into control_objects (obj_id, app_id, obj_name) values (51, 1, 'ApproveForPendingIntegration');
66 
insert into control_objects (obj_id, app_id, obj_name) values (52, 1, 'ApproveForPendingTest');
67 
insert into control_objects (obj_id, app_id, obj_name) values (53, 1, 'RejectProduct');
68 
insert into control_objects (obj_id, app_id, obj_name) values (54, 1, 'ApprovePendingIntegrateAndDeploy');
69 
insert into control_objects (obj_id, app_id, obj_name) values (55, 1, 'DestroyPackageFromRelease');
70 
insert into control_objects (obj_id, app_id, obj_name) values (56, 1, 'EditNonCriticalInfoForLockedPackage');
71 
insert into control_objects (obj_id, app_id, obj_name) values (57, 1, 'EditCriticalInfoForLockedPackage');
51 mhunt 72 
 
53 mhunt 73 
insert into roles (role_id, app_id, role_name) values (1, 1, 'Deployment Manager developer');
74 
insert into roles (role_id, app_id, role_name) values (2, 2, 'Release Manager developer');
75 
insert into roles (role_id, app_id, role_name) values (3, 9, 'Access Manager developer');
76 
insert into roles (role_id, app_id, role_name) values (4, 10, 'Production Manager developer');
51 mhunt 77 
 
78 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 1, 'Y');
79 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 2, 'Y');
80 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 1, 'Y');
81 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 2, 'Y');
82 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 3, 1, 'Y');
83 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 3, 2, 'Y');
84 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 4, 1, 'Y');
85 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 4, 2, 'Y');
86 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 5, 1, 'Y');
87 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 5, 2, 'Y');
88 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 6, 1, 'Y');
89 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 6, 2, 'Y');
90 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 7, 1, 'Y');
91 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 7, 2, 'Y');
92 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 8, 1, 'Y');
93 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 8, 2, 'Y');
94 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 10, 1, 'Y');
95 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 10, 2, 'Y');
96 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 11, 1, 'Y');
97 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 11, 2, 'Y');
98 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 12, 1, 'Y');
99 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 12, 2, 'Y');
100 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 13, 1, 'Y');
101 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 13, 2, 'Y');
102 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 14, 1, 'Y');
103 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 14, 2, 'Y');
104 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 15, 1, 'Y');
105 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 15, 2, 'Y');
106 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 16, 1, 'Y');
107 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 16, 2, 'Y');
108 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 17, 1, 'Y');
109 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 17, 2, 'Y');
110 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 18, 1, 'Y');
111 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 18, 2, 'Y');
112 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 19, 1, 'Y');
113 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 19, 2, 'Y');
114 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 20, 1, 'Y');
115 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 20, 2, 'Y');
116 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 21, 1, 'Y');
117 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 21, 2, 'Y');
118 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 22, 1, 'Y');
119 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 22, 2, 'Y');
120 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 23, 1, 'Y');
121 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 23, 2, 'Y');
122 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 24, 1, 'Y');
123 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 24, 2, 'Y');
124 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 25, 1, 'Y');
125 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 25, 2, 'Y');
126 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 26, 1, 'Y');
127 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 26, 2, 'Y');
128 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 27, 1, 'Y');
129 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 27, 2, 'Y');
130 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 28, 1, 'Y');
131 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 28, 2, 'Y');
132 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 29, 1, 'Y');
133 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 29, 2, 'Y');
134 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 30, 1, 'Y');
135 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 30, 2, 'Y');
136 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 31, 1, 'Y');
137 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 31, 2, 'Y');
138 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 32, 1, 'Y');
139 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 32, 2, 'Y');
140 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 33, 1, 'Y');
141 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 33, 2, 'Y');
142 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 34, 1, 'Y');
143 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 34, 2, 'Y');
144 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 35, 1, 'Y');
145 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 35, 2, 'Y');
146 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 36, 1, 'Y');
147 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 36, 2, 'Y');
148 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 37, 1, 'Y');
149 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 37, 2, 'Y');
150 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 38, 1, 'Y');
151 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 38, 2, 'Y');
152 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 39, 1, 'Y');
153 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 39, 2, 'Y');
154 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 40, 1, 'Y');
155 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 40, 2, 'Y');
156 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 41, 1, 'Y');
157 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 41, 2, 'Y');
158 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 42, 1, 'Y');
159 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 42, 2, 'Y');
160 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 44, 1, 'Y');
161 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 44, 2, 'Y');
162 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 45, 1, 'Y');
163 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 45, 2, 'Y');
164 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 46, 1, 'Y');
165 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 46, 2, 'Y');
166 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 47, 1, 'Y');
167 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 47, 2, 'Y');
168 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 48, 1, 'Y');
169 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 48, 2, 'Y');
170 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 49, 1, 'Y');
171 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 49, 2, 'Y');
172 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 50, 1, 'Y');
173 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 50, 2, 'Y');
174 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 51, 1, 'Y');
175 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 51, 2, 'Y');
176 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 52, 1, 'Y');
177 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 52, 2, 'Y');
178 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 53, 1, 'Y');
179 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 53, 2, 'Y');
180 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 54, 1, 'Y');
181 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 54, 2, 'Y');
182 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 55, 1, 'Y');
183 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 55, 2, 'Y');
184 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 56, 1, 'Y');
185 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 56, 2, 'Y');
186 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 57, 1, 'Y');
187 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 57, 2, 'Y');
188 
 
189 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 1, 1, 'Y');
190 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 1, 2, 'Y');
191 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 2, 1, 'Y');
192 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 2, 2, 'Y');
193 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 3, 1, 'Y');
194 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 3, 2, 'Y');
195 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 4, 1, 'Y');
196 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 4, 2, 'Y');
197 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 5, 1, 'Y');
198 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 5, 2, 'Y');
199 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 6, 1, 'Y');
200 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 6, 2, 'Y');
201 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 7, 1, 'Y');
202 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 7, 2, 'Y');
203 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 8, 1, 'Y');
204 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 8, 2, 'Y');
205 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 10, 1, 'Y');
206 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 10, 2, 'Y');
207 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 11, 1, 'Y');
208 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 11, 2, 'Y');
209 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 12, 1, 'Y');
210 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 12, 2, 'Y');
211 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 13, 1, 'Y');
212 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 13, 2, 'Y');
213 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 14, 1, 'Y');
214 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 14, 2, 'Y');
215 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 15, 1, 'Y');
216 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 15, 2, 'Y');
217 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 16, 1, 'Y');
218 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 16, 2, 'Y');
219 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 17, 1, 'Y');
220 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 17, 2, 'Y');
221 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 18, 1, 'Y');
222 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 18, 2, 'Y');
223 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 19, 1, 'Y');
224 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 19, 2, 'Y');
225 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 20, 1, 'Y');
226 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 20, 2, 'Y');
227 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 21, 1, 'Y');
228 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 21, 2, 'Y');
229 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 22, 1, 'Y');
230 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 22, 2, 'Y');
231 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 23, 1, 'Y');
232 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 23, 2, 'Y');
233 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 24, 1, 'Y');
234 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 24, 2, 'Y');
235 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 25, 1, 'Y');
236 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 25, 2, 'Y');
237 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 26, 1, 'Y');
238 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 26, 2, 'Y');
239 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 27, 1, 'Y');
240 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 27, 2, 'Y');
241 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 28, 1, 'Y');
242 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 28, 2, 'Y');
243 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 29, 1, 'Y');
244 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 29, 2, 'Y');
245 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 30, 1, 'Y');
246 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 30, 2, 'Y');
247 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 31, 1, 'Y');
248 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 31, 2, 'Y');
249 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 32, 1, 'Y');
250 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 32, 2, 'Y');
251 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 33, 1, 'Y');
252 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 33, 2, 'Y');
253 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 34, 1, 'Y');
254 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 34, 2, 'Y');
255 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 35, 1, 'Y');
256 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 35, 2, 'Y');
257 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 36, 1, 'Y');
258 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 36, 2, 'Y');
259 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 37, 1, 'Y');
260 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 37, 2, 'Y');
261 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 38, 1, 'Y');
262 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 38, 2, 'Y');
263 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 39, 1, 'Y');
264 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 39, 2, 'Y');
265 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 40, 1, 'Y');
266 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 40, 2, 'Y');
267 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 41, 1, 'Y');
268 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 41, 2, 'Y');
269 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 42, 1, 'Y');
270 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 42, 2, 'Y');
271 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 44, 1, 'Y');
272 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 44, 2, 'Y');
273 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 45, 1, 'Y');
274 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 45, 2, 'Y');
275 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 46, 1, 'Y');
276 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 46, 2, 'Y');
277 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 47, 1, 'Y');
278 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 47, 2, 'Y');
279 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 48, 1, 'Y');
280 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 48, 2, 'Y');
281 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 49, 1, 'Y');
282 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 49, 2, 'Y');
283 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 50, 1, 'Y');
284 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 50, 2, 'Y');
285 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 51, 1, 'Y');
286 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 51, 2, 'Y');
287 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 52, 1, 'Y');
288 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 52, 2, 'Y');
289 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 53, 1, 'Y');
290 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 53, 2, 'Y');
291 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 54, 1, 'Y');
292 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 54, 2, 'Y');
293 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 55, 1, 'Y');
294 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 55, 2, 'Y');
295 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 56, 1, 'Y');
296 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 56, 2, 'Y');
297 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 57, 1, 'Y');
298 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 57, 2, 'Y');
299 
 
300 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 1, 1, 'Y');
301 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 1, 2, 'Y');
302 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 2, 1, 'Y');
303 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 2, 2, 'Y');
304 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 3, 1, 'Y');
305 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 3, 2, 'Y');
306 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 4, 1, 'Y');
307 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 4, 2, 'Y');
308 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 5, 1, 'Y');
309 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 5, 2, 'Y');
310 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 6, 1, 'Y');
311 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 6, 2, 'Y');
312 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 7, 1, 'Y');
313 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 7, 2, 'Y');
314 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 8, 1, 'Y');
315 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 8, 2, 'Y');
316 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 10, 1, 'Y');
317 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 10, 2, 'Y');
318 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 11, 1, 'Y');
319 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 11, 2, 'Y');
320 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 12, 1, 'Y');
321 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 12, 2, 'Y');
322 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 13, 1, 'Y');
323 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 13, 2, 'Y');
324 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 14, 1, 'Y');
325 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 14, 2, 'Y');
326 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 15, 1, 'Y');
327 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 15, 2, 'Y');
328 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 16, 1, 'Y');
329 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 16, 2, 'Y');
330 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 17, 1, 'Y');
331 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 17, 2, 'Y');
332 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 18, 1, 'Y');
333 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 18, 2, 'Y');
334 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 19, 1, 'Y');
335 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 19, 2, 'Y');
336 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 20, 1, 'Y');
337 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 20, 2, 'Y');
338 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 21, 1, 'Y');
339 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 21, 2, 'Y');
340 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 22, 1, 'Y');
341 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 22, 2, 'Y');
342 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 23, 1, 'Y');
343 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 23, 2, 'Y');
344 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 24, 1, 'Y');
345 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 24, 2, 'Y');
346 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 25, 1, 'Y');
347 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 25, 2, 'Y');
348 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 26, 1, 'Y');
349 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 26, 2, 'Y');
350 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 27, 1, 'Y');
351 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 27, 2, 'Y');
352 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 28, 1, 'Y');
353 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 28, 2, 'Y');
354 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 29, 1, 'Y');
355 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 29, 2, 'Y');
356 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 30, 1, 'Y');
357 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 30, 2, 'Y');
358 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 31, 1, 'Y');
359 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 31, 2, 'Y');
360 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 32, 1, 'Y');
361 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 32, 2, 'Y');
362 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 33, 1, 'Y');
363 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 33, 2, 'Y');
364 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 34, 1, 'Y');
365 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 34, 2, 'Y');
366 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 35, 1, 'Y');
367 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 35, 2, 'Y');
368 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 36, 1, 'Y');
369 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 36, 2, 'Y');
370 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 37, 1, 'Y');
371 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 37, 2, 'Y');
372 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 38, 1, 'Y');
373 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 38, 2, 'Y');
374 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 39, 1, 'Y');
375 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 39, 2, 'Y');
376 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 40, 1, 'Y');
377 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 40, 2, 'Y');
378 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 41, 1, 'Y');
379 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 41, 2, 'Y');
380 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 42, 1, 'Y');
381 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 42, 2, 'Y');
382 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 44, 1, 'Y');
383 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 44, 2, 'Y');
384 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 45, 1, 'Y');
385 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 45, 2, 'Y');
386 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 46, 1, 'Y');
387 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 46, 2, 'Y');
388 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 47, 1, 'Y');
389 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 47, 2, 'Y');
390 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 48, 1, 'Y');
391 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 48, 2, 'Y');
392 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 49, 1, 'Y');
393 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 49, 2, 'Y');
394 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 50, 1, 'Y');
395 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 50, 2, 'Y');
396 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 51, 1, 'Y');
397 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 51, 2, 'Y');
398 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 52, 1, 'Y');
399 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 52, 2, 'Y');
400 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 53, 1, 'Y');
401 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 53, 2, 'Y');
402 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 54, 1, 'Y');
403 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 54, 2, 'Y');
404 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 55, 1, 'Y');
405 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 55, 2, 'Y');
406 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 56, 1, 'Y');
407 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 56, 2, 'Y');
408 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 57, 1, 'Y');
409 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 57, 2, 'Y');
410 
 
411 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 1, 1, 'Y');
412 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 1, 2, 'Y');
413 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 2, 1, 'Y');
414 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 2, 2, 'Y');
415 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 3, 1, 'Y');
416 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 3, 2, 'Y');
417 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 4, 1, 'Y');
418 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 4, 2, 'Y');
419 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 5, 1, 'Y');
420 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 5, 2, 'Y');
421 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 6, 1, 'Y');
422 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 6, 2, 'Y');
423 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 7, 1, 'Y');
424 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 7, 2, 'Y');
425 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 8, 1, 'Y');
426 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 8, 2, 'Y');
427 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 10, 1, 'Y');
428 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 10, 2, 'Y');
429 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 11, 1, 'Y');
430 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 11, 2, 'Y');
431 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 12, 1, 'Y');
432 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 12, 2, 'Y');
433 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 13, 1, 'Y');
434 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 13, 2, 'Y');
435 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 14, 1, 'Y');
436 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 14, 2, 'Y');
437 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 15, 1, 'Y');
438 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 15, 2, 'Y');
439 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 16, 1, 'Y');
440 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 16, 2, 'Y');
441 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 17, 1, 'Y');
442 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 17, 2, 'Y');
443 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 18, 1, 'Y');
444 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 18, 2, 'Y');
445 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 19, 1, 'Y');
446 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 19, 2, 'Y');
447 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 20, 1, 'Y');
448 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 20, 2, 'Y');
449 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 21, 1, 'Y');
450 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 21, 2, 'Y');
451 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 22, 1, 'Y');
452 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 22, 2, 'Y');
453 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 23, 1, 'Y');
454 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 23, 2, 'Y');
455 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 24, 1, 'Y');
456 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 24, 2, 'Y');
457 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 25, 1, 'Y');
458 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 25, 2, 'Y');
459 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 26, 1, 'Y');
460 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 26, 2, 'Y');
461 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 27, 1, 'Y');
462 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 27, 2, 'Y');
463 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 28, 1, 'Y');
464 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 28, 2, 'Y');
465 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 29, 1, 'Y');
466 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 29, 2, 'Y');
467 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 30, 1, 'Y');
468 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 30, 2, 'Y');
469 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 31, 1, 'Y');
470 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 31, 2, 'Y');
471 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 32, 1, 'Y');
472 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 32, 2, 'Y');
473 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 33, 1, 'Y');
474 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 33, 2, 'Y');
475 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 34, 1, 'Y');
476 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 34, 2, 'Y');
477 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 35, 1, 'Y');
478 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 35, 2, 'Y');
479 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 36, 1, 'Y');
480 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 36, 2, 'Y');
481 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 37, 1, 'Y');
482 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 37, 2, 'Y');
483 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 38, 1, 'Y');
484 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 38, 2, 'Y');
485 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 39, 1, 'Y');
486 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 39, 2, 'Y');
487 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 40, 1, 'Y');
488 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 40, 2, 'Y');
489 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 41, 1, 'Y');
490 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 41, 2, 'Y');
491 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 42, 1, 'Y');
492 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 42, 2, 'Y');
493 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 44, 1, 'Y');
494 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 44, 2, 'Y');
495 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 45, 1, 'Y');
496 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 45, 2, 'Y');
497 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 46, 1, 'Y');
498 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 46, 2, 'Y');
499 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 47, 1, 'Y');
500 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 47, 2, 'Y');
501 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 48, 1, 'Y');
502 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 48, 2, 'Y');
503 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 49, 1, 'Y');
504 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 49, 2, 'Y');
505 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 50, 1, 'Y');
506 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 50, 2, 'Y');
507 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 51, 1, 'Y');
508 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 51, 2, 'Y');
509 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 52, 1, 'Y');
510 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 52, 2, 'Y');
511 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 53, 1, 'Y');
512 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 53, 2, 'Y');
513 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 54, 1, 'Y');
514 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 54, 2, 'Y');
515 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 55, 1, 'Y');
516 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 55, 2, 'Y');
517 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 56, 1, 'Y');
518 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 56, 2, 'Y');
519 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 57, 1, 'Y');
520 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 57, 2, 'Y');
521 
 
522 
insert into user_roles (user_id, role_id) values (1, 1);
523 
insert into user_roles (user_id, role_id) values (1, 2);
524 
insert into user_roles (user_id, role_id) values (1, 3);
525 
insert into user_roles (user_id, role_id) values (1, 4);
526 
insert into user_roles (user_id, role_id) values (2, 1);
527 
insert into user_roles (user_id, role_id) values (2, 2);
528 
insert into user_roles (user_id, role_id) values (2, 3);
529 
insert into user_roles (user_id, role_id) values (2, 4);
53 mhunt 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);
57 mhunt 594 
 
595 
insert into licences (licence, name) values (1, 'GPL');
596 
insert into licences (licence, name) values (2, 'LGPL');