Show
Ignore:
Timestamp:
11/19/08 13:36:49 (17 years ago)
Author:
yumileroy
Message:

[svn] Update trinityscript to SD2 rev 700. Source: scriptdev2. Patch provided by SLG.

Original author: megamage
Date: 2008-10-25 11:40:10-05:00

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/src/bindings/scripts/sql/scripts_structure.sql

    r47 r109  
     1DROP TABLE IF EXISTS `custom_texts`; 
     2CREATE TABLE `custom_texts` ( 
     3  `entry` mediumint(8) NOT NULL, 
     4  `content_default` text NOT NULL, 
     5  `content_loc1` text, 
     6  `content_loc2` text, 
     7  `content_loc3` text, 
     8  `content_loc4` text, 
     9  `content_loc5` text, 
     10  `content_loc6` text, 
     11  `content_loc7` text, 
     12  `content_loc8` text, 
     13  `sound` mediumint(8) unsigned NOT NULL default '0', 
     14  `type` tinyint unsigned NOT NULL default '0', 
     15  `language` tinyint unsigned NOT NULL default '0', 
     16  `comment` text, 
     17  PRIMARY KEY (`entry`) 
     18) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts'; 
     19 
    120DROP TABLE IF EXISTS `eventai_scripts`; 
    221CREATE TABLE `eventai_scripts` ( 
    3 `id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT, 
    4 `creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier', 
     22  `id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT, 
     23  `creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier', 
     24  `event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type', 
     25  `event_inverse_phase_mask` int(11) signed NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in', 
     26  `event_chance` int(3) unsigned NOT NULL default '100', 
     27  `event_flags` int(3) unsigned NOT NULL default '0', 
     28  `event_param1` int(11) signed NOT NULL default '0', 
     29  `event_param2` int(11) signed NOT NULL default '0', 
     30  `event_param3` int(11) signed NOT NULL default '0', 
     31  `event_param4` int(11) signed NOT NULL default '0', 
     32  `action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', 
     33  `action1_param1` int(11) signed NOT NULL default '0', 
     34  `action1_param2` int(11) signed NOT NULL default '0', 
     35  `action1_param3` int(11) signed NOT NULL default '0', 
     36  `action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', 
     37  `action2_param1` int(11) signed NOT NULL default '0', 
     38  `action2_param2` int(11) signed NOT NULL default '0', 
     39  `action2_param3` int(11) signed NOT NULL default '0', 
     40  `action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', 
     41  `action3_param1` int(11) signed NOT NULL default '0', 
     42  `action3_param2` int(11) signed NOT NULL default '0', 
     43  `action3_param3` int(11) signed NOT NULL default '0', 
     44  `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment', 
     45  PRIMARY KEY (`id`) 
     46) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts'; 
    547 
    6 `event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type', 
    7 `event_inverse_phase_mask` int(11) signed NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in', 
    8 `event_chance` int(3) unsigned NOT NULL default '100', 
    9 `event_flags` int(3) unsigned NOT NULL default '0', 
    10 `event_param1` int(11) signed NOT NULL default '0', 
    11 `event_param2` int(11) signed NOT NULL default '0', 
    12 `event_param3` int(11) signed NOT NULL default '0', 
    13 `event_param4` int(11) signed NOT NULL default '0', 
    14  
    15 `action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', 
    16 `action1_param1` int(11) signed NOT NULL default '0', 
    17 `action1_param2` int(11) signed NOT NULL default '0', 
    18 `action1_param3` int(11) signed NOT NULL default '0', 
    19  
    20 `action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', 
    21 `action2_param1` int(11) signed NOT NULL default '0', 
    22 `action2_param2` int(11) signed NOT NULL default '0', 
    23 `action2_param3` int(11) signed NOT NULL default '0', 
    24  
    25 `action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', 
    26 `action3_param1` int(11) signed NOT NULL default '0', 
    27 `action3_param2` int(11) signed NOT NULL default '0', 
    28 `action3_param3` int(11) signed NOT NULL default '0', 
    29  
    30 `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment', 
    31  
    32   PRIMARY KEY  (`id`) 
    33 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts'; 
     48DROP TABLE IF EXISTS `eventai_summons`; 
     49CREATE TABLE `eventai_summons` ( 
     50  `id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT, 
     51  `position_x` float NOT NULL default '0', 
     52  `position_y` float NOT NULL default '0', 
     53  `position_z` float NOT NULL default '0', 
     54  `orientation` float NOT NULL default '0', 
     55  `spawntimesecs` int(11) unsigned NOT NULL default '120', 
     56  `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment', 
     57  PRIMARY KEY (`id`) 
     58) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations'; 
    3459 
    3560DROP TABLE IF EXISTS `eventai_texts`; 
    3661CREATE TABLE `eventai_texts` ( 
    37  
    38 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier', 
    39 `text` varchar(255) character set utf8 NOT NULL default '',   
    40 `comment` varchar(255) character set utf8 NOT NULL default '' COMMENT 'Text Comment', 
    41  
    42 PRIMARY KEY (`id`) 
    43 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Texts used in EventAI'; 
    44  
    45 DROP TABLE IF EXISTS `eventai_localized_texts`; 
    46 CREATE TABLE `eventai_localized_texts` ( 
    47  
    48 `id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT, 
    49 `locale_1` varchar(255) NOT NULL default '', 
    50 `locale_2` varchar(255) NOT NULL default '', 
    51 `locale_3` varchar(255) NOT NULL default '', 
    52 `locale_4` varchar(255) NOT NULL default '', 
    53 `locale_5` varchar(255) NOT NULL default '', 
    54 `locale_6` varchar(255) NOT NULL default '', 
    55 `locale_7` varchar(255) NOT NULL default '', 
    56 `locale_8` varchar(255) NOT NULL default '', 
    57 `comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment', 
    58  
    59 PRIMARY KEY  (`id`) 
    60 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Localized Text'; 
    61  
    62 DROP TABLE IF EXISTS `eventai_summons`; 
    63 CREATE TABLE `eventai_summons` ( 
    64 `id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT, 
    65 `position_x` float NOT NULL default '0', 
    66 `position_y` float NOT NULL default '0', 
    67 `position_z` float NOT NULL default '0', 
    68 `orientation` float NOT NULL default '0', 
    69 `spawntimesecs` int(11) unsigned NOT NULL default '120', 
    70 `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment', 
    71 PRIMARY KEY (`id`) 
    72 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations'; 
     62  `entry` mediumint(8) NOT NULL, 
     63  `content_default` text NOT NULL, 
     64  `content_loc1` text, 
     65  `content_loc2` text, 
     66  `content_loc3` text, 
     67  `content_loc4` text, 
     68  `content_loc5` text, 
     69  `content_loc6` text, 
     70  `content_loc7` text, 
     71  `content_loc8` text, 
     72  `sound` mediumint(8) unsigned NOT NULL default '0', 
     73  `type` tinyint unsigned NOT NULL default '0', 
     74  `language` tinyint unsigned NOT NULL default '0', 
     75  `comment` text, 
     76  PRIMARY KEY (`entry`) 
     77) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; 
    7378 
    7479DROP TABLE IF EXISTS `script_texts`; 
    … …  
    9196) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; 
    9297 
    93 DROP TABLE IF EXISTS `custom_texts`; 
    94 CREATE TABLE `custom_texts` ( 
    95   `entry` mediumint(8) NOT NULL, 
    96   `content_default` text NOT NULL, 
    97   `content_loc1` text, 
    98   `content_loc2` text, 
    99   `content_loc3` text, 
    100   `content_loc4` text, 
    101   `content_loc5` text, 
    102   `content_loc6` text, 
    103   `content_loc7` text, 
    104   `content_loc8` text, 
    105   `sound` mediumint(8) unsigned NOT NULL default '0', 
    106   `type` tinyint unsigned NOT NULL default '0', 
    107   `language` tinyint unsigned NOT NULL default '0', 
    108   `comment` text, 
    109   PRIMARY KEY  (`entry`) 
    110 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts'; 
    111  
    11298DROP TABLE IF EXISTS `script_db_version`; 
    11399CREATE TABLE `script_db_version` ( 
    114 `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string' 
     100  `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string' 
    115101) ENGINE=MyISAM DEFAULT CHARSET=utf8;