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(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 (`entry`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts';

DROP TABLE IF EXISTS `gossip_texts`;

CREATE TABLE `gossip_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,

`comment` text,

PRIMARY KEY (`entry`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gossip 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(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 (`entry`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';

DROP TABLE IF EXISTS script_waypoint;

CREATE TABLE script_waypoint (

entry mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry',

pointid mediumint(8) unsigned NOT NULL DEFAULT '0',

location_x float NOT NULL DEFAULT '0',

location_y float NOT NULL DEFAULT '0',

location_z float NOT NULL DEFAULT '0',

waittime int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs',

point_comment text,

PRIMARY KEY (entry, pointid)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints';

DROP TABLE IF EXISTS `sd2_db_version`;

CREATE TABLE `sd2_db_version` (

`version` varchar(255) NOT NULL default '' COMMENT 'Database version string'

) ENGINE=MyISAM DEFAULT CHARSET=utf8;