diff options
| author | Simon | 2011-03-08 12:24:53 +0100 |
|---|---|---|
| committer | Simon | 2011-03-08 12:24:53 +0100 |
| commit | e14ee57716302f516720c6291eb14eca039d06e9 (patch) | |
| tree | 71a1b5cbf9922b0b7af2c573cda1c9c56c4f9b3b /pbs-data.sql | |
| parent | bootisoID in session eingefügt (diff) | |
| download | pbs2-e14ee57716302f516720c6291eb14eca039d06e9.tar.gz pbs2-e14ee57716302f516720c6291eb14eca039d06e9.tar.xz pbs2-e14ee57716302f516720c6291eb14eca039d06e9.zip | |
pbs-data um beispeildaten ergänzt
Diffstat (limited to 'pbs-data.sql')
| -rw-r--r-- | pbs-data.sql | 18 |
1 files changed, 16 insertions, 2 deletions
diff --git a/pbs-data.sql b/pbs-data.sql index 0549e0b..ec7dd03 100644 --- a/pbs-data.sql +++ b/pbs-data.sql @@ -46,6 +46,20 @@ INSERT INTO `pbs_client` (`clientID`, `macadress`, `hardwarehash`) VALUES (10, '84:34:26:9a:92:90', 'a3562c8cad2a4fa4fc11656025dc911b'); INSERT INTO `pbs`.`pbs_pool` (`poolID`, `title`, `description`, `location`) VALUES -(NULL, 'Pool 1', 'Description 1', 'Keller'), -(NULL, 'Pool 2', 'Description 2', 'Keller'); +(1, 'Pool 1', 'Description 1', 'Keller'), +(2, 'Pool 2', 'Description 2', 'Keller'), +(3, 'Pool 3', 'description 3', 'Keller'); + + +INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES +(1, 1, 1), +(2, 1, 2), +(3, 1, 3), +(4, 1, 4), +(5, 1, 5), +(6, 2, 6), +(7, 2, 7), +(8, 2, 8), +(9, 3, 9), +(10, 3, 10); |