From bae6e34c9119750b2cba2a2ce6d88e9f8c895900 Mon Sep 17 00:00:00 2001 From: xengineering 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.2.3-70-g09d2