diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 38 | ||||
| -rw-r--r-- | sql/updates/characters/yyyy_mm_dd_xx_characters.sql | 20 |
2 files changed, 39 insertions, 19 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 2f3490c4689..6981e227ab6 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -271,16 +271,16 @@ DROP TABLE IF EXISTS `calendar_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calendar_events` ( - `id` bigint(20) unsigned NOT NULL DEFAULT '0', - `creator` bigint(20) unsigned NOT NULL DEFAULT '0', - `title` varchar(255) NOT NULL DEFAULT '', - `description` varchar(255) NOT NULL DEFAULT '', - `type` tinyint(1) unsigned NOT NULL DEFAULT '4', - `dungeon` int(10) NOT NULL DEFAULT '-1', - `eventtime` int(10) unsigned NOT NULL DEFAULT '0', - `flags` int(10) unsigned NOT NULL DEFAULT '0', - `time2` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`id`) + `EventID` bigint(20) unsigned NOT NULL DEFAULT '0', + `Owner` bigint(20) unsigned NOT NULL DEFAULT '0', + `Title` varchar(255) NOT NULL DEFAULT '', + `Description` varchar(255) NOT NULL DEFAULT '', + `EventType` tinyint(1) unsigned NOT NULL DEFAULT '4', + `TextureID` int(10) NOT NULL DEFAULT '-1', + `Date` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `LockDate` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`EventID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -301,15 +301,15 @@ DROP TABLE IF EXISTS `calendar_invites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calendar_invites` ( - `id` bigint(20) unsigned NOT NULL DEFAULT '0', - `event` bigint(20) unsigned NOT NULL DEFAULT '0', - `invitee` bigint(20) unsigned NOT NULL DEFAULT '0', - `sender` bigint(20) unsigned NOT NULL DEFAULT '0', - `status` tinyint(1) unsigned NOT NULL DEFAULT '0', - `statustime` int(10) unsigned NOT NULL DEFAULT '0', - `rank` tinyint(1) unsigned NOT NULL DEFAULT '0', - `text` varchar(255) NOT NULL DEFAULT '', - PRIMARY KEY (`id`) + `InviteID` bigint(20) unsigned NOT NULL DEFAULT '0', + `EventID` bigint(20) unsigned NOT NULL DEFAULT '0', + `Invitee` bigint(20) unsigned NOT NULL DEFAULT '0', + `Sender` bigint(20) unsigned NOT NULL DEFAULT '0', + `Status` tinyint(1) unsigned NOT NULL DEFAULT '0', + `ResponseTime` int(10) unsigned NOT NULL DEFAULT '0', + `ModerationRank` tinyint(1) unsigned NOT NULL DEFAULT '0', + `Note` varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (`InviteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/characters/yyyy_mm_dd_xx_characters.sql b/sql/updates/characters/yyyy_mm_dd_xx_characters.sql new file mode 100644 index 00000000000..d2a607a9fa6 --- /dev/null +++ b/sql/updates/characters/yyyy_mm_dd_xx_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`; |