1 |
-- phpMyAdmin SQL Dump |
-- phpMyAdmin SQL Dump |
2 |
-- version 2.6.3-pl1 |
-- version 2.11.5.1 |
3 |
-- http://www.phpmyadmin.net |
-- http://www.phpmyadmin.net |
4 |
-- |
-- |
5 |
-- Host: localhost |
-- Host: localhost |
6 |
-- Generation Time: Oct 11, 2005 at 02:25 AM |
-- Generation Time: Jun 07, 2008 at 12:25 PM |
7 |
-- Server version: 3.23.49 |
-- Server version: 5.0.51 |
8 |
-- PHP Version: 4.1.2 |
-- PHP Version: 5.2.5 |
9 |
-- |
|
10 |
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
11 |
|
|
12 |
|
-- |
13 |
-- Database: `alx_web` |
-- Database: `alx_web` |
14 |
-- |
-- |
15 |
|
|
16 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
17 |
|
|
18 |
-- |
-- |
19 |
-- Table structure for table `cfg_autostart` |
-- Table structure for table `cfg_autostart` |
20 |
-- |
-- |
21 |
|
|
22 |
CREATE TABLE `cfg_autostart` ( |
CREATE TABLE IF NOT EXISTS `cfg_autostart` ( |
23 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
24 |
`session` varchar(50) NOT NULL default '' |
`session` varchar(50) default NULL |
25 |
) TYPE=MyISAM; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
26 |
|
|
27 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
28 |
|
|
29 |
-- |
-- |
30 |
-- Table structure for table `cfg_comments` |
-- Table structure for table `cfg_comments` |
31 |
-- |
-- |
32 |
|
|
33 |
CREATE TABLE `cfg_comments` ( |
CREATE TABLE IF NOT EXISTS `cfg_comments` ( |
34 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
35 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
36 |
`txt` text NOT NULL, |
`txt` text NOT NULL, |
37 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
38 |
) TYPE=MyISAM AUTO_INCREMENT=7 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
39 |
|
|
40 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
41 |
|
|
42 |
-- |
-- |
43 |
-- Table structure for table `cfg_graphic` |
-- Table structure for table `cfg_graphic` |
44 |
-- |
-- |
45 |
|
|
46 |
CREATE TABLE `cfg_graphic` ( |
CREATE TABLE IF NOT EXISTS `cfg_graphic` ( |
47 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
48 |
`resolution` varchar(100) default NULL, |
`resolution` varchar(100) default NULL, |
49 |
`depth` varchar(100) default NULL, |
`depth` varchar(100) default NULL, |
50 |
`monitorid` int(11) default NULL, |
`monitorid` int(11) default NULL, |
51 |
`module` varchar(100) default NULL, |
`module` varchar(100) default NULL, |
52 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`) |
53 |
) TYPE=MyISAM; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
54 |
|
|
55 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
56 |
|
|
57 |
-- |
-- |
58 |
-- Table structure for table `cfg_input` |
-- Table structure for table `cfg_input` |
59 |
-- |
-- |
60 |
|
|
61 |
CREATE TABLE `cfg_input` ( |
CREATE TABLE IF NOT EXISTS `cfg_input` ( |
62 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
63 |
`mouse` varchar(100) default NULL, |
`mouse` varchar(100) default NULL, |
64 |
|
`mouse_acceleration` tinyint(2) default '0', |
65 |
|
`mouse_threshold` tinyint(2) default '0', |
66 |
`keyboard` varchar(100) default NULL, |
`keyboard` varchar(100) default NULL, |
67 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`) |
68 |
) TYPE=MyISAM; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
69 |
|
|
70 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
71 |
|
|
72 |
-- |
-- |
73 |
-- Table structure for table `cfg_modules` |
-- Table structure for table `cfg_interfaces` |
74 |
-- |
-- |
75 |
|
|
76 |
CREATE TABLE `cfg_modules` ( |
CREATE TABLE IF NOT EXISTS `cfg_interfaces` ( |
77 |
`id` int(11) NOT NULL auto_increment, |
`id` int(255) NOT NULL auto_increment, |
78 |
`serial` int(11) default NULL, |
`serial` int(11) NOT 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', |
|
79 |
`iface` varchar(100) NOT NULL default 'eth0', |
`iface` varchar(100) NOT NULL default 'eth0', |
80 |
`hostname` varchar(100) default NULL, |
`networking` varchar(100) NOT NULL, |
|
`domain` varchar(100) default NULL, |
|
|
`networking` varchar(100) default NULL, |
|
81 |
`netmask` varchar(100) default NULL, |
`netmask` varchar(100) default NULL, |
82 |
`dns` varchar(100) default NULL, |
`dns` varchar(100) default NULL, |
83 |
`gateway` varchar(100) default NULL, |
`gateway` varchar(100) default NULL, |
95 |
`wireless_key_length` varchar(10) default NULL, |
`wireless_key_length` varchar(10) default NULL, |
96 |
`wireless_key` text, |
`wireless_key` text, |
97 |
`wireless_key_ascii` text, |
`wireless_key_ascii` text, |
98 |
|
PRIMARY KEY (`id`) |
99 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
100 |
|
|
101 |
|
-- -------------------------------------------------------- |
102 |
|
|
103 |
|
-- |
104 |
|
-- Table structure for table `cfg_modules` |
105 |
|
-- |
106 |
|
|
107 |
|
CREATE TABLE IF NOT EXISTS `cfg_modules` ( |
108 |
|
`id` int(11) NOT NULL auto_increment, |
109 |
|
`serial` int(11) default NULL, |
110 |
|
`module` varchar(100) default NULL, |
111 |
|
PRIMARY KEY (`id`) |
112 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
113 |
|
|
114 |
|
-- -------------------------------------------------------- |
115 |
|
|
116 |
|
-- |
117 |
|
-- Table structure for table `cfg_network` |
118 |
|
-- |
119 |
|
|
120 |
|
CREATE TABLE IF NOT EXISTS `cfg_network` ( |
121 |
|
`serial` int(11) NOT NULL default '0', |
122 |
|
`default_iface` varchar(100) NOT NULL default 'eth0', |
123 |
|
`hostname` varchar(100) default NULL, |
124 |
|
`domain` varchar(100) default NULL, |
125 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`) |
126 |
) TYPE=MyISAM; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
127 |
|
|
128 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
129 |
|
|
130 |
-- |
-- |
131 |
-- Table structure for table `cfg_other_menuitems` |
-- Table structure for table `cfg_other_menuitems` |
132 |
-- |
-- |
133 |
|
|
134 |
CREATE TABLE `cfg_other_menuitems` ( |
CREATE TABLE IF NOT EXISTS `cfg_other_menuitems` ( |
135 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
136 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
137 |
`name` varchar(50) NOT NULL default '', |
`name` varchar(50) default NULL, |
138 |
`exec` varchar(255) NOT NULL default '', |
`exec` varchar(255) default NULL, |
139 |
`workdir` varchar(100) NOT NULL default '', |
`workdir` varchar(100) default NULL, |
140 |
`icon` varchar(100) NOT NULL default '', |
`icon` varchar(100) default NULL, |
141 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
142 |
) TYPE=MyISAM AUTO_INCREMENT=16 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
143 |
|
|
144 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
145 |
|
|
146 |
-- |
-- |
147 |
-- Table structure for table `cfg_printers` |
-- Table structure for table `cfg_printers` |
148 |
-- |
-- |
149 |
|
|
150 |
CREATE TABLE `cfg_printers` ( |
CREATE TABLE IF NOT EXISTS `cfg_printers` ( |
151 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
152 |
`serial` int(11) default NULL, |
`serial` int(11) default NULL, |
153 |
`port` varchar(100) default NULL, |
`port` varchar(100) default NULL, |
155 |
`ip` varchar(100) default NULL, |
`ip` varchar(100) default NULL, |
156 |
`share` varchar(100) default NULL, |
`share` varchar(100) default NULL, |
157 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
158 |
) TYPE=MyISAM AUTO_INCREMENT=3 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; |
159 |
|
|
160 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
161 |
|
|
162 |
-- |
-- |
163 |
-- Table structure for table `cfg_screensaver` |
-- Table structure for table `cfg_screensaver` |
164 |
-- |
-- |
165 |
|
|
166 |
CREATE TABLE `cfg_screensaver` ( |
CREATE TABLE IF NOT EXISTS `cfg_screensaver` ( |
167 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
168 |
`screensaver` varchar(255) NOT NULL default '', |
`screensaver` varchar(255) default NULL, |
169 |
`timeout` int(11) NOT NULL default '10', |
`timeout` int(11) default '10', |
170 |
`password` varchar(255) default NULL, |
`password` varchar(255) default NULL |
171 |
PRIMARY KEY (`serial`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
) TYPE=MyISAM; |
|
172 |
|
|
173 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
174 |
|
|
175 |
-- |
-- |
176 |
-- Table structure for table `cfg_sessions` |
-- Table structure for table `cfg_sessions` |
177 |
-- |
-- |
178 |
|
|
179 |
CREATE TABLE `cfg_sessions` ( |
CREATE TABLE IF NOT EXISTS `cfg_sessions` ( |
180 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
181 |
`serial` int(11) default NULL, |
`serial` int(11) default NULL, |
182 |
`session` varchar(100) default NULL, |
`session` varchar(100) default NULL, |
183 |
`filename` varchar(50) NOT NULL default '', |
`filename` varchar(50) default NULL, |
184 |
`username` varchar(50) default NULL, |
`username` varchar(50) default NULL, |
185 |
`domain` varchar(50) default NULL, |
`domain` varchar(50) default NULL, |
186 |
`password` varchar(50) default NULL, |
`password` varchar(50) default NULL, |
187 |
`browseradrs` varchar(100) NOT NULL default '', |
`browseradrs` varchar(100) default NULL, |
188 |
|
`displaymode` varchar(20) NOT NULL default 'fullscreen', |
189 |
`flg_modified` tinyint(1) NOT NULL default '0', |
`flg_modified` tinyint(1) NOT NULL default '0', |
190 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
191 |
) TYPE=MyISAM AUTO_INCREMENT=15 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
192 |
|
|
193 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
194 |
|
|
195 |
-- |
-- |
196 |
-- Table structure for table `client_auth` |
-- Table structure for table `client_auth` |
197 |
-- |
-- |
198 |
|
|
199 |
CREATE TABLE `client_auth` ( |
CREATE TABLE IF NOT EXISTS `client_auth` ( |
200 |
`serial` int(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
201 |
`username` varchar(100) default NULL, |
`username` varchar(100) default NULL, |
202 |
`shell` varchar(100) default NULL, |
`shell` varchar(100) default NULL, |
204 |
`samba` varchar(100) default NULL, |
`samba` varchar(100) default NULL, |
205 |
`station` varchar(100) default NULL, |
`station` varchar(100) default NULL, |
206 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`) |
207 |
) TYPE=MyISAM; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
208 |
|
|
209 |
|
-- -------------------------------------------------------- |
210 |
|
|
211 |
|
-- |
212 |
|
-- Table structure for table `client_locations` |
213 |
|
-- |
214 |
|
|
215 |
|
CREATE TABLE IF NOT EXISTS `client_locations` ( |
216 |
|
`location` char(3) NOT NULL default '', |
217 |
|
`updateserver` varchar(100) default NULL, |
218 |
|
`username` varchar(30) default NULL, |
219 |
|
`password` varchar(30) default NULL, |
220 |
|
`rsync` varchar(255) default NULL, |
221 |
|
`repository` varchar(255) default NULL, |
222 |
|
PRIMARY KEY (`location`) |
223 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
224 |
|
|
225 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
226 |
|
|
227 |
-- |
-- |
228 |
-- Table structure for table `client_serials` |
-- Table structure for table `client_serials` |
229 |
-- |
-- |
230 |
|
|
231 |
CREATE TABLE `client_serials` ( |
CREATE TABLE IF NOT EXISTS `client_serials` ( |
232 |
`serial` int(11) NOT NULL auto_increment, |
`serial` int(11) NOT NULL auto_increment, |
233 |
`location` char(3) NOT NULL default '', |
`location` char(3) default NULL, |
234 |
`mtime` int(11) default NULL, |
`mtime` int(11) default NULL, |
235 |
`mac` varchar(17) default NULL, |
`mac` varchar(17) default NULL, |
236 |
PRIMARY KEY (`serial`) |
PRIMARY KEY (`serial`) |
237 |
) TYPE=MyISAM AUTO_INCREMENT=22 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
238 |
|
|
239 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
240 |
|
|
241 |
-- |
-- |
242 |
-- Table structure for table `list_monitors` |
-- Table structure for table `list_monitors` |
243 |
-- |
-- |
244 |
|
|
245 |
CREATE TABLE `list_monitors` ( |
CREATE TABLE IF NOT EXISTS `list_monitors` ( |
246 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
247 |
`vendor` varchar(100) default NULL, |
`vendor` varchar(100) default NULL, |
248 |
`model` varchar(100) default NULL, |
`model` varchar(100) default NULL, |
250 |
`hsync` varchar(100) default NULL, |
`hsync` varchar(100) default NULL, |
251 |
`vrefresh` varchar(100) default NULL, |
`vrefresh` varchar(100) default NULL, |
252 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
253 |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1805 ; |
254 |
|
|
255 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
256 |
|
|
257 |
-- |
-- |
258 |
-- Table structure for table `ssh_auth_clients` |
-- Table structure for table `ssh_auth_clients` |
259 |
-- |
-- |
260 |
|
|
261 |
CREATE TABLE `ssh_auth_clients` ( |
CREATE TABLE IF NOT EXISTS `ssh_auth_clients` ( |
262 |
`serial` tinyint(11) NOT NULL default '0', |
`serial` int(11) NOT NULL default '0', |
263 |
`public_key` text NOT NULL |
`public_key` text NOT NULL |
264 |
) TYPE=MyISAM; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
265 |
|
|
266 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
267 |
|
|
268 |
-- |
-- |
269 |
-- Table structure for table `ssh_auth_server` |
-- Table structure for table `ssh_auth_server` |
270 |
-- |
-- |
271 |
|
|
272 |
CREATE TABLE `ssh_auth_server` ( |
CREATE TABLE IF NOT EXISTS `ssh_auth_server` ( |
273 |
`id` tinyint(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
274 |
`public_key` text NOT NULL, |
`public_key` text NOT NULL, |
275 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
276 |
) TYPE=MyISAM AUTO_INCREMENT=2 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
277 |
|
|
278 |
-- -------------------------------------------------------- |
-- -------------------------------------------------------- |
279 |
|
|
280 |
-- |
-- |
281 |
-- Table structure for table `state_connected` |
-- Table structure for table `state_connected` |
282 |
-- |
-- |
283 |
|
|
284 |
CREATE TABLE `state_connected` ( |
CREATE TABLE IF NOT EXISTS `state_connected` ( |
285 |
`id` int(11) NOT NULL auto_increment, |
`id` int(11) NOT NULL auto_increment, |
286 |
`mtime` int(11) default NULL, |
`mtime` int(11) default NULL, |
287 |
`serial` int(11) default NULL, |
`serial` int(11) default NULL, |
290 |
`mac` varchar(100) default NULL, |
`mac` varchar(100) default NULL, |
291 |
`state` varchar(100) default NULL, |
`state` varchar(100) default NULL, |
292 |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`) |
293 |
) TYPE=MyISAM AUTO_INCREMENT=103 ; |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; |