summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl_data.sql
diff options
context:
space:
mode:
Diffstat (limited to 'setup/poolctrl_data.sql')
-rw-r--r--setup/poolctrl_data.sql48
1 files changed, 48 insertions, 0 deletions
diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql
new file mode 100644
index 0000000..acef3a0
--- /dev/null
+++ b/setup/poolctrl_data.sql
@@ -0,0 +1,48 @@
+USE poolctrl;
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+-- Adding person test2
+INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`, `loginpassword`) VALUES
+(2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.');
+
+-- Adding person test3
+INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`, `loginpassword`) VALUES
+(3, 'Herr', 'Test 3', 'Test 3', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test3', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.');
+
+-- Adding bootiso
+INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `prebootID`, `serialnumber`, `created`, `expires`, `public`, `description`) VALUES
+(1, 'BootMedium 1', 1, 1, '1', '10-20-30-40-50', '123', '2012-03-09', 0, 'Description 1'),
+(2, 'BootMedium 2', 1, 1, '2', '11-20-30-40-50', '456', '2012-03-09', 0, 'Description 2'),
+(3, 'BootMedium 3', 1, 1, '3', '12-20-30-40-50', '789', '2012-03-09', 0, 'Description 3');
+
+-- Adding pools
+INSERT INTO `pbs_pool` (`poolID`, `title`, `description`, `location`) VALUES
+(1, 'Pool 1', 'Description 1', 'Keller'),
+(2, 'Pool 2', 'Description 2', 'EG'),
+(3, 'Pool 3', 'Description 3', '1 OG'),
+(4, '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 events
+INSERT INTO `poolctrl_event` (`title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_personID`, `pbs_bootisoID`, `note`) VALUES
+('Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', 'Vorlesung', 1, 2, 1, 'Systeme I Vorlesung'),
+('Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', 'Vorlesung', 1, 2, 1, 'Systeme II Vorlesung'),
+('Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', 'Vorlesung', 1, 2, 1, 'Systeme III Vorlesung');
+
+-- Adding eventreport
+INSERT INTO `poolctrl_eventreport` (`report`, `eventID`) VALUES
+(DEFAULT, 1),
+(DEFAULT, 2),
+('wake-on-lan failed', 3);