-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- 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`
-- 

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

-- 
-- Table structure for table `cfg_autostart`
-- 

CREATE TABLE `cfg_autostart` (
  `serial` int(11) NOT NULL default '0',
  `session` varchar(50) NOT NULL default ''
) TYPE=MyISAM;

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

-- 
-- Table structure for table `cfg_comments`
-- 

CREATE TABLE `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 ;

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

-- 
-- Table structure for table `cfg_graphic`
-- 

CREATE TABLE `cfg_graphic` (
  `serial` int(11) NOT NULL default '0',
  `resolution` varchar(100) default NULL,
  `depth` varchar(100) default NULL,
  `monitorid` int(11) default NULL,
  `module` varchar(100) default NULL,
  PRIMARY KEY  (`serial`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `cfg_input`
-- 

CREATE TABLE `cfg_input` (
  `serial` int(11) NOT NULL default '0',
  `mouse` varchar(100) default NULL,
  `keyboard` varchar(100) default NULL,
  PRIMARY KEY  (`serial`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `cfg_modules`
-- 

CREATE TABLE `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 ;

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

-- 
-- Table structure for table `cfg_network`
-- 

CREATE TABLE `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`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `cfg_other_menuitems`
-- 

CREATE TABLE `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 ;

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

-- 
-- Table structure for table `cfg_printers`
-- 

CREATE TABLE `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`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `cfg_screensaver`
-- 

CREATE TABLE `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;

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

-- 
-- Table structure for table `cfg_sessions`
-- 

CREATE TABLE `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`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

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

-- 
-- Table structure for table `client_auth`
-- 

CREATE TABLE `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;

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

-- 
-- Table structure for table `client_serials`
-- 

CREATE TABLE `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`)
) TYPE=MyISAM AUTO_INCREMENT=22 ;

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

-- 
-- Table structure for table `list_monitors`
-- 

CREATE TABLE `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 ;

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

-- 
-- Table structure for table `ssh_auth_clients`
-- 

CREATE TABLE `ssh_auth_clients` (
  `serial` tinyint(11) NOT NULL default '0',
  `public_key` text NOT NULL
) TYPE=MyISAM;

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

-- 
-- Table structure for table `ssh_auth_server`
-- 

CREATE TABLE `ssh_auth_server` (
  `id` tinyint(11) NOT NULL auto_increment,
  `public_key` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

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

-- 
-- Table structure for table `state_connected`
-- 

CREATE TABLE `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`)
) TYPE=MyISAM AUTO_INCREMENT=103 ;