1 |
-- phpMyAdmin SQL Dump |
-- phpMyAdmin SQL Dump |
2 |
-- version 2.6.3-pl1 |
-- version 2.11.2.2 |
3 |
-- http://www.phpmyadmin.net |
-- http://www.phpmyadmin.net |
4 |
-- |
-- |
5 |
-- Host: localhost |
-- Host: localhost |
6 |
-- Generation Time: Oct 11, 2005 at 02:25 AM |
-- Erstellungszeit: 02. Dezember 2010 um 21:10 |
7 |
-- Server version: 3.23.49 |
-- Server Version: 5.0.32 |
8 |
-- PHP Version: 4.1.2 |
-- PHP-Version: 4.4.4-8+etch6 |
9 |
-- |
|
10 |
-- Database: `alx_web` |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
11 |
-- |
|
12 |
|
-- |
13 |
|
-- Datenbank: `alx_web` |
14 |
|
-- |
15 |
|
|
16 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
17 |
|
|
18 |
-- |
-- |
19 |
-- Table structure for table `cfg_autostart` |
-- Tabellenstruktur für Tabelle `cfg_autostart` |
20 |
-- |
-- |
21 |
|
|
22 |
CREATE TABLE `cfg_autostart` ( |
CREATE TABLE IF NOT EXISTS `cfg_autostart` ( |
23 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
24 |
`session` varchar(50) NOT NULL default '' |
`session` varchar(50) NOT NULL default '', |
25 |
) TYPE=MyISAM; |
KEY `session` (`session`), |
26 |
|
KEY `serial` (`serial`) |
27 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
28 |
|
|
29 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
30 |
|
|
31 |
-- |
-- |
32 |
-- Table structure for table `cfg_comments` |
-- Tabellenstruktur für Tabelle `cfg_comments` |
33 |
-- |
-- |
34 |
|
|
35 |
CREATE TABLE `cfg_comments` ( |
CREATE TABLE IF NOT EXISTS `cfg_comments` ( |
36 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
37 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
38 |
`txt` text NOT NULL, |
`txt` text NOT NULL, |
39 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
40 |
) TYPE=MyISAM AUTO_INCREMENT=7 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ; |
41 |
|
|
42 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
43 |
|
|
44 |
-- |
-- |
45 |
-- Table structure for table `cfg_graphic` |
-- Tabellenstruktur für Tabelle `cfg_graphic` |
46 |
-- |
-- |
47 |
|
|
48 |
CREATE TABLE `cfg_graphic` ( |
CREATE TABLE IF NOT EXISTS `cfg_graphic` ( |
49 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
50 |
`resolution` varchar(100) default NULL, |
`resolution` varchar(100) default NULL, |
51 |
`depth` varchar(100) default NULL, |
`depth` varchar(100) default NULL, |
52 |
`monitorid` int(11) default NULL, |
`monitorid` int(11) default NULL, |
53 |
|
`refresh_rate` int(3) default '60', |
54 |
`module` varchar(100) default NULL, |
`module` varchar(100) default NULL, |
55 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`), |
56 |
) TYPE=MyISAM; |
KEY `resolution` (`resolution`), |
57 |
|
KEY `monitorid` (`monitorid`), |
58 |
|
KEY `module` (`module`) |
59 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
60 |
|
|
61 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
62 |
|
|
63 |
-- |
-- |
64 |
-- Table structure for table `cfg_input` |
-- Tabellenstruktur für Tabelle `cfg_input` |
65 |
-- |
-- |
66 |
|
|
67 |
CREATE TABLE `cfg_input` ( |
CREATE TABLE IF NOT EXISTS `cfg_input` ( |
68 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
69 |
`mouse` varchar(100) default NULL, |
`mouse` varchar(100) default NULL, |
70 |
`keyboard` varchar(100) default NULL, |
`keyboard` varchar(100) default NULL, |
71 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`) |
72 |
) TYPE=MyISAM; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
73 |
|
|
74 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
75 |
|
|
76 |
-- |
-- |
77 |
-- Table structure for table `cfg_modules` |
-- Tabellenstruktur für Tabelle `cfg_modules` |
78 |
-- |
-- |
79 |
|
|
80 |
CREATE TABLE `cfg_modules` ( |
CREATE TABLE IF NOT EXISTS `cfg_modules` ( |
81 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
82 |
`serial` int(11) default NULL, |
`serial` int(11) default NULL, |
83 |
`module` varchar(100) default NULL, |
`module` varchar(100) default NULL, |
84 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`), |
85 |
) TYPE=MyISAM AUTO_INCREMENT=12 ; |
KEY `module` (`module`), |
86 |
|
KEY `serial` (`serial`) |
87 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ; |
88 |
|
|
89 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
90 |
|
|
91 |
-- |
-- |
92 |
-- Table structure for table `cfg_network` |
-- Tabellenstruktur für Tabelle `cfg_network` |
93 |
-- |
-- |
94 |
|
|
95 |
CREATE TABLE `cfg_network` ( |
CREATE TABLE IF NOT EXISTS `cfg_network` ( |
96 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
97 |
`iface` varchar(100) NOT NULL default 'eth0', |
`iface` varchar(100) NOT NULL default 'eth0', |
98 |
`hostname` varchar(100) default NULL, |
`hostname` varchar(100) default NULL, |
115 |
`wireless_key_length` varchar(10) default NULL, |
`wireless_key_length` varchar(10) default NULL, |
116 |
`wireless_key` text, |
`wireless_key` text, |
117 |
`wireless_key_ascii` text, |
`wireless_key_ascii` text, |
118 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`), |
119 |
) TYPE=MyISAM; |
KEY `iface` (`iface`), |
120 |
|
KEY `hostname` (`hostname`), |
121 |
|
KEY `networking` (`networking`), |
122 |
|
KEY `netmask` (`netmask`), |
123 |
|
KEY `gateway` (`gateway`), |
124 |
|
KEY `broadcast` (`broadcast`), |
125 |
|
KEY `ip` (`ip`), |
126 |
|
KEY `module` (`module`), |
127 |
|
KEY `forcemacto` (`forcemacto`), |
128 |
|
KEY `domain` (`domain`) |
129 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
130 |
|
|
131 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
132 |
|
|
133 |
-- |
-- |
134 |
-- Table structure for table `cfg_other_menuitems` |
-- Tabellenstruktur für Tabelle `cfg_other_menuitems` |
135 |
-- |
-- |
136 |
|
|
137 |
CREATE TABLE `cfg_other_menuitems` ( |
CREATE TABLE IF NOT EXISTS `cfg_other_menuitems` ( |
138 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
139 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
140 |
`name` varchar(50) NOT NULL default '', |
`name` varchar(50) NOT NULL default '', |
141 |
`exec` varchar(255) NOT NULL default '', |
`exec` varchar(255) NOT NULL default '', |
142 |
`workdir` varchar(100) NOT NULL default '', |
`workdir` varchar(100) NOT NULL default '', |
143 |
`icon` varchar(100) NOT NULL default '', |
`icon` varchar(100) NOT NULL default '', |
144 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`), |
145 |
) TYPE=MyISAM AUTO_INCREMENT=16 ; |
KEY `serial` (`serial`), |
146 |
|
KEY `exec` (`exec`), |
147 |
|
KEY `workdir` (`workdir`), |
148 |
|
KEY `icon` (`icon`) |
149 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ; |
150 |
|
|
151 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
152 |
|
|
153 |
-- |
-- |
154 |
-- Table structure for table `cfg_printers` |
-- Tabellenstruktur für Tabelle `cfg_printers` |
155 |
-- |
-- |
156 |
|
|
157 |
CREATE TABLE `cfg_printers` ( |
CREATE TABLE IF NOT EXISTS `cfg_printers` ( |
158 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
159 |
`serial` int(11) default NULL, |
`serial` int(11) default NULL, |
160 |
`port` varchar(100) default NULL, |
`port` varchar(100) default NULL, |
162 |
`ip` varchar(100) default NULL, |
`ip` varchar(100) default NULL, |
163 |
`share` varchar(100) default NULL, |
`share` varchar(100) default NULL, |
164 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
165 |
) TYPE=MyISAM AUTO_INCREMENT=3 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=434 ; |
166 |
|
|
167 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
168 |
|
|
169 |
-- |
-- |
170 |
-- Table structure for table `cfg_screensaver` |
-- Tabellenstruktur für Tabelle `cfg_screensaver` |
171 |
-- |
-- |
172 |
|
|
173 |
CREATE TABLE `cfg_screensaver` ( |
CREATE TABLE IF NOT EXISTS `cfg_screensaver` ( |
174 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
175 |
`screensaver` varchar(255) NOT NULL default '', |
`screensaver` varchar(255) NOT NULL default '', |
176 |
`timeout` int(11) NOT NULL default '10', |
`timeout` int(11) NOT NULL default '10', |
177 |
`password` varchar(255) default NULL, |
`password` varchar(255) default NULL |
178 |
PRIMARY KEY (`serial`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
) TYPE=MyISAM; |
|
179 |
|
|
180 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
181 |
|
|
182 |
-- |
-- |
183 |
-- Table structure for table `cfg_sessions` |
-- Tabellenstruktur für Tabelle `cfg_sessions` |
184 |
-- |
-- |
185 |
|
|
186 |
CREATE TABLE `cfg_sessions` ( |
CREATE TABLE IF NOT EXISTS `cfg_sessions` ( |
187 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
188 |
`serial` int(11) default NULL, |
`serial` int(11) default NULL, |
189 |
`session` varchar(100) default NULL, |
`session` varchar(100) default NULL, |
194 |
`browseradrs` varchar(100) NOT NULL default '', |
`browseradrs` varchar(100) NOT NULL default '', |
195 |
`flg_modified` tinyint(1) NOT NULL default '0', |
`flg_modified` tinyint(1) NOT NULL default '0', |
196 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
197 |
) TYPE=MyISAM AUTO_INCREMENT=15 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=441 ; |
198 |
|
|
199 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
200 |
|
|
201 |
-- |
-- |
202 |
-- Table structure for table `client_auth` |
-- Tabellenstruktur für Tabelle `client_auth` |
203 |
-- |
-- |
204 |
|
|
205 |
CREATE TABLE `client_auth` ( |
CREATE TABLE IF NOT EXISTS `client_auth` ( |
206 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
207 |
`username` varchar(100) default NULL, |
`username` varchar(100) default NULL, |
208 |
`shell` varchar(100) default NULL, |
`shell` varchar(100) default NULL, |
209 |
`vnc` varchar(100) default NULL, |
`vnc` varchar(100) default NULL, |
210 |
`samba` varchar(100) default NULL, |
`samba` varchar(100) default NULL, |
211 |
`station` varchar(100) default NULL, |
`station` varchar(100) default NULL, |
212 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`), |
213 |
) TYPE=MyISAM; |
KEY `shell` (`shell`), |
214 |
|
KEY `vnc` (`vnc`), |
215 |
|
KEY `samba` (`samba`), |
216 |
|
KEY `station` (`station`), |
217 |
|
KEY `username` (`username`) |
218 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
219 |
|
|
220 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
221 |
|
|
222 |
-- |
-- |
223 |
-- Table structure for table `client_serials` |
-- Tabellenstruktur für Tabelle `client_locations` |
224 |
-- |
-- |
225 |
|
|
226 |
CREATE TABLE `client_serials` ( |
CREATE TABLE IF NOT EXISTS `client_locations` ( |
227 |
|
`location` char(3) NOT NULL default '', |
228 |
|
`updateserver` varchar(100) NOT NULL default '', |
229 |
|
`username` varchar(30) NOT NULL default '', |
230 |
|
`password` varchar(30) NOT NULL default '', |
231 |
|
`rsync` varchar(255) NOT NULL default '', |
232 |
|
`repository` varchar(255) NOT NULL default '', |
233 |
|
PRIMARY KEY (`location`), |
234 |
|
KEY `updateserver` (`updateserver`) |
235 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
236 |
|
|
237 |
|
-- -------------------------------------------------------- |
238 |
|
|
239 |
|
-- |
240 |
|
-- Tabellenstruktur für Tabelle `client_serials` |
241 |
|
-- |
242 |
|
|
243 |
|
CREATE TABLE IF NOT EXISTS `client_serials` ( |
244 |
`serial` int(11) NOT NULL auto_increment, |
`serial` int(11) NOT NULL auto_increment, |
245 |
`location` char(3) NOT NULL default '', |
`location` char(3) NOT NULL default '', |
246 |
`mtime` int(11) default NULL, |
`mtime` int(11) default NULL, |
247 |
`mac` varchar(17) default NULL, |
`mac` varchar(17) default NULL, |
248 |
|
PRIMARY KEY (`serial`), |
249 |
|
KEY `location` (`location`) |
250 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=419 ; |
251 |
|
|
252 |
|
-- -------------------------------------------------------- |
253 |
|
|
254 |
|
-- |
255 |
|
-- Tabellenstruktur für Tabelle `client_version` |
256 |
|
-- |
257 |
|
|
258 |
|
CREATE TABLE IF NOT EXISTS `client_version` ( |
259 |
|
`serial` varchar(11) NOT NULL, |
260 |
|
`os` varchar(50) NOT NULL, |
261 |
|
`utils` varchar(50) NOT NULL, |
262 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`) |
263 |
) TYPE=MyISAM AUTO_INCREMENT=22 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
264 |
|
|
265 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
266 |
|
|
267 |
-- |
-- |
268 |
-- Table structure for table `list_monitors` |
-- Tabellenstruktur für Tabelle `list_monitors` |
269 |
-- |
-- |
270 |
|
|
271 |
CREATE TABLE `list_monitors` ( |
CREATE TABLE IF NOT EXISTS `list_monitors` ( |
272 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
273 |
`vendor` varchar(100) default NULL, |
`vendor` varchar(100) default NULL, |
274 |
`model` varchar(100) default NULL, |
`model` varchar(100) default NULL, |
275 |
`size` int(11) default NULL, |
`size` int(11) default NULL, |
276 |
`hsync` varchar(100) default NULL, |
`hsync` varchar(100) default NULL, |
277 |
`vrefresh` varchar(100) default NULL, |
`vrefresh` varchar(100) default NULL, |
278 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`), |
279 |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
KEY `vendor` (`vendor`), |
280 |
|
KEY `model` (`model`) |
281 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1809 ; |
282 |
|
|
283 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
284 |
|
|
285 |
-- |
-- |
286 |
-- Table structure for table `ssh_auth_clients` |
-- Tabellenstruktur für Tabelle `ssh_auth_clients` |
287 |
-- |
-- |
288 |
|
|
289 |
CREATE TABLE `ssh_auth_clients` ( |
CREATE TABLE IF NOT EXISTS `ssh_auth_clients` ( |
290 |
`serial` tinyint(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
291 |
`public_key` text NOT NULL |
`public_key` text NOT NULL |
292 |
) TYPE=MyISAM; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
293 |
|
|
294 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
295 |
|
|
296 |
-- |
-- |
297 |
-- Table structure for table `ssh_auth_server` |
-- Tabellenstruktur für Tabelle `ssh_auth_server` |
298 |
-- |
-- |
299 |
|
|
300 |
CREATE TABLE `ssh_auth_server` ( |
CREATE TABLE IF NOT EXISTS `ssh_auth_server` ( |
301 |
`id` tinyint(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
302 |
`public_key` text NOT NULL, |
`public_key` text NOT NULL, |
303 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
304 |
) TYPE=MyISAM AUTO_INCREMENT=2 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
305 |
|
|
306 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
307 |
|
|
308 |
-- |
-- |
309 |
-- Table structure for table `state_connected` |
-- Tabellenstruktur für Tabelle `state_connected` |
310 |
-- |
-- |
311 |
|
|
312 |
CREATE TABLE `state_connected` ( |
CREATE TABLE IF NOT EXISTS `state_connected` ( |
313 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
314 |
`mtime` int(11) default NULL, |
`mtime` int(11) default NULL, |
315 |
`serial` int(11) default NULL, |
`serial` int(11) default NULL, |
317 |
`ip` varchar(100) default NULL, |
`ip` varchar(100) default NULL, |
318 |
`mac` varchar(100) default NULL, |
`mac` varchar(100) default NULL, |
319 |
`state` varchar(100) default NULL, |
`state` varchar(100) default NULL, |
320 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`), |
321 |
) TYPE=MyISAM AUTO_INCREMENT=103 ; |
KEY `serial` (`serial`), |
322 |
|
KEY `hostname` (`hostname`), |
323 |
|
KEY `ip` (`ip`), |
324 |
|
KEY `mac` (`mac`), |
325 |
|
KEY `state` (`state`) |
326 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=54988 ; |