23 lines
844 B
SQL
23 lines
844 B
SQL
CREATE TABLE IF NOT EXISTS plugin_vertretung_absences (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
staff_id INTEGER NOT NULL,
|
|
substitute_id INTEGER NOT NULL,
|
|
start_date TEXT NOT NULL,
|
|
end_date TEXT NOT NULL,
|
|
note TEXT NOT NULL DEFAULT '',
|
|
status TEXT NOT NULL DEFAULT 'planned',
|
|
created_by INTEGER NULL,
|
|
created_at TEXT NOT NULL
|
|
);
|
|
CREATE INDEX IF NOT EXISTS idx_plugin_vertretung_status ON plugin_vertretung_absences (status, start_date);
|
|
CREATE TABLE IF NOT EXISTS plugin_vertretung_moves (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
absence_id INTEGER NOT NULL,
|
|
ticket_id INTEGER NOT NULL,
|
|
from_staff_id INTEGER NOT NULL,
|
|
to_staff_id INTEGER NOT NULL,
|
|
created_at TEXT NOT NULL,
|
|
returned_at TEXT NULL
|
|
);
|
|
CREATE INDEX IF NOT EXISTS idx_plugin_vertretung_moves_absence ON plugin_vertretung_moves (absence_id, returned_at)
|