Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB restructuring - world - spawn_group* #1198

Closed
FrancescoBorzi opened this issue Dec 30, 2018 · 3 comments
Closed

DB restructuring - world - spawn_group* #1198

FrancescoBorzi opened this issue Dec 30, 2018 · 3 comments
Assignees

Comments

@FrancescoBorzi
Copy link
Member

FrancescoBorzi commented Dec 30, 2018

This is part of: #1118

General note: not all structure differences can or should be imported. Every change must be first verified. If a structure change is not suitable, we just close the issue.


TrinityCore/TrinityCore@59db2ee

+-- Dumping structure for table tc_world.spawn_group
+DROP TABLE IF EXISTS `spawn_group`;
+CREATE TABLE IF NOT EXISTS `spawn_group` (
+  `groupId` int(10) unsigned NOT NULL,
+  `spawnType` tinyint(10) unsigned NOT NULL,
+  `spawnId` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`groupId`,`spawnType`,`spawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.spawn_group_template
+DROP TABLE IF EXISTS `spawn_group_template`;
+CREATE TABLE IF NOT EXISTS `spawn_group_template` (
+  `groupId` int(10) unsigned NOT NULL,
+  `groupName` varchar(100) NOT NULL,
+  `groupFlags` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`groupId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@Viste
Copy link
Contributor

Viste commented Jan 6, 2019

big chanse to breake something )

@FrancescoBorzi
Copy link
Member Author

we don't have to import things that can break existing functionality, only import when it's safe

@Viste
Copy link
Contributor

Viste commented Jan 6, 2019

and also they do many fix to spawn-despawn after whis commit need find they to

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants