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, 5 months ago) by niro
File size: 9384 byte(s)
Thu Dec 2 21:46:31 2010 UTC (13 years, 5 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 ; |