-- $Id:$
--
-- Copyright (C) 2007 Platform Computing
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of version 2 of the GNU General Public License as
-- published by the Free Software Foundation.
-- 	
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
--
--


-- Setup a default repo and kits
insert into repos VALUES (1000, 'rhel5_x86_64','/depot/repos/1000' );

-- Setup some node groups
-- Nodegroups
INSERT INTO nodegroups VALUES(1,1000,'installer','package','OS Installers','installer-#RR-#NN','kernel-rhel-5-x86_64','initrd-rhel-5-x86_64.img','text noipv6 kssendmac selinux=0','installer');
INSERT INTO nodegroups VALUES(2,1000,'compute-rhel','package','Red Hat Node installed by packages','compute-#RR-#NN','kernel-rhel-5-x86_64','initrd-rhel-5-x86_64.img','text noipv6 kssendmac selinux=0','compute');
INSERT INTO nodegroups VALUES(3,1000,'compute-imaged','disked','Nodes installed from an image','host#NNN',NULL,NULL,NULL,'compute');
INSERT INTO nodegroups VALUES(4,1000,'compute-diskless','diskless','Diskless Nodes','host#NNN',NULL,NULL,NULL,'compute');
INSERT INTO nodegroups VALUES(5,1000,'unmanaged','unmanaged',NULL,'device#NNN',NULL,NULL,NULL,'other');


-- Application Globals
insert into appglobals values (1, 'ClusterName', 'BadBoy', NULL) ;
insert into appglobals values (2, 'DNSZone', 'myzone.company.com', NULL) ;
insert into appglobals values (3, 'DNSForwarders', '172.16.1.5,172.16.1.8', NULL) ;
insert into appglobals values (4, 'DNSSearch', 'myzone.company.com company.com corp.company.com', NULL) ;
insert into appglobals values (5, 'NASServer', '172.25.243.2', NULL) ;
insert into appglobals values (6, 'TimeZone', 'EST/EDT', NULL) ;
insert into appglobals values (7, 'NISDomain', 'engineering', 2) ;
insert into appglobals values (8, 'NISServers', '172.25.243.4,172.25.243.14', 2) ;
insert into appglobals values (9, 'NISDomain', 'testing', 3) ;
insert into appglobals values (10, 'NISServers', '172.25.243.99,172.25.243.100', 3) ;
insert into appglobals values (11, 'CFMSecret', 'GF5SEVTHJ589TNT45NTEYST78GYBG5GVYGT84NTV578TEB46', NULL) ;
insert into appglobals values (12, 'InstallerServeDNS', 'True', NULL) ;
insert into appglobals values (13, 'InstallerServeNIS', 'True', NULL) ;
insert into appglobals values (14, 'InstallerServeNFS', 'True', NULL) ;
insert into appglobals values (15, 'InstallerServeNTP', 'True', NULL) ;
insert into appglobals values (16, 'PrimaryInstaller', 'installer00', NULL) ;
insert into appglobals values (17, 'DHCPLeaseTime', '2400', NULL) ;
insert into appglobals values (18, 'InstallerServeSMTP', 'False', NULL) ;
insert into appglobals values (19, 'SMTPServer', 'mailserver.myzone.company.com', NULL) ;
insert into appglobals values (20, 'CFMBaseDir', '/opt/kusu/cfm', NULL) ;
insert into appglobals values (21, 'ImageBaseDir', '/depot/images', 1) ;


-- Setup the packages
INSERT INTO packages VALUES(1,4,'SysVinit');
INSERT INTO packages VALUES(2,4,'basesystem');
INSERT INTO packages VALUES(3,4,'bash');
INSERT INTO packages VALUES(4,4,'redhat-release');
INSERT INTO packages VALUES(5,4,'chkconfig');
INSERT INTO packages VALUES(6,4,'coreutils');
INSERT INTO packages VALUES(7,4,'db4');
INSERT INTO packages VALUES(8,4,'e2fsprogs');
INSERT INTO packages VALUES(9,4,'filesystem');
INSERT INTO packages VALUES(10,4,'findutils');
INSERT INTO packages VALUES(11,4,'gawk');
INSERT INTO packages VALUES(12,4,'cracklib-dicts');
INSERT INTO packages VALUES(13,4,'glibc');
INSERT INTO packages VALUES(14,4,'glibc-common');
INSERT INTO packages VALUES(15,4,'initscripts');
INSERT INTO packages VALUES(16,4,'iproute');
INSERT INTO packages VALUES(17,4,'iputils');
INSERT INTO packages VALUES(18,4,'krb5-libs');
INSERT INTO packages VALUES(19,4,'libacl');
INSERT INTO packages VALUES(20,4,'libattr');
INSERT INTO packages VALUES(21,4,'libgcc');
INSERT INTO packages VALUES(22,4,'libstdc++');
INSERT INTO packages VALUES(23,4,'libtermcap');
INSERT INTO packages VALUES(24,4,'mingetty');
INSERT INTO packages VALUES(25,4,'mktemp');
INSERT INTO packages VALUES(26,4,'ncurses');
INSERT INTO packages VALUES(27,4,'net-tools');
INSERT INTO packages VALUES(28,4,'nfs-utils');
INSERT INTO packages VALUES(29,4,'pam');
INSERT INTO packages VALUES(30,4,'pcre');
INSERT INTO packages VALUES(31,4,'popt');
INSERT INTO packages VALUES(32,4,'portmap');
INSERT INTO packages VALUES(33,4,'procps');
INSERT INTO packages VALUES(34,4,'psmisc');
INSERT INTO packages VALUES(35,4,'rdate');
INSERT INTO packages VALUES(36,4,'rsh');
INSERT INTO packages VALUES(37,4,'rsh-server');
INSERT INTO packages VALUES(38,4,'rsync');
INSERT INTO packages VALUES(39,4,'sed');
INSERT INTO packages VALUES(40,4,'setup');
INSERT INTO packages VALUES(41,4,'shadow-utils');
INSERT INTO packages VALUES(42,4,'openssh');
INSERT INTO packages VALUES(43,4,'openssh-server');
INSERT INTO packages VALUES(44,4,'openssh-clients');
INSERT INTO packages VALUES(45,4,'sysklogd');
INSERT INTO packages VALUES(46,4,'tcp_wrappers');
INSERT INTO packages VALUES(47,4,'termcap');
INSERT INTO packages VALUES(48,4,'tzdata');
INSERT INTO packages VALUES(49,4,'util-linux');
INSERT INTO packages VALUES(50,4,'words');
INSERT INTO packages VALUES(51,4,'xinetd');
INSERT INTO packages VALUES(52,4,'zlib');
INSERT INTO packages VALUES(53,4,'tar');
INSERT INTO packages VALUES(54,4,'mkinitrd');
INSERT INTO packages VALUES(55,4,'less');
INSERT INTO packages VALUES(56,4,'gzip');
INSERT INTO packages VALUES(57,4,'which');
INSERT INTO packages VALUES(58,4,'util-linux');
INSERT INTO packages VALUES(59,4,'module-init-tools');
INSERT INTO packages VALUES(60,4,'udev');
INSERT INTO packages VALUES(61,4,'cracklib');
INSERT INTO packages VALUES(62,4,'yum');
INSERT INTO packages VALUES(63,4,'vim-minimal');
INSERT INTO packages VALUES(64,4,'vim-common');
INSERT INTO packages VALUES(65,4,'vim-enhanced');
INSERT INTO packages VALUES(66,4,'rootfiles');
INSERT INTO packages VALUES(67,4,'autofs');
INSERT INTO packages VALUES(68,4,'ntp');
INSERT INTO packages VALUES(69,3,'SysVinit');
INSERT INTO packages VALUES(70,3,'basesystem');
INSERT INTO packages VALUES(71,3,'bash');
INSERT INTO packages VALUES(72,3,'kernel');
INSERT INTO packages VALUES(73,3,'grub');
INSERT INTO packages VALUES(74,3,'redhat-release');
INSERT INTO packages VALUES(75,3,'chkconfig');
INSERT INTO packages VALUES(76,3,'coreutils');
INSERT INTO packages VALUES(77,3,'db4');
INSERT INTO packages VALUES(78,3,'e2fsprogs');
INSERT INTO packages VALUES(79,3,'filesystem');
INSERT INTO packages VALUES(80,3,'findutils');
INSERT INTO packages VALUES(81,3,'gawk');
INSERT INTO packages VALUES(82,3,'cracklib-dicts');
INSERT INTO packages VALUES(83,3,'glibc');
INSERT INTO packages VALUES(84,3,'glibc-common');
INSERT INTO packages VALUES(85,3,'initscripts');
INSERT INTO packages VALUES(86,3,'iproute');
INSERT INTO packages VALUES(87,3,'iputils');
INSERT INTO packages VALUES(88,3,'krb5-libs');
INSERT INTO packages VALUES(89,3,'libacl');
INSERT INTO packages VALUES(90,3,'libattr');
INSERT INTO packages VALUES(91,3,'libgcc');
INSERT INTO packages VALUES(92,3,'libstdc++');
INSERT INTO packages VALUES(93,3,'libtermcap');
INSERT INTO packages VALUES(94,3,'mingetty');
INSERT INTO packages VALUES(95,3,'mktemp');
INSERT INTO packages VALUES(96,3,'ncurses');
INSERT INTO packages VALUES(97,3,'net-tools');
INSERT INTO packages VALUES(98,3,'nfs-utils');
INSERT INTO packages VALUES(99,3,'pam');
INSERT INTO packages VALUES(100,3,'pcre');
INSERT INTO packages VALUES(101,3,'popt');
INSERT INTO packages VALUES(102,3,'portmap');
INSERT INTO packages VALUES(103,3,'procps');
INSERT INTO packages VALUES(104,3,'psmisc');
INSERT INTO packages VALUES(105,3,'rdate');
INSERT INTO packages VALUES(106,3,'rsh');
INSERT INTO packages VALUES(107,3,'rsh-server');
INSERT INTO packages VALUES(108,3,'rsync');
INSERT INTO packages VALUES(109,3,'sed');
INSERT INTO packages VALUES(110,3,'setup');
INSERT INTO packages VALUES(111,3,'shadow-utils');
INSERT INTO packages VALUES(112,3,'openssh');
INSERT INTO packages VALUES(113,3,'openssh-server');
INSERT INTO packages VALUES(114,3,'openssh-clients');
INSERT INTO packages VALUES(115,3,'sysklogd');
INSERT INTO packages VALUES(116,3,'tcp_wrappers');
INSERT INTO packages VALUES(117,3,'termcap');
INSERT INTO packages VALUES(118,3,'tzdata');
INSERT INTO packages VALUES(119,3,'util-linux');
INSERT INTO packages VALUES(120,3,'words');
INSERT INTO packages VALUES(121,3,'xinetd');
INSERT INTO packages VALUES(122,3,'zlib');
INSERT INTO packages VALUES(123,3,'tar');
INSERT INTO packages VALUES(124,3,'mkinitrd');
INSERT INTO packages VALUES(125,3,'less');
INSERT INTO packages VALUES(126,3,'gzip');
INSERT INTO packages VALUES(127,3,'which');
INSERT INTO packages VALUES(128,3,'util-linux');
INSERT INTO packages VALUES(129,3,'module-init-tools');
INSERT INTO packages VALUES(130,3,'udev');
INSERT INTO packages VALUES(131,3,'cracklib');
INSERT INTO packages VALUES(132,3,'yum');
INSERT INTO packages VALUES(133,3,'vim-minimal');
INSERT INTO packages VALUES(134,3,'vim-common');
INSERT INTO packages VALUES(135,3,'vim-enhanced');
INSERT INTO packages VALUES(136,3,'rootfiles');
INSERT INTO packages VALUES(137,3,'autofs');
INSERT INTO packages VALUES(138,3,'ntp');
INSERT INTO packages VALUES(139,1,'kit-base');

-- Modules
INSERT INTO modules VALUES(1,4,'uhci-hcd',1);
INSERT INTO modules VALUES(2,4,'ohci-hcd',2);
INSERT INTO modules VALUES(3,4,'ehci-hcd',3);
INSERT INTO modules VALUES(4,4,'jbd',4);
INSERT INTO modules VALUES(5,4,'nfs',5);
INSERT INTO modules VALUES(6,4,'ext3',6);
INSERT INTO modules VALUES(7,4,'tg3',7);
INSERT INTO modules VALUES(8,4,'bnx2',8);
INSERT INTO modules VALUES(9,4,'e1000',9);
INSERT INTO modules VALUES(10,4,'mii',10);
INSERT INTO modules VALUES(11,4,'e100',11);
INSERT INTO modules VALUES(12,4,'lockd',12);
INSERT INTO modules VALUES(13,4,'fscache',13);
INSERT INTO modules VALUES(14,4,'nfs_acl',14);
INSERT INTO modules VALUES(15,4,'sunrpc',15);
INSERT INTO modules VALUES(16,4,'mii',16);
INSERT INTO modules VALUES(17,4,'pcnet32',17);
INSERT INTO modules VALUES(18,4,'forcedeth',18);
INSERT INTO modules VALUES(19,4,'autofs4',19);
INSERT INTO modules VALUES(20,3,'uhci_hcd',1);
INSERT INTO modules VALUES(21,3,'ohci_hcd',2);
INSERT INTO modules VALUES(22,3,'ehci_hcd',3);
INSERT INTO modules VALUES(23,3,'jbd',4);
INSERT INTO modules VALUES(24,3,'nfs',5);
INSERT INTO modules VALUES(25,3,'ext3',6);
INSERT INTO modules VALUES(26,3,'bonding',7);
INSERT INTO modules VALUES(27,3,'tg3',8);
INSERT INTO modules VALUES(28,3,'bnx2',9);
INSERT INTO modules VALUES(29,3,'e1000',10);
INSERT INTO modules VALUES(30,3,'scsi_mod',11);
INSERT INTO modules VALUES(31,3,'sd_mod',12);
INSERT INTO modules VALUES(32,3,'libata',13);
INSERT INTO modules VALUES(33,3,'ata_piix',14);
INSERT INTO modules VALUES(34,3,'sata_svw',15);
INSERT INTO modules VALUES(35,3,'sata_nv',16);
INSERT INTO modules VALUES(36,3,'ahci',17);
INSERT INTO modules VALUES(37,3,'mptbase',18);
INSERT INTO modules VALUES(38,3,'mptscsih',19);
INSERT INTO modules VALUES(39,3,'scsi_transport_sas',20);
INSERT INTO modules VALUES(40,3,'scsi_transport_fc',21);
INSERT INTO modules VALUES(41,3,'scsi_transport_spi',22);
INSERT INTO modules VALUES(42,3,'mptsas',23);
INSERT INTO modules VALUES(43,3,'mptfc',24);
INSERT INTO modules VALUES(44,3,'mptspi',25);
INSERT INTO modules VALUES(45,3,'lockd',26);
INSERT INTO modules VALUES(46,3,'fscache',27);
INSERT INTO modules VALUES(47,3,'nfs_acl',28);
INSERT INTO modules VALUES(48,3,'sunrpc',29);
INSERT INTO modules VALUES(49,3,'mii',30);
INSERT INTO modules VALUES(50,3,'e100',31);
INSERT INTO modules VALUES(51,3,'pcnet32',32);
INSERT INTO modules VALUES(52,3,'forcedeth',33);
INSERT INTO modules VALUES(53,3,'autofs4',34);

-- Partitions
-- Compute nodegroup
INSERT INTO partitions VALUES(1,2,1,1,'/boot','ext3',100,NULL,False);
INSERT INTO partitions VALUES(2,2,1,2,NULL,'linux-swap',2000,NULL,False);
INSERT INTO partitions VALUES(3,2,1,3,'/','ext3',12000,NULL,False);
INSERT INTO partitions VALUES(4,2,1,5,'/var','ext3',2000,NULL,False);
INSERT INTO partitions VALUES(5,2,1,6,'/data','ext3',14000,'fill',False);
INSERT INTO partitions VALUES(6,2,NULL,NULL,NULL,NULL,NULL,'partitionID=Dell Utility',True);
INSERT INTO partitions VALUES(7,2,NULL,NULL,NULL,NULL,NULL,'partitionID=*',False);

-- Imaged nodegroup
INSERT INTO partitions VALUES(8,3,1,1,'/boot','ext2',100,NULL,False);
INSERT INTO partitions VALUES(9,3,1,2,NULL,'linux-swap',8000,NULL,False);
INSERT INTO partitions VALUES(10,3,1,3,'/','ext3',24000,NULL,False);

-- Installer nodegroup
INSERT INTO partitions VALUES(11,1,1,1,'/boot','ext3',100,NULL,False);
INSERT INTO partitions VALUES(12,1,1,2,NULL,'linux-swap',2000,NULL,False);
INSERT INTO partitions VALUES(13,1,'N',0,NULL,'physical volume',28000,'fill;pv;vg=KusuVolGroup00',False);
INSERT INTO partitions VALUES(14,1,'KusuVolGroup00',NULL,NULL,NULL,NULL,'vg;extent=32M',False);
INSERT INTO partitions VALUES(15,1,'ROOT',NULL,'/','ext3',12000,'lv;vg=KusuVolGroup00',False);
INSERT INTO partitions VALUES(16,1,'DEPOT',NULL,'/depot','ext3',10000,'lv;vg=KusuVolGroup00',False);
INSERT INTO partitions VALUES(17,1,'VAR',NULL,'/var','ext3',2000,'lv;vg=KusuVolGroup00',False);
