Changes between Version 8 and Version 9 of BaseDeDatos

Timestamp:

Sep 14, 2009, 4:23:45 PM (16 years ago)

Author:

adv

Comment:

--

BaseDeDatos

@@ -88 +88 @@
    PRIMARY KEY  (`idgrupo`)
 
+== Informacion sobre Equipos ==
 
 
 
+--
+-- Table structure for table `infonetequipos`
+--
 
+CREATE TABLE IF NOT EXISTS `infonetequipos` (
+  `hostname` varchar(32) collate utf8_spanish_ci NOT NULL,
+  `macaddress` varchar(18) collate utf8_spanish_ci NOT NULL,
+  `ipaddress` varchar(15) collate utf8_spanish_ci NOT NULL,
+  `arranque` varchar(7) collate utf8_spanish_ci NOT NULL default 'pxe',
+  `aula` tinyint(4) NOT NULL,
+  `startpage` varchar(50) collate utf8_spanish_ci default 'default.sh',
+  `vga` varchar(5) collate utf8_spanish_ci default '791',
+  `acpi` enum('on','off') collate utf8_spanish_ci NOT NULL default 'on',
+  `pci` enum('msi','nomsi') collate utf8_spanish_ci NOT NULL default 'msi',
+  PRIMARY KEY  (`hostname`),
+  UNIQUE KEY `mac` (`macaddress`),
+  UNIQUE KEY `ip` (`ipaddress`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
 
+--
+-- Dumping data for table `infonetequipos`
+--
+
+INSERT INTO `infonetequipos` (`hostname`, `macaddress`, `ipaddress`, `arranque`, `aula`, `startpage`, `vga`, `acpi`, `pci`) VALUES
+('r60', '00:13:77:66:4e:60', '172.16.72.152', 'ramfs', 1, 'default.sh', '791', 'on', 'msi');