summaryrefslogtreecommitdiffstats
path: root/pbs-data.sql
diff options
context:
space:
mode:
Diffstat (limited to 'pbs-data.sql')
-rw-r--r--pbs-data.sql18
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);