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
?>
inc
db.php
Generated by
1.8.4