source: admin/Database/ogAdmBD-1.1.0a-1.1.1.sql @ dd890f1

918-git-images-111dconfigfileconfigure-oglivegit-imageslgromero-new-oglivemainmaint-cronmount-efivarfsmultivmmultivm-ogboot-installerogClonningEngineogboot-installer-jenkinsoglive-ipv6test-python-scriptsticket-301ticket-50ticket-50-oldticket-577ticket-585ticket-611ticket-612ticket-693ticket-700ubu24tplunification2use-local-agent-oglivevarios-instalacion
Last change on this file since dd890f1 was 20e5aaad, checked in by Ramón M. Gómez <ramongomez@…>, 6 years ago

#914: Add definition for Hidden NTFS WinRE partition in MSDOS table.

  • Property mode set to 100644
File size: 633 bytes
RevLine 
[01c5e57]1### Fichero de actualización de la base de datos.
[52a1490]2# OpenGnsys 1.1.0, 1.1.0a - OpenGnsys 1.1.1
[01c5e57]3#use ogAdmBD
4
[20e5aaad]5# Nuevos tipos de particiones.
6INSERT INTO tipospar (codpar, tipopar, clonable) VALUES
7        (CONV('27',16,10), 'HNTFS-WINRE', 1)
8        ON DUPLICATE KEY UPDATE
9                codpar=VALUES(codpar), tipopar=VALUES(tipopar), clonable=VALUES(clonable);
10
[8e6fe0a]11# Añadir campo para incluir PC de profesor de aula (ticket #816).
12ALTER TABLE aulas
13        ADD idordprofesor INT(11) DEFAULT 0 AFTER puestos;
14
[60ea634]15# Borrar campos sin uso del antiguo servicio ogAdmRepo (ticket #875).
[b3dfeb6]16ALTER TABLE repositorios
[60ea634]17        DROP passguor,
[b3dfeb6]18        DROP puertorepo;
19
Note: See TracBrowser for help on using the repository browser.