sql/0001_migration.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18


--------------------------------------------------------------------------------

-- 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');