CounterSpell/witch_db.sql at main · RhamzHam/CounterSpell · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

CREATE DATABASE witch_db;

CREATE TABLE rituals_table(
    `ritual_id` INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    `ritual_name` VARCHAR(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE subtasks_table(
    `subtask_id` INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    `ritual_id` INT(6) UNSIGNED,
    `ritual_name` VARCHAR(255) NOT NULL,
    `subtask_name` VARCHAR(255) NOT NULL,
    `subtask_state` INT(6) NOT NULL,
    `subtask_priority` INT(5) NOT NULL,
    `subtask_startdate` VARCHAR(255) NOT NULL,
    `subtask_deadline` VARCHAR(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;