summaryrefslogtreecommitdiffstats
path: root/admin/Database/ogAdmBD-1.1.0a-postinst.sql
diff options
context:
space:
mode:
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.0a-postinst.sql')
-rw-r--r--admin/Database/ogAdmBD-1.1.0a-postinst.sql49
1 files changed, 49 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0a-postinst.sql b/admin/Database/ogAdmBD-1.1.0a-postinst.sql
new file mode 100644
index 00000000..7ebbfd14
--- /dev/null
+++ b/admin/Database/ogAdmBD-1.1.0a-postinst.sql
@@ -0,0 +1,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.
+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;
+
+# Cambiar parámetro de resolución de pantalla para Kernel 3.7 o superior.
+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;
+