aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql1
-rw-r--r--sql/updates/8987_world_playercreateinfo.sql3
2 files changed, 4 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 2de8257a254..e1d04928993 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -4018,6 +4018,7 @@ CREATE TABLE `playercreateinfo` (
`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',
PRIMARY KEY (`race`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/8987_world_playercreateinfo.sql b/sql/updates/8987_world_playercreateinfo.sql
new file mode 100644
index 00000000000..040ec9cc2fd
--- /dev/null
+++ b/sql/updates/8987_world_playercreateinfo.sql
@@ -0,0 +1,3 @@
+
+ALTER TABLE `playercreateinfo`
+ ADD COLUMN `orientation` float NOT NULL DEFAULT 0 AFTER `position_z`;