From 9b0fdbb013ecd114cfc6861a7c748770d13d0048 Mon Sep 17 00:00:00 2001 From: Sebastian Wagner Date: Fri, 7 Oct 2011 15:43:33 +0200 Subject: poolctrl db data changed --- setup/poolctrl.sql | 26 ------------------ setup/poolctrl_data.sql | 71 ++++++++++++++----------------------------------- 2 files changed, 20 insertions(+), 77 deletions(-) (limited to 'setup') diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql index 070c79d..7a3057c 100755 --- a/setup/poolctrl.sql +++ b/setup/poolctrl.sql @@ -89,29 +89,3 @@ ALTER TABLE `poolctrl_event` ADD CONSTRAINT `poolctrl_event_repeatendC` FOREIGN KEY (`repeatend`) REFERENCES `poolctrl_repeatend` (`repeatendID`) ON DELETE SET NULL, ADD CONSTRAINT `poolctrl_event_startC` CHECK (start > CURRENT_TIMESTAMP()), ADD CONSTRAINT `poolctrl_event_endC` CHECK (end > start); - --- Insert Data - --- Adding eventcategories -INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`, `color`) VALUES -(1, 'Lecture', 'green'), -(2, 'Maintenance', 'yellow'), -(3, 'Boot', 'blue'), -(4, 'Shutdown', 'red'); - --- Adding runningtypes -INSERT INTO `poolctrl_runningtype` (`runningtypeID`, `title`) VALUES -(1, 'Boot'), -(2, 'Shutdown'); - --- Adding repeattypes -INSERT INTO `poolctrl_repeattype` (`repeattypeID`, `title`) VALUES -(1, 'Daily'), -(2, 'Once a week'), -(3, 'Every couple of weeks'), -(4, 'Every month'); - --- Adding repeatend -INSERT INTO `poolctrl_repeatend` (`repeatendID`, `title`) VALUES -(1, 'After'), -(2, 'Date'); diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql index 1f02354..495a6ba 100755 --- a/setup/poolctrl_data.sql +++ b/setup/poolctrl_data.sql @@ -1,60 +1,29 @@ USE ##poolctrl##; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; --- Adding clients -INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`, `ip`, `ip6`) VALUES -(1, 1, 'a5:9a:0f:94:2a:b0', 'ea9b82d9de911bc2d3cd23f53a6cab48', '132.230.5.6', ''), -(2, 1, '91:91:f1:e2:99:aa', '1e2b1599710fbbef0dc789e8cfe12455', '', ''), -(3, 1, '6e:5c:82:78:f2:39', '8f6209ca3d6b35e223a11c249d1b69fc', '', ''), -(4, 1, '67:75:e9:f2:5f:8e', 'e17ab09f3586464f19629e2e8b1e9a9d', '84.23.56.86', ''), -(5, 1, '63:51:7e:22:aa:72', '9bf70279d283b85440c2031c19bb6812', '70.81.94.222', ''), -(6, 1, '68:9e:fe:47:95:c5', 'ad3bce4464a6267441ec144744439c7e', '210.84.65.2', ''), -(7, 1, '6e:1c:2e:01:77:33', 'e8d7e80d79f224771b7a3a0af4e02748', '', ''), -(8, 1, 'd1:91:20:43:2f:dd', 'ded66ce272f384e9e386c1b57ded3e4d', '', ''), -(9, 1, '1b:0f:a5:82:47:16', '695610ee509c060b1fca9c8011529af4', '132.230.10.2', ''), -(10, 1, '56:8e:7b:03:5f:98', 'a3562c8cad2a4fa4fc11656025dc911b', '132.20.20.2', ''), -(11, 2, 'af:54:07:87:63:44', '98413218152196816519841365419816', '', ''), -(12, 2, '87:21:74:52:96:20', '98741298132516132169813516981616', '', ''), -(13, 2, '14:47:58:47:36:48', '32168132068132068513216053516513', '', ''), -(14, 1, '64:46:85:A1:89:23', '9684216842068420616841asd6516984', '', ''); +-- Adding eventcategories +INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`, `color`) VALUES +(1, 'Lecture', 'green'), +(2, 'Maintenance', 'yellow'), +(3, 'Boot', 'blue'), +(4, 'Shutdown', 'red'); --- Adding bootos -INSERT INTO `pbs_bootos` (`bootosID`, `groupID`, `membershipID`, `title`, `description`, `defaultkcl`, `created`, `expires`, `public`, `source`, `distro`, `distroversion`, `shortname`, `share`) VALUES -(1, 1, 1, 'BootOs 1', 'Description 1', 'default kcl 1', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(2, 1, 1, 'BootOs 2', 'Description 2', 'default kcl 2', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(3, 1, 1, 'BootOs 3', 'Description 3', 'default kcl 3', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(4, 1, 1, 'BootOs 4', 'Description 4', 'default kcl 4', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(5, 1, 1, 'BootOs 5', 'Description 5', 'default kcl 5', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(6, 1, 1, 'BootOs 6', 'Description 6', 'default kcl 6', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(7, 1, 1, 'BootOs 7', 'Description 7', 'default kcl 7', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(8, 1, 1, 'BootOs 8', 'Description 8', 'default kcl 8', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(9, 1, 1, 'BootOs 9', 'Description 9', 'default kcl 9', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(10, 1, 1, 'BootOs 10', 'Description 10', 'default kcl 10', '1299693782', '2012-03-09', 0, null, null, null, null, null); +-- Adding runningtypes +INSERT INTO `poolctrl_runningtype` (`runningtypeID`, `title`) VALUES +(1, 'Boot'), +(2, 'Shutdown'); --- Adding config -INSERT INTO `pbs_config` (`configID`, `title`, `description`, `groupID`, `membershipID`, `visible`, `created`, `bootosID`) VALUES -(1, 'Default Config', 'Desc1', 1, null, '1', '1299693677', '1'), -(2, 'Config 2', 'Desc2' ,null, 1, '1', '1299693690', '1'); +-- Adding repeattypes +INSERT INTO `poolctrl_repeattype` (`repeattypeID`, `title`) VALUES +(1, 'Daily'), +(2, 'Once a week'), +(3, 'Every couple of weeks'), +(4, 'Every month'); --- Adding pools -INSERT INTO `pbs_pool` (`poolID`, `groupID`, `title`, `description`, `location`) VALUES -(1, 1, 'Pool 1', 'Description 1', 'Keller'), -(2, 1, 'Pool 2', 'Description 2', 'EG'), -(3, 1, 'Pool 3', 'Description 3', '1 OG'), -(4, 1, 'Pool 4', 'Description 4', '2 OG'); - --- Adding client to pools (poolentries) -INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES -(1, 1, 1), -(2, 1, 2), -(3, 1, 3), -(4, 1, 4), -(5, 2, 5), -(6, 2, 6), -(7, 3, 7), -(8, 3, 8), -(9, 4, 9), -(10, 4, 10); +-- Adding repeatend +INSERT INTO `poolctrl_repeatend` (`repeatendID`, `title`) VALUES +(1, 'After'), +(2, 'Date'); -- Adding events INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_membershipID`, `pbs_bootosID`, `pbs_configID`, `note`, `pbs_bootmenuID`, `pbs_filterID`, `created`) VALUES -- cgit v1.2.3-55-g7522