Annotation of /alx-src/branches/alx-web-050/sql/alx_web.sql
Parent Directory | Revision Log
Revision 1607 -
(hide annotations)
(download)
Thu Dec 2 21:46:31 2010 UTC (13 years, 9 months ago) by niro
File size: 9384 byte(s)
Thu Dec 2 21:46:31 2010 UTC (13 years, 9 months ago) by niro
File size: 9384 byte(s)
-resetted all auto_increment indexes to '1'
1 | niro | 1600 | -- phpMyAdmin SQL Dump |
2 | niro | 1601 | -- version 2.11.2.2 |
3 | niro | 1600 | -- http://www.phpmyadmin.net |
4 | niro | 1601 | -- |
5 | niro | 1600 | -- Host: localhost |
6 | niro | 1601 | -- Erstellungszeit: 02. Dezember 2010 um 21:10 |
7 | -- Server Version: 5.0.32 | ||
8 | -- PHP-Version: 4.4.4-8+etch6 | ||
9 | niro | 1600 | |
10 | niro | 1601 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
11 | |||
12 | -- | ||
13 | -- Datenbank: `alx_web` | ||
14 | -- | ||
15 | |||
16 | niro | 1600 | -- -------------------------------------------------------- |
17 | |||
18 | niro | 1601 | -- |
19 | -- Tabellenstruktur für Tabelle `cfg_autostart` | ||
20 | -- | ||
21 | niro | 1600 | |
22 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_autostart` ( |
23 | niro | 1600 | `serial` int(11) NOT NULL default '0', |
24 | niro | 1601 | `session` varchar(50) NOT NULL default '', |
25 | KEY `session` (`session`), | ||
26 | KEY `serial` (`serial`) | ||
27 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
28 | niro | 1600 | |
29 | -- -------------------------------------------------------- | ||
30 | |||
31 | niro | 1601 | -- |
32 | -- Tabellenstruktur für Tabelle `cfg_comments` | ||
33 | -- | ||
34 | niro | 1600 | |
35 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_comments` ( |
36 | niro | 1600 | `id` int(11) NOT NULL auto_increment, |
37 | `serial` int(11) NOT NULL default '0', | ||
38 | `txt` text NOT NULL, | ||
39 | PRIMARY KEY (`id`) | ||
40 | niro | 1607 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
41 | niro | 1600 | |
42 | -- -------------------------------------------------------- | ||
43 | |||
44 | niro | 1601 | -- |
45 | -- Tabellenstruktur für Tabelle `cfg_graphic` | ||
46 | -- | ||
47 | niro | 1600 | |
48 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_graphic` ( |
49 | niro | 1600 | `serial` int(11) NOT NULL default '0', |
50 | `resolution` varchar(100) default NULL, | ||
51 | `depth` varchar(100) default NULL, | ||
52 | `monitorid` int(11) default NULL, | ||
53 | niro | 1601 | `refresh_rate` int(3) default '60', |
54 | niro | 1600 | `module` varchar(100) default NULL, |
55 | niro | 1601 | PRIMARY KEY (`serial`), |
56 | KEY `resolution` (`resolution`), | ||
57 | KEY `monitorid` (`monitorid`), | ||
58 | KEY `module` (`module`) | ||
59 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
60 | niro | 1600 | |
61 | -- -------------------------------------------------------- | ||
62 | |||
63 | niro | 1601 | -- |
64 | -- Tabellenstruktur für Tabelle `cfg_input` | ||
65 | -- | ||
66 | niro | 1600 | |
67 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_input` ( |
68 | niro | 1600 | `serial` int(11) NOT NULL default '0', |
69 | `mouse` varchar(100) default NULL, | ||
70 | `keyboard` varchar(100) default NULL, | ||
71 | PRIMARY KEY (`serial`) | ||
72 | niro | 1601 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
73 | niro | 1600 | |
74 | -- -------------------------------------------------------- | ||
75 | |||
76 | niro | 1601 | -- |
77 | -- Tabellenstruktur für Tabelle `cfg_modules` | ||
78 | -- | ||
79 | niro | 1600 | |
80 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_modules` ( |
81 | niro | 1600 | `id` int(11) NOT NULL auto_increment, |
82 | `serial` int(11) default NULL, | ||
83 | `module` varchar(100) default NULL, | ||
84 | niro | 1601 | PRIMARY KEY (`id`), |
85 | KEY `module` (`module`), | ||
86 | KEY `serial` (`serial`) | ||
87 | niro | 1607 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
88 | niro | 1600 | |
89 | -- -------------------------------------------------------- | ||
90 | |||
91 | niro | 1601 | -- |
92 | -- Tabellenstruktur für Tabelle `cfg_network` | ||
93 | -- | ||
94 | niro | 1600 | |
95 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_network` ( |
96 | niro | 1600 | `serial` int(11) NOT NULL default '0', |
97 | `iface` varchar(100) NOT NULL default 'eth0', | ||
98 | `hostname` varchar(100) default NULL, | ||
99 | `domain` varchar(100) default NULL, | ||
100 | `networking` varchar(100) default NULL, | ||
101 | `netmask` varchar(100) default NULL, | ||
102 | `dns` varchar(100) default NULL, | ||
103 | `gateway` varchar(100) default NULL, | ||
104 | `broadcast` varchar(100) default NULL, | ||
105 | `ip` varchar(100) default NULL, | ||
106 | `module` varchar(100) default NULL, | ||
107 | `forcemacto` varchar(17) default NULL, | ||
108 | `wireless_bitrate` varchar(5) default NULL, | ||
109 | `wireless_channel` varchar(10) default NULL, | ||
110 | `wireless_essid` varchar(255) default NULL, | ||
111 | `wireless_frequency` varchar(255) default NULL, | ||
112 | `wireless_mode` varchar(255) default NULL, | ||
113 | `wireless_nick` varchar(255) default NULL, | ||
114 | `wireless_auth_mode` varchar(255) default NULL, | ||
115 | `wireless_key_length` varchar(10) default NULL, | ||
116 | `wireless_key` text, | ||
117 | `wireless_key_ascii` text, | ||
118 | niro | 1601 | PRIMARY KEY (`serial`), |
119 | 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 | niro | 1600 | |
131 | -- -------------------------------------------------------- | ||
132 | |||
133 | niro | 1601 | -- |
134 | -- Tabellenstruktur für Tabelle `cfg_other_menuitems` | ||
135 | -- | ||
136 | niro | 1600 | |
137 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_other_menuitems` ( |
138 | niro | 1600 | `id` int(11) NOT NULL auto_increment, |
139 | `serial` int(11) NOT NULL default '0', | ||
140 | `name` varchar(50) NOT NULL default '', | ||
141 | `exec` varchar(255) NOT NULL default '', | ||
142 | `workdir` varchar(100) NOT NULL default '', | ||
143 | `icon` varchar(100) NOT NULL default '', | ||
144 | niro | 1601 | PRIMARY KEY (`id`), |
145 | KEY `serial` (`serial`), | ||
146 | KEY `exec` (`exec`), | ||
147 | KEY `workdir` (`workdir`), | ||
148 | KEY `icon` (`icon`) | ||
149 | niro | 1607 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
150 | niro | 1600 | |
151 | -- -------------------------------------------------------- | ||
152 | |||
153 | niro | 1601 | -- |
154 | -- Tabellenstruktur für Tabelle `cfg_printers` | ||
155 | -- | ||
156 | niro | 1600 | |
157 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_printers` ( |
158 | niro | 1600 | `id` int(11) NOT NULL auto_increment, |
159 | `serial` int(11) default NULL, | ||
160 | `port` varchar(100) default NULL, | ||
161 | `printer_name` varchar(100) default NULL, | ||
162 | `ip` varchar(100) default NULL, | ||
163 | `share` varchar(100) default NULL, | ||
164 | PRIMARY KEY (`id`) | ||
165 | niro | 1607 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
166 | niro | 1600 | |
167 | -- -------------------------------------------------------- | ||
168 | |||
169 | niro | 1601 | -- |
170 | -- Tabellenstruktur für Tabelle `cfg_screensaver` | ||
171 | -- | ||
172 | niro | 1600 | |
173 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_screensaver` ( |
174 | niro | 1600 | `serial` int(11) NOT NULL default '0', |
175 | `screensaver` varchar(255) NOT NULL default '', | ||
176 | `timeout` int(11) NOT NULL default '10', | ||
177 | niro | 1601 | `password` varchar(255) default NULL |
178 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
179 | niro | 1600 | |
180 | -- -------------------------------------------------------- | ||
181 | |||
182 | niro | 1601 | -- |
183 | -- Tabellenstruktur für Tabelle `cfg_sessions` | ||
184 | -- | ||
185 | niro | 1600 | |
186 | niro | 1601 | CREATE TABLE IF NOT EXISTS `cfg_sessions` ( |
187 | niro | 1600 | `id` int(11) NOT NULL auto_increment, |
188 | `serial` int(11) default NULL, | ||
189 | `session` varchar(100) default NULL, | ||
190 | `filename` varchar(50) NOT NULL default '', | ||
191 | `username` varchar(50) default NULL, | ||
192 | `domain` varchar(50) default NULL, | ||
193 | `password` varchar(50) default NULL, | ||
194 | `browseradrs` varchar(100) NOT NULL default '', | ||
195 | `flg_modified` tinyint(1) NOT NULL default '0', | ||
196 | PRIMARY KEY (`id`) | ||
197 | niro | 1607 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
198 | niro | 1600 | |
199 | -- -------------------------------------------------------- | ||
200 | |||
201 | niro | 1601 | -- |
202 | -- Tabellenstruktur für Tabelle `client_auth` | ||
203 | -- | ||
204 | niro | 1600 | |
205 | niro | 1601 | CREATE TABLE IF NOT EXISTS `client_auth` ( |
206 | niro | 1600 | `serial` int(11) NOT NULL default '0', |
207 | `username` varchar(100) default NULL, | ||
208 | `shell` varchar(100) default NULL, | ||
209 | `vnc` varchar(100) default NULL, | ||
210 | `samba` varchar(100) default NULL, | ||
211 | `station` varchar(100) default NULL, | ||
212 | niro | 1601 | PRIMARY KEY (`serial`), |
213 | 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 | niro | 1600 | |
220 | -- -------------------------------------------------------- | ||
221 | |||
222 | niro | 1601 | -- |
223 | -- Tabellenstruktur für Tabelle `client_locations` | ||
224 | -- | ||
225 | niro | 1600 | |
226 | niro | 1601 | 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 | niro | 1600 | `serial` int(11) NOT NULL auto_increment, |
245 | `location` char(3) NOT NULL default '', | ||
246 | `mtime` int(11) default NULL, | ||
247 | `mac` varchar(17) default NULL, | ||
248 | niro | 1601 | PRIMARY KEY (`serial`), |
249 | KEY `location` (`location`) | ||
250 | niro | 1606 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
251 | niro | 1601 | |
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 | niro | 1600 | PRIMARY KEY (`serial`) |
263 | niro | 1601 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
264 | niro | 1600 | |
265 | -- -------------------------------------------------------- | ||
266 | |||
267 | niro | 1601 | -- |
268 | -- Tabellenstruktur für Tabelle `list_monitors` | ||
269 | -- | ||
270 | niro | 1600 | |
271 | niro | 1601 | CREATE TABLE IF NOT EXISTS `list_monitors` ( |
272 | niro | 1600 | `id` int(11) NOT NULL auto_increment, |
273 | `vendor` varchar(100) default NULL, | ||
274 | `model` varchar(100) default NULL, | ||
275 | `size` int(11) default NULL, | ||
276 | `hsync` varchar(100) default NULL, | ||
277 | `vrefresh` varchar(100) default NULL, | ||
278 | niro | 1601 | PRIMARY KEY (`id`), |
279 | KEY `vendor` (`vendor`), | ||
280 | KEY `model` (`model`) | ||
281 | niro | 1607 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
282 | niro | 1600 | |
283 | -- -------------------------------------------------------- | ||
284 | |||
285 | niro | 1601 | -- |
286 | -- Tabellenstruktur für Tabelle `ssh_auth_clients` | ||
287 | -- | ||
288 | niro | 1600 | |
289 | niro | 1601 | CREATE TABLE IF NOT EXISTS `ssh_auth_clients` ( |
290 | `serial` int(11) NOT NULL default '0', | ||
291 | niro | 1600 | `public_key` text NOT NULL |
292 | niro | 1601 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
293 | niro | 1600 | |
294 | -- -------------------------------------------------------- | ||
295 | |||
296 | niro | 1601 | -- |
297 | -- Tabellenstruktur für Tabelle `ssh_auth_server` | ||
298 | -- | ||
299 | niro | 1600 | |
300 | niro | 1601 | CREATE TABLE IF NOT EXISTS `ssh_auth_server` ( |
301 | `id` int(11) NOT NULL auto_increment, | ||
302 | niro | 1600 | `public_key` text NOT NULL, |
303 | PRIMARY KEY (`id`) | ||
304 | niro | 1607 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
305 | niro | 1600 | |
306 | -- -------------------------------------------------------- | ||
307 | |||
308 | niro | 1601 | -- |
309 | -- Tabellenstruktur für Tabelle `state_connected` | ||
310 | -- | ||
311 | niro | 1600 | |
312 | niro | 1601 | CREATE TABLE IF NOT EXISTS `state_connected` ( |
313 | niro | 1600 | `id` int(11) NOT NULL auto_increment, |
314 | `mtime` int(11) default NULL, | ||
315 | `serial` int(11) default NULL, | ||
316 | `hostname` varchar(100) default NULL, | ||
317 | `ip` varchar(100) default NULL, | ||
318 | `mac` varchar(100) default NULL, | ||
319 | `state` varchar(100) default NULL, | ||
320 | niro | 1601 | PRIMARY KEY (`id`), |
321 | KEY `serial` (`serial`), | ||
322 | KEY `hostname` (`hostname`), | ||
323 | KEY `ip` (`ip`), | ||
324 | KEY `mac` (`mac`), | ||
325 | KEY `state` (`state`) | ||
326 | niro | 1607 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |