Contents of /alx-src/branches/alx-web-050/sql/alx_web.sql
Parent Directory
| 
Revision Log
Revision 1606 -
(show annotations)
(download)
Thu Dec 2 21:43:17 2010 UTC (13 years, 4 months ago) by niro
File size: 9398 byte(s)
Thu Dec 2 21:43:17 2010 UTC (13 years, 4 months ago) by niro
File size: 9398 byte(s)
-set auto_increment index for client_serials to '1'
| 1 | -- phpMyAdmin SQL Dump |
| 2 | -- version 2.11.2.2 |
| 3 | -- http://www.phpmyadmin.net |
| 4 | -- |
| 5 | -- Host: localhost |
| 6 | -- Erstellungszeit: 02. Dezember 2010 um 21:10 |
| 7 | -- Server Version: 5.0.32 |
| 8 | -- PHP-Version: 4.4.4-8+etch6 |
| 9 | |
| 10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| 11 | |
| 12 | -- |
| 13 | -- Datenbank: `alx_web` |
| 14 | -- |
| 15 | |
| 16 | -- -------------------------------------------------------- |
| 17 | |
| 18 | -- |
| 19 | -- Tabellenstruktur für Tabelle `cfg_autostart` |
| 20 | -- |
| 21 | |
| 22 | CREATE TABLE IF NOT EXISTS `cfg_autostart` ( |
| 23 | `serial` int(11) NOT NULL default '0', |
| 24 | `session` varchar(50) NOT NULL default '', |
| 25 | KEY `session` (`session`), |
| 26 | KEY `serial` (`serial`) |
| 27 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 28 | |
| 29 | -- -------------------------------------------------------- |
| 30 | |
| 31 | -- |
| 32 | -- Tabellenstruktur für Tabelle `cfg_comments` |
| 33 | -- |
| 34 | |
| 35 | CREATE TABLE IF NOT EXISTS `cfg_comments` ( |
| 36 | `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 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ; |
| 41 | |
| 42 | -- -------------------------------------------------------- |
| 43 | |
| 44 | -- |
| 45 | -- Tabellenstruktur für Tabelle `cfg_graphic` |
| 46 | -- |
| 47 | |
| 48 | CREATE TABLE IF NOT EXISTS `cfg_graphic` ( |
| 49 | `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 | `refresh_rate` int(3) default '60', |
| 54 | `module` varchar(100) default NULL, |
| 55 | PRIMARY KEY (`serial`), |
| 56 | KEY `resolution` (`resolution`), |
| 57 | KEY `monitorid` (`monitorid`), |
| 58 | KEY `module` (`module`) |
| 59 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 60 | |
| 61 | -- -------------------------------------------------------- |
| 62 | |
| 63 | -- |
| 64 | -- Tabellenstruktur für Tabelle `cfg_input` |
| 65 | -- |
| 66 | |
| 67 | CREATE TABLE IF NOT EXISTS `cfg_input` ( |
| 68 | `serial` int(11) NOT NULL default '0', |
| 69 | `mouse` varchar(100) default NULL, |
| 70 | `keyboard` varchar(100) default NULL, |
| 71 | PRIMARY KEY (`serial`) |
| 72 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 73 | |
| 74 | -- -------------------------------------------------------- |
| 75 | |
| 76 | -- |
| 77 | -- Tabellenstruktur für Tabelle `cfg_modules` |
| 78 | -- |
| 79 | |
| 80 | CREATE TABLE IF NOT EXISTS `cfg_modules` ( |
| 81 | `id` int(11) NOT NULL auto_increment, |
| 82 | `serial` int(11) default NULL, |
| 83 | `module` varchar(100) default NULL, |
| 84 | PRIMARY KEY (`id`), |
| 85 | KEY `module` (`module`), |
| 86 | KEY `serial` (`serial`) |
| 87 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ; |
| 88 | |
| 89 | -- -------------------------------------------------------- |
| 90 | |
| 91 | -- |
| 92 | -- Tabellenstruktur für Tabelle `cfg_network` |
| 93 | -- |
| 94 | |
| 95 | CREATE TABLE IF NOT EXISTS `cfg_network` ( |
| 96 | `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 | 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 | |
| 131 | -- -------------------------------------------------------- |
| 132 | |
| 133 | -- |
| 134 | -- Tabellenstruktur für Tabelle `cfg_other_menuitems` |
| 135 | -- |
| 136 | |
| 137 | CREATE TABLE IF NOT EXISTS `cfg_other_menuitems` ( |
| 138 | `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 | PRIMARY KEY (`id`), |
| 145 | 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 | -- Tabellenstruktur für Tabelle `cfg_printers` |
| 155 | -- |
| 156 | |
| 157 | CREATE TABLE IF NOT EXISTS `cfg_printers` ( |
| 158 | `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 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=434 ; |
| 166 | |
| 167 | -- -------------------------------------------------------- |
| 168 | |
| 169 | -- |
| 170 | -- Tabellenstruktur für Tabelle `cfg_screensaver` |
| 171 | -- |
| 172 | |
| 173 | CREATE TABLE IF NOT EXISTS `cfg_screensaver` ( |
| 174 | `serial` int(11) NOT NULL default '0', |
| 175 | `screensaver` varchar(255) NOT NULL default '', |
| 176 | `timeout` int(11) NOT NULL default '10', |
| 177 | `password` varchar(255) default NULL |
| 178 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 179 | |
| 180 | -- -------------------------------------------------------- |
| 181 | |
| 182 | -- |
| 183 | -- Tabellenstruktur für Tabelle `cfg_sessions` |
| 184 | -- |
| 185 | |
| 186 | CREATE TABLE IF NOT EXISTS `cfg_sessions` ( |
| 187 | `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 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=441 ; |
| 198 | |
| 199 | -- -------------------------------------------------------- |
| 200 | |
| 201 | -- |
| 202 | -- Tabellenstruktur für Tabelle `client_auth` |
| 203 | -- |
| 204 | |
| 205 | CREATE TABLE IF NOT EXISTS `client_auth` ( |
| 206 | `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 | 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 | |
| 220 | -- -------------------------------------------------------- |
| 221 | |
| 222 | -- |
| 223 | -- Tabellenstruktur für Tabelle `client_locations` |
| 224 | -- |
| 225 | |
| 226 | 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, |
| 245 | `location` char(3) NOT NULL default '', |
| 246 | `mtime` int(11) default NULL, |
| 247 | `mac` varchar(17) default NULL, |
| 248 | PRIMARY KEY (`serial`), |
| 249 | KEY `location` (`location`) |
| 250 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| 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`) |
| 263 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 264 | |
| 265 | -- -------------------------------------------------------- |
| 266 | |
| 267 | -- |
| 268 | -- Tabellenstruktur für Tabelle `list_monitors` |
| 269 | -- |
| 270 | |
| 271 | CREATE TABLE IF NOT EXISTS `list_monitors` ( |
| 272 | `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 | PRIMARY KEY (`id`), |
| 279 | KEY `vendor` (`vendor`), |
| 280 | KEY `model` (`model`) |
| 281 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1809 ; |
| 282 | |
| 283 | -- -------------------------------------------------------- |
| 284 | |
| 285 | -- |
| 286 | -- Tabellenstruktur für Tabelle `ssh_auth_clients` |
| 287 | -- |
| 288 | |
| 289 | CREATE TABLE IF NOT EXISTS `ssh_auth_clients` ( |
| 290 | `serial` int(11) NOT NULL default '0', |
| 291 | `public_key` text NOT NULL |
| 292 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 293 | |
| 294 | -- -------------------------------------------------------- |
| 295 | |
| 296 | -- |
| 297 | -- Tabellenstruktur für Tabelle `ssh_auth_server` |
| 298 | -- |
| 299 | |
| 300 | CREATE TABLE IF NOT EXISTS `ssh_auth_server` ( |
| 301 | `id` int(11) NOT NULL auto_increment, |
| 302 | `public_key` text NOT NULL, |
| 303 | PRIMARY KEY (`id`) |
| 304 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
| 305 | |
| 306 | -- -------------------------------------------------------- |
| 307 | |
| 308 | -- |
| 309 | -- Tabellenstruktur für Tabelle `state_connected` |
| 310 | -- |
| 311 | |
| 312 | CREATE TABLE IF NOT EXISTS `state_connected` ( |
| 313 | `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 | PRIMARY KEY (`id`), |
| 321 | 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 ; |