Sponsorenverwaltung - Team StarCraft e.V.
 All Data Structures Files Functions Variables
db.php
Go to the documentation of this file.
1 <?php
2  /**
3  * @file db.php
4  *
5  * @brief Holds two global arrays ($db, $dbBack) containing the names of
6  * all of the tables in the datebase.
7  *
8  * @details
9  * Holds two global arrays ($db, $dbBack) containing the names of
10  * all of the tables in the datebase. These arrays are used in the
11  * vast majority of SQL-statements.
12  *
13  * This file depends on inc/mysql.php.
14  *
15  * @copyright (c) 2013, Team StarCraft e.V.
16  * @version 1.0.0
17  * @author Daniel Seichter
18  *
19  */
20  require_once(ABS_PATH.'inc/mysql.php');
21 
22  //! holds the names of sponsoring and usercake tables
23  $db = array(
24  'configuration' => MYSQL_PREFIX_USERCAKE.'configuration',
25  'pages' => MYSQL_PREFIX_USERCAKE.'pages',
26  'permissions' => MYSQL_PREFIX_USERCAKE.'permissions',
27  'users' => MYSQL_PREFIX_USERCAKE.'users',
28  'user_permission' => MYSQL_PREFIX_USERCAKE.'user_permission_matches',
29  'car' => MYSQL_PREFIX.'car',
30  'category' => MYSQL_PREFIX.'category',
31  'contact_person' => MYSQL_PREFIX.'contact_person',
32  'production_facility' => MYSQL_PREFIX.'production_facility',
33  'sc_attachment' => MYSQL_PREFIX.'sc_attachment',
34  'sc_event' => MYSQL_PREFIX.'sc_event',
35  'sc_financial_donation' => MYSQL_PREFIX.'sc_financial_donation',
36  'sc_material_donation' => MYSQL_PREFIX.'sc_material_donation',
37  'sc_produced_part' => MYSQL_PREFIX.'sc_produced_part',
38  'sponsor' => MYSQL_PREFIX.'sponsor',
39  'sponsor_car' => MYSQL_PREFIX.'sponsor_car',
40  'sp_production_facility' => MYSQL_PREFIX.'sp_production_facility',
41  'status' => MYSQL_PREFIX.'status');
42 
43  //! holds the names of the sponsoring backup tables
44  $dbBackup = array(
45  'car' => MYSQL_PREFIX_BACKUP.'car',
46  'category' => MYSQL_PREFIX_BACKUP.'category',
47  'contact_person' => MYSQL_PREFIX_BACKUP.'contact_person',
48  'production_facility' => MYSQL_PREFIX_BACKUP.'production_facility',
49  'sc_attachment' => MYSQL_PREFIX_BACKUP.'sc_attachment',
50  'sc_event' => MYSQL_PREFIX_BACKUP.'sc_event',
51  'sc_financial_donation' => MYSQL_PREFIX_BACKUP.'sc_financial_donation',
52  'sc_material_donation' => MYSQL_PREFIX_BACKUP.'sc_material_donation',
53  'sc_produced_part' => MYSQL_PREFIX_BACKUP.'sc_produced_part',
54  'sponsor' => MYSQL_PREFIX_BACKUP.'sponsor',
55  'sponsor_car' => MYSQL_PREFIX_BACKUP.'sponsor_car',
56  'sp_production_facility' => MYSQL_PREFIX_BACKUP.'sp_production_facility',
57  'status' => MYSQL_PREFIX_BACKUP.'status');
58 ?>