Index: branches/5.2.x/install/install_schema.sql =================================================================== diff -u -N -r15244 -r15376 --- branches/5.2.x/install/install_schema.sql (.../install_schema.sql) (revision 15244) +++ branches/5.2.x/install/install_schema.sql (.../install_schema.sql) (revision 15376) @@ -251,8 +251,16 @@ CREATE TABLE PaymentTypes ( PaymentTypeId int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(100) NOT NULL DEFAULT '', - Description varchar(255) DEFAULT NULL, - Instructions text, + l1_Description varchar(255) DEFAULT '', + l2_Description varchar(255) DEFAULT '', + l3_Description varchar(255) DEFAULT '', + l4_Description varchar(255) DEFAULT '', + l5_Description varchar(255) DEFAULT '', + l1_Instructions text, + l2_Instructions text, + l3_Instructions text, + l4_Instructions text, + l5_Instructions text, AdminComments text, `Status` int(11) NOT NULL DEFAULT '0', Priority int(11) NOT NULL DEFAULT '0', @@ -267,7 +275,17 @@ KEY Priority (Priority), KEY GatewayId (GatewayId), KEY BuiltIn (BuiltIn), - KEY IsPrimary (IsPrimary) + KEY IsPrimary (IsPrimary), + KEY l1_Description (l1_Description(5)), + KEY l2_Description (l2_Description(5)), + KEY l3_Description (l3_Description(5)), + KEY l4_Description (l4_Description(5)), + KEY l5_Description (l5_Description(5)), + KEY l1_Instructions (l1_Instructions(5)), + KEY l2_Instructions (l2_Instructions(5)), + KEY l3_Instructions (l3_Instructions(5)), + KEY l4_Instructions (l4_Instructions(5)), + KEY l5_Instructions (l5_Instructions(5)) ); CREATE TABLE Products (