diff options
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 3 | ||||
| -rw-r--r-- | sql-files/upgrade_svn6533.sql | 2 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index f60f36594..718f811e9 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -407,10 +407,11 @@ CREATE TABLE `sc_data` ( DROP TABLE IF EXISTS `loginlog`;
CREATE TABLE `loginlog` (
`time` datetime NOT NULL default '0000-00-00 00:00:00',
- `ip` varchar(64) NOT NULL default '',
+ `ip` char(15) NOT NULL default '',
`user` varchar(32) NOT NULL default '',
`rcode` tinyint(4) NOT NULL default '0',
`log` varchar(255) NOT NULL default ''
+ KEY (`ip`),
) TYPE=MyISAM;
--
diff --git a/sql-files/upgrade_svn6533.sql b/sql-files/upgrade_svn6533.sql new file mode 100644 index 000000000..5dffe0293 --- /dev/null +++ b/sql-files/upgrade_svn6533.sql @@ -0,0 +1,2 @@ +ALTER TABLE `loginlog` CHANGE `ip` `ip` CHAR( 15 ) NOT NULL
+ALTER TABLE `loginlog` ADD INDEX ( `ip` ( 15 ) )
|