-- phpMyAdmin SQL Dump
-- version 2.11.2.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- 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`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `cfg_autostart`
--

CREATE TABLE IF NOT EXISTS `cfg_autostart` (
  `serial` int(11) NOT NULL default '0',
  `session` varchar(50) NOT NULL default '',
  KEY `session` (`session`),
  KEY `serial` (`serial`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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`),
  KEY `resolution` (`resolution`),
  KEY `monitorid` (`monitorid`),
  KEY `module` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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`),
  KEY `module` (`module`),
  KEY `serial` (`serial`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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,
  `domain` varchar(100) default NULL,
  `networking` varchar(100) default NULL,
  `netmask` varchar(100) default NULL,
  `dns` varchar(100) default NULL,
  `gateway` varchar(100) default NULL,
  `broadcast` varchar(100) default NULL,
  `ip` varchar(100) default NULL,
  `module` varchar(100) default NULL,
  `forcemacto` varchar(17) default NULL,
  `wireless_bitrate` varchar(5) default NULL,
  `wireless_channel` varchar(10) default NULL,
  `wireless_essid` varchar(255) default NULL,
  `wireless_frequency` varchar(255) default NULL,
  `wireless_mode` varchar(255) default NULL,
  `wireless_nick` varchar(255) default NULL,
  `wireless_auth_mode` varchar(255) default NULL,
  `wireless_key_length` varchar(10) default NULL,
  `wireless_key` text,
  `wireless_key_ascii` text,
  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;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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`),
  KEY `serial` (`serial`),
  KEY `exec` (`exec`),
  KEY `workdir` (`workdir`),
  KEY `icon` (`icon`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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,
  `printer_name` varchar(100) default NULL,
  `ip` varchar(100) default NULL,
  `share` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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,
  `filename` varchar(50) NOT NULL default '',
  `username` varchar(50) default NULL,
  `domain` varchar(50) default NULL,
  `password` varchar(50) default NULL,
  `browseradrs` varchar(100) NOT NULL default '',
  `flg_modified` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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`),
  KEY `shell` (`shell`),
  KEY `vnc` (`vnc`),
  KEY `samba` (`samba`),
  KEY `station` (`station`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `client_locations`
--

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=1 ;

-- --------------------------------------------------------

--
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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`),
  KEY `vendor` (`vendor`),
  KEY `model` (`model`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ssh_auth_clients`
--

CREATE TABLE IF NOT EXISTS `ssh_auth_clients` (
  `serial` int(11) NOT NULL default '0',
  `public_key` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ssh_auth_server`
--

CREATE TABLE IF NOT EXISTS `ssh_auth_server` (
  `id` int(11) NOT NULL auto_increment,
  `public_key` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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,
  `hostname` varchar(100) default NULL,
  `ip` varchar(100) default NULL,
  `mac` varchar(100) default NULL,
  `state` varchar(100) default NULL,
  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=1 ;
