Index: branches/5.3.x/admin_templates/affiliate_plans/affiliates_edit.tpl =================================================================== diff -u -r15971 -r16133 --- branches/5.3.x/admin_templates/affiliate_plans/affiliates_edit.tpl (.../affiliates_edit.tpl) (revision 15971) +++ branches/5.3.x/admin_templates/affiliate_plans/affiliates_edit.tpl (.../affiliates_edit.tpl) (revision 16133) @@ -70,7 +70,6 @@ - @@ -99,4 +98,4 @@ - \ No newline at end of file + Index: branches/5.3.x/install/upgrades.sql =================================================================== diff -u -r16106 -r16133 --- branches/5.3.x/install/upgrades.sql (.../upgrades.sql) (revision 16106) +++ branches/5.3.x/install/upgrades.sql (.../upgrades.sql) (revision 16133) @@ -297,3 +297,5 @@ # ===== v 5.2.1 ===== # ===== v 5.3.0-B1 ===== +ALTER TABLE Affiliates DROP SSN; +DELETE FROM LanguageLabels WHERE PhraseKey IN ('LA_FLD_SSN', 'LU_COMM_SSNFIELD', 'LU_FLD_SSNFIELD'); Index: branches/5.3.x/install/install_schema.sql =================================================================== diff -u -r15671 -r16133 --- branches/5.3.x/install/install_schema.sql (.../install_schema.sql) (revision 15671) +++ branches/5.3.x/install/install_schema.sql (.../install_schema.sql) (revision 16133) @@ -673,7 +673,6 @@ AffiliateCode varchar(30) NOT NULL DEFAULT '', ItemsSold int(10) unsigned NOT NULL DEFAULT '0', PaymentTypeId int(11) NOT NULL DEFAULT '0', - SSN varchar(100) NOT NULL DEFAULT '', Comments text, CreatedOn int(11) DEFAULT NULL, PRIMARY KEY (AffiliateId), @@ -744,4 +743,4 @@ ADD INDEX (PrimaryCurrencyId), ADD INDEX (Currencies), ADD INDEX (PrimaryPaymentTypeId), - ADD INDEX (PaymentTypes); \ No newline at end of file + ADD INDEX (PaymentTypes); Index: branches/5.3.x/install/english.lang =================================================================== diff -u -r15899 -r16133 --- branches/5.3.x/install/english.lang (.../english.lang) (revision 15899) +++ branches/5.3.x/install/english.lang (.../english.lang) (revision 16133) @@ -366,7 +366,6 @@ U2hpcHBpbmcgWm9uZSBOYW1l U0tV U3BlZWQgQ29kZQ== - U1NOL1RheCBJZC9WQVQgTnVtYmVy U3RhcnQgRGF0ZQ== U3VidG90YWw= QXBwbHkgdG8gUHJvY2Vzc2luZw== @@ -1045,4 +1044,4 @@ - \ No newline at end of file + Index: branches/5.3.x/units/affiliates/affiliates_config.php =================================================================== diff -u -r15671 -r16133 --- branches/5.3.x/units/affiliates/affiliates_config.php (.../affiliates_config.php) (revision 15671) +++ branches/5.3.x/units/affiliates/affiliates_config.php (.../affiliates_config.php) (revision 16133) @@ -1,6 +1,6 @@ Array ('type' => 'string', 'not_null' => '1', 'default' => ''), 'ItemsSold' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), 'PaymentTypeId' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => ''), 'options_sql' => 'SELECT Name, PaymentTypeId FROM '.TABLE_PREFIX.'AffiliatePaymentTypes WHERE Status = 1 ORDER BY IsPrimary DESC, Priority DESC, Name ASC', 'option_key_field' => 'PaymentTypeId', 'option_title_field' => 'Name', 'not_null' => 1, 'default' => 0), - 'SSN' => Array ('type' => 'string', 'not_null' => '1', 'default' => '', 'required' => 1), 'Comments' => Array ('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => NULL), 'CreatedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'), ), @@ -238,4 +237,4 @@ ), ), ), -); \ No newline at end of file +);