From bae6e34c9119750b2cba2a2ce6d88e9f8c895900 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Sat, 1 Apr 2023 21:18:29 +0200
Subject: Switch from MariaDB to files

Using a database is way more complex (see the commit statistics of this
commit) than using files to store recipe data. Also administration and
usage is simpler.
---
 sql/0001_migration.sql | 18 ------------------
 1 file changed, 18 deletions(-)
 delete mode 100644 sql/0001_migration.sql

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

diff --git a/sql/0001_migration.sql b/sql/0001_migration.sql
deleted file mode 100644
index 9502e6c..0000000
--- a/sql/0001_migration.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-
---------------------------------------------------------------------------------
-
--- 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;
-
--- 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.3

