summaryrefslogtreecommitdiffstats
path: root/admin/Database/ogAdmBD-1.1.0pre-postinst.sql
blob: 95ab6470af45c60d7a73a4ed74bfb59db3be7df4 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
### Procedimiento para actualización de la base de datos.
# Postinstalación de OpenGnSys 1.1.0
#use ogAdmBD

# Nota: retocar el fichero para sustituir KERNELVERSION por la versión del 
#       Kernel del cliente ogLive con el formato V.RR (V=versión, RR=revisión).

# Cambiar parámetro de resolución de pantalla para Kernel anteriores a 3.7 o posteriores a 4.3.
UPDATE menus
	SET resolucion = CASE resolucion 
				WHEN 'uvesafb:1152x864-16' THEN '355'
				WHEN 'uvesafb:800x600-16' THEN '788'
				WHEN 'uvesafb:800x600-24' THEN '789'
				WHEN 'uvesafb:800x600-32' THEN '814'
				WHEN 'uvesafb:1024x768-16' THEN '791'
				WHEN 'uvesafb:1024x768-24' THEN '792'
				WHEN 'uvesafb:1024x768-32' THEN '824'
				WHEN 'uvesafb:1280x1024-16' THEN '794'
				WHEN 'uvesafb:1280x1024-24' THEN '795'
				WHEN 'uvesafb:1280x1024-32' THEN '829'
				WHEN 'uvesafb:1600x1200-16' THEN '798'
				WHEN 'uvesafb:1600x1200-24' THEN '799'
				WHEN 'uvesafb:1600x1200-32' THEN '834'
				WHEN NULL or '0' THEN '788'
				ELSE resolucion
			 END
			 WHERE KERNELVERSION < 3.07 OR KERNELVERSION >= 4.04;

# Cambiar parámetro de resolución de pantalla para Kernel entre 3.7 y 4.3.
UPDATE menus
	SET resolucion = CASE resolucion 
				WHEN '355' THEN 'uvesafb:1152x864-16'
				WHEN '788' THEN 'uvesafb:800x600-16'
				WHEN '789' THEN 'uvesafb:800x600-24'
				WHEN '791' THEN 'uvesafb:1024x768-16'
				WHEN '792' THEN 'uvesafb:1024x768-24'
				WHEN '794' THEN 'uvesafb:1280x1024-16'
				WHEN '795' THEN 'uvesafb:1280x1024-24'
				WHEN '798' THEN 'uvesafb:1600x1200-16'
				WHEN '799' THEN 'uvesafb:1600x1200-24'
				WHEN '814' THEN 'uvesafb:800x600-32'
				WHEN '824' THEN 'uvesafb:1024x768-32'
				WHEN '829' THEN 'uvesafb:1280x1024-32'
				WHEN '834' THEN 'uvesafb:1600x1200-32'
				WHEN NULL or '0' THEN 'uvesafb:800x600-16'
				ELSE resolucion
			 END
			 WHERE KERNELVERSION >= 3.07 OR KERNELVERSION < 4.04;;