Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-050/sql/alx_web.sql

    Contents of /alx-src/branches/alx-web-050/sql/alx_web.sql

    Parent Directory Parent Directory | Revision Log Revision Log

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