diff options
| author | michael pereira | 2011-03-08 14:54:34 +0100 |
|---|---|---|
| committer | michael pereira | 2011-03-08 14:54:34 +0100 |
| commit | 2d7595cc8b8078acce88888c6800f85f927c7c2d (patch) | |
| tree | 97b74c4134c0e480a4d4ca34dbdbc0083f54d5a3 /pbs-data.sql | |
| parent | pbs.sql aktualisiert (diff) | |
| parent | application.ini entfernt (diff) | |
| download | pbs2-2d7595cc8b8078acce88888c6800f85f927c7c2d.tar.gz pbs2-2d7595cc8b8078acce88888c6800f85f927c7c2d.tar.xz pbs2-2d7595cc8b8078acce88888c6800f85f927c7c2d.zip | |
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
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); |