| 15 | |
| 16 | |
| 17 | menuboot(label,prompt,timeout,description) |
| 18 | PRIMARY KEY (`label`) |
| 19 | ENGINE=InnoDB |
| 20 | DESCRIPCION: Esta tabla es el menu que mostrará a los clientes pxe. La función SetDefaultBoot(label,IP), la usará para asignarla al cliente. NOTA: un menu está formado por un itemboot o varios. Normalmente un menuboot solo tiene un itemboot. |
| 21 | |
| 22 | INSERT INTO `menuboot` (`label`, `prompt`, `timeout`, `description`) VALUES ('1', 0, 10, 'mbr 1hd'),('11', 0, 10, '1hd 1partion'),('pxe', 0, 10, 'ogClient-pxe'),('ramfs', 1, 50, 'varios ramfs'); |
| 23 | |
| 24 | |
| 25 | CREATE TABLE IF NOT EXISTS `itemboot` ( |
| 26 | `label` varchar(50) collate utf8_spanish_ci NOT NULL, |
| 27 | `kernel` varchar(100) collate utf8_spanish_ci NOT NULL, |
| 28 | `append` varchar(500) collate utf8_spanish_ci NOT NULL, |
| 29 | PRIMARY KEY (`label`) |
| 30 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci; |
| 31 | |
| 32 | -- |
| 33 | -- Dumping data for table `itemboot` |
| 34 | -- |
| 35 | |
| 36 | INSERT INTO `itemboot` (`label`, `kernel`, `append`) VALUES |
| 37 | ('1', 'KERNEL syslinux/chain.c32', 'APPEND hd0'), |
| 38 | ('1_localboot', 'LOCALBOOT 0', ' '), |
| 39 | ('11', 'KERNEL syslinux/chain.c32', 'APPEND hd0 1'), |
| 40 | ('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'), |
| 41 | ('MSdos', 'KERNEL floppies/memdisk', 'APPEND initrd=/floppies/dos.img'), |
| 42 | ('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'), |
| 43 | ('ogClientNfsUltraLight', 'KERNEL ogclients/ogClientNfsUltraLight/linux', 'APPEND initrd=ogclients/ogClientNfsUltraLight/initrd.gz'), |
| 44 | ('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'); |
| 45 | |
| 46 | |
| 47 | -- -------------------------------------------------------- |
| 48 | |
| 49 | -- |
| 50 | -- Table structure for table `menuboot_itemboot` |
| 51 | -- |
| 52 | |
| 53 | CREATE TABLE IF NOT EXISTS `menuboot_itemboot` ( |
| 54 | `labelmenu` varchar(100) NOT NULL, |
| 55 | `labelitem` varchar(100) NOT NULL, |
| 56 | `default` tinyint(10) NOT NULL |
| 57 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 58 | |
| 59 | -- |
| 60 | -- Dumping data for table `menuboot_itemboot` |
| 61 | -- |
| 62 | |
| 63 | INSERT INTO `menuboot_itemboot` (`labelmenu`, `labelitem`, `default`) VALUES |
| 64 | ('0', '0', 0), |
| 65 | ('11', '11', 0), |
| 66 | ('ramfs', 'ogClientNfs', 0), |
| 67 | ('1', '1', 1), |
| 68 | ('pxe', 'ogClientNfs', 1), |
| 69 | ('ramfs', 'ogClientNfsUltraLight', 0); |