-
- /**
- * Another patch for beta users
- * This changes the size of the meta_value so we can store more
- */
-
- $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "user_meta (
- meta_id int AUTO_INCREMENT NOT NULL,
- user_id int NOT NULL,
- meta_key VARCHAR(255) NOT NULL,
- meta_value VARCHAR(255),
- PRIMARY KEY (meta_id)
- )");
- $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "auth_settings (
- id int AUTO_INCREMENT NOT NULL,
- setting_key VARCHAR(255) NOT NULL,
- setting_value VARCHAR(255),
- PRIMARY KEY (id)
- )");
- $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "fail2ban (
- id int AUTO_INCREMENT NOT NULL,
- ip VARCHAR(255) NOT NULL,
- count VARCHAR(255),
- PRIMARY KEY (id)
- )");
- $c = [];
- if (($columns = $conn->query("SHOW COLUMNS FROM ".SQL_PREFIX."user_meta")));
- $c = $columns->fetchAll();
- if (!empty($c))
- $conn->query("ALTER TABLE `".SQL_PREFIX."user_meta` CHANGE `meta_value` `meta_value` VARCHAR(5000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL");
-
-
- new AuthSettings();