source: trunk/www/Application/Model/TableRelations.php

Last change on this file was 93, checked in by chronos, 12 years ago
  • Fixed: System variable as parameter to constructors of descendents of Module class.
  • Removed: End PHP mark "?>" from all files.
  • Property svn:executable set to *
File size: 4.3 KB
Line 
1<?php
2
3$TableRelation = array(
4 array('Database' => 'characters', 'Table' => 'account_data', 'Relation' => array(
5 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
6 )),
7 array('Database' => 'characters', 'Table' => 'arena_team', 'Relation' => array(
8 )),
9 array('Database' => 'characters', 'Table' => 'arena_team_member', 'Relation' => array(
10 array('Database' => 'characters', 'Table' => 'arena_team', 'SourceColumn' => 'arenateamid', 'TargetColumn' => 'arenateamid'),
11 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
12 )),
13 array('Database' => 'characters', 'Table' => 'arena_team_stat', 'Relation' => array(
14 array('Database' => 'characters', 'Table' => 'arena_team', 'SourceColumn' => 'arenateamid', 'TargetColumn' => 'arenateamid'),
15 )),
16 array('Database' => 'characters', 'Table' => 'characters', 'Realation' => array(
17 array('Database' => 'realmd', 'Table' => 'account', 'SourceColumn' => 'account', 'TargetColumn' => 'id'),
18 )),
19 array('Database' => 'characters', 'Table' => 'character_achievement', 'Relation' => array(
20 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
21 )),
22 array('Database' => 'characters', 'Table' => 'character_achievement_progress', 'Relation' => array(
23 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
24 )),
25 array('Database' => 'characters', 'Table' => 'character_action', 'Relation' => array(
26 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
27 )),
28 array('Database' => 'characters', 'Table' => 'character_aura', 'Relation' => array(
29 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
30 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'caster', 'TargetColumn' => 'guid'),
31 )),
32 array('Database' => 'characters', 'Table' => 'character_db_version', 'Relation' => array(
33 )),
34 array('Database' => 'characters', 'Table' => 'character_declinedname', 'Relation' => array(
35 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
36 )),
37 array('Database' => 'characters', 'Table' => 'character_equipmentsets', 'Relation' => array(
38 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
39 )),
40 array('Database' => 'characters', 'Table' => 'character_gifts', 'Relation' => array(
41 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
42 )),
43 array('Database' => 'characters', 'Table' => 'character_homebind', 'Relation' => array(
44 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
45 )),
46 array('Database' => 'characters', 'Table' => 'character_instance', 'Relation' => array(
47 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
48 )),
49 array('Database' => 'characters', 'Table' => 'character_inventory', 'Relation' => array(
50 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
51 array('Database' => 'mangos', 'Table' => 'item_template', 'SourceColumn' => 'item_template', 'TargetColumn' => 'entry'),
52 )),
53 array('Database' => 'characters', 'Table' => 'character_pet', 'Relation' => array(
54 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'owner', 'TargetColumn' => 'guid'),
55 )),
56 array('Database' => 'characters', 'Table' => 'character_pet_declinedname', 'Relation' => array(
57 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'owner', 'TargetColumn' => 'guid'),
58 )),
59 array('Database' => 'characters', 'Table' => 'character_queststatus', 'Relation' => array(
60 array('Database' => 'characters', 'Table' => 'character', 'SourceColumn' => 'guid', 'TargetColumn' => 'guid'),
61 array('Database' => 'mangos', 'Table' => 'quest_template', 'SourceColumn' => 'quest', 'TargetColumn' => 'entry'),
62 )),
63
64);
Note: See TracBrowser for help on using the repository browser.