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_view.sql | 17 -----------------
 1 file changed, 17 deletions(-)
 delete mode 100644 sql-files/upgrade_svn12975_view.sql

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

diff --git a/sql-files/upgrade_svn12975_view.sql b/sql-files/upgrade_svn12975_view.sql
deleted file mode 100644
index 7f0cce743..000000000
--- a/sql-files/upgrade_svn12975_view.sql
+++ /dev/null
@@ -1,17 +0,0 @@
--- The statements below will create a 'view' (virtual table) that mimics
--- the previous `login` table layout. You can use this hack to make your db
--- compatible with older *Athena servers or control panels.
--- Note: also adjust the account.sql.account_db setting in login_athena.conf.
--- Note: if your CP does not have a config setting for the `login` table name
---       you'll have to either modify its code or do some table renaming.
-
-START TRANSACTION;
-
--- create dummy columns, needed to make the view insertable
-ALTER TABLE `login` ADD `error_message` SMALLINT UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `login` ADD `memo` SMALLINT UNSIGNED NOT NULL DEFAULT '0';
-
--- create the view
-CREATE VIEW `login_view` ( `account_id`, `userid`, `user_pass`, `lastlogin`, `sex`, `logincount`, `email`, `level`, `error_message`, `connect_until`, `last_ip`, `memo`, `ban_until`, `state` ) AS SELECT `account_id`, `userid`, `user_pass`, `lastlogin`, `sex`, `logincount`, `email`, `level`, `error_message`, `expiration_time`, `last_ip`, `memo`, `unban_time`, `state` FROM `login`;
-
-COMMIT;
-- 
cgit v1.2.3-70-g09d2

