u7u5pqnB

1/**************************************************************************
2-- -Generated by xSQL SDK for Schema Comparison and Synchronization
3-- -Date/Time: January 12, 2012 17:27:54
4
5-- -Summary:
6    Contains the T-SQL script that makes the database 
7    svr-nlpg01\sqlexpress.Howslow the same as the database svr-nlpg01\sqlexpress.4.2
8
9-- -Action:
10    Execute this script on svr-nlpg01\sqlexpress.Howslow
11
12-- -SQL Server version: 10.0.1600
13**************************************************************************/
14
15
16/**************************************************************************
17Warnings:
18Table dbo.ADMIN_AREA_NAME will be altered with an intermediate table.
19Table dbo.ADTNLSTR will be altered with an intermediate table.
20Table dbo.ALIASINFO will be altered with an intermediate table.
21Table dbo.ALT_STREET_LPI will be altered with an intermediate table.
22Table dbo.BLPU will be altered with an intermediate table.
23Table dbo.BLPU_CANDIDATE will be altered with an intermediate table.
24Table dbo.BLPU_CLASS will be altered with an intermediate table.
25Table dbo.BLPU_CLASSIFICATION will be altered with an intermediate table.
26Table dbo.Candidate_TFI will be altered with an intermediate table.
27Table dbo.Candidate_TFI_ARCHIVE will be altered with an intermediate table.
28Table dbo.ESU will be altered with an intermediate table.
29Table dbo.EXPORT_DATES will be altered with an intermediate table.
30Table dbo.EXPORTDATES_TFIOLD will be altered with an intermediate table.
31Table dbo.HWW will be altered with an intermediate table.
32Table dbo.LAND_AND_PROPERTY_IDENTIFIER will be altered with an intermediate table.
33Table dbo.LOCALITY will be altered with an intermediate table.
34Table dbo.LPI_CANDIDATE will be altered with an intermediate table.
35Table dbo.NODE will be altered with an intermediate table.
36Table dbo.ORGANISATION will be altered with an intermediate table.
37Table dbo.REINSTDS will be altered with an intermediate table.
38Table dbo.SPCLDSG will be altered with an intermediate table.
39Table dbo.STREET_SP will be altered with an intermediate table.
40Table dbo.SUCCESSOR_XREF will be altered with an intermediate table.
41Table dbo.TFI will be altered with an intermediate table.
42Table dbo.TOWN will be altered with an intermediate table.
43Table dbo.TRANSFER_FILE_IMAGE will be altered with an intermediate table.
44Table dbo.TRANSFER_FILE_IMAGE_ARCHIVE will be altered with an intermediate table.
45**************************************************************************/
46
47
48BEGIN TRANSACTION
49	SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
50	SET QUOTED_IDENTIFIER ON
51	SET ANSI_NULLS ON
52	SET ANSI_PADDING ON
53	SET ANSI_WARNINGS ON
54	SET ARITHABORT ON
55	SET NUMERIC_ROUNDABORT OFF
56	SET CONCAT_NULL_YIELDS_NULL ON
57	SET XACT_ABORT ON
58COMMIT TRANSACTION
59GO
60
61IF EXISTS (select * from tempdb..sysobjects where id = OBJECT_ID('tempdb..#ErrorLog')) 
62	DROP TABLE #ErrorLog 
63CREATE TABLE #ErrorLog 
64( pkid [int] IDENTITY(1,1) NOT NULL, errno [int] NOT NULL, errdescr [varchar](100) NULL )
65GO
66
67IF @@TRANCOUNT=0 BEGIN TRANSACTION
68GO
69DROP TABLE [dbo].[ADDRESS_SEARCH]
70GO
71IF @@ERROR<>0 
72Begin
73	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
74	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to drop table dbo.ADDRESS_SEARCH')
75END
76GO
77
78IF @@TRANCOUNT=0 BEGIN TRANSACTION
79GO
80CREATE USER [GGP\billp] FOR LOGIN [GGP\billp] WITH DEFAULT_SCHEMA=[dbo]
81GO
82
83IF @@ERROR<>0 
84Begin
85	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
86	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add user GGP\billp')
87END
88GO
89IF @@TRANCOUNT=0 BEGIN TRANSACTION
90GO
91SET ANSI_NULLS ON
92GO
93SET QUOTED_IDENTIFIER ON
94GO
95
96CREATE TABLE [dbo].[tmp_ADMIN_AREA_NAME] (
97	[AAN_REF] [int] IDENTITY (1,1) NOT NULL,
98	[AAN_DESCRIPTION] [varchar](30) COLLATE Latin1_General_CI_AS NULL,
99	[TYPE] [varchar](1) COLLATE Latin1_General_CI_AS NULL
100) ON [PRIMARY]
101
102IF @@ERROR<>0 
103Begin
104	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
105	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ADMIN_AREA_NAME')
106END
107GO
108SET IDENTITY_INSERT [dbo].[tmp_ADMIN_AREA_NAME] ON
109IF EXISTS (SELECT * FROM [dbo].[ADMIN_AREA_NAME])
110	EXEC
111	('
112		INSERT INTO [dbo].[tmp_ADMIN_AREA_NAME] ([AAN_REF],[AAN_DESCRIPTION],[TYPE])
113		SELECT [AAN_REF],[AAN_DESCRIPTION],[TYPE] FROM [dbo].[ADMIN_AREA_NAME] TABLOCKX
114	')
115IF @@ERROR<>0 
116Begin
117	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
118	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ADMIN_AREA_NAME')
119END
120GO
121SET IDENTITY_INSERT [dbo].[tmp_ADMIN_AREA_NAME] OFF
122
123DROP TABLE [dbo].[ADMIN_AREA_NAME]
124GO
125IF @@ERROR<>0 
126Begin
127	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
128	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ADMIN_AREA_NAME')
129END
130GO
131EXECUTE sp_rename N'[dbo].[tmp_ADMIN_AREA_NAME]', N'ADMIN_AREA_NAME', 'OBJECT'
132
133IF @@ERROR<>0 
134Begin
135	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
136	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ADMIN_AREA_NAME')
137END
138GO
139
140IF @@TRANCOUNT=0 BEGIN TRANSACTION
141GO
142SET ANSI_NULLS ON
143GO
144SET QUOTED_IDENTIFIER ON
145GO
146
147CREATE TABLE [dbo].[tmp_ADTNLSTR] (
148	[APGRECNO] [bigint] IDENTITY (1,1) NOT NULL,
149	[UPDDATE] [datetime] NULL,
150	[USRN] [varchar](8) COLLATE Latin1_General_CI_AS NULL,
151	[SEQNUM] [numeric](3,0) NULL,
152	[RSCCODE] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
153	[WHOLEROAD] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
154	[LOCTEXT] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
155	[SWACODE] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
156	[GEOMETRY] [geometry] NULL
157) ON [PRIMARY]
158
159IF @@ERROR<>0 
160Begin
161	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
162	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ADTNLSTR')
163END
164GO
165SET IDENTITY_INSERT [dbo].[tmp_ADTNLSTR] ON
166IF EXISTS (SELECT * FROM [dbo].[ADTNLSTR])
167	EXEC
168	('
169		INSERT INTO [dbo].[tmp_ADTNLSTR] ([APGRECNO],[UPDDATE],[USRN],[SEQNUM],[RSCCODE],[WHOLEROAD],[LOCTEXT],[SWACODE],[GEOMETRY])
170		SELECT [APGRECNO],[UPDDATE],[USRN],[SEQNUM],[RSCCODE],[WHOLEROAD],[LOCTEXT],[SWACODE],[GEOMETRY] FROM [dbo].[ADTNLSTR] TABLOCKX
171	')
172IF @@ERROR<>0 
173Begin
174	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
175	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ADTNLSTR')
176END
177GO
178SET IDENTITY_INSERT [dbo].[tmp_ADTNLSTR] OFF
179
180DROP TABLE [dbo].[ADTNLSTR]
181GO
182IF @@ERROR<>0 
183Begin
184	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
185	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ADTNLSTR')
186END
187GO
188EXECUTE sp_rename N'[dbo].[tmp_ADTNLSTR]', N'ADTNLSTR', 'OBJECT'
189
190IF @@ERROR<>0 
191Begin
192	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
193	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ADTNLSTR')
194END
195GO
196
197IF @@TRANCOUNT=0 BEGIN TRANSACTION
198GO
199SET ANSI_NULLS ON
200GO
201SET QUOTED_IDENTIFIER ON
202GO
203
204CREATE TABLE [dbo].[tmp_ALIASINFO] (
205	[ALIAS_ID] [int] IDENTITY (1,1) NOT NULL,
206	[NAME] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
207	[ALIAS_NAME] [varchar](500) COLLATE Latin1_General_CI_AS NULL,
208	[ALIASTYPE] [varchar](4) COLLATE Latin1_General_CI_AS NULL
209) ON [PRIMARY]
210
211IF @@ERROR<>0 
212Begin
213	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
214	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ALIASINFO')
215END
216GO
217SET IDENTITY_INSERT [dbo].[tmp_ALIASINFO] ON
218IF EXISTS (SELECT * FROM [dbo].[ALIASINFO])
219	EXEC
220	('
221		INSERT INTO [dbo].[tmp_ALIASINFO] ([ALIAS_ID],[NAME],[ALIAS_NAME],[ALIASTYPE])
222		SELECT [ALIAS_ID],[NAME],[ALIAS_NAME],[ALIASTYPE] FROM [dbo].[ALIASINFO] TABLOCKX
223	')
224IF @@ERROR<>0 
225Begin
226	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
227	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ALIASINFO')
228END
229GO
230SET IDENTITY_INSERT [dbo].[tmp_ALIASINFO] OFF
231
232DROP TABLE [dbo].[ALIASINFO]
233GO
234IF @@ERROR<>0 
235Begin
236	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
237	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ALIASINFO')
238END
239GO
240EXECUTE sp_rename N'[dbo].[tmp_ALIASINFO]', N'ALIASINFO', 'OBJECT'
241
242IF @@ERROR<>0 
243Begin
244	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
245	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ALIASINFO')
246END
247GO
248
249IF @@TRANCOUNT=0 BEGIN TRANSACTION
250GO
251SET ANSI_NULLS ON
252GO
253SET QUOTED_IDENTIFIER ON
254GO
255
256CREATE TABLE [dbo].[tmp_ALT_STREET_LPI] (
257	[ALT_LPI] [int] IDENTITY (1,1) NOT NULL,
258	[LPI_UNIQUE] [int] NOT NULL,
259	[UPRN] [float] NULL,
260	[USRN] [int] NULL
261) ON [PRIMARY]
262
263IF @@ERROR<>0 
264Begin
265	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
266	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ALT_STREET_LPI')
267END
268GO
269SET IDENTITY_INSERT [dbo].[tmp_ALT_STREET_LPI] ON
270IF EXISTS (SELECT * FROM [dbo].[ALT_STREET_LPI])
271	EXEC
272	('
273		INSERT INTO [dbo].[tmp_ALT_STREET_LPI] ([ALT_LPI],[LPI_UNIQUE],[UPRN],[USRN])
274		SELECT [ALT_LPI],[LPI_UNIQUE],[UPRN],[USRN] FROM [dbo].[ALT_STREET_LPI] TABLOCKX
275	')
276IF @@ERROR<>0 
277Begin
278	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
279	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ALT_STREET_LPI')
280END
281GO
282SET IDENTITY_INSERT [dbo].[tmp_ALT_STREET_LPI] OFF
283
284DROP TABLE [dbo].[ALT_STREET_LPI]
285GO
286IF @@ERROR<>0 
287Begin
288	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
289	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ALT_STREET_LPI')
290END
291GO
292EXECUTE sp_rename N'[dbo].[tmp_ALT_STREET_LPI]', N'ALT_STREET_LPI', 'OBJECT'
293
294IF @@ERROR<>0 
295Begin
296	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
297	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ALT_STREET_LPI')
298END
299GO
300
301IF @@TRANCOUNT=0 BEGIN TRANSACTION
302GO
303SET ANSI_NULLS ON
304GO
305SET QUOTED_IDENTIFIER ON
306GO
307
308CREATE TABLE [dbo].[tmp_BLPU] (
309	[APGRECNO] [bigint] IDENTITY (1,1) NOT NULL,
310	[UPDDATE] [datetime] NULL,
311	[UPRN] [varchar](12) COLLATE Latin1_General_CI_AS NULL,
312	[DISPLAYFLG] [numeric](1,0) NULL,
313	[LOG_STATUS] [varchar](2) COLLATE Latin1_General_CI_AS NULL,
314	[PROP_TYPE] [varchar](2) COLLATE Latin1_General_CI_AS NULL,
315	[PROV_CODE] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
316	[CAN_KEY] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
317	[XREFKEY] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
318	[PAON] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
319	[SAON] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
320	[STREETNAME] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
321	[LOCALITY] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
322	[STREETTOWN] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
323	[POSTTOWN] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
324	[COUNTY] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
325	[POSTCODE] [varchar](10) COLLATE Latin1_General_CI_AS NULL,
326	[WARDCODE] [varchar](6) COLLATE Latin1_General_CI_AS NULL,
327	[PARISHCODE] [varchar](7) COLLATE Latin1_General_CI_AS NULL,
328	[WARDNAME] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
329	[PARISHNAME] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
330	[BLPUCLASS] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
331	[POSTALADR] [text] COLLATE Latin1_General_CI_AS NULL,
332	[GEOMETRY] [geometry] NULL
333) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
334
335IF @@ERROR<>0 
336Begin
337	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
338	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU')
339END
340GO
341SET IDENTITY_INSERT [dbo].[tmp_BLPU] ON
342IF EXISTS (SELECT * FROM [dbo].[BLPU])
343	EXEC
344	('
345		INSERT INTO [dbo].[tmp_BLPU] ([APGRECNO],[UPDDATE],[UPRN],[DISPLAYFLG],[LOG_STATUS],[PROP_TYPE],[PROV_CODE],[CAN_KEY],[XREFKEY],[PAON],[SAON],[STREETNAME],[LOCALITY],[STREETTOWN],[POSTTOWN],[COUNTY],[POSTCODE],[WARDCODE],[PARISHCODE],[WARDNAME],[PARISHNAME],[BLPUCLASS],[POSTALADR],[GEOMETRY])
346		SELECT [APGRECNO],[UPDDATE],[UPRN],[DISPLAYFLG],[LOG_STATUS],[PROP_TYPE],[PROV_CODE],[CAN_KEY],[XREFKEY],[PAON],[SAON],[STREETNAME],[LOCALITY],[STREETTOWN],[POSTTOWN],[COUNTY],[POSTCODE],[WARDCODE],[PARISHCODE],[WARDNAME],[PARISHNAME],[BLPUCLASS],[POSTALADR],[GEOMETRY] FROM [dbo].[BLPU] TABLOCKX
347	')
348IF @@ERROR<>0 
349Begin
350	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
351	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU')
352END
353GO
354SET IDENTITY_INSERT [dbo].[tmp_BLPU] OFF
355
356DROP TABLE [dbo].[BLPU]
357GO
358IF @@ERROR<>0 
359Begin
360	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
361	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU')
362END
363GO
364EXECUTE sp_rename N'[dbo].[tmp_BLPU]', N'BLPU', 'OBJECT'
365
366IF @@ERROR<>0 
367Begin
368	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
369	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU')
370END
371GO
372
373IF @@TRANCOUNT=0 BEGIN TRANSACTION
374GO
375SET ANSI_NULLS ON
376GO
377SET QUOTED_IDENTIFIER ON
378GO
379
380CREATE TABLE [dbo].[tmp_BLPU_CANDIDATE] (
381	[BLPU_CANDIDATE_ID] [int] IDENTITY (1,1) NOT NULL,
382	[UPRN] [float] NULL,
383	[CUSTODIAN_CODE] [int] NOT NULL,
384	[XREF] [decimal](10,2) NULL,
385	[YREF] [decimal](10,2) NULL,
386	[LOGICAL_STATUS] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
387	[REP_POINT_CODE] [int] NULL,
388	[START_DATE] [datetime] NULL,
389	[END_DATE] [datetime] NULL,
390	[ENTRY_DATE] [datetime] NULL,
391	[LAST_UPDATE_DATE] [datetime] NULL,
392	[BLPUSTATE] [int] NULL,
393	[BLPU_STATE_DATE] [datetime] NULL,
394	[BLPU_CLASS] [varchar](4) COLLATE Latin1_General_CI_AS NULL,
395	[PARENT_UPRN] [float] NULL,
396	[ORGANISATION] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
397	[WARDCODE] [varchar](6) COLLATE Latin1_General_CI_AS NULL,
398	[PARISHCODE] [varchar](7) COLLATE Latin1_General_CI_AS NULL,
399	[CUSTODIANONE] [int] NULL,
400	[CUSTODIANTWO] [int] NULL,
401	[CAN_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
402	[REQUEST_SOURCE] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
403	[CANDIDATE_FLAG] [varchar](3) COLLATE Latin1_General_CI_AS NULL,
404	[NOTES] [varchar](4000) COLLATE Latin1_General_CI_AS NULL,
405	[NEWUNIQUEID] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
406	[REQUEST_SOURCE_ID] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
407	[USER_NAME] [varchar](50) COLLATE Latin1_General_CI_AS NULL
408) ON [PRIMARY]
409
410IF @@ERROR<>0 
411Begin
412	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
413	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CANDIDATE')
414END
415GO
416SET IDENTITY_INSERT [dbo].[tmp_BLPU_CANDIDATE] ON
417IF EXISTS (SELECT * FROM [dbo].[BLPU_CANDIDATE])
418	EXEC
419	('
420		INSERT INTO [dbo].[tmp_BLPU_CANDIDATE] ([BLPU_CANDIDATE_ID],[UPRN],[CUSTODIAN_CODE],[XREF],[YREF],[LOGICAL_STATUS],[REP_POINT_CODE],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[BLPUSTATE],[BLPU_STATE_DATE],[BLPU_CLASS],[PARENT_UPRN],[ORGANISATION],[WARDCODE],[PARISHCODE],[CUSTODIANONE],[CUSTODIANTWO],[CAN_KEY],[REQUEST_SOURCE],[CANDIDATE_FLAG],[NOTES],[NEWUNIQUEID],[REQUEST_SOURCE_ID],[USER_NAME])
421		SELECT [BLPU_CANDIDATE_ID],[UPRN],[CUSTODIAN_CODE],[XREF],[YREF],[LOGICAL_STATUS],[REP_POINT_CODE],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[BLPUSTATE],[BLPU_STATE_DATE],[BLPU_CLASS],[PARENT_UPRN],[ORGANISATION],[WARDCODE],[PARISHCODE],[CUSTODIANONE],[CUSTODIANTWO],[CAN_KEY],[REQUEST_SOURCE],[CANDIDATE_FLAG],[NOTES],[NEWUNIQUEID],[REQUEST_SOURCE_ID],[USER_NAME] FROM [dbo].[BLPU_CANDIDATE] TABLOCKX
422	')
423IF @@ERROR<>0 
424Begin
425	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
426	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CANDIDATE')
427END
428GO
429SET IDENTITY_INSERT [dbo].[tmp_BLPU_CANDIDATE] OFF
430
431DROP TABLE [dbo].[BLPU_CANDIDATE]
432GO
433IF @@ERROR<>0 
434Begin
435	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
436	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CANDIDATE')
437END
438GO
439EXECUTE sp_rename N'[dbo].[tmp_BLPU_CANDIDATE]', N'BLPU_CANDIDATE', 'OBJECT'
440
441IF @@ERROR<>0 
442Begin
443	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
444	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CANDIDATE')
445END
446GO
447
448IF @@TRANCOUNT=0 BEGIN TRANSACTION
449GO
450SET ANSI_NULLS ON
451GO
452SET QUOTED_IDENTIFIER ON
453GO
454
455CREATE TABLE [dbo].[tmp_BLPU_CLASS] (
456	[BLPU_ID] [int] IDENTITY (1,1) NOT NULL,
457	[Primary_class] [nvarchar](1) COLLATE Latin1_General_CI_AS NULL,
458	[Secondary_Class] [nvarchar](1) COLLATE Latin1_General_CI_AS NULL,
459	[Tertiary_Class] [nvarchar](2) COLLATE Latin1_General_CI_AS NULL,
460	[Description] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
461	[BLPU_Type] [nvarchar](3) COLLATE Latin1_General_CI_AS NULL,
462	[BLPU_Class] [nvarchar](4) COLLATE Latin1_General_CI_AS NULL
463) ON [PRIMARY]
464
465IF @@ERROR<>0 
466Begin
467	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
468	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CLASS')
469END
470GO
471SET IDENTITY_INSERT [dbo].[tmp_BLPU_CLASS] ON
472IF EXISTS (SELECT * FROM [dbo].[BLPU_CLASS])
473	EXEC
474	('
475		INSERT INTO [dbo].[tmp_BLPU_CLASS] ([BLPU_ID],[Primary_class],[Secondary_Class],[Tertiary_Class],[Description],[BLPU_Type],[BLPU_Class])
476		SELECT [BLPU_ID],[Primary_class],[Secondary_Class],[Tertiary_Class],[Description],[BLPU_Type],[BLPU_Class] FROM [dbo].[BLPU_CLASS] TABLOCKX
477	')
478IF @@ERROR<>0 
479Begin
480	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
481	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CLASS')
482END
483GO
484SET IDENTITY_INSERT [dbo].[tmp_BLPU_CLASS] OFF
485
486DROP TABLE [dbo].[BLPU_CLASS]
487GO
488IF @@ERROR<>0 
489Begin
490	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
491	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CLASS')
492END
493GO
494EXECUTE sp_rename N'[dbo].[tmp_BLPU_CLASS]', N'BLPU_CLASS', 'OBJECT'
495
496IF @@ERROR<>0 
497Begin
498	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
499	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CLASS')
500END
501GO
502
503IF @@TRANCOUNT=0 BEGIN TRANSACTION
504GO
505SET ANSI_NULLS ON
506GO
507SET QUOTED_IDENTIFIER ON
508GO
509
510CREATE TABLE [dbo].[tmp_BLPU_CLASSIFICATION] (
511	[UNIQUE_BLPUCLASS] [int] IDENTITY (1,1) NOT NULL,
512	[UPRN] [float] NOT NULL,
513	[CLASS_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
514	[CLASS_SCHEME] [varchar](40) COLLATE Latin1_General_CI_AS NULL,
515	[BLPU_CLASS] [varchar](4) COLLATE Latin1_General_CI_AS NOT NULL,
516	[START_DATE] [datetime] NULL,
517	[END_DATE] [datetime] NULL,
518	[ENTRY_DATE] [datetime] NULL,
519	[LAST_UPDATE_DATE] [datetime] NULL,
520	[LOCALONLY_PRIORITY] [varchar](3) COLLATE Latin1_General_CI_AS NULL,
521	[LOCALONLY_BLPUCLASSKEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
522	[CAN_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
523	[LOCALONLY_UNIQUEID] [float] NOT NULL
524) ON [PRIMARY]
525
526IF @@ERROR<>0 
527Begin
528	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
529	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CLASSIFICATION')
530END
531GO
532SET IDENTITY_INSERT [dbo].[tmp_BLPU_CLASSIFICATION] ON
533IF EXISTS (SELECT * FROM [dbo].[BLPU_CLASSIFICATION])
534	EXEC
535	('
536		INSERT INTO [dbo].[tmp_BLPU_CLASSIFICATION] ([UNIQUE_BLPUCLASS],[UPRN],[CLASS_KEY],[CLASS_SCHEME],[BLPU_CLASS],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[LOCALONLY_PRIORITY],[LOCALONLY_BLPUCLASSKEY],[CAN_KEY],[LOCALONLY_UNIQUEID])
537		SELECT [UNIQUE_BLPUCLASS],[UPRN],[CLASS_KEY],[CLASS_SCHEME],[BLPU_CLASS],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[LOCALONLY_PRIORITY],[LOCALONLY_BLPUCLASSKEY],[CAN_KEY],[LOCALONLY_UNIQUEID] FROM [dbo].[BLPU_CLASSIFICATION] TABLOCKX
538	')
539IF @@ERROR<>0 
540Begin
541	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
542	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CLASSIFICATION')
543END
544GO
545SET IDENTITY_INSERT [dbo].[tmp_BLPU_CLASSIFICATION] OFF
546
547DROP TABLE [dbo].[BLPU_CLASSIFICATION]
548GO
549IF @@ERROR<>0 
550Begin
551	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
552	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CLASSIFICATION')
553END
554GO
555EXECUTE sp_rename N'[dbo].[tmp_BLPU_CLASSIFICATION]', N'BLPU_CLASSIFICATION', 'OBJECT'
556
557IF @@ERROR<>0 
558Begin
559	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
560	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.BLPU_CLASSIFICATION')
561END
562GO
563
564IF @@TRANCOUNT=0 BEGIN TRANSACTION
565GO
566SET ANSI_NULLS ON
567GO
568SET QUOTED_IDENTIFIER ON
569GO
570
571CREATE TABLE [dbo].[tmp_Candidate_TFI] (
572	[TFI_Unique] [int] IDENTITY (1,1) NOT NULL,
573	[KEy_value] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
574	[entire_record] [varchar](2000) COLLATE Latin1_General_CI_AS NULL,
575	[entry_date] [datetime] NULL,
576	[USERID] [varchar](50) COLLATE Latin1_General_CI_AS NULL
577) ON [PRIMARY]
578
579IF @@ERROR<>0 
580Begin
581	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
582	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.Candidate_TFI')
583END
584GO
585SET IDENTITY_INSERT [dbo].[tmp_Candidate_TFI] ON
586IF EXISTS (SELECT * FROM [dbo].[Candidate_TFI])
587	EXEC
588	('
589		INSERT INTO [dbo].[tmp_Candidate_TFI] ([TFI_Unique],[KEy_value],[entire_record],[entry_date],[USERID])
590		SELECT [TFI_Unique],[KEy_value],[entire_record],[entry_date],[USERID] FROM [dbo].[Candidate_TFI] TABLOCKX
591	')
592IF @@ERROR<>0 
593Begin
594	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
595	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.Candidate_TFI')
596END
597GO
598SET IDENTITY_INSERT [dbo].[tmp_Candidate_TFI] OFF
599
600DROP TABLE [dbo].[Candidate_TFI]
601GO
602IF @@ERROR<>0 
603Begin
604	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
605	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.Candidate_TFI')
606END
607GO
608EXECUTE sp_rename N'[dbo].[tmp_Candidate_TFI]', N'Candidate_TFI', 'OBJECT'
609
610IF @@ERROR<>0 
611Begin
612	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
613	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.Candidate_TFI')
614END
615GO
616
617IF @@TRANCOUNT=0 BEGIN TRANSACTION
618GO
619SET ANSI_NULLS ON
620GO
621SET QUOTED_IDENTIFIER ON
622GO
623
624CREATE TABLE [dbo].[tmp_Candidate_TFI_ARCHIVE] (
625	[TFI_ARCHIVE_Unique] [int] IDENTITY (1,1) NOT NULL,
626	[KEy_value] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
627	[entire_record] [varchar](2000) COLLATE Latin1_General_CI_AS NULL,
628	[entry_date] [datetime] NULL
629) ON [PRIMARY]
630
631IF @@ERROR<>0 
632Begin
633	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
634	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.Candidate_TFI_ARCHIVE')
635END
636GO
637SET IDENTITY_INSERT [dbo].[tmp_Candidate_TFI_ARCHIVE] ON
638IF EXISTS (SELECT * FROM [dbo].[Candidate_TFI_ARCHIVE])
639	EXEC
640	('
641		INSERT INTO [dbo].[tmp_Candidate_TFI_ARCHIVE] ([TFI_ARCHIVE_Unique],[KEy_value],[entire_record],[entry_date])
642		SELECT [TFI_ARCHIVE_Unique],[KEy_value],[entire_record],[entry_date] FROM [dbo].[Candidate_TFI_ARCHIVE] TABLOCKX
643	')
644IF @@ERROR<>0 
645Begin
646	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
647	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.Candidate_TFI_ARCHIVE')
648END
649GO
650SET IDENTITY_INSERT [dbo].[tmp_Candidate_TFI_ARCHIVE] OFF
651
652DROP TABLE [dbo].[Candidate_TFI_ARCHIVE]
653GO
654IF @@ERROR<>0 
655Begin
656	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
657	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.Candidate_TFI_ARCHIVE')
658END
659GO
660EXECUTE sp_rename N'[dbo].[tmp_Candidate_TFI_ARCHIVE]', N'Candidate_TFI_ARCHIVE', 'OBJECT'
661
662IF @@ERROR<>0 
663Begin
664	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
665	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.Candidate_TFI_ARCHIVE')
666END
667GO
668
669IF @@TRANCOUNT=0 BEGIN TRANSACTION
670GO
671SET ANSI_NULLS ON
672GO
673SET QUOTED_IDENTIFIER ON
674GO
675
676CREATE TABLE [dbo].[tmp_ESU] (
677	[APGRECNO] [bigint] IDENTITY (1,1) NOT NULL,
678	[UPDDATE] [datetime] NULL,
679	[ESU_ID] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
680	[DISPLAYFLG] [numeric](1,0) NULL,
681	[STREETNAME] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
682	[TOWNNAME] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
683	[LOCALITY] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
684	[USRN] [varchar](8) COLLATE Latin1_General_CI_AS NULL,
685	[GEOMETRY] [geometry] NULL
686) ON [PRIMARY]
687
688IF @@ERROR<>0 
689Begin
690	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
691	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ESU')
692END
693GO
694SET IDENTITY_INSERT [dbo].[tmp_ESU] ON
695IF EXISTS (SELECT * FROM [dbo].[ESU])
696	EXEC
697	('
698		INSERT INTO [dbo].[tmp_ESU] ([APGRECNO],[UPDDATE],[ESU_ID],[DISPLAYFLG],[STREETNAME],[TOWNNAME],[LOCALITY],[USRN],[GEOMETRY])
699		SELECT [APGRECNO],[UPDDATE],[ESU_ID],[DISPLAYFLG],[STREETNAME],[TOWNNAME],[LOCALITY],[USRN],[GEOMETRY] FROM [dbo].[ESU] TABLOCKX
700	')
701IF @@ERROR<>0 
702Begin
703	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
704	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ESU')
705END
706GO
707SET IDENTITY_INSERT [dbo].[tmp_ESU] OFF
708
709DROP TABLE [dbo].[ESU]
710GO
711IF @@ERROR<>0 
712Begin
713	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
714	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ESU')
715END
716GO
717EXECUTE sp_rename N'[dbo].[tmp_ESU]', N'ESU', 'OBJECT'
718
719IF @@ERROR<>0 
720Begin
721	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
722	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ESU')
723END
724GO
725
726IF @@TRANCOUNT=0 BEGIN TRANSACTION
727GO
728SET ANSI_NULLS ON
729GO
730SET QUOTED_IDENTIFIER ON
731GO
732
733CREATE TABLE [dbo].[tmp_EXPORT_DATES] (
734	[EXPORT_ID] [int] IDENTITY (1,1) NOT NULL,
735	[EXPORT_DATE] [datetime] NULL,
736	[STATUS_IMPORT_DATE] [datetime] NULL,
737	[HUB_EXPORT_DATE] [datetime] NULL,
738	[EXPORT_TYPE] [int] NOT NULL,
739	[USERID] [varchar](50) COLLATE Latin1_General_CI_AS NULL
740) ON [PRIMARY]
741
742IF @@ERROR<>0 
743Begin
744	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
745	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.EXPORT_DATES')
746END
747GO
748SET IDENTITY_INSERT [dbo].[tmp_EXPORT_DATES] ON
749IF EXISTS (SELECT * FROM [dbo].[EXPORT_DATES])
750	EXEC
751	('
752		INSERT INTO [dbo].[tmp_EXPORT_DATES] ([EXPORT_ID],[EXPORT_DATE],[STATUS_IMPORT_DATE],[HUB_EXPORT_DATE],[EXPORT_TYPE],[USERID])
753		SELECT [EXPORT_ID],[EXPORT_DATE],[STATUS_IMPORT_DATE],[HUB_EXPORT_DATE],[EXPORT_TYPE],[USERID] FROM [dbo].[EXPORT_DATES] TABLOCKX
754	')
755IF @@ERROR<>0 
756Begin
757	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
758	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.EXPORT_DATES')
759END
760GO
761SET IDENTITY_INSERT [dbo].[tmp_EXPORT_DATES] OFF
762
763DROP TABLE [dbo].[EXPORT_DATES]
764GO
765IF @@ERROR<>0 
766Begin
767	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
768	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.EXPORT_DATES')
769END
770GO
771EXECUTE sp_rename N'[dbo].[tmp_EXPORT_DATES]', N'EXPORT_DATES', 'OBJECT'
772
773IF @@ERROR<>0 
774Begin
775	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
776	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.EXPORT_DATES')
777END
778GO
779
780IF @@TRANCOUNT=0 BEGIN TRANSACTION
781GO
782SET ANSI_NULLS ON
783GO
784SET QUOTED_IDENTIFIER ON
785GO
786
787CREATE TABLE [dbo].[tmp_EXPORTDATES_TFIOLD] (
788	[EXPORT_ID] [int] IDENTITY (1,1) NOT NULL,
789	[EXPORT_DATE] [datetime] NULL,
790	[STATUS_IMPORT_DATE] [datetime] NULL,
791	[HUB_EXPORT_DATE] [datetime] NULL,
792	[EXPORT_TYPE] [int] NULL,
793	[ENTRY_DATE] [datetime] NULL
794) ON [PRIMARY]
795
796IF @@ERROR<>0 
797Begin
798	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
799	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.EXPORTDATES_TFIOLD')
800END
801GO
802SET IDENTITY_INSERT [dbo].[tmp_EXPORTDATES_TFIOLD] ON
803IF EXISTS (SELECT * FROM [dbo].[EXPORTDATES_TFIOLD])
804	EXEC
805	('
806		INSERT INTO [dbo].[tmp_EXPORTDATES_TFIOLD] ([EXPORT_ID],[EXPORT_DATE],[STATUS_IMPORT_DATE],[HUB_EXPORT_DATE],[EXPORT_TYPE],[ENTRY_DATE])
807		SELECT [EXPORT_ID],[EXPORT_DATE],[STATUS_IMPORT_DATE],[HUB_EXPORT_DATE],[EXPORT_TYPE],[ENTRY_DATE] FROM [dbo].[EXPORTDATES_TFIOLD] TABLOCKX
808	')
809IF @@ERROR<>0 
810Begin
811	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
812	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.EXPORTDATES_TFIOLD')
813END
814GO
815SET IDENTITY_INSERT [dbo].[tmp_EXPORTDATES_TFIOLD] OFF
816
817DROP TABLE [dbo].[EXPORTDATES_TFIOLD]
818GO
819IF @@ERROR<>0 
820Begin
821	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
822	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.EXPORTDATES_TFIOLD')
823END
824GO
825EXECUTE sp_rename N'[dbo].[tmp_EXPORTDATES_TFIOLD]', N'EXPORTDATES_TFIOLD', 'OBJECT'
826
827IF @@ERROR<>0 
828Begin
829	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
830	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.EXPORTDATES_TFIOLD')
831END
832GO
833
834IF @@TRANCOUNT=0 BEGIN TRANSACTION
835GO
836SET ANSI_NULLS ON
837GO
838SET QUOTED_IDENTIFIER ON
839GO
840
841CREATE TABLE [dbo].[tmp_HWW] (
842	[APGRECNO] [bigint] IDENTITY (1,1) NOT NULL,
843	[UPDDATE] [datetime] NULL,
844	[USRN] [varchar](8) COLLATE Latin1_General_CI_AS NULL,
845	[SEQNUM] [numeric](3,0) NULL,
846	[DESIGCODE] [varchar](120) COLLATE Latin1_General_CI_AS NULL,
847	[WHOLE_ROAD] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
848	[ENDDATE] [varchar](10) COLLATE Latin1_General_CI_AS NULL,
849	[LOCTEXT] [varchar](120) COLLATE Latin1_General_CI_AS NULL,
850	[VALMETRIC] [varchar](3) COLLATE Latin1_General_CI_AS NULL,
851	[TROTEXT] [varchar](120) COLLATE Latin1_General_CI_AS NULL,
852	[FEATDESC] [varchar](120) COLLATE Latin1_General_CI_AS NULL,
853	[AUTHORITY] [varchar](4) COLLATE Latin1_General_CI_AS NULL,
854	[GEOMETRY] [geometry] NULL
855) ON [PRIMARY]
856
857IF @@ERROR<>0 
858Begin
859	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
860	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.HWW')
861END
862GO
863SET IDENTITY_INSERT [dbo].[tmp_HWW] ON
864IF EXISTS (SELECT * FROM [dbo].[HWW])
865	EXEC
866	('
867		INSERT INTO [dbo].[tmp_HWW] ([APGRECNO],[UPDDATE],[USRN],[SEQNUM],[DESIGCODE],[WHOLE_ROAD],[ENDDATE],[LOCTEXT],[VALMETRIC],[TROTEXT],[FEATDESC],[AUTHORITY],[GEOMETRY])
868		SELECT [APGRECNO],[UPDDATE],[USRN],[SEQNUM],[DESIGCODE],[WHOLE_ROAD],[ENDDATE],[LOCTEXT],[VALMETRIC],[TROTEXT],[FEATDESC],[AUTHORITY],[GEOMETRY] FROM [dbo].[HWW] TABLOCKX
869	')
870IF @@ERROR<>0 
871Begin
872	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
873	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.HWW')
874END
875GO
876SET IDENTITY_INSERT [dbo].[tmp_HWW] OFF
877
878DROP TABLE [dbo].[HWW]
879GO
880IF @@ERROR<>0 
881Begin
882	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
883	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.HWW')
884END
885GO
886EXECUTE sp_rename N'[dbo].[tmp_HWW]', N'HWW', 'OBJECT'
887
888IF @@ERROR<>0 
889Begin
890	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
891	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.HWW')
892END
893GO
894
895IF @@TRANCOUNT=0 BEGIN TRANSACTION
896GO
897SET ANSI_NULLS ON
898GO
899SET QUOTED_IDENTIFIER ON
900GO
901
902CREATE TABLE [dbo].[tmp_LAND_AND_PROPERTY_IDENTIFIER] (
903	[LPI_UNIQUE] [int] IDENTITY (1,1) NOT NULL,
904	[UPRN] [float] NOT NULL,
905	[USRN] [int] NOT NULL,
906	[PAO_FROM] [smallint] NULL,
907	[PAO_FROM_SUFF] [varchar](2) COLLATE Latin1_General_CI_AS NULL,
908	[PAO_TO] [smallint] NULL,
909	[PAO_TO_SUFF] [varchar](2) COLLATE Latin1_General_CI_AS NULL,
910	[PAO_NAME] [varchar](90) COLLATE Latin1_General_CI_AS NULL,
911	[SAO_FROM] [smallint] NULL,
912	[SAO_FROM_SUFF] [varchar](2) COLLATE Latin1_General_CI_AS NULL,
913	[SAO_TO] [smallint] NULL,
914	[SAO_TO_SUFF] [varchar](2) COLLATE Latin1_General_CI_AS NULL,
915	[SAO_NAME] [varchar](90) COLLATE Latin1_General_CI_AS NULL,
916	[POSTTOWN] [varchar](30) COLLATE Latin1_General_CI_AS NULL,
917	[POSTCODE] [varchar](8) COLLATE Latin1_General_CI_AS NULL,
918	[OFFICIAL_ADDRESS_MARKER] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
919	[LPI_LEVEL] [varchar](30) COLLATE Latin1_General_CI_AS NULL,
920	[LOGICAL_STATUS] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
921	[START_DATE] [datetime] NULL,
922	[END_DATE] [datetime] NULL,
923	[ENTRY_DATE] [datetime] NULL,
924	[LAST_UPDATE_DATE] [datetime] NULL,
925	[ALT_LPI] [int] NULL,
926	[LPIKEY] [nvarchar](14) COLLATE Latin1_General_CI_AS NULL,
927	[POSTALLYADDRESSABLE] [nvarchar](1) COLLATE Latin1_General_CI_AS NULL,
928	[CUSTODIANONE] [int] NULL,
929	[CUSTODIANTWO] [int] NULL,
930	[CAN_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
931	[LANGUAGE_CODE] [nvarchar](3) COLLATE Latin1_General_CI_AS NULL,
932	[HIDEPAON] [nvarchar](1) COLLATE Latin1_General_CI_AS NULL,
933	[SUB_LOCALITY] [varchar](35) COLLATE Latin1_General_CI_AS NULL,
934	[ALIAS_ID] [int] NULL,
935	[LOCALONLY_PRIORITY] [varchar](3) COLLATE Latin1_General_CI_AS NULL,
936	[POLICEBEATCODE] [varchar](10) COLLATE Latin1_General_CI_AS NULL,
937	[POLICEFORCEAREA] [varchar](10) COLLATE Latin1_General_CI_AS NULL,
938	[LOCALONLY_UNIQUE_ID] [float] NOT NULL,
939	[LPI_NOTES] [nvarchar](2000) COLLATE Latin1_General_CI_AS NULL,
940	[LOCALONLY_LPIKEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
941	[ISOSGSTREETRECORD] [varchar](1) COLLATE Latin1_General_CI_AS NULL
942) ON [PRIMARY]
943
944IF @@ERROR<>0 
945Begin
946	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
947	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LAND_AND_PROPERTY_IDENTIFIER')
948END
949GO
950SET IDENTITY_INSERT [dbo].[tmp_LAND_AND_PROPERTY_IDENTIFIER] ON
951IF EXISTS (SELECT * FROM [dbo].[LAND_AND_PROPERTY_IDENTIFIER])
952	EXEC
953	('
954		INSERT INTO [dbo].[tmp_LAND_AND_PROPERTY_IDENTIFIER] ([LPI_UNIQUE],[UPRN],[USRN],[PAO_FROM],[PAO_FROM_SUFF],[PAO_TO],[PAO_TO_SUFF],[PAO_NAME],[SAO_FROM],[SAO_FROM_SUFF],[SAO_TO],[SAO_TO_SUFF],[SAO_NAME],[POSTTOWN],[POSTCODE],[OFFICIAL_ADDRESS_MARKER],[LPI_LEVEL],[LOGICAL_STATUS],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[ALT_LPI],[LPIKEY],[POSTALLYADDRESSABLE],[CUSTODIANONE],[CUSTODIANTWO],[CAN_KEY],[LANGUAGE_CODE],[HIDEPAON],[SUB_LOCALITY],[ALIAS_ID],[LOCALONLY_PRIORITY],[POLICEBEATCODE],[POLICEFORCEAREA],[LOCALONLY_UNIQUE_ID],[LPI_NOTES],[LOCALONLY_LPIKEY],[ISOSGSTREETRECORD])
955		SELECT [LPI_UNIQUE],[UPRN],[USRN],[PAO_FROM],[PAO_FROM_SUFF],[PAO_TO],[PAO_TO_SUFF],[PAO_NAME],[SAO_FROM],[SAO_FROM_SUFF],[SAO_TO],[SAO_TO_SUFF],[SAO_NAME],[POSTTOWN],[POSTCODE],[OFFICIAL_ADDRESS_MARKER],[LPI_LEVEL],[LOGICAL_STATUS],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[ALT_LPI],[LPIKEY],[POSTALLYADDRESSABLE],[CUSTODIANONE],[CUSTODIANTWO],[CAN_KEY],[LANGUAGE_CODE],[HIDEPAON],[SUB_LOCALITY],[ALIAS_ID],[LOCALONLY_PRIORITY],[POLICEBEATCODE],[POLICEFORCEAREA],[LOCALONLY_UNIQUE_ID],[LPI_NOTES],[LOCALONLY_LPIKEY],[ISOSGSTREETRECORD] FROM [dbo].[LAND_AND_PROPERTY_IDENTIFIER] TABLOCKX
956	')
957IF @@ERROR<>0 
958Begin
959	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
960	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LAND_AND_PROPERTY_IDENTIFIER')
961END
962GO
963SET IDENTITY_INSERT [dbo].[tmp_LAND_AND_PROPERTY_IDENTIFIER] OFF
964
965DROP TABLE [dbo].[LAND_AND_PROPERTY_IDENTIFIER]
966GO
967IF @@ERROR<>0 
968Begin
969	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
970	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LAND_AND_PROPERTY_IDENTIFIER')
971END
972GO
973EXECUTE sp_rename N'[dbo].[tmp_LAND_AND_PROPERTY_IDENTIFIER]', N'LAND_AND_PROPERTY_IDENTIFIER', 'OBJECT'
974
975IF @@ERROR<>0 
976Begin
977	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
978	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LAND_AND_PROPERTY_IDENTIFIER')
979END
980GO
981
982IF @@TRANCOUNT=0 BEGIN TRANSACTION
983GO
984SET ANSI_NULLS ON
985GO
986SET QUOTED_IDENTIFIER ON
987GO
988
989CREATE TABLE [dbo].[tmp_LOCALITY] (
990	[LOC_REF] [int] IDENTITY (1,1) NOT NULL,
991	[NAME] [varchar](35) COLLATE Latin1_General_CI_AS NULL,
992	[TYPE] [varchar](1) COLLATE Latin1_General_CI_AS NULL
993) ON [PRIMARY]
994
995IF @@ERROR<>0 
996Begin
997	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
998	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LOCALITY')
999END
1000GO
1001SET IDENTITY_INSERT [dbo].[tmp_LOCALITY] ON
1002IF EXISTS (SELECT * FROM [dbo].[LOCALITY])
1003	EXEC
1004	('
1005		INSERT INTO [dbo].[tmp_LOCALITY] ([LOC_REF],[NAME],[TYPE])
1006		SELECT [LOC_REF],[NAME],[TYPE] FROM [dbo].[LOCALITY] TABLOCKX
1007	')
1008IF @@ERROR<>0 
1009Begin
1010	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1011	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LOCALITY')
1012END
1013GO
1014SET IDENTITY_INSERT [dbo].[tmp_LOCALITY] OFF
1015
1016DROP TABLE [dbo].[LOCALITY]
1017GO
1018IF @@ERROR<>0 
1019Begin
1020	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1021	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LOCALITY')
1022END
1023GO
1024EXECUTE sp_rename N'[dbo].[tmp_LOCALITY]', N'LOCALITY', 'OBJECT'
1025
1026IF @@ERROR<>0 
1027Begin
1028	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1029	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LOCALITY')
1030END
1031GO
1032
1033IF @@TRANCOUNT=0 BEGIN TRANSACTION
1034GO
1035SET ANSI_NULLS ON
1036GO
1037SET QUOTED_IDENTIFIER ON
1038GO
1039
1040CREATE TABLE [dbo].[tmp_LPI_CANDIDATE] (
1041	[LPI_CANDIDATE_ID] [int] IDENTITY (1,1) NOT NULL,
1042	[UPRN] [float] NULL,
1043	[USRN] [int] NOT NULL,
1044	[PAO_FROM] [smallint] NULL,
1045	[PAO_FROM_SUFF] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1046	[PAO_TO] [smallint] NULL,
1047	[PAO_TO_SUFF] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1048	[PAO_NAME] [varchar](90) COLLATE Latin1_General_CI_AS NULL,
1049	[SAO_FROM] [smallint] NULL,
1050	[SAO_FROM_SUFF] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1051	[SAO_TO] [smallint] NULL,
1052	[SAO_TO_SUFF] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1053	[SAO_NAME] [varchar](90) COLLATE Latin1_General_CI_AS NULL,
1054	[POSTTOWN] [varchar](30) COLLATE Latin1_General_CI_AS NULL,
1055	[POSTCODE] [varchar](8) COLLATE Latin1_General_CI_AS NULL,
1056	[LPI_LEVEL] [varchar](30) COLLATE Latin1_General_CI_AS NULL,
1057	[LOGICAL_STATUS] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1058	[START_DATE] [datetime] NULL,
1059	[END_DATE] [datetime] NULL,
1060	[ENTRY_DATE] [datetime] NULL,
1061	[LAST_UPDATE_DATE] [datetime] NULL,
1062	[LPIKEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1063	[POSTALLYADDRESSABLE] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1064	[CUSTODIANONE] [int] NULL,
1065	[CUSTODIANTWO] [int] NULL,
1066	[CAN_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1067	[LANGUAGE_CODE] [varchar](3) COLLATE Latin1_General_CI_AS NULL,
1068	[REQUEST_SOURCE] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
1069	[CANDIDATE_FLAG] [varchar](3) COLLATE Latin1_General_CI_AS NULL,
1070	[OFFICIAL_FLAG] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1071	[SUB_LOCALITY] [varchar](35) COLLATE Latin1_General_CI_AS NULL,
1072	[NOTES] [varchar](4000) COLLATE Latin1_General_CI_AS NULL,
1073	[COMMENTS] [varchar](4000) COLLATE Latin1_General_CI_AS NULL,
1074	[NEWUNIQUEID] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
1075	[USER_NAME] [varchar](50) COLLATE Latin1_General_CI_AS NULL
1076) ON [PRIMARY]
1077
1078IF @@ERROR<>0 
1079Begin
1080	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1081	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LPI_CANDIDATE')
1082END
1083GO
1084SET IDENTITY_INSERT [dbo].[tmp_LPI_CANDIDATE] ON
1085IF EXISTS (SELECT * FROM [dbo].[LPI_CANDIDATE])
1086	EXEC
1087	('
1088		INSERT INTO [dbo].[tmp_LPI_CANDIDATE] ([LPI_CANDIDATE_ID],[UPRN],[USRN],[PAO_FROM],[PAO_FROM_SUFF],[PAO_TO],[PAO_TO_SUFF],[PAO_NAME],[SAO_FROM],[SAO_FROM_SUFF],[SAO_TO],[SAO_TO_SUFF],[SAO_NAME],[POSTTOWN],[POSTCODE],[LPI_LEVEL],[LOGICAL_STATUS],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[LPIKEY],[POSTALLYADDRESSABLE],[CUSTODIANONE],[CUSTODIANTWO],[CAN_KEY],[LANGUAGE_CODE],[REQUEST_SOURCE],[CANDIDATE_FLAG],[OFFICIAL_FLAG],[SUB_LOCALITY],[NOTES],[COMMENTS],[NEWUNIQUEID],[USER_NAME])
1089		SELECT [LPI_CANDIDATE_ID],[UPRN],[USRN],[PAO_FROM],[PAO_FROM_SUFF],[PAO_TO],[PAO_TO_SUFF],[PAO_NAME],[SAO_FROM],[SAO_FROM_SUFF],[SAO_TO],[SAO_TO_SUFF],[SAO_NAME],[POSTTOWN],[POSTCODE],[LPI_LEVEL],[LOGICAL_STATUS],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[LPIKEY],[POSTALLYADDRESSABLE],[CUSTODIANONE],[CUSTODIANTWO],[CAN_KEY],[LANGUAGE_CODE],[REQUEST_SOURCE],[CANDIDATE_FLAG],[OFFICIAL_FLAG],[SUB_LOCALITY],[NOTES],[COMMENTS],[NEWUNIQUEID],[USER_NAME] FROM [dbo].[LPI_CANDIDATE] TABLOCKX
1090	')
1091IF @@ERROR<>0 
1092Begin
1093	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1094	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LPI_CANDIDATE')
1095END
1096GO
1097SET IDENTITY_INSERT [dbo].[tmp_LPI_CANDIDATE] OFF
1098
1099DROP TABLE [dbo].[LPI_CANDIDATE]
1100GO
1101IF @@ERROR<>0 
1102Begin
1103	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1104	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LPI_CANDIDATE')
1105END
1106GO
1107EXECUTE sp_rename N'[dbo].[tmp_LPI_CANDIDATE]', N'LPI_CANDIDATE', 'OBJECT'
1108
1109IF @@ERROR<>0 
1110Begin
1111	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1112	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.LPI_CANDIDATE')
1113END
1114GO
1115
1116IF @@TRANCOUNT=0 BEGIN TRANSACTION
1117GO
1118SET ANSI_NULLS ON
1119GO
1120SET QUOTED_IDENTIFIER ON
1121GO
1122
1123CREATE TABLE [dbo].[tmp_NODE] (
1124	[APGRECNO] [bigint] IDENTITY (1,1) NOT NULL,
1125	[UPDDATE] [datetime] NULL,
1126	[NODE_ID] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1127	[DISPLAYFLG] [numeric](1,0) NULL,
1128	[GEOMETRY] [geometry] NULL
1129) ON [PRIMARY]
1130
1131IF @@ERROR<>0 
1132Begin
1133	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1134	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.NODE')
1135END
1136GO
1137SET IDENTITY_INSERT [dbo].[tmp_NODE] ON
1138IF EXISTS (SELECT * FROM [dbo].[NODE])
1139	EXEC
1140	('
1141		INSERT INTO [dbo].[tmp_NODE] ([APGRECNO],[UPDDATE],[NODE_ID],[DISPLAYFLG],[GEOMETRY])
1142		SELECT [APGRECNO],[UPDDATE],[NODE_ID],[DISPLAYFLG],[GEOMETRY] FROM [dbo].[NODE] TABLOCKX
1143	')
1144IF @@ERROR<>0 
1145Begin
1146	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1147	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.NODE')
1148END
1149GO
1150SET IDENTITY_INSERT [dbo].[tmp_NODE] OFF
1151
1152DROP TABLE [dbo].[NODE]
1153GO
1154IF @@ERROR<>0 
1155Begin
1156	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1157	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.NODE')
1158END
1159GO
1160EXECUTE sp_rename N'[dbo].[tmp_NODE]', N'NODE', 'OBJECT'
1161
1162IF @@ERROR<>0 
1163Begin
1164	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1165	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.NODE')
1166END
1167GO
1168
1169IF @@TRANCOUNT=0 BEGIN TRANSACTION
1170GO
1171SET ANSI_NULLS ON
1172GO
1173SET QUOTED_IDENTIFIER ON
1174GO
1175
1176CREATE TABLE [dbo].[tmp_ORGANISATION] (
1177	[UNIQUE_ORG] [int] IDENTITY (1,1) NOT NULL,
1178	[UPRN] [float] NOT NULL,
1179	[ORG_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1180	[ORGANISATION] [varchar](100) COLLATE Latin1_General_CI_AS NULL,
1181	[LEGAL_NAME] [varchar](60) COLLATE Latin1_General_CI_AS NULL,
1182	[START_DATE] [datetime] NULL,
1183	[END_DATE] [datetime] NULL,
1184	[ENTRY_DATE] [datetime] NULL,
1185	[LAST_UPDATE_DATE] [datetime] NULL,
1186	[LOCALONLY_PRIORITY] [varchar](3) COLLATE Latin1_General_CI_AS NULL,
1187	[LOCALONLY_ORGKEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1188	[CAN_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1189	[LOCALONLY_UNIQUEID] [float] NOT NULL
1190) ON [PRIMARY]
1191
1192IF @@ERROR<>0 
1193Begin
1194	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1195	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ORGANISATION')
1196END
1197GO
1198SET IDENTITY_INSERT [dbo].[tmp_ORGANISATION] ON
1199IF EXISTS (SELECT * FROM [dbo].[ORGANISATION])
1200	EXEC
1201	('
1202		INSERT INTO [dbo].[tmp_ORGANISATION] ([UNIQUE_ORG],[UPRN],[ORG_KEY],[ORGANISATION],[LEGAL_NAME],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[LOCALONLY_PRIORITY],[LOCALONLY_ORGKEY],[CAN_KEY],[LOCALONLY_UNIQUEID])
1203		SELECT [UNIQUE_ORG],[UPRN],[ORG_KEY],[ORGANISATION],[LEGAL_NAME],[START_DATE],[END_DATE],[ENTRY_DATE],[LAST_UPDATE_DATE],[LOCALONLY_PRIORITY],[LOCALONLY_ORGKEY],[CAN_KEY],[LOCALONLY_UNIQUEID] FROM [dbo].[ORGANISATION] TABLOCKX
1204	')
1205IF @@ERROR<>0 
1206Begin
1207	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1208	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ORGANISATION')
1209END
1210GO
1211SET IDENTITY_INSERT [dbo].[tmp_ORGANISATION] OFF
1212
1213DROP TABLE [dbo].[ORGANISATION]
1214GO
1215IF @@ERROR<>0 
1216Begin
1217	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1218	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ORGANISATION')
1219END
1220GO
1221EXECUTE sp_rename N'[dbo].[tmp_ORGANISATION]', N'ORGANISATION', 'OBJECT'
1222
1223IF @@ERROR<>0 
1224Begin
1225	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1226	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.ORGANISATION')
1227END
1228GO
1229
1230IF @@TRANCOUNT=0 BEGIN TRANSACTION
1231GO
1232SET ANSI_NULLS ON
1233GO
1234SET QUOTED_IDENTIFIER ON
1235GO
1236
1237CREATE TABLE [dbo].[tmp_REINSTDS] (
1238	[APGRECNO] [bigint] IDENTITY (1,1) NOT NULL,
1239	[UPDDATE] [datetime] NULL,
1240	[USRN] [varchar](8) COLLATE Latin1_General_CI_AS NULL,
1241	[SRCTYPE] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
1242	[WHOLE_ROAD] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1243	[LOCTEXT] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
1244	[SEQNUM] [numeric](3,0) NULL,
1245	[SRCCODE] [numeric](2,0) NULL,
1246	[GEOMETRY] [geometry] NULL
1247) ON [PRIMARY]
1248
1249IF @@ERROR<>0 
1250Begin
1251	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1252	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.REINSTDS')
1253END
1254GO
1255SET IDENTITY_INSERT [dbo].[tmp_REINSTDS] ON
1256IF EXISTS (SELECT * FROM [dbo].[REINSTDS])
1257	EXEC
1258	('
1259		INSERT INTO [dbo].[tmp_REINSTDS] ([APGRECNO],[UPDDATE],[USRN],[SRCTYPE],[WHOLE_ROAD],[LOCTEXT],[SEQNUM],[SRCCODE],[GEOMETRY])
1260		SELECT [APGRECNO],[UPDDATE],[USRN],[SRCTYPE],[WHOLE_ROAD],[LOCTEXT],[SEQNUM],[SRCCODE],[GEOMETRY] FROM [dbo].[REINSTDS] TABLOCKX
1261	')
1262IF @@ERROR<>0 
1263Begin
1264	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1265	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.REINSTDS')
1266END
1267GO
1268SET IDENTITY_INSERT [dbo].[tmp_REINSTDS] OFF
1269
1270DROP TABLE [dbo].[REINSTDS]
1271GO
1272IF @@ERROR<>0 
1273Begin
1274	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1275	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.REINSTDS')
1276END
1277GO
1278EXECUTE sp_rename N'[dbo].[tmp_REINSTDS]', N'REINSTDS', 'OBJECT'
1279
1280IF @@ERROR<>0 
1281Begin
1282	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1283	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.REINSTDS')
1284END
1285GO
1286
1287IF @@TRANCOUNT=0 BEGIN TRANSACTION
1288GO
1289SET ANSI_NULLS ON
1290GO
1291SET QUOTED_IDENTIFIER ON
1292GO
1293
1294CREATE TABLE [dbo].[tmp_SPCLDSG] (
1295	[APGRECNO] [bigint] IDENTITY (1,1) NOT NULL,
1296	[UPDDATE] [datetime] NULL,
1297	[USRN] [varchar](8) COLLATE Latin1_General_CI_AS NULL,
1298	[SPLDSGTEXT] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
1299	[WHOLE_ROAD] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
1300	[SPLDSGPRD] [varchar](120) COLLATE Latin1_General_CI_AS NULL,
1301	[LOCTEXT] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
1302	[SEQNUM] [numeric](3,0) NULL,
1303	[DESIGCODE] [numeric](2,0) NULL,
1304	[STARTDATE] [date] NULL,
1305	[ENDDATE] [date] NULL,
1306	[START_TIME] [varchar](5) COLLATE Latin1_General_CI_AS NULL,
1307	[END_TIME] [varchar](5) COLLATE Latin1_General_CI_AS NULL,
1308	[GEOMETRY] [geometry] NULL
1309) ON [PRIMARY]
1310
1311IF @@ERROR<>0 
1312Begin
1313	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1314	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.SPCLDSG')
1315END
1316GO
1317SET IDENTITY_INSERT [dbo].[tmp_SPCLDSG] ON
1318IF EXISTS (SELECT * FROM [dbo].[SPCLDSG])
1319	EXEC
1320	('
1321		INSERT INTO [dbo].[tmp_SPCLDSG] ([APGRECNO],[UPDDATE],[USRN],[SPLDSGTEXT],[WHOLE_ROAD],[SPLDSGPRD],[LOCTEXT],[SEQNUM],[DESIGCODE],[STARTDATE],[ENDDATE],[START_TIME],[END_TIME],[GEOMETRY])
1322		SELECT [APGRECNO],[UPDDATE],[USRN],[SPLDSGTEXT],[WHOLE_ROAD],[SPLDSGPRD],[LOCTEXT],[SEQNUM],[DESIGCODE],[STARTDATE],[ENDDATE],[START_TIME],[END_TIME],[GEOMETRY] FROM [dbo].[SPCLDSG] TABLOCKX
1323	')
1324IF @@ERROR<>0 
1325Begin
1326	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1327	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.SPCLDSG')
1328END
1329GO
1330SET IDENTITY_INSERT [dbo].[tmp_SPCLDSG] OFF
1331
1332DROP TABLE [dbo].[SPCLDSG]
1333GO
1334IF @@ERROR<>0 
1335Begin
1336	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1337	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.SPCLDSG')
1338END
1339GO
1340EXECUTE sp_rename N'[dbo].[tmp_SPCLDSG]', N'SPCLDSG', 'OBJECT'
1341
1342IF @@ERROR<>0 
1343Begin
1344	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1345	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.SPCLDSG')
1346END
1347GO
1348
1349IF @@TRANCOUNT=0 BEGIN TRANSACTION
1350GO
1351SET ANSI_NULLS ON
1352GO
1353SET QUOTED_IDENTIFIER ON
1354GO
1355
1356CREATE TABLE [dbo].[tmp_STREET_SP] (
1357	[APGRECNO] [bigint] IDENTITY (1,1) NOT NULL,
1358	[UPDDATE] [datetime] NULL,
1359	[USRN] [varchar](8) COLLATE Latin1_General_CI_AS NULL,
1360	[DISPLAYFLG] [numeric](1,0) NULL,
1361	[SUB_TYPE] [varchar](2) COLLATE Latin1_General_CI_AS NULL,
1362	[LENGTH] [numeric](10,3) NULL,
1363	[CLOSE_DATE] [date] NULL,
1364	[GEOMETRY] [geometry] NULL
1365) ON [PRIMARY]
1366
1367IF @@ERROR<>0 
1368Begin
1369	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1370	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.STREET_SP')
1371END
1372GO
1373SET IDENTITY_INSERT [dbo].[tmp_STREET_SP] ON
1374IF EXISTS (SELECT * FROM [dbo].[STREET_SP])
1375	EXEC
1376	('
1377		INSERT INTO [dbo].[tmp_STREET_SP] ([APGRECNO],[UPDDATE],[USRN],[DISPLAYFLG],[SUB_TYPE],[LENGTH],[CLOSE_DATE],[GEOMETRY])
1378		SELECT [APGRECNO],[UPDDATE],[USRN],[DISPLAYFLG],[SUB_TYPE],[LENGTH],[CLOSE_DATE],[GEOMETRY] FROM [dbo].[STREET_SP] TABLOCKX
1379	')
1380IF @@ERROR<>0 
1381Begin
1382	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1383	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.STREET_SP')
1384END
1385GO
1386SET IDENTITY_INSERT [dbo].[tmp_STREET_SP] OFF
1387
1388DROP TABLE [dbo].[STREET_SP]
1389GO
1390IF @@ERROR<>0 
1391Begin
1392	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1393	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.STREET_SP')
1394END
1395GO
1396EXECUTE sp_rename N'[dbo].[tmp_STREET_SP]', N'STREET_SP', 'OBJECT'
1397
1398IF @@ERROR<>0 
1399Begin
1400	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1401	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.STREET_SP')
1402END
1403GO
1404
1405IF @@TRANCOUNT=0 BEGIN TRANSACTION
1406GO
1407SET ANSI_NULLS ON
1408GO
1409SET QUOTED_IDENTIFIER ON
1410GO
1411
1412CREATE TABLE [dbo].[tmp_SUCCESSOR_XREF] (
1413	[UNIQUE_SUCCESSOR_XREF] [int] IDENTITY (1,1) NOT NULL,
1414	[PREDECESSOR] [float] NOT NULL,
1415	[SUCC_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1416	[START_DATE] [datetime] NULL,
1417	[LAST_UPDATE_DATE] [datetime] NULL,
1418	[ENTRY_DATE] [datetime] NULL,
1419	[END_DATE] [datetime] NULL,
1420	[SUCCESSOR_TYPE] [smallint] NULL,
1421	[SUCCESSOR] [float] NULL,
1422	[LOCALONLY_SUCCKEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1423	[localonly_uniqueid] [varchar](14) COLLATE Latin1_General_CI_AS NULL,
1424	[CAN_KEY] [varchar](14) COLLATE Latin1_General_CI_AS NULL
1425) ON [PRIMARY]
1426
1427IF @@ERROR<>0 
1428Begin
1429	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1430	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.SUCCESSOR_XREF')
1431END
1432GO
1433SET IDENTITY_INSERT [dbo].[tmp_SUCCESSOR_XREF] ON
1434IF EXISTS (SELECT * FROM [dbo].[SUCCESSOR_XREF])
1435	EXEC
1436	('
1437		INSERT INTO [dbo].[tmp_SUCCESSOR_XREF] ([UNIQUE_SUCCESSOR_XREF],[PREDECESSOR],[SUCC_KEY],[START_DATE],[LAST_UPDATE_DATE],[ENTRY_DATE],[END_DATE],[SUCCESSOR_TYPE],[SUCCESSOR],[LOCALONLY_SUCCKEY],[localonly_uniqueid],[CAN_KEY])
1438		SELECT [UNIQUE_SUCCESSOR_XREF],[PREDECESSOR],[SUCC_KEY],[START_DATE],[LAST_UPDATE_DATE],[ENTRY_DATE],[END_DATE],[SUCCESSOR_TYPE],[SUCCESSOR],[LOCALONLY_SUCCKEY],[localonly_uniqueid],[CAN_KEY] FROM [dbo].[SUCCESSOR_XREF] TABLOCKX
1439	')
1440IF @@ERROR<>0 
1441Begin
1442	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1443	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.SUCCESSOR_XREF')
1444END
1445GO
1446SET IDENTITY_INSERT [dbo].[tmp_SUCCESSOR_XREF] OFF
1447
1448DROP TABLE [dbo].[SUCCESSOR_XREF]
1449GO
1450IF @@ERROR<>0 
1451Begin
1452	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1453	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.SUCCESSOR_XREF')
1454END
1455GO
1456EXECUTE sp_rename N'[dbo].[tmp_SUCCESSOR_XREF]', N'SUCCESSOR_XREF', 'OBJECT'
1457
1458IF @@ERROR<>0 
1459Begin
1460	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1461	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.SUCCESSOR_XREF')
1462END
1463GO
1464
1465IF @@TRANCOUNT=0 BEGIN TRANSACTION
1466GO
1467SET ANSI_NULLS ON
1468GO
1469SET QUOTED_IDENTIFIER ON
1470GO
1471
1472CREATE TABLE [dbo].[tmp_TFI] (
1473	[TFI_UNIQUE] [int] IDENTITY (1,1) NOT NULL,
1474	[KEY_VALUE] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
1475	[ENTIRE_RECORD] [ntext] COLLATE Latin1_General_CI_AS NULL,
1476	[ENTRY_DATE] [datetime] NULL
1477) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1478
1479IF @@ERROR<>0 
1480Begin
1481	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1482	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TFI')
1483END
1484GO
1485SET IDENTITY_INSERT [dbo].[tmp_TFI] ON
1486IF EXISTS (SELECT * FROM [dbo].[TFI])
1487	EXEC
1488	('
1489		INSERT INTO [dbo].[tmp_TFI] ([TFI_UNIQUE],[KEY_VALUE],[ENTIRE_RECORD],[ENTRY_DATE])
1490		SELECT [TFI_UNIQUE],[KEY_VALUE],[ENTIRE_RECORD],[ENTRY_DATE] FROM [dbo].[TFI] TABLOCKX
1491	')
1492IF @@ERROR<>0 
1493Begin
1494	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1495	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TFI')
1496END
1497GO
1498SET IDENTITY_INSERT [dbo].[tmp_TFI] OFF
1499
1500DROP TABLE [dbo].[TFI]
1501GO
1502IF @@ERROR<>0 
1503Begin
1504	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1505	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TFI')
1506END
1507GO
1508EXECUTE sp_rename N'[dbo].[tmp_TFI]', N'TFI', 'OBJECT'
1509
1510IF @@ERROR<>0 
1511Begin
1512	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1513	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TFI')
1514END
1515GO
1516
1517IF @@TRANCOUNT=0 BEGIN TRANSACTION
1518GO
1519SET ANSI_NULLS ON
1520GO
1521SET QUOTED_IDENTIFIER ON
1522GO
1523
1524CREATE TABLE [dbo].[tmp_TOWN] (
1525	[TOWN_REF] [int] IDENTITY (1,1) NOT NULL,
1526	[NAME] [varchar](30) COLLATE Latin1_General_CI_AS NULL,
1527	[TYPE] [varchar](1) COLLATE Latin1_General_CI_AS NULL
1528) ON [PRIMARY]
1529
1530IF @@ERROR<>0 
1531Begin
1532	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1533	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TOWN')
1534END
1535GO
1536SET IDENTITY_INSERT [dbo].[tmp_TOWN] ON
1537IF EXISTS (SELECT * FROM [dbo].[TOWN])
1538	EXEC
1539	('
1540		INSERT INTO [dbo].[tmp_TOWN] ([TOWN_REF],[NAME],[TYPE])
1541		SELECT [TOWN_REF],[NAME],[TYPE] FROM [dbo].[TOWN] TABLOCKX
1542	')
1543IF @@ERROR<>0 
1544Begin
1545	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1546	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TOWN')
1547END
1548GO
1549SET IDENTITY_INSERT [dbo].[tmp_TOWN] OFF
1550
1551DROP TABLE [dbo].[TOWN]
1552GO
1553IF @@ERROR<>0 
1554Begin
1555	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1556	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TOWN')
1557END
1558GO
1559EXECUTE sp_rename N'[dbo].[tmp_TOWN]', N'TOWN', 'OBJECT'
1560
1561IF @@ERROR<>0 
1562Begin
1563	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1564	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TOWN')
1565END
1566GO
1567
1568IF @@TRANCOUNT=0 BEGIN TRANSACTION
1569GO
1570SET ANSI_NULLS ON
1571GO
1572SET QUOTED_IDENTIFIER ON
1573GO
1574
1575CREATE TABLE [dbo].[tmp_TRANSFER_FILE_IMAGE] (
1576	[TFI_UNIQUE] [int] IDENTITY (1,1) NOT NULL,
1577	[KEY_VALUE] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
1578	[ENTIRE_RECORD] [ntext] COLLATE Latin1_General_CI_AS NULL,
1579	[ENTRY_DATE] [datetime] NULL,
1580	[USERID] [varchar](50) COLLATE Latin1_General_CI_AS NULL
1581) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1582
1583IF @@ERROR<>0 
1584Begin
1585	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1586	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TRANSFER_FILE_IMAGE')
1587END
1588GO
1589SET IDENTITY_INSERT [dbo].[tmp_TRANSFER_FILE_IMAGE] ON
1590IF EXISTS (SELECT * FROM [dbo].[TRANSFER_FILE_IMAGE])
1591	EXEC
1592	('
1593		INSERT INTO [dbo].[tmp_TRANSFER_FILE_IMAGE] ([TFI_UNIQUE],[KEY_VALUE],[ENTIRE_RECORD],[ENTRY_DATE],[USERID])
1594		SELECT [TFI_UNIQUE],[KEY_VALUE],[ENTIRE_RECORD],[ENTRY_DATE],[USERID] FROM [dbo].[TRANSFER_FILE_IMAGE] TABLOCKX
1595	')
1596IF @@ERROR<>0 
1597Begin
1598	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1599	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TRANSFER_FILE_IMAGE')
1600END
1601GO
1602SET IDENTITY_INSERT [dbo].[tmp_TRANSFER_FILE_IMAGE] OFF
1603
1604DROP TABLE [dbo].[TRANSFER_FILE_IMAGE]
1605GO
1606IF @@ERROR<>0 
1607Begin
1608	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1609	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TRANSFER_FILE_IMAGE')
1610END
1611GO
1612EXECUTE sp_rename N'[dbo].[tmp_TRANSFER_FILE_IMAGE]', N'TRANSFER_FILE_IMAGE', 'OBJECT'
1613
1614IF @@ERROR<>0 
1615Begin
1616	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1617	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TRANSFER_FILE_IMAGE')
1618END
1619GO
1620
1621IF @@TRANCOUNT=0 BEGIN TRANSACTION
1622GO
1623SET ANSI_NULLS ON
1624GO
1625SET QUOTED_IDENTIFIER ON
1626GO
1627
1628CREATE TABLE [dbo].[tmp_TRANSFER_FILE_IMAGE_ARCHIVE] (
1629	[TFI_ARCHIVE_UNIQUE] [int] IDENTITY (1,1) NOT NULL,
1630	[KEY_VALUE] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
1631	[VERSION_NUMBER] [int] NOT NULL,
1632	[ENTIRE_RECORD] [ntext] COLLATE Latin1_General_CI_AS NULL,
1633	[ENTRY_DATE] [datetime] NULL,
1634	[USERID] [varchar](50) COLLATE Latin1_General_CI_AS NULL
1635) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1636
1637IF @@ERROR<>0 
1638Begin
1639	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1640	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TRANSFER_FILE_IMAGE_ARCHIVE')
1641END
1642GO
1643SET IDENTITY_INSERT [dbo].[tmp_TRANSFER_FILE_IMAGE_ARCHIVE] ON
1644IF EXISTS (SELECT * FROM [dbo].[TRANSFER_FILE_IMAGE_ARCHIVE])
1645	EXEC
1646	('
1647		INSERT INTO [dbo].[tmp_TRANSFER_FILE_IMAGE_ARCHIVE] ([TFI_ARCHIVE_UNIQUE],[KEY_VALUE],[VERSION_NUMBER],[ENTIRE_RECORD],[ENTRY_DATE],[USERID])
1648		SELECT [TFI_ARCHIVE_UNIQUE],[KEY_VALUE],[VERSION_NUMBER],[ENTIRE_RECORD],[ENTRY_DATE],[USERID] FROM [dbo].[TRANSFER_FILE_IMAGE_ARCHIVE] TABLOCKX
1649	')
1650IF @@ERROR<>0 
1651Begin
1652	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1653	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TRANSFER_FILE_IMAGE_ARCHIVE')
1654END
1655GO
1656SET IDENTITY_INSERT [dbo].[tmp_TRANSFER_FILE_IMAGE_ARCHIVE] OFF
1657
1658DROP TABLE [dbo].[TRANSFER_FILE_IMAGE_ARCHIVE]
1659GO
1660IF @@ERROR<>0 
1661Begin
1662	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1663	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TRANSFER_FILE_IMAGE_ARCHIVE')
1664END
1665GO
1666EXECUTE sp_rename N'[dbo].[tmp_TRANSFER_FILE_IMAGE_ARCHIVE]', N'TRANSFER_FILE_IMAGE_ARCHIVE', 'OBJECT'
1667
1668IF @@ERROR<>0 
1669Begin
1670	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1671	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter table dbo.TRANSFER_FILE_IMAGE_ARCHIVE')
1672END
1673GO
1674
1675SET ANSI_NULLS ON
1676GO
1677SET QUOTED_IDENTIFIER ON
1678GO
1679ALTER TABLE [dbo].[STREET] ADD 
1680	CONSTRAINT [DF__STREET__release___3864608B] DEFAULT ((1)) FOR [release_number]
1681GO
1682
1683IF @@TRANCOUNT=0 BEGIN TRANSACTION
1684GO
1685SET QUOTED_IDENTIFIER ON
1686GO
1687SET ANSI_NULLS ON
1688GO
1689CREATE TRIGGER [dbo].[trg_BI_SUCCESSOR_XREF]
1690 ON [dbo].[SUCCESSOR_XREF]
1691FOR INSERT AS
1692DECLARE @LASTSUCCKEY VARCHAR(14),@AUTHCODE VARCHAR(4),@TMPKEYVALUE VARCHAR(14);
1693BEGIN
1694SELECT @TMPKEYVALUE = INS.SUCC_KEY FROM INSERTED INS;
1695PRINT @TMPKEYVALUE
1696IF @TMPKEYVALUE ='' or @TMPKEYVALUE is null
1697BEGIN
1698	SELECT @AUTHCODE=right('0000'+auth_CODE,4) from AUTHORITY WHERE USED_AUTH='Y';
1699	PRINT @AUTHCODE;
1700	SELECT @LASTSUCCKEY =RIGHT('000000000'+CAST(UNIQUE_SUCCESSOR_XREF AS VARCHAR),9) FROM INSERTED INS;
1701	PRINT @LASTSUCCKEY;
1702	SET @TMPKEYVALUE=@AUTHCODE+'S'+@LASTSUCCKEY;
1703	UPDATE SUCCESSOR_XREF SET SUCC_KEY = @TMPKEYVALUE WHERE UNIQUE_SUCCESSOR_XREF IN(SELECT UNIQUE_SUCCESSOR_XREF  FROM INSERTED);	
1704	PRINT @TMPKEYVALUE;
1705END
1706UPDATE METADATA SET SUCC_KEY = @TMPKEYVALUE WHERE CUSTODIAN_CODE = @AUTHCODE;
1707END;
1708
1709GO
1710IF @@ERROR<>0 
1711Begin
1712	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1713	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.SUCCESSOR_XREF.trg_BI_SUCCESSOR_XREF')
1714END
1715GO
1716SET QUOTED_IDENTIFIER OFF
1717GO
1718SET ANSI_NULLS ON
1719GO
1720
1721IF @@TRANCOUNT=0 BEGIN TRANSACTION
1722GO
1723SET QUOTED_IDENTIFIER ON
1724GO
1725SET ANSI_NULLS ON
1726GO
1727create TRIGGER [dbo].[trg_AI_BLPU]
1728ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT]
1729FOR INSERT 
1730AS
1731DECLARE	  
1732  @AUTHTYPE VARCHAR(2),@LOCALONLYPRIORITY VARCHAR(3),@DATEVALUE VARCHAR(15),@KEYVALUE VARCHAR(100),
1733  @LASTCANKEY VARCHAR(14),  @AUTHCODE VARCHAR(4),  @NEWUPRN FLOAT, @NEWBLPUCLASS VARCHAR(4),
1734  @NEWLOGSTATUS VARCHAR(1), @NEWORG varchar(100);
1735BEGIN 
1736	SELECT @AUTHCODE=right('0000'+auth_CODE,4) from AUTHORITY WHERE USED_AUTH='Y';
1737  	select @AUTHTYPE= AUTHORITY_TYPE from AUTHORITY WHERE USED_AUTH='Y'; 
1738	SELECT @NEWUPRN=UPRN FROM INSERTED;
1739	SELECT @NEWBLPUCLASS=BLPU_CLASS FROM INSERTED;
1740        SELECT @NEWORG=ORGANISATION FROM INSERTED;
1741        SELECT @NEWLOGSTATUS = LOGICAL_STATUS FROM INSERTED;
1742  	SELECT @LASTCANKEY = CAN_KEY FROM INSERTED;
1743	SELECT @LOCALONLYPRIORITY = LOCALONLY_PRIORITY FROM INSERTED;
1744    IF CHARINDEX(@AUTHTYPE,'S')>0
1745   	If (@NEWBLPUCLASS <>'' AND @NEWLOGSTATUS ='5' AND @LASTCANKEY <>'') 
1746	BEGIN
1747   	   INSERT INTO BLPU_CLASSIFICATION(UPRN,CLASS_KEY,blpu_class,CLASS_SCHEME,START_DATE,ENTRY_DATE,LAST_UPDATE_DATE,LOCALONLY_PRIORITY)
1748   	    VALUES(@NEWUPRN,@LASTCANKEY,@NEWBLPUCLASS,'Scottish Gazetteer Conventions V1.0',getdate(),getdate(),getdate(),@LOCALONLYPRIORITY);
1749	END;
1750   	ELSE IF (@NEWBLPUCLASS <> '' AND @NEWLOGSTATUS <>'5') 
1751   	 INSERT INTO BLPU_CLASSIFICATION(UPRN,blpu_class,CLASS_SCHEME,START_DATE,ENTRY_DATE,LAST_UPDATE_DATE,LOCALONLY_PRIORITY)
1752   	    VALUES(@NEWUPRN,@NEWBLPUCLASS,'Scottish Gazetteer Conventions V1.0',getdate(),getdate(),getdate(),@LOCALONLYPRIORITY);
1753
1754   	If (@NEWORG <>'' AND @NEWLOGSTATUS ='5' AND @LASTCANKEY <>'') 
1755   		INSERT INTO ORGANISATION(UPRN,ORG_KEY,ORGANISATION,START_DATE,ENTRY_DATE,LAST_UPDATE_DATE,LOCALONLY_PRIORITY)
1756   	   VALUES(@NEWUPRN,@LASTCANKEY,@NEWORG,getdate(),getdate(),getdate(),@LOCALONLYPRIORITY);
1757   	ELSE If (@NEWORG  <>'' AND @NEWLOGSTATUS  <>'5')
1758   	   INSERT INTO ORGANISATION(UPRN,ORGANISATION,START_DATE,ENTRY_DATE,LAST_UPDATE_DATE,LOCALONLY_PRIORITY)
1759   	   VALUES(@NEWUPRN, @NEWORG, getdate(), getdate() ,getdate(),@LOCALONLYPRIORITY);
1760END;
1761
1762GO
1763IF @@ERROR<>0 
1764Begin
1765	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1766	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.BASIC_LAND_AND_PROPERTY_UNIT.trg_AI_BLPU')
1767END
1768GO
1769SET QUOTED_IDENTIFIER OFF
1770GO
1771SET ANSI_NULLS ON
1772GO
1773
1774IF @@TRANCOUNT=0 BEGIN TRANSACTION
1775GO
1776SET QUOTED_IDENTIFIER ON
1777GO
1778SET ANSI_NULLS ON
1779GO
1780CREATE TRIGGER [dbo].[trg_BD_BLPU]
1781ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT]
1782for DELETE 
1783as
1784DECLARE
1785  @UPRNCOUNT INTEGER, @TFICOUNT INTEGER, @UPRN FLOAT,
1786  @LOGSTATUS VARCHAR(1),@CANKEY VARCHAR(14);  
1787BEGIN 	
1788  SELECT @UPRN = UPRN FROM DELETED;
1789  SELECT @LOGSTATUS = LOGICAL_STATUS FROM DELETED;
1790  SELECT @CANKEY = CAN_KEY FROM DELETED;
1791  DELETE FROM BLPU_HISTORY WHERE UPRN=@UPRN;  
1792  SELECT @UPRNCOUNT = COUNT(UPRN) FROM BLPU_DELETED WHERE UPRN = @UPRN;
1793  IF @LOGSTATUS =  '5' 
1794  BEGIN
1795    DELETE FROM BLPU_CANDIDATE WHERE CAN_KEY = @CANKEY;
1796    SELECT @TFICOUNT=COUNT(TFI_UNIQUE)  FROM CANDIDATE_TFI WHERE
1797    KEY_VALUE LIKE '24%'+@CANKEY+'%';
1798    IF @TFICOUNT=0 
1799    DELETE FROM CANDIDATE_TFI WHERE KEY_VALUE LIKE '21%'+@CANKEY+'%';
1800  END;
1801  if @UPRNCOUNT=0 
1802    INSERT INTO BLPU_DELETED SELECT * FROM DELETED WHERE UPRN = @UPRN;
1803END;
1804
1805GO
1806IF @@ERROR<>0 
1807Begin
1808	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1809	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.BASIC_LAND_AND_PROPERTY_UNIT.trg_BD_BLPU')
1810END
1811GO
1812SET QUOTED_IDENTIFIER OFF
1813GO
1814SET ANSI_NULLS ON
1815GO
1816
1817IF @@TRANCOUNT=0 BEGIN TRANSACTION
1818GO
1819SET QUOTED_IDENTIFIER ON
1820GO
1821SET ANSI_NULLS ON
1822GO
1823CREATE TRIGGER [dbo].[trg_BI_BLPU]
1824ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT]
1825FOR INSERT 
1826AS
1827DECLARE	  
1828  @AUTHTYPE VARCHAR(14), @NEWORGKEY VARCHAR(14), @NEWBLPUCLASSKEY VARCHAR(14),
1829  @LINEOFTEXT VARCHAR(255), @DATEVALUE VARCHAR(15), @KEYVALUE VARCHAR(100),@BLPUCLASS VARCHAR(4),
1830  @UPRN FLOAT, @ORG VARCHAR(100),@NEWBLPUCLASS VARCHAR(4), @NEWORG VARCHAR(100),
1831  @NEWLOGSTATUS VARCHAR(1), @LOCALONLYPRIORITY VARCHAR(3), @CUSTODIANTWO INTEGER,
1832  @LASTCANKEY VARCHAR(14),@AUTHCODE VARCHAR(4), @CANKEY VARCHAR(14);
1833BEGIN 
1834  select @AUTHTYPE = AUTHORITY_TYPE from AUTHORITY WHERE USED_AUTH='Y'; 
1835   SELECT @AUTHCODE=AUTH_CODE FROM AUTHORITY WHERE USED_AUTH = 'Y';
1836   SELECT @DATEVALUE = CONVERT(VARCHAR(10),GETDATE(),120);
1837   SELECT @UPRN = UPRN FROM  INSERTED;
1838   SELECT @BLPUCLASS = BLPU_CLASS FROM INSERTED;
1839   SELECT @ORG= ORGANISATION FROM INSERTED;  
1840   SELECT @NEWLOGSTATUS = LOGICAL_STATUS FROM INSERTED;
1841   SELECT @CUSTODIANTWO = CUSTODIANTWO FROM INSERTED;
1842   SELECT @CANKEY = CAN_KEY FROM INSERTED;
1843   SELECT @LASTCANKEY = LAST_CAN_KEY FROM METADATA WHERE CUSTODIAN_CODE = @AUTHCODE;
1844  If (@NEWLOGSTATUS = '5' AND @CANKEY IS NULL) 
1845  BEGIN
1846    IF @LASTCANKEY=''       	    
1847	SET @LASTCANKEY = @AUTHCODE+'C'+'000000001' 
1848    ELSE  
1849	select @LASTCANKEY=@AUTHCODE+'C'+RIGHT('000000000'+CAST(cast(substring(LAST_CAN_KEY,6,14) as integer)+1 AS VARCHAR),9) from metadata;           
1850     INSERT INTO BLPU_CANDIDATE (uprn, custodian_code, xref, yref, logical_status, rep_point_code, start_date,
1851     end_date, entry_date, last_update_date, blpustate, blpu_state_date, blpu_class, parent_uprn, organisation,
1852     wardcode, parishcode, custodianone, custodiantwo, can_key, request_source, candidate_flag)
1853     SELECT uprn, custodian_code, xref, yref,LOGICAL_STATUS, rep_point_code, start_date,
1854     end_date, entry_date, last_update_date, blpustate, blpu_state_date, blpu_class, parent_uprn, organisation, wardcode, parishcode, 
1855     snnflag, custodiantwo, @LASTCANKEY, @AUTHCODE , 'C01' FROM INSERTED;
1856     UPDATE BASIC_LAND_AND_PROPERTY_UNIT SET CAN_KEY = @LASTCANKEY WHERE UPRN = @UPRN;
1857     UPDATE METADATA SET last_can_key = @LASTCANKEY WHERE CUSTODIAN_CODE = @AUTHCODE;
1858   End;   
1859 End;
1860
1861GO
1862IF @@ERROR<>0 
1863Begin
1864	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1865	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.BASIC_LAND_AND_PROPERTY_UNIT.trg_BI_BLPU')
1866END
1867GO
1868SET QUOTED_IDENTIFIER OFF
1869GO
1870SET ANSI_NULLS ON
1871GO
1872
1873IF @@TRANCOUNT=0 BEGIN TRANSACTION
1874GO
1875SET QUOTED_IDENTIFIER ON
1876GO
1877SET ANSI_NULLS ON
1878GO
1879CREATE TRIGGER [dbo].[trg_BI_BLPU_CLASSIFICATION]
1880ON [dbo].[BLPU_CLASSIFICATION]
1881for INSERT 
1882AS
1883DECLARE	
1884	@LASTBLPUCLASSKEY VARCHAR(14),@AUTHCODE VARCHAR(4), @BLPUclassKEY VARCHAR(14),
1885	@LOCALONLYPRIORITY VARCHAR(3), @LASTCANKEY VARCHAR(14), @UNIQUEBLPUCLASS INTEGER,
1886	@UPRN FLOAT, @BLPUCLASS VARCHAR(100);
1887
1888BEGIN 
1889   SELECT @AUTHCODE=right('0000'+auth_CODE,4) from AUTHORITY WHERE USED_AUTH='Y';
1890   SELECT @LASTCANKEY = LAST_CAN_KEY FROM METADATA WHERE CUSTODIAN_CODE = @AUTHCODE;
1891   SELECT @LOCALONLYPRIORITY = LOCALONLY_PRIORITY FROM INSERTED;
1892   SELECT @UNIQUEBLPUCLASS = UNIQUE_BLPUCLASS FROM INSERTED;
1893   SELECT @BLPUCLASSKEY = CLASS_KEY FROM INSERTED;
1894   SELECT @UPRN = UPRN FROM INSERTED;
1895   SELECT @BLPUCLASS = BLPU_CLASS FROM INSERTED; 
1896
1897   If charindex(@LOCALONLYPRIORITY,'C')>0 AND @BLPUCLASSKEY=''
1898   BEGIN  	   
1899	IF @LASTCANKEY =''        			
1900		SET @LASTCANKEY=@AUTHCODE+'C'+'000000001'
1901	else
1902		select @LASTCANKEY=@AUTHCODE+'C'+RIGHT('000000000'+CAST(cast(substring(LAST_CAN_KEY,6,14) as integer)+1 AS VARCHAR),9) 
1903			from metadata;
1904   	UPDATE BLPU_CLASSIFICATION SET CLASS_KEY = @LASTCANKEY WHERE UNIQUE_BLPUCLASS = @UNIQUEBLPUCLASS;   		
1905	INSERT INTO BLPU_CANDIDATE (uprn, custodian_code, xref, yref, logical_status, rep_point_code, start_date,
1906	     	end_date, entry_date, last_update_date, blpustate, blpu_state_date,parent_uprn, BLPU_CLASS, custodiantwo, 
1907		can_key, request_source, candidate_flag)
1908		SELECT UPRN,CUSTODIAN_CODE,XREF,YREF,'5',REP_POINT_CODE,START_DATE,END_DATE, ENTRY_DATE, LAST_UPDATE_DATE,
1909		BLPUSTATE, BLPU_STATE_DATE,PARENT_UPRN,@BLPUCLASS,1,@LASTCANKEY,CUSTODIAN_CODE,'C01' FROM BASIC_LAND_AND_PROPERTY_UNIT
1910		WHERE UPRN = @UPRN;	
1911   	UPdate metadata set LAST_CAN_KEY=@LASTCANKEY WHERE CUSTODIAN_CODE = @AUTHCODE;
1912   END;
1913   ELSE IF @BLPUCLASSKEY=''  or @blpuclasskey is null  
1914	SELECT @LASTBLPUCLASSKEY =RIGHT('000000000'+CAST(UNIQUE_BLPUCLASS AS VARCHAR),9) FROM INSERTED INS;
1915	PRINT @LASTBLPUCLASSKEY;
1916	SET @LASTBLPUCLASSKEY =@AUTHCODE+'B'+@LASTBLPUCLASSKEY ;
1917	UPDATE BLPU_CLASSIFICATION SET CLASS_KEY = @LASTBLPUCLASSKEY WHERE UNIQUE_BLPUCLASS=@UNIQUEBLPUCLASS;
1918	UPdate metadata set LAST_CAN_KEY=@LASTBLPUCLASSKEY  WHERE CUSTODIAN_CODE = @AUTHCODE;
1919   
1920END;
1921
1922GO
1923IF @@ERROR<>0 
1924Begin
1925	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1926	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.BLPU_CLASSIFICATION.trg_BI_BLPU_CLASSIFICATION')
1927END
1928GO
1929SET QUOTED_IDENTIFIER OFF
1930GO
1931SET ANSI_NULLS ON
1932GO
1933
1934IF @@TRANCOUNT=0 BEGIN TRANSACTION
1935GO
1936SET QUOTED_IDENTIFIER ON
1937GO
1938SET ANSI_NULLS ON
1939GO
1940CREATE TRIGGER [dbo].[trg_BI_ORG_KEY]
1941ON [dbo].[ORGANISATION]
1942for INSERT 
1943as
1944DECLARE	
1945	@LASTORGKEY VARCHAR(14),@AUTHCODE VARCHAR(4), @ORGKEY VARCHAR(14),
1946	@LOCALONLYPRIORITY VARCHAR(3), @LASTCANKEY VARCHAR(14), 
1947	@UNIQUEORG INTEGER,@UPRN FLOAT, @ORGANISATION VARCHAR(100);  
1948BEGIN 
1949   SELECT @AUTHCODE=right('0000'+auth_CODE,4) from AUTHORITY WHERE USED_AUTH='Y';
1950   SELECT @LASTCANKEY = LAST_CAN_KEY FROM METADATA WHERE CUSTODIAN_CODE = @AUTHCODE;
1951   SELECT @LOCALONLYPRIORITY = LOCALONLY_PRIORITY FROM INSERTED;
1952   SELECT @UNIQUEORG = UNIQUE_ORG FROM INSERTED;
1953   SELECT @ORGKEY = ORG_KEY FROM INSERTED;
1954   SELECT @UPRN = UPRN FROM INSERTED;
1955   SELECT @ORGANISATION= ORGANISATION FROM INSERTED;    
1956	If charindex(@LOCALONLYPRIORITY,'C')>0 AND @ORGKEY=''
1957	BEGIN  	   
1958		IF @LASTCANKEY =''        			
1959			SET @LASTCANKEY=@AUTHCODE+'C'+'000000001'
1960		else
1961			select @LASTCANKEY=@AUTHCODE+'C'+RIGHT('000000000'+CAST(cast(substring(LAST_CAN_KEY,6,14) as integer)+1 AS VARCHAR),9) 
1962			from metadata;
1963		UPDATE ORGANISATION SET ORG_KEY = @LASTCANKEY WHERE UNIQUE_ORG = @UNIQUEORG;		
1964		INSERT INTO BLPU_CANDIDATE (uprn, custodian_code, xref, yref, logical_status, rep_point_code, start_date,
1965	     	end_date, entry_date, last_update_date, blpustate, blpu_state_date,parent_uprn, organisation, custodiantwo, 
1966		can_key, request_source, candidate_flag)
1967		SELECT UPRN,CUSTODIAN_CODE,XREF,YREF,'5',REP_POINT_CODE,START_DATE,END_DATE, ENTRY_DATE, LAST_UPDATE_DATE,
1968		BLPUSTATE, BLPU_STATE_DATE,PARENT_UPRN,@ORGANISATION,1,@LASTCANKEY,CUSTODIAN_CODE,'C01' FROM BASIC_LAND_AND_PROPERTY_UNIT
1969		WHERE UPRN = @UPRN;
1970		UPdate metadata set LAST_CAN_KEY=@LASTCANKEY WHERE CUSTODIAN_CODE = @AUTHCODE;
1971	END;
1972	elsE IF @ORGKEY ='' or @orgkey is null 
1973	      	SELECT @LASTORGKEY =RIGHT('000000000'+CAST(UNIQUE_ORG AS VARCHAR),9) FROM INSERTED;
1974      	      	SET @LASTORGKEY  =@AUTHCODE+'O'+@LASTORGKEY;
1975	        UPDATE ORGANISATION SET ORG_KEY = @LASTORGKEY  WHERE UNIQUE_ORG =@UNIQUEORG;
1976		UPDATE METADATA SET org_key = @LASTORGKEY WHERE CUSTODIAN_CODE = @AUTHCODE;
1977
1978END;
1979
1980GO
1981IF @@ERROR<>0 
1982Begin
1983	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
1984	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.ORGANISATION.trg_BI_ORG_KEY')
1985END
1986GO
1987SET QUOTED_IDENTIFIER OFF
1988GO
1989SET ANSI_NULLS ON
1990GO
1991
1992IF @@TRANCOUNT=0 BEGIN TRANSACTION
1993GO
1994SET QUOTED_IDENTIFIER ON
1995GO
1996SET ANSI_NULLS ON
1997GO
1998create TRIGGER [dbo].[TRG_AI_AU_BLPU_CANDIDATE]
1999ON [dbo].[BLPU_CANDIDATE]
2000for update
2001as
2002DECLARE
2003 @AUTHTYPE VARCHAR(14), @NEWUPRN FLOAT,@CUSTTWO INTEGER, @BLPUAUTHCODE VARCHAR(4), @UPRN FLOAT, @AUTHCODE VARCHAR(4),
2004 @CANDIDATEFLAG VARCHAR(3), @LINEOFTEXT VARCHAR(255), @CANKEY VARCHAR(14),@BLPUSTATEDATE VARCHAR(10),@STARTDATE VARCHAR(10),
2005 @ENDDATE VARCHAR(10), @LASTUPDATEDATE VARCHAR(10), @ENTRYDATE VARCHAR(10),@KEYVALUE VARCHAR(20);
2006BEGIN  
2007  SET @NEWUPRN='';
2008print 'TRG_AI_AU_BLPU_CANDIDATE'
2009  select @AUTHTYPE = AUTHORITY_TYPE from AUTHORITY WHERE USED_AUTH='Y'; 
2010print @authtype;
2011  SELECT @CUSTTWO = CUSTODIANTWO FROM INSERTED;
2012print @CUSTTWO;
2013  SELECT @CANDIDATEFLAG = CANDIDATE_FLAG FROM INSERTED;
2014print @CANDIDATEFLAG;
2015  SELECT @CANKEY = CAN_KEY FROM INSERTED;
2016print 'cankey ='+@CANKEY;
2017  SELECT @UPRN = UPRN FROM INSERTED;
2018print @UPRN;
2019  select @AUTHCODE = AUTH_CODE from AUTHORITY WHERE USED_AUTH='Y';
2020print @AUTHCODE;
2021  select @BLPUSTATEDATE = CONVERT(VARCHAR(10), BLPU_STATE_DATE, 120)  FROM INSERTED;
2022print @BLPUSTATEDATE;
2023  SELECT @STARTDATE = CONVERT(VARCHAR(10), START_DATE, 120)  FROM INSERTED;
2024print @STARTDATE;
2025  SELECT @ENDDATE = CONVERT(VARCHAR(10), END_DATE, 120)  FROM INSERTED;
2026print @ENDDATE;
2027  SELECT @LASTUPDATEDATE= CONVERT(VARCHAR(10), LAST_UPDATE_DATE, 120)  FROM INSERTED;
2028print @LASTUPDATEDATE;
2029  SELECT @ENTRYDATE = CONVERT(VARCHAR(10), ENTRY_DATE, 120)  FROM INSERTED;
2030print @ENTRYDATE;
2031  IF @CUSTTWO IS NOT NULL 
2032	SELECT @BLPUAUTHCODE =CUSTODIAN_CODE FROM BASIC_LAND_AND_PROPERTY_UNIT WHERE UPRN = @UPRN;
2033  IF @BLPUAUTHCODE <> @AUTHCODE 
2034    SET @NEWUPRN=@UPRN;
2035  IF @CANDIDATEFLAG = 'C01' and Len(@CANKEY)=14 
2036  begin	
2037    SET @LINEOFTEXT = '21,"C",';
2038    IF @CUSTTWO = 1 
2039    bEGIN
2040     SET @NEWUPRN = @UPRN;
2041     SET @LINEOFTEXT = @LINEOFTEXT + Isnull(convert(varchar(100),cast(@NEWUPRN as decimal(12,0))),'');
2042    END;
2043   print @lineoftext;
2044    SELECT @LINEOFTEXT =  @LINEOFTEXT + ',' +  IsNull(LOGICAL_STATUS,'')+','+
2045	IsNull(CONVERT(VARCHAR(1),BLPUSTATE),'')+ ',"' + IsNull(BLPU_CLASS,'') +'",'+
2046    Isnull(convert(varchar(100),cast(parent_uprn as decimal(12,0))),'') 
2047+','+Isnull(CONVERT(VARCHAR(10),XREF),'')+','+
2048Isnull(CONVERT(VARCHAR(10),YREF),'')+','+
2049 IsNull(convert(varchar(1),REP_POINT_CODE),'')
2050    +','+IsNull(convert(varchar(4),CUSTODIAN_CODE),'') + ','+ 
2051Isnull(@STARTDATE,'')+','+Isnull(@ENDDATE,'') +	
2052    ','+ISnull(@LASTUPDATEDATE,'') +','+ Isnull(@ENTRYDATE,'')+',"'+
2053    IsNull(ORGANISATION,'')+'","'+IsNull(WARDCODE,'')+'","'+
2054IsNull(PARISHCODE,'')+'",'+ISnull(CONVERT(VARCHAR(4),CUSTODIANONE),'')
2055+','+Isnull(CONVERT(VARCHAR(4),CUSTODIANTWO),'')
2056	+',"'+IsNull(CAN_KEY,'')+'"' from Inserted;      
2057      SET @KEYVALUE = '21' +  Isnull(convert(varchar(100),cast(@NEWUPRN as decimal(12,0))),'') 
2058		 + IsNull(@CANKEY,'');
2059	
2060    INSERT INTO CANDIDATE_TFI(KEY_VALUE,ENTIRE_RECORD,ENTRY_DATE)      
2061      VALUES(@KEYVALUE,@LINEOFTEXT,GETDATE());
2062  end;
2063END;
2064
2065GO
2066IF @@ERROR<>0 
2067Begin
2068	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2069	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.BLPU_CANDIDATE.TRG_AI_AU_BLPU_CANDIDATE')
2070END
2071GO
2072SET QUOTED_IDENTIFIER OFF
2073GO
2074SET ANSI_NULLS ON
2075GO
2076
2077IF @@TRANCOUNT=0 BEGIN TRANSACTION
2078GO
2079SET QUOTED_IDENTIFIER ON
2080GO
2081SET ANSI_NULLS ON
2082GO
2083Create TRIGGER [dbo].[TRG_BI_BU_BLPU_CANDIDATE]
2084ON [dbo].[BLPU_CANDIDATE]
2085FOR INSERT,update
2086AS
2087DECLARE
2088	@LASTCANKEY VARCHAR(14),@AUTHCODE VARCHAR(4),@CANKEY VARCHAR(14),@CANFLAG VARCHAR(3),
2089	@BLPUCANID FLOAT;
2090BEGIN
2091SELECT @AUTHCODE=right('0000'+auth_CODE,4) from AUTHORITY WHERE USED_AUTH='Y';
2092SELECT @CANKEY = CAN_KEY FROM INSERTED;
2093SELECT @BLPUCANID = BLPU_CANDIDATE_ID FROM INSERTED;
2094SELECT @CANFLAG = CANDIDATE_FLAG FROM INSERTED;
2095SELECT @LASTCANKEY = LAST_CAN_KEY FROM METADATA WHERE CUSTODIAN_CODE = @AUTHCODE;
2096print 'TRG_BI_BU_BLPU_CANDIDATE';
2097	IF (@CANFLAG = 'C01') and (len(@cankey)<>14 or @CANKEY is null) 
2098	BEGIN	
2099       	  IF (@LASTCANKEY ='') or (@LASTCANKEY IS NULL)
2100     		SET @LASTCANKEY=@AUTHCODE+'C'+'000000001';
2101          ELSE
2102      		select @LASTCANKEY=@AUTHCODE+'C'+RIGHT('000000000'+CAST(cast(substring(LAST_CAN_KEY,6,14) as integer)+1 AS VARCHAR),9) from metadata;	
2103	 UPDATE BLPU_CANDIDATE SET CAN_KEY = @LASTCANKEY WHERE BLPU_CANDIDATE_ID = @BLPUCANID;
2104     UPDATE METADATA SET last_can_key =@LASTCANKEY WHERE CUSTODIAN_CODE = @AUTHCODE;
2105    END;
2106END;
2107
2108GO
2109IF @@ERROR<>0 
2110Begin
2111	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2112	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.BLPU_CANDIDATE.TRG_BI_BU_BLPU_CANDIDATE')
2113END
2114GO
2115SET QUOTED_IDENTIFIER OFF
2116GO
2117SET ANSI_NULLS ON
2118GO
2119
2120IF @@TRANCOUNT=0 BEGIN TRANSACTION
2121GO
2122SET QUOTED_IDENTIFIER ON
2123GO
2124SET ANSI_NULLS ON
2125GO
2126create TRIGGER [dbo].[TRG_AI_AU_LPI_CANDIDATE]
2127ON [dbo].[LPI_CANDIDATE]
2128for  update,INSERT
2129AS
2130DECLARE
2131  @AUTHTYPE VARCHAR(14), @NEWUPRN FLOAT,@CUSTTWO INTEGER, @BLPUAUTHCODE VARCHAR(4), @UPRN FLOAT, @AUTHCODE VARCHAR(4),
2132 @CANDIDATEFLAG VARCHAR(3), @LINEOFTEXT VARCHAR(255), @CANKEY VARCHAR(14),@BLPUSTATEDATE VARCHAR(10),@STARTDATE VARCHAR(10),
2133 @ENDDATE VARCHAR(10), @LASTUPDATEDATE VARCHAR(10), @ENTRYDATE VARCHAR(10),@KEYVALUE VARCHAR(20);
2134BEGIN	 
2135  SET @NEWUPRN='';  
2136  SELECT @CUSTTWO = CUSTODIANTWO FROM INSERTED;
2137  SELECT @CANDIDATEFLAG = CANDIDATE_FLAG FROM INSERTED;
2138  SELECT @CANKEY = CAN_KEY FROM INSERTED;	
2139  SELECT @UPRN = UPRN FROM INSERTED;  
2140  SELECT @STARTDATE = CONVERT(VARCHAR(10), START_DATE, 120)  FROM INSERTED;
2141  SELECT @ENDDATE = CONVERT(VARCHAR(10), END_DATE, 120)  FROM INSERTED;
2142  SELECT @LASTUPDATEDATE= CONVERT(VARCHAR(10), LAST_UPDATE_DATE, 120)  FROM INSERTED;
2143  SELECT @ENTRYDATE = CONVERT(VARCHAR(10), ENTRY_DATE, 120)  FROM INSERTED;  
2144  IF @CANDIDATEFLAG = 'C01' and Len(@CANKEY)=14 
2145  begin
2146    SET @LINEOFTEXT = '24,"C",';
2147    IF @CUSTTWO IS NOT NULL 
2148    BEGIN
2149     SET @NEWUPRN = @UPRN;
2150     set @LINEOFTEXT= @LINEOFTEXT + Isnull(convert(varchar(100),cast(@NEWUPRN as decimal(12,0))),'');
2151    END;
2152    SELECT @LINEOFTEXT = @LINEOFTEXT + ',,"' + ISNULL(LANGUAGE_code,'')
2153    +'",'+ ISNULL(LOGICAL_STATUS,'') + ',' + IsNull(@STARTDATE,'') +','+
2154    ISnull(@ENDDATE,'') +','+ IsNull(@ENTRYDATE,'') +','  +
2155    IsNull(@LASTUPDATEDATE,'')  +','+ IsNull(CONVERT(VARCHAR(4),SAO_FROM),'')
2156    +',"'+ISNULL(SAO_FROM_SUFF,'') + '",'+ IsNull(CONVERT(VARCHAR(4),SAO_TO),'') 
2157	+',"'+ ISNULL(SAO_TO_SUFF,'')
2158    +'","'+ISNULL(sao_name,'') +'",'+  IsNull(CONVERT(VARCHAR(4),PAO_FROM),'')
2159    +',"'+ISNULL(PAO_FROM_SUFF,'') + '",'+ 
2160    IsNull(CONVERT(VARCHAR(4),PAO_TO),'') +',"'+ISNULL(PAO_TO_SUFF,'')
2161    +'","'+IsNull(Pao_name,'')+'",'+ IsNull(convert(varchar(8),USRN),'')+',"'+
2162    IsNull(LPI_LEVEL,'')+'","'+IsNull(POSTALLYADDRESSABLE,'')+'","'+IsNull(POSTCODE,'')+
2163    '","'+IsNull(POSTTOWN,'')+'","'+IsNull(OFFICIAL_flag,'')+'",'+ IsNull(convert(varchar(1),CUSTODIANONE),'')+
2164    ','+IsNull(Convert(varchar(1),CUSTODIANTWO),'') +',"'+IsNull(CAN_KEY,'')+'"' from Inserted;
2165     SET @KEYVALUE = '24' + Isnull(convert(varchar(100),cast(@NEWUPRN as decimal(12,0))),'')  + IsNull(@CANKEY,'');
2166    INSERT INTO CANDIDATE_TFI(KEY_VALUE,ENTIRE_RECORD,ENTRY_DATE)      
2167      VALUES(@KEYVALUE,@LINEOFTEXT,getDATE());
2168   End;
2169END;
2170
2171GO
2172IF @@ERROR<>0 
2173Begin
2174	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2175	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.LPI_CANDIDATE.TRG_AI_AU_LPI_CANDIDATE')
2176END
2177GO
2178SET QUOTED_IDENTIFIER OFF
2179GO
2180SET ANSI_NULLS ON
2181GO
2182
2183IF @@TRANCOUNT=0 BEGIN TRANSACTION
2184GO
2185SET QUOTED_IDENTIFIER ON
2186GO
2187SET ANSI_NULLS ON
2188GO
2189create TRIGGER [dbo].[TRG_BI_LPI_CANDIDATE]
2190ON [dbo].[LPI_CANDIDATE]
2191FOR INSERT , update
2192AS
2193DECLARE
2194	@LASTCANKEY VARCHAR(14),@AUTHCODE VARCHAR(4),@CANKEY VARCHAR(14),
2195	@CANFLAG VARCHAR(3),@UPRN float,
2196	@LPIUNIQUE INTEGER;
2197BEGIN
2198 SELECT @AUTHCODE=right('0000'+auth_CODE,4) from AUTHORITY WHERE USED_AUTH='Y';
2199 SELECT @CANKEY = CAN_KEY FROM INSERTED;
2200 SELECT @CANFLAG = CANDIDATE_FLAG FROM INSERTED;
2201 SELECT @LPIUNIQUE= LPI_CANDIDATE_ID FROM INSERTED;
2202 SELECT @UPRN = UPRN FROM INSERTED;
2203 SELECT @LASTCANKEY = LAST_CAN_KEY FROM METADATA WHERE CUSTODIAN_CODE = @AUTHCODE;
2204	IF @CANFLAG = 'C01' and (len(@cankey)<>14 or @CAnKey is null)
2205	BEGIN		  		
2206       	  IF (@LASTCANKEY ='') or (@LastCankey is null)
2207     		SET @LASTCANKEY=@AUTHCODE+'C'+'000000001';
2208          ELSE
2209      		select @LASTCANKEY=@AUTHCODE+'C'+RIGHT('000000000'+CAST(cast(substring(LAST_CAN_KEY,6,14) 	
2210		as integer)+1 AS VARCHAR),9) from metadata;
2211		print 'LastCanley='+ @lastCanKey;
2212	  ;;SET @CANKEY = @LASTCANKEY;
2213	  UPDATE LPI_CANDIDATE SET CAN_KEY = @LASTCANKEY,LPIKEY = @LASTCANKEY WHERE LPI_CANDIDATE_ID = @LPIUNIQUE;
2214          UPDATE METADATA SET last_can_key =@LASTCANKEY WHERE CUSTODIAN_CODE = @AUTHCODE;
2215	END;
2216END;
2217
2218GO
2219IF @@ERROR<>0 
2220Begin
2221	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2222	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.LPI_CANDIDATE.TRG_BI_LPI_CANDIDATE')
2223END
2224GO
2225SET QUOTED_IDENTIFIER OFF
2226GO
2227SET ANSI_NULLS ON
2228GO
2229
2230IF @@TRANCOUNT=0 BEGIN TRANSACTION
2231GO
2232SET QUOTED_IDENTIFIER ON
2233GO
2234SET ANSI_NULLS ON
2235GO
2236CREATE TRIGGER [dbo].[trg_BD_LPI]
2237ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER]
2238FOR DELETE 
2239AS
2240	DECLARE @LPI_UNIQUE INTEGER;
2241BEGIN 	
2242	SELECT @LPI_UNIQUE=LPI_UNIQUE FROM DELETED;
2243PRINT @LPI_UNIQUE;
2244  DELETE FROM LPI_HISTORY WHERE LPI_UNIQUE =@LPI_UNIQUE;
2245  DELETE FROM LPI_POSTALADR WHERE LPI_UNIQUE =@LPI_UNIQUE;
2246  INSERT INTO LPI_DELETED SELECT * FROM DELETED WHERE LPI_UNIQUE=@LPI_UNIQUE;
2247END;
2248
2249GO
2250IF @@ERROR<>0 
2251Begin
2252	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2253	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.LAND_AND_PROPERTY_IDENTIFIER.trg_BD_LPI')
2254END
2255GO
2256SET QUOTED_IDENTIFIER OFF
2257GO
2258SET ANSI_NULLS ON
2259GO
2260
2261IF @@TRANCOUNT=0 BEGIN TRANSACTION
2262GO
2263SET QUOTED_IDENTIFIER ON
2264GO
2265SET ANSI_NULLS ON
2266GO
2267create TRIGGER [dbo].[trgLPI]
2268ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER]
2269FOR INSERT
2270AS
2271DECLARE @LASTLPIKEY VARCHAR(14),@AUTHCODE VARCHAR(4),@TMPKEYVALUE VARCHAR(14),
2272@LPICOUNT INTEGER, @UPRN FLOAT, @LOGSTATUS VARCHAR(1), @CUSTODIANTWO INTEGER,
2273@LASTCANKEY VARCHAR(14),@LPIUNIQUE INTEGER, @CANKEY VARCHAR(14);
2274BEGIN
2275SELECT @AUTHCODE=RIGHT('0000'+cast(AUTH_CODE as varchar(5)), 4) from AUTHORITY WHERE USED_AUTH='Y';
2276SELECT @TMPKEYVALUE = INS.LPIKEY FROM INSERTED INS;
2277SELECT @UPRN = INS.UPRN FROM INSERTED INS;
2278SELECT @LOGSTATUS = INS.LOGICAL_STATUS FROM INSERTED INS;
2279SELECT @CUSTODIANTWO = INS.CUSTODIANTWO FROM INSERTED INS;
2280SELECT @LASTCANKEY = LAST_CAN_KEY FROM METADATA WHERE CUSTODIAN_CODE = @AUTHCODE;
2281SELECT @LPIUNIQUE= LPI_UNIQUE FROM INSERTED;
2282SELECT @CANKEY = CAN_KEY FROM INSERTED;
2283SELECT @LPICOUNT = COUNT(UPRN) FROM LAND_AND_PROPERTY_IDENTIFIER WHERE UPRN = @UPRN;
2284If (@LOGSTATUS = '5') and (@CANKEY is null)
2285BEGIN
2286  IF @LPICOUNT>0 
2287  BEGIN
2288    IF @LASTCANKEY=''       	    
2289	SET @LASTCANKEY = @AUTHCODE+'C'+'000000001' 
2290    ELSE  
2291	select @LASTCANKEY=@AUTHCODE+'C'+RIGHT('000000000'+CAST(cast(substring(LAST_CAN_KEY,6,14) as integer)+1 AS VARCHAR),9) from metadata;
2292  END  
2293  ELSE	
2294     SELECT @LASTCANKEY = CAN_KEY  FROM BASIC_LAND_AND_PROPERTY_UNIT WHERE UPRN = @UPRN;
2295  UPDATE LAND_AND_PROPERTY_IDENTIFIER SET LPIKEY = @LASTCANKEY, CAN_KEY = @LASTCANKEY
2296	 WHERE LPI_UNIQUE=@LPIUNIQUE;	   
2297     INSERT INTO LPI_CANDIDATE ( uprn, usrn, pao_from, pao_from_suff, pao_to, pao_to_suff, pao_name, 
2298     sao_from, sao_from_suff, sao_to, sao_to_suff, sao_name, posttown, postcode, lpi_level, logical_status, 
2299     start_date, end_date, entry_date, last_update_date, lpikey, postallyaddressable, custodianone, custodiantwo,
2300     can_key, language_code, request_source, candidate_flag,SUB_LOCALITY)
2301	SELECT uprn, usrn, pao_from, pao_from_suff, pao_to, pao_to_suff, pao_name, 
2302     sao_from, sao_from_suff, sao_to, sao_to_suff, sao_name, posttown, postcode, lpi_level, logical_status, 
2303     start_date, end_date, entry_date, last_update_date, @LASTCANKEY, postallyaddressable, custodianone, custodiantwo,
2304     @LASTCANKEY, language_code, @AUTHCODE, 'C01',SUB_LOCALITY FROM INSERTED;     
2305     UPDATE METADATA SET last_can_key =@LASTCANKEY WHERE CUSTODIAN_CODE = @AUTHCODE;
2306END
2307ELSE IF @TMPKEYVALUE ='' or @tmpkeyvalue is null
2308BEGIN	
2309	PRINT @AUTHCODE;
2310	SELECT @LASTLPIKEY = RIGHT('000000000'+CAST(LPI_UNIQUE AS VARCHAR),9) FROM INSERTED INS;
2311	PRINT @LASTLPIKEY;
2312	SET @TMPKEYVALUE=@AUTHCODE+'L'+@LASTLPIKEY;
2313	UPDATE LAND_AND_PROPERTY_IDENTIFIER SET LPIKEY = @TMPKEYVALUE WHERE LPI_UNIQUE =@LPIUNIQUE;	
2314	PRINT @TMPKEYVALUE;
2315END
2316UPDATE METADATA SET LPIKEY = @TMPKEYVALUE WHERE CUSTODIAN_CODE = @AUTHCODE;
2317END;
2318
2319GO
2320IF @@ERROR<>0 
2321Begin
2322	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2323	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add trigger dbo.LAND_AND_PROPERTY_IDENTIFIER.trgLPI')
2324END
2325GO
2326SET QUOTED_IDENTIFIER OFF
2327GO
2328SET ANSI_NULLS ON
2329GO
2330
2331IF @@TRANCOUNT=0 BEGIN TRANSACTION
2332GO
2333SET ANSI_NULLS ON
2334GO
2335SET QUOTED_IDENTIFIER ON
2336GO
2337ALTER TABLE [dbo].[OWE_HISTORY] ADD 
2338	CONSTRAINT [PK_OWE_HISTORY] PRIMARY KEY CLUSTERED 
2339	(
2340		[ESU_ID],[SEQUENCE_NUMBER],[AUTH_CODE],[VERSION_NUMBER]
2341	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2342GO
2343
2344IF @@ERROR<>0 
2345Begin
2346	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2347	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.OWE_HISTORY.PK_OWE_HISTORY')
2348END
2349GO
2350IF @@TRANCOUNT=0 BEGIN TRANSACTION
2351GO
2352SET ANSI_NULLS ON
2353GO
2354SET QUOTED_IDENTIFIER ON
2355GO
2356ALTER TABLE [dbo].[LOCALITY] ADD 
2357	CONSTRAINT [PKLOCALITY] PRIMARY KEY CLUSTERED 
2358	(
2359		[LOC_REF]
2360	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2361GO
2362
2363IF @@ERROR<>0 
2364Begin
2365	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2366	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.LOCALITY.PKLOCALITY')
2367END
2368GO
2369IF @@TRANCOUNT=0 BEGIN TRANSACTION
2370GO
2371SET ANSI_NULLS ON
2372GO
2373SET QUOTED_IDENTIFIER ON
2374GO
2375ALTER TABLE [dbo].[ORGANISATION_DELETED] ADD 
2376	CONSTRAINT [PK_ORG_DELETED] PRIMARY KEY CLUSTERED 
2377	(
2378		[UNIQUE_ORG]
2379	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2380GO
2381
2382IF @@ERROR<>0 
2383Begin
2384	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2385	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ORGANISATION_DELETED.PK_ORG_DELETED')
2386END
2387GO
2388IF @@TRANCOUNT=0 BEGIN TRANSACTION
2389GO
2390SET ANSI_NULLS ON
2391GO
2392SET QUOTED_IDENTIFIER ON
2393GO
2394ALTER TABLE [dbo].[POLICEFORCEAREA] ADD 
2395	CONSTRAINT [PK_POLICEFORCEAREA] PRIMARY KEY CLUSTERED 
2396	(
2397		[POLICEFORCEAREAID]
2398	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2399GO
2400
2401IF @@ERROR<>0 
2402Begin
2403	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2404	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.POLICEFORCEAREA.PK_POLICEFORCEAREA')
2405END
2406GO
2407IF @@TRANCOUNT=0 BEGIN TRANSACTION
2408GO
2409SET ANSI_NULLS ON
2410GO
2411SET QUOTED_IDENTIFIER ON
2412GO
2413ALTER TABLE [dbo].[PROVENANCE] ADD 
2414	CONSTRAINT [PK_PROVENANCE] PRIMARY KEY CLUSTERED 
2415	(
2416		[UPRN],[PROV_CODE]
2417	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2418GO
2419
2420IF @@ERROR<>0 
2421Begin
2422	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2423	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.PROVENANCE.PK_PROVENANCE')
2424END
2425GO
2426IF @@TRANCOUNT=0 BEGIN TRANSACTION
2427GO
2428SET ANSI_NULLS ON
2429GO
2430SET QUOTED_IDENTIFIER ON
2431GO
2432ALTER TABLE [dbo].[POLICEBEATCODE] ADD 
2433	CONSTRAINT [PK__POLICEBE__1FF25107164452B1] PRIMARY KEY CLUSTERED 
2434	(
2435		[POLICEBEATCODEID]
2436	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2437GO
2438
2439IF @@ERROR<>0 
2440Begin
2441	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2442	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.POLICEBEATCODE.PK__POLICEBE__1FF25107164452B1')
2443END
2444GO
2445IF @@TRANCOUNT=0 BEGIN TRANSACTION
2446GO
2447SET ANSI_NULLS ON
2448GO
2449SET QUOTED_IDENTIFIER ON
2450GO
2451ALTER TABLE [dbo].[PARISH] ADD 
2452	CONSTRAINT [PKPARISH] PRIMARY KEY CLUSTERED 
2453	(
2454		[PARISHCODE]
2455	) ON [PRIMARY];
2456GO
2457
2458IF @@ERROR<>0 
2459Begin
2460	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2461	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.PARISH.PKPARISH')
2462END
2463GO
2464IF @@TRANCOUNT=0 BEGIN TRANSACTION
2465GO
2466SET ANSI_NULLS ON
2467GO
2468SET QUOTED_IDENTIFIER ON
2469GO
2470ALTER TABLE [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ADD 
2471	CONSTRAINT [PKLPI] PRIMARY KEY CLUSTERED 
2472	(
2473		[LPI_UNIQUE]
2474	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2475GO
2476
2477IF @@ERROR<>0 
2478Begin
2479	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2480	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.LAND_AND_PROPERTY_IDENTIFIER.PKLPI')
2481END
2482GO
2483IF @@TRANCOUNT=0 BEGIN TRANSACTION
2484GO
2485SET ANSI_NULLS ON
2486GO
2487SET QUOTED_IDENTIFIER ON
2488GO
2489ALTER TABLE [dbo].[ORGANISATION] ADD 
2490	CONSTRAINT [PK_ORGANISATION] PRIMARY KEY CLUSTERED 
2491	(
2492		[UNIQUE_ORG]
2493	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2494GO
2495
2496IF @@ERROR<>0 
2497Begin
2498	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2499	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ORGANISATION.PK_ORGANISATION')
2500END
2501GO
2502IF @@TRANCOUNT=0 BEGIN TRANSACTION
2503GO
2504SET ANSI_NULLS ON
2505GO
2506SET QUOTED_IDENTIFIER ON
2507GO
2508ALTER TABLE [dbo].[LPI_HISTORY] ADD 
2509	CONSTRAINT [PKLPI_HISTORY] PRIMARY KEY CLUSTERED 
2510	(
2511		[LPI_UNIQUE],[VERSION_NO]
2512	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2513GO
2514
2515IF @@ERROR<>0 
2516Begin
2517	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2518	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.LPI_HISTORY.PKLPI_HISTORY')
2519END
2520GO
2521IF @@TRANCOUNT=0 BEGIN TRANSACTION
2522GO
2523SET ANSI_NULLS ON
2524GO
2525SET QUOTED_IDENTIFIER ON
2526GO
2527ALTER TABLE [dbo].[LPI_POSTALADR] ADD 
2528	CONSTRAINT [pkLPIPostalAdr] PRIMARY KEY CLUSTERED 
2529	(
2530		[LPI_UNIQUE]
2531	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2532GO
2533
2534IF @@ERROR<>0 
2535Begin
2536	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2537	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.LPI_POSTALADR.pkLPIPostalAdr')
2538END
2539GO
2540IF @@TRANCOUNT=0 BEGIN TRANSACTION
2541GO
2542SET ANSI_NULLS ON
2543GO
2544SET QUOTED_IDENTIFIER ON
2545GO
2546ALTER TABLE [dbo].[LPI_DELETED] ADD 
2547	CONSTRAINT [PK_LPI_DELETED] PRIMARY KEY CLUSTERED 
2548	(
2549		[LPI_UNIQUE]
2550	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2551GO
2552
2553IF @@ERROR<>0 
2554Begin
2555	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2556	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.LPI_DELETED.PK_LPI_DELETED')
2557END
2558GO
2559IF @@TRANCOUNT=0 BEGIN TRANSACTION
2560GO
2561SET ANSI_NULLS ON
2562GO
2563SET QUOTED_IDENTIFIER ON
2564GO
2565ALTER TABLE [dbo].[LPI_CANDIDATE_ARCHIVE] ADD 
2566	CONSTRAINT [PK_LPI_CANDIDATE_ARCHIVE] PRIMARY KEY CLUSTERED 
2567	(
2568		[LPI_CANDIDATE_ID]
2569	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2570GO
2571
2572IF @@ERROR<>0 
2573Begin
2574	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2575	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.LPI_CANDIDATE_ARCHIVE.PK_LPI_CANDIDATE_ARCHIVE')
2576END
2577GO
2578IF @@TRANCOUNT=0 BEGIN TRANSACTION
2579GO
2580SET ANSI_NULLS ON
2581GO
2582SET QUOTED_IDENTIFIER ON
2583GO
2584ALTER TABLE [dbo].[METADATA] ADD 
2585	CONSTRAINT [pkMetadata] PRIMARY KEY CLUSTERED 
2586	(
2587		[CUSTODIAN_CODE]
2588	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2589GO
2590
2591IF @@ERROR<>0 
2592Begin
2593	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2594	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.METADATA.pkMetadata')
2595END
2596GO
2597IF @@TRANCOUNT=0 BEGIN TRANSACTION
2598GO
2599SET ANSI_NULLS ON
2600GO
2601SET QUOTED_IDENTIFIER ON
2602GO
2603ALTER TABLE [dbo].[ONEWAYSTREETEXEMPT] ADD 
2604	CONSTRAINT [PK_ONEWAYSTREETEXEMPT] PRIMARY KEY CLUSTERED 
2605	(
2606		[ESU_ID],[SEQUENCE_NUMBER],[AUTH_CODE]
2607	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2608GO
2609
2610IF @@ERROR<>0 
2611Begin
2612	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2613	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ONEWAYSTREETEXEMPT.PK_ONEWAYSTREETEXEMPT')
2614END
2615GO
2616IF @@TRANCOUNT=0 BEGIN TRANSACTION
2617GO
2618SET ANSI_NULLS ON
2619GO
2620SET QUOTED_IDENTIFIER ON
2621GO
2622ALTER TABLE [dbo].[LPI_CANDIDATE] ADD 
2623	CONSTRAINT [PK_LPI_CANDIDATE] PRIMARY KEY CLUSTERED 
2624	(
2625		[LPI_CANDIDATE_ID]
2626	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2627GO
2628
2629IF @@ERROR<>0 
2630Begin
2631	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2632	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.LPI_CANDIDATE.PK_LPI_CANDIDATE')
2633END
2634GO
2635IF @@TRANCOUNT=0 BEGIN TRANSACTION
2636GO
2637SET ANSI_NULLS ON
2638GO
2639SET QUOTED_IDENTIFIER ON
2640GO
2641ALTER TABLE [dbo].[NODE] ADD 
2642	CONSTRAINT [PK_NODE_CNS] PRIMARY KEY CLUSTERED 
2643	(
2644		[APGRECNO]
2645	) ON [PRIMARY];
2646GO
2647
2648IF @@ERROR<>0 
2649Begin
2650	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2651	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.NODE.PK_NODE_CNS')
2652END
2653GO
2654IF @@TRANCOUNT=0 BEGIN TRANSACTION
2655GO
2656SET ANSI_NULLS ON
2657GO
2658SET QUOTED_IDENTIFIER ON
2659GO
2660ALTER TABLE [dbo].[NODE_LOOKUP] ADD 
2661	CONSTRAINT [PKNODE_LOOKUP] PRIMARY KEY CLUSTERED 
2662	(
2663		[NODE_ID],[STREET_ESU_ID]
2664	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2665GO
2666
2667IF @@ERROR<>0 
2668Begin
2669	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2670	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.NODE_LOOKUP.PKNODE_LOOKUP')
2671END
2672GO
2673IF @@TRANCOUNT=0 BEGIN TRANSACTION
2674GO
2675SET ANSI_NULLS ON
2676GO
2677SET QUOTED_IDENTIFIER ON
2678GO
2679ALTER TABLE [dbo].[SUCCESSOR_XREF_DELETED] ADD 
2680	CONSTRAINT [PK_SUCCESSOR_XREF_DEL] PRIMARY KEY CLUSTERED 
2681	(
2682		[UNIQUE_SUCCESSOR_XREF]
2683	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2684GO
2685
2686IF @@ERROR<>0 
2687Begin
2688	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2689	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.SUCCESSOR_XREF_DELETED.PK_SUCCESSOR_XREF_DEL')
2690END
2691GO
2692IF @@TRANCOUNT=0 BEGIN TRANSACTION
2693GO
2694SET ANSI_NULLS ON
2695GO
2696SET QUOTED_IDENTIFIER ON
2697GO
2698ALTER TABLE [dbo].[TFI] ADD 
2699	CONSTRAINT [pkTFIOld] PRIMARY KEY CLUSTERED 
2700	(
2701		[TFI_UNIQUE]
2702	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2703GO
2704
2705IF @@ERROR<>0 
2706Begin
2707	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2708	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.TFI.pkTFIOld')
2709END
2710GO
2711IF @@TRANCOUNT=0 BEGIN TRANSACTION
2712GO
2713SET ANSI_NULLS ON
2714GO
2715SET QUOTED_IDENTIFIER ON
2716GO
2717ALTER TABLE [dbo].[SUCCESSOR_XREF] ADD 
2718	CONSTRAINT [PK_SUCCESSOR_XREF] PRIMARY KEY CLUSTERED 
2719	(
2720		[UNIQUE_SUCCESSOR_XREF]
2721	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2722GO
2723
2724IF @@ERROR<>0 
2725Begin
2726	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2727	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.SUCCESSOR_XREF.PK_SUCCESSOR_XREF')
2728END
2729GO
2730IF @@TRANCOUNT=0 BEGIN TRANSACTION
2731GO
2732SET ANSI_NULLS ON
2733GO
2734SET QUOTED_IDENTIFIER ON
2735GO
2736ALTER TABLE [dbo].[STREET_HISTORY] ADD 
2737	CONSTRAINT [PKSTREET_HISTORY] PRIMARY KEY CLUSTERED 
2738	(
2739		[USRN],[VERSION_NO]
2740	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2741GO
2742
2743IF @@ERROR<>0 
2744Begin
2745	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2746	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.STREET_HISTORY.PKSTREET_HISTORY')
2747END
2748GO
2749IF @@TRANCOUNT=0 BEGIN TRANSACTION
2750GO
2751SET ANSI_NULLS ON
2752GO
2753SET QUOTED_IDENTIFIER ON
2754GO
2755ALTER TABLE [dbo].[STREET_SP] ADD 
2756	CONSTRAINT [PK_STREET_SP_CNS] PRIMARY KEY CLUSTERED 
2757	(
2758		[APGRECNO]
2759	) ON [PRIMARY];
2760GO
2761
2762IF @@ERROR<>0 
2763Begin
2764	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2765	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.STREET_SP.PK_STREET_SP_CNS')
2766END
2767GO
2768IF @@TRANCOUNT=0 BEGIN TRANSACTION
2769GO
2770SET ANSI_NULLS ON
2771GO
2772SET QUOTED_IDENTIFIER ON
2773GO
2774ALTER TABLE [dbo].[USERTABLE] ADD 
2775	CONSTRAINT [PK_USERID] PRIMARY KEY CLUSTERED 
2776	(
2777		[USERID]
2778	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2779GO
2780
2781IF @@ERROR<>0 
2782Begin
2783	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2784	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.USERTABLE.PK_USERID')
2785END
2786GO
2787IF @@TRANCOUNT=0 BEGIN TRANSACTION
2788GO
2789SET ANSI_NULLS ON
2790GO
2791SET QUOTED_IDENTIFIER ON
2792GO
2793ALTER TABLE [dbo].[WARD] ADD 
2794	CONSTRAINT [PKWARD] PRIMARY KEY CLUSTERED 
2795	(
2796		[WARDCODE]
2797	) ON [PRIMARY];
2798GO
2799
2800IF @@ERROR<>0 
2801Begin
2802	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2803	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.WARD.PKWARD')
2804END
2805GO
2806IF @@TRANCOUNT=0 BEGIN TRANSACTION
2807GO
2808SET ANSI_NULLS ON
2809GO
2810SET QUOTED_IDENTIFIER ON
2811GO
2812ALTER TABLE [dbo].[TRANSFER_FILE_IMAGE_ARCHIVE] ADD 
2813	CONSTRAINT [PK_TRANSFER_FILE_ARCHIVE] PRIMARY KEY CLUSTERED 
2814	(
2815		[TFI_ARCHIVE_UNIQUE]
2816	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2817GO
2818
2819IF @@ERROR<>0 
2820Begin
2821	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2822	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.TRANSFER_FILE_IMAGE_ARCHIVE.PK_TRANSFER_FILE_ARCHIVE')
2823END
2824GO
2825IF @@TRANCOUNT=0 BEGIN TRANSACTION
2826GO
2827SET ANSI_NULLS ON
2828GO
2829SET QUOTED_IDENTIFIER ON
2830GO
2831ALTER TABLE [dbo].[TOWN] ADD 
2832	CONSTRAINT [PK_TOWN] PRIMARY KEY CLUSTERED 
2833	(
2834		[TOWN_REF]
2835	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2836GO
2837
2838IF @@ERROR<>0 
2839Begin
2840	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2841	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.TOWN.PK_TOWN')
2842END
2843GO
2844IF @@TRANCOUNT=0 BEGIN TRANSACTION
2845GO
2846SET ANSI_NULLS ON
2847GO
2848SET QUOTED_IDENTIFIER ON
2849GO
2850ALTER TABLE [dbo].[TRANSFER_FILE_IMAGE] ADD 
2851	CONSTRAINT [PK_TRANSFER_FILE] PRIMARY KEY CLUSTERED 
2852	(
2853		[TFI_UNIQUE]
2854	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2855GO
2856
2857IF @@ERROR<>0 
2858Begin
2859	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2860	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.TRANSFER_FILE_IMAGE.PK_TRANSFER_FILE')
2861END
2862GO
2863IF @@TRANCOUNT=0 BEGIN TRANSACTION
2864GO
2865SET ANSI_NULLS ON
2866GO
2867SET QUOTED_IDENTIFIER ON
2868GO
2869ALTER TABLE [dbo].[STREET_DESCRIPTOR] ADD 
2870	CONSTRAINT [PKSTREET_DESC] PRIMARY KEY CLUSTERED 
2871	(
2872		[USRN],[LANGUAGE_CODE]
2873	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2874GO
2875
2876IF @@ERROR<>0 
2877Begin
2878	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2879	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.STREET_DESCRIPTOR.PKSTREET_DESC')
2880END
2881GO
2882IF @@TRANCOUNT=0 BEGIN TRANSACTION
2883GO
2884SET ANSI_NULLS ON
2885GO
2886SET QUOTED_IDENTIFIER ON
2887GO
2888ALTER TABLE [dbo].[REINSTDS] ADD 
2889	CONSTRAINT [PK_REINSTDS_CNS] PRIMARY KEY CLUSTERED 
2890	(
2891		[APGRECNO]
2892	) ON [PRIMARY];
2893GO
2894
2895IF @@ERROR<>0 
2896Begin
2897	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2898	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.REINSTDS.PK_REINSTDS_CNS')
2899END
2900GO
2901IF @@TRANCOUNT=0 BEGIN TRANSACTION
2902GO
2903SET ANSI_NULLS ON
2904GO
2905SET QUOTED_IDENTIFIER ON
2906GO
2907ALTER TABLE [dbo].[SPCLDSG] ADD 
2908	CONSTRAINT [PK_SPCLDSG_CNS] PRIMARY KEY CLUSTERED 
2909	(
2910		[APGRECNO]
2911	) ON [PRIMARY];
2912GO
2913
2914IF @@ERROR<>0 
2915Begin
2916	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2917	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.SPCLDSG.PK_SPCLDSG_CNS')
2918END
2919GO
2920IF @@TRANCOUNT=0 BEGIN TRANSACTION
2921GO
2922SET ANSI_NULLS ON
2923GO
2924SET QUOTED_IDENTIFIER ON
2925GO
2926ALTER TABLE [dbo].[REINST_DESIGNATION] ADD 
2927	CONSTRAINT [PK_REINST_DESIGNATION] PRIMARY KEY CLUSTERED 
2928	(
2929		[USRN],[STREET_REINST_TYPE_SEQ_NUM],[AUTH_CODE]
2930	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2931GO
2932
2933IF @@ERROR<>0 
2934Begin
2935	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2936	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.REINST_DESIGNATION.PK_REINST_DESIGNATION')
2937END
2938GO
2939IF @@TRANCOUNT=0 BEGIN TRANSACTION
2940GO
2941SET ANSI_NULLS ON
2942GO
2943SET QUOTED_IDENTIFIER ON
2944GO
2945ALTER TABLE [dbo].[PUBLIC_RIGHT_OF_WAY] ADD 
2946	CONSTRAINT [PKPROW] PRIMARY KEY CLUSTERED 
2947	(
2948		[PROW_ID]
2949	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2950GO
2951
2952IF @@ERROR<>0 
2953Begin
2954	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2955	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.PUBLIC_RIGHT_OF_WAY.PKPROW')
2956END
2957GO
2958IF @@TRANCOUNT=0 BEGIN TRANSACTION
2959GO
2960SET ANSI_NULLS ON
2961GO
2962SET QUOTED_IDENTIFIER ON
2963GO
2964ALTER TABLE [dbo].[REINST_DESIG_HISTORY] ADD 
2965	CONSTRAINT [PK_REINST_DESIG_HISTORY] PRIMARY KEY CLUSTERED 
2966	(
2967		[USRN],[STREET_REINST_TYPE_SEQ_NUM],[STREET_REINST_TYPE_CODE],[REINST_VERSION_NO],[AUTH_CODE]
2968	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2969GO
2970
2971IF @@ERROR<>0 
2972Begin
2973	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2974	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.REINST_DESIG_HISTORY.PK_REINST_DESIG_HISTORY')
2975END
2976GO
2977IF @@TRANCOUNT=0 BEGIN TRANSACTION
2978GO
2979SET ANSI_NULLS ON
2980GO
2981SET QUOTED_IDENTIFIER ON
2982GO
2983ALTER TABLE [dbo].[STREET_CROSS_REFERENCE] ADD 
2984	CONSTRAINT [PKSTREET_XREF] PRIMARY KEY CLUSTERED 
2985	(
2986		[USRN],[XUSRN]
2987	) WITH (FILLFACTOR = 90) ON [PRIMARY];
2988GO
2989
2990IF @@ERROR<>0 
2991Begin
2992	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
2993	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.STREET_CROSS_REFERENCE.PKSTREET_XREF')
2994END
2995GO
2996IF @@TRANCOUNT=0 BEGIN TRANSACTION
2997GO
2998SET ANSI_NULLS ON
2999GO
3000SET QUOTED_IDENTIFIER ON
3001GO
3002ALTER TABLE [dbo].[STREET_DESC_HISTORY] ADD 
3003	CONSTRAINT [PKSTREETDESC_HISTORY] PRIMARY KEY CLUSTERED 
3004	(
3005		[USRN],[LANGUAGE_CODE],[VERSION_NUMBER]
3006	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3007GO
3008
3009IF @@ERROR<>0 
3010Begin
3011	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3012	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.STREET_DESC_HISTORY.PKSTREETDESC_HISTORY')
3013END
3014GO
3015IF @@TRANCOUNT=0 BEGIN TRANSACTION
3016GO
3017SET ANSI_NULLS ON
3018GO
3019SET QUOTED_IDENTIFIER ON
3020GO
3021ALTER TABLE [dbo].[STREET] ADD 
3022	CONSTRAINT [PKSTREET] PRIMARY KEY CLUSTERED 
3023	(
3024		[USRN]
3025	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3026GO
3027
3028IF @@ERROR<>0 
3029Begin
3030	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3031	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.STREET.PKSTREET')
3032END
3033GO
3034IF @@TRANCOUNT=0 BEGIN TRANSACTION
3035GO
3036SET ANSI_NULLS ON
3037GO
3038SET QUOTED_IDENTIFIER ON
3039GO
3040ALTER TABLE [dbo].[SPECIAL_DESIG_HISTORY] ADD 
3041	CONSTRAINT [PK_SPCLDESG_HISTORY] PRIMARY KEY CLUSTERED 
3042	(
3043		[USRN],[STREET_SPECIAL_DESIG_NUM],[STREET_SPECIAL_DESIG_CODE],[SPCL_VERSION_NO]
3044	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3045GO
3046
3047IF @@ERROR<>0 
3048Begin
3049	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3050	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.SPECIAL_DESIG_HISTORY.PK_SPCLDESG_HISTORY')
3051END
3052GO
3053IF @@TRANCOUNT=0 BEGIN TRANSACTION
3054GO
3055SET ANSI_NULLS ON
3056GO
3057SET QUOTED_IDENTIFIER ON
3058GO
3059ALTER TABLE [dbo].[SPECIAL_DESIGNATION] ADD 
3060	CONSTRAINT [PK_SPECIAL_DESIGNATION] PRIMARY KEY CLUSTERED 
3061	(
3062		[USRN],[STREET_SPECIAL_DESIG_NUM],[AUTH_CODE]
3063	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3064GO
3065
3066IF @@ERROR<>0 
3067Begin
3068	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3069	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.SPECIAL_DESIGNATION.PK_SPECIAL_DESIGNATION')
3070END
3071GO
3072IF @@TRANCOUNT=0 BEGIN TRANSACTION
3073GO
3074SET ANSI_NULLS ON
3075GO
3076SET QUOTED_IDENTIFIER ON
3077GO
3078ALTER TABLE [dbo].[ImpExpErrorCodes] ADD 
3079	CONSTRAINT [PK_IMPEXP_ERRORCODE] PRIMARY KEY CLUSTERED 
3080	(
3081		[ERRORCODE]
3082	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3083GO
3084
3085IF @@ERROR<>0 
3086Begin
3087	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3088	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ImpExpErrorCodes.PK_IMPEXP_ERRORCODE')
3089END
3090GO
3091IF @@TRANCOUNT=0 BEGIN TRANSACTION
3092GO
3093SET ANSI_NULLS ON
3094GO
3095SET QUOTED_IDENTIFIER ON
3096GO
3097ALTER TABLE [dbo].[BLPU_CANDIDATE_ARCHIVE] ADD 
3098	CONSTRAINT [PK_BLPU_CANDIDATE_ARCHIVE] PRIMARY KEY CLUSTERED 
3099	(
3100		[BLPU_CANDIDATE_ID]
3101	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3102GO
3103
3104IF @@ERROR<>0 
3105Begin
3106	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3107	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_CANDIDATE_ARCHIVE.PK_BLPU_CANDIDATE_ARCHIVE')
3108END
3109GO
3110IF @@TRANCOUNT=0 BEGIN TRANSACTION
3111GO
3112SET ANSI_NULLS ON
3113GO
3114SET QUOTED_IDENTIFIER ON
3115GO
3116ALTER TABLE [dbo].[BLPU_CLASS] ADD 
3117	CONSTRAINT [pkBLPU_Class] PRIMARY KEY CLUSTERED 
3118	(
3119		[BLPU_ID]
3120	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3121GO
3122
3123IF @@ERROR<>0 
3124Begin
3125	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3126	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_CLASS.pkBLPU_Class')
3127END
3128GO
3129IF @@TRANCOUNT=0 BEGIN TRANSACTION
3130GO
3131SET ANSI_NULLS ON
3132GO
3133SET QUOTED_IDENTIFIER ON
3134GO
3135ALTER TABLE [dbo].[BLPU_CANDIDATE] ADD 
3136	CONSTRAINT [PK_BLPU_CANDIDATE] PRIMARY KEY CLUSTERED 
3137	(
3138		[BLPU_CANDIDATE_ID]
3139	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3140GO
3141
3142IF @@ERROR<>0 
3143Begin
3144	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3145	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_CANDIDATE.PK_BLPU_CANDIDATE')
3146END
3147GO
3148IF @@TRANCOUNT=0 BEGIN TRANSACTION
3149GO
3150SET ANSI_NULLS ON
3151GO
3152SET QUOTED_IDENTIFIER ON
3153GO
3154ALTER TABLE [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ADD 
3155	CONSTRAINT [PK_BLPU] PRIMARY KEY CLUSTERED 
3156	(
3157		[UPRN]
3158	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3159GO
3160
3161IF @@ERROR<>0 
3162Begin
3163	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3164	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BASIC_LAND_AND_PROPERTY_UNIT.PK_BLPU')
3165END
3166GO
3167IF @@TRANCOUNT=0 BEGIN TRANSACTION
3168GO
3169SET ANSI_NULLS ON
3170GO
3171SET QUOTED_IDENTIFIER ON
3172GO
3173ALTER TABLE [dbo].[BLPU] ADD 
3174	CONSTRAINT [PK_BLPU_CNS] PRIMARY KEY CLUSTERED 
3175	(
3176		[APGRECNO]
3177	) ON [PRIMARY];
3178GO
3179
3180IF @@ERROR<>0 
3181Begin
3182	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3183	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU.PK_BLPU_CNS')
3184END
3185GO
3186IF @@TRANCOUNT=0 BEGIN TRANSACTION
3187GO
3188SET ANSI_NULLS ON
3189GO
3190SET QUOTED_IDENTIFIER ON
3191GO
3192ALTER TABLE [dbo].[BLPU_CLASSIFICATION] ADD 
3193	CONSTRAINT [PK_BLPU_CLASSIFICATION] PRIMARY KEY CLUSTERED 
3194	(
3195		[UNIQUE_BLPUCLASS]
3196	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3197GO
3198
3199IF @@ERROR<>0 
3200Begin
3201	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3202	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_CLASSIFICATION.PK_BLPU_CLASSIFICATION')
3203END
3204GO
3205IF @@TRANCOUNT=0 BEGIN TRANSACTION
3206GO
3207SET ANSI_NULLS ON
3208GO
3209SET QUOTED_IDENTIFIER ON
3210GO
3211ALTER TABLE [dbo].[BLPU_EXTENT] ADD 
3212	CONSTRAINT [PK_BLPU_EXTENT] PRIMARY KEY CLUSTERED 
3213	(
3214		[UPRN],[PROV_CODE]
3215	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3216GO
3217
3218IF @@ERROR<>0 
3219Begin
3220	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3221	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_EXTENT.PK_BLPU_EXTENT')
3222END
3223GO
3224IF @@TRANCOUNT=0 BEGIN TRANSACTION
3225GO
3226SET ANSI_NULLS ON
3227GO
3228SET QUOTED_IDENTIFIER ON
3229GO
3230ALTER TABLE [dbo].[BLPU_EXTENT_POLYGON] ADD 
3231	CONSTRAINT [PKBLPU_EXTENT_POLYGON] PRIMARY KEY CLUSTERED 
3232	(
3233		[PROVENANCE_CODE],[UPRN],[POLYGON_NUMBER]
3234	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3235GO
3236
3237IF @@ERROR<>0 
3238Begin
3239	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3240	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_EXTENT_POLYGON.PKBLPU_EXTENT_POLYGON')
3241END
3242GO
3243IF @@TRANCOUNT=0 BEGIN TRANSACTION
3244GO
3245SET ANSI_NULLS ON
3246GO
3247SET QUOTED_IDENTIFIER ON
3248GO
3249ALTER TABLE [dbo].[BLPU_DELETED] ADD 
3250	CONSTRAINT [PK_BLPU_DELETED] PRIMARY KEY CLUSTERED 
3251	(
3252		[UPRN]
3253	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3254GO
3255
3256IF @@ERROR<>0 
3257Begin
3258	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3259	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_DELETED.PK_BLPU_DELETED')
3260END
3261GO
3262IF @@TRANCOUNT=0 BEGIN TRANSACTION
3263GO
3264SET ANSI_NULLS ON
3265GO
3266SET QUOTED_IDENTIFIER ON
3267GO
3268ALTER TABLE [dbo].[BLPU_CLASSIFICATION_DELETED] ADD 
3269	CONSTRAINT [PK_BLPU_CLASS_DELETED] PRIMARY KEY CLUSTERED 
3270	(
3271		[UNIQUE_BLPUCLASS]
3272	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3273GO
3274
3275IF @@ERROR<>0 
3276Begin
3277	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3278	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_CLASSIFICATION_DELETED.PK_BLPU_CLASS_DELETED')
3279END
3280GO
3281IF @@TRANCOUNT=0 BEGIN TRANSACTION
3282GO
3283SET ANSI_NULLS ON
3284GO
3285SET QUOTED_IDENTIFIER ON
3286GO
3287ALTER TABLE [dbo].[BLPU_CROSS_REFERENCE] ADD 
3288	CONSTRAINT [PKBLPU_XREF] PRIMARY KEY CLUSTERED 
3289	(
3290		[UPRN],[XUPRN]
3291	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3292GO
3293
3294IF @@ERROR<>0 
3295Begin
3296	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3297	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_CROSS_REFERENCE.PKBLPU_XREF')
3298END
3299GO
3300IF @@TRANCOUNT=0 BEGIN TRANSACTION
3301GO
3302SET ANSI_NULLS ON
3303GO
3304SET QUOTED_IDENTIFIER ON
3305GO
3306ALTER TABLE [dbo].[ALIASINFO] ADD 
3307	CONSTRAINT [PK_ALIASINFO] PRIMARY KEY CLUSTERED 
3308	(
3309		[ALIAS_ID]
3310	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3311GO
3312
3313IF @@ERROR<>0 
3314Begin
3315	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3316	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ALIASINFO.PK_ALIASINFO')
3317END
3318GO
3319IF @@TRANCOUNT=0 BEGIN TRANSACTION
3320GO
3321SET ANSI_NULLS ON
3322GO
3323SET QUOTED_IDENTIFIER ON
3324GO
3325ALTER TABLE [dbo].[ALT_STREET_LPI] ADD 
3326	CONSTRAINT [pkAltLPI] PRIMARY KEY CLUSTERED 
3327	(
3328		[ALT_LPI]
3329	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3330GO
3331
3332IF @@ERROR<>0 
3333Begin
3334	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3335	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ALT_STREET_LPI.pkAltLPI')
3336END
3337GO
3338IF @@TRANCOUNT=0 BEGIN TRANSACTION
3339GO
3340SET ANSI_NULLS ON
3341GO
3342SET QUOTED_IDENTIFIER ON
3343GO
3344ALTER TABLE [dbo].[ADTNLSTR] ADD 
3345	CONSTRAINT [PK_ADTNLSTR_CNS] PRIMARY KEY CLUSTERED 
3346	(
3347		[APGRECNO]
3348	) ON [PRIMARY];
3349GO
3350
3351IF @@ERROR<>0 
3352Begin
3353	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3354	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ADTNLSTR.PK_ADTNLSTR_CNS')
3355END
3356GO
3357IF @@TRANCOUNT=0 BEGIN TRANSACTION
3358GO
3359SET ANSI_NULLS ON
3360GO
3361SET QUOTED_IDENTIFIER ON
3362GO
3363ALTER TABLE [dbo].[ADDITIONAL_STREET] ADD 
3364	CONSTRAINT [PK_ADDITIONAL_STREET] PRIMARY KEY CLUSTERED 
3365	(
3366		[USRN],[ADDITIONAL_STREET_SEQ_NUMBER],[AUTH_CODE]
3367	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3368GO
3369
3370IF @@ERROR<>0 
3371Begin
3372	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3373	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ADDITIONAL_STREET.PK_ADDITIONAL_STREET')
3374END
3375GO
3376IF @@TRANCOUNT=0 BEGIN TRANSACTION
3377GO
3378SET ANSI_NULLS ON
3379GO
3380SET QUOTED_IDENTIFIER ON
3381GO
3382ALTER TABLE [dbo].[ADMIN_AREA_NAME] ADD 
3383	CONSTRAINT [PKADMIN_AREANAME] PRIMARY KEY CLUSTERED 
3384	(
3385		[AAN_REF]
3386	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3387GO
3388
3389IF @@ERROR<>0 
3390Begin
3391	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3392	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ADMIN_AREA_NAME.PKADMIN_AREANAME')
3393END
3394GO
3395IF @@TRANCOUNT=0 BEGIN TRANSACTION
3396GO
3397SET ANSI_NULLS ON
3398GO
3399SET QUOTED_IDENTIFIER ON
3400GO
3401ALTER TABLE [dbo].[APPLICATION_CROSS_REFERENCE] ADD 
3402	CONSTRAINT [PKAPP_CROSSREF_NEW] PRIMARY KEY CLUSTERED 
3403	(
3404		[CROSS_REF],[SOURCE],[UPRN]
3405	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3406GO
3407
3408IF @@ERROR<>0 
3409Begin
3410	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3411	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.APPLICATION_CROSS_REFERENCE.PKAPP_CROSSREF_NEW')
3412END
3413GO
3414IF @@TRANCOUNT=0 BEGIN TRANSACTION
3415GO
3416SET ANSI_NULLS ON
3417GO
3418SET QUOTED_IDENTIFIER ON
3419GO
3420ALTER TABLE [dbo].[ASD_ODD] ADD 
3421	CONSTRAINT [PKASDODD] PRIMARY KEY CLUSTERED 
3422	(
3423		[ORG_ID],[DISTRICT_ID]
3424	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3425GO
3426
3427IF @@ERROR<>0 
3428Begin
3429	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3430	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ASD_ODD.PKASDODD')
3431END
3432GO
3433IF @@TRANCOUNT=0 BEGIN TRANSACTION
3434GO
3435SET ANSI_NULLS ON
3436GO
3437SET QUOTED_IDENTIFIER ON
3438GO
3439ALTER TABLE [dbo].[AUTHORITY] ADD 
3440	CONSTRAINT [PK_AUTHORITY] PRIMARY KEY CLUSTERED 
3441	(
3442		[AUTH_CODE]
3443	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3444GO
3445
3446IF @@ERROR<>0 
3447Begin
3448	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3449	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.AUTHORITY.PK_AUTHORITY')
3450END
3451GO
3452IF @@TRANCOUNT=0 BEGIN TRANSACTION
3453GO
3454SET ANSI_NULLS ON
3455GO
3456SET QUOTED_IDENTIFIER ON
3457GO
3458ALTER TABLE [dbo].[ASD_LOOKUP] ADD 
3459	CONSTRAINT [PKASDLOOKUP] PRIMARY KEY CLUSTERED 
3460	(
3461		[LOOKUPID],[LOOKUPTYPE]
3462	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3463GO
3464
3465IF @@ERROR<>0 
3466Begin
3467	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3468	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ASD_LOOKUP.PKASDLOOKUP')
3469END
3470GO
3471IF @@TRANCOUNT=0 BEGIN TRANSACTION
3472GO
3473SET ANSI_NULLS ON
3474GO
3475SET QUOTED_IDENTIFIER ON
3476GO
3477ALTER TABLE [dbo].[APPLICATION_SOURCE] ADD 
3478	CONSTRAINT [PKAPP_SOURCE_NEW] PRIMARY KEY CLUSTERED 
3479	(
3480		[SOURCE]
3481	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3482GO
3483
3484IF @@ERROR<>0 
3485Begin
3486	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3487	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.APPLICATION_SOURCE.PKAPP_SOURCE_NEW')
3488END
3489GO
3490IF @@TRANCOUNT=0 BEGIN TRANSACTION
3491GO
3492SET ANSI_NULLS ON
3493GO
3494SET QUOTED_IDENTIFIER ON
3495GO
3496ALTER TABLE [dbo].[ASD_HISTORY] ADD 
3497	CONSTRAINT [PK_ASD_HISTORY] PRIMARY KEY CLUSTERED 
3498	(
3499		[USRN],[ADDITIONAL_STREET_SEQ_NUMBER],[ASD_VERSION_NO],[AUTH_CODE]
3500	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3501GO
3502
3503IF @@ERROR<>0 
3504Begin
3505	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3506	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ASD_HISTORY.PK_ASD_HISTORY')
3507END
3508GO
3509IF @@TRANCOUNT=0 BEGIN TRANSACTION
3510GO
3511SET ANSI_NULLS ON
3512GO
3513SET QUOTED_IDENTIFIER ON
3514GO
3515ALTER TABLE [dbo].[BLPU_EXTENT_POLYGON_VERTEX] ADD 
3516	CONSTRAINT [PKBLPU_EXT_POLY_VERTEX] PRIMARY KEY CLUSTERED 
3517	(
3518		[PROVENANCE_CODE],[UPRN],[POLYGON_NUMBER],[VERTEX_ORDER]
3519	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3520GO
3521
3522IF @@ERROR<>0 
3523Begin
3524	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3525	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_EXTENT_POLYGON_VERTEX.PKBLPU_EXT_POLY_VERTEX')
3526END
3527GO
3528IF @@TRANCOUNT=0 BEGIN TRANSACTION
3529GO
3530SET ANSI_NULLS ON
3531GO
3532SET QUOTED_IDENTIFIER ON
3533GO
3534ALTER TABLE [dbo].[EXPORTDATES_TFIOLD] ADD 
3535	CONSTRAINT [pkEXPORTID_OldTFI] PRIMARY KEY CLUSTERED 
3536	(
3537		[EXPORT_ID]
3538	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3539GO
3540
3541IF @@ERROR<>0 
3542Begin
3543	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3544	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.EXPORTDATES_TFIOLD.pkEXPORTID_OldTFI')
3545END
3546GO
3547IF @@TRANCOUNT=0 BEGIN TRANSACTION
3548GO
3549SET ANSI_NULLS ON
3550GO
3551SET QUOTED_IDENTIFIER ON
3552GO
3553ALTER TABLE [dbo].[EXPORT_DATES] ADD 
3554	CONSTRAINT [PKEXPORT_DATES] PRIMARY KEY CLUSTERED 
3555	(
3556		[EXPORT_ID]
3557	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3558GO
3559
3560IF @@ERROR<>0 
3561Begin
3562	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3563	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.EXPORT_DATES.PKEXPORT_DATES')
3564END
3565GO
3566IF @@TRANCOUNT=0 BEGIN TRANSACTION
3567GO
3568SET ANSI_NULLS ON
3569GO
3570SET QUOTED_IDENTIFIER ON
3571GO
3572ALTER TABLE [dbo].[HEIGHTWIDTHWEIGHT] ADD 
3573	CONSTRAINT [PK_HEIGHTWIDTHWEIGHT] PRIMARY KEY CLUSTERED 
3574	(
3575		[USRN],[HWW_SEQUENCE_NO],[AUTH_CODE]
3576	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3577GO
3578
3579IF @@ERROR<>0 
3580Begin
3581	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3582	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.HEIGHTWIDTHWEIGHT.PK_HEIGHTWIDTHWEIGHT')
3583END
3584GO
3585IF @@TRANCOUNT=0 BEGIN TRANSACTION
3586GO
3587SET ANSI_NULLS ON
3588GO
3589SET QUOTED_IDENTIFIER ON
3590GO
3591ALTER TABLE [dbo].[GGP_LINK] ADD 
3592	CONSTRAINT [PKGGP_LINK] PRIMARY KEY CLUSTERED 
3593	(
3594		[STREET_BLPU_KEY]
3595	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3596GO
3597
3598IF @@ERROR<>0 
3599Begin
3600	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3601	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.GGP_LINK.PKGGP_LINK')
3602END
3603GO
3604IF @@TRANCOUNT=0 BEGIN TRANSACTION
3605GO
3606SET ANSI_NULLS ON
3607GO
3608SET QUOTED_IDENTIFIER ON
3609GO
3610ALTER TABLE [dbo].[ESU_CROSS_REFERENCE] ADD 
3611	CONSTRAINT [PKESUXREF] PRIMARY KEY CLUSTERED 
3612	(
3613		[ESU_ID],[USRN],[XREF_VERSION_NUMBER],[USRN_VERSION_NUMBER]
3614	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3615GO
3616
3617IF @@ERROR<>0 
3618Begin
3619	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3620	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ESU_CROSS_REFERENCE.PKESUXREF')
3621END
3622GO
3623IF @@TRANCOUNT=0 BEGIN TRANSACTION
3624GO
3625SET ANSI_NULLS ON
3626GO
3627SET QUOTED_IDENTIFIER ON
3628GO
3629ALTER TABLE [dbo].[ESU_COORD_HISTORY] ADD 
3630	CONSTRAINT [PKESUCOORDHISTORY] PRIMARY KEY CLUSTERED 
3631	(
3632		[ESU_ID],[VERSION_NO],[NUM_COORD]
3633	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3634GO
3635
3636IF @@ERROR<>0 
3637Begin
3638	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3639	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ESU_COORD_HISTORY.PKESUCOORDHISTORY')
3640END
3641GO
3642IF @@TRANCOUNT=0 BEGIN TRANSACTION
3643GO
3644SET ANSI_NULLS ON
3645GO
3646SET QUOTED_IDENTIFIER ON
3647GO
3648ALTER TABLE [dbo].[ESU_XREF_HISTORY] ADD 
3649	CONSTRAINT [PKESUXREFHISTORY] PRIMARY KEY CLUSTERED 
3650	(
3651		[ESU_ID],[USRN],[XREF_VERSION_NUMBER],[USRN_VERSION_NUMBER]
3652	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3653GO
3654
3655IF @@ERROR<>0 
3656Begin
3657	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3658	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ESU_XREF_HISTORY.PKESUXREFHISTORY')
3659END
3660GO
3661IF @@TRANCOUNT=0 BEGIN TRANSACTION
3662GO
3663SET ANSI_NULLS ON
3664GO
3665SET QUOTED_IDENTIFIER ON
3666GO
3667ALTER TABLE [dbo].[ESU_HISTORY] ADD 
3668	CONSTRAINT [PKESUHISTORY] PRIMARY KEY CLUSTERED 
3669	(
3670		[ESU_ID],[VERSION_NO]
3671	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3672GO
3673
3674IF @@ERROR<>0 
3675Begin
3676	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3677	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ESU_HISTORY.PKESUHISTORY')
3678END
3679GO
3680IF @@TRANCOUNT=0 BEGIN TRANSACTION
3681GO
3682SET ANSI_NULLS ON
3683GO
3684SET QUOTED_IDENTIFIER ON
3685GO
3686ALTER TABLE [dbo].[HWW_HISTORY] ADD 
3687	CONSTRAINT [PK_HWW_HISTORY] PRIMARY KEY CLUSTERED 
3688	(
3689		[USRN],[HWW_SEQUENCE_NO],[AUTH_CODE],[VERSION_NUMBER]
3690	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3691GO
3692
3693IF @@ERROR<>0 
3694Begin
3695	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3696	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.HWW_HISTORY.PK_HWW_HISTORY')
3697END
3698GO
3699IF @@TRANCOUNT=0 BEGIN TRANSACTION
3700GO
3701SET ANSI_NULLS ON
3702GO
3703SET QUOTED_IDENTIFIER ON
3704GO
3705ALTER TABLE [dbo].[Candidate_TFI_ARCHIVE] ADD 
3706	CONSTRAINT [PK_CANDIDATE_TFI_ARCHIVE] PRIMARY KEY CLUSTERED 
3707	(
3708		[TFI_ARCHIVE_Unique]
3709	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3710GO
3711
3712IF @@ERROR<>0 
3713Begin
3714	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3715	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.Candidate_TFI_ARCHIVE.PK_CANDIDATE_TFI_ARCHIVE')
3716END
3717GO
3718IF @@TRANCOUNT=0 BEGIN TRANSACTION
3719GO
3720SET ANSI_NULLS ON
3721GO
3722SET QUOTED_IDENTIFIER ON
3723GO
3724ALTER TABLE [dbo].[BLPU_HISTORY] ADD 
3725	CONSTRAINT [PK_BLPU_HISTORY] PRIMARY KEY CLUSTERED 
3726	(
3727		[UPRN],[VERSION_NO]
3728	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3729GO
3730
3731IF @@ERROR<>0 
3732Begin
3733	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3734	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.BLPU_HISTORY.PK_BLPU_HISTORY')
3735END
3736GO
3737IF @@TRANCOUNT=0 BEGIN TRANSACTION
3738GO
3739SET ANSI_NULLS ON
3740GO
3741SET QUOTED_IDENTIFIER ON
3742GO
3743ALTER TABLE [dbo].[Candidate_TFI] ADD 
3744	CONSTRAINT [PK_CANDIDATE_TFI] PRIMARY KEY CLUSTERED 
3745	(
3746		[TFI_Unique]
3747	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3748GO
3749
3750IF @@ERROR<>0 
3751Begin
3752	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3753	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.Candidate_TFI.PK_CANDIDATE_TFI')
3754END
3755GO
3756IF @@TRANCOUNT=0 BEGIN TRANSACTION
3757GO
3758SET ANSI_NULLS ON
3759GO
3760SET QUOTED_IDENTIFIER ON
3761GO
3762ALTER TABLE [dbo].[HWW] ADD 
3763	CONSTRAINT [PK_HWW_CNS] PRIMARY KEY CLUSTERED 
3764	(
3765		[APGRECNO]
3766	) ON [PRIMARY];
3767GO
3768
3769IF @@ERROR<>0 
3770Begin
3771	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3772	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.HWW.PK_HWW_CNS')
3773END
3774GO
3775IF @@TRANCOUNT=0 BEGIN TRANSACTION
3776GO
3777SET ANSI_NULLS ON
3778GO
3779SET QUOTED_IDENTIFIER ON
3780GO
3781ALTER TABLE [dbo].[ESU] ADD 
3782	CONSTRAINT [PK_ESU_CNS] PRIMARY KEY CLUSTERED 
3783	(
3784		[APGRECNO]
3785	) ON [PRIMARY];
3786GO
3787
3788IF @@ERROR<>0 
3789Begin
3790	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3791	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ESU.PK_ESU_CNS')
3792END
3793GO
3794IF @@TRANCOUNT=0 BEGIN TRANSACTION
3795GO
3796SET ANSI_NULLS ON
3797GO
3798SET QUOTED_IDENTIFIER ON
3799GO
3800ALTER TABLE [dbo].[ELEMENTARY_STREET_UNIT] ADD 
3801	CONSTRAINT [PK_ESU] PRIMARY KEY CLUSTERED 
3802	(
3803		[ESU_ID]
3804	) WITH (FILLFACTOR = 90) ON [PRIMARY];
3805GO
3806
3807IF @@ERROR<>0 
3808Begin
3809	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3810	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add primary key dbo.ELEMENTARY_STREET_UNIT.PK_ESU')
3811END
3812GO
3813IF @@TRANCOUNT=0 BEGIN TRANSACTION
3814GO
3815CREATE INDEX [IDX_LPI_LANGUAGE_CODE] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([LANGUAGE_CODE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3816GO
3817IF @@ERROR<>0 
3818Begin
3819	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3820	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IDX_LPI_LANGUAGE_CODE')
3821END
3822GO
3823
3824IF @@TRANCOUNT=0 BEGIN TRANSACTION
3825GO
3826CREATE INDEX [IDX_LPI_LASTUPDATE] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([LAST_UPDATE_DATE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3827GO
3828IF @@ERROR<>0 
3829Begin
3830	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3831	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IDX_LPI_LASTUPDATE')
3832END
3833GO
3834
3835IF @@TRANCOUNT=0 BEGIN TRANSACTION
3836GO
3837CREATE INDEX [IDX_LPI_LOCALONLY_PRIORITY] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([LOCALONLY_PRIORITY]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3838GO
3839IF @@ERROR<>0 
3840Begin
3841	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3842	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IDX_LPI_LOCALONLY_PRIORITY')
3843END
3844GO
3845
3846IF @@TRANCOUNT=0 BEGIN TRANSACTION
3847GO
3848CREATE INDEX [Idx_LPI_LOGICALSTATUS] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([LOGICAL_STATUS]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3849GO
3850IF @@ERROR<>0 
3851Begin
3852	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3853	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.Idx_LPI_LOGICALSTATUS')
3854END
3855GO
3856
3857IF @@TRANCOUNT=0 BEGIN TRANSACTION
3858GO
3859CREATE INDEX [idx_LPI_PAON] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([PAO_FROM],[PAO_FROM_SUFF],[PAO_TO],[PAO_TO_SUFF],[PAO_NAME]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3860GO
3861IF @@ERROR<>0 
3862Begin
3863	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3864	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.idx_LPI_PAON')
3865END
3866GO
3867
3868IF @@TRANCOUNT=0 BEGIN TRANSACTION
3869GO
3870CREATE INDEX [IDX_LPI_POLICEBEATCODE] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([POLICEBEATCODE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3871GO
3872IF @@ERROR<>0 
3873Begin
3874	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3875	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IDX_LPI_POLICEBEATCODE')
3876END
3877GO
3878
3879IF @@TRANCOUNT=0 BEGIN TRANSACTION
3880GO
3881CREATE INDEX [IDX_LPI_POLICEFORCEAREA] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([POLICEFORCEAREA]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3882GO
3883IF @@ERROR<>0 
3884Begin
3885	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3886	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IDX_LPI_POLICEFORCEAREA')
3887END
3888GO
3889
3890IF @@TRANCOUNT=0 BEGIN TRANSACTION
3891GO
3892CREATE INDEX [Idx_LPI_POSTCODE] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([POSTCODE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3893GO
3894IF @@ERROR<>0 
3895Begin
3896	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3897	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.Idx_LPI_POSTCODE')
3898END
3899GO
3900
3901IF @@TRANCOUNT=0 BEGIN TRANSACTION
3902GO
3903CREATE INDEX [idx_LPI_SAON] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([SAO_FROM],[SAO_FROM_SUFF],[SAO_TO],[SAO_TO_SUFF],[SAO_NAME]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3904GO
3905IF @@ERROR<>0 
3906Begin
3907	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3908	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.idx_LPI_SAON')
3909END
3910GO
3911
3912IF @@TRANCOUNT=0 BEGIN TRANSACTION
3913GO
3914CREATE INDEX [IDX_LPI_UPRN] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([UPRN]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3915GO
3916IF @@ERROR<>0 
3917Begin
3918	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3919	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IDX_LPI_UPRN')
3920END
3921GO
3922
3923IF @@TRANCOUNT=0 BEGIN TRANSACTION
3924GO
3925CREATE INDEX [IDX_LPI_USRN] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([USRN]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3926GO
3927IF @@ERROR<>0 
3928Begin
3929	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3930	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IDX_LPI_USRN')
3931END
3932GO
3933
3934IF @@TRANCOUNT=0 BEGIN TRANSACTION
3935GO
3936CREATE INDEX [IndxLPILOGSTATUS] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([LOGICAL_STATUS]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3937GO
3938IF @@ERROR<>0 
3939Begin
3940	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3941	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IndxLPILOGSTATUS')
3942END
3943GO
3944
3945IF @@TRANCOUNT=0 BEGIN TRANSACTION
3946GO
3947CREATE INDEX [IndxLPIPOSTCODE] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([POSTCODE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3948GO
3949IF @@ERROR<>0 
3950Begin
3951	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3952	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IndxLPIPOSTCODE')
3953END
3954GO
3955
3956IF @@TRANCOUNT=0 BEGIN TRANSACTION
3957GO
3958CREATE INDEX [IndxLPIUPRN] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([UPRN]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3959GO
3960IF @@ERROR<>0 
3961Begin
3962	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3963	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.IndxLPIUPRN')
3964END
3965GO
3966
3967IF @@TRANCOUNT=0 BEGIN TRANSACTION
3968GO
3969CREATE INDEX [indxPAON] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([PAO_FROM],[PAO_FROM_SUFF],[PAO_TO],[PAO_TO_SUFF],[PAO_NAME]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3970GO
3971IF @@ERROR<>0 
3972Begin
3973	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3974	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.indxPAON')
3975END
3976GO
3977
3978IF @@TRANCOUNT=0 BEGIN TRANSACTION
3979GO
3980CREATE INDEX [indxSAON] ON [dbo].[LAND_AND_PROPERTY_IDENTIFIER] ([SAO_FROM],[SAO_FROM_SUFF],[SAO_TO],[SAO_TO_SUFF],[SAO_NAME]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3981GO
3982IF @@ERROR<>0 
3983Begin
3984	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3985	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LAND_AND_PROPERTY_IDENTIFIER.indxSAON')
3986END
3987GO
3988
3989IF @@TRANCOUNT=0 BEGIN TRANSACTION
3990GO
3991CREATE INDEX [IDX_LPI_DELETED_LOGSTATUS] ON [dbo].[LPI_DELETED] ([LOGICAL_STATUS]) WITH (FILLFACTOR = 90) ON [PRIMARY];
3992GO
3993IF @@ERROR<>0 
3994Begin
3995	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
3996	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LPI_DELETED.IDX_LPI_DELETED_LOGSTATUS')
3997END
3998GO
3999
4000IF @@TRANCOUNT=0 BEGIN TRANSACTION
4001GO
4002CREATE INDEX [IDX_LPI_DELETED_POSTCODE] ON [dbo].[LPI_DELETED] ([POSTCODE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4003GO
4004IF @@ERROR<>0 
4005Begin
4006	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4007	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LPI_DELETED.IDX_LPI_DELETED_POSTCODE')
4008END
4009GO
4010
4011IF @@TRANCOUNT=0 BEGIN TRANSACTION
4012GO
4013CREATE INDEX [IDX_LPI_DELETED_UPRN] ON [dbo].[LPI_DELETED] ([UPRN]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4014GO
4015IF @@ERROR<>0 
4016Begin
4017	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4018	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LPI_DELETED.IDX_LPI_DELETED_UPRN')
4019END
4020GO
4021
4022IF @@TRANCOUNT=0 BEGIN TRANSACTION
4023GO
4024CREATE INDEX [IDX_LPI_DELETED_USRN] ON [dbo].[LPI_DELETED] ([USRN]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4025GO
4026IF @@ERROR<>0 
4027Begin
4028	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4029	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.LPI_DELETED.IDX_LPI_DELETED_USRN')
4030END
4031GO
4032
4033IF @@TRANCOUNT=0 BEGIN TRANSACTION
4034GO
4035CREATE INDEX [IDX_STREET_SP_DISPLAYFLG] ON [dbo].[STREET_SP] ([DISPLAYFLG]) ON [PRIMARY];
4036GO
4037IF @@ERROR<>0 
4038Begin
4039	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4040	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET_SP.IDX_STREET_SP_DISPLAYFLG')
4041END
4042GO
4043
4044IF @@TRANCOUNT=0 BEGIN TRANSACTION
4045GO
4046CREATE INDEX [IDX_STREET_SP_SUB_TYPE] ON [dbo].[STREET_SP] ([SUB_TYPE]) ON [PRIMARY];
4047GO
4048IF @@ERROR<>0 
4049Begin
4050	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4051	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET_SP.IDX_STREET_SP_SUB_TYPE')
4052END
4053GO
4054
4055IF @@TRANCOUNT=0 BEGIN TRANSACTION
4056GO
4057CREATE INDEX [IDX_STREET_SP_UPDDATE] ON [dbo].[STREET_SP] ([UPDDATE]) ON [PRIMARY];
4058GO
4059IF @@ERROR<>0 
4060Begin
4061	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4062	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET_SP.IDX_STREET_SP_UPDDATE')
4063END
4064GO
4065
4066IF @@TRANCOUNT=0 BEGIN TRANSACTION
4067GO
4068CREATE UNIQUE INDEX [UIDX_STREET_SP_USRN] ON [dbo].[STREET_SP] ([USRN]) ON [PRIMARY];
4069GO
4070IF @@ERROR<>0 
4071Begin
4072	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4073	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET_SP.UIDX_STREET_SP_USRN')
4074END
4075GO
4076
4077IF @@TRANCOUNT=0 BEGIN TRANSACTION
4078GO
4079CREATE INDEX [idx_STREET_HISTORY_USRN] ON [dbo].[STREET_HISTORY] ([USRN]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4080GO
4081IF @@ERROR<>0 
4082Begin
4083	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4084	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET_HISTORY.idx_STREET_HISTORY_USRN')
4085END
4086GO
4087
4088IF @@TRANCOUNT=0 BEGIN TRANSACTION
4089GO
4090CREATE INDEX [idx_STREET_HISTORY_VERSION_NO] ON [dbo].[STREET_HISTORY] ([VERSION_NO]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4091GO
4092IF @@ERROR<>0 
4093Begin
4094	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4095	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET_HISTORY.idx_STREET_HISTORY_VERSION_NO')
4096END
4097GO
4098
4099IF @@TRANCOUNT=0 BEGIN TRANSACTION
4100GO
4101CREATE INDEX [IDX_ESU_DISPLAYFLG] ON [dbo].[ESU] ([DISPLAYFLG]) ON [PRIMARY];
4102GO
4103IF @@ERROR<>0 
4104Begin
4105	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4106	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.ESU.IDX_ESU_DISPLAYFLG')
4107END
4108GO
4109
4110IF @@TRANCOUNT=0 BEGIN TRANSACTION
4111GO
4112CREATE INDEX [IDX_ESU_UPDDATE] ON [dbo].[ESU] ([UPDDATE]) ON [PRIMARY];
4113GO
4114IF @@ERROR<>0 
4115Begin
4116	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4117	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.ESU.IDX_ESU_UPDDATE')
4118END
4119GO
4120
4121IF @@TRANCOUNT=0 BEGIN TRANSACTION
4122GO
4123CREATE UNIQUE INDEX [UIDX_ESU_ESU_ID] ON [dbo].[ESU] ([ESU_ID]) ON [PRIMARY];
4124GO
4125IF @@ERROR<>0 
4126Begin
4127	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4128	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.ESU.UIDX_ESU_ESU_ID')
4129END
4130GO
4131
4132IF @@TRANCOUNT=0 BEGIN TRANSACTION
4133GO
4134CREATE INDEX [IDX_NODE_DISPLAYFLG] ON [dbo].[NODE] ([DISPLAYFLG]) ON [PRIMARY];
4135GO
4136IF @@ERROR<>0 
4137Begin
4138	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4139	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.NODE.IDX_NODE_DISPLAYFLG')
4140END
4141GO
4142
4143IF @@TRANCOUNT=0 BEGIN TRANSACTION
4144GO
4145CREATE INDEX [IDX_NODE_UPDDATE] ON [dbo].[NODE] ([UPDDATE]) ON [PRIMARY];
4146GO
4147IF @@ERROR<>0 
4148Begin
4149	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4150	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.NODE.IDX_NODE_UPDDATE')
4151END
4152GO
4153
4154IF @@TRANCOUNT=0 BEGIN TRANSACTION
4155GO
4156CREATE UNIQUE INDEX [UIDX_NODE_NODE_ID] ON [dbo].[NODE] ([NODE_ID]) ON [PRIMARY];
4157GO
4158IF @@ERROR<>0 
4159Begin
4160	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4161	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.NODE.UIDX_NODE_NODE_ID')
4162END
4163GO
4164
4165IF @@TRANCOUNT=0 BEGIN TRANSACTION
4166GO
4167CREATE INDEX [IDX_STREET_LASTUPDATE] ON [dbo].[STREET] ([LAST_UPDATE_DATE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4168GO
4169IF @@ERROR<>0 
4170Begin
4171	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4172	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET.IDX_STREET_LASTUPDATE')
4173END
4174GO
4175
4176IF @@TRANCOUNT=0 BEGIN TRANSACTION
4177GO
4178CREATE INDEX [IDX_BLPU_DELETED_CUSTCODE] ON [dbo].[BLPU_DELETED] ([CUSTODIAN_CODE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4179GO
4180IF @@ERROR<>0 
4181Begin
4182	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4183	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU_DELETED.IDX_BLPU_DELETED_CUSTCODE')
4184END
4185GO
4186
4187IF @@TRANCOUNT=0 BEGIN TRANSACTION
4188GO
4189CREATE INDEX [IDX_BLPU_DELETED_LOGSTATUS] ON [dbo].[BLPU_DELETED] ([LOGICAL_STATUS]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4190GO
4191IF @@ERROR<>0 
4192Begin
4193	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4194	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU_DELETED.IDX_BLPU_DELETED_LOGSTATUS')
4195END
4196GO
4197
4198IF @@TRANCOUNT=0 BEGIN TRANSACTION
4199GO
4200CREATE INDEX [IDX_ORGANISATION_UPRN] ON [dbo].[ORGANISATION] ([UPRN]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4201GO
4202IF @@ERROR<>0 
4203Begin
4204	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4205	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.ORGANISATION.IDX_ORGANISATION_UPRN')
4206END
4207GO
4208
4209IF @@TRANCOUNT=0 BEGIN TRANSACTION
4210GO
4211CREATE INDEX [IDX_BLPU_CLASS_BLPUCLS] ON [dbo].[BLPU_CLASS] ([BLPU_Class]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4212GO
4213IF @@ERROR<>0 
4214Begin
4215	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4216	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU_CLASS.IDX_BLPU_CLASS_BLPUCLS')
4217END
4218GO
4219
4220IF @@TRANCOUNT=0 BEGIN TRANSACTION
4221GO
4222CREATE INDEX [IDX_BLPU_CUSTODIANCODE] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([CUSTODIAN_CODE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4223GO
4224IF @@ERROR<>0 
4225Begin
4226	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4227	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.IDX_BLPU_CUSTODIANCODE')
4228END
4229GO
4230
4231IF @@TRANCOUNT=0 BEGIN TRANSACTION
4232GO
4233CREATE INDEX [IDX_BLPU_LASTUPDATE] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([LAST_UPDATE_DATE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4234GO
4235IF @@ERROR<>0 
4236Begin
4237	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4238	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.IDX_BLPU_LASTUPDATE')
4239END
4240GO
4241
4242IF @@TRANCOUNT=0 BEGIN TRANSACTION
4243GO
4244CREATE INDEX [IDX_BLPU_LOCALONLY_PRIORITY] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([LOCALONLY_PRIORITY]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4245GO
4246IF @@ERROR<>0 
4247Begin
4248	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4249	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.IDX_BLPU_LOCALONLY_PRIORITY')
4250END
4251GO
4252
4253IF @@TRANCOUNT=0 BEGIN TRANSACTION
4254GO
4255CREATE INDEX [Idx_BLPU_LOGICALSTATUS] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([LOGICAL_STATUS]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4256GO
4257IF @@ERROR<>0 
4258Begin
4259	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4260	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.Idx_BLPU_LOGICALSTATUS')
4261END
4262GO
4263
4264IF @@TRANCOUNT=0 BEGIN TRANSACTION
4265GO
4266CREATE INDEX [IDX_BLPU_org] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([ORGANISATION]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4267GO
4268IF @@ERROR<>0 
4269Begin
4270	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4271	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.IDX_BLPU_org')
4272END
4273GO
4274
4275IF @@TRANCOUNT=0 BEGIN TRANSACTION
4276GO
4277CREATE INDEX [IDX_BLPU_PARENT_UPRN] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([PARENT_UPRN]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4278GO
4279IF @@ERROR<>0 
4280Begin
4281	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4282	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.IDX_BLPU_PARENT_UPRN')
4283END
4284GO
4285
4286IF @@TRANCOUNT=0 BEGIN TRANSACTION
4287GO
4288CREATE INDEX [IDX_BLPU_PARISH] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([PARISHCODE]) ON [PRIMARY];
4289GO
4290IF @@ERROR<>0 
4291Begin
4292	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4293	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.IDX_BLPU_PARISH')
4294END
4295GO
4296
4297IF @@TRANCOUNT=0 BEGIN TRANSACTION
4298GO
4299CREATE INDEX [IDX_BLPU_WARD] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([WARDCODE]) ON [PRIMARY];
4300GO
4301IF @@ERROR<>0 
4302Begin
4303	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4304	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.IDX_BLPU_WARD')
4305END
4306GO
4307
4308IF @@TRANCOUNT=0 BEGIN TRANSACTION
4309GO
4310CREATE INDEX [IndxBLPULOGSTATUS] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([LOGICAL_STATUS]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4311GO
4312IF @@ERROR<>0 
4313Begin
4314	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4315	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.IndxBLPULOGSTATUS')
4316END
4317GO
4318
4319IF @@TRANCOUNT=0 BEGIN TRANSACTION
4320GO
4321CREATE INDEX [indxPropertyType] ON [dbo].[BASIC_LAND_AND_PROPERTY_UNIT] ([PROPERTY_TYPE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4322GO
4323IF @@ERROR<>0 
4324Begin
4325	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4326	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BASIC_LAND_AND_PROPERTY_UNIT.indxPropertyType')
4327END
4328GO
4329
4330IF @@TRANCOUNT=0 BEGIN TRANSACTION
4331GO
4332CREATE INDEX [IDX_BLPU_CAN_KEY] ON [dbo].[BLPU] ([CAN_KEY]) ON [PRIMARY];
4333GO
4334IF @@ERROR<>0 
4335Begin
4336	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4337	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.IDX_BLPU_CAN_KEY')
4338END
4339GO
4340
4341IF @@TRANCOUNT=0 BEGIN TRANSACTION
4342GO
4343CREATE INDEX [IDX_BLPU_DISPLAYFLG] ON [dbo].[BLPU] ([DISPLAYFLG]) ON [PRIMARY];
4344GO
4345IF @@ERROR<>0 
4346Begin
4347	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4348	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.IDX_BLPU_DISPLAYFLG')
4349END
4350GO
4351
4352IF @@TRANCOUNT=0 BEGIN TRANSACTION
4353GO
4354CREATE INDEX [IDX_BLPU_LOG_STATUS] ON [dbo].[BLPU] ([LOG_STATUS]) ON [PRIMARY];
4355GO
4356IF @@ERROR<>0 
4357Begin
4358	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4359	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.IDX_BLPU_LOG_STATUS')
4360END
4361GO
4362
4363IF @@TRANCOUNT=0 BEGIN TRANSACTION
4364GO
4365CREATE INDEX [IDX_BLPU_POSTCODE] ON [dbo].[BLPU] ([POSTCODE]) ON [PRIMARY];
4366GO
4367IF @@ERROR<>0 
4368Begin
4369	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4370	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.IDX_BLPU_POSTCODE')
4371END
4372GO
4373
4374IF @@TRANCOUNT=0 BEGIN TRANSACTION
4375GO
4376CREATE INDEX [IDX_BLPU_PROP_TYPE] ON [dbo].[BLPU] ([PROP_TYPE]) ON [PRIMARY];
4377GO
4378IF @@ERROR<>0 
4379Begin
4380	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4381	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.IDX_BLPU_PROP_TYPE')
4382END
4383GO
4384
4385IF @@TRANCOUNT=0 BEGIN TRANSACTION
4386GO
4387CREATE INDEX [IDX_BLPU_PROV_CODE] ON [dbo].[BLPU] ([PROV_CODE]) ON [PRIMARY];
4388GO
4389IF @@ERROR<>0 
4390Begin
4391	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4392	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.IDX_BLPU_PROV_CODE')
4393END
4394GO
4395
4396IF @@TRANCOUNT=0 BEGIN TRANSACTION
4397GO
4398CREATE INDEX [IDX_BLPU_UPDDATE] ON [dbo].[BLPU] ([UPDDATE]) ON [PRIMARY];
4399GO
4400IF @@ERROR<>0 
4401Begin
4402	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4403	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.IDX_BLPU_UPDDATE')
4404END
4405GO
4406
4407IF @@TRANCOUNT=0 BEGIN TRANSACTION
4408GO
4409CREATE INDEX [IDX_BLPU_UPRN] ON [dbo].[BLPU] ([UPRN]) ON [PRIMARY];
4410GO
4411IF @@ERROR<>0 
4412Begin
4413	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4414	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.IDX_BLPU_UPRN')
4415END
4416GO
4417
4418IF @@TRANCOUNT=0 BEGIN TRANSACTION
4419GO
4420CREATE INDEX [IDX_STREET_DESC_LASTUPDATE] ON [dbo].[STREET_DESCRIPTOR] ([LAST_UPDATE_DATE]) WITH (FILLFACTOR = 90) ON [PRIMARY];
4421GO
4422IF @@ERROR<>0 
4423Begin
4424	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4425	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET_DESCRIPTOR.IDX_STREET_DESC_LASTUPDATE')
4426END
4427GO
4428
4429IF @@TRANCOUNT=0 BEGIN TRANSACTION
4430GO
4431CREATE SPATIAL INDEX [SIDX_STREET_SP_GEOMETRY] ON [dbo].[STREET_SP] ([GEOMETRY]) 
4432USING GEOMETRY_GRID
4433WITH (BOUNDING_BOX = (0, 0, 700000, 1300000), GRIDS =(LEVEL_1 = MEDIUM, LEVEL_2 = MEDIUM, LEVEL_3 = MEDIUM, LEVEL_4 = MEDIUM), CELLS_PER_OBJECT = 16) ;
4434GO
4435IF @@ERROR<>0 
4436Begin
4437	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4438	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.STREET_SP.SIDX_STREET_SP_GEOMETRY')
4439END
4440GO
4441
4442IF @@TRANCOUNT=0 BEGIN TRANSACTION
4443GO
4444CREATE SPATIAL INDEX [SIDX_BLPU_GEOMETRY] ON [dbo].[BLPU] ([GEOMETRY]) 
4445USING GEOMETRY_GRID
4446WITH (BOUNDING_BOX = (0, 0, 700000, 1300000), GRIDS =(LEVEL_1 = MEDIUM, LEVEL_2 = MEDIUM, LEVEL_3 = MEDIUM, LEVEL_4 = MEDIUM), CELLS_PER_OBJECT = 16) ;
4447GO
4448IF @@ERROR<>0 
4449Begin
4450	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4451	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.BLPU.SIDX_BLPU_GEOMETRY')
4452END
4453GO
4454
4455IF @@TRANCOUNT=0 BEGIN TRANSACTION
4456GO
4457CREATE SPATIAL INDEX [SIDX_NODE_GEOMETRY] ON [dbo].[NODE] ([GEOMETRY]) 
4458USING GEOMETRY_GRID
4459WITH (BOUNDING_BOX = (0, 0, 700000, 1300000), GRIDS =(LEVEL_1 = MEDIUM, LEVEL_2 = MEDIUM, LEVEL_3 = MEDIUM, LEVEL_4 = MEDIUM), CELLS_PER_OBJECT = 16) ;
4460GO
4461IF @@ERROR<>0 
4462Begin
4463	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4464	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.NODE.SIDX_NODE_GEOMETRY')
4465END
4466GO
4467
4468IF @@TRANCOUNT=0 BEGIN TRANSACTION
4469GO
4470CREATE SPATIAL INDEX [SIDX_ESU_GEOMETRY] ON [dbo].[ESU] ([GEOMETRY]) 
4471USING GEOMETRY_GRID
4472WITH (BOUNDING_BOX = (0, 0, 700000, 1300000), GRIDS =(LEVEL_1 = MEDIUM, LEVEL_2 = MEDIUM, LEVEL_3 = MEDIUM, LEVEL_4 = MEDIUM), CELLS_PER_OBJECT = 16) ;
4473GO
4474IF @@ERROR<>0 
4475Begin
4476	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4477	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to add index dbo.ESU.SIDX_ESU_GEOMETRY')
4478END
4479GO
4480
4481IF @@TRANCOUNT=0 BEGIN TRANSACTION
4482GO
4483if exists (select * from sys.database_principals where name = N'GGP\billp')
4484GRANT CONNECT TO [GGP\billp]
4485IF @@ERROR<>0 
4486Begin
4487	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4488	INSERT INTO #ErrorLog (errno,errdescr) values(@@ERROR,'Failed to alter permissions')
4489END
4490GO
4491IF EXISTS (Select * from #ErrorLog)
4492BEGIN
4493	IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
4494END
4495ELSE
4496BEGIN
4497	IF @@TRANCOUNT>0 COMMIT TRANSACTION
4498END
4499IF EXISTS (Select * from #ErrorLog)
4500BEGIN
4501	Print 'Database synchronization script failed'
4502	GOTO QuitWithErrors
4503END
4504ELSE
4505BEGIN
4506	Print 'Database synchronization completed successfully'
4507END
4508
4509
4510
4511QuitWithErrors: