Contents of /alx-src/trunk/alx-web/sql/alx_web.sql
Parent Directory
| 
Revision Log
Revision 480 -
(show annotations)
(download)
Sat Jun 7 10:20:35 2008 UTC (15 years, 11 months ago) by niro
File size: 8377 byte(s)
Sat Jun 7 10:20:35 2008 UTC (15 years, 11 months ago) by niro
File size: 8377 byte(s)
-update to current
| 1 | -- phpMyAdmin SQL Dump |
| 2 | -- version 2.11.5.1 |
| 3 | -- http://www.phpmyadmin.net |
| 4 | -- |
| 5 | -- Host: localhost |
| 6 | -- Generation Time: Jun 07, 2008 at 12:25 PM |
| 7 | -- Server version: 5.0.51 |
| 8 | -- PHP Version: 5.2.5 |
| 9 | |
| 10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| 11 | |
| 12 | -- |
| 13 | -- Database: `alx_web` |
| 14 | -- |
| 15 | |
| 16 | -- -------------------------------------------------------- |
| 17 | |
| 18 | -- |
| 19 | -- Table structure for table `cfg_autostart` |
| 20 | -- |
| 21 | |
| 22 | CREATE TABLE IF NOT EXISTS `cfg_autostart` ( |
| 23 | `serial` int(11) NOT NULL default '0', |
| 24 | `session` varchar(50) default NULL |
| 25 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 26 | |
| 27 | -- -------------------------------------------------------- |
| 28 | |
| 29 | -- |
| 30 | -- Table structure for table `cfg_comments` |
| 31 | -- |
| 32 | |
| 33 | CREATE TABLE IF NOT EXISTS `cfg_comments` ( |
| 34 | `id` int(11) NOT NULL auto_increment, |
| 35 | `serial` int(11) NOT NULL default '0', |
| 36 | `txt` text NOT NULL, |
| 37 | PRIMARY KEY (`id`) |
| 38 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| 39 | |
| 40 | -- -------------------------------------------------------- |
| 41 | |
| 42 | -- |
| 43 | -- Table structure for table `cfg_graphic` |
| 44 | -- |
| 45 | |
| 46 | CREATE TABLE IF NOT EXISTS `cfg_graphic` ( |
| 47 | `serial` int(11) NOT NULL default '0', |
| 48 | `resolution` varchar(100) default NULL, |
| 49 | `depth` varchar(100) default NULL, |
| 50 | `monitorid` int(11) default NULL, |
| 51 | `module` varchar(100) default NULL, |
| 52 | PRIMARY KEY (`serial`) |
| 53 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 54 | |
| 55 | -- -------------------------------------------------------- |
| 56 | |
| 57 | -- |
| 58 | -- Table structure for table `cfg_input` |
| 59 | -- |
| 60 | |
| 61 | CREATE TABLE IF NOT EXISTS `cfg_input` ( |
| 62 | `serial` int(11) NOT NULL default '0', |
| 63 | `mouse` varchar(100) default NULL, |
| 64 | `mouse_acceleration` tinyint(2) default '0', |
| 65 | `mouse_threshold` tinyint(2) default '0', |
| 66 | `keyboard` varchar(100) default NULL, |
| 67 | PRIMARY KEY (`serial`) |
| 68 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 69 | |
| 70 | -- -------------------------------------------------------- |
| 71 | |
| 72 | -- |
| 73 | -- Table structure for table `cfg_interfaces` |
| 74 | -- |
| 75 | |
| 76 | CREATE TABLE IF NOT EXISTS `cfg_interfaces` ( |
| 77 | `id` int(255) NOT NULL auto_increment, |
| 78 | `serial` int(11) NOT NULL, |
| 79 | `iface` varchar(100) NOT NULL default 'eth0', |
| 80 | `networking` varchar(100) NOT NULL, |
| 81 | `netmask` varchar(100) default NULL, |
| 82 | `dns` varchar(100) default NULL, |
| 83 | `gateway` varchar(100) default NULL, |
| 84 | `broadcast` varchar(100) default NULL, |
| 85 | `ip` varchar(100) default NULL, |
| 86 | `module` varchar(100) default NULL, |
| 87 | `forcemacto` varchar(17) default NULL, |
| 88 | `wireless_bitrate` varchar(5) default NULL, |
| 89 | `wireless_channel` varchar(10) default NULL, |
| 90 | `wireless_essid` varchar(255) default NULL, |
| 91 | `wireless_frequency` varchar(255) default NULL, |
| 92 | `wireless_mode` varchar(255) default NULL, |
| 93 | `wireless_nick` varchar(255) default NULL, |
| 94 | `wireless_auth_mode` varchar(255) default NULL, |
| 95 | `wireless_key_length` varchar(10) default NULL, |
| 96 | `wireless_key` text, |
| 97 | `wireless_key_ascii` text, |
| 98 | PRIMARY KEY (`id`) |
| 99 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
| 100 | |
| 101 | -- -------------------------------------------------------- |
| 102 | |
| 103 | -- |
| 104 | -- Table structure for table `cfg_modules` |
| 105 | -- |
| 106 | |
| 107 | CREATE TABLE IF NOT EXISTS `cfg_modules` ( |
| 108 | `id` int(11) NOT NULL auto_increment, |
| 109 | `serial` int(11) default NULL, |
| 110 | `module` varchar(100) default NULL, |
| 111 | PRIMARY KEY (`id`) |
| 112 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| 113 | |
| 114 | -- -------------------------------------------------------- |
| 115 | |
| 116 | -- |
| 117 | -- Table structure for table `cfg_network` |
| 118 | -- |
| 119 | |
| 120 | CREATE TABLE IF NOT EXISTS `cfg_network` ( |
| 121 | `serial` int(11) NOT NULL default '0', |
| 122 | `default_iface` varchar(100) NOT NULL default 'eth0', |
| 123 | `hostname` varchar(100) default NULL, |
| 124 | `domain` varchar(100) default NULL, |
| 125 | PRIMARY KEY (`serial`) |
| 126 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 127 | |
| 128 | -- -------------------------------------------------------- |
| 129 | |
| 130 | -- |
| 131 | -- Table structure for table `cfg_other_menuitems` |
| 132 | -- |
| 133 | |
| 134 | CREATE TABLE IF NOT EXISTS `cfg_other_menuitems` ( |
| 135 | `id` int(11) NOT NULL auto_increment, |
| 136 | `serial` int(11) NOT NULL default '0', |
| 137 | `name` varchar(50) default NULL, |
| 138 | `exec` varchar(255) default NULL, |
| 139 | `workdir` varchar(100) default NULL, |
| 140 | `icon` varchar(100) default NULL, |
| 141 | PRIMARY KEY (`id`) |
| 142 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
| 143 | |
| 144 | -- -------------------------------------------------------- |
| 145 | |
| 146 | -- |
| 147 | -- Table structure for table `cfg_printers` |
| 148 | -- |
| 149 | |
| 150 | CREATE TABLE IF NOT EXISTS `cfg_printers` ( |
| 151 | `id` int(11) NOT NULL auto_increment, |
| 152 | `serial` int(11) default NULL, |
| 153 | `port` varchar(100) default NULL, |
| 154 | `printer_name` varchar(100) default NULL, |
| 155 | `ip` varchar(100) default NULL, |
| 156 | `share` varchar(100) default NULL, |
| 157 | PRIMARY KEY (`id`) |
| 158 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; |
| 159 | |
| 160 | -- -------------------------------------------------------- |
| 161 | |
| 162 | -- |
| 163 | -- Table structure for table `cfg_screensaver` |
| 164 | -- |
| 165 | |
| 166 | CREATE TABLE IF NOT EXISTS `cfg_screensaver` ( |
| 167 | `serial` int(11) NOT NULL default '0', |
| 168 | `screensaver` varchar(255) default NULL, |
| 169 | `timeout` int(11) default '10', |
| 170 | `password` varchar(255) default NULL |
| 171 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 172 | |
| 173 | -- -------------------------------------------------------- |
| 174 | |
| 175 | -- |
| 176 | -- Table structure for table `cfg_sessions` |
| 177 | -- |
| 178 | |
| 179 | CREATE TABLE IF NOT EXISTS `cfg_sessions` ( |
| 180 | `id` int(11) NOT NULL auto_increment, |
| 181 | `serial` int(11) default NULL, |
| 182 | `session` varchar(100) default NULL, |
| 183 | `filename` varchar(50) default NULL, |
| 184 | `username` varchar(50) default NULL, |
| 185 | `domain` varchar(50) default NULL, |
| 186 | `password` varchar(50) default NULL, |
| 187 | `browseradrs` varchar(100) default NULL, |
| 188 | `displaymode` varchar(20) NOT NULL default 'fullscreen', |
| 189 | `flg_modified` tinyint(1) NOT NULL default '0', |
| 190 | PRIMARY KEY (`id`) |
| 191 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
| 192 | |
| 193 | -- -------------------------------------------------------- |
| 194 | |
| 195 | -- |
| 196 | -- Table structure for table `client_auth` |
| 197 | -- |
| 198 | |
| 199 | CREATE TABLE IF NOT EXISTS `client_auth` ( |
| 200 | `serial` int(11) NOT NULL default '0', |
| 201 | `username` varchar(100) default NULL, |
| 202 | `shell` varchar(100) default NULL, |
| 203 | `vnc` varchar(100) default NULL, |
| 204 | `samba` varchar(100) default NULL, |
| 205 | `station` varchar(100) default NULL, |
| 206 | PRIMARY KEY (`serial`) |
| 207 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 208 | |
| 209 | -- -------------------------------------------------------- |
| 210 | |
| 211 | -- |
| 212 | -- Table structure for table `client_locations` |
| 213 | -- |
| 214 | |
| 215 | CREATE TABLE IF NOT EXISTS `client_locations` ( |
| 216 | `location` char(3) NOT NULL default '', |
| 217 | `updateserver` varchar(100) default NULL, |
| 218 | `username` varchar(30) default NULL, |
| 219 | `password` varchar(30) default NULL, |
| 220 | `rsync` varchar(255) default NULL, |
| 221 | `repository` varchar(255) default NULL, |
| 222 | PRIMARY KEY (`location`) |
| 223 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 224 | |
| 225 | -- -------------------------------------------------------- |
| 226 | |
| 227 | -- |
| 228 | -- Table structure for table `client_serials` |
| 229 | -- |
| 230 | |
| 231 | CREATE TABLE IF NOT EXISTS `client_serials` ( |
| 232 | `serial` int(11) NOT NULL auto_increment, |
| 233 | `location` char(3) default NULL, |
| 234 | `mtime` int(11) default NULL, |
| 235 | `mac` varchar(17) default NULL, |
| 236 | PRIMARY KEY (`serial`) |
| 237 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
| 238 | |
| 239 | -- -------------------------------------------------------- |
| 240 | |
| 241 | -- |
| 242 | -- Table structure for table `list_monitors` |
| 243 | -- |
| 244 | |
| 245 | CREATE TABLE IF NOT EXISTS `list_monitors` ( |
| 246 | `id` int(11) NOT NULL auto_increment, |
| 247 | `vendor` varchar(100) default NULL, |
| 248 | `model` varchar(100) default NULL, |
| 249 | `size` int(11) default NULL, |
| 250 | `hsync` varchar(100) default NULL, |
| 251 | `vrefresh` varchar(100) default NULL, |
| 252 | PRIMARY KEY (`id`) |
| 253 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1805 ; |
| 254 | |
| 255 | -- -------------------------------------------------------- |
| 256 | |
| 257 | -- |
| 258 | -- Table structure for table `ssh_auth_clients` |
| 259 | -- |
| 260 | |
| 261 | CREATE TABLE IF NOT EXISTS `ssh_auth_clients` ( |
| 262 | `serial` int(11) NOT NULL default '0', |
| 263 | `public_key` text NOT NULL |
| 264 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 265 | |
| 266 | -- -------------------------------------------------------- |
| 267 | |
| 268 | -- |
| 269 | -- Table structure for table `ssh_auth_server` |
| 270 | -- |
| 271 | |
| 272 | CREATE TABLE IF NOT EXISTS `ssh_auth_server` ( |
| 273 | `id` int(11) NOT NULL auto_increment, |
| 274 | `public_key` text NOT NULL, |
| 275 | PRIMARY KEY (`id`) |
| 276 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
| 277 | |
| 278 | -- -------------------------------------------------------- |
| 279 | |
| 280 | -- |
| 281 | -- Table structure for table `state_connected` |
| 282 | -- |
| 283 | |
| 284 | CREATE TABLE IF NOT EXISTS `state_connected` ( |
| 285 | `id` int(11) NOT NULL auto_increment, |
| 286 | `mtime` int(11) default NULL, |
| 287 | `serial` int(11) default NULL, |
| 288 | `hostname` varchar(100) default NULL, |
| 289 | `ip` varchar(100) default NULL, |
| 290 | `mac` varchar(100) default NULL, |
| 291 | `state` varchar(100) default NULL, |
| 292 | PRIMARY KEY (`id`) |
| 293 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; |