Annotation of /alx-src/branches/alx-web-050/sql/alx_web.sql
Parent Directory | Revision Log
Revision 1600 -
(hide annotations)
(download)
Thu Dec 2 19:56:40 2010 UTC (13 years, 9 months ago) by niro
File size: 6863 byte(s)
Thu Dec 2 19:56:40 2010 UTC (13 years, 9 months ago) by niro
File size: 6863 byte(s)
-import from 050
1 | niro | 1600 | -- 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 ; |