Contents of /alx-src/trunk/alx-web/sql/alx_web.sql
Parent Directory | Revision Log
Revision 480 -
(show annotations)
(download)
Sat Jun 7 10:20:35 2008 UTC (16 years, 3 months ago) by niro
File size: 8377 byte(s)
Sat Jun 7 10:20:35 2008 UTC (16 years, 3 months ago) by niro
File size: 8377 byte(s)
-update to current
1 | -- phpMyAdmin SQL Dump |
2 | -- version 2.11.5.1 |
3 | -- http://www.phpmyadmin.net |
4 | -- |
5 | -- Host: localhost |
6 | -- Generation Time: Jun 07, 2008 at 12:25 PM |
7 | -- Server version: 5.0.51 |
8 | -- PHP Version: 5.2.5 |
9 | |
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
11 | |
12 | -- |
13 | -- Database: `alx_web` |
14 | -- |
15 | |
16 | -- -------------------------------------------------------- |
17 | |
18 | -- |
19 | -- Table structure for table `cfg_autostart` |
20 | -- |
21 | |
22 | CREATE TABLE IF NOT EXISTS `cfg_autostart` ( |
23 | `serial` int(11) NOT NULL default '0', |
24 | `session` varchar(50) default NULL |
25 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
26 | |
27 | -- -------------------------------------------------------- |
28 | |
29 | -- |
30 | -- Table structure for table `cfg_comments` |
31 | -- |
32 | |
33 | CREATE TABLE IF NOT EXISTS `cfg_comments` ( |
34 | `id` int(11) NOT NULL auto_increment, |
35 | `serial` int(11) NOT NULL default '0', |
36 | `txt` text NOT NULL, |
37 | PRIMARY KEY (`id`) |
38 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
39 | |
40 | -- -------------------------------------------------------- |
41 | |
42 | -- |
43 | -- Table structure for table `cfg_graphic` |
44 | -- |
45 | |
46 | CREATE TABLE IF NOT EXISTS `cfg_graphic` ( |
47 | `serial` int(11) NOT NULL default '0', |
48 | `resolution` varchar(100) default NULL, |
49 | `depth` varchar(100) default NULL, |
50 | `monitorid` int(11) default NULL, |
51 | `module` varchar(100) default NULL, |
52 | PRIMARY KEY (`serial`) |
53 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
54 | |
55 | -- -------------------------------------------------------- |
56 | |
57 | -- |
58 | -- Table structure for table `cfg_input` |
59 | -- |
60 | |
61 | CREATE TABLE IF NOT EXISTS `cfg_input` ( |
62 | `serial` int(11) NOT NULL default '0', |
63 | `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, |
67 | PRIMARY KEY (`serial`) |
68 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
69 | |
70 | -- -------------------------------------------------------- |
71 | |
72 | -- |
73 | -- Table structure for table `cfg_interfaces` |
74 | -- |
75 | |
76 | CREATE TABLE IF NOT EXISTS `cfg_interfaces` ( |
77 | `id` int(255) NOT NULL auto_increment, |
78 | `serial` int(11) NOT NULL, |
79 | `iface` varchar(100) NOT NULL default 'eth0', |
80 | `networking` varchar(100) NOT NULL, |
81 | `netmask` varchar(100) default NULL, |
82 | `dns` varchar(100) default NULL, |
83 | `gateway` varchar(100) default NULL, |
84 | `broadcast` varchar(100) default NULL, |
85 | `ip` varchar(100) default NULL, |
86 | `module` varchar(100) default NULL, |
87 | `forcemacto` varchar(17) default NULL, |
88 | `wireless_bitrate` varchar(5) default NULL, |
89 | `wireless_channel` varchar(10) default NULL, |
90 | `wireless_essid` varchar(255) default NULL, |
91 | `wireless_frequency` varchar(255) default NULL, |
92 | `wireless_mode` varchar(255) default NULL, |
93 | `wireless_nick` varchar(255) default NULL, |
94 | `wireless_auth_mode` varchar(255) default NULL, |
95 | `wireless_key_length` varchar(10) default NULL, |
96 | `wireless_key` text, |
97 | `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`) |
126 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
127 | |
128 | -- -------------------------------------------------------- |
129 | |
130 | -- |
131 | -- Table structure for table `cfg_other_menuitems` |
132 | -- |
133 | |
134 | CREATE TABLE IF NOT EXISTS `cfg_other_menuitems` ( |
135 | `id` int(11) NOT NULL auto_increment, |
136 | `serial` int(11) NOT NULL default '0', |
137 | `name` varchar(50) default NULL, |
138 | `exec` varchar(255) default NULL, |
139 | `workdir` varchar(100) default NULL, |
140 | `icon` varchar(100) default NULL, |
141 | PRIMARY KEY (`id`) |
142 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
143 | |
144 | -- -------------------------------------------------------- |
145 | |
146 | -- |
147 | -- Table structure for table `cfg_printers` |
148 | -- |
149 | |
150 | CREATE TABLE IF NOT EXISTS `cfg_printers` ( |
151 | `id` int(11) NOT NULL auto_increment, |
152 | `serial` int(11) default NULL, |
153 | `port` varchar(100) default NULL, |
154 | `printer_name` varchar(100) default NULL, |
155 | `ip` varchar(100) default NULL, |
156 | `share` varchar(100) default NULL, |
157 | PRIMARY KEY (`id`) |
158 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; |
159 | |
160 | -- -------------------------------------------------------- |
161 | |
162 | -- |
163 | -- Table structure for table `cfg_screensaver` |
164 | -- |
165 | |
166 | CREATE TABLE IF NOT EXISTS `cfg_screensaver` ( |
167 | `serial` int(11) NOT NULL default '0', |
168 | `screensaver` varchar(255) default NULL, |
169 | `timeout` int(11) default '10', |
170 | `password` varchar(255) default NULL |
171 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
172 | |
173 | -- -------------------------------------------------------- |
174 | |
175 | -- |
176 | -- Table structure for table `cfg_sessions` |
177 | -- |
178 | |
179 | CREATE TABLE IF NOT EXISTS `cfg_sessions` ( |
180 | `id` int(11) NOT NULL auto_increment, |
181 | `serial` int(11) default NULL, |
182 | `session` varchar(100) default NULL, |
183 | `filename` varchar(50) default NULL, |
184 | `username` varchar(50) default NULL, |
185 | `domain` varchar(50) default NULL, |
186 | `password` varchar(50) default NULL, |
187 | `browseradrs` varchar(100) default NULL, |
188 | `displaymode` varchar(20) NOT NULL default 'fullscreen', |
189 | `flg_modified` tinyint(1) NOT NULL default '0', |
190 | PRIMARY KEY (`id`) |
191 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
192 | |
193 | -- -------------------------------------------------------- |
194 | |
195 | -- |
196 | -- Table structure for table `client_auth` |
197 | -- |
198 | |
199 | CREATE TABLE IF NOT EXISTS `client_auth` ( |
200 | `serial` int(11) NOT NULL default '0', |
201 | `username` varchar(100) default NULL, |
202 | `shell` varchar(100) default NULL, |
203 | `vnc` varchar(100) default NULL, |
204 | `samba` varchar(100) default NULL, |
205 | `station` varchar(100) default NULL, |
206 | PRIMARY KEY (`serial`) |
207 | ) 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` |
229 | -- |
230 | |
231 | CREATE TABLE IF NOT EXISTS `client_serials` ( |
232 | `serial` int(11) NOT NULL auto_increment, |
233 | `location` char(3) default NULL, |
234 | `mtime` int(11) default NULL, |
235 | `mac` varchar(17) default NULL, |
236 | PRIMARY KEY (`serial`) |
237 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
238 | |
239 | -- -------------------------------------------------------- |
240 | |
241 | -- |
242 | -- Table structure for table `list_monitors` |
243 | -- |
244 | |
245 | CREATE TABLE IF NOT EXISTS `list_monitors` ( |
246 | `id` int(11) NOT NULL auto_increment, |
247 | `vendor` varchar(100) default NULL, |
248 | `model` varchar(100) default NULL, |
249 | `size` int(11) default NULL, |
250 | `hsync` varchar(100) default NULL, |
251 | `vrefresh` varchar(100) default NULL, |
252 | PRIMARY KEY (`id`) |
253 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1805 ; |
254 | |
255 | -- -------------------------------------------------------- |
256 | |
257 | -- |
258 | -- Table structure for table `ssh_auth_clients` |
259 | -- |
260 | |
261 | CREATE TABLE IF NOT EXISTS `ssh_auth_clients` ( |
262 | `serial` int(11) NOT NULL default '0', |
263 | `public_key` text NOT NULL |
264 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
265 | |
266 | -- -------------------------------------------------------- |
267 | |
268 | -- |
269 | -- Table structure for table `ssh_auth_server` |
270 | -- |
271 | |
272 | CREATE TABLE IF NOT EXISTS `ssh_auth_server` ( |
273 | `id` int(11) NOT NULL auto_increment, |
274 | `public_key` text NOT NULL, |
275 | PRIMARY KEY (`id`) |
276 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
277 | |
278 | -- -------------------------------------------------------- |
279 | |
280 | -- |
281 | -- Table structure for table `state_connected` |
282 | -- |
283 | |
284 | CREATE TABLE IF NOT EXISTS `state_connected` ( |
285 | `id` int(11) NOT NULL auto_increment, |
286 | `mtime` int(11) default NULL, |
287 | `serial` int(11) default NULL, |
288 | `hostname` varchar(100) default NULL, |
289 | `ip` varchar(100) default NULL, |
290 | `mac` varchar(100) default NULL, |
291 | `state` varchar(100) default NULL, |
292 | PRIMARY KEY (`id`) |
293 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; |