diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2015-04-11 15:58:43 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2015-04-11 15:58:43 +0200 |
| commit | a0647a825ad7236aa30546cc8d27257cbd831c30 (patch) | |
| tree | 4fb762e36b94007148a72c9d2fdca700bf73d334 /sql | |
| parent | b2d0e7d9d51f29577682cf0d47e25d877bdfe679 (diff) | |
Core/Misc:
- Update SMSG_GOSSIP_POI for WoD
- Update points of interest locale in simple system
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_04_11_04_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2015_04_11_04_world.sql b/sql/updates/world/2015_04_11_04_world.sql new file mode 100644 index 00000000000..a9baa899ae6 --- /dev/null +++ b/sql/updates/world/2015_04_11_04_world.sql @@ -0,0 +1,13 @@ +DROP TABLE IF EXISTS `locales_points_of_interest`; + +DROP TABLE IF EXISTS `points_of_interest_locale`; +CREATE TABLE IF NOT EXISTS `points_of_interest_locale` ( + `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `locale` VARCHAR(4) NOT NULL, + `Name` TEXT, + `VerifiedBuild` SMALLINT(5) DEFAULT '0' +) ENGINE=MYISAM DEFAULT CHARSET=utf8; + +ALTER TABLE `points_of_interest_locale` + ADD PRIMARY KEY (`ID`,`locale`); +
\ No newline at end of file |