source: admin/Database/ogAdmBD-1.0pre-1.0.sql @ ea60f41

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-instalacionwebconsole3
Last change on this file since ea60f41 was 27dc5ff, checked in by ramon <ramongomez@…>, 14 years ago

Versión 1.0.1: secuencia más lógica de ejecución del actualizador; aplicar actualización en bases de datos para el comando restaurar (modificar #357).

git-svn-id: https://opengnsys.es/svn/branches/version1.0@2027 a21b9725-9963-47de-94b9-378ad31fedc9

  • Property mode set to 100644
File size: 760 bytes
Line 
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3--
4-- Base de datos: `ogAdmBD`
5--
6
7
8ALTER TABLE `aulas` CHANGE `modp2p` `modp2p` ENUM( 'seeder', 'peer', 'leecher' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'peer';
9
10ALTER TABLE `aulas` CHANGE `velmul` `velmul` SMALLINT( 6 ) NOT NULL DEFAULT '70';
11
12
13ALTER TABLE `asistentes` DROP PRIMARY KEY ,
14ADD PRIMARY KEY ( `idcomando` , `descripcion` ) ;
15
16UPDATE `ogAdmBD`.`comandos` SET `activo` = '0' WHERE `comandos`.`idcomando` =10;
17
18UPDATE `ogAdmBD`.`asistentes` SET `idcomando` = '8' ;
19
20
21UPDATE `ogAdmBD`.`itemboot` SET `append` = 'APPEND initrd=ogclient/oginitrd.img ro boot=oginit vga=788 irqpoll acpi=on og2nd=sqfs ogprotocol=smb ogactiveadmin=true ogdebug=true' WHERE `itemboot`.`label` = 'ogClientAdmin';
Note: See TracBrowser for help on using the repository browser.