aboutsummaryrefslogtreecommitdiffstats
path: root/archiva-modules/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql
diff options
context:
space:
mode:
Diffstat (limited to 'archiva-modules/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql')
-rw-r--r--archiva-modules/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/archiva-modules/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql b/archiva-modules/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql
new file mode 100644
index 000000000..9da244402
--- /dev/null
+++ b/archiva-modules/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql
@@ -0,0 +1,17 @@
+-- mysql mysql --user=root --password < dev_bootstrap.sql
+
+create database archiva character set utf8 collate utf8_general_ci;
+create database redback;
+
+use mysql;
+
+GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX
+ ON archiva.*
+ TO 'archiva'@'localhost'
+ IDENTIFIED BY 'sa';
+
+GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX
+ ON redback.*
+ TO 'archiva'@'localhost'
+ IDENTIFIED BY 'sa';
+