From 9ff821d8bb2ee4e3f43c43e3badbeb40e000d503 Mon Sep 17 00:00:00 2001
From: Brian <runningnak3d@gmail.com>
Date: Thu, 22 Jul 2010 14:37:32 -0600
Subject: * Add the ability to set player orientation for new characters. *
 Requires DB data to actully do anything, however not needed for working *
 server * Original patch by Vladimir

--HG--
branch : trunk
---
 sql/base/world_database.sql                 | 1 +
 sql/updates/8987_world_playercreateinfo.sql | 3 +++
 2 files changed, 4 insertions(+)
 create mode 100644 sql/updates/8987_world_playercreateinfo.sql

(limited to 'sql')

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`;
-- 
cgit v1.2.3