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

2 files changed, 9 insertions, 4 deletions

diff --git a/admin/Database/ogAdmBD-1.0pre-1.0.sql b/admin/Database/ogAdmBD-1.0pre-1.0.sql
index 5ef410d1..4fd30bbb 100644
--- a/admin/Database/ogAdmBD-1.0pre-1.0.sql
+++ b/admin/Database/ogAdmBD-1.0pre-1.0.sql
@@ -5,12 +5,17 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 --
 
 
-UPDATE `ogAdmBD`.`comandos` SET `activo` = '0' WHERE `comandos`.`idcomando` =10;
 
 
 
+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' ;
\ No newline at end of file
+UPDATE `ogAdmBD`.`asistentes` SET `idcomando` = '8' ;
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql
index 15464fff..cfcd2987 100644
--- a/admin/Database/ogAdmBD.sql
+++ b/admin/Database/ogAdmBD.sql
@@ -99,11 +99,11 @@ CREATE TABLE IF NOT EXISTS `aulas` (
   `modomul` tinyint(4) NOT NULL,
   `ipmul` varchar(16) NOT NULL,
   `pormul` int(11) NOT NULL,
-  `velmul` smallint(6) NOT NULL,
+  `velmul` smallint(6) NOT NULL DEFAULT '70',
   `router` VARCHAR( 30 ),
   `netmask` VARCHAR( 30 ),
   `dns` VARCHAR (30),
-  `modp2p` enum('seeder','peer','leecher') DEFAULT 'seeder',
+  `modp2p` enum('seeder','peer','leecher') DEFAULT 'peer',
   `timep2p` INT(11) NOT NULL DEFAULT '60',
   PRIMARY KEY (`idaula`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;