From bb9615796077d4adb6d4bbe2b9e8f0e655254ec1 Mon Sep 17 00:00:00 2001
From: Christopher Speller <crspeller@gmail.com>
Date: Mon, 9 Nov 2015 15:25:41 -0500
Subject: Removing old DB upgrade code

---
 store/sql_channel_store.go | 49 ----------------------------------------------
 store/sql_post_store.go    | 17 ----------------
 store/sql_team_store.go    |  5 -----
 store/sql_user_store.go    |  2 --
 4 files changed, 73 deletions(-)

(limited to 'store')

diff --git a/store/sql_channel_store.go b/store/sql_channel_store.go
index 2d62b8614..6fcad5dc2 100644
--- a/store/sql_channel_store.go
+++ b/store/sql_channel_store.go
@@ -40,55 +40,6 @@ func NewSqlChannelStore(sqlStore *SqlStore) ChannelStore {
 }
 
 func (s SqlChannelStore) UpgradeSchemaIfNeeded() {
-
-	// REMOVE AFTER 1.2 SHIP see PLT-828
-	if s.CreateColumnIfNotExists("ChannelMembers", "NotifyProps", "varchar(2000)", "varchar(2000)", "{}") {
-		// populate NotifyProps from existing NotifyLevel field
-
-		// set default values
-		_, err := s.GetMaster().Exec(
-			`UPDATE
-				ChannelMembers
-			SET
-				NotifyProps = CONCAT('{"desktop":"', CONCAT(NotifyLevel, '","mark_unread":"` + model.CHANNEL_MARK_UNREAD_ALL + `"}'))`)
-		if err != nil {
-			l4g.Error("Unable to set default values for ChannelMembers.NotifyProps")
-			l4g.Error(err.Error())
-		}
-
-		// assume channels with all notifications enabled are just using the default settings
-		_, err = s.GetMaster().Exec(
-			`UPDATE
-				ChannelMembers
-			SET
-				NotifyProps = '{"desktop":"` + model.CHANNEL_NOTIFY_DEFAULT + `","mark_unread":"` + model.CHANNEL_MARK_UNREAD_ALL + `"}'
-			WHERE
-				NotifyLevel = '` + model.CHANNEL_NOTIFY_ALL + `'`)
-		if err != nil {
-			l4g.Error("Unable to set values for ChannelMembers.NotifyProps when members previously had notifyLevel=all")
-			l4g.Error(err.Error())
-		}
-
-		// set quiet mode channels to have no notifications and only mark the channel unread on mentions
-		_, err = s.GetMaster().Exec(
-			`UPDATE
-				ChannelMembers
-			SET
-				NotifyProps = '{"desktop":"` + model.CHANNEL_NOTIFY_NONE + `","mark_unread":"` + model.CHANNEL_MARK_UNREAD_MENTION + `"}'
-			WHERE
-				NotifyLevel = 'quiet'`)
-		if err != nil {
-			l4g.Error("Unable to set values for ChannelMembers.NotifyProps when members previously had notifyLevel=quiet")
-			l4g.Error(err.Error())
-		}
-
-		s.RemoveColumnIfExists("ChannelMembers", "NotifyLevel")
-	}
-
-	// BEGIN REMOVE AFTER 1.2.0
-	s.RenameColumnIfExists("Channels", "Description", "Header", "varchar(1024)")
-	s.CreateColumnIfNotExists("Channels", "Purpose", "varchar(1024)", "varchar(1024)", "")
-	// END REMOVE AFTER 1.2.0
 }
 
 func (s SqlChannelStore) CreateIndexesIfNotExists() {
diff --git a/store/sql_post_store.go b/store/sql_post_store.go
index 3460fca92..3a25fe89b 100644
--- a/store/sql_post_store.go
+++ b/store/sql_post_store.go
@@ -9,10 +9,8 @@ import (
 	"strconv"
 	"strings"
 
-	l4g "code.google.com/p/log4go"
 	"github.com/mattermost/platform/model"
 	"github.com/mattermost/platform/utils"
-	"time"
 )
 
 type SqlPostStore struct {
@@ -40,21 +38,6 @@ func NewSqlPostStore(sqlStore *SqlStore) PostStore {
 }
 
 func (s SqlPostStore) UpgradeSchemaIfNeeded() {
-	colType := s.GetColumnDataType("Posts", "Props")
-	if colType != "text" {
-
-		query := "ALTER TABLE Posts MODIFY COLUMN Props TEXT"
-		if utils.Cfg.SqlSettings.DriverName == model.DATABASE_DRIVER_POSTGRES {
-			query = "ALTER TABLE Posts ALTER COLUMN Props TYPE text"
-		}
-
-		_, err := s.GetMaster().Exec(query)
-		if err != nil {
-			l4g.Critical("Failed to alter column Posts.Props to TEXT: " + err.Error())
-			time.Sleep(time.Second)
-			panic("Failed to alter column Posts.Props to TEXT: " + err.Error())
-		}
-	}
 }
 
 func (s SqlPostStore) CreateIndexesIfNotExists() {
diff --git a/store/sql_team_store.go b/store/sql_team_store.go
index e0f95fa7e..1a0aeabde 100644
--- a/store/sql_team_store.go
+++ b/store/sql_team_store.go
@@ -30,11 +30,6 @@ func NewSqlTeamStore(sqlStore *SqlStore) TeamStore {
 }
 
 func (s SqlTeamStore) UpgradeSchemaIfNeeded() {
-	// REMOVE AFTER 1.2 SHIP see PLT-828
-	s.RemoveColumnIfExists("Teams", "AllowValet")
-	s.CreateColumnIfNotExists("Teams", "InviteId", "varchar(32)", "varchar(32)", "")
-	s.CreateColumnIfNotExists("Teams", "AllowOpenInvite", "tinyint(1)", "boolean", "0")
-	s.CreateColumnIfNotExists("Teams", "AllowTeamListing", "tinyint(1)", "boolean", "0")
 }
 
 func (s SqlTeamStore) CreateIndexesIfNotExists() {
diff --git a/store/sql_user_store.go b/store/sql_user_store.go
index 686949a4d..d38b5c214 100644
--- a/store/sql_user_store.go
+++ b/store/sql_user_store.go
@@ -41,8 +41,6 @@ func NewSqlUserStore(sqlStore *SqlStore) UserStore {
 }
 
 func (us SqlUserStore) UpgradeSchemaIfNeeded() {
-	// REMOVE AFTER 1.2 SHIP see PLT-828
-	us.CreateColumnIfNotExists("Users", "ThemeProps", "varchar(2000)", "character varying(2000)", "{}")
 }
 
 func (us SqlUserStore) CreateIndexesIfNotExists() {
-- 
cgit v1.2.3-1-g7c22