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

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 42ac964 was b1fd551, checked in by adv <adv@…>, 14 years ago

version 1.0 ticket:311 #311 dando valores por defecto a la tabla BD aulas

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

  • Property mode set to 100644
File size: 541 bytes
Line 
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3--
4-- Base de datos: `ogBDAdmin`
5--
6
7
8
9
10
11ALTER TABLE `aulas` CHANGE `modp2p` `modp2p` ENUM( 'seeder', 'peer', 'leecher' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'peer';
12
13ALTER TABLE `aulas` CHANGE `velmul` `velmul` SMALLINT( 6 ) NOT NULL DEFAULT '70';
14
15
16ALTER TABLE `asistentes` DROP PRIMARY KEY ,
17ADD PRIMARY KEY ( `idcomando` , `descripcion` ) ;
18
19UPDATE `ogAdmBD`.`comandos` SET `activo` = '0' WHERE `comandos`.`idcomando` =10;
20
21UPDATE `ogAdmBD`.`asistentes` SET `idcomando` = '8' ;
Note: See TracBrowser for help on using the repository browser.