diff options
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 2 | ||||
| -rw-r--r-- | sql-files/upgrade_svn15003.sql | 1 |
2 files changed, 2 insertions, 1 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index feafcae3e..22ccc186f 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -164,7 +164,7 @@ CREATE TABLE IF NOT EXISTS `global_reg_value` ( `char_id` int(11) unsigned NOT NULL default '0', `str` varchar(255) NOT NULL default '', `value` varchar(255) NOT NULL default '0', - `type` int(11) NOT NULL default '3', + `type` tinyint(1) NOT NULL default '3', `account_id` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`char_id`,`str`,`account_id`), KEY `account_id` (`account_id`), diff --git a/sql-files/upgrade_svn15003.sql b/sql-files/upgrade_svn15003.sql new file mode 100644 index 000000000..28b4f451e --- /dev/null +++ b/sql-files/upgrade_svn15003.sql @@ -0,0 +1 @@ +ALTER TABLE `global_reg_value` MODIFY `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '3';
|