SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de datos: `ogBDAdmin`
--

ALTER TABLE `ordenadores`ADD `arranque` VARCHAR( 30 ) NOT NULL DEFAULT '1',
ADD `netiface` enum('eth0','eth1','eth2') DEFAULT 'eth0',
ADD `netdriver` VARCHAR( 30 ) NOT NULL DEFAULT 'generic';





ALTER TABLE `aulas` ADD `router` VARCHAR( 30 ),
ADD `netmask` VARCHAR( 30 ),
ADD `dns` VARCHAR (30),
ADD `modp2p` enum('seeder','peer','leecher') DEFAULT 'seeder',
ADD `timep2p` INT(11) NOT NULL DEFAULT '60';






CREATE TABLE IF NOT EXISTS `itemboot` (
  `label` varchar(50) collate utf8_spanish_ci NOT NULL,
  `kernel` varchar(100) collate utf8_spanish_ci NOT NULL,
  `append` varchar(500) collate utf8_spanish_ci NOT NULL,
  PRIMARY KEY  (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;



INSERT INTO `itemboot` (`label`, `kernel`, `append`) VALUES
('1', 'KERNEL syslinux/chain.c32', 'APPEND hd0'),
('1_localboot', 'LOCALBOOT 0', ' '),
('11', 'KERNEL syslinux/chain.c32', 'APPEND hd0 1'),
('12', 'KERNEL syslinux/chain.c32', 'APPEND hd0 2'),
('ogClientUser', 'KERNEL ogclient/ogvmlinuz', 'APPEND initrd=ogclient/oginitrd.img ro boot=oginit vga=788 irqpoll acpi=on og2nd=sqfs ogprotocol=smb  ogactiveadmin=false'),
('ogClientAdmin', 'KERNEL ogclient/ogvmlinuz', 'APPEND initrd=ogclient/oginitrd.img ro boot=oginit vga=788 irqpoll acpi=on og2nd=sqfs ogprotocol=smb ogactiveadmin=true'),
('ogInitrdUser', 'KERNEL linux', 'APPEND initrd=initrd.gz ip=dhcp ro vga=788 irqpoll acpi=on boot=user '),
('ogInitrdAdmin', 'KERNEL linux', 'APPEND initrd=initrd.gz ip=dhcp ro vga=788 irqpoll acpi=on boot=admin ');




CREATE TABLE IF NOT EXISTS `menuboot` (
  `label` varchar(50) collate utf8_spanish_ci NOT NULL,
  `prompt` int(11) NOT NULL,
  `timeout` int(30) default NULL,
  `description` varchar(50) collate utf8_spanish_ci NOT NULL,
  PRIMARY KEY  (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;



INSERT INTO `menuboot` (`label`, `prompt`, `timeout`, `description`) VALUES
('1', 0, 10, 'mbr 1hd'),
('11', 0, 10, '1hd 1particion'),
('12', 0, 10, '1hd 2particion'),
('pxe', 0, 10, 'og client - user'),
('pxeADMIN', 0, 10, 'OgClient - admin');


CREATE TABLE IF NOT EXISTS `menuboot_itemboot` (
  `labelmenu` varchar(100) NOT NULL,
  `labelitem` varchar(100) NOT NULL,
  `default` tinyint(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `menuboot_itemboot` (`labelmenu`, `labelitem`, `default`) VALUES
('0', '0', 0),
('11', '11', 0),
('12', '12', 0),
('1', '1', 0),
('pxe', 'ogClientUser', 0),
('pxeADMIN', 'ogClientAdmin', 0);



--
-- Estructura de tabla para la tabla `asistentes`
--

CREATE TABLE IF NOT EXISTS `asistentes` (
  `idcomando` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(250) NOT NULL DEFAULT '',
  `pagina` varchar(256) NOT NULL,
  `gestor` varchar(256) NOT NULL,
  `funcion` varchar(64) NOT NULL,
  `urlimg` varchar(250) DEFAULT NULL,
  `aplicambito` tinyint(4) DEFAULT NULL,
  `visuparametros` varchar(250) DEFAULT NULL,
  `parametros` varchar(250) DEFAULT NULL,
  `comentarios` text,
  `activo` tinyint(1) NOT NULL,
  PRIMARY KEY (`idcomando`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;


INSERT INTO `asistentes` (`idcomando`, `descripcion`, `pagina`, `gestor`, `funcion`, `urlimg`, `aplicambito`, `visuparametros`, `parametros`, `comentarios`, `activo`) VALUES
('1', 'Asistente Clonacion Particiones Remotas', '../asistentes/AsistenteCloneRemotePartition.php', '../asistentes/gestores/gestor_Comandos.php', 'EjecutarScript', ' ', '31', 'iph;tis;dcr;dsp', 'nfn;iph;tis;dcr;scp', ' ', '1'),
('2', 'Asistente "Deploy" de Imagenes', '../asistentes/AsistenteDeployImage.php', '../asistentes/gestores/gestor_Comandos.php', 'EjecutarScript', ' ', '31', 'iph;tis;dcr;dsp', 'nfn;iph;tis;dcr;scp', ' ', '1'),
('3', 'Asistente "UpdateCache" con Imagenes', '../asistentes/AsistenteUpdateCache.php', '../asistentes/gestores/gestor_Comandos.php', 'EjecutarScript', ' ', '31', 'iph;tis;dcr;dsp', 'nfn;iph;tis;dcr;scp', ' ', '0'),
('4', 'Asistente Restauracion de Imagenes', '../asistentes/AsistenteRestoreImage.php', '../asistentes/gestores/gestor_Comandos.php', 'EjecutarScript', ' ', '31', 'iph;tis;dcr;dsp', 'nfn;iph;tis;dcr;scp', ' ', '0'),
('5', 'Asistente Particionado', '../asistentes/AsistenteParticionado.php', '../asistentes/gestores/gestor_Comandos.php', 'EjecutarScript', ' ', '31', 'iph;tis;dcr;dsp', 'nfn;iph;tis;dcr;scp', ' ', '1');