From 1d6b45bebea66391a2a535a3bb328a5732aaa75d Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Sat, 5 Nov 2022 21:25:31 +0100
Subject: Add existing work

---
 sql/0001_migration.sql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 sql/0001_migration.sql

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

diff --git a/sql/0001_migration.sql b/sql/0001_migration.sql
new file mode 100644
index 0000000..b04a754
--- /dev/null
+++ b/sql/0001_migration.sql
@@ -0,0 +1,25 @@
+
+--------------------------------------------------------------------------------
+
+-- 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.
+
+-- 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;
+
+-- create meta table and set database schema version
+CREATE TABLE IF NOT EXISTS meta (
+	identifier varchar(80) PRIMARY KEY NOT NULL UNIQUE,
+	value varchar(80) NOT NULL
+);
+INSERT INTO meta (identifier,value) VALUES ('version', '1');
-- 
cgit v1.2.3-70-g09d2

