From 53d17214e4e9e1e630d625a51d05484c3770fad1 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Fri, 11 Nov 2022 16:40:32 +0100
Subject: Remove user setup from initial migration

The initial migration used to add the Ceres database and user. This
works well for the production use case but is not that suitable for the
development / debugging use case where the default user of the developer
should be used.

With this commit the generic user setup is explained in the README which
can be applied to the developers Linux user aswell as a system user for
the production use case.
---
 sql/0001_migration.sql | 11 ++---------
 1 file changed, 2 insertions(+), 9 deletions(-)

(limited to 'sql/0001_migration.sql')

diff --git a/sql/0001_migration.sql b/sql/0001_migration.sql
index b04a754..9502e6c 100644
--- a/sql/0001_migration.sql
+++ b/sql/0001_migration.sql
@@ -1,18 +1,11 @@
 
 --------------------------------------------------------------------------------
 
--- This migration script adds the ceres database and user and sets
--- permissions.
-
--- Run this migration via `sudo mariadb -u root < 0001_migration.sql`. Mind
--- that you also have to create the ceres Linux user. This is possibly done
--- by the systemd *.sysusers file.
+-- This migration script adds the initial version of the Ceres database.
+-- Run this migration via `sudo mariadb -u root < 0001_migration.sql`.
 
 -- create database for ceres, add ceres user and set privileges
 CREATE DATABASE IF NOT EXISTS ceres;
-CREATE USER IF NOT EXISTS 'ceres'@'localhost' IDENTIFIED VIA unix_socket;
-GRANT ALL PRIVILEGES on ceres.* to 'ceres'@'localhost';
-FLUSH PRIVILEGES;
 
 -- select correct database for the rest of this script
 USE ceres;
-- 
cgit v1.2.3-70-g09d2

