aboutsummaryrefslogtreecommitdiff
path: root/sql/world_scripts_structure.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/world_scripts_structure.sql')
-rw-r--r--sql/world_scripts_structure.sql202
1 files changed, 101 insertions, 101 deletions
diff --git a/sql/world_scripts_structure.sql b/sql/world_scripts_structure.sql
index eb305d2e40d..dff8a54a806 100644
--- a/sql/world_scripts_structure.sql
+++ b/sql/world_scripts_structure.sql
@@ -1,101 +1,101 @@
-DROP TABLE IF EXISTS `custom_texts`;
-CREATE TABLE `custom_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 unsigned NOT NULL default '0',
- `language` tinyint unsigned NOT NULL default '0',
- `comment` text,
- PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts';
-
-DROP TABLE IF EXISTS `eventai_scripts`;
-CREATE TABLE `eventai_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';
-
-DROP TABLE IF EXISTS `eventai_summons`;
-CREATE TABLE `eventai_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';
-
-DROP TABLE IF EXISTS `eventai_texts`;
-CREATE TABLE `eventai_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 unsigned NOT NULL default '0',
- `language` tinyint unsigned NOT NULL default '0',
- `comment` text,
- PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
-
-DROP TABLE IF EXISTS `script_texts`;
-CREATE TABLE `script_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 unsigned NOT NULL default '0',
- `language` tinyint unsigned NOT NULL default '0',
- `comment` text,
- PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
-
-DROP TABLE IF EXISTS `script_db_version`;
-CREATE TABLE `script_db_version` (
- `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS `custom_texts`;
+CREATE TABLE `custom_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 unsigned NOT NULL default '0',
+ `language` tinyint unsigned NOT NULL default '0',
+ `comment` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts';
+
+DROP TABLE IF EXISTS `eventai_scripts`;
+CREATE TABLE `eventai_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';
+
+DROP TABLE IF EXISTS `eventai_summons`;
+CREATE TABLE `eventai_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';
+
+DROP TABLE IF EXISTS `eventai_texts`;
+CREATE TABLE `eventai_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 unsigned NOT NULL default '0',
+ `language` tinyint unsigned NOT NULL default '0',
+ `comment` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
+
+DROP TABLE IF EXISTS `script_texts`;
+CREATE TABLE `script_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 unsigned NOT NULL default '0',
+ `language` tinyint unsigned NOT NULL default '0',
+ `comment` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
+
+DROP TABLE IF EXISTS `script_db_version`;
+CREATE TABLE `script_db_version` (
+ `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;