<commit_before>-- ----------------------------
-- Table structure for `creature_ai_scripts`
-- ----------------------------
DROP TABLE IF EXISTS `creature_ai_scripts`;
CREATE TABLE `creature_ai_scripts` (
  `entry` int unsigned NOT NULL,
  `difficulty` tinyint unsigned NOT NULL DEFAULT '0',
  `phase` tinyint unsigned NOT NULL DEFAULT '0',
  `event` tinyint unsigned NOT NULL DEFAULT '0',
  `action` tinyint unsigned NOT NULL DEFAULT '0',
  `maxCount` tinyint unsigned NOT NULL DEFAULT '0',
  `chance` float unsigned NOT NULL DEFAULT '1',
  `spell` int unsigned NOT NULL DEFAULT '0',
  `spell_type` int NOT NULL,
  `triggered` tinyint(1) NOT NULL DEFAULT '0',
  `target` tinyint NOT NULL DEFAULT '0',
  `cooldownMin` int NOT NULL DEFAULT '0',
  `cooldownMax` int unsigned NOT NULL DEFAULT '0',
  `minHealth` float NOT NULL DEFAULT '0',
  `maxHealth` float NOT NULL DEFAULT '100',
  `textId` int unsigned NOT NULL DEFAULT '0',
  `misc1` int NOT NULL DEFAULT '0',
  `comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_build` int NOT NULL DEFAULT '12340',
  `max_build` int NOT NULL DEFAULT '12340',
  UNIQUE KEY `entry` (`entry`,`difficulty`,`phase`,`spell`,`event`,`action`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI System';

REPLACE INTO `world_db_version` VALUES ('85', '20210814-01_creature_ai_scripts');
<commit_msg>Fix multibuild logic. min/max_nuild has to be part of the unique key.<commit_after>-- ----------------------------
-- Table structure for `creature_ai_scripts`
-- ----------------------------
DROP TABLE IF EXISTS `creature_ai_scripts`;
CREATE TABLE `creature_ai_scripts` (
  `min_build` int NOT NULL DEFAULT '12340',
  `max_build` int NOT NULL DEFAULT '12340',
  `entry` int unsigned NOT NULL,
  `difficulty` tinyint unsigned NOT NULL DEFAULT '0',
  `phase` tinyint unsigned NOT NULL DEFAULT '0',
  `event` tinyint unsigned NOT NULL DEFAULT '0',
  `action` tinyint unsigned NOT NULL DEFAULT '0',
  `maxCount` tinyint unsigned NOT NULL DEFAULT '0',
  `chance` float unsigned NOT NULL DEFAULT '1',
  `spell` int unsigned NOT NULL DEFAULT '0',
  `spell_type` int NOT NULL DEFAULT '0',
  `triggered` tinyint(1) NOT NULL DEFAULT '0',
  `target` tinyint NOT NULL DEFAULT '0',
  `cooldownMin` int NOT NULL DEFAULT '0',
  `cooldownMax` int unsigned NOT NULL DEFAULT '0',
  `minHealth` float NOT NULL DEFAULT '0',
  `maxHealth` float NOT NULL DEFAULT '100',
  `textId` int unsigned NOT NULL DEFAULT '0',
  `misc1` int NOT NULL DEFAULT '0',
  `comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `entry` (`min_build`,`max_build`,`entry`,`difficulty`,`phase`,`spell`,`event`,`action`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI System';

REPLACE INTO `world_db_version` VALUES ('85', '20210814-01_creature_ai_scripts');

{'fraction_non_alphanumeric': 0.14880332986472425, 'fraction_numerical': 0.03433922996878252, 'mean_word_length': 4.159212880143112, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1082162', 'n_tokens_mistral': 973, 'n_tokens_neox': 912, 'n_words': 331}