00001
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031 #include "rodsClient.h"
00032 #include "icatHighLevelRoutines.h"
00033 #ifdef EXTENDED_ICAT
00034 #define EXTENDED_ICAT_TABLES_2 1
00035 #include "extendedICAT.h"
00036 #endif
00037
00038 void
00039 icatGeneralQuerySetup() {
00040 #ifdef EXTENDED_ICAT
00041 int i;
00042 #endif
00043 sTableInit();
00044
00045 sTable( "R_USER_PASSWORD", "R_USER_PASSWORD", 0);
00046 sTable( "R_USER_SESSION_KEY", "R_USER_SESSION_KEY", 0);
00047 sTable( "R_TOKN_MAIN", "R_TOKN_MAIN", 0);
00048 sTable( "R_RESC_GROUP", "R_RESC_GROUP", 0);
00049 sTable( "R_ZONE_MAIN", "R_ZONE_MAIN", 0);
00050 sTable( "R_RESC_MAIN", "R_RESC_MAIN", 0);
00051 sTable( "R_COLL_MAIN", "R_COLL_MAIN", 0);
00052 sTable( "R_DATA_MAIN", "R_DATA_MAIN", 0);
00053
00054 sTable( "r_met2_main", "R_META_MAIN r_met2_main" ,0);
00055 sTable( "R_META_MAIN", "R_META_MAIN" , 0);
00056
00057 sTable( "R_RULE_MAIN", "R_RULE_MAIN", 0);
00058 sTable( "R_USER_MAIN", "R_USER_MAIN", 0);
00059 sTable( "r_resc_access", "R_OBJT_ACCESS r_resc_access", 0);
00060 sTable( "r_coll_access", "R_OBJT_ACCESS r_coll_access", 0);
00061 sTable( "r_data_access", "R_OBJT_ACCESS r_data_access", 0);
00062 sTable( "r_met2_access", "R_OBJT_ACCESS r_met2_access", 0);
00063 sTable( "r_rule_access", "R_OBJT_ACCESS r_rule_access", 0);
00064 sTable( "r_msrvc_access", "R_OBJT_ACCESS r_msrvc_access", 0);
00065 sTable( "r_resc_audit", "R_OBJT_AUDIT r_resc_audit", 0);
00066 sTable( "r_coll_audit", "R_OBJT_AUDIT r_coll_audit", 0);
00067 sTable( "r_data_audit", "R_OBJT_AUDIT r_data_audit", 0);
00068 sTable( "r_met2_audit", "R_OBJT_AUDIT r_met2_audit", 0);
00069 sTable( "r_rule_audit", "R_OBJT_AUDIT r_rule_audit", 0);
00070 sTable( "r_resc_deny_access", "R_OBJT_DENY_ACCESS r_resc_deny_access", 0);
00071 sTable( "r_coll_deny_access", "R_OBJT_DENY_ACCESS r_coll_deny_access", 0);
00072 sTable( "r_data_deny_access", "R_OBJT_DENY_ACCESS r_data_deny_access", 0);
00073 sTable( "r_met2_deny_access", "R_OBJT_DENY_ACCESS r_met2_deny_access", 0);
00074 sTable( "r_rule_deny_access", "R_OBJT_DENY_ACCESS r_rule_deny_access", 0);
00075 sTable( "r_resc_metamap", "R_OBJT_METAMAP r_resc_metamap", 0);
00076 sTable( "r_resc_grp_metamap", "R_OBJT_METAMAP r_resc_grp_metamap", 0);
00077 sTable( "r_coll_metamap", "R_OBJT_METAMAP r_coll_metamap", 0);
00078 sTable( "r_data_metamap", "R_OBJT_METAMAP r_data_metamap", 0);
00079 sTable( "r_met2_metamap", "R_OBJT_METAMAP r_met2_metamap", 0);
00080 sTable( "r_rule_metamap", "R_OBJT_METAMAP r_rule_metamap", 0);
00081 sTable( "r_msrvc_metamap", "R_OBJT_METAMAP r_msrvc_metamap", 0);
00082 sTable( "r_user_metamap", "R_OBJT_METAMAP r_user_metamap", 0);
00083 sTable( "r_resc_user_group", "R_USER_GROUP r_resc_user_group", 0);
00084 sTable( "r_coll_user_group", "R_USER_GROUP r_coll_user_group", 0);
00085 sTable( "r_data_user_group", "R_USER_GROUP r_data_user_group", 0);
00086 sTable( "r_met2_user_group", "R_USER_GROUP r_met2_user_group", 0);
00087 sTable( "r_rule_user_group", "R_USER_GROUP r_rule_user_group", 0);
00088 sTable( "r_resc_da_user_group", "R_USER_GROUP r_resc_da_user_group", 0);
00089 sTable( "r_coll_da_user_group", "R_USER_GROUP r_coll_da_user_group", 0);
00090 sTable( "r_data_da_user_group", "R_USER_GROUP r_data_da_user_group", 0);
00091 sTable( "r_met2_da_user_group", "R_USER_GROUP r_met2_da_user_group", 0);
00092 sTable( "r_rule_da_user_group", "R_USER_GROUP r_rule_da_user_group", 0);
00093
00094 sTable( "r_resc_au_user_group", "R_USER_GROUP r_resc_au_user_group", 0);
00095 sTable( "r_coll_au_user_group", "R_USER_GROUP r_coll_au_user_group", 0);
00096 sTable( "r_data_au_user_group", "R_USER_GROUP r_data_au_user_group", 0);
00097 sTable( "r_met2_au_user_group", "R_USER_GROUP r_met2_au_user_group", 0);
00098 sTable( "r_rule_au_user_group", "R_USER_GROUP r_rule_au_user_group", 0);
00099 sTable( "r_resc_user_main", "R_USER_MAIN r_resc_user_main", 0);
00100 sTable( "r_coll_user_main", "R_USER_MAIN r_coll_user_main", 0);
00101 sTable( "r_data_user_main", "R_USER_MAIN r_data_user_main", 0);
00102 sTable( "r_met2_user_main", "R_USER_MAIN r_met2_user_main", 0);
00103 sTable( "r_rule_user_main", "R_USER_MAIN r_rule_user_main", 0);
00104 sTable( "r_resc_da_user_main", "R_USER_MAIN r_resc_da_user_main", 0);
00105 sTable( "r_coll_da_user_main", "R_USER_MAIN r_coll_da_user_main", 0);
00106 sTable( "r_data_da_user_main", "R_USER_MAIN r_data_da_user_main", 0);
00107 sTable( "r_met2_da_user_main", "R_USER_MAIN r_met2_da_user_main", 0);
00108 sTable( "r_rule_da_user_main", "R_USER_MAIN r_rule_da_user_main", 0);
00109 sTable( "r_resc_au_user_main", "R_USER_MAIN r_resc_au_user_main", 0);
00110 sTable( "r_coll_au_user_main", "R_USER_MAIN r_coll_au_user_main", 0);
00111 sTable( "r_data_au_user_main", "R_USER_MAIN r_data_au_user_main", 0);
00112 sTable( "r_met2_au_user_main", "R_USER_MAIN r_met2_au_user_main", 0);
00113 sTable( "r_rule_au_user_main", "R_USER_MAIN r_rule_au_user_main", 0);
00114
00115 sTable( "r_quota_user_main", "R_USER_MAIN r_quota_user_main", 1);
00116 sTable( "r_quota_user_group", "R_USER_MAIN r_quota_user_group", 1);
00117 sTable( "r_quota_resc_main", "R_RESC_MAIN r_quota_resc_main", 1);
00118
00119 sTable( "r_resc_tokn_accs", "R_TOKN_MAIN r_resc_tokn_accs", 0);
00120 sTable( "r_coll_tokn_accs", "R_TOKN_MAIN r_coll_tokn_accs", 0);
00121 sTable( "r_data_tokn_accs", "R_TOKN_MAIN r_data_tokn_accs", 0);
00122
00123 sTable( "r_rule_tokn_accs", "R_TOKN_MAIN r_rule_tokn_accs", 0);
00124 sTable( "r_met2_tokn_accs", "R_TOKN_MAIN r_met2_tokn_accs", 0);
00125 sTable( "r_resc_tokn_deny_accs", "R_TOKN_MAIN r_resc_tokn_deny_accs", 0);
00126 sTable( "r_coll_tokn_deny_accs", "R_TOKN_MAIN r_coll_tokn_deny_accs", 0);
00127 sTable( "r_data_tokn_deny_accs", "R_TOKN_MAIN r_data_tokn_deny_accs", 0);
00128 sTable( "r_rule_tokn_deny_accs", "R_TOKN_MAIN r_rule_tokn_deny_accs", 0);
00129 sTable( "r_met2_tokn_deny_accs", "R_TOKN_MAIN r_met2_tokn_deny_accs", 0);
00130 sTable( "r_resc_tokn_audit", "R_TOKN_MAIN r_resc_tokn_audit", 0);
00131 sTable( "r_coll_tokn_audit", "R_TOKN_MAIN r_coll_tokn_audit", 0);
00132 sTable( "r_data_tokn_audit", "R_TOKN_MAIN r_data_tokn_audit", 0);
00133 sTable( "r_rule_tokn_audit", "R_TOKN_MAIN r_rule_tokn_audit", 0);
00134 sTable( "r_met2_tokn_audit", "R_TOKN_MAIN r_met2_tokn_audit", 0);
00135 sTable( "r_resc_meta_main", "R_META_MAIN r_resc_meta_main", 0);
00136 sTable( "r_resc_grp_meta_main", "R_META_MAIN r_resc_grp_meta_main", 0);
00137 sTable( "r_coll_meta_main", "R_META_MAIN r_coll_meta_main", 0);
00138 sTable( "r_data_meta_main", "R_META_MAIN r_data_meta_main", 0);
00139 sTable( "r_rule_meta_main", "R_META_MAIN r_rule_meta_main", 0);
00140 sTable( "r_user_meta_main", "R_META_MAIN r_user_meta_main", 0);
00141 sTable( "r_met2_meta_main", "R_META_MAIN r_met2_meta_main", 0);
00142
00143 sTable( "R_USER_GROUP", "R_USER_GROUP", 0);
00144 sTable( "r_group_main", "R_USER_MAIN r_group_main", 0);
00145
00146 sTable( "R_RULE_EXEC", "R_RULE_EXEC", 0);
00147
00148 sTable( "R_OBJT_AUDIT", "R_OBJT_AUDIT", 0);
00149
00150 sTable( "R_SERVER_LOAD", "R_SERVER_LOAD", 0);
00151
00152 sTable( "R_SERVER_LOAD_DIGEST", "R_SERVER_LOAD_DIGEST", 0);
00153
00154 sTable( "R_USER_AUTH", "R_USER_AUTH", 0);
00155
00156 sTable( "R_RULE_BASE_MAP", "R_RULE_BASE_MAP", 0);
00157 sTable( "R_RULE_DVM_MAP", "R_RULE_DVM_MAP", 0);
00158 sTable( "R_RULE_FNM_MAP", "R_RULE_FNM_MAP", 0);
00159 sTable( "R_RULE_DVM", "R_RULE_DVM", 0);
00160 sTable( "R_RULE_FNM", "R_RULE_FNM", 0);
00161
00162 sTable( "R_QUOTA_MAIN", "R_QUOTA_MAIN", 0);
00163 sTable( "R_QUOTA_USAGE", "R_QUOTA_USAGE", 0);
00164
00165 sTable( "R_MICROSRVC_MAIN", "R_MICROSRVC_MAIN", 0);
00166 sTable( "R_MICROSRVC_VER", "R_MICROSRVC_VER", 0);
00167
00168 sTable( "r_msrvc_deny_access", "R_OBJT_DENY_ACCESS r_msrvc_deny_access", 0);
00169 sTable( "r_msrvc_audit", "R_OBJT_AUDIT r_msrvc_audit", 0);
00170 sTable( "r_msrvc_meta_main", "R_META_MAIN r_msrvc_meta_main", 0);
00171 sTable( "r_msrvc_tokn_accs", "R_TOKN_MAIN r_msrvc_tokn_accs", 0);
00172 sTable( "r_msrvc_user_group", "R_USER_GROUP r_msrvc_user_group", 0);
00173 sTable( "r_msrvc_user_main", "R_USER_MAIN r_msrvc_user_main", 0);
00174 sTable( "r_msrvc_tokn_deny_accs", "R_TOKN_MAIN r_msrvc_tokn_deny_accs", 0);
00175 sTable( "r_msrvc_da_user_group", "R_USER_GROUP r_msrvc_da_user_group", 0);
00176 sTable( "r_msrvc_da_user_main", "R_USER_MAIN r_msrvc_da_user_main", 0);
00177 sTable( "r_msrvc_tokn_audit", "R_TOKN_MAIN r_msrvc_tokn_audit", 0);
00178 sTable( "r_msrvc_au_user_group", "R_USER_GROUP r_msrvc_au_user_group", 0);
00179 sTable( "r_msrvc_au_user_main", "R_USER_MAIN r_msrvc_au_user_main", 0);
00180
00181
00182
00183
00184
00185 sColumn( COL_ZONE_ID, "R_ZONE_MAIN", "zone_id");
00186 sColumn( COL_ZONE_NAME, "R_ZONE_MAIN", "zone_name");
00187 sColumn( COL_ZONE_TYPE, "R_ZONE_MAIN", "zone_type_name");
00188 sColumn( COL_ZONE_CONNECTION, "R_ZONE_MAIN", "zone_conn_string");
00189 sColumn( COL_ZONE_COMMENT, "R_ZONE_MAIN", "r_comment");
00190 sColumn( COL_ZONE_CREATE_TIME, "R_ZONE_MAIN", "create_ts");
00191 sColumn( COL_ZONE_MODIFY_TIME, "R_ZONE_MAIN", "modify_ts");
00192
00193 sColumn( COL_USER_ID, "R_USER_MAIN", "user_id");
00194 sColumn( COL_USER_NAME, "R_USER_MAIN", "user_name");
00195 sColumn( COL_USER_TYPE, "R_USER_MAIN", "user_type_name");
00196 sColumn( COL_USER_ZONE, "R_USER_MAIN", "zone_name");
00197 sColumn( COL_USER_INFO, "R_USER_MAIN", "user_info");
00198 sColumn( COL_USER_COMMENT, "R_USER_MAIN", "r_comment");
00199 sColumn( COL_USER_CREATE_TIME, "R_USER_MAIN", "create_ts");
00200 sColumn( COL_USER_MODIFY_TIME, "R_USER_MAIN", "modify_ts");
00201
00202 sColumn( COL_USER_AUTH_ID, "R_USER_AUTH", "user_id");
00203 sColumn( COL_USER_DN, "R_USER_AUTH", "user_auth_name");
00204
00205
00206
00207
00208
00209
00210
00211
00212 sColumn( COL_USER_DN_INVALID,"R_USER_MAIN", "r_comment");
00213
00214
00215 sColumn( COL_R_RESC_ID, "R_RESC_MAIN", "resc_id");
00216 sColumn( COL_R_RESC_NAME, "R_RESC_MAIN", "resc_name");
00217 sColumn( COL_R_ZONE_NAME, "R_RESC_MAIN", "zone_name");
00218 sColumn( COL_R_TYPE_NAME, "R_RESC_MAIN", "resc_type_name");
00219 sColumn( COL_R_CLASS_NAME, "R_RESC_MAIN", "resc_class_name");
00220 sColumn( COL_R_LOC, "R_RESC_MAIN", "resc_net");
00221 sColumn( COL_R_VAULT_PATH, "R_RESC_MAIN", "resc_def_path ");
00222 sColumn( COL_R_FREE_SPACE, "R_RESC_MAIN", "free_space");
00223 sColumn( COL_R_FREE_SPACE_TIME, "R_RESC_MAIN", "free_space_ts");
00224 sColumn( COL_R_RESC_INFO, "R_RESC_MAIN", "resc_info");
00225 sColumn( COL_R_RESC_COMMENT, "R_RESC_MAIN", "r_comment");
00226 sColumn( COL_R_RESC_STATUS, "R_RESC_MAIN", "resc_status");
00227 sColumn( COL_R_CREATE_TIME, "R_RESC_MAIN", "create_ts");
00228 sColumn( COL_R_MODIFY_TIME, "R_RESC_MAIN", "modify_ts ");
00229 sColumn( COL_R_RESC_CHILDREN, "R_RESC_MAIN", "resc_children ");
00230 sColumn( COL_R_RESC_CONTEXT, "R_RESC_MAIN", "resc_context ");
00231 sColumn( COL_R_RESC_PARENT, "R_RESC_MAIN", "resc_parent ");
00232 sColumn( COL_R_RESC_OBJCOUNT, "R_RESC_MAIN", "resc_objcount ");
00233 sColumn( COL_D_DATA_ID, "R_DATA_MAIN", "data_id");
00234 sColumn( COL_D_COLL_ID, "R_DATA_MAIN", "coll_id");
00235 sColumn( COL_DATA_NAME, "R_DATA_MAIN", "data_name");
00236 sColumn( COL_DATA_REPL_NUM, "R_DATA_MAIN", "data_repl_num");
00237 sColumn( COL_DATA_VERSION, "R_DATA_MAIN", "data_version");
00238 sColumn( COL_DATA_TYPE_NAME, "R_DATA_MAIN", "data_type_name");
00239 sColumn( COL_DATA_SIZE, "R_DATA_MAIN", "data_size");
00240 sColumn( COL_D_RESC_GROUP_NAME, "R_DATA_MAIN", "resc_group_name");
00241 sColumn( COL_D_RESC_NAME, "R_DATA_MAIN", "resc_name");
00242 sColumn( COL_D_DATA_PATH, "R_DATA_MAIN", "data_path");
00243 sColumn( COL_D_OWNER_NAME, "R_DATA_MAIN", "data_owner_name");
00244 sColumn( COL_D_OWNER_ZONE, "R_DATA_MAIN", "data_owner_zone");
00245 sColumn( COL_D_REPL_STATUS, "R_DATA_MAIN", "data_is_dirty");
00246 sColumn( COL_D_DATA_STATUS, "R_DATA_MAIN", "data_status");
00247 sColumn( COL_D_DATA_CHECKSUM, "R_DATA_MAIN", "data_checksum");
00248 sColumn( COL_D_EXPIRY, "R_DATA_MAIN", "data_expiry_ts");
00249 sColumn( COL_D_MAP_ID, "R_DATA_MAIN", "data_map_id");
00250 sColumn( COL_D_COMMENTS, "R_DATA_MAIN", "r_comment");
00251 sColumn( COL_D_CREATE_TIME, "R_DATA_MAIN", "create_ts");
00252 sColumn( COL_D_MODIFY_TIME, "R_DATA_MAIN", "modify_ts");
00253 sColumn( COL_DATA_MODE, "R_DATA_MAIN", "data_mode");
00254 sColumn( COL_D_RESC_HIER, "R_DATA_MAIN", "resc_hier");
00255
00256
00257 sColumn( COL_DATA_ACCESS_TYPE, "r_data_access", "access_type_id");
00258 sColumn( COL_DATA_ACCESS_NAME, "r_data_tokn_accs", "token_name");
00259 sColumn( COL_DATA_TOKEN_NAMESPACE, "r_data_tokn_accs", "token_namespace");
00260 sColumn( COL_DATA_ACCESS_USER_ID, "r_data_access", "user_id");
00261 sColumn( COL_DATA_ACCESS_DATA_ID, "r_data_access", "object_id");
00262
00263 sColumn( COL_COLL_ACCESS_TYPE, "r_coll_access", "access_type_id");
00264 sColumn( COL_COLL_ACCESS_NAME, "r_coll_tokn_accs", "token_name");
00265 sColumn( COL_COLL_TOKEN_NAMESPACE, "r_coll_tokn_accs", "token_namespace");
00266 sColumn( COL_COLL_ACCESS_USER_ID, "r_coll_access", "user_id");
00267 sColumn( COL_COLL_ACCESS_COLL_ID, "r_coll_access", "object_id");
00268
00269 sColumn( COL_RESC_ACCESS_TYPE, "r_resc_access", "access_type_id");
00270 sColumn( COL_RESC_ACCESS_NAME, "r_resc_tokn_accs", "token_name");
00271 sColumn( COL_RESC_TOKEN_NAMESPACE, "r_resc_tokn_accs", "token_namespace");
00272 sColumn( COL_RESC_ACCESS_USER_ID, "r_resc_access", "user_id");
00273 sColumn( COL_RESC_ACCESS_RESC_ID, "r_resc_access", "object_id");
00274
00275 sColumn( COL_COLL_ID, "R_COLL_MAIN", "coll_id");
00276 sColumn( COL_COLL_NAME, "R_COLL_MAIN", "coll_name");
00277 sColumn( COL_COLL_PARENT_NAME, "R_COLL_MAIN", "parent_coll_name");
00278 sColumn( COL_COLL_OWNER_NAME, "R_COLL_MAIN", "coll_owner_name");
00279 sColumn( COL_COLL_OWNER_ZONE, "R_COLL_MAIN", "coll_owner_zone");
00280 sColumn( COL_COLL_MAP_ID, "R_COLL_MAIN", "coll_map_id");
00281 sColumn( COL_COLL_INHERITANCE, "R_COLL_MAIN", "coll_inheritance");
00282 sColumn( COL_COLL_COMMENTS, "R_COLL_MAIN", "r_comment");
00283 sColumn( COL_COLL_CREATE_TIME, "R_COLL_MAIN", "create_ts");
00284 sColumn( COL_COLL_MODIFY_TIME, "R_COLL_MAIN", "modify_ts");
00285 sColumn( COL_COLL_TYPE, "R_COLL_MAIN", "coll_type");
00286 sColumn( COL_COLL_INFO1, "R_COLL_MAIN", "coll_info1");
00287 sColumn( COL_COLL_INFO2, "R_COLL_MAIN", "coll_info2");
00288
00289 sColumn( COL_META_DATA_ATTR_NAME, "r_data_meta_main", "meta_attr_name");
00290 sColumn( COL_META_DATA_ATTR_VALUE, "r_data_meta_main", "meta_attr_value");
00291 sColumn( COL_META_DATA_ATTR_UNITS, "r_data_meta_main", "meta_attr_unit");
00292 sColumn( COL_META_DATA_ATTR_ID, "r_data_meta_main", "meta_id");
00293 sColumn( COL_META_DATA_CREATE_TIME, "r_data_meta_main", "create_ts");
00294 sColumn( COL_META_DATA_MODIFY_TIME, "r_data_meta_main", "modify_ts");
00295
00296 sColumn( COL_META_COLL_ATTR_NAME, "r_coll_meta_main", "meta_attr_name");
00297 sColumn( COL_META_COLL_ATTR_VALUE, "r_coll_meta_main", "meta_attr_value");
00298 sColumn( COL_META_COLL_ATTR_UNITS, "r_coll_meta_main", "meta_attr_unit");
00299 sColumn( COL_META_COLL_ATTR_ID, "r_coll_meta_main", "meta_id");
00300 sColumn( COL_META_COLL_CREATE_TIME, "r_coll_meta_main", "create_ts");
00301 sColumn( COL_META_COLL_MODIFY_TIME, "r_coll_meta_main", "modify_ts");
00302
00303 sColumn( COL_META_NAMESPACE_COLL, "r_coll_meta_main", "meta_namespace");
00304 sColumn( COL_META_NAMESPACE_DATA, "r_data_meta_main", "meta_namespace");
00305 sColumn( COL_META_NAMESPACE_RESC, "r_resc_meta_main", "meta_namespace");
00306 sColumn( COL_META_NAMESPACE_RESC_GROUP, "r_resc_grp_meta_main", "meta_namespace");
00307 sColumn( COL_META_NAMESPACE_USER, "r_user_meta_main", "meta_namespace");
00308 sColumn( COL_META_NAMESPACE_RULE, "r_rule_meta_main", "meta_namespace");
00309 sColumn( COL_META_NAMESPACE_MSRVC, "r_msrvc_meta_main", "meta_namespace");
00310 sColumn( COL_META_NAMESPACE_MET2, "r_met2_meta_main", "meta_namespace");
00311
00312
00313 sColumn( COL_META_RESC_ATTR_NAME, "r_resc_meta_main", "meta_attr_name");
00314 sColumn( COL_META_RESC_ATTR_VALUE, "r_resc_meta_main", "meta_attr_value");
00315 sColumn( COL_META_RESC_ATTR_UNITS, "r_resc_meta_main", "meta_attr_unit");
00316 sColumn( COL_META_RESC_ATTR_ID, "r_resc_meta_main", "meta_id");
00317 sColumn( COL_META_RESC_CREATE_TIME, "r_resc_meta_main", "create_ts");
00318 sColumn( COL_META_RESC_MODIFY_TIME, "r_resc_meta_main", "modify_ts");
00319
00320 sColumn( COL_META_RESC_GROUP_ATTR_NAME, "r_resc_grp_meta_main", "meta_attr_name");
00321 sColumn( COL_META_RESC_GROUP_ATTR_VALUE, "r_resc_grp_meta_main", "meta_attr_value");
00322 sColumn( COL_META_RESC_GROUP_ATTR_UNITS, "r_resc_grp_meta_main", "meta_attr_unit");
00323 sColumn( COL_META_RESC_GROUP_ATTR_ID, "r_resc_grp_meta_main", "meta_id");
00324 sColumn( COL_META_RESC_GROUP_CREATE_TIME, "r_resc_grp_meta_main", "create_ts");
00325 sColumn( COL_META_RESC_GROUP_MODIFY_TIME, "r_resc_grp_meta_main", "modify_ts");
00326
00327 sColumn( COL_META_USER_ATTR_NAME, "r_user_meta_main", "meta_attr_name");
00328 sColumn( COL_META_USER_ATTR_VALUE, "r_user_meta_main", "meta_attr_value");
00329 sColumn( COL_META_USER_ATTR_UNITS, "r_user_meta_main", "meta_attr_unit");
00330 sColumn( COL_META_USER_ATTR_ID, "r_user_meta_main", "meta_id");
00331 sColumn( COL_META_USER_CREATE_TIME, "r_user_meta_main", "create_ts");
00332 sColumn( COL_META_USER_MODIFY_TIME, "r_user_meta_main", "modify_ts");
00333
00334 sColumn( COL_META_RULE_ATTR_NAME, "r_rule_meta_main", "meta_attr_name");
00335 sColumn( COL_META_RULE_ATTR_VALUE, "r_rule_meta_main", "meta_attr_value");
00336 sColumn( COL_META_RULE_ATTR_UNITS, "r_rule_meta_main", "meta_attr_unit");
00337 sColumn( COL_META_RULE_ATTR_ID, "r_rule_meta_main", "meta_id");
00338 sColumn( COL_META_RULE_CREATE_TIME, "r_rule_meta_main", "create_ts");
00339 sColumn( COL_META_RULE_MODIFY_TIME, "r_rule_meta_main", "modify_ts");
00340
00341 sColumn( COL_META_MSRVC_ATTR_NAME, "r_msrvc_meta_main", "meta_attr_name");
00342 sColumn( COL_META_MSRVC_ATTR_VALUE, "r_msrvc_meta_main", "meta_attr_value");
00343 sColumn( COL_META_MSRVC_ATTR_UNITS, "r_msrvc_meta_main", "meta_attr_unit");
00344 sColumn( COL_META_MSRVC_ATTR_ID, "r_msrvc_meta_main", "meta_id");
00345 sColumn( COL_META_MSRVC_CREATE_TIME, "r_msrvc_meta_main", "create_ts");
00346 sColumn( COL_META_MSRVC_MODIFY_TIME, "r_msrvc_meta_main", "modify_ts");
00347
00348 sColumn( COL_META_MET2_ATTR_NAME, "r_met2_meta_main", "meta_attr_name");
00349 sColumn( COL_META_MET2_ATTR_VALUE, "r_met2_meta_main", "meta_attr_value");
00350 sColumn( COL_META_MET2_ATTR_UNITS, "r_met2_meta_main", "meta_attr_unit");
00351 sColumn( COL_META_MET2_ATTR_ID, "r_met2_meta_main", "meta_id");
00352 sColumn( COL_META_MET2_CREATE_TIME, "r_met2_meta_main", "create_ts");
00353 sColumn( COL_META_MET2_MODIFY_TIME, "r_met2_meta_main", "modify_ts");
00354
00355 sColumn( COL_RESC_GROUP_RESC_ID, "R_RESC_GROUP", "resc_id");
00356 sColumn( COL_RESC_GROUP_NAME, "R_RESC_GROUP", "resc_group_name");
00357 sColumn( COL_RESC_GROUP_ID, "R_RESC_GROUP", "resc_group_id");
00358
00359 sColumn( COL_USER_GROUP_ID, "R_USER_GROUP", "group_user_id");
00360 sColumn( COL_USER_GROUP_NAME, "r_group_main", "user_name");
00361
00362 sColumn( COL_RULE_EXEC_ID, "R_RULE_EXEC", "rule_exec_id");
00363 sColumn( COL_RULE_EXEC_NAME, "R_RULE_EXEC", "rule_name");
00364 sColumn( COL_RULE_EXEC_REI_FILE_PATH, "R_RULE_EXEC", "rei_file_path");
00365 sColumn( COL_RULE_EXEC_USER_NAME, "R_RULE_EXEC", "user_name");
00366 sColumn( COL_RULE_EXEC_ADDRESS, "R_RULE_EXEC", "exe_address");
00367 sColumn( COL_RULE_EXEC_TIME, "R_RULE_EXEC", "exe_time");
00368 sColumn( COL_RULE_EXEC_FREQUENCY, "R_RULE_EXEC", "exe_frequency");
00369 sColumn( COL_RULE_EXEC_PRIORITY, "R_RULE_EXEC", "priority");
00370 sColumn( COL_RULE_EXEC_ESTIMATED_EXE_TIME,"R_RULE_EXEC","estimated_exe_time");
00371 sColumn( COL_RULE_EXEC_NOTIFICATION_ADDR,"R_RULE_EXEC", "notification_addr");
00372 sColumn( COL_RULE_EXEC_LAST_EXE_TIME,"R_RULE_EXEC", "last_exe_time");
00373 sColumn( COL_RULE_EXEC_STATUS,"R_RULE_EXEC", "exe_status");
00374
00375 sColumn(COL_TOKEN_NAMESPACE, "R_TOKN_MAIN", "token_namespace");
00376 sColumn(COL_TOKEN_ID, "R_TOKN_MAIN", "token_id");
00377 sColumn(COL_TOKEN_NAME, "R_TOKN_MAIN", "token_name");
00378 sColumn(COL_TOKEN_VALUE, "R_TOKN_MAIN", "token_value");
00379 sColumn(COL_TOKEN_VALUE2, "R_TOKN_MAIN", "token_value2");
00380 sColumn(COL_TOKEN_VALUE3, "R_TOKN_MAIN", "token_value3");
00381 sColumn(COL_TOKEN_COMMENT, "R_TOKN_MAIN", "r_comment");
00382
00383 sColumn(COL_AUDIT_OBJ_ID, "R_OBJT_AUDIT", "object_id");
00384 sColumn(COL_AUDIT_USER_ID, "R_OBJT_AUDIT", "user_id");
00385 sColumn(COL_AUDIT_ACTION_ID, "R_OBJT_AUDIT", "action_id");
00386 sColumn(COL_AUDIT_COMMENT, "R_OBJT_AUDIT", "r_comment");
00387 sColumn(COL_AUDIT_CREATE_TIME, "R_OBJT_AUDIT", "create_ts");
00388 sColumn(COL_AUDIT_MODIFY_TIME, "R_OBJT_AUDIT", "modify_ts");
00389
00390 sColumn(COL_COLL_USER_NAME, "r_coll_user_main", "user_name");
00391 sColumn(COL_COLL_USER_ZONE, "r_coll_user_main", "zone_name");
00392
00393 sColumn(COL_DATA_USER_NAME, "r_data_user_main", "user_name");
00394 sColumn(COL_DATA_USER_ZONE, "r_data_user_main", "zone_name");
00395
00396 sColumn(COL_RESC_USER_NAME, "r_resc_user_main", "user_name");
00397 sColumn(COL_RESC_USER_ZONE, "r_resc_user_main", "zone_name");
00398
00399 sColumn(COL_SL_HOST_NAME, "R_SERVER_LOAD", "host_name");
00400 sColumn(COL_SL_RESC_NAME, "R_SERVER_LOAD", "resc_name");
00401 sColumn(COL_SL_CPU_USED, "R_SERVER_LOAD", "cpu_used");
00402 sColumn(COL_SL_MEM_USED, "R_SERVER_LOAD", "mem_used");
00403 sColumn(COL_SL_SWAP_USED, "R_SERVER_LOAD", "swap_used");
00404 sColumn(COL_SL_RUNQ_LOAD, "R_SERVER_LOAD", "runq_load");
00405 sColumn(COL_SL_DISK_SPACE, "R_SERVER_LOAD", "disk_space");
00406 sColumn(COL_SL_NET_INPUT, "R_SERVER_LOAD", "net_input");
00407 sColumn(COL_SL_NET_OUTPUT, "R_SERVER_LOAD", "net_output");
00408 sColumn(COL_SL_CREATE_TIME, "R_SERVER_LOAD", "create_ts");
00409
00410 sColumn(COL_SLD_RESC_NAME, "R_SERVER_LOAD_DIGEST", "resc_name");
00411 sColumn(COL_SLD_LOAD_FACTOR, "R_SERVER_LOAD_DIGEST", "load_factor");
00412 sColumn(COL_SLD_CREATE_TIME, "R_SERVER_LOAD_DIGEST", "create_ts");
00413
00414 sColumn(COL_RULE_ID, "R_RULE_MAIN", "rule_id");
00415 sColumn(COL_RULE_VERSION, "R_RULE_MAIN", "rule_version");
00416 sColumn(COL_RULE_BASE_NAME, "R_RULE_MAIN", "rule_base_name");
00417 sColumn(COL_RULE_NAME, "R_RULE_MAIN", "rule_name");
00418 sColumn(COL_RULE_EVENT, "R_RULE_MAIN", "rule_event");
00419 sColumn(COL_RULE_CONDITION, "R_RULE_MAIN", "rule_condition");
00420 sColumn(COL_RULE_BODY, "R_RULE_MAIN", "rule_body");
00421 sColumn(COL_RULE_RECOVERY, "R_RULE_MAIN", "rule_recovery");
00422 sColumn(COL_RULE_STATUS, "R_RULE_MAIN", "rule_status");
00423 sColumn(COL_RULE_OWNER_NAME, "R_RULE_MAIN", "rule_owner_name");
00424 sColumn(COL_RULE_OWNER_ZONE, "R_RULE_MAIN", "rule_owner_zone");
00425 sColumn(COL_RULE_DESCR_1, "R_RULE_MAIN", "rule_descr_1");
00426 sColumn(COL_RULE_DESCR_2, "R_RULE_MAIN", "rule_descr_2");
00427 sColumn(COL_RULE_INPUT_PARAMS, "R_RULE_MAIN", "input_params");
00428 sColumn(COL_RULE_OUTPUT_PARAMS, "R_RULE_MAIN", "output_params");
00429 sColumn(COL_RULE_DOLLAR_VARS, "R_RULE_MAIN", "dollar_vars");
00430 sColumn(COL_RULE_ICAT_ELEMENTS, "R_RULE_MAIN", "icat_elements");
00431 sColumn(COL_RULE_SIDEEFFECTS, "R_RULE_MAIN", "sideeffects");
00432 sColumn(COL_RULE_COMMENT, "R_RULE_MAIN", "r_comment");
00433 sColumn(COL_RULE_CREATE_TIME,"R_RULE_MAIN", "create_ts");
00434 sColumn(COL_RULE_MODIFY_TIME,"R_RULE_MAIN", "modify_ts");
00435
00436 sColumn(COL_RULE_BASE_MAP_VERSION, "R_RULE_BASE_MAP", "map_version");
00437 sColumn(COL_RULE_BASE_MAP_PRIORITY, "R_RULE_BASE_MAP", "map_priority");
00438 sColumn(COL_RULE_BASE_MAP_BASE_NAME, "R_RULE_BASE_MAP", "map_base_name");
00439 sColumn(COL_RULE_BASE_MAP_OWNER_NAME, "R_RULE_BASE_MAP", "map_owner_name");
00440 sColumn(COL_RULE_BASE_MAP_OWNER_ZONE, "R_RULE_BASE_MAP", "map_owner_zone");
00441 sColumn(COL_RULE_BASE_MAP_COMMENT, "R_RULE_BASE_MAP", "r_comment");
00442 sColumn(COL_RULE_BASE_MAP_CREATE_TIME,"R_RULE_BASE_MAP", "create_ts");
00443 sColumn(COL_RULE_BASE_MAP_MODIFY_TIME,"R_RULE_BASE_MAP", "modify_ts");
00444
00445 sColumn(COL_DVM_ID, "R_RULE_DVM", "dvm_id");
00446 sColumn(COL_DVM_VERSION, "R_RULE_DVM", "dvm_version");
00447 sColumn(COL_DVM_BASE_NAME, "R_RULE_DVM", "dvm_base_name");
00448 sColumn(COL_DVM_EXT_VAR_NAME, "R_RULE_DVM", "dvm_ext_var_name");
00449 sColumn(COL_DVM_CONDITION, "R_RULE_DVM", "dvm_condition");
00450 sColumn(COL_DVM_INT_MAP_PATH, "R_RULE_DVM", "dvm_int_map_path");
00451 sColumn(COL_DVM_STATUS, "R_RULE_DVM", "dvm_status");
00452 sColumn(COL_DVM_OWNER_NAME, "R_RULE_DVM", "dvm_owner_name");
00453 sColumn(COL_DVM_OWNER_ZONE, "R_RULE_DVM", "dvm_owner_zone");
00454 sColumn(COL_DVM_COMMENT, "R_RULE_DVM", "r_comment");
00455 sColumn(COL_DVM_CREATE_TIME, "R_RULE_DVM", "create_ts");
00456 sColumn(COL_DVM_MODIFY_TIME, "R_RULE_DVM", "modify_ts");
00457
00458 sColumn(COL_DVM_BASE_MAP_VERSION, "R_RULE_DVM_MAP", "map_dvm_version");
00459 sColumn(COL_DVM_BASE_MAP_BASE_NAME, "R_RULE_DVM_MAP", "map_dvm_base_name");
00460 sColumn(COL_DVM_BASE_MAP_OWNER_NAME, "R_RULE_DVM_MAP", "map_owner_name");
00461 sColumn(COL_DVM_BASE_MAP_OWNER_ZONE, "R_RULE_DVM_MAP", "map_owner_zone");
00462 sColumn(COL_DVM_BASE_MAP_COMMENT, "R_RULE_DVM_MAP", "r_comment");
00463 sColumn(COL_DVM_BASE_MAP_CREATE_TIME,"R_RULE_DVM_MAP", "create_ts");
00464 sColumn(COL_DVM_BASE_MAP_MODIFY_TIME,"R_RULE_DVM_MAP", "modify_ts");
00465
00466 sColumn(COL_FNM_ID, "R_RULE_FNM", "fnm_id");
00467 sColumn(COL_FNM_VERSION, "R_RULE_FNM", "fnm_version");
00468 sColumn(COL_FNM_BASE_NAME, "R_RULE_FNM", "fnm_base_name");
00469 sColumn(COL_FNM_EXT_FUNC_NAME,"R_RULE_FNM", "fnm_ext_func_name");
00470 sColumn(COL_FNM_INT_FUNC_NAME,"R_RULE_FNM", "fnm_int_func_name");
00471 sColumn(COL_FNM_STATUS, "R_RULE_FNM", "fnm_status");
00472 sColumn(COL_FNM_OWNER_NAME, "R_RULE_FNM", "fnm_owner_name");
00473 sColumn(COL_FNM_OWNER_ZONE, "R_RULE_FNM", "fnm_owner_zone");
00474 sColumn(COL_FNM_COMMENT, "R_RULE_FNM", "r_comment");
00475 sColumn(COL_FNM_CREATE_TIME, "R_RULE_FNM", "create_ts");
00476 sColumn(COL_FNM_MODIFY_TIME, "R_RULE_FNM", "modify_ts");
00477
00478 sColumn(COL_FNM_BASE_MAP_VERSION, "R_RULE_FNM_MAP", "map_fnm_version");
00479 sColumn(COL_FNM_BASE_MAP_BASE_NAME, "R_RULE_FNM_MAP", "map_fnm_base_name");
00480 sColumn(COL_FNM_BASE_MAP_OWNER_NAME, "R_RULE_FNM_MAP", "map_owner_name");
00481 sColumn(COL_FNM_BASE_MAP_OWNER_ZONE, "R_RULE_FNM_MAP", "map_owner_zone");
00482 sColumn(COL_FNM_BASE_MAP_COMMENT, "R_RULE_FNM_MAP", "r_comment");
00483 sColumn(COL_FNM_BASE_MAP_CREATE_TIME,"R_RULE_FNM_MAP", "create_ts");
00484 sColumn(COL_FNM_BASE_MAP_MODIFY_TIME,"R_RULE_FNM_MAP", "modify_ts");
00485
00486 sColumn(COL_QUOTA_USER_ID, "R_QUOTA_MAIN", "user_id");
00487 sColumn(COL_QUOTA_RESC_ID, "R_QUOTA_MAIN", "resc_id");
00488 sColumn(COL_QUOTA_LIMIT, "R_QUOTA_MAIN", "quota_limit");
00489 sColumn(COL_QUOTA_OVER, "R_QUOTA_MAIN", "quota_over");
00490 sColumn(COL_QUOTA_MODIFY_TIME,"R_QUOTA_MAIN", "modify_ts");
00491
00492 sColumn(COL_QUOTA_USAGE_USER_ID, "R_QUOTA_USAGE", "user_id");
00493 sColumn(COL_QUOTA_USAGE_RESC_ID, "R_QUOTA_USAGE", "resc_id");
00494 sColumn(COL_QUOTA_USAGE, "R_QUOTA_USAGE", "quota_usage");
00495 sColumn(COL_QUOTA_USAGE_MODIFY_TIME,"R_QUOTA_USAGE", "modify_ts");
00496
00497 sColumn( COL_QUOTA_USER_NAME, "r_quota_user_main", "user_name");
00498 sColumn( COL_QUOTA_USER_TYPE, "r_quota_user_group", "user_type_name");
00499 sColumn( COL_QUOTA_RESC_NAME, "r_quota_resc_main", "resc_name");
00500 sColumn( COL_QUOTA_USER_ZONE, "r_quota_user_main", "zone_name");
00501
00502 sColumn(COL_MSRVC_ID, "R_MICROSRVC_MAIN", "msrvc_id");
00503 sColumn(COL_MSRVC_MODULE_NAME, "R_MICROSRVC_MAIN", "msrvc_module_name");
00504 sColumn(COL_MSRVC_NAME, "R_MICROSRVC_MAIN", "msrvc_name");
00505 sColumn(COL_MSRVC_SIGNATURE, "R_MICROSRVC_MAIN", "msrvc_signature");
00506 sColumn(COL_MSRVC_DOXYGEN, "R_MICROSRVC_MAIN", "msrvc_doxygen");
00507 sColumn(COL_MSRVC_VARIATIONS, "R_MICROSRVC_MAIN", "msrvc_variations");
00508 sColumn(COL_MSRVC_OWNER_NAME, "R_MICROSRVC_MAIN", "msrvc_owner_name");
00509 sColumn(COL_MSRVC_OWNER_ZONE, "R_MICROSRVC_MAIN", "msrvc_owner_zone");
00510 sColumn(COL_MSRVC_COMMENT, "R_MICROSRVC_MAIN", "r_comment");
00511 sColumn(COL_MSRVC_CREATE_TIME, "R_MICROSRVC_MAIN", "create_ts");
00512 sColumn(COL_MSRVC_MODIFY_TIME, "R_MICROSRVC_MAIN", "modify_ts");
00513
00514 sColumn(COL_MSRVC_VERSION, "R_MICROSRVC_VER", "msrvc_version");
00515 sColumn(COL_MSRVC_HOST, "R_MICROSRVC_VER", "msrvc_host");
00516 sColumn(COL_MSRVC_LOCATION, "R_MICROSRVC_VER", "msrvc_location");
00517 sColumn(COL_MSRVC_LANGUAGE, "R_MICROSRVC_VER", "msrvc_language");
00518 sColumn(COL_MSRVC_TYPE_NAME, "R_MICROSRVC_VER", "msrvc_type_name");
00519 sColumn(COL_MSRVC_STATUS, "R_MICROSRVC_VER", "msrvc_status");
00520 sColumn(COL_MSRVC_VER_OWNER_NAME, "R_MICROSRVC_VER", "msrvc_owner_name");
00521 sColumn(COL_MSRVC_VER_OWNER_ZONE, "R_MICROSRVC_VER", "msrvc_owner_zone");
00522 sColumn(COL_MSRVC_VER_COMMENT, "R_MICROSRVC_VER", "r_comment");
00523 sColumn(COL_MSRVC_VER_CREATE_TIME,"R_MICROSRVC_VER", "create_ts");
00524 sColumn(COL_MSRVC_VER_MODIFY_TIME,"R_MICROSRVC_VER", "modify_ts");
00525
00526 sColumn( COL_META_ACCESS_TYPE, "r_meta_access", "access_type_id");
00527 sColumn( COL_META_ACCESS_NAME, "r_meta_tokn_accs", "token_name");
00528 sColumn( COL_META_TOKEN_NAMESPACE, "r_meta_tokn_accs", "token_namespace");
00529 sColumn( COL_META_ACCESS_USER_ID, "r_meta_access", "user_id");
00530 sColumn( COL_META_ACCESS_META_ID, "r_meta_access", "object_id");
00531
00532 sColumn( COL_RESC_ACCESS_TYPE, "r_resc_access", "access_type_id");
00533 sColumn( COL_RESC_ACCESS_NAME, "r_resc_tokn_accs", "token_name");
00534 sColumn( COL_RESC_TOKEN_NAMESPACE, "r_resc_tokn_accs", "token_namespace");
00535 sColumn( COL_RESC_ACCESS_USER_ID, "r_resc_access", "user_id");
00536 sColumn( COL_RESC_ACCESS_RESC_ID, "r_resc_access", "object_id");
00537
00538 sColumn( COL_RULE_ACCESS_TYPE, "r_rule_access", "access_type_id");
00539 sColumn( COL_RULE_ACCESS_NAME, "r_rule_tokn_accs", "token_name");
00540 sColumn( COL_RULE_TOKEN_NAMESPACE, "r_rule_tokn_accs", "token_namespace");
00541 sColumn( COL_RULE_ACCESS_USER_ID, "r_rule_access", "user_id");
00542 sColumn( COL_RULE_ACCESS_RULE_ID, "r_rule_access", "object_id");
00543
00544 sColumn( COL_MSRVC_ACCESS_TYPE, "r_msrvc_access", "access_type_id");
00545 sColumn( COL_MSRVC_ACCESS_NAME, "r_msrvc_tokn_accs", "token_name");
00546 sColumn( COL_MSRVC_TOKEN_NAMESPACE, "r_msrvc_tokn_accs", "token_namespace");
00547 sColumn( COL_MSRVC_ACCESS_USER_ID, "r_msrvc_access", "user_id");
00548 sColumn( COL_MSRVC_ACCESS_MSRVC_ID, "r_msrvc_access", "object_id");
00549
00550
00551
00552
00553 sFklink("R_COLL_MAIN", "R_DATA_MAIN", "R_COLL_MAIN.coll_id = R_DATA_MAIN.coll_id");
00554 sFklink("R_RESC_GROUP", "R_RESC_MAIN", "R_RESC_GROUP.resc_id = R_RESC_MAIN.resc_id");
00555 sFklink("R_RESC_MAIN", "r_resc_metamap", "R_RESC_MAIN.resc_id = r_resc_metamap.object_id");
00556 sFklink("R_RESC_MAIN", "R_DATA_MAIN", "R_RESC_MAIN.resc_name = R_DATA_MAIN.resc_name");
00557 sFklink("R_RESC_GROUP", "r_resc_grp_metamap", "R_RESC_GROUP.resc_group_id = r_resc_grp_metamap.object_id");
00558 sFklink("R_COLL_MAIN", "r_coll_metamap", "R_COLL_MAIN.coll_id = r_coll_metamap.object_id");
00559 sFklink("R_DATA_MAIN", "r_data_metamap", "R_DATA_MAIN.data_id = r_data_metamap.object_id");
00560 sFklink("R_RULE_MAIN", "r_rule_metamap", "R_RULE_MAIN.rule_id = r_rule_metamap.object_id");
00561 sFklink("R_USER_MAIN", "r_user_metamap", "R_USER_MAIN.user_id = r_user_metamap.object_id");
00562 sFklink("r_met2_main", "r_met2_metamap", "r_met2_main.meta_id = r_met2_metamap.object_id");
00563 sFklink("R_RESC_MAIN", "r_resc_access", "R_RESC_MAIN.resc_id = r_resc_access.object_id");
00564 sFklink("R_COLL_MAIN", "r_coll_access", "R_COLL_MAIN.coll_id = r_coll_access.object_id");
00565 sFklink("R_DATA_MAIN", "r_data_access", "R_DATA_MAIN.data_id = r_data_access.object_id");
00566 sFklink("R_RULE_MAIN", "r_rule_access", "R_RULE_MAIN.rule_id = r_rule_access.object_id");
00567 sFklink("r_met2_main", "r_met2_access", "r_met2_main.meta_id = r_met2_access.object_id");
00568 sFklink("R_RESC_MAIN", "r_resc_deny_access", "R_RESC_MAIN.resc_id = r_resc_deny_access.object_id");
00569 sFklink("R_COLL_MAIN", "r_coll_deny_access", "R_COLL_MAIN.coll_id = r_coll_deny_access.object_id");
00570 sFklink("R_DATA_MAIN", "r_data_deny_access", "R_DATA_MAIN.data_id = r_data_deny_access.object_id");
00571 sFklink("R_RULE_MAIN", "r_rule_deny_access", "R_RULE_MAIN.rule_id = r_rule_deny_access.object_id");
00572 sFklink("r_met2_main", "r_met2_deny_access", "r_met2_main.meta_id = r_met2_deny_access.object_id");
00573 sFklink("R_RESC_MAIN", "r_resc_audit", "R_RESC_MAIN.resc_id = r_resc_audit.object_id");
00574 sFklink("R_COLL_MAIN", "r_coll_audit", "R_COLL_MAIN.coll_id = r_coll_audit.object_id");
00575 sFklink("R_DATA_MAIN", "r_data_audit", "R_DATA_MAIN.data_id = r_data_audit.object_id");
00576 sFklink("R_RULE_MAIN", "r_rule_audit", "R_RULE_MAIN.rule_id = r_rule_audit.object_id");
00577 sFklink("r_met2_main", "r_met2_audit", "r_met2_main.meta_id = r_met2_audit.object_id.meta_id");
00578 sFklink("r_resc_metamap", "r_resc_meta_main", "r_resc_metamap.meta_id = r_resc_meta_main.meta_id");
00579 sFklink("r_resc_grp_metamap", "r_resc_grp_meta_main", "r_resc_grp_metamap.meta_id = r_resc_grp_meta_main.meta_id");
00580 sFklink("r_coll_metamap", "r_coll_meta_main", "r_coll_metamap.meta_id = r_coll_meta_main.meta_id");
00581 sFklink("r_data_metamap", "r_data_meta_main", "r_data_metamap.meta_id = r_data_meta_main.meta_id");
00582 sFklink("r_rule_metamap", "r_rule_meta_main", "r_rule_metamap.meta_id = r_rule_meta_main.meta_id");
00583 sFklink("r_user_metamap", "r_user_meta_main", "r_user_metamap.meta_id = r_user_meta_main.meta_id");
00584 sFklink("r_met2_metamap", "r_met2_meta_main", "r_met2_metamap.object_id = r_met2_meta_main.meta_id");
00585 sFklink("r_resc_access", "r_resc_tokn_accs", "r_resc_access.access_type_id = r_resc_tokn_accs.token_id");
00586 sFklink("r_resc_access", "r_resc_user_group", "r_resc_access.user_id = r_resc_user_group.group_user_id");
00587 sFklink("r_coll_access", "r_coll_tokn_accs", "r_coll_access.access_type_id = r_coll_tokn_accs.token_id");
00588 sFklink("r_coll_access", "r_coll_user_group", "r_coll_access.user_id = r_coll_user_group.group_user_id");
00589 sFklink("r_data_access", "r_data_tokn_accs", "r_data_access.access_type_id = r_data_tokn_accs.token_id");
00590 sFklink("r_data_access", "r_data_user_group", "r_data_access.user_id = r_data_user_group.group_user_id");
00591 sFklink("r_rule_access", "r_rule_tokn_accs", "r_rule_access.access_typ_id = r_rule_tokn_accs.token_id");
00592 sFklink("r_rule_access", "r_rule_user_group", "r_rule_access.user_id = r_rule_user_group.group_user_id");
00593 sFklink("r_met2_access", "r_met2_tokn_accs", "r_met2_access.access_typ_id = r_met2_tokn_accs.token_id");
00594 sFklink("r_met2_access", "r_met2_user_group", "r_met2_access.user_id = r_met2_user_group.group_user_id");
00595 sFklink("r_resc_deny_access", "r_resc_tokn_deny_accs", "r_resc_deny_access.access_typ_id = r_resc_tokn_deny_accs.token_id");
00596 sFklink("r_resc_deny_access", "r_resc_da_user_group", "r_resc_deny_access.user_id = r_resc_da_user_group.group_user_id");
00597 sFklink("r_coll_deny_access", "r_coll_tokn_deny_accs", "r_coll_deny_access.access_typ_id = r_coll_tokn_deny_accs.token_id");
00598 sFklink("r_coll_deny_access", "r_coll_da_user_group", "r_coll_deny_access.user_id = r_coll_da_user_group.group_user_id");
00599 sFklink("r_data_deny_access", "r_data_tokn_deny_accs", "r_data_deny_access.access_typ_id = r_data_tokn_deny_accs.token_id");
00600 sFklink("r_data_deny_access", "r_data_da_user_group", "r_data_deny_access.user_id = r_data_da_user_group.group_user_id");
00601 sFklink("r_rule_deny_access", "r_rule_tokn_deny_accs", "r_rule_deny_access.access_typ_id = r_rule_tokn_deny_accs.token_id");
00602 sFklink("r_rule_deny_access", "r_rule_da_user_group", "r_rule_deny_access.user_id = r_rule_da_user_group.group_user_id");
00603 sFklink("r_met2_deny_access", "r_met2_tokn_deny_accs", "r_met2_deny_access.access_typ_id = r_met2_tokn_deny_accs.token_id");
00604 sFklink("r_met2_deny_access", "r_met2_da_user_group", "r_met2_deny_access.user_id = r_met2_da_user_group.group_user_id");
00605 sFklink("r_resc_audit", "r_resc_tokn_audit", "r_resc_audit.action_id = r_resc_tokn_audit.token_id");
00606 sFklink("r_resc_audit", "r_resc_au_user_group", "r_resc_audit.user_id = r_resc_au_user_group.group_user_id");
00607 sFklink("r_coll_audit", "r_coll_tokn_audit", "r_coll_audit.action_id = r_coll_tokn_audit.token_id");
00608 sFklink("r_coll_audit", "r_coll_au_user_group", "r_coll_audit.user_id = r_coll_au_user_group.group_user_id");
00609 sFklink("r_data_audit", "r_data_tokn_audit", "r_data_audit.action_id = r_data_tokn_audit.token_id");
00610 sFklink("r_data_audit", "r_data_au_user_group", "r_data_audit.user_id = r_data_au_user_group.group_user_id");
00611 sFklink("r_rule_audit", "r_rule_tokn_audit", "r_rule_audit.action_id = r_rule_tokn_audit.token_id");
00612 sFklink("r_rule_audit", "r_rule_au_user_group", "r_rule_audit.user_id = r_rule_au_user_group.group_user_id");
00613 sFklink("r_met2_audit", "r_met2_tokn_audit", "r_met2_audit.action_id = r_met2_tokn_audit.token_id");
00614 sFklink("r_met2_audit", "r_met2_au_user_group", "r_met2_audit.user_id = r_met2_au_user_group.group_user_id");
00615 sFklink("r_resc_user_group", "r_resc_user_main", "r_resc_user_group.user_id = r_resc_user_main.user_id");
00616 sFklink("r_coll_user_group", "r_coll_user_main", "r_coll_user_group.user_id = r_coll_user_main.user_id");
00617 sFklink("r_data_user_group", "r_data_user_main", "r_data_user_group.user_id = r_data_user_main.user_id");
00618 sFklink("r_rule_user_group", "r_rule_user_main", "r_rule_user_group.user_id = r_rule_user_main.user_id");
00619 sFklink("r_met2_user_group", "r_met2_user_main", "r_met2_user_group.user_id = r_met2_user_main.user_id");
00620 sFklink("r_resc_da_user_group", "r_resc_da_user_main", "r_resc_da_user_group.user_id = r_resc_da_user_main.user_id");
00621 sFklink("r_coll_da_user_group", "r_coll_da_user_main", "r_coll_da_user_group.user_id = r_coll_da_user_main.user_id");
00622 sFklink("r_data_da_user_group", "r_data_da_user_main", "r_data_da_user_group.user_id = r_data_da_user_main.user_id");
00623 sFklink("r_rule_da_user_group", "r_rule_da_user_main", "r_rule_da_user_group.user_id = r_rule_da_user_main.user_id");
00624 sFklink("r_met2_da_user_group", "r_met2_da_user_main", "r_met2_da_user_group.user_id = r_met2_da_user_main.user_id");
00625 sFklink("r_resc_au_user_group", "r_resc_au_user_main", "r_resc_au_user_group.user_id = r_resc_au_user_main.user_id");
00626 sFklink("r_coll_au_user_group", "r_coll_au_user_main", "r_coll_au_user_group.user_id = r_coll_au_user_main.user_id");
00627 sFklink("r_data_au_user_group", "r_data_au_user_main", "r_data_au_user_group.user_id = r_data_au_user_main.user_id");
00628 sFklink("r_rule_au_user_group", "r_rule_au_user_main", "r_rule_au_user_group.user_id = r_rule_au_user_main.user_id");
00629 sFklink("r_met2_au_user_group", "r_met2_au_user_main", "r_met2_au_user_group.user_id = r_met2_au_user_main.user_id");
00630 sFklink("R_USER_MAIN", "R_USER_PASSWORD", "R_USER_MAIN.user_id = R_USER_PASSWORD.user_id");
00631 sFklink("R_USER_MAIN", "R_USER_AUTH", "R_USER_MAIN.user_id = R_USER_AUTH.user_id");
00632 sFklink("R_USER_MAIN", "R_USER_SESSION_KEY", "R_USER_MAIN.user_id = R_USER_SESSION_KEY.user_id");
00633 sFklink("R_USER_MAIN", "r_data_access", "R_USER_MAIN.user_id = r_data_access.user_id");
00634 sFklink("R_USER_MAIN", "R_USER_GROUP", "R_USER_MAIN.user_id = R_USER_GROUP.user_id");
00635 sFklink("R_USER_GROUP", "r_group_main", "R_USER_GROUP.group_user_id = r_group_main.user_id");
00636 sFklink("R_USER_MAIN", "R_OBJT_AUDIT", "R_USER_MAIN.user_id = R_OBJT_AUDIT.user_id");
00637
00638 sFklink("R_QUOTA_MAIN", "r_quota_user_main", "R_QUOTA_MAIN.user_id = r_quota_user_main.user_id");
00639 sFklink("R_QUOTA_MAIN", "r_quota_resc_main", "R_QUOTA_MAIN.resc_id = r_quota_resc_main.resc_id");
00640 sFklink("R_QUOTA_MAIN", "r_quota_user_group", "R_QUOTA_MAIN.user_id = r_quota_user_group.user_id");
00641 sFklink("R_QUOTA_USAGE", "r_quota_user_main", "R_QUOTA_USAGE.user_id = r_quota_user_main.user_id");
00642 sFklink("R_QUOTA_USAGE", "r_quota_resc_main", "R_QUOTA_USAGE.resc_id = r_quota_resc_main.resc_id");
00643 sFklink("R_QUOTA_USAGE", "r_quota_user_group", "R_QUOTA_USAGE.user_id = r_quota_user_group.user_id");
00644 sFklink("R_RULE_BASE_MAP", "R_RULE_MAIN", "R_RULE_BASE_MAP.rule_id = R_RULE_MAIN.rule_id");
00645 sFklink("R_RULE_DVM_MAP", "R_RULE_DVM", "R_RULE_DVM_MAP.dvm_id = R_RULE_DVM.dvm_id");
00646 sFklink("R_RULE_FNM_MAP", "R_RULE_FNM", "R_RULE_FNM_MAP.fnm_id = R_RULE_FNM.fnm_id");
00647
00648
00649 sFklink("R_MICROSRVC_MAIN", "R_MICROSRVC_VER", "R_MICROSRVC_MAIN.msrvc_id = R_MICROSRVC_VER.msrvc_id");
00650 sFklink("R_MICROSRVC_MAIN", "r_msrvc_metamap", "R_MICROSRVC_MAIN.msrvc_id = r_msrvc_metamap.object_id");
00651 sFklink("r_msrvc_metamap", "r_msrvc_meta_main", "r_msrvc_metamap.meta_id = r_msrvc_meta_main.meta_id");
00652 sFklink("R_MICROSRVC_MAIN", "r_msrvc_access", "R_MICROSRVC_MAIN.msrvc_id = r_msrvc_access.object_id");
00653 sFklink("r_msrvc_access", "r_msrvc_tokn_accs", "r_msrvc_access.access_typ_id = r_msrvc_tokn_accs.token_id");
00654 sFklink("r_msrvc_access", "r_msrvc_user_group", "r_msrvc_access.user_id = r_msrvc_user_group.group_user_id");
00655 sFklink("r_msrvc_user_group", "r_msrvc_user_main", "r_msrvc_user_group.user_id = r_msrvc_user_main.user_id");
00656 sFklink("R_MICROSRVC_MAIN", "r_msrvc_deny_access", "R_MICROSRVC_MAIN.msrvc_id = r_msrvc_deny_access.object_id");
00657 sFklink("r_msrvc_deny_access", "r_msrvc_tokn_deny_accs", "r_msrvc_deny_access.access_typ_id = r_msrvc_tokn_deny_accs.token_id");
00658 sFklink("r_msrvc_deny_access", "r_msrvc_da_user_group", "r_msrvc_deny_access.user_id = r_msrvc_da_user_group.group_user_id");
00659 sFklink("r_msrvc_da_user_group", "r_msrvc_da_user_main", "r_msrvc_da_user_group.user_id = r_msrvc_da_user_main.user_id");
00660 sFklink("R_MICROSRVC_MAIN", "r_msrvc_audit", "R_MICROSRVC_MAIN.msrvc_id = r_msrvc_audit.object_id");
00661 sFklink("r_msrvc_audit", "r_msrvc_tokn_audit", "r_msrvc_audit.action_id = r_msrvc_tokn_audit.token_id");
00662 sFklink("r_msrvc_audit", "r_msrvc_au_user_group", "r_msrvc_audit.user_id = r_msrvc_au_user_group.group_user_id");
00663 sFklink("r_msrvc_au_user_group", "r_msrvc_au_user_main", "r_msrvc_au_user_group.user_id = r_msrvc_au_user_main.user_id");
00664
00665
00666
00667
00668
00669
00670
00671 #ifdef EXTENDED_ICAT
00672 for (i=0;i<NumOfExtTables;i++) {
00673 sTable(extTables[i].tableName, extTables[i].tableAlias, 0);
00674 }
00675 for (i=0;i<NumOfExtColumns;i++) {
00676 sColumn(extColumns[i].column_id,
00677 extColumns[i].column_table_name,
00678 extColumns[i].column_name);
00679 }
00680
00681 #ifdef EXTENDED_ICAT_TABLE_LINKS
00682 for (i=0;i<NumOfExtTableLinks;i++) {
00683 char linkString[200];
00684 snprintf(linkString, sizeof linkString, "%s.%s = %s.%s",
00685 extLinks[i].table1_name,
00686 extLinks[i].col1_name,
00687 extLinks[i].table2_name,
00688 extLinks[i].col2_name);
00689 sFklink(extLinks[i].table1_name, extLinks[i].table2_name, linkString);
00690 }
00691 #endif
00692
00693 #endif
00694
00695
00696 }