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