ODBC Database Structures Changes in SMS Studio 3.1.0.0

1. ODBC Connection - fields changed to TEXT (MySQL), NVARCHAR(MAX) (Microsoft SQL Server) or LONGTEXT (Microsoft Access):

- Incoming table - MsgExternalID

- IncomingStatus table - MsgExternalID, MsgDLRStatus, MsgBodyPart

- OutogingStatus table - MsgDLRStatus, MsgBodyPart

 

2. Main files - fields changed to TEXT (MySQL), NVARCHAR(MAX) (Microsoft SQL Server) or LONGTEXT (Microsoft Access):

- Inbox table: MsgExternalID, MsgInfo

- Outbox table: MsgExternalID, MsgInfo, MsgSendingTime

- Billing table: ReqInfo, RegGroups, ReqRuleName, ReqRuleParameters, ReqTag

- Credits table: AccName, AccTimeInterval, AccContact

 

3. Main files - fields added as INTEGER:

- Outbox table: MsgSendingAccountID

 

4. Service - fields changed to TEXT (MySQL), NVARCHAR(MAX) (Microsoft SQL Server) or LONGTEXT (Microsoft Access):

- Voting service - VotingResults table: AnswerName, VotePercentage

- Betting service - BettingInbox table: MsgExternalID

- Mailbox service - Mailbox table: MsgExternalID

- Voucher services - VoucherInbox table: MsgExternalID

 

NOTE: You may use AlterTable scripts from the Samples folder to make these changes.