· 4 years ago · Jan 21, 2021, 11:58 AM
1/*
2Script created by SQL Examiner 7.1.8.293 at 21-01-2021 11:48:20.
3Run this script on bruno-mig\sql2017.PRIEMPRE_SR to make it the same as bruno-mig\sql2017.PRIEMPRE
4*/
5GO
6SET NOCOUNT ON
7SET NOEXEC OFF
8SET ARITHABORT ON
9SET XACT_ABORT ON
10SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
11GO
12BEGIN TRAN
13GO
14--step 1: drop index COMDeclsElectronicas03 from table dbo.COMDeclsElectronicas---------------------
15DROP INDEX [dbo].[COMDeclsElectronicas].[COMDeclsElectronicas03]
16GO
17IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 1 is completed with errors' ROLLBACK TRAN END
18GO
19IF @@TRANCOUNT = 0 BEGIN PRINT 'step 1 is completed with errors' SET NOEXEC ON END
20GO
21--step 2: add index COMDeclsElectronicas03 to table dbo.COMDeclsElectronicas------------------------
22CREATE NONCLUSTERED INDEX [COMDeclsElectronicas03] ON [dbo].[COMDeclsElectronicas]([Ficheiro]) ON [PRIMARY]
23GO
24IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 2 is completed with errors' ROLLBACK TRAN END
25GO
26IF @@TRANCOUNT = 0 BEGIN PRINT 'step 2 is completed with errors' SET NOEXEC ON END
27GO
28--step 3: alter column [Valor] of table [dbo].[COMValoresImpressao]---------------------------------
29ALTER TABLE [dbo].[COMValoresImpressao] ALTER COLUMN [Valor] [varchar](2500) COLLATE Latin1_General_CI_AS NULL
30GO
31IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 3 is completed with errors' ROLLBACK TRAN END
32GO
33IF @@TRANCOUNT = 0 BEGIN PRINT 'step 3 is completed with errors' SET NOEXEC ON END
34GO
35--step 4: truncate data in [dbo].[Empresas].[IDNome] before changing the column size----------------
36UPDATE [dbo].[Empresas] SET [IDNome] = SUBSTRING([IDNome], 1, 50)
37GO
38IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 4 is completed with errors' ROLLBACK TRAN END
39GO
40IF @@TRANCOUNT = 0 BEGIN PRINT 'step 4 is completed with errors' SET NOEXEC ON END
41GO
42--step 5: alter column [IDNome] of table [dbo].[Empresas]-------------------------------------------
43ALTER TABLE [dbo].[Empresas] ALTER COLUMN [IDNome] [varchar](50) COLLATE Latin1_General_CI_AS NULL
44GO
45IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 5 is completed with errors' ROLLBACK TRAN END
46GO
47IF @@TRANCOUNT = 0 BEGIN PRINT 'step 5 is completed with errors' SET NOEXEC ON END
48GO
49--step 6: add columns to Table dbo.Empresas---------------------------------------------------------
50ALTER TABLE [dbo].[Empresas] ADD
51 [Wallpaper] [nvarchar](260) COLLATE Latin1_General_CI_AS NULL,
52 [WallpaperStretch] [bit] NULL
53GO
54IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 6 is completed with errors' ROLLBACK TRAN END
55GO
56IF @@TRANCOUNT = 0 BEGIN PRINT 'step 6 is completed with errors' SET NOEXEC ON END
57GO
58--step 7: drop column Pais from table dbo.Empresas--------------------------------------------------
59ALTER TABLE [dbo].[Empresas] DROP COLUMN
60 [Pais]
61GO
62IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 7 is completed with errors' ROLLBACK TRAN END
63GO
64IF @@TRANCOUNT = 0 BEGIN PRINT 'step 7 is completed with errors' SET NOEXEC ON END
65GO
66--step 8: alter column [BuildingNumber] of table [dbo].[EnterpriseInformationsCache]----------------
67ALTER TABLE [dbo].[EnterpriseInformationsCache] ALTER COLUMN [BuildingNumber] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL
68GO
69IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 8 is completed with errors' ROLLBACK TRAN END
70GO
71IF @@TRANCOUNT = 0 BEGIN PRINT 'step 8 is completed with errors' SET NOEXEC ON END
72GO
73--step 9: alter column [Company] of table [dbo].[ExtensibilityConfiguration]------------------------
74ALTER TABLE [dbo].[ExtensibilityConfiguration] ALTER COLUMN [Company] [nvarchar](max) COLLATE Latin1_General_CI_AS NULL
75GO
76IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 9 is completed with errors' ROLLBACK TRAN END
77GO
78IF @@TRANCOUNT = 0 BEGIN PRINT 'step 9 is completed with errors' SET NOEXEC ON END
79GO
80--step 10: create table dbo.HistoricoObjetos--------------------------------------------------------
81CREATE TABLE [dbo].[HistoricoObjetos] (
82 [Id] [uniqueidentifier] NOT NULL,
83 [Entidade] [nvarchar](100) COLLATE Latin1_General_CI_AS NOT NULL,
84 [Apl] [nvarchar](3) COLLATE Latin1_General_CI_AS NOT NULL,
85 [Operacao] [nvarchar](1) COLLATE Latin1_General_CI_AS NOT NULL,
86 [Utilizador] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL,
87 [Objeto] [text] COLLATE Latin1_General_CI_AS NOT NULL,
88 [Mensagem] [text] COLLATE Latin1_General_CI_AS NOT NULL,
89 [ChaveRGPD] [nvarchar](100) COLLATE Latin1_General_CI_AS NOT NULL,
90 [Chave1] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
91 [Chave2] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
92 [Chave3] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
93 [Chave4] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
94 [Chave5] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
95 [Chave6] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
96 [Chave7] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
97 [CreatedOn] [datetime] NOT NULL,
98 [ModifiedOn] [datetime] NOT NULL
99) ON [PRIMARY]
100GO
101IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 10 is completed with errors' ROLLBACK TRAN END
102GO
103IF @@TRANCOUNT = 0 BEGIN PRINT 'step 10 is completed with errors' SET NOEXEC ON END
104GO
105--step 11: dbo.HistoricoObjetos: add primary key PK_HistoricoObjetos--------------------------------
106ALTER TABLE [dbo].[HistoricoObjetos] ADD CONSTRAINT [PK_HistoricoObjetos] PRIMARY KEY CLUSTERED ([Id])
107GO
108IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 11 is completed with errors' ROLLBACK TRAN END
109GO
110IF @@TRANCOUNT = 0 BEGIN PRINT 'step 11 is completed with errors' SET NOEXEC ON END
111GO
112--step 12: create table dbo.HistoricoObjetosComparacao----------------------------------------------
113CREATE TABLE [dbo].[HistoricoObjetosComparacao] (
114 [Id] [uniqueidentifier] NOT NULL,
115 [IdOrigem] [uniqueidentifier] NOT NULL,
116 [IdDestino] [uniqueidentifier] NOT NULL,
117 [Resultado] [text] COLLATE Latin1_General_CI_AS NOT NULL,
118 [CreatedOn] [datetime] NOT NULL,
119 [ModifiedOn] [datetime] NOT NULL
120) ON [PRIMARY]
121GO
122IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 12 is completed with errors' ROLLBACK TRAN END
123GO
124IF @@TRANCOUNT = 0 BEGIN PRINT 'step 12 is completed with errors' SET NOEXEC ON END
125GO
126--step 13: dbo.HistoricoObjetosComparacao: add primary key PK_HistoricoObjetosComparacao------------
127ALTER TABLE [dbo].[HistoricoObjetosComparacao] ADD CONSTRAINT [PK_HistoricoObjetosComparacao] PRIMARY KEY CLUSTERED ([Id])
128GO
129IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 13 is completed with errors' ROLLBACK TRAN END
130GO
131IF @@TRANCOUNT = 0 BEGIN PRINT 'step 13 is completed with errors' SET NOEXEC ON END
132GO
133--step 14: dbo.HistoricoObjetosComparacao: add foreign key FK_HistoricoObjetosComparacao_HistoricoObjetos_Destino
134ALTER TABLE [dbo].[HistoricoObjetosComparacao] ADD CONSTRAINT [FK_HistoricoObjetosComparacao_HistoricoObjetos_Destino] FOREIGN KEY ([IdDestino]) REFERENCES [dbo].[HistoricoObjetos] ([Id])
135GO
136IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 14 is completed with errors' ROLLBACK TRAN END
137GO
138IF @@TRANCOUNT = 0 BEGIN PRINT 'step 14 is completed with errors' SET NOEXEC ON END
139GO
140--step 15: dbo.HistoricoObjetosComparacao: add foreign key FK_HistoricoObjetosComparacao_HistoricoObjetos_Origem
141ALTER TABLE [dbo].[HistoricoObjetosComparacao] ADD CONSTRAINT [FK_HistoricoObjetosComparacao_HistoricoObjetos_Origem] FOREIGN KEY ([IdOrigem]) REFERENCES [dbo].[HistoricoObjetos] ([Id])
142GO
143IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 15 is completed with errors' ROLLBACK TRAN END
144GO
145IF @@TRANCOUNT = 0 BEGIN PRINT 'step 15 is completed with errors' SET NOEXEC ON END
146GO
147--step 16: add columns to Table dbo.LicensingInformation--------------------------------------------
148ALTER TABLE [dbo].[LicensingInformation] ADD
149 [ContractState] [nvarchar](32) COLLATE Latin1_General_CI_AS NULL
150GO
151IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 16 is completed with errors' ROLLBACK TRAN END
152GO
153IF @@TRANCOUNT = 0 BEGIN PRINT 'step 16 is completed with errors' SET NOEXEC ON END
154GO
155--step 17: create table dbo.LicensingInformationParameters------------------------------------------
156CREATE TABLE [dbo].[LicensingInformationParameters] (
157 [ID] [uniqueidentifier] NOT NULL,
158 [LicensingID] [varchar](36) COLLATE Latin1_General_CI_AS NOT NULL,
159 [LicensingToken] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
160 [ParamName] [varchar](200) COLLATE Latin1_General_CI_AS NOT NULL,
161 [ParamValue] [text] COLLATE Latin1_General_CI_AS NOT NULL
162) ON [PRIMARY]
163GO
164IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 17 is completed with errors' ROLLBACK TRAN END
165GO
166IF @@TRANCOUNT = 0 BEGIN PRINT 'step 17 is completed with errors' SET NOEXEC ON END
167GO
168--step 18: dbo.LicensingInformationParameters: add primary key PK_LicensingInformationParameters----
169ALTER TABLE [dbo].[LicensingInformationParameters] ADD CONSTRAINT [PK_LicensingInformationParameters] PRIMARY KEY CLUSTERED ([ID])
170GO
171IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 18 is completed with errors' ROLLBACK TRAN END
172GO
173IF @@TRANCOUNT = 0 BEGIN PRINT 'step 18 is completed with errors' SET NOEXEC ON END
174GO
175--step 19: dbo.LicensingInformationParameters: add foreign key FK_LicensingInformationParameters_LicensingInformationParameters
176ALTER TABLE [dbo].[LicensingInformationParameters] ADD CONSTRAINT [FK_LicensingInformationParameters_LicensingInformationParameters] FOREIGN KEY ([LicensingID]) REFERENCES [dbo].[LicensingInformation] ([ID])
177GO
178IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 19 is completed with errors' ROLLBACK TRAN END
179GO
180IF @@TRANCOUNT = 0 BEGIN PRINT 'step 19 is completed with errors' SET NOEXEC ON END
181GO
182--step 20: drop columns CartaoIDDados, CartaoIDThumbprint from table dbo.Utilizadores---------------
183ALTER TABLE [dbo].[Utilizadores] DROP COLUMN
184 [CartaoIDDados],
185 [CartaoIDThumbprint]
186GO
187IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 20 is completed with errors' ROLLBACK TRAN END
188GO
189IF @@TRANCOUNT = 0 BEGIN PRINT 'step 20 is completed with errors' SET NOEXEC ON END
190GO
191--step 21: create function dbo.std_string_split-----------------------------------------------------
192GO
193SET QUOTED_IDENTIFIER OFF
194GO
195SET ANSI_NULLS ON
196GO
197CREATE FUNCTION [dbo].[std_string_split]
198(
199 @string nvarchar(max),
200 @delimiter nvarchar(max)
201)
202RETURNS TABLE AS RETURN
203(
204 SELECT
205 ROW_NUMBER ( ) over(order by (select 0)) id -- Not sure if it works correct
206 , Split.a.value('.', 'NVARCHAR(MAX)') value
207 FROM
208 (
209 SELECT CAST('<X>'+REPLACE(@string, @delimiter, '</X><X>')+'</X>' AS XML) AS String
210 ) AS a
211 CROSS APPLY String.nodes('/X') AS Split(a)
212)
213GO
214IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 21 is completed with errors' ROLLBACK TRAN END
215GO
216IF @@TRANCOUNT = 0 BEGIN PRINT 'step 21 is completed with errors' SET NOEXEC ON END
217GO
218--step 22: alter procedure dbo.GCP_EmpresaTemDocumentosEmitidos-------------------------------------
219GO
220SET QUOTED_IDENTIFIER OFF
221GO
222SET ANSI_NULLS ON
223GO
224ALTER PROCEDURE [dbo].[GCP_EmpresaTemDocumentosEmitidos]
225 @Empresa VARCHAR(50),
226 @RecCount AS INT OUTPUT
227AS
228BEGIN
229 DECLARE @SQL AS NVARCHAR(400)
230 DECLARE @RecCountVendas AS INT
231 DECLARE @RecCountCompras AS INT
232 DECLARE @Params AS NVARCHAR(200)
233 DECLARE @Tabela AS NVARCHAR(20)
234 SET @Params = N'@Tabela NVARCHAR(20), @RecCount int OUTPUT'
235 SET @SQL = 'SELECT @RecCount = COUNT(1) FROM PRI' + @Empresa + '.dbo.sysobjects obj '
236 SET @SQL = @SQL + 'INNER JOIN PRI' + @Empresa + '.dbo.syscolumns col ON obj.ID = col.ID '
237 SET @SQL = @SQL + 'WHERE obj.Name = @Tabela '
238 SET @SQL = @SQL + 'AND col.Name = ''Assinatura'' '
239 SET @SQL = @SQL + 'AND obj.xtype= ''U'''
240 EXEC sp_executesql @SQL, @Params, @Tabela = 'CabecDoc', @RecCount = @RecCount OUTPUT
241 SET @RecCountVendas = @RecCount
242 EXEC sp_executesql @SQL, @Params, @Tabela = 'CabecCompras', @RecCount = @RecCount OUTPUT
243 SET @RecCountCompras = @RecCount
244 --Se não existe a coluna na tabela CabecDoc retorna 0
245 IF @RecCountVendas <> 0
246 BEGIN
247
248 SET @Params = N'@RecCount int OUTPUT'
249 SET @SQL = 'SELECT @RecCount = Count(1) FROM(SELECT TOP 1 Existe = 1 FROM PRI' + @Empresa + '.dbo.CabecDoc C WITH(NOLOCK) '
250 SET @SQL = @SQL + 'WHERE LEN(ISNULL(C.Assinatura,'''')) > 0 '
251 IF @RecCountCompras <> 0
252 SET @SQL = @SQL + ' UNION ALL SELECT TOP 1 Existe = 1 FROM PRI' + @Empresa + '.dbo.CabecCompras C WITH(NOLOCK) WHERE LEN(ISNULL(C.Assinatura,'''')) > 0) x'
253 ELSE
254 SET @SQL = @SQL + ') x'
255 EXEC sp_executesql @SQL, @Params, @RecCount OUTPUT
256 END
257 ELSE
258 SET @RecCount = 0
259END
260GO
261IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 22 is completed with errors' ROLLBACK TRAN END
262GO
263IF @@TRANCOUNT = 0 BEGIN PRINT 'step 22 is completed with errors' SET NOEXEC ON END
264GO
265--step 23: drop procedure GCP_ValidaCriacaoSAFT-----------------------------------------------------
266GO
267DROP PROCEDURE [dbo].[GCP_ValidaCriacaoSAFT]
268GO
269IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 23 is completed with errors' ROLLBACK TRAN END
270GO
271IF @@TRANCOUNT = 0 BEGIN PRINT 'step 23 is completed with errors' SET NOEXEC ON END
272GO
273--step 24: drop procedure SAFT_DocumentosExportacao-------------------------------------------------
274GO
275DROP PROCEDURE [dbo].[SAFT_DocumentosExportacao]
276GO
277IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 24 is completed with errors' ROLLBACK TRAN END
278GO
279IF @@TRANCOUNT = 0 BEGIN PRINT 'step 24 is completed with errors' SET NOEXEC ON END
280GO
281--step 25: drop procedure SAFT_DocumentosExportacaoAF-----------------------------------------------
282GO
283DROP PROCEDURE [dbo].[SAFT_DocumentosExportacaoAF]
284GO
285IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 25 is completed with errors' ROLLBACK TRAN END
286GO
287IF @@TRANCOUNT = 0 BEGIN PRINT 'step 25 is completed with errors' SET NOEXEC ON END
288GO
289--step 26: drop procedure SAFT_DocumentosMovimentacao-----------------------------------------------
290GO
291DROP PROCEDURE [dbo].[SAFT_DocumentosMovimentacao]
292GO
293IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 26 is completed with errors' ROLLBACK TRAN END
294GO
295IF @@TRANCOUNT = 0 BEGIN PRINT 'step 26 is completed with errors' SET NOEXEC ON END
296GO
297--step 27: drop procedure SAFT_DocumentosTrabalho---------------------------------------------------
298GO
299DROP PROCEDURE [dbo].[SAFT_DocumentosTrabalho]
300GO
301IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 27 is completed with errors' ROLLBACK TRAN END
302GO
303IF @@TRANCOUNT = 0 BEGIN PRINT 'step 27 is completed with errors' SET NOEXEC ON END
304GO
305--step 28: drop procedure SAFT200_DocumentosExportacao----------------------------------------------
306GO
307DROP PROCEDURE [dbo].[SAFT200_DocumentosExportacao]
308GO
309IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 28 is completed with errors' ROLLBACK TRAN END
310GO
311IF @@TRANCOUNT = 0 BEGIN PRINT 'step 28 is completed with errors' SET NOEXEC ON END
312GO
313--step 29: drop procedure SAFT200_DocumentosExportacaoAF--------------------------------------------
314GO
315DROP PROCEDURE [dbo].[SAFT200_DocumentosExportacaoAF]
316GO
317IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 29 is completed with errors' ROLLBACK TRAN END
318GO
319IF @@TRANCOUNT = 0 BEGIN PRINT 'step 29 is completed with errors' SET NOEXEC ON END
320GO
321--step 30: drop procedure SAFT200_DocumentosMovimentacao--------------------------------------------
322GO
323DROP PROCEDURE [dbo].[SAFT200_DocumentosMovimentacao]
324GO
325IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 30 is completed with errors' ROLLBACK TRAN END
326GO
327IF @@TRANCOUNT = 0 BEGIN PRINT 'step 30 is completed with errors' SET NOEXEC ON END
328GO
329--step 31: drop procedure SAFT200_DocumentosTrabalho------------------------------------------------
330GO
331DROP PROCEDURE [dbo].[SAFT200_DocumentosTrabalho]
332GO
333IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 31 is completed with errors' ROLLBACK TRAN END
334GO
335IF @@TRANCOUNT = 0 BEGIN PRINT 'step 31 is completed with errors' SET NOEXEC ON END
336GO
337--step 32: alter procedure dbo.STD_EmpresaTemAtividadeLegal-----------------------------------------
338GO
339SET QUOTED_IDENTIFIER OFF
340GO
341SET ANSI_NULLS ON
342GO
343ALTER PROCEDURE [dbo].[STD_EmpresaTemAtividadeLegal] (@Empresa varchar(50))
344AS
345BEGIN
346 DECLARE @AtividadeLegal bit
347 SET @AtividadeLegal = 0
348 -- GCP - Determinar se a empresa tem documentos emitidos
349 DECLARE @DocsEmitidos int
350 Exec GCP_EmpresaTemDocumentosEmitidos @Empresa, @DocsEmitidos output
351 -- Efetuar as condições necessárias para determinar se existe atividade legal com base na execução das Sps anteriores
352 if @DocsEmitidos>0
353 BEGIN
354 SET @AtividadeLegal = 1
355 END
356 SELECT @AtividadeLegal
357END
358GO
359IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 32 is completed with errors' ROLLBACK TRAN END
360GO
361IF @@TRANCOUNT = 0 BEGIN PRINT 'step 32 is completed with errors' SET NOEXEC ON END
362GO
363--step 33: alter procedure dbo.STD_EnableAllConstraints---------------------------------------------
364GO
365SET QUOTED_IDENTIFIER OFF
366GO
367SET ANSI_NULLS ON
368GO
369ALTER PROCEDURE [dbo].[STD_EnableAllConstraints]
370AS
371DECLARE @TblName varchar(100)
372DECLARE @ConstName varchar(100)
373DECLARE constraints CURSOR FOR SELECT fk.name as chave, so.name as tabela FROM sys.Foreign_keys fk INNER JOIN sysobjects so ON SO.id = fk.Parent_object_id WHERE so.type = 'U'
374OPEN constraints
375FETCH NEXT FROM constraints
376into @ConstName, @TblName
377WHILE @@FETCH_STATUS = 0
378BEGIN
379
380 BEGIN TRY
381 EXEC('ALTER TABLE [' + @TblName + '] CHECK CONSTRAINT ' + @ConstName)
382 END TRY
383 BEGIN CATCH
384 print ERROR_MESSAGE()
385 END CATCH
386
387 FETCH NEXT FROM constraints
388 into @ConstName, @TblName
389END
390CLOSE constraints
391DEALLOCATE constraints
392GO
393IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 33 is completed with errors' ROLLBACK TRAN END
394GO
395IF @@TRANCOUNT = 0 BEGIN PRINT 'step 33 is completed with errors' SET NOEXEC ON END
396GO
397--step 34: alter procedure dbo.STD_ExpressCriaFavoritosDefault--------------------------------------
398GO
399SET QUOTED_IDENTIFIER OFF
400GO
401SET ANSI_NULLS ON
402GO
403-------------------------------------------------------------------------------
404-- PRIEMPRE
405-- Script para correcção do PRIEMPRE
406-- Implementa TODAS as correccoes da versao 782 --> 783
407-- VERSAO: 783
408-------------------------------------------------------------------------------
409ALTER PROCEDURE [dbo].[STD_ExpressCriaFavoritosDefault]
410 @user varchar(20) = null
411AS
412BEGIN
413 SET NOCOUNT ON;
414 --Portugal default navigators
415 declare @defaultConfigPortugal_PT as nvarchar(4000); set @defaultConfigPortugal_PT = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Criar/Alterar Clientes</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Criar/Alterar Artigos</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Movimentar Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Registar Vendas/Cotações</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Registar Recebimentos</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Analisar Vendas</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventário</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Ligações úteis</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Ajuda</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Site Comunidade PRIMAVERA</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE215A50CA5E1511E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Suporte Técnico</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE215A50CA5E1511E1BC34D92F1F4EEE8C><CHAVE5067BA1D5E0711E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>Portal PRIMAVERA Starter Easy</TITULO><EXECUTAR>http://www.primaverabss.com/easy</EXECUTAR></CHAVE5067BA1D5E0711E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
416 declare @defaultConfigPortugal_ES as nvarchar(4000); set @defaultConfigPortugal_ES = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Crear/Modificar Clientes</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Crear/Modificar Artículos</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Gestionar Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Registrar Ventas/Ofertas</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Registrar Cobros</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Analizar Ventas</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventario</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Enlaces útiles</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Ayuda</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Site Comunidad PRIMAVERA</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Soporte Técnico</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C><CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>Portal PRIMAVERA Starter Easy</TITULO><EXECUTAR>http://www.primaverabss.com/easy</EXECUTAR></CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
417 declare @defaultConfigPortugal_UK as nvarchar(4000); set @defaultConfigPortugal_UK = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Create/Update Customers</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Create/Update Items</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Manage Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Register Sales/Quotes</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Register Receivables</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Sales Analisis</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventory</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Useful links</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Help</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>PRIMAVERA Comunity Site</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Helpdesk</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C><CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>PRIMAVERA Starter Easy Portal</TITULO><EXECUTAR>http://www.primaverabss.com/easy</EXECUTAR></CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
418
419 --Default navigators for spain
420 declare @defaultConfigSpain_PT as nvarchar(4000); set @defaultConfigSpain_PT = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Criar/Alterar Clientes</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Criar/Alterar Artigos</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Movimentar Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Registar Vendas/Cotações</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Registar Recebimentos</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Analisar Vendas</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventário</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Ligações úteis</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Ajuda</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Site Comunidade PRIMAVERA</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE215A50CA5E1511E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Suporte Técnico</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE215A50CA5E1511E1BC34D92F1F4EEE8C><CHAVE5067BA1D5E0711E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>Site PRIMAVERA Express</TITULO><EXECUTAR>http://www.primaverabss.com/es/PortalRender.aspx?PageID={89b18dc1-446c-11dd-ba62-0003fff8f872}</EXECUTAR></CHAVE5067BA1D5E0711E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
421 declare @defaultConfigSpain_ES as nvarchar(4000); set @defaultConfigSpain_ES = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Crear/Modificar Clientes</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Crear/Modificar Artículos</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Gestionar Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Registrar Ventas/Ofertas</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Registrar Cobros</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Analizar Ventas</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventario</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Enlaces útiles</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Ayuda</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Site Comunidad PRIMAVERA</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Soporte Técnico</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C><CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>Site PRIMAVERA Express</TITULO><EXECUTAR>http://www.primaverabss.com/es/PortalRender.aspx?PageID={89b18dc1-446c-11dd-ba62-0003fff8f872}</EXECUTAR></CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
422 declare @defaultConfigSpain_UK as nvarchar(4000); set @defaultConfigSpain_UK = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Create/Update Customers</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Create/Update Items</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Manage Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Register Sales/Quotes</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Register Receivables</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Sales Analisis</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventory</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Useful links</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Help</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>PRIMAVERA Comunity Site</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Helpdesk</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C><CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>Site PRIMAVERA Express</TITULO><EXECUTAR>http://www.primaverabss.com/es/PortalRender.aspx?PageID={89b18dc1-446c-11dd-ba62-0003fff8f872}</EXECUTAR></CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
423 --Default navigators for africa
424 declare @defaultConfigAfrica_PT as nvarchar(4000); set @defaultConfigAfrica_PT = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Criar/Alterar Clientes</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Criar/Alterar Artigos</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Movimentar Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Registar Vendas/Cotações</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Registar Recebimentos</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Analisar Vendas</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventário</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Ligações úteis</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Ajuda</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Site Comunidade PRIMAVERA</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE215A50CA5E1511E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Suporte Técnico</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE215A50CA5E1511E1BC34D92F1F4EEE8C><CHAVE5067BA1D5E0711E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>Site PRIMAVERA Express</TITULO><EXECUTAR>http://www.primaverabss.com/afr/PRIMAVERAEXPRESS.aspx</EXECUTAR></CHAVE5067BA1D5E0711E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
425 declare @defaultConfigAfrica_ES as nvarchar(4000); set @defaultConfigAfrica_ES = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Crear/Modificar Clientes</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Crear/Modificar Artículos</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Gestionar Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Registrar Ventas/Ofertas</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Registrar Cobros</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Analizar Ventas</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventario</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Enlaces útiles</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Ayuda</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Site Comunidad PRIMAVERA</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Soporte Técnico</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C><CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>Site PRIMAVERA Express</TITULO><EXECUTAR>http://www.primaverabss.com/afr/PRIMAVERAEXPRESS.aspx</EXECUTAR></CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
426 declare @defaultConfigAfrica_UK as nvarchar(4000); set @defaultConfigAfrica_UK = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Create/Update Customers</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Create/Update Items</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Manage Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Register Sales/Quotes</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Register Receivables</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Sales Analisis</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventory</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Useful links</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Help</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>PRIMAVERA Comunity Site</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Helpdesk</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C><CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C TIPO="URL"><TITULO>Site PRIMAVERA Express</TITULO><EXECUTAR>http://www.primaverabss.com/afr/PRIMAVERAEXPRESS.aspx</EXECUTAR></CHAVEE890DF045E1B11E1BC34D92F1F4EEE8C></CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C></NAVEGADOR>'
427
428 --Default navigators for other countries
429 declare @defaultConfigOthers_PT as nvarchar(4000); set @defaultConfigOthers_PT = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Criar/Alterar Clientes</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Criar/Alterar Artigos</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Movimentar Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Registar Vendas/Cotações</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Registar Recebimentos</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Analisar Vendas</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventário</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Ligações úteis</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Ajuda</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Site Comunidade PRIMAVERA</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE215A50CA5E1511E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Suporte Técnico</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></NAVEGADOR>'
430 declare @defaultConfigOthers_ES as nvarchar(4000); set @defaultConfigOthers_ES = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Crear/Modificar Clientes</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Crear/Modificar Artículos</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Gestionar Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Registrar Ventas/Ofertas</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Registrar Cobros</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Analizar Ventas</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventario</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Enlaces útiles</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Ayuda</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Site Comunidad PRIMAVERA</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Soporte Técnico</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></NAVEGADOR>'
431 declare @defaultConfigOthers_UK as nvarchar(4000); set @defaultConfigOthers_UK = '<NAVEGADOR><CHAVED23983015DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>1. Create/Update Customers</TITULO><EXECUTAR>barraVND||GCP$mnuTabClientes</EXECUTAR></CHAVED23983015DFE11E1BC34D92F1F4EEE8C><CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>2. Create/Update Items</TITULO><EXECUTAR>barraINV||GCP$mnuTabArtigo</EXECUTAR></CHAVEEE0F02C75DFE11E1BC34D92F1F4EEE8C><CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>3. Manage Stock</TITULO><EXECUTAR>barraINV||GCP$mnuDocStk</EXECUTAR></CHAVE0620DCC05DFF11E1BC34D92F1F4EEE8C><CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>4. Register Sales/Quotes</TITULO><EXECUTAR>barraVND||GCP$mnuDocVnd</EXECUTAR></CHAVE14E87ED75DFF11E1BC34D92F1F4EEE8C><CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>5. Register Receivables</TITULO><EXECUTAR>barraTES||submnuTabPagamentosRecebimentos||GCP$mnuDocCCOperacoes</EXECUTAR></CHAVE516B7E6A5DFF11E1BC34D92F1F4EEE8C><CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>6. Sales Analisis</TITULO><EXECUTAR>barraVND||GCP$submnuVendExploracao||GCP$submnuVendExpVendas||GCP$mnuExpResVnd</EXECUTAR></CHAVE7930484C5DFF11E1BC34D92F1F4EEE8C><CHAVE867515495DFF11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>7. Inventory</TITULO><EXECUTAR>barraINV||GCP$submnuInvExploracao||GCP$mnuExpStkInventario</EXECUTAR></CHAVE867515495DFF11E1BC34D92F1F4EEE8C><CHAVEF980FE585DFF11E1BC34D92F1F4EEE8C TIPO="PST" EXP="1"><TITULO>Useful links</TITULO><CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Help</TITULO><EXECUTAR>mnuStdAjudaIndice</EXECUTAR></CHAVEF0A366D35E0611E1BC34D92F1F4EEE8C><CHAVE066E342C5E0011E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>PRIMAVERA Comunity Site</TITULO><EXECUTAR>mnuStdAjudaPortal</EXECUTAR></CHAVE066E342C5E0011E1BC34D92F1F4EEE8C><CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C TIPO="MEN"><TITULO>Helpdesk</TITULO><EXECUTAR>mnuStdAjudaSuporte</EXECUTAR></CHAVE7535753B5E1B11E1BC34D92F1F4EEE8C></NAVEGADOR>'
432 -- Variables
433 declare @Company as varchar(10)
434 declare @CompanyLocale as smallint
435 declare @UserLanguage as int
436 declare @defaultConfig as nvarchar(4000)
437 declare @CreateNewConfig as bit
438 declare @sql as nvarchar(4000)
439
440
441 --For each company, create the user default navigator acordingly to the company location and the user language
442 declare CompanyCursor cursor for select Codigo Company, IFLocalizacaoSede CompanyLocale from empresas
443
444 open CompanyCursor
445
446 fetch next from CompanyCursor into @Company,@CompanyLocale
447
448 while @@FETCH_STATUS = 0
449 begin
450 --Valida se a base de dados existe (Cenário: Estão registadas empresas no PRIEMPRE mas não existem as respectivas BD's)
451 if exists(select * from sys.databases where name = '@@Company@@')
452 begin
453 -- Check if the navigator config already exists
454 -- Use Dynamic SQL (due to the database iteration)
455 set @sql = '
456 set @CreateNewConfig=0
457 if not exists (select * from PRI@@Company@@.dbo.navegador where apl=''ERP'' and isnull(utilizador,'''') = isnull(@user,''''))
458 begin
459 set @CreateNewConfig=1
460 end'
461 set @sql = replace(@sql,'@@Company@@',@Company)
462 exec sp_executesql @query = @sql
463, @params = N'@user varchar(20),@CreateNewConfig bit output'
464, @User = @User
465, @CreateNewConfig = @CreateNewConfig output
466
467 -- Start creating the configuration
468 if (@CreateNewConfig=1)
469 begin
470
471 --Get the user language
472 select @UserLanguage = Idioma from Utilizadores where Codigo=@User
473
474 set @defaultConfig =
475 case
476 -- Portuguese company (Azores and Madeira included)
477 when (@CompanyLocale=1 or @CompanyLocale=2 or @CompanyLocale=3) then
478 case
479 --Portuguese | Spanish or other language
480 when isnull(@UserLanguage,-1) in (-1,2070,1046) then @defaultConfigPortugal_PT
481 when isnull(@UserLanguage,-1) = 3082 then @defaultConfigPortugal_ES
482 else @defaultConfigPortugal_UK
483 end
484 -- Spanish company
485 when @CompanyLocale=9 then
486 case
487 --Portuguese | Spanish or other language
488 when isnull(@UserLanguage,-1) in (-1,2070,1046) then @defaultConfigSpain_PT
489 when isnull(@UserLanguage,-1) = 3082 then @defaultConfigSpain_ES
490 else @defaultConfigSpain_UK
491 end
492 -- Africa companies
493 when (@CompanyLocale=4 or @CompanyLocale=5) then
494 case
495 --Portuguese | Spanish or other language
496 when isnull(@UserLanguage,-1) in (-1,2070,1046) then @defaultConfigAfrica_PT
497 when isnull(@UserLanguage,-1) = 3082 then @defaultConfigAfrica_ES
498 else @defaultConfigAfrica_UK
499 end
500 -- Other country company
501 else
502 case
503 --Portuguese | Spanish or other language
504 when isnull(@UserLanguage,-1) in (-1,2070,1046) then @defaultConfigOthers_PT
505 when isnull(@UserLanguage,-1) = 3082 then @defaultConfigOthers_ES
506 else @defaultConfigOthers_UK
507 end
508 end
509 -- Insert the default navigator
510 -- Use Dynamic SQL (due to the database iteration)
511 set @sql = '
512 insert into PRI@@Company@@.dbo.navegador (Guid,Apl,Utilizador,Configuracao)
513 values (newid(),''ERP'',@user,@defaultConfig)'
514 set @sql = replace(@sql,'@@Company@@',@Company)
515 exec sp_executesql @query = @sql
516 , @params = N'@user varchar(20),@defaultConfig nvarchar(4000)'
517 , @user = @user
518 , @defaultConfig = @defaultConfig
519 end
520 end
521 -- next cursor
522 fetch next from CompanyCursor
523 into @Company,@CompanyLocale
524 end
525 close CompanyCursor
526 deallocate CompanyCursor
527END
528GO
529IF @@ERROR <> 0 AND @@TRANCOUNT > 0 BEGIN PRINT 'step 34 is completed with errors' ROLLBACK TRAN END
530GO
531IF @@TRANCOUNT = 0 BEGIN PRINT 'step 34 is completed with errors' SET NOEXEC ON END
532GO
533----------------------------------------------------------------------
534IF @@TRANCOUNT > 0 BEGIN COMMIT TRAN PRINT 'Synchronization is successfully completed.' END
535GO
536SET NOEXEC OFF
537GO
538
539/*
540Script created by SQL Data Examiner 7.1.8.293 at 21-01-2021 11:50:06.
541Run this script on BRUNO-MIG\SQL2017.PRIEMPRE_SR to make it the same as BRUNO-MIG\SQL2017.PRIEMPRE
542*/
543BEGIN TRANSACTION
544
545BEGIN TRY
546
547
548--Deleting data from [dbo].[Versao] (1 records)
549DELETE [dbo].[Versao] WHERE ([Versao] = N'PS.07.81044.0000')
550
551--Deleting data from [dbo].[VersaoDFP] (1 records)
552DELETE [dbo].[VersaoDFP] WHERE ([Versao] = N'09.02')
553
554--Updating [dbo].[VersaoModulo] (27 records)
555UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.19' WHERE [Modulo] = N'BAS'
556UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.19' WHERE [Modulo] = N'CBL'
557UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.28' WHERE [Modulo] = N'CCT'
558UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.17' WHERE [Modulo] = N'CMP'
559UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'CNO'
560UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'COM'
561UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.09' WHERE [Modulo] = N'COP'
562UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'CRM'
563UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'DFP'
564UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.05' WHERE [Modulo] = N'EAP'
565UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'FAC'
566UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'FIL'
567UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'GAB'
568UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'GCP'
569UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.06' WHERE [Modulo] = N'GPR'
570UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'IAM'
571UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.14' WHERE [Modulo] = N'INT'
572UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.44' WHERE [Modulo] = N'INV'
573UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.08' WHERE [Modulo] = N'ORC'
574UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.05' WHERE [Modulo] = N'PCM'
575UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.07' WHERE [Modulo] = N'PRJ'
576UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.07' WHERE [Modulo] = N'RHP'
577UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.20' WHERE [Modulo] = N'SAF'
578UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'STP'
579UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.08' WHERE [Modulo] = N'TES'
580UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.00' WHERE [Modulo] = N'TTE'
581UPDATE [dbo].[VersaoModulo] SET [Versao] = N'10.24' WHERE [Modulo] = N'VND'
582
583--Inserting data into [dbo].[VersaoDFP] (1 records)
584INSERT INTO [dbo].[VersaoDFP]([Versao]) VALUES (N'07.12')
585
586--Inserting data into [dbo].[Versao] (1 records)
587INSERT INTO [dbo].[Versao]([Versao]) VALUES (N'PS.07.81072.0000')
588
589
590--End of transaction
591PRINT 'Commit synchronization.'
592COMMIT TRANSACTION
593
594END TRY
595BEGIN CATCH
596 --If during synchronization process an error occurred then the following code will be executed
597 if @@error <> 0 AND @@trancount > 0
598 BEGIN
599 DECLARE @EX_ERROR_MESSAGE nvarchar(MAX), @STATE int, @SEVERITY int
600 SELECT @EX_ERROR_MESSAGE =
601 'An error occurred:' + char(13) + char(10)
602 + 'Msg ' + cast( ERROR_NUMBER() as nvarchar(20) )
603 + ', Level ' + cast( ERROR_SEVERITY() as nvarchar(20) )
604 + ', State ' + cast( ERROR_STATE() as nvarchar(20) )
605 + ', Line ' + cast( ERROR_LINE() as nvarchar(20) ) + char(13) + char(10)
606 + ERROR_MESSAGE() + char(13) + char(10),
607 @SEVERITY = ERROR_SEVERITY(),
608 @STATE = ERROR_STATE()
609 RAISERROR(@EX_ERROR_MESSAGE, @SEVERITY, @STATE)
610 END
611 ROLLBACK TRAN
612 PRINT 'Data synchronization is completed with errors, all changes were cancelled'
613END CATCH