aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-04-07 19:38:09 -0500
committermegamage <none@none>2009-04-07 19:38:09 -0500
commitf59c4debf6d413fefb7f55d422263fbb44772054 (patch)
treea65e607067e5caf81a2b10b0eaecbaa78d9cf062 /sql
parent24dede78d339f348ab67d4e7235ed12d93802b69 (diff)
[7622] Added creatureAI with related database tables. Author: AlexDereka
*Note: three tables are renamed. --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/mangos.sql101
-rw-r--r--sql/updates/7622_01_mangos_creature_ai_scripts.sql30
-rw-r--r--sql/updates/7622_02_mangos_creature_ai_summons.sql14
-rw-r--r--sql/updates/7622_03_mangos_creature_ai_texts.sql22
4 files changed, 166 insertions, 1 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql
index b752d0d76ed..83ac68521e4 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -22,7 +22,7 @@
DROP TABLE IF EXISTS `db_version`;
CREATE TABLE `db_version` (
`version` varchar(120) default NULL,
- `required_7616_02_mangos_command` bit(1) default NULL
+ `required_7622_03_mangos_creature_ai_texts` bit(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
--
@@ -920,6 +920,105 @@ LOCK TABLES `disenchant_loot_template` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `creature_ai_scripts`
+--
+
+DROP TABLE IF EXISTS `creature_ai_scripts`;
+CREATE TABLE `creature_ai_scripts` (
+ `id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT,
+ `creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier',
+ `event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type',
+ `event_inverse_phase_mask` int(11) signed NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in',
+ `event_chance` int(3) unsigned NOT NULL default '100',
+ `event_flags` int(3) unsigned NOT NULL default '0',
+ `event_param1` int(11) signed NOT NULL default '0',
+ `event_param2` int(11) signed NOT NULL default '0',
+ `event_param3` int(11) signed NOT NULL default '0',
+ `event_param4` int(11) signed NOT NULL default '0',
+ `action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action1_param1` int(11) signed NOT NULL default '0',
+ `action1_param2` int(11) signed NOT NULL default '0',
+ `action1_param3` int(11) signed NOT NULL default '0',
+ `action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action2_param1` int(11) signed NOT NULL default '0',
+ `action2_param2` int(11) signed NOT NULL default '0',
+ `action2_param3` int(11) signed NOT NULL default '0',
+ `action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action3_param1` int(11) signed NOT NULL default '0',
+ `action3_param2` int(11) signed NOT NULL default '0',
+ `action3_param3` int(11) signed NOT NULL default '0',
+ `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts';
+
+--
+-- Dumping data for table `creature_ai_scripts`
+--
+
+LOCK TABLES `creature_ai_scripts` WRITE;
+/*!40000 ALTER TABLE `creature_ai_scripts` DISABLE KEYS */;
+/*!40000 ALTER TABLE `creature_ai_scripts` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `creature_ai_summons`
+--
+
+DROP TABLE IF EXISTS `creature_ai_summons`;
+CREATE TABLE `creature_ai_summons` (
+ `id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
+ `position_x` float NOT NULL default '0',
+ `position_y` float NOT NULL default '0',
+ `position_z` float NOT NULL default '0',
+ `orientation` float NOT NULL default '0',
+ `spawntimesecs` int(11) unsigned NOT NULL default '120',
+ `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations';
+
+--
+-- Dumping data for table `creature_ai_summons`
+--
+
+LOCK TABLES `creature_ai_summons` WRITE;
+/*!40000 ALTER TABLE `creature_ai_summons` DISABLE KEYS */;
+/*!40000 ALTER TABLE `creature_ai_summons` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `creature_ai_texts`
+--
+
+DROP TABLE IF EXISTS `creature_ai_texts`;
+CREATE TABLE `creature_ai_texts` (
+ `entry` mediumint(8) NOT NULL,
+ `content_default` text NOT NULL,
+ `content_loc1` text,
+ `content_loc2` text,
+ `content_loc3` text,
+ `content_loc4` text,
+ `content_loc5` text,
+ `content_loc6` text,
+ `content_loc7` text,
+ `content_loc8` text,
+ `sound` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `language` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `emote` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `comment` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
+
+--
+-- Dumping data for table `creature_ai_texts`
+--
+
+LOCK TABLES `creature_ai_texts` WRITE;
+/*!40000 ALTER TABLE `creature_ai_texts` DISABLE KEYS */;
+/*!40000 ALTER TABLE `creature_ai_texts` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `event_scripts`
--
diff --git a/sql/updates/7622_01_mangos_creature_ai_scripts.sql b/sql/updates/7622_01_mangos_creature_ai_scripts.sql
new file mode 100644
index 00000000000..6050a8e0232
--- /dev/null
+++ b/sql/updates/7622_01_mangos_creature_ai_scripts.sql
@@ -0,0 +1,30 @@
+ALTER TABLE db_version CHANGE COLUMN required_7616_02_mangos_command required_7622_01_mangos_creature_ai_scripts bit;
+
+
+DROP TABLE IF EXISTS `creature_ai_scripts`;
+CREATE TABLE `creature_ai_scripts` (
+ `id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT,
+ `creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier',
+ `event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type',
+ `event_inverse_phase_mask` int(11) signed NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in',
+ `event_chance` int(3) unsigned NOT NULL default '100',
+ `event_flags` int(3) unsigned NOT NULL default '0',
+ `event_param1` int(11) signed NOT NULL default '0',
+ `event_param2` int(11) signed NOT NULL default '0',
+ `event_param3` int(11) signed NOT NULL default '0',
+ `event_param4` int(11) signed NOT NULL default '0',
+ `action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action1_param1` int(11) signed NOT NULL default '0',
+ `action1_param2` int(11) signed NOT NULL default '0',
+ `action1_param3` int(11) signed NOT NULL default '0',
+ `action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action2_param1` int(11) signed NOT NULL default '0',
+ `action2_param2` int(11) signed NOT NULL default '0',
+ `action2_param3` int(11) signed NOT NULL default '0',
+ `action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action3_param1` int(11) signed NOT NULL default '0',
+ `action3_param2` int(11) signed NOT NULL default '0',
+ `action3_param3` int(11) signed NOT NULL default '0',
+ `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts'; \ No newline at end of file
diff --git a/sql/updates/7622_02_mangos_creature_ai_summons.sql b/sql/updates/7622_02_mangos_creature_ai_summons.sql
new file mode 100644
index 00000000000..a46d933df91
--- /dev/null
+++ b/sql/updates/7622_02_mangos_creature_ai_summons.sql
@@ -0,0 +1,14 @@
+ALTER TABLE db_version CHANGE COLUMN required_7622_01_mangos_creature_ai_scripts required_7622_02_mangos_creature_ai_summons bit;
+
+
+DROP TABLE IF EXISTS `creature_ai_summons`;
+CREATE TABLE `creature_ai_summons` (
+ `id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
+ `position_x` float NOT NULL default '0',
+ `position_y` float NOT NULL default '0',
+ `position_z` float NOT NULL default '0',
+ `orientation` float NOT NULL default '0',
+ `spawntimesecs` int(11) unsigned NOT NULL default '120',
+ `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations'; \ No newline at end of file
diff --git a/sql/updates/7622_03_mangos_creature_ai_texts.sql b/sql/updates/7622_03_mangos_creature_ai_texts.sql
new file mode 100644
index 00000000000..d8cb6ccbeeb
--- /dev/null
+++ b/sql/updates/7622_03_mangos_creature_ai_texts.sql
@@ -0,0 +1,22 @@
+ALTER TABLE db_version CHANGE COLUMN required_7622_02_mangos_creature_ai_summons required_7622_03_mangos_creature_ai_texts bit;
+
+
+DROP TABLE IF EXISTS `creature_ai_texts`;
+CREATE TABLE `creature_ai_texts` (
+ `entry` mediumint(8) NOT NULL,
+ `content_default` text NOT NULL,
+ `content_loc1` text,
+ `content_loc2` text,
+ `content_loc3` text,
+ `content_loc4` text,
+ `content_loc5` text,
+ `content_loc6` text,
+ `content_loc7` text,
+ `content_loc8` text,
+ `sound` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `language` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `emote` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `comment` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';