diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/505_world.sql | 32 |
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 */; |
