root/trunk/sql/updates/0.8/4425_character.sql @ 2

Revision 2, 212 bytes (checked in by yumileroy, 17 years ago)

[svn] * Proper SVN structure

Original author: Neo2003
Date: 2008-10-02 16:23:55-05:00
Line 
1ALTER TABLE `character` 
2  ADD COLUMN `at_login` int(11) unsigned NOT NULL default '0' AFTER `rename`;
3
4UPDATE `character` SET `at_login` = 1 WHERE `rename` <> 0;
5
6ALTER TABLE `character` 
7  DROP COLUMN `rename`;
Note: See TracBrowser for help on using the browser.