diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/0001_migration.sql | 11 |
1 files changed, 2 insertions, 9 deletions
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; |