diff options
Diffstat (limited to 'sql/0001_migration.sql')
-rw-r--r-- | sql/0001_migration.sql | 18 |
1 files changed, 0 insertions, 18 deletions
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'); |