diff options
| author | ramon <ramongomez@us.es> | 2011-12-22 13:38:11 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2011-12-22 13:38:11 +0000 |
| commit | c3c7cb3ae6f6600223111a572050f34f2df6fa71 (patch) | |
| tree | 96fce1db6bf64fee2845d3a48abcbe07d9937562 /admin/Database/ogAdmBD-1.0pre-1.0.2.sql | |
| parent | 4caea352de0d0a19d4e0a2e2dd04980dd28e6be0 (diff) | |
Congelar versión 1.0.2 en tags/opengnsys-1.0.2 (modifica #446).opengnsys-1.0.2
git-svn-id: https://opengnsys.es/svn/tags/opengnsys-1.0.2@2405 a21b9725-9963-47de-94b9-378ad31fedc9
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; + |