mirror of
https://github.com/ProjectSkyfire/SkyFire_548
synced 2026-08-18 06:32:13 -04:00
21 lines
749 B
SQL
21 lines
749 B
SQL
DROP TABLE IF EXISTS `script_texts`;
|
|
CREATE TABLE `script_texts` (
|
|
`npc_entry` mediumint(8) NOT NULL default '0' COMMENT 'creature_template entry',
|
|
`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` smallint(5) unsigned NOT NULL default '0',
|
|
`comment` text,
|
|
PRIMARY KEY (`npc_entry`,`entry`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
|
|
|