Contents of /alx-src/trunk/alx-web/sql/alx_web.sql
Parent Directory | Revision Log
Revision 364 -
(show annotations)
(download)
Mon Oct 10 22:52:24 2005 UTC (18 years, 11 months ago) by niro
File size: 6863 byte(s)
Mon Oct 10 22:52:24 2005 UTC (18 years, 11 months ago) by niro
File size: 6863 byte(s)
added missing sql layout
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 ; |