--- alx-src/branches/alx-web-050/sql/alx_web.sql 2010/12/02 19:56:40 1600 +++ alx-src/branches/alx-web-050/sql/alx_web.sql 2010/12/02 20:00:42 1601 @@ -1,87 +1,98 @@ -- phpMyAdmin SQL Dump --- version 2.6.3-pl1 +-- version 2.11.2.2 -- http://www.phpmyadmin.net --- +-- -- Host: localhost --- Generation Time: Oct 11, 2005 at 02:25 AM --- Server version: 3.23.49 --- PHP Version: 4.1.2 --- --- Database: `alx_web` --- +-- Erstellungszeit: 02. Dezember 2010 um 21:10 +-- Server Version: 5.0.32 +-- PHP-Version: 4.4.4-8+etch6 + +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; + +-- +-- Datenbank: `alx_web` +-- -- -------------------------------------------------------- --- --- Table structure for table `cfg_autostart` --- +-- +-- Tabellenstruktur für Tabelle `cfg_autostart` +-- -CREATE TABLE `cfg_autostart` ( +CREATE TABLE IF NOT EXISTS `cfg_autostart` ( `serial` int(11) NOT NULL default '0', - `session` varchar(50) NOT NULL default '' -) TYPE=MyISAM; + `session` varchar(50) NOT NULL default '', + KEY `session` (`session`), + KEY `serial` (`serial`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `cfg_comments` --- +-- +-- Tabellenstruktur für Tabelle `cfg_comments` +-- -CREATE TABLE `cfg_comments` ( +CREATE TABLE IF NOT EXISTS `cfg_comments` ( `id` int(11) NOT NULL auto_increment, `serial` int(11) NOT NULL default '0', `txt` text NOT NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=7 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ; -- -------------------------------------------------------- --- --- Table structure for table `cfg_graphic` --- +-- +-- Tabellenstruktur für Tabelle `cfg_graphic` +-- -CREATE TABLE `cfg_graphic` ( +CREATE TABLE IF NOT EXISTS `cfg_graphic` ( `serial` int(11) NOT NULL default '0', `resolution` varchar(100) default NULL, `depth` varchar(100) default NULL, `monitorid` int(11) default NULL, + `refresh_rate` int(3) default '60', `module` varchar(100) default NULL, - PRIMARY KEY (`serial`) -) TYPE=MyISAM; + PRIMARY KEY (`serial`), + KEY `resolution` (`resolution`), + KEY `monitorid` (`monitorid`), + KEY `module` (`module`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `cfg_input` --- +-- +-- Tabellenstruktur für Tabelle `cfg_input` +-- -CREATE TABLE `cfg_input` ( +CREATE TABLE IF NOT EXISTS `cfg_input` ( `serial` int(11) NOT NULL default '0', `mouse` varchar(100) default NULL, `keyboard` varchar(100) default NULL, PRIMARY KEY (`serial`) -) TYPE=MyISAM; +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `cfg_modules` --- +-- +-- Tabellenstruktur für Tabelle `cfg_modules` +-- -CREATE TABLE `cfg_modules` ( +CREATE TABLE IF NOT EXISTS `cfg_modules` ( `id` int(11) NOT NULL auto_increment, `serial` int(11) default NULL, `module` varchar(100) default NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=12 ; + PRIMARY KEY (`id`), + KEY `module` (`module`), + KEY `serial` (`serial`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ; -- -------------------------------------------------------- --- --- Table structure for table `cfg_network` --- +-- +-- Tabellenstruktur für Tabelle `cfg_network` +-- -CREATE TABLE `cfg_network` ( +CREATE TABLE IF NOT EXISTS `cfg_network` ( `serial` int(11) NOT NULL default '0', `iface` varchar(100) NOT NULL default 'eth0', `hostname` varchar(100) default NULL, @@ -104,32 +115,46 @@ `wireless_key_length` varchar(10) default NULL, `wireless_key` text, `wireless_key_ascii` text, - PRIMARY KEY (`serial`) -) TYPE=MyISAM; + PRIMARY KEY (`serial`), + KEY `iface` (`iface`), + KEY `hostname` (`hostname`), + KEY `networking` (`networking`), + KEY `netmask` (`netmask`), + KEY `gateway` (`gateway`), + KEY `broadcast` (`broadcast`), + KEY `ip` (`ip`), + KEY `module` (`module`), + KEY `forcemacto` (`forcemacto`), + KEY `domain` (`domain`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `cfg_other_menuitems` --- +-- +-- Tabellenstruktur für Tabelle `cfg_other_menuitems` +-- -CREATE TABLE `cfg_other_menuitems` ( +CREATE TABLE IF NOT EXISTS `cfg_other_menuitems` ( `id` int(11) NOT NULL auto_increment, `serial` int(11) NOT NULL default '0', `name` varchar(50) NOT NULL default '', `exec` varchar(255) NOT NULL default '', `workdir` varchar(100) NOT NULL default '', `icon` varchar(100) NOT NULL default '', - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=16 ; + PRIMARY KEY (`id`), + KEY `serial` (`serial`), + KEY `exec` (`exec`), + KEY `workdir` (`workdir`), + KEY `icon` (`icon`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ; -- -------------------------------------------------------- --- --- Table structure for table `cfg_printers` --- +-- +-- Tabellenstruktur für Tabelle `cfg_printers` +-- -CREATE TABLE `cfg_printers` ( +CREATE TABLE IF NOT EXISTS `cfg_printers` ( `id` int(11) NOT NULL auto_increment, `serial` int(11) default NULL, `port` varchar(100) default NULL, @@ -137,29 +162,28 @@ `ip` varchar(100) default NULL, `share` varchar(100) default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=3 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=434 ; -- -------------------------------------------------------- --- --- Table structure for table `cfg_screensaver` --- +-- +-- Tabellenstruktur für Tabelle `cfg_screensaver` +-- -CREATE TABLE `cfg_screensaver` ( +CREATE TABLE IF NOT EXISTS `cfg_screensaver` ( `serial` int(11) NOT NULL default '0', `screensaver` varchar(255) NOT NULL default '', `timeout` int(11) NOT NULL default '10', - `password` varchar(255) default NULL, - PRIMARY KEY (`serial`) -) TYPE=MyISAM; + `password` varchar(255) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `cfg_sessions` --- +-- +-- Tabellenstruktur für Tabelle `cfg_sessions` +-- -CREATE TABLE `cfg_sessions` ( +CREATE TABLE IF NOT EXISTS `cfg_sessions` ( `id` int(11) NOT NULL auto_increment, `serial` int(11) default NULL, `session` varchar(100) default NULL, @@ -170,84 +194,122 @@ `browseradrs` varchar(100) NOT NULL default '', `flg_modified` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=15 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=441 ; -- -------------------------------------------------------- --- --- Table structure for table `client_auth` --- +-- +-- Tabellenstruktur für Tabelle `client_auth` +-- -CREATE TABLE `client_auth` ( +CREATE TABLE IF NOT EXISTS `client_auth` ( `serial` int(11) NOT NULL default '0', `username` varchar(100) default NULL, `shell` varchar(100) default NULL, `vnc` varchar(100) default NULL, `samba` varchar(100) default NULL, `station` varchar(100) default NULL, - PRIMARY KEY (`serial`) -) TYPE=MyISAM; + PRIMARY KEY (`serial`), + KEY `shell` (`shell`), + KEY `vnc` (`vnc`), + KEY `samba` (`samba`), + KEY `station` (`station`), + KEY `username` (`username`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `client_serials` --- +-- +-- Tabellenstruktur für Tabelle `client_locations` +-- -CREATE TABLE `client_serials` ( +CREATE TABLE IF NOT EXISTS `client_locations` ( + `location` char(3) NOT NULL default '', + `updateserver` varchar(100) NOT NULL default '', + `username` varchar(30) NOT NULL default '', + `password` varchar(30) NOT NULL default '', + `rsync` varchar(255) NOT NULL default '', + `repository` varchar(255) NOT NULL default '', + PRIMARY KEY (`location`), + KEY `updateserver` (`updateserver`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `client_serials` +-- + +CREATE TABLE IF NOT EXISTS `client_serials` ( `serial` int(11) NOT NULL auto_increment, `location` char(3) NOT NULL default '', `mtime` int(11) default NULL, `mac` varchar(17) default NULL, + PRIMARY KEY (`serial`), + KEY `location` (`location`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=419 ; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `client_version` +-- + +CREATE TABLE IF NOT EXISTS `client_version` ( + `serial` varchar(11) NOT NULL, + `os` varchar(50) NOT NULL, + `utils` varchar(50) NOT NULL, PRIMARY KEY (`serial`) -) TYPE=MyISAM AUTO_INCREMENT=22 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `list_monitors` --- +-- +-- Tabellenstruktur für Tabelle `list_monitors` +-- -CREATE TABLE `list_monitors` ( +CREATE TABLE IF NOT EXISTS `list_monitors` ( `id` int(11) NOT NULL auto_increment, `vendor` varchar(100) default NULL, `model` varchar(100) default NULL, `size` int(11) default NULL, `hsync` varchar(100) default NULL, `vrefresh` varchar(100) default NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ; + PRIMARY KEY (`id`), + KEY `vendor` (`vendor`), + KEY `model` (`model`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1809 ; -- -------------------------------------------------------- --- --- Table structure for table `ssh_auth_clients` --- +-- +-- Tabellenstruktur für Tabelle `ssh_auth_clients` +-- -CREATE TABLE `ssh_auth_clients` ( - `serial` tinyint(11) NOT NULL default '0', +CREATE TABLE IF NOT EXISTS `ssh_auth_clients` ( + `serial` int(11) NOT NULL default '0', `public_key` text NOT NULL -) TYPE=MyISAM; +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `ssh_auth_server` --- +-- +-- Tabellenstruktur für Tabelle `ssh_auth_server` +-- -CREATE TABLE `ssh_auth_server` ( - `id` tinyint(11) NOT NULL auto_increment, +CREATE TABLE IF NOT EXISTS `ssh_auth_server` ( + `id` int(11) NOT NULL auto_increment, `public_key` text NOT NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=2 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- --- --- Table structure for table `state_connected` --- +-- +-- Tabellenstruktur für Tabelle `state_connected` +-- -CREATE TABLE `state_connected` ( +CREATE TABLE IF NOT EXISTS `state_connected` ( `id` int(11) NOT NULL auto_increment, `mtime` int(11) default NULL, `serial` int(11) default NULL, @@ -255,5 +317,10 @@ `ip` varchar(100) default NULL, `mac` varchar(100) default NULL, `state` varchar(100) default NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=103 ; + PRIMARY KEY (`id`), + KEY `serial` (`serial`), + KEY `hostname` (`hostname`), + KEY `ip` (`ip`), + KEY `mac` (`mac`), + KEY `state` (`state`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=54988 ;