diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/5360_8409_characters_guild.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/5360_8409_characters_guild.sql b/sql/updates/5360_8409_characters_guild.sql new file mode 100644 index 00000000000..db517e723b6 --- /dev/null +++ b/sql/updates/5360_8409_characters_guild.sql @@ -0,0 +1,17 @@ +-- ALTER TABLE character_db_version CHANGE COLUMN required_8402_02_characters_guild_bank_eventlog required_8409_01_characters_guild bit; + + +-- Change createdate column type from datetime to bigint(20) + +-- add temporary column +ALTER TABLE guild ADD COLUMN created_temp bigint(20) default '0'; +-- update temporary columns data +UPDATE guild SET created_temp = UNIX_TIMESTAMP(createdate); +-- drop current column +ALTER TABLE guild DROP COLUMN createdate; +-- create new column with correct type +ALTER TABLE guild ADD COLUMN createdate bigint(20) NOT NULL default '0' AFTER motd; +-- copy data to new column +UPDATE guild set createdate = created_temp; +-- remove old column +ALTER TABLE guild DROP COLUMN created_temp;
\ No newline at end of file |