From e3014f7b20b5df2843e3448c5327dda2641ddbdc Mon Sep 17 00:00:00 2001
From: shennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Thu, 6 Sep 2012 19:58:51 +0000
Subject: sql-files folder redesign as discussed with other developers, all
 upgrade files prior to rathena were removed (if you need them you can use the
 trac or download a earlier version of the folder).

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16750 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/upgrade_svn12975.sql | 24 ------------------------
 1 file changed, 24 deletions(-)
 delete mode 100644 sql-files/upgrade_svn12975.sql

(limited to 'sql-files/upgrade_svn12975.sql')

diff --git a/sql-files/upgrade_svn12975.sql b/sql-files/upgrade_svn12975.sql
deleted file mode 100644
index 26d78178e..000000000
--- a/sql-files/upgrade_svn12975.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-START TRANSACTION;
-
--- delete columns
-ALTER TABLE `login` DROP `error_message`;
-ALTER TABLE `login` DROP `memo`;
-
--- rename columns
-ALTER TABLE `login` CHANGE `connect_until` `expiration_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `login` CHANGE `ban_until` `unban_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
-
--- reorder columns
-ALTER TABLE `login` MODIFY `sex` enum('M','F','S') NOT NULL default 'M' AFTER `user_pass`;
-ALTER TABLE `login` MODIFY `email` varchar(39) NOT NULL default '' AFTER `sex`;
-ALTER TABLE `login` MODIFY `level` tinyint(3) NOT NULL default '0' AFTER `email`;
-ALTER TABLE `login` MODIFY `state` int(11) unsigned NOT NULL default '0' AFTER `level`;
-ALTER TABLE `login` MODIFY `unban_time` int(11) unsigned NOT NULL default '0' AFTER `state`;
-ALTER TABLE `login` MODIFY `expiration_time` int(11) unsigned NOT NULL default '0' AFTER `unban_time`;
-ALTER TABLE `login` MODIFY `logincount` mediumint(9) unsigned NOT NULL default '0' AFTER `expiration_time`;
-
--- change ip format
-ALTER TABLE `loginlog` CHANGE `ip` `ip` VARCHAR( 15 ) NOT NULL default '';
-UPDATE `loginlog` SET `ip` = inet_ntoa(`ip`);
-
-COMMIT;
-- 
cgit v1.2.3-70-g09d2

