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/0002_migration.sql | 25 -------------------------
 1 file changed, 25 deletions(-)
 delete mode 100644 sql/0002_migration.sql

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

diff --git a/sql/0002_migration.sql b/sql/0002_migration.sql
deleted file mode 100644
index 7c99616..0000000
--- a/sql/0002_migration.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-
---------------------------------------------------------------------------------
-
--- This migration creates the initial version of the database layout.
-
--- Run this command as Linux user `ceres` with this command:
--- `mariadb < 0002_migration.sql`.
-
--- set database for this script
-USE ceres;
-
--- create recipe table
-CREATE TABLE IF NOT EXISTS recipes (
-	id INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
-	title varchar(80) NOT NULL DEFAULT '(no title)',
-	upstream_url varchar(200) NOT NULL DEFAULT '',
-	description_markdown text NOT NULL DEFAULT ''
-);
-
--- update database schema version
-UPDATE meta
-SET
-	value='2'
-WHERE
-	identifier='version';
-- 
cgit v1.2.3-70-g09d2

