diff options
Diffstat (limited to 'admin/Database/ogAdmBD-1.0pre-1.0.2.sql')
| -rw-r--r-- | admin/Database/ogAdmBD-1.0pre-1.0.2.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.0pre-1.0.2.sql b/admin/Database/ogAdmBD-1.0pre-1.0.2.sql new file mode 100644 index 00000000..523c1ecf --- /dev/null +++ b/admin/Database/ogAdmBD-1.0pre-1.0.2.sql @@ -0,0 +1,24 @@ +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; + +-- +-- Base de datos: `ogAdmBD` +-- + + +ALTER TABLE `aulas` CHANGE `modp2p` `modp2p` ENUM( 'seeder', 'peer', 'leecher' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'peer'; + +ALTER TABLE `aulas` CHANGE `velmul` `velmul` SMALLINT( 6 ) NOT NULL DEFAULT '70'; + + +ALTER TABLE `asistentes` DROP PRIMARY KEY , +ADD PRIMARY KEY ( `idcomando` , `descripcion` ) ; + +UPDATE `ogAdmBD`.`comandos` SET `activo` = '0' WHERE `comandos`.`idcomando` =10; + +UPDATE `ogAdmBD`.`asistentes` SET `idcomando` = '8' ; + + +UPDATE `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'; + +UPDATE `ogAdmBD`.`parametros` SET `tipopa` = '4', `visual` = '1' WHERE `parametros`.`idparametro` = 30; + |