*Creature formations implemented.

--HG--
branch : trunk

1 files changed, 32 insertions, 0 deletions

diff --git a/sql/updates/505_world.sql b/sql/updates/505_world.sql
new file mode 100644
index 00000000000..644ee9ee5de
--- /dev/null
+++ b/sql/updates/505_world.sql
@@ -0,0 +1,32 @@
+/*
+SQLyog Community Edition- MySQL GUI v6.16
+MySQL - 5.0.27-community-nt : Database - world
+*********************************************************************
+*/

+
+/*!40101 SET NAMES utf8 */;
+
+/*!40101 SET SQL_MODE=''*/;
+
+create database if not exists `world`;
+
+USE `world`;
+
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+
+/*Table structure for table `creature_formations` */
+
+DROP TABLE IF EXISTS `creature_formations`;
+
+CREATE TABLE `creature_formations` (
+  `leader` int(11) unsigned NOT NULL,
+  `follower` int(11) unsigned NOT NULL,
+  `dist` float unsigned NOT NULL,
+  `angle` float unsigned NOT NULL,
+  `groupAI` int(11) unsigned NOT NULL,
+  PRIMARY KEY  (`follower`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;