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/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