| Index: trunk/extensions/DataCenter/DataCenter.sql |
| — | — | @@ -5,7 +5,7 @@ |
| 6 | 6 | -- |
| 7 | 7 | -- Table of locations of physical datacenters |
| 8 | 8 | DROP TABLE IF EXISTS dc_facility_locations; |
| 9 | | -CREATE TABLE /*$wgDBPrefix*/dc_facility_locations ( |
| | 9 | +CREATE TABLE /*$wgDBprefix*/dc_facility_locations ( |
| 10 | 10 | -- Unique ID of dc_locations |
| 11 | 11 | fcl_loc_id INTEGER AUTO_INCREMENT, |
| 12 | 12 | -- Tense of this rack |
| — | — | @@ -24,7 +24,7 @@ |
| 25 | 25 | -- |
| 26 | 26 | -- Table of spaces in locations |
| 27 | 27 | DROP TABLE IF EXISTS dc_facility_spaces; |
| 28 | | -CREATE TABLE /*$wgDBPrefix*/dc_facility_spaces ( |
| | 28 | +CREATE TABLE /*$wgDBprefix*/dc_facility_spaces ( |
| 29 | 29 | -- Unique ID of dc_spaces |
| 30 | 30 | fcl_spc_id INTEGER AUTO_INCREMENT, |
| 31 | 31 | -- Tense of this rack |
| — | — | @@ -49,7 +49,7 @@ |
| 50 | 50 | -- |
| 51 | 51 | -- Table of racks |
| 52 | 52 | DROP TABLE IF EXISTS dc_rack_assets; |
| 53 | | -CREATE TABLE /*$wgDBPrefix*/dc_rack_assets ( |
| | 53 | +CREATE TABLE /*$wgDBprefix*/dc_rack_assets ( |
| 54 | 54 | -- Unique ID of dc_racks |
| 55 | 55 | ast_rak_id INTEGER AUTO_INCREMENT, |
| 56 | 56 | -- Tense of this racj |
| — | — | @@ -68,7 +68,7 @@ |
| 69 | 69 | -- |
| 70 | 70 | -- Table of objects |
| 71 | 71 | DROP TABLE IF EXISTS dc_object_assets; |
| 72 | | -CREATE TABLE /*$wgDBPrefix*/dc_object_assets ( |
| | 72 | +CREATE TABLE /*$wgDBprefix*/dc_object_assets ( |
| 73 | 73 | -- Unique ID of dc_objects |
| 74 | 74 | ast_obj_id INTEGER AUTO_INCREMENT, |
| 75 | 75 | -- Tense of this rack |
| — | — | @@ -89,7 +89,7 @@ |
| 90 | 90 | -- |
| 91 | 91 | -- Table of model of racks |
| 92 | 92 | DROP TABLE IF EXISTS dc_rack_models; |
| 93 | | -CREATE TABLE /*$wgDBPrefix*/dc_rack_models ( |
| | 93 | +CREATE TABLE /*$wgDBprefix*/dc_rack_models ( |
| 94 | 94 | -- Unique ID of dc_rack_models |
| 95 | 95 | mdl_rak_id INTEGER AUTO_INCREMENT, |
| 96 | 96 | -- Manufacturer name of this rack model |
| — | — | @@ -106,7 +106,7 @@ |
| 107 | 107 | -- |
| 108 | 108 | -- Table of model of objects |
| 109 | 109 | DROP TABLE IF EXISTS dc_object_models; |
| 110 | | -CREATE TABLE /*$wgDBPrefix*/dc_object_models ( |
| | 110 | +CREATE TABLE /*$wgDBprefix*/dc_object_models ( |
| 111 | 111 | -- Unique ID of dc_object_models |
| 112 | 112 | mdl_obj_id INTEGER AUTO_INCREMENT, |
| 113 | 113 | -- Manufacturer name of this object model |
| — | — | @@ -134,7 +134,7 @@ |
| 135 | 135 | -- |
| 136 | 136 | -- Table of models of ports |
| 137 | 137 | DROP TABLE IF EXISTS dc_port_models; |
| 138 | | -CREATE TABLE /*$wgDBPrefix*/dc_port_models ( |
| | 138 | +CREATE TABLE /*$wgDBprefix*/dc_port_models ( |
| 139 | 139 | -- Unique ID of dc_port_models |
| 140 | 140 | mdl_prt_id INTEGER AUTO_INCREMENT, |
| 141 | 141 | -- Name of this port model |
| — | — | @@ -169,7 +169,7 @@ |
| 170 | 170 | -- |
| 171 | 171 | -- Table of tags used to categorize repairs |
| 172 | 172 | DROP TABLE IF EXISTS dc_meta_tags; |
| 173 | | -CREATE TABLE /*$wgDBPrefix*/dc_meta_tags ( |
| | 173 | +CREATE TABLE /*$wgDBprefix*/dc_meta_tags ( |
| 174 | 174 | -- Unique ID of dc_tags |
| 175 | 175 | mta_tag_id INTEGER AUTO_INCREMENT, |
| 176 | 176 | -- Name of this tag |
| — | — | @@ -180,7 +180,7 @@ |
| 181 | 181 | -- |
| 182 | 182 | -- |
| 183 | 183 | DROP TABLE IF EXISTS dc_meta_plans; |
| 184 | | -CREATE TABLE /*$wgDBPrefix*/dc_meta_plans ( |
| | 184 | +CREATE TABLE /*$wgDBprefix*/dc_meta_plans ( |
| 185 | 185 | -- Unique ID of dc_meta_plans |
| 186 | 186 | mta_pln_id INTEGER AUTO_INCREMENT, |
| 187 | 187 | -- Name of this plan |
| — | — | @@ -197,7 +197,7 @@ |
| 198 | 198 | -- |
| 199 | 199 | -- Table of changes made to targets (facilities, assets and models) |
| 200 | 200 | DROP TABLE IF EXISTS dc_meta_changes; |
| 201 | | -CREATE TABLE /*$wgDBPrefix*/dc_meta_changes ( |
| | 201 | +CREATE TABLE /*$wgDBprefix*/dc_meta_changes ( |
| 202 | 202 | -- Unique ID of dc_meta_changes |
| 203 | 203 | mta_cng_id INTEGER AUTO_INCREMENT, |
| 204 | 204 | -- ID of user who made change |
| — | — | @@ -233,7 +233,7 @@ |
| 234 | 234 | -- |
| 235 | 235 | -- Table of models used by other models |
| 236 | 236 | DROP TABLE IF EXISTS dc_model_links; |
| 237 | | -CREATE TABLE /*$wgDBPrefix*/dc_model_links ( |
| | 237 | +CREATE TABLE /*$wgDBprefix*/dc_model_links ( |
| 238 | 238 | -- Unique ID of dc_meta_model_links |
| 239 | 239 | lnk_mdl_id INTEGER AUTO_INCREMENT, |
| 240 | 240 | -- Name of this link |
| — | — | @@ -259,7 +259,7 @@ |
| 260 | 260 | -- |
| 261 | 261 | -- Table of assets used by other assets |
| 262 | 262 | DROP TABLE IF EXISTS dc_asset_links; |
| 263 | | -CREATE TABLE /*$wgDBPrefix*/dc_asset_links ( |
| | 263 | +CREATE TABLE /*$wgDBprefix*/dc_asset_links ( |
| 264 | 264 | -- Unique ID of dc_meta_asset_links |
| 265 | 265 | lnk_ast_id INTEGER AUTO_INCREMENT, |
| 266 | 266 | -- Name of this asset |
| — | — | @@ -291,7 +291,7 @@ |
| 292 | 292 | -- |
| 293 | 293 | -- Table of meta fields to attach to components |
| 294 | 294 | DROP TABLE IF EXISTS dc_field_links; |
| 295 | | -CREATE TABLE /*$wgDBPrefix*/dc_field_links ( |
| | 295 | +CREATE TABLE /*$wgDBprefix*/dc_field_links ( |
| 296 | 296 | -- Unique ID of dc_meta_field_links |
| 297 | 297 | lnk_fld_id INTEGER AUTO_INCREMENT, |
| 298 | 298 | -- ID of field to attach |
| — | — | @@ -317,7 +317,7 @@ |
| 318 | 318 | -- |
| 319 | 319 | -- Table of meta fields to attach to models |
| 320 | 320 | DROP TABLE IF EXISTS dc_meta_fields; |
| 321 | | -CREATE TABLE /*$wgDBPrefix*/dc_meta_fields ( |
| | 321 | +CREATE TABLE /*$wgDBprefix*/dc_meta_fields ( |
| 322 | 322 | -- Unique ID of dc_meta_fields |
| 323 | 323 | mta_fld_id INTEGER AUTO_INCREMENT, |
| 324 | 324 | -- Name of this meta field |
| — | — | @@ -336,7 +336,7 @@ |
| 337 | 337 | -- |
| 338 | 338 | -- Table of meta information to attach to assets |
| 339 | 339 | DROP TABLE IF EXISTS dc_meta_values; |
| 340 | | -CREATE TABLE /*$wgDBPrefix*/dc_meta_values ( |
| | 340 | +CREATE TABLE /*$wgDBprefix*/dc_meta_values ( |
| 341 | 341 | -- Unique ID of dc_meta_values |
| 342 | 342 | mta_val_id INTEGER AUTO_INCREMENT, |
| 343 | 343 | -- Category of component type |
| — | — | @@ -366,7 +366,7 @@ |
| 367 | 367 | -- |
| 368 | 368 | -- Table of connections between ports |
| 369 | 369 | DROP TABLE IF EXISTS dc_meta_connections; |
| 370 | | -CREATE TABLE /*$wgDBPrefix*/dc_meta_connections ( |
| | 370 | +CREATE TABLE /*$wgDBprefix*/dc_meta_connections ( |
| 371 | 371 | -- Unique ID of dc_connections |
| 372 | 372 | mta_con_id INTEGER AUTO_INCREMENT, |
| 373 | 373 | -- ID of port being connected from |