diff options
| -rw-r--r-- | sql/updates/world/2012_01_29_00_world_conditions.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2012_01_30_00_world_conditions.sql | 3 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/updates/world/2012_01_29_00_world_conditions.sql b/sql/updates/world/2012_01_29_00_world_conditions.sql index 8e8c5b4734d..8a04993a03e 100644 --- a/sql/updates/world/2012_01_29_00_world_conditions.sql +++ b/sql/updates/world/2012_01_29_00_world_conditions.sql @@ -1 +1 @@ -ALTER TABLE conditions ADD COLUMN `SourceId` INT(10) NOT NULL AFTER SourceEntry; +ALTER TABLE `conditions` ADD COLUMN `SourceId` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER SourceEntry; diff --git a/sql/updates/world/2012_01_30_00_world_conditions.sql b/sql/updates/world/2012_01_30_00_world_conditions.sql new file mode 100644 index 00000000000..48b9c63b5cb --- /dev/null +++ b/sql/updates/world/2012_01_30_00_world_conditions.sql @@ -0,0 +1,3 @@ +ALTER TABLE `conditions` CHANGE `SourceId` `SourceId` INT(10) NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` DROP PRIMARY KEY, + ADD PRIMARY KEY (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`); |