From c62a82c6740ebdd74b4e5c0f26c3b29c4f6af5c2 Mon Sep 17 00:00:00 2001 From: Nay Date: Mon, 30 Jan 2012 07:26:38 +0000 Subject: SQL: Add missing "sql properties" to `conditions` field SourceId --- sql/updates/world/2012_01_29_00_world_conditions.sql | 2 +- sql/updates/world/2012_01_30_00_world_conditions.sql | 3 +++ 2 files changed, 4 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2012_01_30_00_world_conditions.sql (limited to 'sql') 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`); -- cgit v1.2.3