Changes between Version 3 and Version 4 of BaseDeDatos

Timestamp:

Sep 14, 2009, 3:45:59 PM (16 years ago)

Author:

adv

Comment:

--

BaseDeDatos

@@ -23 +23 @@
 
 
-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,
+itemboot(label,kernel,append)
   PRIMARY KEY  (`label`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
-
---
--- Dumping data for table `itemboot`
---
+  ENGINE=InnoDB 
+  DESCRIPCION: esta tabla recoge los elementos de arranque ya sean locales (discos duros) o remotos (clientes opengnsys o cualquier otro que queramos integrar)
 
 INSERT INTO `itemboot` (`label`, `kernel`, `append`) VALUES
@@ -38 +32 @@
 ('1_localboot', 'LOCALBOOT 0', ' '),
 ('11', 'KERNEL syslinux/chain.c32', 'APPEND hd0 1'),
-('EACdefault', 'KERNEL EACBootAgent/stable/vmlinuz-2.6.28-11-server', 'APPEND root=/dev/nfs initrd=EACBootAgent/stable/initrd.img-2.6.28-11-server nfsroot=repo_client:/var/EAC/nfsroot/stable ip=dhcp ro vga=788 irqpoll nolapic  acpi=off EACregistred=no pci=nomsi EACregistred=NO'),
-('MSdos', 'KERNEL floppies/memdisk', 'APPEND initrd=/floppies/dos.img'),
+
 ('ogClientNfs', 'KERNEL ogclients/ogClientNfs/netboot/vmlinuz-2.6.31-2-generic', 'APPEND root=/dev/nfs initrd=ogclients/ogClientNfs/netboot/initrd.img-2.6.31-2-generic nfsroot=repo_client:/opt/opengnsys/tftpboot/ogclients/ogClientNfs'),
+
 ('ogClientNfsUltraLight', 'KERNEL ogclients/ogClientNfsUltraLight/linux', 'APPEND initrd=ogclients/ogClientNfsUltraLight/initrd.gz'),
+
 ('ogClientRamfs', 'kernel ping-brutalix/kernel', 'append vga=normal devfs=nomount pxe ramdisk_size=33000 load_ramdisk=1 init=/linuxrc prompt_ramdisk=0 initrd=ping-brutalix/initrd.gz root=/dev/ram0 rw nolapic lba');
 
 
--- --------------------------------------------------------
 
---
--- Table structure for table `menuboot_itemboot`
---
-
-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;
-
---
--- Dumping data for table `menuboot_itemboot`
---
+menuboot_itemboot(labelmenu,labelitem,default)
+ ENGINE=MyISAM 
+ DESCRIPCION: tabla resultante de la relación muchos a muchos de las dos anteriores.
 
 INSERT INTO `menuboot_itemboot` (`labelmenu`, `labelitem`, `default`) VALUES