From c46cdaae3ea8ce0a0128a59e79a03f0c7f5b3e12 Mon Sep 17 00:00:00 2001
From: ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Tue, 29 Jul 2008 03:06:58 +0000
Subject: Corrected upgrade_svn12975_view.sql not assigning default values to
 the two dummy columns (bugreport:1940). Please drop the view and re-run the
 script.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13010 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/upgrade_svn12975_view.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

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

diff --git a/sql-files/upgrade_svn12975_view.sql b/sql-files/upgrade_svn12975_view.sql
index 8d5d5906b..a3d64f97e 100644
--- a/sql-files/upgrade_svn12975_view.sql
+++ b/sql-files/upgrade_svn12975_view.sql
@@ -8,8 +8,8 @@
 START TRANSACTION;
 
 -- create dummy columns, needed to make the view insertable
-ALTER TABLE `login` ADD `error_message` SMALLINT UNSIGNED NOT NULL;
-ALTER TABLE `login` ADD `memo` SMALLINT UNSIGNED NOT NULL;
+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`;
-- 
cgit v1.2.3-70-g09d2

