Database Changes - Commands
Copy the following commands and run them in the SQL query window for the SpeechMiner 8.5.0 to 8.5.0.1 Upgrade Procedure:
/* Change for build #7056
PRSM-9848 - adding time stamp for cleaning audios which entered more than 7 days ago.
Michal - 1/13/2014 3:19:56 PM */
ALTER TABLE dbo.segmentAudioTbl ADD arrivalTime int NULL
GO
GO
/* Change for build #7056
PRSM-9801 -
Tidhar - 1/15/2014 7:56:39 AM */
ALTER TABLE [dbo].[coachingStaticCallListCalls] DROP CONSTRAINT [FK_coachingStaticCallListCalls_callMetaTbl]
GO
GO
/* Change for build #7057
PRSM-9890 -
amit - 1/20/2014 11:52:51 AM */
GO
/****** Object: Index [IX_agentEntityTbl] Script Date: 20/01/2014 11:50:14 ******/
ALTER TABLE [dbo].[agentEntityTbl] DROP CONSTRAINT [IX_agentEntityTbl]
GO
GO
/* Change for build #7057
PRSM-8159 -
Tidhar - 1/21/2014 10:15:25 AM */
GO
/****** Object: StoredProcedure [dbo].[sp_agentFilterCleanByDays] Script Date: 01/21/2014 07:27:02 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_agentFilterCleanByDays]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_agentFilterCleanByDays]
GO
ALTER PROCEDURE [dbo].[sp_rebuild_partition_help_tables]
WITH EXECUTE AS SELF
AS
BEGIN TRAN
TRUNCATE TABLE partitionProgramTbl
insert into partitionprogramTbl
select distinct b.partitionid,a.programid
from (select callId,programId from callMetaTbl union select textId as callId,programId from TextData) a, callPartitionTbl as b
where a.callid=b.callid
COMMIT
/****** Object: Table [dbo].[partitionAgentTbl] Script Date: 01/21/2014 07:25:35 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[partitionAgentTbl]') AND type in (N'U'))
DROP TABLE [dbo].[partitionAgentTbl]
GO
GO
/* Change for build #7058
PRSM-9947 - Adding columns for the word error rate, and recall data
ttapuhi - 1/22/2014 3:58:12 PM */
ALTER TABLE WordPrecision
ADD "wer" float(20)
ALTER TABLE WordPrecision
ADD "recall" float(20)
GO
GO
/* Change for build #7058
PRSM-9953 - CLONE -Backoff writing to a NGProbs tables through smart
ttapuhi - 1/22/2014 5:50:30 PM */
ALTER TABLE NGProbs1
ADD "backoff" float(20)
ALTER TABLE NGProbs2
ADD "backoff" float(20)
ALTER TABLE NGProbs3
ADD "backoff" float(20)
ALTER TABLE NGProbs4
ADD "backoff" float(20)
GO
GO
/* Change for build #7063
PRSM-9926 - Add Column isBackupConfigurationServer to computerList
Itai Bechor - 1/26/2014 4:04:35 PM */
IF NOT EXISTS(select * from sys.columns where Name = N'isBackupConfigurationServer' and Object_ID = Object_ID(N'ComputerList'))
BEGIN
ALTER TABLE [dbo].[ComputerList] ADD isBackupConfigurationServer bit NOT NULL DEFAULT 0
END
GO
/* Change for build #7068
PRSM-9800 - adding wildcardGrammars table to DB for defining all wildcards in the supported languages.
Michal - 1/30/2014 3:28:26 PM */
CREATE TABLE wildcardGrammars
(
languageId int NOT NULL,
[key] nvarchar(50) NOT NULL,
value nvarchar(50) NOT NULL,
PRIMARY KEY (languageId,[key])
);
GO
INSERT INTO wildcardGrammars values
(0,'[alphanum]','alphanum'),
(0,'[boolean]','boolean'),
(0,'[ccexpdate]','ccexpdate'),
(0,'[creditcard]','creditcard'),
(0,'[currency]','currency'),
(0,'[date]','date'),
(0,'[digits]','digits'),
(0,'[number]','number'),
(0,'[phone]','phone'),
(0,'[socialsecurity]','socialsecurity'),
(0,'[time]','time'),
(0,'[voiceenroll]','voiceenroll'),
(0,'[zipcode]', 'zipcode'),
(2,'[alphanum]','alphanum'),
(2,'[boolean]','boolean'),
(2,'[ccexpdate]','ccexpdate'),
(2,'[creditcard]','creditcard'),
(2,'[currency]','currency'),
(2,'[date]','date'),
(2,'[digits]','digits'),
(2,'[number]','number'),
(2,'[phone]','phone'),
(2,'[time]','time'),
(2,'[voiceenroll]','voiceenroll'),
(2,'[zipcode]','zipcode');
GO
GO
/* Change for build #7068
PRSM-9953 - CLONE -Update of NGProbs tables writing through smart
Remove backoff column from NGProbs tables
ttapuhi - 1/28/2014 3:57:23 PM */
ALTER TABLE NGProbs1
DROP COLUMN backoff
ALTER TABLE NGProbs2
DROP COLUMN backoff
ALTER TABLE NGProbs3
DROP COLUMN backoff
ALTER TABLE NGProbs4
DROP COLUMN backoff
GO
GO
/* Change for build #7068
PRSM-9971 - Word Confidence Improvement: Adding new Neural Networks and use language dependent NN -
1. updating RecognitionLanguages table with NN names
2. New table - WordConfidenceInterpolation - with interpolation parameters
ttapuhi - 1/28/2014 4:10:39 PM */
ALTER TABLE RecognitionLanguages
ADD "WordConfidence" varchar(100)
GO
Update RecognitionLanguages
SET WordConfidence = 'wordconfidence'
UPDATE RecognitionLanguages
SET WordConfidence = 'wordconfidence_German' where index1 = 6
UPDATE RecognitionLanguages
SET WordConfidence = 'wordconfidence_Catalan' where index1 = 13
UPDATE RecognitionLanguages
SET WordConfidence = 'wordconfidence_English' where index1 in (0,3,14)
UPDATE RecognitionLanguages
SET WordConfidence = 'wordconfidence_Spanish' where index1 in (1,2)
UPDATE RecognitionLanguages
SET WordConfidence = 'wordconfidence_Portuguese' where index1 = 11
UPDATE RecognitionLanguages
SET WordConfidence = 'wordconfidence_French' where index1 = 5
GO
CREATE TABLE WordConfidenceInterpolation
(
Language int,
wer varchar(255),
precision varchar(255),
recall varchar(255)
)
grant SELECT on WordConfidenceInterpolation to Platform
INSERT INTO WordConfidenceInterpolation values(0,'-0.0356 0.8034','0.0431 0.3559','0.0272 0.5093')
INSERT INTO WordConfidenceInterpolation values(1,'-0.0383 0.7144','0.0226 0.5246','0.0338 0.3492')
INSERT INTO WordConfidenceInterpolation values(2,'-0.0369 0.8605','0.0418 0.3515','0.0343 0.1833')
INSERT INTO WordConfidenceInterpolation values(3,'-0.0328 0.7378','0.0395 0.3265','0.0246 0.3305')
INSERT INTO WordConfidenceInterpolation values(5,'-0.0334 0.9805','0.0386 0.1734','0.0386 0.1734')
INSERT INTO WordConfidenceInterpolation values(6,'-0.0179 0.6302','0.0295 0.3729','0.018 0.3883')
INSERT INTO WordConfidenceInterpolation values(11,'-0.0203 0.3161','0.0339 0.3161','0.0167 0.4534')
INSERT INTO WordConfidenceInterpolation values(13,'-0.0356 0.8034','0.0431 0.3559','0.0272 0.5093')
INSERT INTO WordConfidenceInterpolation values(14,'-0.033 0.6866','0.043 0.3835','0.0379 0.3249')
GO
GO
/* Change for build #7068
PRSM-9800 - Adding permissions
Michal - 1/29/2014 12:07:11 PM */
GRANT select ON [dbo].[wildcardGrammars] TO [SMART],[SMARTCompileGrammar],[InteractionReceiver],[Platform],[SMConfig],[Web]
GO
GO
/* Change for build #7068
PRSM-9972 -
Tidhar - 2/3/2014 3:04:50 PM */
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[callPartitionTbl]') AND name = N'IX_callPartitionTbl_partitionId')
DROP INDEX [IX_callPartitionTbl_partitionId] ON [dbo].[callPartitionTbl] WITH ( ONLINE = OFF )
GO
GO
/* Change for build #7070
PRSM-10006 - Updating RecognitionLanguages table, with South African English
ttapuhi - 2/6/2014 2:16:33 PM */
Update RecognitionLanguages
set Display='South African English',
NuanceRecognizerLanguagePack='en-ZA',
AS_PER_CHAR_TIME_DURATION=0.075,
culture='en-ZA',
encoding='English_South Africa.20127'
where index1=15
Update RecognitionLanguages
set encoding='French_France.28591' where index1=5
GO
GO
/* Change for build #7071
PRSM-10014 - fix last RecognitionLanguages DB changes
ttapuhi - 2/9/2014 4:00:05 PM */
Update RecognitionLanguages
set Display='',
NuanceRecognizerLanguagePack=NULL,
AS_PER_CHAR_TIME_DURATION=NULL,
culture=NULL,
DictionaryName=NULL,
encoding=NULL
where index1=15
GO
/* Change for build #7072
PRSM-10037 -
Tidhar - 2/13/2014 12:18:27 PM */
GO
Alter FUNCTION [dbo].[sp_getTopicEventSequences]
(
@callid int, @threshold int
)
RETURNS varchar(max)
AS
BEGIN
declare @text as varchar(max)
set @text=''
select @text=@text + ltrim(rtrim(str(e.resourceID))) + ' '
from callEventstbl e
where e.callid = @callid
and e.type=1 and e.subtype=1
and e.confidence>=@threshold
and e.found=1
order by e.starttime
RETURN substring(@text, 1, len(@text))
END
go
GO
/* Change for build #7072
PRSM-10039 - disabling confidence adjustment
ttapuhi - 2/13/2014 2:00:43 PM */
update dbo.callrecognizer set ADJUST_CONF = 'False'
GO
GO
/* Change for build #7072
PRSM-10049 - voiceenroll was removed from wildcards because lack of nuance documentation
ttapuhi - 2/17/2014 6:23:15 PM */
Delete from wildcardGrammars
where [key]='[voiceenroll]'
GO
/* Change for build #7072
PRSM-9800 - Changing columns name in WildcardGrammars table
Michal - 2/18/2014 12:02:18 PM */
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
EXECUTE sp_rename N'dbo.wildcardGrammars.[key]', N'Tmp_token', 'COLUMN'
GO
EXECUTE sp_rename N'dbo.wildcardGrammars.value', N'Tmp_grammar_1', 'COLUMN'
GO
EXECUTE sp_rename N'dbo.wildcardGrammars.Tmp_token', N'token', 'COLUMN'
GO
EXECUTE sp_rename N'dbo.wildcardGrammars.Tmp_grammar_1', N'grammar', 'COLUMN'
GO
ALTER TABLE dbo.wildcardGrammars SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
GO
/* Change for build #7072
PRSM-9926 - Remove Column isBackupConfigurationServer from computerList
Itai Bechor - 2/23/2014 10:23:25 AM */
declare @table_name nvarchar(256)
declare @col_name nvarchar(256)
declare @Command nvarchar(1000)
set @table_name = N'ComputerList'
set @col_name = N'isBackupConfigurationServer'
select @Command = 'ALTER TABLE ' + @table_name + ' drop constraint ' + d.name
from sys.tables t
join sys.default_constraints d
on d.parent_object_id = t.object_id
join sys.columns c
on c.object_id = t.object_id
and c.column_id = d.parent_column_id
where t.name = @table_name
and c.name = @col_name
execute (@Command)
GO
IF EXISTS(select * from sys.columns where Name = N'isBackupConfigurationServer' and Object_ID = Object_ID(N'ComputerList'))
BEGIN
ALTER TABLE [dbo].[ComputerList] DROP COLUMN isBackupConfigurationServer
END
GO
GO
/* Change for build #7077
PRSM-10081 -
Tidhar - 2/27/2014 2:35:06 PM */
ALTER PROCEDURE [dbo].[sp_deleteTexts](@TextIDs varchar(max),@deletedTextsNum int OUTPUT)
WITH EXECUTE AS SELF
AS
BEGIN
SET NOCOUNT ON;
DECLARE @ParmDefinition nvarchar(500);
set @deletedTextsNum ='-1'
declare @SelectCounter nvarchar(max)
set @SelectCounter = N'select @sOUT = count(*) from textData where textId in (' + @TextIDs + ')'
SET @ParmDefinition = N'@sOUT int OUTPUT';
exec sp_executesql @SelectCounter,@ParmDefinition,@sOUT=@deletedTextsNum OUTPUT;
declare @deleteTexts as nvarchar (max)
set @deleteTexts = ''
---------
set @deleteTexts = @deleteTexts + 'DELETE FROM callMetaExTbl where callid in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM callcategoryTbl where callid in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM callEventsTbl where callid in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM callAgentTbl where callid in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM callPartitionTbl where callid in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM textparties where textId in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM textStatus where textId in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM textData where textId in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM repCategoryMetaTbl where callid in (' + @TextIDs + ')'
set @deleteTexts = @deleteTexts + 'DELETE FROM callSpeakersTbl where callid in (' + @TextIDs + ')'
---------
exec sp_executesql @deleteTexts
END
GO
/* Change for build #7078
PRSM-10029 - enable enter of text ID's to table
Itai Bechor - 2/27/2014 2:37:52 PM */
ALTER TABLE callNotesTbl DROP CONSTRAINT FK_callNotesTbl_callMetaTbl
GO
/* Change for build #7079
PRSM-10099 - Dictionary name for Brazilian Portugese have been updated.
Spanish dictionaries names updated
ttapuhi - 3/3/2014 11:54:17 AM */
UPDATE RecognitionLanguages
set DictionaryName = 'pt_BR' where index1=11
GO
UPDATE RecognitionLanguages
set DictionaryName = 'es_MX' where index1 = 1
GO
UPDATE RecognitionLanguages
set DictionaryName = 'es_ES' where index1 = 2
GO
GO
/* Change for build #7079
PRSM-10110 - report caching - get next report from cache
morad - 3/11/2014 8:22:43 PM */
delete from reportCachingQueue
GO
alter table reportCachingQueue add runAtTime int NOT NULL
GO
CREATE PROCEDURE [dbo].[sp_getReportCachingNextTask]
AS
BEGIN
BEGIN TRAN
declare @id int
SELECT top 1 @id=id from reportCachingQueue with(updlock holdlock)
where nextTimeToRun<dbo.time2tod(GetUtcDate())
order by nextTimeToRun
IF @id IS NOT NULL
BEGIN
update reportCachingQueue set nextTimeToRun=dbo.time2tod(GetUtcDate())+1*60*60 where id=@id
select reportid, [partitions], runAtTime from reportCachingQueue where id=@id
END
COMMIT
END
GO
grant execute on sp_getReportCachingNextTask to platform
GO
GO
/* Change for build #7080
PRSM-9946 - This changes are for the automatic restore
Michal - 3/4/2014 11:07:50 AM */
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.indexParamsTbl ADD
autoRestore bit NOT NULL CONSTRAINT DF_indexParamsTbl_autoRestore DEFAULT 0,
timeToWaitForFolder int NULL
GO
ALTER TABLE dbo.indexParamsTbl SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
GRANT update(indexdirectorypath, dailyBackupLocation) ON [indexparamstbl] TO [Platform]
GO
GO
/* Change for build #7080
PRSM-9954 - Move archive API to interaction receiver
Shahar - 3/4/2014 2:20:17 PM */
grant update(status,stoppedForPurge) on computerList to interactionReceiver
grant execute on sp_enqueuePurgeTask to interactionReceiver
GO
/* Change for build #7080
PRSM-9480 - Change SP that get the trend of a cluster
morad - 3/4/2014 9:41:48 PM */
ALTER PROCEDURE [dbo].[sp_getClusterTrendData]
@clusterId int,
@maxTrendWeeksBack int
AS
BEGIN
declare @firstDayOfWeek as int
set @firstDayOfWeek = dbo.getFirstDayOfWeek()
set DATEFIRST @firstDayOfWeek
declare @paramsId as int
declare @reportDate as datetime
set @paramsId = (select paramsId from ExplorationReports where reportid=(select reportid from ExplorationReportsData where clusterid=@clusterId))
set @reportDate = (select dbo.tod2time(endTime) from ExplorationReportParams where id=@paramsId)
IF @reportDate IS NULL
BEGIN
select NULL as[time], NULL as [numberOfCalls], NULL as [totalNumberOfCalls]
RETURN -- the specified cluster id does not exist.
END
create table #trendData (
[time] datetime NOT NULL,
[numberOfCalls] int,
[totalNumberOfCalls] int
)
insert into #trendData
select dbo.tod2time([time]) as [time], numberOfCalls, totalNumberOfCalls
from dbo.ExplorationTrendData where clusterid=@clusterId
IF NOT EXISTS(select [time] from #trendData)
BEGIN
insert into #trendData values(DATEADD(DAY, 1-DATEPART(WEEKDAY, @reportDate), @reportDate), NULL, NULL)
END
-- add the dates (start of week) from the last date with data to the report time
while dateadd(week, 1, (select max(time) from #trendData)) < @reportDate
BEGIN
declare @newTime as datetime
set @newTime = dateadd(week, 1, (select max(time) from #trendData))
IF not exists(select * from #trendData where [time] = @newTime)
BEGIN
insert into #trendData values(@newTime, NULL, NULL)
END
END
declare @currentTrendDate as datetime
set @currentTrendDate = (select max(time) from #trendData)
-- skip the first week if the current report date is the first day of the week
if @currentTrendDate = @reportDate
BEGIN
set @currentTrendDate = dateadd(week, -1, @currentTrendDate)
END
declare @count as int
set @count = 0
while @count < @maxTrendWeeksBack - 1
BEGIN
IF not exists(select * from #trendData where [time] = @currentTrendDate)
BEGIN
insert into #trendData values(@currentTrendDate, NULL, NULL)
END
set @currentTrendDate = dateadd(week, -1, @currentTrendDate)
set @count = @count + 1
END
set @currentTrendDate = dateadd(week, 1, @currentTrendDate)
delete from #trendData where time<@currentTrendDate -- remove the old items if there are more than @maxTrendWeeksBack items
select * from #trendData order by [time]
drop table #trendData
END
GO
/* Change for build #7081
PRSM-9468 -
amit - 3/5/2014 11:21:47 AM */
GO
GRANT UPDATE ON dbo.[TextStatus] TO Web
GO
GO
/* Change for build #7082
PRSM-10077 - Supporting non ANSI characters in emails' body and subject.
amit - 3/5/2014 5:50:23 PM */
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TextData
DROP CONSTRAINT FK_TextData_ResourceType
GO
ALTER TABLE dbo.ResourceType SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TextData
DROP CONSTRAINT FK_TextData_programInfoTbl
GO
ALTER TABLE dbo.programInfoTbl SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TextData
DROP CONSTRAINT DF_TextData_customerId
GO
ALTER TABLE dbo.TextData
DROP CONSTRAINT DF_TextData_customerGroupId
GO
ALTER TABLE dbo.TextData
DROP CONSTRAINT DF_TextData_programId
GO
CREATE TABLE dbo.Tmp_TextData
(
textId int NOT NULL,
resourceTypeId int NOT NULL,
originalTime int NULL,
customerId varchar(256) NOT NULL,
customerGroupId varchar(256) NOT NULL,
subject nvarchar(MAX) NULL,
body nvarchar(MAX) NULL,
externalTextId varchar(256) NULL,
sender varchar(8000) NULL,
receiver varchar(8000) NULL,
cc varchar(8000) NULL,
bcc varchar(8000) NULL,
programId int NOT NULL,
originalBody varchar(MAX) NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_TextData SET (LOCK_ESCALATION = TABLE)
GO
GRANT DELETE ON dbo.Tmp_TextData TO Platform AS dbo
GO
GRANT INSERT ON dbo.Tmp_TextData TO Platform AS dbo
GO
GRANT SELECT ON dbo.Tmp_TextData TO Web AS dbo
GO
GRANT SELECT ON dbo.Tmp_TextData TO Platform AS dbo
GO
GRANT SELECT ON dbo.Tmp_TextData TO SMART AS dbo
GO
GRANT UPDATE ON dbo.Tmp_TextData TO Web AS dbo
GO
GRANT UPDATE ON dbo.Tmp_TextData TO Platform AS dbo
GO
ALTER TABLE dbo.Tmp_TextData ADD CONSTRAINT
DF_TextData_customerId DEFAULT ('') FOR customerId
GO
ALTER TABLE dbo.Tmp_TextData ADD CONSTRAINT
DF_TextData_customerGroupId DEFAULT ('') FOR customerGroupId
GO
ALTER TABLE dbo.Tmp_TextData ADD CONSTRAINT
DF_TextData_programId DEFAULT ((0)) FOR programId
GO
IF EXISTS(SELECT * FROM dbo.TextData)
EXEC('INSERT INTO dbo.Tmp_TextData (textId, resourceTypeId, originalTime, customerId, customerGroupId, subject, body, externalTextId, sender, receiver, cc, bcc, programId, originalBody)
SELECT textId, resourceTypeId, originalTime, customerId, customerGroupId, CONVERT(nvarchar(MAX), subject), CONVERT(nvarchar(MAX), body), externalTextId, sender, receiver, cc, bcc, programId, originalBody FROM dbo.TextData WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.TextStatus
DROP CONSTRAINT FK_TextStatus_TextData
GO
DROP TABLE dbo.TextData
GO
EXECUTE sp_rename N'dbo.Tmp_TextData', N'TextData', 'OBJECT'
GO
ALTER TABLE dbo.TextData ADD CONSTRAINT
PK_TextDataTbl PRIMARY KEY CLUSTERED
(
textId
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_externalTextId ON dbo.TextData
(
externalTextId
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.TextData ADD CONSTRAINT
FK_TextData_programInfoTbl FOREIGN KEY
(
programId
) REFERENCES dbo.programInfoTbl
(
programId
) ON UPDATE NO ACTION
ON DELETE NO ACTION
GO
ALTER TABLE dbo.TextData ADD CONSTRAINT
FK_TextData_ResourceType FOREIGN KEY
(
resourceTypeId
) REFERENCES dbo.ResourceType
(
resourceTypeId
) ON UPDATE NO ACTION
ON DELETE NO ACTION
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.TextStatus WITH NOCHECK ADD CONSTRAINT
FK_TextStatus_TextData FOREIGN KEY
(
textId
) REFERENCES dbo.TextData
(
textId
) ON UPDATE NO ACTION
ON DELETE NO ACTION
GO
ALTER TABLE dbo.TextStatus
NOCHECK CONSTRAINT FK_TextStatus_TextData
GO
ALTER TABLE dbo.TextStatus SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
GO
/* Change for build #7082
PRSM-10139 - Update customer care email
Shahar - 3/6/2014 3:37:57 PM */
UPDATE [webServiceParams] SET [sendFeedbackEmail]='customercare@genesys.com'
GO
/* Change for build #7085
PRSM-9996 - Remove digits wildcard, which crashes Nuance
Shahar - 3/13/2014 4:50:24 PM */
delete wildcardGrammars where grammar='digits'
GO
/* Change for build #7092
PRSM-10202 -
amit - 3/19/2014 11:28:27 AM */
GO
UPDATE indexer set calls_per_chunk=6000
GO
GO
update dbo.versionTbl set version= '8.5.7104' where resource in ('SM', 'SMART')
go
This page was last edited on May 4, 2014, at 10:10.
Comments or questions about this documentation? Contact us for support!