sql-schema/include/values.sh

create_database_values()
{
	# meta
	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"

	VALUE_DEFINITION=(
		"values_graphic_depth, value, enabled, id"
			"24, 1"
			"16, 1"
			"8, 1"
	)
	sql_set_value

	VALUE_DEFINITION=(
		"values_graphic_module, value, enabled, id"
			"vesa, 1"
			"ati, 1"
			"cirrus, 1"
			"i710, 1"
			"intel, 1"
			"nv, 1"
			"nouveau, 1"
			"mach64, 1"
			"mga, 1"
			"openchrome, 1"
			"radeon, 1"
			"s3, 1"
			"s3virge, 1"
			"savage, 1"
			"sis, 1"
			"trident, 1"
			"tseng, 1"
			"vmware, 1"
	)
	sql_set_value

	VALUE_DEFINITION=(
		"values_graphic_refresh_rate, value, enabled, id"
			"60, 1"
			"75, 1"
			"85, 1"
			"100, 1"
	)
	sql_set_value

	VALUE_DEFINITION=(
		"values_input_keymap, value, enabled, id"
			"us, 1"
			"de, 1"
	)
	sql_set_value

	VALUE_DEFINITION=(
		"values_graphic_resolution, value, enabled, id"
			"640x480, 1"
			"800x600, 1"
			"1024x768, 1"
			"1280x960, 1"
			"1280x1024, 1"
			"1360x768, 1"
			"1366x768, 1"
			"1400x1050, 1"
			"1440x900, 1"
			"1600x1200, 1"
			"1680x1050, 1"
			"1280x720, 1"
			"1920x1080, 1"
			"auto, 1"
	)
	sql_set_value

	VALUE_DEFINITION=(
		"values_network_module, value, enabled, id"
			", 1"
			"3c509, 1"
			"5c59x, 1"
			"8139cp, 1"
			"8139too, 1"
			"8390, 1"
			"amd8111e, 1"
			"atl1c, 1"
			"atl1e, 1"
			"atl1, 1"
			"atl2, 1"
			"b44, 1"
			"bnx2, 1"
			"cnic, 1"
			"e100, 1"
			"e1000, 1"
			"e1000e, 1"
			"forcedeth, 1"
			"igb, 1"
			"ipg, 1"
			"jme, 1"
			"natsemi, 1"
			"ne2k-pci, 1"
			"ns83820, 1"
			"pcnet32, 1"
			"qla3xxx, 1"
			"r8169, 1"
			"sis190, 1"
			"sis900, 1"
			"skge, 1"
			"sky2, 1"
			"tg3, 1"
			"typhoon, 1"
			"via-rhine, 1"
			"via-velocity, 1"
			"adm8211, 1"
			"airo, 1"
			"at76c50x-usb, 1"
			"ar9170usb, 1"
			"ath5k, 1"
			"ath9k, 1"
			"atmel, 1"
			"atmel_pci, 1"
			"b43, 1"
			"b43legacy, 1"
			"hostap_pci, 1"
			"hostap_plx, 1"
			"ipw2100, 1"
			"ipw2200, 1"
			"iwl3945, 1"
			"iwl4965, 1"
			"iwldvm, 1"
			"iwlwifi, 1"
			"libertas_tf, 1"
			"libertas_tf_usb, 1"
			"mwl8k, 1"
			"orinoco, 1"
			"orinoco_nortel, 1"
			"orinoco_plx, 1"
			"orinico_tmd, 1"
			"orinoco_usb, 1"
			"p54pci, 1"
			"p54usb, 1"
			"prism54, 1"
			"mdis_wlan, 1"
			"rt2400pci, 1"
			"rt2500pci, 1"
			"rt2500usb, 1"
			"rt2800pci, 1"
			"rt2800usb, 1"
			"rt61pci, 1"
			"rt73usb, 1"
			"rtl8180, 1"
			"rtl8187, 1"
			"usb8xxx, 1"
			"wl1251, 1"
			"wl1271, 1"
			"zd1201, 1"
			"zd1211rw, 1"
	)
	sql_set_value

	VALUE_DEFINITION=(
		"values_printers_port, value, enabled, id"
			"lpt1, 1"
			"usb1, 1"
			"usb2, 1"
			"com1, 1"
			"com2, 1"
	)
	sql_set_value

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