From a665ad5c2e44922fbd9790597913091c68311533 Mon Sep 17 00:00:00 2001
From: Nathan Guse <nathaniel.guse@gmail.com>
Date: Tue, 15 Jan 2013 18:58:19 -0600
Subject: [feature/migrations] Remove user_msnm migration

PHPBB3-9737
---
 .../includes/db/migration/data/310/remove_msnm.php | 43 ++++++++++++++++++++++
 1 file changed, 43 insertions(+)
 create mode 100644 phpBB/includes/db/migration/data/310/remove_msnm.php

(limited to 'phpBB/includes/db/migration/data/310/remove_msnm.php')

diff --git a/phpBB/includes/db/migration/data/310/remove_msnm.php b/phpBB/includes/db/migration/data/310/remove_msnm.php
new file mode 100644
index 0000000000..521161df6b
--- /dev/null
+++ b/phpBB/includes/db/migration/data/310/remove_msnm.php
@@ -0,0 +1,43 @@
+<?php
+/**
+*
+* @package migration
+* @copyright (c) 2012 phpBB Group
+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2
+*
+*/
+
+class phpbb_db_migration_data_310_remove_msnm extends phpbb_db_migration
+{
+	public function effectively_installed()
+	{
+		return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_msnm');
+	}
+
+	static public function depends_on()
+	{
+		return array('phpbb_db_migration_data_30x_3_0_11');
+	}
+
+	public function update_schema()
+	{
+		return array(
+			'drop_columns'	=> array(
+				$this->table_prefix . 'users'			=> array(
+					'user_msnm',
+				),
+			),
+		);
+	}
+
+	public function revert_schema()
+	{
+		return array(
+			'add_columns'	=> array(
+				$this->table_prefix . 'users'			=> array(
+					'user_msnm'		=> array('VCHAR_UNI', ''),
+				),
+			),
+		);
+	}
+}
-- 
cgit v1.2.1