| Index: trunk/extensions/DataCenter/DataCenter.sql |
| — | — | @@ -379,7 +379,7 @@ |
| 380 | 380 | -- |
| 381 | 381 | -- Initial Facilities |
| 382 | 382 | -- |
| 383 | | -INSERT INTO dc_facility_locations |
| | 383 | +INSERT INTO /*$wgDBprefix*/dc_facility_locations |
| 384 | 384 | ( |
| 385 | 385 | fcl_loc_tense, fcl_loc_name, fcl_loc_region, fcl_loc_latitude, |
| 386 | 386 | fcl_loc_longitude |
| — | — | @@ -388,7 +388,7 @@ |
| 389 | 389 | ( 'present', 'PMTPA', 'Tampa, FL', 27.98141, -82.451141 ), |
| 390 | 390 | ( 'present', 'SFO', 'San Francisco, CA', 37.775196, -122.419204 ); |
| 391 | 391 | -- |
| 392 | | -INSERT INTO dc_facility_spaces |
| | 392 | +INSERT INTO /*$wgDBprefix*/dc_facility_spaces |
| 393 | 393 | ( |
| 394 | 394 | fcl_spc_tense, fcl_spc_name, fcl_spc_location, fcl_spc_width, |
| 395 | 395 | fcl_spc_height, fcl_spc_depth, fcl_spc_power |
| — | — | @@ -399,7 +399,7 @@ |
| 400 | 400 | -- |
| 401 | 401 | -- Initial Assets |
| 402 | 402 | -- |
| 403 | | -INSERT INTO dc_rack_assets |
| | 403 | +INSERT INTO /*$wgDBprefix*/dc_rack_assets |
| 404 | 404 | ( |
| 405 | 405 | ast_rak_model, ast_rak_tense, ast_rak_location, ast_rak_asset, |
| 406 | 406 | ast_rak_serial |
| — | — | @@ -412,7 +412,7 @@ |
| 413 | 413 | ( 2, 'present', 1, '5670556705', 'A1S2D3F4G5H6J7' ), |
| 414 | 414 | ( 2, 'present', 2, '6780667806', 'Z1X2C3V4B5N6M7' ); |
| 415 | 415 | -- |
| 416 | | -INSERT INTO dc_object_assets |
| | 416 | +INSERT INTO /*$wgDBprefix*/dc_object_assets |
| 417 | 417 | ( |
| 418 | 418 | ast_obj_model, ast_obj_tense, ast_obj_location, ast_obj_asset, |
| 419 | 419 | ast_obj_serial |
| — | — | @@ -427,7 +427,7 @@ |
| 428 | 428 | -- |
| 429 | 429 | -- Initial Models |
| 430 | 430 | -- |
| 431 | | -INSERT INTO dc_rack_models |
| | 431 | +INSERT INTO /*$wgDBprefix*/dc_rack_models |
| 432 | 432 | ( |
| 433 | 433 | mdl_rak_manufacturer, mdl_rak_name, mdl_rak_kind, mdl_rak_units |
| 434 | 434 | ) |
| — | — | @@ -436,7 +436,7 @@ |
| 437 | 437 | ( 'Rittal', 'TS-44', 'Rack', 44 ), |
| 438 | 438 | ( 'Rittal', 'TS-47', 'Rack', 47 ); |
| 439 | 439 | -- |
| 440 | | -INSERT INTO dc_object_models |
| | 440 | +INSERT INTO /*$wgDBprefix*/dc_object_models |
| 441 | 441 | ( |
| 442 | 442 | mdl_obj_manufacturer, mdl_obj_name, mdl_obj_kind, mdl_obj_form_factor, |
| 443 | 443 | mdl_obj_units, mdl_obj_depth, mdl_obj_power |
| — | — | @@ -446,7 +446,7 @@ |
| 447 | 447 | ( 'Cisco', 'Catalyst 2950', 'Switch', 'rackunit', 1, 1, 100 ), |
| 448 | 448 | ( 'APC', 'Smart-UPS 3000VA', 'UPS', 'rackunit', 5, 2, 20 ); |
| 449 | 449 | -- |
| 450 | | -INSERT INTO dc_port_models |
| | 450 | +INSERT INTO /*$wgDBprefix*/dc_port_models |
| 451 | 451 | ( |
| 452 | 452 | mdl_prt_name, mdl_prt_kind, mdl_prt_category, mdl_prt_format |
| 453 | 453 | ) |
| — | — | @@ -497,7 +497,7 @@ |
| 498 | 498 | -- |
| 499 | 499 | -- Initial Meta |
| 500 | 500 | -- |
| 501 | | -INSERT INTO dc_meta_fields |
| | 501 | +INSERT INTO /*$wgDBprefix*/dc_meta_fields |
| 502 | 502 | ( |
| 503 | 503 | mta_fld_name, mta_fld_format |
| 504 | 504 | ) |
| — | — | @@ -507,7 +507,7 @@ |
| 508 | 508 | ( 'Weight (LBS)', 'number' ), |
| 509 | 509 | ( 'Assigned User', 'string' ); |
| 510 | 510 | -- |
| 511 | | -INSERT INTO dc_meta_values |
| | 511 | +INSERT INTO /*$wgDBprefix*/dc_meta_values |
| 512 | 512 | ( |
| 513 | 513 | mta_val_component_category, mta_val_component_type, |
| 514 | 514 | mta_val_component_id, mta_val_field, mta_val_value |
| — | — | @@ -516,7 +516,7 @@ |
| 517 | 517 | ( 'facility', 'location', 2, 1, true ), |
| 518 | 518 | ( 'facility', 'location', 2, 2, 'The best place to be!' ); |
| 519 | 519 | -- |
| 520 | | -INSERT INTO dc_meta_plans |
| | 520 | +INSERT INTO /*$wgDBprefix*/dc_meta_plans |
| 521 | 521 | ( |
| 522 | 522 | mta_pln_tense, mta_pln_space, mta_pln_name, mta_pln_note |
| 523 | 523 | ) |
| — | — | @@ -527,7 +527,7 @@ |
| 528 | 528 | -- |
| 529 | 529 | -- Initial Links |
| 530 | 530 | -- |
| 531 | | -INSERT INTO dc_asset_links |
| | 531 | +INSERT INTO /*$wgDBprefix*/dc_asset_links |
| 532 | 532 | ( |
| 533 | 533 | lnk_ast_name, lnk_ast_plan, lnk_ast_tense, lnk_ast_parent_link, |
| 534 | 534 | lnk_ast_asset_type, lnk_ast_asset_id, lnk_ast_x, lnk_ast_y, lnk_ast_z, |
| — | — | @@ -547,7 +547,7 @@ |
| 548 | 548 | ( 'Switch', 2, 'present', 6, 'object', 5, null, null, 9, 0 ), |
| 549 | 549 | ( 'UPS', 2, 'present', 6, 'object', 6, null, null, 10, 0 ); |
| 550 | 550 | -- |
| 551 | | -INSERT INTO dc_model_links |
| | 551 | +INSERT INTO /*$wgDBprefix*/dc_model_links |
| 552 | 552 | ( |
| 553 | 553 | lnk_mdl_name, lnk_mdl_quantity, lnk_mdl_parent_type, |
| 554 | 554 | lnk_mdl_parent_id, lnk_mdl_child_type, lnk_mdl_child_id |
| — | — | @@ -558,7 +558,7 @@ |
| 559 | 559 | ( 'Power In', 1, 'object', 3, 'port', 27 ), |
| 560 | 560 | ( 'Power Out', 8, 'object', 3, 'port', 24 ); |
| 561 | 561 | -- |
| 562 | | -INSERT INTO dc_field_links |
| | 562 | +INSERT INTO /*$wgDBprefix*/dc_field_links |
| 563 | 563 | ( |
| 564 | 564 | lnk_fld_field, lnk_fld_component_category, lnk_fld_component_type |
| 565 | 565 | ) |