diff options
| -rw-r--r-- | rpkid/testbed.clean.sql | 12 | ||||
| -rw-r--r-- | rpkid/testbed.setup.sql | 26 |
2 files changed, 38 insertions, 0 deletions
diff --git a/rpkid/testbed.clean.sql b/rpkid/testbed.clean.sql index 1e9b4c1b..baa5289f 100644 --- a/rpkid/testbed.clean.sql +++ b/rpkid/testbed.clean.sql @@ -41,3 +41,15 @@ DROP DATABASE IF EXISTS rpki9; DROP DATABASE IF EXISTS rpki10; DROP DATABASE IF EXISTS rpki11; DROP DATABASE IF EXISTS pubd; +DROP DATABASE IF EXISTS pubd0; +DROP DATABASE IF EXISTS pubd1; +DROP DATABASE IF EXISTS pubd2; +DROP DATABASE IF EXISTS pubd3; +DROP DATABASE IF EXISTS pubd4; +DROP DATABASE IF EXISTS pubd5; +DROP DATABASE IF EXISTS pubd6; +DROP DATABASE IF EXISTS pubd7; +DROP DATABASE IF EXISTS pubd8; +DROP DATABASE IF EXISTS pubd9; +DROP DATABASE IF EXISTS pubd10; +DROP DATABASE IF EXISTS pubd11; diff --git a/rpkid/testbed.setup.sql b/rpkid/testbed.setup.sql index a98fa0f5..c5689fa5 100644 --- a/rpkid/testbed.setup.sql +++ b/rpkid/testbed.setup.sql @@ -32,6 +32,19 @@ CREATE DATABASE rpki11; CREATE DATABASE pubd; +CREATE DATABASE pubd0; +CREATE DATABASE pubd1; +CREATE DATABASE pubd2; +CREATE DATABASE pubd3; +CREATE DATABASE pubd4; +CREATE DATABASE pubd5; +CREATE DATABASE pubd6; +CREATE DATABASE pubd7; +CREATE DATABASE pubd8; +CREATE DATABASE pubd9; +CREATE DATABASE pubd10; +CREATE DATABASE pubd11; + GRANT ALL ON irdb0.* TO irdb@localhost IDENTIFIED BY 'fnord'; GRANT ALL ON irdb1.* TO irdb@localhost IDENTIFIED BY 'fnord'; GRANT ALL ON irdb2.* TO irdb@localhost IDENTIFIED BY 'fnord'; @@ -59,3 +72,16 @@ GRANT ALL ON rpki10.* TO rpki@localhost IDENTIFIED BY 'fnord'; GRANT ALL ON rpki11.* TO rpki@localhost IDENTIFIED BY 'fnord'; GRANT ALL ON pubd.* TO pubd@localhost IDENTIFIED BY 'fnord'; + +GRANT ALL ON pubd0.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd1.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd2.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd3.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd4.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd5.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd6.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd7.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd8.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd9.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd10.* TO pubd@localhost IDENTIFIED BY 'fnord'; +GRANT ALL ON pubd11.* TO pubd@localhost IDENTIFIED BY 'fnord'; |