[Hejes-devel] [863] blog: added preliminary stuff for DB management

[hejes-devel at nytud.hu]

Revision: 863
Author:   mihaltz
Date:     2013-07-23 17:29:14 +0200 (Tue, 23 Jul 2013)
Log Message:
-----------
blog: added preliminary stuff for DB management

Added Paths:
-----------
    trunk/misc/dbblog/
    trunk/misc/dbblog/Makefile
    trunk/misc/dbblog/dbblog_create_database.sql
    trunk/misc/dbblog/dbblog_create_users.sql

Added: trunk/misc/dbblog/Makefile
===================================================================
--- trunk/misc/dbblog/Makefile	                        (rev 0)
+++ trunk/misc/dbblog/Makefile	2013-07-23 15:29:14 UTC (rev 863)
@@ -0,0 +1,11 @@
+.PHONY: create_db create_dbusers
+
+# create DB
+create_db:
+	mysql -u root -p < dbblog_create_database.sql
+
+# create DB users
+create_dbusers:
+	mysql -u root -p < dbblog_create_users.sql
+
+# TODO: dump_db, restore_db

Added: trunk/misc/dbblog/dbblog_create_database.sql
===================================================================
--- trunk/misc/dbblog/dbblog_create_database.sql	                        (rev 0)
+++ trunk/misc/dbblog/dbblog_create_database.sql	2013-07-23 15:29:14 UTC (rev 863)
@@ -0,0 +1 @@
+CREATE DATABASE `dbhelyesblog` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_hungarian_ci */

Added: trunk/misc/dbblog/dbblog_create_users.sql
===================================================================
--- trunk/misc/dbblog/dbblog_create_users.sql	                        (rev 0)
+++ trunk/misc/dbblog/dbblog_create_users.sql	2013-07-23 15:29:14 UTC (rev 863)
@@ -0,0 +1,4 @@
+CREATE USER 'dbblogadmin'@'localhost' IDENTIFIED BY 'd4bl0GGr';
+GRANT ALL PRIVILEGES ON `dbhelyesblog`.* TO 'dbblogadmin'@'%';
+CREATE USER 'dbblogviewer'@'localhost' IDENTIFIED BY 'dbblogger123';
+GRANT SELECT ON `dbhelyesblog`.* TO 'dbblogviewer'@'%';