| | 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); |