| Index: trunk/extensions/DataCenter/DataCenter.sql |
| — | — | @@ -4,7 +4,7 @@ |
| 5 | 5 | -- Facilities |
| 6 | 6 | -- |
| 7 | 7 | -- Table of locations of physical datacenters |
| 8 | | -DROP TABLE IF EXISTS dc_facility_locations; |
| | 8 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_facility_locations; |
| 9 | 9 | CREATE TABLE /*$wgDBprefix*/dc_facility_locations ( |
| 10 | 10 | -- Unique ID of dc_locations |
| 11 | 11 | fcl_loc_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -23,7 +23,7 @@ |
| 24 | 24 | ) /*$wgDBTableOptions*/; |
| 25 | 25 | -- |
| 26 | 26 | -- Table of spaces in locations |
| 27 | | -DROP TABLE IF EXISTS dc_facility_spaces; |
| | 27 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_facility_spaces; |
| 28 | 28 | CREATE TABLE /*$wgDBprefix*/dc_facility_spaces ( |
| 29 | 29 | -- Unique ID of dc_spaces |
| 30 | 30 | fcl_spc_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -48,7 +48,7 @@ |
| 49 | 49 | -- Assets |
| 50 | 50 | -- |
| 51 | 51 | -- Table of racks |
| 52 | | -DROP TABLE IF EXISTS dc_rack_assets; |
| | 52 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_rack_assets; |
| 53 | 53 | CREATE TABLE /*$wgDBprefix*/dc_rack_assets ( |
| 54 | 54 | -- Unique ID of dc_racks |
| 55 | 55 | ast_rak_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -67,7 +67,7 @@ |
| 68 | 68 | ) /*$wgDBTableOptions*/; |
| 69 | 69 | -- |
| 70 | 70 | -- Table of objects |
| 71 | | -DROP TABLE IF EXISTS dc_object_assets; |
| | 71 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_object_assets; |
| 72 | 72 | CREATE TABLE /*$wgDBprefix*/dc_object_assets ( |
| 73 | 73 | -- Unique ID of dc_objects |
| 74 | 74 | ast_obj_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -88,7 +88,7 @@ |
| 89 | 89 | -- Models |
| 90 | 90 | -- |
| 91 | 91 | -- Table of model of racks |
| 92 | | -DROP TABLE IF EXISTS dc_rack_models; |
| | 92 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_rack_models; |
| 93 | 93 | CREATE TABLE /*$wgDBprefix*/dc_rack_models ( |
| 94 | 94 | -- Unique ID of dc_rack_models |
| 95 | 95 | mdl_rak_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -105,7 +105,7 @@ |
| 106 | 106 | ) /*$wgDBTableOptions*/; |
| 107 | 107 | -- |
| 108 | 108 | -- Table of model of objects |
| 109 | | -DROP TABLE IF EXISTS dc_object_models; |
| | 109 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_object_models; |
| 110 | 110 | CREATE TABLE /*$wgDBprefix*/dc_object_models ( |
| 111 | 111 | -- Unique ID of dc_object_models |
| 112 | 112 | mdl_obj_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -133,7 +133,7 @@ |
| 134 | 134 | ) /*$wgDBTableOptions*/; |
| 135 | 135 | -- |
| 136 | 136 | -- Table of models of ports |
| 137 | | -DROP TABLE IF EXISTS dc_port_models; |
| | 137 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_port_models; |
| 138 | 138 | CREATE TABLE /*$wgDBprefix*/dc_port_models ( |
| 139 | 139 | -- Unique ID of dc_port_models |
| 140 | 140 | mdl_prt_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -168,7 +168,7 @@ |
| 169 | 169 | -- Meta Information |
| 170 | 170 | -- |
| 171 | 171 | -- Table of tags used to categorize repairs |
| 172 | | -DROP TABLE IF EXISTS dc_meta_tags; |
| | 172 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_meta_tags; |
| 173 | 173 | CREATE TABLE /*$wgDBprefix*/dc_meta_tags ( |
| 174 | 174 | -- Unique ID of dc_tags |
| 175 | 175 | mta_tag_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -179,7 +179,7 @@ |
| 180 | 180 | ) /*$wgDBTableOptions*/; |
| 181 | 181 | -- |
| 182 | 182 | -- |
| 183 | | -DROP TABLE IF EXISTS dc_meta_plans; |
| | 183 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_meta_plans; |
| 184 | 184 | CREATE TABLE /*$wgDBprefix*/dc_meta_plans ( |
| 185 | 185 | -- Unique ID of dc_meta_plans |
| 186 | 186 | mta_pln_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -196,7 +196,7 @@ |
| 197 | 197 | ) /*$wgDBTableOptions*/; |
| 198 | 198 | -- |
| 199 | 199 | -- Table of changes made to targets (facilities, assets and models) |
| 200 | | -DROP TABLE IF EXISTS dc_meta_changes; |
| | 200 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_meta_changes; |
| 201 | 201 | CREATE TABLE /*$wgDBprefix*/dc_meta_changes ( |
| 202 | 202 | -- Unique ID of dc_meta_changes |
| 203 | 203 | mta_cng_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -232,7 +232,7 @@ |
| 233 | 233 | ) /*$wgDBTableOptions*/; |
| 234 | 234 | -- |
| 235 | 235 | -- Table of models used by other models |
| 236 | | -DROP TABLE IF EXISTS dc_model_links; |
| | 236 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_model_links; |
| 237 | 237 | CREATE TABLE /*$wgDBprefix*/dc_model_links ( |
| 238 | 238 | -- Unique ID of dc_meta_model_links |
| 239 | 239 | lnk_mdl_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -258,7 +258,7 @@ |
| 259 | 259 | ) /*$wgDBTableOptions*/; |
| 260 | 260 | -- |
| 261 | 261 | -- Table of assets used by other assets |
| 262 | | -DROP TABLE IF EXISTS dc_asset_links; |
| | 262 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_asset_links; |
| 263 | 263 | CREATE TABLE /*$wgDBprefix*/dc_asset_links ( |
| 264 | 264 | -- Unique ID of dc_meta_asset_links |
| 265 | 265 | lnk_ast_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -290,7 +290,7 @@ |
| 291 | 291 | ) /*$wgDBTableOptions*/; |
| 292 | 292 | -- |
| 293 | 293 | -- Table of meta fields to attach to components |
| 294 | | -DROP TABLE IF EXISTS dc_field_links; |
| | 294 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_field_links; |
| 295 | 295 | CREATE TABLE /*$wgDBprefix*/dc_field_links ( |
| 296 | 296 | -- Unique ID of dc_meta_field_links |
| 297 | 297 | lnk_fld_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -316,7 +316,7 @@ |
| 317 | 317 | ) /*$wgDBTableOptions*/; |
| 318 | 318 | -- |
| 319 | 319 | -- Table of meta fields to attach to models |
| 320 | | -DROP TABLE IF EXISTS dc_meta_fields; |
| | 320 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_meta_fields; |
| 321 | 321 | CREATE TABLE /*$wgDBprefix*/dc_meta_fields ( |
| 322 | 322 | -- Unique ID of dc_meta_fields |
| 323 | 323 | mta_fld_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -335,7 +335,7 @@ |
| 336 | 336 | ) /*$wgDBTableOptions*/; |
| 337 | 337 | -- |
| 338 | 338 | -- Table of meta information to attach to assets |
| 339 | | -DROP TABLE IF EXISTS dc_meta_values; |
| | 339 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_meta_values; |
| 340 | 340 | CREATE TABLE /*$wgDBprefix*/dc_meta_values ( |
| 341 | 341 | -- Unique ID of dc_meta_values |
| 342 | 342 | mta_val_id INTEGER AUTO_INCREMENT, |
| — | — | @@ -365,7 +365,7 @@ |
| 366 | 366 | ) /*$wgDBTableOptions*/; |
| 367 | 367 | -- |
| 368 | 368 | -- Table of connections between ports |
| 369 | | -DROP TABLE IF EXISTS dc_meta_connections; |
| | 369 | +DROP TABLE IF EXISTS /*$wgDBprefix*/dc_meta_connections; |
| 370 | 370 | CREATE TABLE /*$wgDBprefix*/dc_meta_connections ( |
| 371 | 371 | -- Unique ID of dc_connections |
| 372 | 372 | mta_con_id INTEGER AUTO_INCREMENT, |