From 79d8a778464316eb973f0238ab7d1e4078e70fb6 Mon Sep 17 00:00:00 2001 From: Paradox Date: Thu, 28 May 2009 10:15:08 -0400 Subject: Fix wrong data type for core_revision in DB, again --HG-- branch : trunk --- sql/updates/2.4.3_updates/919_world.sql | 2 +- sql/world.sql | 2 +- sql/world_scripts_structure.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'sql') diff --git a/sql/updates/2.4.3_updates/919_world.sql b/sql/updates/2.4.3_updates/919_world.sql index 4d4a6308576..90b286003e0 100644 --- a/sql/updates/2.4.3_updates/919_world.sql +++ b/sql/updates/2.4.3_updates/919_world.sql @@ -1,2 +1,2 @@ ALTER TABLE `version` - ADD `core_revision` BIGINT UNSIGNED AFTER `core_version`; \ No newline at end of file + ADD `core_revision` varchar(120) AFTER `core_version`; \ No newline at end of file diff --git a/sql/world.sql b/sql/world.sql index c466956739a..9813baf6ab4 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -13746,7 +13746,7 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `version`; CREATE TABLE `version` ( `core_version` varchar(120) default NULL COMMENT 'Core revision dumped at startup.', - `core_revision` BIGINT UNSIGNED default '0', + `core_revision` varchar(120) default '0', `db_version` varchar(120) default NULL COMMENT 'Version of world DB.', `script_version` varchar(120) default NULL COMMENT 'Version of scripts DB.' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'; diff --git a/sql/world_scripts_structure.sql b/sql/world_scripts_structure.sql index 2aff81ba6c3..0087c4e1d1b 100644 --- a/sql/world_scripts_structure.sql +++ b/sql/world_scripts_structure.sql @@ -62,7 +62,7 @@ CREATE TABLE `creature_ai_texts` ( CREATE TABLE IF NOT EXISTS `version` ( `core_version` varchar(120) default NULL COMMENT 'Core revision dumped at startup.', - `core_revision` BIGINT UNSIGNED default '0', + `core_revision` varchar(120) default '0', `db_version` varchar(120) default NULL COMMENT 'Version of world DB.', `script_version` varchar(120) default NULL COMMENT 'Version of scripts DB.' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'; \ No newline at end of file -- cgit v1.2.3