Magellan Linux

Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/values.sh

Parent Directory Parent Directory | Revision Log Revision Log


Revision 8485 - (show annotations) (download) (as text)
Fri Feb 5 12:06:33 2016 UTC (8 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 4465 byte(s)
-added initial schema script
1 create_database_values()
2 {
3 # meta
4 echo "INSERT INTO ${MCORE_SQL_DB}.meta( version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';"
5 mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta( version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" || die "updating version"
6
7 VALUE_DEFINITION=(
8 "values_graphic_depth, value, enabled, id"
9 "24, 1"
10 "16, 1"
11 "8, 1"
12 )
13 sql_set_value
14
15 VALUE_DEFINITION=(
16 "values_graphic_module, value, enabled, id"
17 "vesa, 1"
18 "ati, 1"
19 "cirrus, 1"
20 "i710, 1"
21 "intel, 1"
22 "nv, 1"
23 "nouveau, 1"
24 "mach64, 1"
25 "mga, 1"
26 "openchrome, 1"
27 "radeon, 1"
28 "s3, 1"
29 "s3virge, 1"
30 "savage, 1"
31 "sis, 1"
32 "trident, 1"
33 "tseng, 1"
34 "vmware, 1"
35 )
36 sql_set_value
37
38 VALUE_DEFINITION=(
39 "values_graphic_refresh_rate, value, enabled, id"
40 "60, 1"
41 "75, 1"
42 "85, 1"
43 "100, 1"
44 )
45 sql_set_value
46
47 VALUE_DEFINITION=(
48 "values_input_keymap, value, enabled, id"
49 "us, 1"
50 "de, 1"
51 )
52 sql_set_value
53
54 VALUE_DEFINITION=(
55 "values_graphic_resolution, value, enabled, id"
56 "640x480, 1"
57 "800x600, 1"
58 "1024x768, 1"
59 "1280x960, 1"
60 "1280x1024, 1"
61 "1360x768, 1"
62 "1366x768, 1"
63 "1400x1050, 1"
64 "1440x900, 1"
65 "1600x1200, 1"
66 "1680x1050, 1"
67 "1280x720, 1"
68 "1920x1080, 1"
69 "auto, 1"
70 )
71 sql_set_value
72
73 VALUE_DEFINITION=(
74 "values_network_module, value, enabled, id"
75 ", 1"
76 "3c509, 1"
77 "5c59x, 1"
78 "8139cp, 1"
79 "8139too, 1"
80 "8390, 1"
81 "amd8111e, 1"
82 "atl1c, 1"
83 "atl1e, 1"
84 "atl1, 1"
85 "atl2, 1"
86 "b44, 1"
87 "bnx2, 1"
88 "cnic, 1"
89 "e100, 1"
90 "e1000, 1"
91 "e1000e, 1"
92 "forcedeth, 1"
93 "igb, 1"
94 "ipg, 1"
95 "jme, 1"
96 "natsemi, 1"
97 "ne2k-pci, 1"
98 "ns83820, 1"
99 "pcnet32, 1"
100 "qla3xxx, 1"
101 "r8169, 1"
102 "sis190, 1"
103 "sis900, 1"
104 "skge, 1"
105 "sky2, 1"
106 "tg3, 1"
107 "typhoon, 1"
108 "via-rhine, 1"
109 "via-velocity, 1"
110 "adm8211, 1"
111 "airo, 1"
112 "at76c50x-usb, 1"
113 "ar9170usb, 1"
114 "ath5k, 1"
115 "ath9k, 1"
116 "atmel, 1"
117 "atmel_pci, 1"
118 "b43, 1"
119 "b43legacy, 1"
120 "hostap_pci, 1"
121 "hostap_plx, 1"
122 "ipw2100, 1"
123 "ipw2200, 1"
124 "iwl3945, 1"
125 "iwl4965, 1"
126 "iwldvm, 1"
127 "iwlwifi, 1"
128 "libertas_tf, 1"
129 "libertas_tf_usb, 1"
130 "mwl8k, 1"
131 "orinoco, 1"
132 "orinoco_nortel, 1"
133 "orinoco_plx, 1"
134 "orinico_tmd, 1"
135 "orinoco_usb, 1"
136 "p54pci, 1"
137 "p54usb, 1"
138 "prism54, 1"
139 "mdis_wlan, 1"
140 "rt2400pci, 1"
141 "rt2500pci, 1"
142 "rt2500usb, 1"
143 "rt2800pci, 1"
144 "rt2800usb, 1"
145 "rt61pci, 1"
146 "rt73usb, 1"
147 "rtl8180, 1"
148 "rtl8187, 1"
149 "usb8xxx, 1"
150 "wl1251, 1"
151 "wl1271, 1"
152 "zd1201, 1"
153 "zd1211rw, 1"
154 )
155 sql_set_value
156
157 VALUE_DEFINITION=(
158 "values_printers_port, value, enabled, id"
159 "lpt1, 1"
160 "usb1, 1"
161 "usb2, 1"
162 "com1, 1"
163 "com2, 1"
164 )
165 sql_set_value
166
167 VALUE_DEFINITION=(
168 "values_screensaver_screensaver, value, enabled, id"
169 ", 1"
170 "blank, 1"
171 "random, 1"
172 "ant, 1"
173 "ant3d, 1"
174 "apollonian, 1"
175 "ball, 1"
176 "bat, 1"
177 "blot, 1"
178 "bomb, 1"
179 "bouboule, 1"
180 "bounce, 1"
181 "braid, 1"
182 "bubble, 1"
183 "bug, 1"
184 "clock, 1"
185 "coral, 1"
186 "crystal, 1"
187 "daisy, 1"
188 "dclock, 1"
189 "decay, 1"
190 "deco, 1"
191 "demon, 1"
192 "dilemma, 1"
193 "discrete, 1"
194 "dragon, 1"
195 "drift, 1"
196 "euler2d, 1"
197 "eyes, 1"
198 "fadeplot, 1"
199 "fiberlamp, 1"
200 "flag, 1"
201 "flame, 1"
202 "flow, 1"
203 "forest, 1"
204 "galaxy, 1"
205 "goop, 1"
206 "grav, 1"
207 "helix, 1"
208 "hop, 1"
209 "hyper, 1"
210 "ico, 1"
211 "ifs, 1"
212 "image, 1"
213 "juggle, 1"
214 "julia, 1"
215 "kaleid, 1"
216 "kumppa, 1"
217 "laser, 1"
218 "life, 1"
219 "life1d, 1"
220 "life3d, 1"
221 "lightning, 1"
222 "lisa, 1"
223 "lissie, 1"
224 "loop, 1"
225 "lyapunov, 1"
226 "mandelbrot, 1"
227 "marquee, 1"
228 "matrix, 1"
229 "maze, 1"
230 "mountain, 1"
231 "munch, 1"
232 "nose, 1"
233 "pacman, 1"
234 "penrose, 1"
235 "petal, 1"
236 "petri, 1"
237 "polyominoes, 1"
238 "puzzle, 1"
239 "pyro, 1"
240 "qix, 1"
241 "roll, 1"
242 "rotor, 1"
243 "scooter, 1"
244 "shape, 1"
245 "sierpinski, 1"
246 "slip, 1"
247 "solitare, 1"
248 "space, 1"
249 "sphere, 1"
250 "spiral, 1"
251 "spline, 1"
252 "star, 1"
253 "starfish, 1"
254 "strange, 1"
255 "swarm, 1"
256 "swirl, 1"
257 "t3d, 1"
258 "tetris, 1"
259 "thornbird, 1"
260 "tik_tak, 1"
261 "toneclock, 1"
262 "triangle, 1"
263 "tube, 1"
264 "turtle, 1"
265 "vines, 1"
266 "voters, 1"
267 "wator, 1"
268 "wire, 1"
269 "world, 1"
270 "worm, 1"
271 "xcl, 1"
272 "xjack, 1"
273 )
274 sql_set_value
275 }