diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-01-30 07:26:38 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-01-30 07:26:38 +0000 |
| commit | c62a82c6740ebdd74b4e5c0f26c3b29c4f6af5c2 (patch) | |
| tree | 1f21875fa417cd1e8f67f4701df5499d3be3b08c | |
| parent | 0fbb86f2215461c04105766b0508519ec5bb4fc7 (diff) | |
SQL: Add missing "sql properties" to `conditions` field SourceId
| -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`); |