close Warning: Failed to sync with repository "ogBrowser-Git": (1366, "Incorrect string value: '\\xF0\\x9F\\x93\\xA6 I...' for column 'message' at row 1"); repository information may be out of date. Look in the Trac log for more information including mitigation strategies.

Changes between Version 8 and Version 9 of BaseDeDatos


Ignore:
Timestamp:
Sep 14, 2009, 4:23:45 PM (16 years ago)
Author:
adv
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • BaseDeDatos

    v8 v9  
    8888   PRIMARY KEY  (`idgrupo`)
    8989
     90== Informacion sobre Equipos ==
    9091
    9192
    9293
     94--
     95-- Table structure for table `infonetequipos`
     96--
    9397
     98CREATE TABLE IF NOT EXISTS `infonetequipos` (
     99  `hostname` varchar(32) collate utf8_spanish_ci NOT NULL,
     100  `macaddress` varchar(18) collate utf8_spanish_ci NOT NULL,
     101  `ipaddress` varchar(15) collate utf8_spanish_ci NOT NULL,
     102  `arranque` varchar(7) collate utf8_spanish_ci NOT NULL default 'pxe',
     103  `aula` tinyint(4) NOT NULL,
     104  `startpage` varchar(50) collate utf8_spanish_ci default 'default.sh',
     105  `vga` varchar(5) collate utf8_spanish_ci default '791',
     106  `acpi` enum('on','off') collate utf8_spanish_ci NOT NULL default 'on',
     107  `pci` enum('msi','nomsi') collate utf8_spanish_ci NOT NULL default 'msi',
     108  PRIMARY KEY  (`hostname`),
     109  UNIQUE KEY `mac` (`macaddress`),
     110  UNIQUE KEY `ip` (`ipaddress`)
     111) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
    94112
     113--
     114-- Dumping data for table `infonetequipos`
     115--
     116
     117INSERT INTO `infonetequipos` (`hostname`, `macaddress`, `ipaddress`, `arranque`, `aula`, `startpage`, `vga`, `acpi`, `pci`) VALUES
     118('r60', '00:13:77:66:4e:60', '172.16.72.152', 'ramfs', 1, 'default.sh', '791', 'on', 'msi');