text: CREATE TABLE os_audit_ips (id INT AUTO_INCREMENT NOT NULL, ip VARCHAR(255) NOT NULL, name VARCHAR(64) DEFAULT NULL, allowed_to_clock TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_CF6F1072A5E3B32D (ip), PRIMARY KEY(id))
  CREATE TABLE os_shift (id INT AUTO_INCREMENT NOT NULL, uid INT DEFAULT NULL, puid INT DEFAULT NULL, sid INT DEFAULT NULL, spid INT DEFAULT NULL, pid INT DEFAULT NULL, status VARCHAR(255) NOT NULL, creationTime DATETIME NOT NULL, startTime DATETIME NOT NULL, endTime DATETIME NOT NULL, notes VARCHAR(255) DEFAULT NULL, INDEX IDX_2F98D1B2539B0606 (uid), INDEX IDX_2F98D1B2E6A1A094 (puid), INDEX IDX_2F98D1B257167AB4 (sid), INDEX IDX_2F98D1B2F2DFCD91 (spid), INDEX IDX_2F98D1B25550C4ED (pid), INDEX users (uid, puid), PRIMARY KEY(id))
  CREATE INDEX week ON os_archived_clock (week)
  CREATE TABLE os_archived_clock (id INT AUTO_INCREMENT NOT NULL, uid INT DEFAULT NULL, week DATETIME NOT NULL, sun VARCHAR(96) NOT NULL, mon VARCHAR(96) NOT NULL, tue VARCHAR(96) NOT NULL, wed VARCHAR(96) NOT NULL, thu VARCHAR(96) NOT NULL, fri VARCHAR(96) NOT NULL, sat VARCHAR(96) NOT NULL, INDEX IDX_E2AE7B56539B0606 (uid), PRIMARY KEY(id))
  CREATE TABLE os_audit_late (id INT AUTO_INCREMENT NOT NULL, uid INT DEFAULT NULL, sid INT DEFAULT NULL, spid INT DEFAULT NULL, pid INT DEFAULT NULL, status VARCHAR(255) NOT NULL, arrivalTime DATETIME DEFAULT NULL, creationTime DATETIME NOT NULL, notes VARCHAR(255) DEFAULT NULL, INDEX IDX_3465AAE8539B0606 (uid), INDEX IDX_3465AAE857167AB4 (sid), INDEX IDX_3465AAE8F2DFCD91 (spid), INDEX IDX_3465AAE85550C4ED (pid), INDEX lateShiftCreated (creationTime), PRIMARY KEY(id))
  CREATE TABLE os_settings (id INT AUTO_INCREMENT NOT NULL, brandName VARCHAR(64) NOT NULL, pruneAfter INT NOT NULL, weekStartDay VARCHAR(9) NOT NULL, weekStartDayClock VARCHAR(9) NOT NULL, defaultTimeResolution VARCHAR(255) NOT NULL, startHour VARCHAR(255) NOT NULL, endHour VARCHAR(255) NOT NULL, PRIMARY KEY(id))
  