1 files changed, 68 insertions, 0 deletions
diff --git a/schema/mysql.schema.sql b/schema/mysql.schema.sql
new file mode 100644
index 0000000..1eb71a8
--- /dev/null
+++ b/schema/mysql.schema.sql
@@ -0,0 +1,68 @@
+# Icinga Web 2 | (c) 2014 Icinga GmbH | GPLv2+
+
+CREATE TABLE `icingaweb_group`(
+  `id`     int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `name`   varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `parent` int(10) unsigned NULL DEFAULT NULL,
+  `ctime`  timestamp NULL DEFAULT NULL,
+  `mtime`  timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `idx_name` (`name`),
+  CONSTRAINT `fk_icingaweb_group_parent_id` FOREIGN KEY (`parent`)
+    REFERENCES `icingaweb_group` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
+
+CREATE TABLE `icingaweb_group_membership`(
+  `group_id`   int(10) unsigned NOT NULL,
+  `username`   varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `ctime`      timestamp NULL DEFAULT NULL,
+  `mtime`      timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`group_id`,`username`),
+  CONSTRAINT `fk_icingaweb_group_membership_icingaweb_group` FOREIGN KEY (`group_id`)
+    REFERENCES `icingaweb_group` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
+
+CREATE TABLE `icingaweb_user`(
+  `name`          varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `active`        tinyint(1) NOT NULL,
+  `password_hash` varbinary(255) NOT NULL,
+  `ctime`         timestamp NULL DEFAULT NULL,
+  `mtime`         timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
+
+CREATE TABLE `icingaweb_user_preference`(
+  `username` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `section`  varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `name`     varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `value`    varchar(255) NOT NULL,
+  `ctime`    timestamp NULL DEFAULT NULL,
+  `mtime`    timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`username`,`section`,`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
+
+CREATE TABLE `icingaweb_rememberme`(
+  id                int(10) unsigned NOT NULL AUTO_INCREMENT,
+  username          varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
+  passphrase        varchar(256) NOT NULL,
+  random_iv         varchar(32) NOT NULL,
+  http_user_agent   text NOT NULL,
+  expires_at        timestamp NULL DEFAULT NULL,
+  ctime             timestamp NULL DEFAULT NULL,
+  mtime             timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (id)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
+
+CREATE TABLE icingaweb_schema (
+  id        int unsigned NOT NULL AUTO_INCREMENT,
+  version   varchar(64) NOT NULL,
+  timestamp bigint unsigned NOT NULL,
+  success   enum('n', 'y') DEFAULT NULL,
+  reason    text DEFAULT NULL,
+
+  PRIMARY KEY (id),
+  CONSTRAINT idx_icingaweb_schema_version UNIQUE (version)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
+
+INSERT INTO icingaweb_schema (version, timestamp, success)
+  VALUES ('2.12.0', UNIX_TIMESTAMP() * 1000, 'y');