diff options
| -rw-r--r-- | sql/updates/characters/2015_07_28_00_characters.sql | 20 | ||||
| -rw-r--r-- | sql/updates/characters/yyyy_mm_dd_xx_characters.sql | 20 |
2 files changed, 20 insertions, 20 deletions
diff --git a/sql/updates/characters/2015_07_28_00_characters.sql b/sql/updates/characters/2015_07_28_00_characters.sql new file mode 100644 index 00000000000..29af7731d19 --- /dev/null +++ b/sql/updates/characters/2015_07_28_00_characters.sql @@ -0,0 +1,20 @@ +ALTER TABLE `calendar_invites` + CHANGE COLUMN `id` `InviteID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' FIRST, + CHANGE COLUMN `event` `EventID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `InviteID`, + CHANGE COLUMN `invitee` `Invitee` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `EventID`, + CHANGE COLUMN `sender` `Sender` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `Invitee`, + CHANGE COLUMN `status` `Status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `Sender`, + CHANGE COLUMN `statustime` `ResponseTime` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Status`, + CHANGE COLUMN `rank` `ModerationRank` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `ResponseTime`, + CHANGE COLUMN `text` `Note` VARCHAR(255) NOT NULL DEFAULT '' AFTER `ModerationRank`; + +ALTER TABLE `calendar_events` + CHANGE COLUMN `id` `EventID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' FIRST, + CHANGE COLUMN `creator` `Owner` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `EventID`, + CHANGE COLUMN `title` `Title` VARCHAR(255) NOT NULL DEFAULT '' AFTER `Owner`, + CHANGE COLUMN `description` `Description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `Title`, + CHANGE COLUMN `type` `EventType` TINYINT(1) UNSIGNED NOT NULL DEFAULT '4' AFTER `Description`, + CHANGE COLUMN `dungeon` `TextureID` INT(10) NOT NULL DEFAULT '-1' AFTER `EventType`, + CHANGE COLUMN `eventtime` `Date` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `TextureID`, + CHANGE COLUMN `flags` `Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Date`, + CHANGE COLUMN `time2` `LockDate` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Flags`; diff --git a/sql/updates/characters/yyyy_mm_dd_xx_characters.sql b/sql/updates/characters/yyyy_mm_dd_xx_characters.sql deleted file mode 100644 index d2a607a9fa6..00000000000 --- a/sql/updates/characters/yyyy_mm_dd_xx_characters.sql +++ /dev/null @@ -1,20 +0,0 @@ -ALTER TABLE `calendar_invites` - CHANGE COLUMN `id` `InviteID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' FIRST, - CHANGE COLUMN `event` `EventID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `InviteID`, - CHANGE COLUMN `invitee` `Invitee` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `EventID`, - CHANGE COLUMN `sender` `Sender` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `Invitee`, - CHANGE COLUMN `status` `Status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `Sender`, - CHANGE COLUMN `statustime` `ResponseTime` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Status`, - CHANGE COLUMN `rank` `ModerationRank` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `ResponseTime`, - CHANGE COLUMN `text` `Note` VARCHAR(255) NOT NULL DEFAULT '' AFTER `ModerationRank`; - -ALTER TABLE `calendar_events` - CHANGE COLUMN `id` `EventID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' FIRST, - CHANGE COLUMN `creator` `Owner` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `EventID`, - CHANGE COLUMN `title` `Title` VARCHAR(255) NOT NULL DEFAULT '' AFTER `Owner`, - CHANGE COLUMN `description` `Description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `Title`, - CHANGE COLUMN `type` `EventType` TINYINT(1) UNSIGNED NOT NULL DEFAULT '4' AFTER `Description`, - CHANGE COLUMN `dungeon` `TextureID` INT(10) NOT NULL DEFAULT '-1' AFTER `EventType`, - CHANGE COLUMN `eventtime` `Date` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `TextureID`, - CHANGE COLUMN `flags` `Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Date`, - CHANGE COLUMN `time2` `LockDate` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `Flags`; |