summaryrefslogtreecommitdiff
path: root/protected/data/create_database.mysql.sql
diff options
context:
space:
mode:
authorccwn <tzur@ccwn.org>2012-04-24 18:49:57 +0200
committerccwn <tzur@ccwn.org>2012-04-24 18:49:57 +0200
commitc98745edd2c7b2f48bc3493c4dd9a061376c4720 (patch)
treeca1b559f220ec28c3f263d02a8b832613493471f /protected/data/create_database.mysql.sql
parent314328f527e8cae759d496f528a1472d7970c137 (diff)
- Database setup
- Database schema - Database dev data - config for new database setup - Update in AngebotVerein - Update in Speis&Trank - Update in Verein - Update in Kategorie
Diffstat (limited to 'protected/data/create_database.mysql.sql')
-rw-r--r--protected/data/create_database.mysql.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/protected/data/create_database.mysql.sql b/protected/data/create_database.mysql.sql
new file mode 100644
index 0000000..38103fb
--- /dev/null
+++ b/protected/data/create_database.mysql.sql
@@ -0,0 +1,5 @@
+DROP DATABASE IF EXISTS `astaf`;
+CREATE DATABASE `astaf`;
+GRANT ALL ON `astaf`.* TO 'astaf'@'localhost' IDENTIFIED BY 'AsTaF4';
+FLUSH PRIVILEGES;
+USE `astaf`; \ No newline at end of file