diff options
author | shennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-09-06 19:58:51 +0000 |
---|---|---|
committer | shennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-09-06 19:58:51 +0000 |
commit | e3014f7b20b5df2843e3448c5327dda2641ddbdc (patch) | |
tree | 7b051a2217aeb27a77f35f2a632034df12477b87 /sql-files/upgrade_svn12975_view.sql | |
parent | bd62cbc13d98a977008f42ea6583a33c99516c6b (diff) | |
download | hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.gz hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.bz2 hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.xz hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.zip |
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
Diffstat (limited to 'sql-files/upgrade_svn12975_view.sql')
-rw-r--r-- | sql-files/upgrade_svn12975_view.sql | 17 |
1 files changed, 0 insertions, 17 deletions
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; |