· 9 years ago · Jan 02, 2017, 04:00 PM
1-- phpMyAdmin SQL Dump
2-- version 4.3.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Erstellungszeit: 02. Jan 2017 um 16:55
7-- Server-Version: 5.6.24
8-- PHP-Version: 5.6.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Datenbank: `sieben`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabellenstruktur für Tabelle `guests`
27--
28
29CREATE TABLE IF NOT EXISTS `guests` (
30 `gid` int(11) NOT NULL,
31 `gname` varchar(24) NOT NULL,
32 `gtel` varchar(25) NOT NULL,
33 `gpw` char(64) NOT NULL,
34 `gemail` varchar(64) NOT NULL,
35 `gcontact` text NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38-- --------------------------------------------------------
39
40--
41-- Tabellenstruktur für Tabelle `settings`
42--
43
44CREATE TABLE IF NOT EXISTS `settings` (
45 `setting_id` int(11) NOT NULL,
46 `setting_name` varchar(24) NOT NULL,
47 `setting_value` int(11) NOT NULL,
48 `setting_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
49) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
50
51--
52-- Daten für Tabelle `settings`
53--
54
55INSERT INTO `settings` (`setting_id`, `setting_name`, `setting_value`, `setting_timestamp`) VALUES
56(1, 'days', 7, '2016-12-20 16:38:23'),
57(2, 'yearback', 1, '2016-12-20 08:41:44'),
58(3, 'yearforward', 3, '2016-12-20 08:41:44'),
59(4, 'wh_start', 8, '2016-12-20 08:41:44'),
60(5, 'wh_end', 18, '2016-12-20 08:41:44'),
61(6, 'minutes', 20, '2016-12-20 17:40:05');
62
63-- --------------------------------------------------------
64
65--
66-- Tabellenstruktur für Tabelle `termins`
67--
68
69CREATE TABLE IF NOT EXISTS `termins` (
70 `tid` int(11) NOT NULL,
71 `t_date` date NOT NULL,
72 `t_time` time NOT NULL,
73 `t_type` int(11) NOT NULL,
74 `t_note` text,
75 `t_status` int(11) NOT NULL,
76 `t_person` int(11) NOT NULL
77) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
78
79--
80-- Daten für Tabelle `termins`
81--
82
83INSERT INTO `termins` (`tid`, `t_date`, `t_time`, `t_type`, `t_note`, `t_status`, `t_person`) VALUES
84(1, '2016-12-20', '12:40:00', 3, 'NemszámÃt', 0, 1),
85(2, '2016-12-20', '14:20:00', 5, NULL, 0, 0),
86(3, '2016-12-20', '17:40:00', 0, NULL, 0, 0);
87
88-- --------------------------------------------------------
89
90--
91-- Tabellenstruktur für Tabelle `types`
92--
93
94CREATE TABLE IF NOT EXISTS `types` (
95 `typeid` int(11) NOT NULL,
96 `typename` varchar(64) NOT NULL,
97 `typedesc` text NOT NULL,
98 `typecolor` char(7) NOT NULL
99) ENGINE=InnoDB DEFAULT CHARSET=latin1;
100
101-- --------------------------------------------------------
102
103--
104-- Tabellenstruktur für Tabelle `whours`
105--
106
107CREATE TABLE IF NOT EXISTS `whours` (
108 `wh_id` int(11) NOT NULL,
109 `wh_start` time NOT NULL,
110 `wh_end` time NOT NULL,
111 `wh_spec` tinyint(1) NOT NULL DEFAULT '0',
112 `wh_working` tinyint(1) NOT NULL DEFAULT '1',
113 `wh_mo` tinyint(1) NOT NULL DEFAULT '1',
114 `wh_di` tinyint(1) NOT NULL DEFAULT '1',
115 `wh_mi` tinyint(1) NOT NULL DEFAULT '1',
116 `wh_do` tinyint(1) NOT NULL DEFAULT '1',
117 `wh_fr` tinyint(1) NOT NULL DEFAULT '1',
118 `wh_sa` tinyint(1) NOT NULL DEFAULT '0',
119 `wh_so` tinyint(1) NOT NULL DEFAULT '0'
120) ENGINE=InnoDB DEFAULT CHARSET=latin1;
121
122-- --------------------------------------------------------
123
124--
125-- Tabellenstruktur für Tabelle `wh_specials`
126--
127
128CREATE TABLE IF NOT EXISTS `wh_specials` (
129 `wh_spec_id` int(11) NOT NULL,
130 `wh_id` int(11) NOT NULL,
131 `wh_spec_date` int(11) NOT NULL
132) ENGINE=InnoDB DEFAULT CHARSET=latin1;
133
134--
135-- Indizes der exportierten Tabellen
136--
137
138--
139-- Indizes für die Tabelle `guests`
140--
141ALTER TABLE `guests`
142 ADD PRIMARY KEY (`gid`);
143
144--
145-- Indizes für die Tabelle `settings`
146--
147ALTER TABLE `settings`
148 ADD PRIMARY KEY (`setting_id`);
149
150--
151-- Indizes für die Tabelle `termins`
152--
153ALTER TABLE `termins`
154 ADD PRIMARY KEY (`tid`);
155
156--
157-- Indizes für die Tabelle `types`
158--
159ALTER TABLE `types`
160 ADD PRIMARY KEY (`typeid`);
161
162--
163-- Indizes für die Tabelle `whours`
164--
165ALTER TABLE `whours`
166 ADD PRIMARY KEY (`wh_id`);
167
168--
169-- Indizes für die Tabelle `wh_specials`
170--
171ALTER TABLE `wh_specials`
172 ADD PRIMARY KEY (`wh_spec_id`);
173
174--
175-- AUTO_INCREMENT für exportierte Tabellen
176--
177
178--
179-- AUTO_INCREMENT für Tabelle `guests`
180--
181ALTER TABLE `guests`
182 MODIFY `gid` int(11) NOT NULL AUTO_INCREMENT;
183--
184-- AUTO_INCREMENT für Tabelle `settings`
185--
186ALTER TABLE `settings`
187 MODIFY `setting_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
188--
189-- AUTO_INCREMENT für Tabelle `termins`
190--
191ALTER TABLE `termins`
192 MODIFY `tid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
193--
194-- AUTO_INCREMENT für Tabelle `types`
195--
196ALTER TABLE `types`
197 MODIFY `typeid` int(11) NOT NULL AUTO_INCREMENT;
198--
199-- AUTO_INCREMENT für Tabelle `whours`
200--
201ALTER TABLE `whours`
202 MODIFY `wh_id` int(11) NOT NULL AUTO_INCREMENT;
203--
204-- AUTO_INCREMENT für Tabelle `wh_specials`
205--
206ALTER TABLE `wh_specials`
207 MODIFY `wh_spec_id` int(11) NOT NULL AUTO_INCREMENT;
208/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
209/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
210/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;