Migrations executed individually pass, executing all migrations fails

[devinleighsmith]

I wasn't able to find a similar issue within this repository, but I'm hoping someone can provide some insight into this issue.

Essentially, I get an error when running dotnet ef database update, the final migration fails 20211001205930_v0.2.11.0 (see below output for stack trace). However, if I run all of the previous migrations, and then run the final migration like so:

dotnet ef database update 20210909194500_v0.2.10.0
dotnet ef database update

all of the migrations pass.

I'm not understanding the reason for the difference in behaviour, and am concerned that I may have a more fundamental understanding of how migrations work. There should be no difference in running migrations individually and running them all at once should there?

I can provide more code on request, if that would be helpful as this is an open source project.

Starting from a fresh (dropped) database, this fails:

$ dotnet ef database update
Build started...
Build succeeded.
info: Pims.Dal.PimsContextFactory[0]
      Context Factory Started
Applying migration '20210823233813_Initial'.
Applying migration '20210908232309_v0.2.0.9.1'.
Applying migration '20210909194500_v0.2.10.0'.
Applying migration '20211001205930_v0.2.11.0'.
Failed executing DbCommand (20ms) [Parameters=[], CommandType='Text', CommandTimeout='600']
DECLARE @var1 sysname;
SELECT @var1 = [d].[name]
FROM [sys].[default_constraints] [d]
INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PIMS_USER_ORGANIZATION]') AND [c].[name] = N'IS_DISABLED');
IF @var1 IS NOT NULL EXEC(N'ALTER TABLE [PIMS_USER_ORGANIZATION] DROP CONSTRAINT [' + @var1 + '];');
ALTER TABLE [PIMS_USER_ORGANIZATION] ADD CONSTRAINT PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF DEFAULT CAST(0 AS bit) FOR [IS_DISABLED];
Microsoft.Data.SqlClient.SqlException (0x80131904): There is already an object named 'PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF' in the database.
Could not create constraint or index. See previous errors.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlConnection.cs:line 1777
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\TdsParser.cs:line 1313
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\TdsParser.cs:line 2523
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 3062
   at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 1446
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 1061
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
ClientConnectionId:8d3909f9-8557-4bb4-91f5-303f51faf0ac
Error Number:2714,State:5,Class:16
There is already an object named 'PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF' in the database.
Could not create constraint or index. See previous errors.

Starting from a fresh(dropped) database, executing all databases except the most recent migration, and then updating the most recent migration in a subsequent command passes.

$ dotnet ef database update 20210909194500_v0.2.10.0
Build started...
Build succeeded.
info: Pims.Dal.PimsContextFactory[0]
      Context Factory Started
Applying migration '20210823233813_Initial'.
Applying migration '20210908232309_v0.2.0.9.1'.
Applying migration '20210909194500_v0.2.10.0'.
Done.

$ dotnet ef database update
Build started...
Build succeeded.
info: Pims.Dal.PimsContextFactory[0]
      Context Factory Started
Applying migration '20211001205930_v0.2.11.0'.
Done.

Here is the output of running just the last two migrations with verbose logging enabled.

Output

``` $ dotnet ef database update -v Using project 'C:\git\PSP\backend\dal\Pims.Dal.csproj'. Using startup project 'C:\git\PSP\backend\dal\Pims.Dal.csproj'. Writing 'C:\git\PSP\backend\dal\obj\Pims.Dal.csproj.EntityFrameworkCore.targets'... dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\Users\DevinS\AppData\Local\Temp\tmp42A3.tmp /verbosity:quiet /nologo C:\git\PSP\backend\dal\Pims.Dal.csproj Writing 'C:\git\PSP\backend\dal\obj\Pims.Dal.csproj.EntityFrameworkCore.targets'... dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\Users\DevinS\AppData\Local\Temp\tmp466D.tmp /verbosity:quiet /nologo C:\git\PSP\backend\dal\Pims.Dal.csproj Build started... dotnet build C:\git\PSP\backend\dal\Pims.Dal.csproj /verbosity:quiet /nologo Build succeeded. 0 Warning(s) 0 Error(s) Time Elapsed 00:00:04.10 Build succeeded. dotnet exec --depsfile C:\git\PSP\backend\dal\bin\Debug\net5.0\Pims.Dal.deps.json --additionalprobingpath C:\Users\DevinS\.nuget\packages --additionalprobingpath "C:\Program Files\dotnet\sdk\NuGetFallbackFolder" --runtimeconfig C:\git\PSP\backend\dal\bin\Debug\net5.0\Pims.Dal.runtimeconfig.json C:\Users\DevinS\.dotnet\tools\.store\dotnet-ef\5.0.9\dotnet-ef\5.0.9\tools\netcoreapp3.1\any\tools\netcoreapp2.0\any\ef.dll database update --assembly C:\git\PSP\backend\dal\bin\Debug\net5.0\Pims.Dal.dll --startup-assembly C:\git\PSP\backend\dal\bin\Debug\net5.0\Pims.Dal.dll --project-dir C:\git\PSP\backend\dal\ --language C# --working-dir C:\git\PSP\backend\dal --verbose --root-namespace Pims.Dal Using assembly 'Pims.Dal'. Using startup assembly 'Pims.Dal'. Using application base 'C:\git\PSP\backend\dal\bin\Debug\net5.0'. Using working directory 'C:\git\PSP\backend\dal'. Using root namespace 'Pims.Dal'. Using project directory 'C:\git\PSP\backend\dal\'. Remaining arguments: . Finding DbContext classes... Finding IDesignTimeDbContextFactory implementations... Found IDesignTimeDbContextFactory implementation 'PimsContextFactory'. Found DbContext 'PimsContext'. Finding application service provider in assembly 'Pims.Dal'... Finding Microsoft.Extensions.Hosting service provider... No static method 'CreateHostBuilder(string[])' was found on class 'Program'. No application service provider was found. Finding DbContext classes in the project... Using DbContext factory 'PimsContextFactory'. info: Pims.Dal.PimsContextFactory[0] Context Factory Started Using context 'PimsContext'. Finding design-time services for provider 'Microsoft.EntityFrameworkCore.SqlServer'... Using design-time services from provider 'Microsoft.EntityFrameworkCore.SqlServer'. Finding design-time services referenced by assembly 'Pims.Dal'... Finding design-time services referenced by assembly 'Pims.Dal'... Using design-time services from assembly 'Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite'. Finding IDesignTimeServices implementations in assembly 'Pims.Dal'... No design-time services were found. Migrating using database 'pims' on server 'localhost,5433'. Opening connection to database 'pims' on server 'localhost,5433'. Opened connection to database 'pims' on server 'localhost,5433'. Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (2ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT 1 Executed DbCommand (26ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT 1 Closing connection to database 'pims' on server 'localhost,5433'. Closed connection to database 'pims' on server 'localhost,5433'. Creating DbCommand for 'ExecuteScalar'. Created DbCommand for 'ExecuteScalar' (0ms). Opening connection to database 'pims' on server 'localhost,5433'. Opened connection to database 'pims' on server 'localhost,5433'. Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); Executed DbCommand (17ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); Closing connection to database 'pims' on server 'localhost,5433'. Closed connection to database 'pims' on server 'localhost,5433'. Opening connection to database 'pims' on server 'localhost,5433'. Opened connection to database 'pims' on server 'localhost,5433'. Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT 1 Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT 1 Closing connection to database 'pims' on server 'localhost,5433'. Closed connection to database 'pims' on server 'localhost,5433'. Creating DbCommand for 'ExecuteScalar'. Created DbCommand for 'ExecuteScalar' (0ms). Opening connection to database 'pims' on server 'localhost,5433'. Opened connection to database 'pims' on server 'localhost,5433'. Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); Closing connection to database 'pims' on server 'localhost,5433'. Closed connection to database 'pims' on server 'localhost,5433'. Creating DbCommand for 'ExecuteReader'. Created DbCommand for 'ExecuteReader' (0ms). Opening connection to database 'pims' on server 'localhost,5433'. Opened connection to database 'pims' on server 'localhost,5433'. Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT [MIGRATION_ID], [PRODUCT_VERSION] FROM [__EFMigrationsHistory] ORDER BY [MIGRATION_ID]; Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] SELECT [MIGRATION_ID], [PRODUCT_VERSION] FROM [__EFMigrationsHistory] ORDER BY [MIGRATION_ID]; A data reader was disposed. Closing connection to database 'pims' on server 'localhost,5433'. Closed connection to database 'pims' on server 'localhost,5433'. Applying migration '20210909194500_v0.2.10.0'. Opening connection to database 'pims' on server 'localhost,5433'. Opened connection to database 'pims' on server 'localhost,5433'. Beginning transaction with isolation level 'Unspecified'. Began transaction with isolation level 'ReadCommitted'. Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'PreUp Scripts' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'PreUp Scripts' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PreUp\00-Sequences.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PreUp\00-Sequences.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Create Sequences for Table Primary Keys' Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Create Sequences for Table Primary Keys' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE SEQUENCE [dbo].[PIMS_LEASE_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_PROPERTY_LEASE_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_PROPERTY_LEASE_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_ACTIVITY_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_ACTIVITY_PERIOD_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_ACTIVITY_PERIOD_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_ACTIVITY_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_EXPECTED_AMOUNT_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_EXPECTED_AMOUNT_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 -- NOT SURE WHAT THIS IS FOR WITHIN THE SCHEMA CREATE SEQUENCE [dbo].[PIMS_L_FILE_NO_SEQ] AS bigint START WITH 0 INCREMENT BY 1 MINVALUE 0 MAXVALUE 2147483647 NO CYCLE CACHE 50 Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE SEQUENCE [dbo].[PIMS_LEASE_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_PROPERTY_LEASE_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_PROPERTY_LEASE_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_ACTIVITY_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_ACTIVITY_PERIOD_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_ACTIVITY_PERIOD_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_LEASE_ACTIVITY_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_EXPECTED_AMOUNT_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 CREATE SEQUENCE [dbo].[PIMS_EXPECTED_AMOUNT_H_ID_SEQ] AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 50 -- NOT SURE WHAT THIS IS FOR WITHIN THE SCHEMA CREATE SEQUENCE [dbo].[PIMS_L_FILE_NO_SEQ] AS bigint START WITH 0 INCREMENT BY 1 MINVALUE 0 MAXVALUE 2147483647 NO CYCLE CACHE 50 Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PreUp\01-History.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PreUp\01-History.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Create history tables' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Create history tables' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [dbo].[PIMS_LEASE_HIST] ( [_LEASE_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_LEASE_H_ID_SEQ]), [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [EXPIRED] bit NOT NULL, [EXPIRY_DATE] datetime NULL, [HAS_DIGITAL_FILE] bit NOT NULL, [HAS_DIGITAL_LICENSE] bit NOT NULL, [HAS_PHYSICAL_FILE] bit NOT NULL, [HAS_PHYSICAL_LICENSE] bit NOT NULL, [INSPECTION_DATE] datetime NULL, [INSPECTION_NOTES] nvarchar(4000) NULL, [INSURANCE_END_DATE] datetime NULL, [INSURANCE_START_DATE] datetime NULL, [L_FILE_NO] nvarchar(50) NULL, [LEASE_AMOUNT] nvarchar(40) NULL, [LEASE_ID] bigint NOT NULL, [LEASE_NOTES] nvarchar(4000) NULL, [LEASE_PMT_FREQ_TYPE_CODE] nvarchar(40) NOT NULL, [LEASE_PROGRAM_TYPE_CODE] nvarchar(40) NULL, [LEASE_PURPOSE_SUBTYPE_CODE] smallint NOT NULL, [LEASE_PURPOSE_TYPE_CODE] smallint NOT NULL, [LEASE_STATUS_TYPE_CODE] nvarchar(40) NOT NULL, [PROP_MGMT_ORG_ID] bigint NULL, [PROPERTY_MANAGER_ID] bigint NULL, [PS_FILE_NO] nvarchar(50) NULL, [RENEWAL_DATE] datetime NULL, [SECURITY_END_DATE] datetime NULL, [SECURITY_START_DATE] datetime NULL, [START_DATE] datetime NULL, [TENANT_ID] bigint NOT NULL, [TFA_FILE_NO] int NULL, [UNIT] nvarchar(2000) NULL, PRIMARY KEY CLUSTERED([_LEASE_HIST_ID]) ON [PRIMARY]) CREATE TABLE [dbo].[PIMS_PROPERTY_LEASE_HIST] ( [_PROPERTY_LEASE_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_PROPERTY_LEASE_H_ID_SEQ]), [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [LEASE_ID] bigint NOT NULL, [PROPERTY_ID] bigint NOT NULL, [PROPERTY_LEASE_ID] bigint NOT NULL, PRIMARY KEY CLUSTERED([_PROPERTY_LEASE_HIST_ID]) ON [PRIMARY]) CREATE TABLE [dbo].[PIMS_EXPECTED_AMOUNT_HIST] ( [_EXPECTED_AMOUNT_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_EXPECTED_AMOUNT_H_ID_SEQ]), [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [EXPECTED_AMOUNT] money NULL, [EXPECTED_AMOUNT_ID] bigint NOT NULL, [LEASE_ACTIVITY_PERIOD_ID] bigint NOT NULL, [LEASE_ID] bigint NOT NULL, PRIMARY KEY CLUSTERED([_EXPECTED_AMOUNT_HIST_ID]) ON [PRIMARY]) CREATE TABLE [dbo].[PIMS_LEASE_ACTIVITY_PERIOD_HIST] ( [_LEASE_ACTIVITY_PERIOD_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_LEASE_ACTIVITY_PERIOD_H_ID_SEQ]), [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [IS_CLOSED] bit NULL, [LEASE_ACTIVITY_PERIOD_ID] bigint NOT NULL, [PERIOD_DATE] datetime NOT NULL, PRIMARY KEY CLUSTERED([_LEASE_ACTIVITY_PERIOD_HIST_ID]) ON [PRIMARY]) Executed DbCommand (26ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [dbo].[PIMS_LEASE_HIST] ( [_LEASE_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_LEASE_H_ID_SEQ]), [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [EXPIRED] bit NOT NULL, [EXPIRY_DATE] datetime NULL, [HAS_DIGITAL_FILE] bit NOT NULL, [HAS_DIGITAL_LICENSE] bit NOT NULL, [HAS_PHYSICAL_FILE] bit NOT NULL, [HAS_PHYSICAL_LICENSE] bit NOT NULL, [INSPECTION_DATE] datetime NULL, [INSPECTION_NOTES] nvarchar(4000) NULL, [INSURANCE_END_DATE] datetime NULL, [INSURANCE_START_DATE] datetime NULL, [L_FILE_NO] nvarchar(50) NULL, [LEASE_AMOUNT] nvarchar(40) NULL, [LEASE_ID] bigint NOT NULL, [LEASE_NOTES] nvarchar(4000) NULL, [LEASE_PMT_FREQ_TYPE_CODE] nvarchar(40) NOT NULL, [LEASE_PROGRAM_TYPE_CODE] nvarchar(40) NULL, [LEASE_PURPOSE_SUBTYPE_CODE] smallint NOT NULL, [LEASE_PURPOSE_TYPE_CODE] smallint NOT NULL, [LEASE_STATUS_TYPE_CODE] nvarchar(40) NOT NULL, [PROP_MGMT_ORG_ID] bigint NULL, [PROPERTY_MANAGER_ID] bigint NULL, [PS_FILE_NO] nvarchar(50) NULL, [RENEWAL_DATE] datetime NULL, [SECURITY_END_DATE] datetime NULL, [SECURITY_START_DATE] datetime NULL, [START_DATE] datetime NULL, [TENANT_ID] bigint NOT NULL, [TFA_FILE_NO] int NULL, [UNIT] nvarchar(2000) NULL, PRIMARY KEY CLUSTERED([_LEASE_HIST_ID]) ON [PRIMARY]) CREATE TABLE [dbo].[PIMS_PROPERTY_LEASE_HIST] ( [_PROPERTY_LEASE_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_PROPERTY_LEASE_H_ID_SEQ]), [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [LEASE_ID] bigint NOT NULL, [PROPERTY_ID] bigint NOT NULL, [PROPERTY_LEASE_ID] bigint NOT NULL, PRIMARY KEY CLUSTERED([_PROPERTY_LEASE_HIST_ID]) ON [PRIMARY]) CREATE TABLE [dbo].[PIMS_EXPECTED_AMOUNT_HIST] ( [_EXPECTED_AMOUNT_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_EXPECTED_AMOUNT_H_ID_SEQ]), [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [EXPECTED_AMOUNT] money NULL, [EXPECTED_AMOUNT_ID] bigint NOT NULL, [LEASE_ACTIVITY_PERIOD_ID] bigint NOT NULL, [LEASE_ID] bigint NOT NULL, PRIMARY KEY CLUSTERED([_EXPECTED_AMOUNT_HIST_ID]) ON [PRIMARY]) CREATE TABLE [dbo].[PIMS_LEASE_ACTIVITY_PERIOD_HIST] ( [_LEASE_ACTIVITY_PERIOD_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_LEASE_ACTIVITY_PERIOD_H_ID_SEQ]), [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [IS_CLOSED] bit NULL, [LEASE_ACTIVITY_PERIOD_ID] bigint NOT NULL, [PERIOD_DATE] datetime NOT NULL, PRIMARY KEY CLUSTERED([_LEASE_ACTIVITY_PERIOD_HIST_ID]) ON [PRIMARY]) Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [dbo].[PIMS_LEASE_ACTIVITY_HIST] ( [_LEASE_ACTIVITY_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_LEASE_ACTIVITY_H_ID_SEQ]), [ACTIVITY_DATE] datetime NULL, [AMOUNT] money NULL, [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [COMMENT] nvarchar(40) NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [LEASE_ACTIVITY_ID] bigint NOT NULL, [LEASE_ACTIVITY_PERIOD_ID] bigint NOT NULL, [LEASE_ID] bigint NOT NULL, [LEASE_SUBTYPE_CODE] nvarchar(20) NOT NULL, [LEASE_TYPE_CODE] smallint NOT NULL, PRIMARY KEY CLUSTERED([_LEASE_ACTIVITY_HIST_ID]) ON [PRIMARY]) Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [dbo].[PIMS_LEASE_ACTIVITY_HIST] ( [_LEASE_ACTIVITY_HIST_ID] bigint NOT NULL DEFAULT (NEXT VALUE FOR [PIMS_LEASE_ACTIVITY_H_ID_SEQ]), [ACTIVITY_DATE] datetime NULL, [AMOUNT] money NULL, [APP_CREATE_TIMESTAMP] datetime NOT NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [COMMENT] nvarchar(40) NULL, [CONCURRENCY_CONTROL_NUMBER] bigint NOT NULL, [DB_CREATE_TIMESTAMP] datetime NOT NULL, [DB_CREATE_USERID] nvarchar(30) NOT NULL, [DB_LAST_UPDATE_TIMESTAMP] datetime NOT NULL, [DB_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [EFFECTIVE_DATE_HIST] datetime NOT NULL DEFAULT (getutcdate()), [END_DATE_HIST] datetime NULL, [LEASE_ACTIVITY_ID] bigint NOT NULL, [LEASE_ACTIVITY_PERIOD_ID] bigint NOT NULL, [LEASE_ID] bigint NOT NULL, [LEASE_SUBTYPE_CODE] nvarchar(20) NOT NULL, [LEASE_TYPE_CODE] smallint NOT NULL, PRIMARY KEY CLUSTERED([_LEASE_ACTIVITY_HIST_ID]) ON [PRIMARY]) Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PreUp\01-TableDefinition.sql' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PreUp\01-TableDefinition.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMSX_TableDefinitions (TABLE_NAME, TABLE_ALIAS) VALUES ('PIMS_LEASE','PIMS_LEASE') , ('PIMS_PROPERTY_LEASE','PIMS_PROPLS') , ('PIMS_EXPECTED_AMOUNT','PIMS_EXPAMT') , ('PIMS_LEASE_ACTIVITY_PERIOD','PIMS_LSACPR') , ('PIMS_LEASE_ACTIVITY','PIMS_LSACTV') , ('PIMS_LEASE_TYPE','PIMS_LSTYPE') , ('PIMS_LEASE_SUBTYPE','PIMS_LSSTYP') , ('PIMS_LEASE_PURPOSE_TYPE','PIMS_LSPRTY') , ('PIMS_LEASE_PURPOSE_SUBTYPE','PIMS_LSPRST') , ('PIMS_LEASE_STATUS_TYPE','PIMS_LSSTSY') , ('PIMS_LEASE_PMT_FREQ_TYPE','PIMS_LSPMTF') , ('PIMS_LEASE_PROGRAM_TYPE','PIMS_LSPRGT'); Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMSX_TableDefinitions (TABLE_NAME, TABLE_ALIAS) VALUES ('PIMS_LEASE','PIMS_LEASE') , ('PIMS_PROPERTY_LEASE','PIMS_PROPLS') , ('PIMS_EXPECTED_AMOUNT','PIMS_EXPAMT') , ('PIMS_LEASE_ACTIVITY_PERIOD','PIMS_LSACPR') , ('PIMS_LEASE_ACTIVITY','PIMS_LSACTV') , ('PIMS_LEASE_TYPE','PIMS_LSTYPE') , ('PIMS_LEASE_SUBTYPE','PIMS_LSSTYP') , ('PIMS_LEASE_PURPOSE_TYPE','PIMS_LSPRTY') , ('PIMS_LEASE_PURPOSE_SUBTYPE','PIMS_LSPRST') , ('PIMS_LEASE_STATUS_TYPE','PIMS_LSSTSY') , ('PIMS_LEASE_PMT_FREQ_TYPE','PIMS_LSPMTF') , ('PIMS_LEASE_PROGRAM_TYPE','PIMS_LSPRGT'); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_ACTIVITY_PERIOD] ( [LEASE_ACTIVITY_PERIOD_ID] BIGINT NOT NULL CONSTRAINT LSACPR_LEASE_ACTIVITY_PERIOD_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_LEASE_ACTIVITY_PERIOD_ID_SEQ), [PERIOD_DATE] DATETIME NOT NULL, [IS_CLOSED] bit NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSACPR_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LSACPR_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LSACPR_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [LSACPR_PK] PRIMARY KEY ([LEASE_ACTIVITY_PERIOD_ID]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'LEASE_ACTIVITY_PERIOD_ID'; SET @description = N'The date of the activity period'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'PERIOD_DATE'; SET @description = N'Whether this lease activity period is closed'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'IS_CLOSED'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Executed DbCommand (22ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_ACTIVITY_PERIOD] ( [LEASE_ACTIVITY_PERIOD_ID] BIGINT NOT NULL CONSTRAINT LSACPR_LEASE_ACTIVITY_PERIOD_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_LEASE_ACTIVITY_PERIOD_ID_SEQ), [PERIOD_DATE] DATETIME NOT NULL, [IS_CLOSED] bit NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSACPR_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LSACPR_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LSACPR_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [LSACPR_PK] PRIMARY KEY ([LEASE_ACTIVITY_PERIOD_ID]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'LEASE_ACTIVITY_PERIOD_ID'; SET @description = N'The date of the activity period'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'PERIOD_DATE'; SET @description = N'Whether this lease activity period is closed'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'IS_CLOSED'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY_PERIOD', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_PMT_FREQ_TYPE] ( [LEASE_PMT_FREQ_TYPE_CODE] nvarchar(40) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSPMTF_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSPMTF_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSPMTF_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSPMTF_PK] PRIMARY KEY ([LEASE_PMT_FREQ_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'LEASE_PMT_FREQ_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Executed DbCommand (10ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_PMT_FREQ_TYPE] ( [LEASE_PMT_FREQ_TYPE_CODE] nvarchar(40) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSPMTF_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSPMTF_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSPMTF_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSPMTF_PK] PRIMARY KEY ([LEASE_PMT_FREQ_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'LEASE_PMT_FREQ_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PMT_FREQ_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_PROGRAM_TYPE] ( [LEASE_PROGRAM_TYPE_CODE] nvarchar(40) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSPRGT_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSPRGT_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSPRGT_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSPRGT_PK] PRIMARY KEY ([LEASE_PROGRAM_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'LEASE_PROGRAM_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Executed DbCommand (10ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_PROGRAM_TYPE] ( [LEASE_PROGRAM_TYPE_CODE] nvarchar(40) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSPRGT_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSPRGT_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSPRGT_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSPRGT_PK] PRIMARY KEY ([LEASE_PROGRAM_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'LEASE_PROGRAM_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PROGRAM_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_PURPOSE_SUBTYPE] ( [LEASE_PURPOSE_SUBTYPE_CODE] SMALLINT NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSPRST_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSPRST_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSPRST_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSPRST_PK] PRIMARY KEY ([LEASE_PURPOSE_SUBTYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'LEASE_PURPOSE_SUBTYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'DISPLAY_ORDER'; Executed DbCommand (9ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_PURPOSE_SUBTYPE] ( [LEASE_PURPOSE_SUBTYPE_CODE] SMALLINT NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSPRST_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSPRST_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSPRST_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSPRST_PK] PRIMARY KEY ([LEASE_PURPOSE_SUBTYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'LEASE_PURPOSE_SUBTYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_SUBTYPE', 'COLUMN', N'DISPLAY_ORDER'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_PURPOSE_TYPE] ( [LEASE_PURPOSE_TYPE_CODE] SMALLINT NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSPRTY_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSPRTY_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSPRTY_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSPRTY_PK] PRIMARY KEY ([LEASE_PURPOSE_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'LEASE_PURPOSE_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Executed DbCommand (10ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_PURPOSE_TYPE] ( [LEASE_PURPOSE_TYPE_CODE] SMALLINT NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSPRTY_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSPRTY_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSPRTY_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSPRTY_PK] PRIMARY KEY ([LEASE_PURPOSE_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'LEASE_PURPOSE_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_PURPOSE_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_STATUS_TYPE] ( [LEASE_STATUS_TYPE_CODE] nvarchar(40) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSSTSY_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSSTSY_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSSTSY_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSSTSY_PK] PRIMARY KEY ([LEASE_STATUS_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'LEASE_STATUS_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Executed DbCommand (10ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_STATUS_TYPE] ( [LEASE_STATUS_TYPE_CODE] nvarchar(40) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSSTSY_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSSTSY_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSSTSY_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSSTSY_PK] PRIMARY KEY ([LEASE_STATUS_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'LEASE_STATUS_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_STATUS_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_SUBTYPE] ( [LEASE_SUBTYPE_CODE] nvarchar(20) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSSTYP_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSSTYP_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSSTYP_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSSTYP_PK] PRIMARY KEY ([LEASE_SUBTYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'LEASE_SUBTYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'DISPLAY_ORDER'; Executed DbCommand (10ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_SUBTYPE] ( [LEASE_SUBTYPE_CODE] nvarchar(20) NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSSTYP_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSSTYP_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSSTYP_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSSTYP_PK] PRIMARY KEY ([LEASE_SUBTYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'LEASE_SUBTYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_SUBTYPE', 'COLUMN', N'DISPLAY_ORDER'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_TYPE] ( [LEASE_TYPE_CODE] SMALLINT NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSTYPE_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSTYPE_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSTYPE_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSTYPE_PK] PRIMARY KEY ([LEASE_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'LEASE_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_TYPE] ( [LEASE_TYPE_CODE] SMALLINT NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSTYPE_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [DESCRIPTION] nvarchar(200) NOT NULL CONSTRAINT LSTYPE_DESCRIPTION_DEF DEFAULT (''), [IS_DISABLED] bit NOT NULL CONSTRAINT LSTYPE_IS_DISABLED_DEF DEFAULT CAST(0 AS bit), [DISPLAY_ORDER] int NULL, CONSTRAINT [LSTYPE_PK] PRIMARY KEY ([LEASE_TYPE_CODE]) ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Primary key code to identify record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'LEASE_TYPE_CODE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'Friendly description of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'DESCRIPTION'; SET @description = N'Whether this record is disabled'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'IS_DISABLED'; SET @description = N'Sorting order of record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_TYPE', 'COLUMN', N'DISPLAY_ORDER'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE] ( [LEASE_ID] BIGINT NOT NULL CONSTRAINT LEASE_LEASE_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_LEASE_ID_SEQ), [PROP_MGMT_ORG_ID] BIGINT NULL, [LEASE_PURPOSE_TYPE_CODE] SMALLINT NOT NULL, [LEASE_PURPOSE_SUBTYPE_CODE] SMALLINT NOT NULL, [LEASE_STATUS_TYPE_CODE] nvarchar(40) NULL, [LEASE_PMT_FREQ_TYPE_CODE] nvarchar(40) NULL, [LEASE_PROGRAM_TYPE_CODE] nvarchar(40) NULL, [PROPERTY_MANAGER_ID] BIGINT NULL, [TENANT_ID] BIGINT NULL, [L_FILE_NO] nvarchar(50) NULL, [TFA_FILE_NO] int NULL, [PS_FILE_NO] nvarchar(50) NULL, [START_DATE] DATETIME NULL, [RENEWAL_DATE] DATETIME NULL, [EXPIRY_DATE] DATETIME NULL, [LEASE_AMOUNT] nvarchar(40) NULL, [INSURANCE_START_DATE] DATETIME NULL, [INSURANCE_END_DATE] DATETIME NULL, [SECURITY_START_DATE] DATETIME NULL, [SECURITY_END_DATE] DATETIME NULL, [INSPECTION_DATE] DATETIME NULL, [INSPECTION_NOTES] nvarchar(4000) NULL, [LEASE_NOTES] nvarchar(4000) NULL, [UNIT] nvarchar(2000) NULL, [EXPIRED] bit NOT NULL, [HAS_PHYSICAL_FILE] bit NOT NULL, [HAS_DIGITAL_FILE] bit NOT NULL, [HAS_PHYSICAL_LICENSE] bit NOT NULL, [HAS_DIGITAL_LICENSE] bit NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LEASE_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LEASE_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LEASE_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [LEASE_PK] PRIMARY KEY ([LEASE_ID]), CONSTRAINT [PIM_LSPMTF_PIM_LEASE_FK] FOREIGN KEY ([LEASE_PMT_FREQ_TYPE_CODE]) REFERENCES [PIMS_LEASE_PMT_FREQ_TYPE] ([LEASE_PMT_FREQ_TYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSPRGT_PIM_LEASE_FK] FOREIGN KEY ([LEASE_PROGRAM_TYPE_CODE]) REFERENCES [PIMS_LEASE_PROGRAM_TYPE] ([LEASE_PROGRAM_TYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSPRST_PIM_LEASE_FK] FOREIGN KEY ([LEASE_PURPOSE_SUBTYPE_CODE]) REFERENCES [PIMS_LEASE_PURPOSE_SUBTYPE] ([LEASE_PURPOSE_SUBTYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSPRTY_PIM_LEASE_FK] FOREIGN KEY ([LEASE_PURPOSE_TYPE_CODE]) REFERENCES [PIMS_LEASE_PURPOSE_TYPE] ([LEASE_PURPOSE_TYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSSTSY_PIM_LEASE_FK] FOREIGN KEY ([LEASE_STATUS_TYPE_CODE]) REFERENCES [PIMS_LEASE_STATUS_TYPE] ([LEASE_STATUS_TYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_ORG_PIM_LEASE_FK] FOREIGN KEY ([PROP_MGMT_ORG_ID]) REFERENCES [PIMS_ORGANIZATION] ([ORGANIZATION_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_PERSON_PIM_LEASE_PM_CONTACT_FK] FOREIGN KEY ([PROPERTY_MANAGER_ID]) REFERENCES [PIMS_PERSON] ([PERSON_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_PERSON_PIM_LEASE_TENANT_FK] FOREIGN KEY ([TENANT_ID]) REFERENCES [PIMS_PERSON] ([PERSON_ID]) ON DELETE NO ACTION ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_ID'; SET @description = N'Foreign key to property management organization'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'PROP_MGMT_ORG_ID'; SET @description = N'Foreign key to lease purpose type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_PURPOSE_TYPE_CODE'; SET @description = N'Foreign key to lease purpose subtype'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_PURPOSE_SUBTYPE_CODE'; SET @description = N'Foreign key to lease status type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_STATUS_TYPE_CODE'; SET @description = N'Foreign key to lease payment frequency type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_PMT_FREQ_TYPE_CODE'; SET @description = N'Foreign key to lease program type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_PROGRAM_TYPE_CODE'; SET @description = N'Foreign key to lease property manager person'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'PROPERTY_MANAGER_ID'; SET @description = N'Foreign key to lease tenant person'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'TENANT_ID'; SET @description = N'The LIS File #'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'L_FILE_NO'; SET @description = N'The TFA File #'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'TFA_FILE_NO'; SET @description = N'The PS File #'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'PS_FILE_NO'; SET @description = N'The date this lease starts'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'START_DATE'; SET @description = N'The date this lease renews'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'RENEWAL_DATE'; SET @description = N'The date this lease expires'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'EXPIRY_DATE'; SET @description = N'The amount of the lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_AMOUNT'; SET @description = N'The date this lease insurance starts'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'INSURANCE_START_DATE'; SET @description = N'The date this lease insurance ends'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'INSURANCE_END_DATE'; SET @description = N'The date this lease security starts'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'SECURITY_START_DATE'; SET @description = N'The date this lease security ends'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'SECURITY_END_DATE'; SET @description = N'The date the property will be inspected'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'INSPECTION_DATE'; SET @description = N'A note on the inspection'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'INSPECTION_NOTES'; SET @description = N'A note on the lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_NOTES'; SET @description = N'A description of the unit'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'UNIT'; SET @description = N'Whether this lease has expired'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'EXPIRED'; SET @description = N'Whether this lease has a physical file'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'HAS_PHYSICAL_FILE'; SET @description = N'Whether this lease has a digital file'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'HAS_DIGITAL_FILE'; SET @description = N'Whether this lease has a physical license'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'HAS_PHYSICAL_LICENSE'; SET @description = N'Whether this lease has a digital license'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'HAS_DIGITAL_LICENSE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Executed DbCommand (56ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE] ( [LEASE_ID] BIGINT NOT NULL CONSTRAINT LEASE_LEASE_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_LEASE_ID_SEQ), [PROP_MGMT_ORG_ID] BIGINT NULL, [LEASE_PURPOSE_TYPE_CODE] SMALLINT NOT NULL, [LEASE_PURPOSE_SUBTYPE_CODE] SMALLINT NOT NULL, [LEASE_STATUS_TYPE_CODE] nvarchar(40) NULL, [LEASE_PMT_FREQ_TYPE_CODE] nvarchar(40) NULL, [LEASE_PROGRAM_TYPE_CODE] nvarchar(40) NULL, [PROPERTY_MANAGER_ID] BIGINT NULL, [TENANT_ID] BIGINT NULL, [L_FILE_NO] nvarchar(50) NULL, [TFA_FILE_NO] int NULL, [PS_FILE_NO] nvarchar(50) NULL, [START_DATE] DATETIME NULL, [RENEWAL_DATE] DATETIME NULL, [EXPIRY_DATE] DATETIME NULL, [LEASE_AMOUNT] nvarchar(40) NULL, [INSURANCE_START_DATE] DATETIME NULL, [INSURANCE_END_DATE] DATETIME NULL, [SECURITY_START_DATE] DATETIME NULL, [SECURITY_END_DATE] DATETIME NULL, [INSPECTION_DATE] DATETIME NULL, [INSPECTION_NOTES] nvarchar(4000) NULL, [LEASE_NOTES] nvarchar(4000) NULL, [UNIT] nvarchar(2000) NULL, [EXPIRED] bit NOT NULL, [HAS_PHYSICAL_FILE] bit NOT NULL, [HAS_DIGITAL_FILE] bit NOT NULL, [HAS_PHYSICAL_LICENSE] bit NOT NULL, [HAS_DIGITAL_LICENSE] bit NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LEASE_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LEASE_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LEASE_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [LEASE_PK] PRIMARY KEY ([LEASE_ID]), CONSTRAINT [PIM_LSPMTF_PIM_LEASE_FK] FOREIGN KEY ([LEASE_PMT_FREQ_TYPE_CODE]) REFERENCES [PIMS_LEASE_PMT_FREQ_TYPE] ([LEASE_PMT_FREQ_TYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSPRGT_PIM_LEASE_FK] FOREIGN KEY ([LEASE_PROGRAM_TYPE_CODE]) REFERENCES [PIMS_LEASE_PROGRAM_TYPE] ([LEASE_PROGRAM_TYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSPRST_PIM_LEASE_FK] FOREIGN KEY ([LEASE_PURPOSE_SUBTYPE_CODE]) REFERENCES [PIMS_LEASE_PURPOSE_SUBTYPE] ([LEASE_PURPOSE_SUBTYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSPRTY_PIM_LEASE_FK] FOREIGN KEY ([LEASE_PURPOSE_TYPE_CODE]) REFERENCES [PIMS_LEASE_PURPOSE_TYPE] ([LEASE_PURPOSE_TYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSSTSY_PIM_LEASE_FK] FOREIGN KEY ([LEASE_STATUS_TYPE_CODE]) REFERENCES [PIMS_LEASE_STATUS_TYPE] ([LEASE_STATUS_TYPE_CODE]) ON DELETE NO ACTION, CONSTRAINT [PIM_ORG_PIM_LEASE_FK] FOREIGN KEY ([PROP_MGMT_ORG_ID]) REFERENCES [PIMS_ORGANIZATION] ([ORGANIZATION_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_PERSON_PIM_LEASE_PM_CONTACT_FK] FOREIGN KEY ([PROPERTY_MANAGER_ID]) REFERENCES [PIMS_PERSON] ([PERSON_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_PERSON_PIM_LEASE_TENANT_FK] FOREIGN KEY ([TENANT_ID]) REFERENCES [PIMS_PERSON] ([PERSON_ID]) ON DELETE NO ACTION ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_ID'; SET @description = N'Foreign key to property management organization'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'PROP_MGMT_ORG_ID'; SET @description = N'Foreign key to lease purpose type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_PURPOSE_TYPE_CODE'; SET @description = N'Foreign key to lease purpose subtype'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_PURPOSE_SUBTYPE_CODE'; SET @description = N'Foreign key to lease status type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_STATUS_TYPE_CODE'; SET @description = N'Foreign key to lease payment frequency type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_PMT_FREQ_TYPE_CODE'; SET @description = N'Foreign key to lease program type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_PROGRAM_TYPE_CODE'; SET @description = N'Foreign key to lease property manager person'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'PROPERTY_MANAGER_ID'; SET @description = N'Foreign key to lease tenant person'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'TENANT_ID'; SET @description = N'The LIS File #'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'L_FILE_NO'; SET @description = N'The TFA File #'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'TFA_FILE_NO'; SET @description = N'The PS File #'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'PS_FILE_NO'; SET @description = N'The date this lease starts'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'START_DATE'; SET @description = N'The date this lease renews'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'RENEWAL_DATE'; SET @description = N'The date this lease expires'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'EXPIRY_DATE'; SET @description = N'The amount of the lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_AMOUNT'; SET @description = N'The date this lease insurance starts'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'INSURANCE_START_DATE'; SET @description = N'The date this lease insurance ends'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'INSURANCE_END_DATE'; SET @description = N'The date this lease security starts'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'SECURITY_START_DATE'; SET @description = N'The date this lease security ends'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'SECURITY_END_DATE'; SET @description = N'The date the property will be inspected'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'INSPECTION_DATE'; SET @description = N'A note on the inspection'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'INSPECTION_NOTES'; SET @description = N'A note on the lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'LEASE_NOTES'; SET @description = N'A description of the unit'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'UNIT'; SET @description = N'Whether this lease has expired'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'EXPIRED'; SET @description = N'Whether this lease has a physical file'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'HAS_PHYSICAL_FILE'; SET @description = N'Whether this lease has a digital file'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'HAS_DIGITAL_FILE'; SET @description = N'Whether this lease has a physical license'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'HAS_PHYSICAL_LICENSE'; SET @description = N'Whether this lease has a digital license'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'HAS_DIGITAL_LICENSE'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_EXPECTED_AMOUNT] ( [EXPECTED_AMOUNT_ID] BIGINT NOT NULL CONSTRAINT EXPAMT_EXPECTED_AMOUNT_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_EXPECTED_AMOUNT_ID_SEQ), [LEASE_ID] BIGINT NOT NULL, [LEASE_ACTIVITY_PERIOD_ID] BIGINT NOT NULL, [EXPECTED_AMOUNT] MONEY NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT EXPAMT_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT EXPAMT_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT EXPAMT_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [EXPAMT_PK] PRIMARY KEY ([EXPECTED_AMOUNT_ID]), CONSTRAINT [PIM_LEASE_PIM_EXPAMT_FK] FOREIGN KEY ([LEASE_ID]) REFERENCES [PIMS_LEASE] ([LEASE_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSACPR_PIM_EXPAMT_FK] FOREIGN KEY ([LEASE_ACTIVITY_PERIOD_ID]) REFERENCES [PIMS_LEASE_ACTIVITY_PERIOD] ([LEASE_ACTIVITY_PERIOD_ID]) ON DELETE NO ACTION ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'EXPECTED_AMOUNT_ID'; SET @description = N'Foreign key to lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'LEASE_ID'; SET @description = N'Foreign key to lease activity period'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'LEASE_ACTIVITY_PERIOD_ID'; SET @description = N'The expected amount for this lease period'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'EXPECTED_AMOUNT'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Executed DbCommand (24ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_EXPECTED_AMOUNT] ( [EXPECTED_AMOUNT_ID] BIGINT NOT NULL CONSTRAINT EXPAMT_EXPECTED_AMOUNT_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_EXPECTED_AMOUNT_ID_SEQ), [LEASE_ID] BIGINT NOT NULL, [LEASE_ACTIVITY_PERIOD_ID] BIGINT NOT NULL, [EXPECTED_AMOUNT] MONEY NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT EXPAMT_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT EXPAMT_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT EXPAMT_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [EXPAMT_PK] PRIMARY KEY ([EXPECTED_AMOUNT_ID]), CONSTRAINT [PIM_LEASE_PIM_EXPAMT_FK] FOREIGN KEY ([LEASE_ID]) REFERENCES [PIMS_LEASE] ([LEASE_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSACPR_PIM_EXPAMT_FK] FOREIGN KEY ([LEASE_ACTIVITY_PERIOD_ID]) REFERENCES [PIMS_LEASE_ACTIVITY_PERIOD] ([LEASE_ACTIVITY_PERIOD_ID]) ON DELETE NO ACTION ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'EXPECTED_AMOUNT_ID'; SET @description = N'Foreign key to lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'LEASE_ID'; SET @description = N'Foreign key to lease activity period'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'LEASE_ACTIVITY_PERIOD_ID'; SET @description = N'The expected amount for this lease period'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'EXPECTED_AMOUNT'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_EXPECTED_AMOUNT', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_ACTIVITY] ( [LEASE_ACTIVITY_ID] BIGINT NOT NULL CONSTRAINT LSACTV_LEASE_ACTIVITY_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_LEASE_ACTIVITY_ID_SEQ), [LEASE_ID] BIGINT NOT NULL, [LEASE_TYPE_CODE] SMALLINT NOT NULL, [LEASE_SUBTYPE_CODE] nvarchar(20) NULL, [LEASE_ACTIVITY_PERIOD_ID] BIGINT NOT NULL, [AMOUNT] MONEY NULL, [ACTIVITY_DATE] datetime2 NULL, [COMMENT] nvarchar(40) NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSACTV_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LSACTV_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LSACTV_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [LSACTV_PK] PRIMARY KEY ([LEASE_ACTIVITY_ID]), CONSTRAINT [PIM_LEASE_PIM_LSACTV_FK] FOREIGN KEY ([LEASE_ID]) REFERENCES [PIMS_LEASE] ([LEASE_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSACPR_PIM_LSACTV_FK] FOREIGN KEY ([LEASE_ACTIVITY_PERIOD_ID]) REFERENCES [PIMS_LEASE_ACTIVITY_PERIOD] ([LEASE_ACTIVITY_PERIOD_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSSTYP_PIM_LSACTV_FK] FOREIGN KEY ([LEASE_SUBTYPE_CODE]) REFERENCES [PIMS_LEASE_SUBTYPE] ([LEASE_SUBTYPE_CODE]) ON DELETE CASCADE, CONSTRAINT [PIM_LSTYPE_PIM_LSACTV_FK] FOREIGN KEY ([LEASE_TYPE_CODE]) REFERENCES [PIMS_LEASE_TYPE] ([LEASE_TYPE_CODE]) ON DELETE CASCADE ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_ACTIVITY_ID'; SET @description = N'Foreign key to lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_ID'; SET @description = N'Foreign key to lease type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_TYPE_CODE'; SET @description = N'Foreign key to lease subtype'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_SUBTYPE_CODE'; SET @description = N'Foreign key to lease activity period'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_ACTIVITY_PERIOD_ID'; SET @description = N'The lease activity amount'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'AMOUNT'; SET @description = N'When the activity occurred'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'ACTIVITY_DATE'; SET @description = N'A comment related to the activity'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'COMMENT'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Executed DbCommand (24ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_LEASE_ACTIVITY] ( [LEASE_ACTIVITY_ID] BIGINT NOT NULL CONSTRAINT LSACTV_LEASE_ACTIVITY_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_LEASE_ACTIVITY_ID_SEQ), [LEASE_ID] BIGINT NOT NULL, [LEASE_TYPE_CODE] SMALLINT NOT NULL, [LEASE_SUBTYPE_CODE] nvarchar(20) NULL, [LEASE_ACTIVITY_PERIOD_ID] BIGINT NOT NULL, [AMOUNT] MONEY NULL, [ACTIVITY_DATE] datetime2 NULL, [COMMENT] nvarchar(40) NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT LSACTV_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LSACTV_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT LSACTV_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [LSACTV_PK] PRIMARY KEY ([LEASE_ACTIVITY_ID]), CONSTRAINT [PIM_LEASE_PIM_LSACTV_FK] FOREIGN KEY ([LEASE_ID]) REFERENCES [PIMS_LEASE] ([LEASE_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSACPR_PIM_LSACTV_FK] FOREIGN KEY ([LEASE_ACTIVITY_PERIOD_ID]) REFERENCES [PIMS_LEASE_ACTIVITY_PERIOD] ([LEASE_ACTIVITY_PERIOD_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_LSSTYP_PIM_LSACTV_FK] FOREIGN KEY ([LEASE_SUBTYPE_CODE]) REFERENCES [PIMS_LEASE_SUBTYPE] ([LEASE_SUBTYPE_CODE]) ON DELETE CASCADE, CONSTRAINT [PIM_LSTYPE_PIM_LSACTV_FK] FOREIGN KEY ([LEASE_TYPE_CODE]) REFERENCES [PIMS_LEASE_TYPE] ([LEASE_TYPE_CODE]) ON DELETE CASCADE ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_ACTIVITY_ID'; SET @description = N'Foreign key to lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_ID'; SET @description = N'Foreign key to lease type'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_TYPE_CODE'; SET @description = N'Foreign key to lease subtype'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_SUBTYPE_CODE'; SET @description = N'Foreign key to lease activity period'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'LEASE_ACTIVITY_PERIOD_ID'; SET @description = N'The lease activity amount'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'AMOUNT'; SET @description = N'When the activity occurred'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'ACTIVITY_DATE'; SET @description = N'A comment related to the activity'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'COMMENT'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_LEASE_ACTIVITY', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_PROPERTY_LEASE] ( [PROPERTY_LEASE_ID] BIGINT NOT NULL CONSTRAINT PROPLS_PROPERTY_LEASE_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_PROPERTY_LEASE_ID_SEQ), [PROPERTY_ID] BIGINT NOT NULL, [LEASE_ID] BIGINT NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT PROPLS_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT PROPLS_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT PROPLS_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [PROPLS_PK] PRIMARY KEY ([PROPERTY_LEASE_ID]), CONSTRAINT [PIM_LEASE_PIM_PROPLS_FK] FOREIGN KEY ([LEASE_ID]) REFERENCES [PIMS_LEASE] ([LEASE_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_PRPRTY_PIM_PROPLS_FK] FOREIGN KEY ([PROPERTY_ID]) REFERENCES [PIMS_PROPERTY] ([PROPERTY_ID]) ON DELETE NO ACTION ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'PROPERTY_LEASE_ID'; SET @description = N'Foreign key to property'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'PROPERTY_ID'; SET @description = N'Foreign key to lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'LEASE_ID'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Executed DbCommand (19ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TABLE [PIMS_PROPERTY_LEASE] ( [PROPERTY_LEASE_ID] BIGINT NOT NULL CONSTRAINT PROPLS_PROPERTY_LEASE_ID_DEF DEFAULT (NEXT VALUE FOR PIMS_PROPERTY_LEASE_ID_SEQ), [PROPERTY_ID] BIGINT NOT NULL, [LEASE_ID] BIGINT NOT NULL, [CONCURRENCY_CONTROL_NUMBER] BIGINT NOT NULL CONSTRAINT PROPLS_CONCURRENCY_CONTROL_NUMBER_DEF DEFAULT CAST(1 AS BIGINT), [APP_CREATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT PROPLS_APP_CREATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_CREATE_USERID] nvarchar(30) NOT NULL, [APP_CREATE_USER_GUID] uniqueidentifier NULL, [APP_CREATE_USER_DIRECTORY] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL CONSTRAINT PROPLS_APP_LAST_UPDATE_TIMESTAMP_DEF DEFAULT (GETUTCDATE()), [APP_LAST_UPDATE_USERID] nvarchar(30) NOT NULL, [APP_LAST_UPDATE_USER_GUID] uniqueidentifier NULL, [APP_LAST_UPDATE_USER_DIRECTORY] nvarchar(30) NOT NULL, CONSTRAINT [PROPLS_PK] PRIMARY KEY ([PROPERTY_LEASE_ID]), CONSTRAINT [PIM_LEASE_PIM_PROPLS_FK] FOREIGN KEY ([LEASE_ID]) REFERENCES [PIMS_LEASE] ([LEASE_ID]) ON DELETE NO ACTION, CONSTRAINT [PIM_PRPRTY_PIM_PROPLS_FK] FOREIGN KEY ([PROPERTY_ID]) REFERENCES [PIMS_PROPERTY] ([PROPERTY_ID]) ON DELETE NO ACTION ); DECLARE @defaultSchema AS sysname; SET @defaultSchema = SCHEMA_NAME(); DECLARE @description AS sql_variant; SET @description = N'Auto-sequenced unique key value'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'PROPERTY_LEASE_ID'; SET @description = N'Foreign key to property'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'PROPERTY_ID'; SET @description = N'Foreign key to lease'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'LEASE_ID'; SET @description = N'Concurrency control number'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'CONCURRENCY_CONTROL_NUMBER'; SET @description = N'When this record was created'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_CREATE_TIMESTAMP'; SET @description = N'Reference to the username who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_CREATE_USERID'; SET @description = N'Reference to the user uid who created this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_CREATE_USER_GUID'; SET @description = N'Reference to the user directory who created this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_CREATE_USER_DIRECTORY'; SET @description = N'When this record was last updated'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_LAST_UPDATE_TIMESTAMP'; SET @description = N'Reference to the user who last updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USERID'; SET @description = N'Reference to the user uid who updated this record'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USER_GUID'; SET @description = N'Reference to the user directory who updated this record [IDIR, BCeID]'; EXEC sp_addextendedproperty 'MS_Description', @description, 'SCHEMA', @defaultSchema, 'TABLE', N'PIMS_PROPERTY_LEASE', 'COLUMN', N'APP_LAST_UPDATE_USER_DIRECTORY'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [EXPAMT_LEASE_ACTIVITY_PERIOD_ID_IDX] ON [PIMS_EXPECTED_AMOUNT] ([LEASE_ACTIVITY_PERIOD_ID]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [EXPAMT_LEASE_ACTIVITY_PERIOD_ID_IDX] ON [PIMS_EXPECTED_AMOUNT] ([LEASE_ACTIVITY_PERIOD_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [EXPAMT_LEASE_ID_IDX] ON [PIMS_EXPECTED_AMOUNT] ([LEASE_ID]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [EXPAMT_LEASE_ID_IDX] ON [PIMS_EXPECTED_AMOUNT] ([LEASE_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_PMT_FREQ_TYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_PMT_FREQ_TYPE_CODE]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_PMT_FREQ_TYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_PMT_FREQ_TYPE_CODE]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_PROGRAM_TYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_PROGRAM_TYPE_CODE]); Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_PROGRAM_TYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_PROGRAM_TYPE_CODE]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_PURPOSE_SUBTYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_PURPOSE_SUBTYPE_CODE]); Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_PURPOSE_SUBTYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_PURPOSE_SUBTYPE_CODE]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_PURPOSE_TYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_PURPOSE_TYPE_CODE]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_PURPOSE_TYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_PURPOSE_TYPE_CODE]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_STATUS_TYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_STATUS_TYPE_CODE]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_LEASE_STATUS_TYPE_CODE_IDX] ON [PIMS_LEASE] ([LEASE_STATUS_TYPE_CODE]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_PROP_MGMT_ORG_ID_IDX] ON [PIMS_LEASE] ([PROP_MGMT_ORG_ID]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_PROP_MGMT_ORG_ID_IDX] ON [PIMS_LEASE] ([PROP_MGMT_ORG_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_PROPERTY_MANAGER_ID_IDX] ON [PIMS_LEASE] ([PROPERTY_MANAGER_ID]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_PROPERTY_MANAGER_ID_IDX] ON [PIMS_LEASE] ([PROPERTY_MANAGER_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_TENANT_ID_IDX] ON [PIMS_LEASE] ([TENANT_ID]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LEASE_TENANT_ID_IDX] ON [PIMS_LEASE] ([TENANT_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LSACTV_LEASE_ACTIVITY_PERIOD_ID_IDX] ON [PIMS_LEASE_ACTIVITY] ([LEASE_ACTIVITY_PERIOD_ID]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LSACTV_LEASE_ACTIVITY_PERIOD_ID_IDX] ON [PIMS_LEASE_ACTIVITY] ([LEASE_ACTIVITY_PERIOD_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LSEACT_LEASE_ID_IDX] ON [PIMS_LEASE_ACTIVITY] ([LEASE_ID]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LSEACT_LEASE_ID_IDX] ON [PIMS_LEASE_ACTIVITY] ([LEASE_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LSEACT_LEASE_SUBTYPE_CODE_ID_IDX] ON [PIMS_LEASE_ACTIVITY] ([LEASE_SUBTYPE_CODE]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LSEACT_LEASE_SUBTYPE_CODE_ID_IDX] ON [PIMS_LEASE_ACTIVITY] ([LEASE_SUBTYPE_CODE]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LSEACT_LEASE_TYPE_CODE_ID_IDX] ON [PIMS_LEASE_ACTIVITY] ([LEASE_TYPE_CODE]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [LSEACT_LEASE_TYPE_CODE_ID_IDX] ON [PIMS_LEASE_ACTIVITY] ([LEASE_TYPE_CODE]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [PROPLS_LEASE_ID_IDX] ON [PIMS_PROPERTY_LEASE] ([LEASE_ID]); Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [PROPLS_LEASE_ID_IDX] ON [PIMS_PROPERTY_LEASE] ([LEASE_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [PROPLS_PROPERTY_ID_IDX] ON [PIMS_PROPERTY_LEASE] ([PROPERTY_ID]); Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE INDEX [PROPLS_PROPERTY_ID_IDX] ON [PIMS_PROPERTY_LEASE] ([PROPERTY_ID]); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'PostUp Scripts' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'PostUp Scripts' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\00-DbAuditColumns.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\00-DbAuditColumns.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Adding DB Audit Columns' ALTER TABLE dbo.[PIMS_LEASE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_PROPERTY_LEASE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_EXPECTED_AMOUNT] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_ACTIVITY_PERIOD] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_ACTIVITY] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_SUBTYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_PURPOSE_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_PURPOSE_SUBTYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_STATUS_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_PMT_FREQ_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_PROGRAM_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() Executed DbCommand (27ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Adding DB Audit Columns' ALTER TABLE dbo.[PIMS_LEASE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_PROPERTY_LEASE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_EXPECTED_AMOUNT] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_ACTIVITY_PERIOD] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_ACTIVITY] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_SUBTYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_PURPOSE_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_PURPOSE_SUBTYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_STATUS_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_PMT_FREQ_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() ALTER TABLE dbo.[PIMS_LEASE_PROGRAM_TYPE] ADD [DB_CREATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_CREATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() , [DB_LAST_UPDATE_TIMESTAMP] DATETIME NOT NULL DEFAULT GETUTCDATE() , [DB_LAST_UPDATE_USERID] NVARCHAR(30) NOT NULL DEFAULT user_name() Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeasePaymentFrequencyType.sql' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeasePaymentFrequencyType.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_PMT_FREQ_TYPE]' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_PMT_FREQ_TYPE]' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_PMT_FREQ_TYPE (LEASE_PMT_FREQ_TYPE_CODE, DESCRIPTION) VALUES (N'NOMINAL', N'Nominal'), (N'MONTHLY', N'Monthly'), (N'PREPAID', N'Prepaid'), (N'ANNUAL', N'Annual'); Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_PMT_FREQ_TYPE (LEASE_PMT_FREQ_TYPE_CODE, DESCRIPTION) VALUES (N'NOMINAL', N'Nominal'), (N'MONTHLY', N'Monthly'), (N'PREPAID', N'Prepaid'), (N'ANNUAL', N'Annual'); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeaseProgramType.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeaseProgramType.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_PROGRAM_TYPE]' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_PROGRAM_TYPE]' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_PROGRAM_TYPE (LEASE_PROGRAM_TYPE_CODE, DESCRIPTION) VALUES (N'BCFERRIES', N'BC Ferries'), (N'BCTRANSIT', N'BC Transit'), (N'BELLETERM', N'Belleville Terminal'), (N'COMMBLDG', N'Commercial Buildings'), (N'LCLGOVT', N'Local Government/RCMP'), (N'OTHER', N'Other Licencing'), (N'RAILTRAIL', N'Rail Trails'), (N'RESRENTAL', N'Residential Rentals'), (N'TMEP', N'TMEP'), (N'TRANSLINK', N'TransLink'), (N'UTILITY', N'Utilities'); Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_PROGRAM_TYPE (LEASE_PROGRAM_TYPE_CODE, DESCRIPTION) VALUES (N'BCFERRIES', N'BC Ferries'), (N'BCTRANSIT', N'BC Transit'), (N'BELLETERM', N'Belleville Terminal'), (N'COMMBLDG', N'Commercial Buildings'), (N'LCLGOVT', N'Local Government/RCMP'), (N'OTHER', N'Other Licencing'), (N'RAILTRAIL', N'Rail Trails'), (N'RESRENTAL', N'Residential Rentals'), (N'TMEP', N'TMEP'), (N'TRANSLINK', N'TransLink'), (N'UTILITY', N'Utilities'); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeasePurposeSubtype.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeasePurposeSubtype.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_PURPOSE_SUBTYPE]' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_PURPOSE_SUBTYPE]' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_PURPOSE_SUBTYPE (LEASE_PURPOSE_SUBTYPE_CODE, DESCRIPTION) VALUES (1, N'Parking Lot'), (2, N'Ferry Terminal'), (3, N'Trail'), (4, N'Park'), (5, N'Weigh Scale'), (6, N'Railway'), (7, N'Agriculture'), (8, N'Grazing'), (9, N'Utilities'), (10, N'Storage'), (11, N'Access'), (12, N'Community'), (13, N'Transmission Sites'), (14, N'Landscaping'), (15, N'Encroachment'), (16, N'Others'), (17, N'Retail'), (18, N'Billboard'), (19, N'Apartment'), (20, N'Oil and Gas'), (21, N'Oil and Gas'), (22, N'Overhead Construction Crane permit'), (23, N'Overhead Crane permit'), (24, N'Public Building - Firehall'), (25, N'Relocation - Office'), (26, N'Park N Ride'), (27, N'Hwy Maintenance Yard'); Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_PURPOSE_SUBTYPE (LEASE_PURPOSE_SUBTYPE_CODE, DESCRIPTION) VALUES (1, N'Parking Lot'), (2, N'Ferry Terminal'), (3, N'Trail'), (4, N'Park'), (5, N'Weigh Scale'), (6, N'Railway'), (7, N'Agriculture'), (8, N'Grazing'), (9, N'Utilities'), (10, N'Storage'), (11, N'Access'), (12, N'Community'), (13, N'Transmission Sites'), (14, N'Landscaping'), (15, N'Encroachment'), (16, N'Others'), (17, N'Retail'), (18, N'Billboard'), (19, N'Apartment'), (20, N'Oil and Gas'), (21, N'Oil and Gas'), (22, N'Overhead Construction Crane permit'), (23, N'Overhead Crane permit'), (24, N'Public Building - Firehall'), (25, N'Relocation - Office'), (26, N'Park N Ride'), (27, N'Hwy Maintenance Yard'); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeasePurposeType.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeasePurposeType.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_PURPOSE_TYPE]' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_PURPOSE_TYPE]' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_PURPOSE_TYPE (LEASE_PURPOSE_TYPE_CODE, DESCRIPTION) VALUES (1, N'Residential'), (2, N'Commercial'), (3, N'Industrial'), (4, N'Nominal'); Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_PURPOSE_TYPE (LEASE_PURPOSE_TYPE_CODE, DESCRIPTION) VALUES (1, N'Residential'), (2, N'Commercial'), (3, N'Industrial'), (4, N'Nominal'); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeaseStatusType.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeaseStatusType.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_STATUS_TYPE]' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_STATUS_TYPE]' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_STATUS_TYPE (LEASE_STATUS_TYPE_CODE, DESCRIPTION) VALUES (N'I', N'Unknown'), (N'L', N'Unknown'), (N'LI', N'Unknown'), (N'R', N'Unknown'), (N'RW', N'Unknown'), (N'U', N'Unknown'), (N'V', N'Unknown'); Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_STATUS_TYPE (LEASE_STATUS_TYPE_CODE, DESCRIPTION) VALUES (N'I', N'Unknown'), (N'L', N'Unknown'), (N'LI', N'Unknown'), (N'R', N'Unknown'), (N'RW', N'Unknown'), (N'U', N'Unknown'), (N'V', N'Unknown'); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeaseSubtype.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeaseSubtype.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_SUBTYPE]' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_SUBTYPE]' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_SUBTYPE (LEASE_SUBTYPE_CODE, DESCRIPTION) VALUES (N'E', N'Expense'), (N'R', N'Revenue'); Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_SUBTYPE (LEASE_SUBTYPE_CODE, DESCRIPTION) VALUES (N'E', N'Expense'), (N'R', N'Revenue'); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeaseType.sql' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\02-LeaseType.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_TYPE]' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Inserting [PIMS_LEASE_TYPE]' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_TYPE (LEASE_TYPE_CODE, DESCRIPTION) VALUES (5100, N'Marketing Fee'), (5120, N'Advertising'), (5140, N'Cleaning'), (5160, N'Security'), (5180, N'BC Hydro'), (5200, N'Landscaping'), (5220, N'BC Gas'), (5240, N'Carpentry'), (5260, N'Legal'), (5280, N'Maintenance'), (5300, N'Management'), (5320, N'Miscellaneous'), (5340, N'Painting'), (5360, N'Plumbing/Heating'), (5380, N'Legal Survey'), (5390, N'Report/Consulting Fee'), (5400, N'Property Purchase Tax'), (5420, N'Commission Fee'), (5440, N'Level 1 Assessment'), (5460, N'Property Taxes'), (5500, N'Rubbish Removal'), (5520, N'Water/Sewer'), (6100, N'Security Deposit'), (6120, N'Rental/Lease Revenue'), (6140, N'Other Income'); Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO PIMS_LEASE_TYPE (LEASE_TYPE_CODE, DESCRIPTION) VALUES (5100, N'Marketing Fee'), (5120, N'Advertising'), (5140, N'Cleaning'), (5160, N'Security'), (5180, N'BC Hydro'), (5200, N'Landscaping'), (5220, N'BC Gas'), (5240, N'Carpentry'), (5260, N'Legal'), (5280, N'Maintenance'), (5300, N'Management'), (5320, N'Miscellaneous'), (5340, N'Painting'), (5360, N'Plumbing/Heating'), (5380, N'Legal Survey'), (5390, N'Report/Consulting Fee'), (5400, N'Property Purchase Tax'), (5420, N'Commission Fee'), (5440, N'Level 1 Assessment'), (5460, N'Property Taxes'), (5500, N'Rubbish Removal'), (5520, N'Water/Sewer'), (6100, N'Security Deposit'), (6120, N'Rental/Lease Revenue'), (6140, N'Other Income'); Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\99-Triggers.sql' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'---------------> C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.10.0\Up\PostUp\99-Triggers.sql' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Add Triggers' Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Add Triggers' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRTY_I_S_I_TR] ON PIMS_LEASE_PURPOSE_TYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_PURPOSE_TYPE ("LEASE_PURPOSE_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_PURPOSE_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRTY_I_S_I_TR] ON PIMS_LEASE_PURPOSE_TYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_PURPOSE_TYPE ("LEASE_PURPOSE_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_PURPOSE_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSTYPE_I_S_U_TR] ON PIMS_LEASE_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_TYPE_CODE = deleted.LEASE_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_TYPE set "LEASE_TYPE_CODE" = inserted."LEASE_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_TYPE inner join inserted on (PIMS_LEASE_TYPE.LEASE_TYPE_CODE = inserted.LEASE_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSTYPE_I_S_U_TR] ON PIMS_LEASE_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_TYPE_CODE = deleted.LEASE_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_TYPE set "LEASE_TYPE_CODE" = inserted."LEASE_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_TYPE inner join inserted on (PIMS_LEASE_TYPE.LEASE_TYPE_CODE = inserted.LEASE_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRGT_I_S_U_TR] ON PIMS_LEASE_PROGRAM_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_PROGRAM_TYPE_CODE = deleted.LEASE_PROGRAM_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_PROGRAM_TYPE set "LEASE_PROGRAM_TYPE_CODE" = inserted."LEASE_PROGRAM_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_PROGRAM_TYPE inner join inserted on (PIMS_LEASE_PROGRAM_TYPE.LEASE_PROGRAM_TYPE_CODE = inserted.LEASE_PROGRAM_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRGT_I_S_U_TR] ON PIMS_LEASE_PROGRAM_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_PROGRAM_TYPE_CODE = deleted.LEASE_PROGRAM_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_PROGRAM_TYPE set "LEASE_PROGRAM_TYPE_CODE" = inserted."LEASE_PROGRAM_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_PROGRAM_TYPE inner join inserted on (PIMS_LEASE_PROGRAM_TYPE.LEASE_PROGRAM_TYPE_CODE = inserted.LEASE_PROGRAM_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPMTF_I_S_I_TR] ON PIMS_LEASE_PMT_FREQ_TYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_PMT_FREQ_TYPE ("LEASE_PMT_FREQ_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_PMT_FREQ_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPMTF_I_S_I_TR] ON PIMS_LEASE_PMT_FREQ_TYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_PMT_FREQ_TYPE ("LEASE_PMT_FREQ_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_PMT_FREQ_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSTYPE_I_S_I_TR] ON PIMS_LEASE_TYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_TYPE ("LEASE_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSTYPE_I_S_I_TR] ON PIMS_LEASE_TYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_TYPE ("LEASE_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACTV_I_S_I_TR] ON PIMS_LEASE_ACTIVITY INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_ACTIVITY ("LEASE_ACTIVITY_ID", "LEASE_ID", "LEASE_TYPE_CODE", "LEASE_SUBTYPE_CODE", "LEASE_ACTIVITY_PERIOD_ID", "AMOUNT", "ACTIVITY_DATE", "COMMENT", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "LEASE_ACTIVITY_ID", "LEASE_ID", "LEASE_TYPE_CODE", "LEASE_SUBTYPE_CODE", "LEASE_ACTIVITY_PERIOD_ID", "AMOUNT", "ACTIVITY_DATE", "COMMENT", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACTV_I_S_I_TR] ON PIMS_LEASE_ACTIVITY INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_ACTIVITY ("LEASE_ACTIVITY_ID", "LEASE_ID", "LEASE_TYPE_CODE", "LEASE_SUBTYPE_CODE", "LEASE_ACTIVITY_PERIOD_ID", "AMOUNT", "ACTIVITY_DATE", "COMMENT", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "LEASE_ACTIVITY_ID", "LEASE_ID", "LEASE_TYPE_CODE", "LEASE_SUBTYPE_CODE", "LEASE_ACTIVITY_PERIOD_ID", "AMOUNT", "ACTIVITY_DATE", "COMMENT", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRTY_I_S_U_TR] ON PIMS_LEASE_PURPOSE_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_PURPOSE_TYPE_CODE = deleted.LEASE_PURPOSE_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_PURPOSE_TYPE set "LEASE_PURPOSE_TYPE_CODE" = inserted."LEASE_PURPOSE_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_PURPOSE_TYPE inner join inserted on (PIMS_LEASE_PURPOSE_TYPE.LEASE_PURPOSE_TYPE_CODE = inserted.LEASE_PURPOSE_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRTY_I_S_U_TR] ON PIMS_LEASE_PURPOSE_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_PURPOSE_TYPE_CODE = deleted.LEASE_PURPOSE_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_PURPOSE_TYPE set "LEASE_PURPOSE_TYPE_CODE" = inserted."LEASE_PURPOSE_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_PURPOSE_TYPE inner join inserted on (PIMS_LEASE_PURPOSE_TYPE.LEASE_PURPOSE_TYPE_CODE = inserted.LEASE_PURPOSE_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPMTF_I_S_U_TR] ON PIMS_LEASE_PMT_FREQ_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_PMT_FREQ_TYPE_CODE = deleted.LEASE_PMT_FREQ_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_PMT_FREQ_TYPE set "LEASE_PMT_FREQ_TYPE_CODE" = inserted."LEASE_PMT_FREQ_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_PMT_FREQ_TYPE inner join inserted on (PIMS_LEASE_PMT_FREQ_TYPE.LEASE_PMT_FREQ_TYPE_CODE = inserted.LEASE_PMT_FREQ_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPMTF_I_S_U_TR] ON PIMS_LEASE_PMT_FREQ_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_PMT_FREQ_TYPE_CODE = deleted.LEASE_PMT_FREQ_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_PMT_FREQ_TYPE set "LEASE_PMT_FREQ_TYPE_CODE" = inserted."LEASE_PMT_FREQ_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_PMT_FREQ_TYPE inner join inserted on (PIMS_LEASE_PMT_FREQ_TYPE.LEASE_PMT_FREQ_TYPE_CODE = inserted.LEASE_PMT_FREQ_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_EXPAMT_I_S_U_TR] ON PIMS_EXPECTED_AMOUNT INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.EXPECTED_AMOUNT_ID = deleted.EXPECTED_AMOUNT_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_EXPECTED_AMOUNT set "EXPECTED_AMOUNT_ID" = inserted."EXPECTED_AMOUNT_ID", "LEASE_ID" = inserted."LEASE_ID", "LEASE_ACTIVITY_PERIOD_ID" = inserted."LEASE_ACTIVITY_PERIOD_ID", "EXPECTED_AMOUNT" = inserted."EXPECTED_AMOUNT", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_EXPECTED_AMOUNT inner join inserted on (PIMS_EXPECTED_AMOUNT.EXPECTED_AMOUNT_ID = inserted.EXPECTED_AMOUNT_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_EXPAMT_I_S_U_TR] ON PIMS_EXPECTED_AMOUNT INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.EXPECTED_AMOUNT_ID = deleted.EXPECTED_AMOUNT_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_EXPECTED_AMOUNT set "EXPECTED_AMOUNT_ID" = inserted."EXPECTED_AMOUNT_ID", "LEASE_ID" = inserted."LEASE_ID", "LEASE_ACTIVITY_PERIOD_ID" = inserted."LEASE_ACTIVITY_PERIOD_ID", "EXPECTED_AMOUNT" = inserted."EXPECTED_AMOUNT", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_EXPECTED_AMOUNT inner join inserted on (PIMS_EXPECTED_AMOUNT.EXPECTED_AMOUNT_ID = inserted.EXPECTED_AMOUNT_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSSTYP_I_S_I_TR] ON PIMS_LEASE_SUBTYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_SUBTYPE ("LEASE_SUBTYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_SUBTYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSSTYP_I_S_I_TR] ON PIMS_LEASE_SUBTYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_SUBTYPE ("LEASE_SUBTYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_SUBTYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LEASE_A_S_IUD_TR] ON PIMS_LEASE FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_LEASE_HIST set END_DATE_HIST = @curr_date where LEASE_ID in (select LEASE_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_LEASE_HIST ([LEASE_ID], [PROP_MGMT_ORG_ID], [LEASE_PURPOSE_TYPE_CODE], [LEASE_PURPOSE_SUBTYPE_CODE], [LEASE_STATUS_TYPE_CODE], [LEASE_PMT_FREQ_TYPE_CODE], [LEASE_PROGRAM_TYPE_CODE], [PROPERTY_MANAGER_ID], [TENANT_ID], [L_FILE_NO], [TFA_FILE_NO], [PS_FILE_NO], [START_DATE], [RENEWAL_DATE], [EXPIRY_DATE], [LEASE_AMOUNT], [INSURANCE_START_DATE], [INSURANCE_END_DATE], [SECURITY_START_DATE], [SECURITY_END_DATE], [INSPECTION_DATE], [INSPECTION_NOTES], [LEASE_NOTES], [UNIT], [EXPIRED], [HAS_PHYSICAL_FILE], [HAS_DIGITAL_FILE], [HAS_PHYSICAL_LICENSE], [HAS_DIGITAL_LICENSE], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _LEASE_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [LEASE_ID], [PROP_MGMT_ORG_ID], [LEASE_PURPOSE_TYPE_CODE], [LEASE_PURPOSE_SUBTYPE_CODE], [LEASE_STATUS_TYPE_CODE], [LEASE_PMT_FREQ_TYPE_CODE], [LEASE_PROGRAM_TYPE_CODE], [PROPERTY_MANAGER_ID], [TENANT_ID], [L_FILE_NO], [TFA_FILE_NO], [PS_FILE_NO], [START_DATE], [RENEWAL_DATE], [EXPIRY_DATE], [LEASE_AMOUNT], [INSURANCE_START_DATE], [INSURANCE_END_DATE], [SECURITY_START_DATE], [SECURITY_END_DATE], [INSPECTION_DATE], [INSPECTION_NOTES], [LEASE_NOTES], [UNIT], [EXPIRED], [HAS_PHYSICAL_FILE], [HAS_DIGITAL_FILE], [HAS_PHYSICAL_LICENSE], [HAS_DIGITAL_LICENSE], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_LEASE_H_ID_SEQ]) as [_LEASE_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (10ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LEASE_A_S_IUD_TR] ON PIMS_LEASE FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_LEASE_HIST set END_DATE_HIST = @curr_date where LEASE_ID in (select LEASE_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_LEASE_HIST ([LEASE_ID], [PROP_MGMT_ORG_ID], [LEASE_PURPOSE_TYPE_CODE], [LEASE_PURPOSE_SUBTYPE_CODE], [LEASE_STATUS_TYPE_CODE], [LEASE_PMT_FREQ_TYPE_CODE], [LEASE_PROGRAM_TYPE_CODE], [PROPERTY_MANAGER_ID], [TENANT_ID], [L_FILE_NO], [TFA_FILE_NO], [PS_FILE_NO], [START_DATE], [RENEWAL_DATE], [EXPIRY_DATE], [LEASE_AMOUNT], [INSURANCE_START_DATE], [INSURANCE_END_DATE], [SECURITY_START_DATE], [SECURITY_END_DATE], [INSPECTION_DATE], [INSPECTION_NOTES], [LEASE_NOTES], [UNIT], [EXPIRED], [HAS_PHYSICAL_FILE], [HAS_DIGITAL_FILE], [HAS_PHYSICAL_LICENSE], [HAS_DIGITAL_LICENSE], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _LEASE_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [LEASE_ID], [PROP_MGMT_ORG_ID], [LEASE_PURPOSE_TYPE_CODE], [LEASE_PURPOSE_SUBTYPE_CODE], [LEASE_STATUS_TYPE_CODE], [LEASE_PMT_FREQ_TYPE_CODE], [LEASE_PROGRAM_TYPE_CODE], [PROPERTY_MANAGER_ID], [TENANT_ID], [L_FILE_NO], [TFA_FILE_NO], [PS_FILE_NO], [START_DATE], [RENEWAL_DATE], [EXPIRY_DATE], [LEASE_AMOUNT], [INSURANCE_START_DATE], [INSURANCE_END_DATE], [SECURITY_START_DATE], [SECURITY_END_DATE], [INSPECTION_DATE], [INSPECTION_NOTES], [LEASE_NOTES], [UNIT], [EXPIRED], [HAS_PHYSICAL_FILE], [HAS_DIGITAL_FILE], [HAS_PHYSICAL_LICENSE], [HAS_DIGITAL_LICENSE], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_LEASE_H_ID_SEQ]) as [_LEASE_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSSTYP_I_S_U_TR] ON PIMS_LEASE_SUBTYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_SUBTYPE_CODE = deleted.LEASE_SUBTYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_SUBTYPE set "LEASE_SUBTYPE_CODE" = inserted."LEASE_SUBTYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_SUBTYPE inner join inserted on (PIMS_LEASE_SUBTYPE.LEASE_SUBTYPE_CODE = inserted.LEASE_SUBTYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSSTYP_I_S_U_TR] ON PIMS_LEASE_SUBTYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_SUBTYPE_CODE = deleted.LEASE_SUBTYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_SUBTYPE set "LEASE_SUBTYPE_CODE" = inserted."LEASE_SUBTYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_SUBTYPE inner join inserted on (PIMS_LEASE_SUBTYPE.LEASE_SUBTYPE_CODE = inserted.LEASE_SUBTYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRST_I_S_I_TR] ON PIMS_LEASE_PURPOSE_SUBTYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_PURPOSE_SUBTYPE ("LEASE_PURPOSE_SUBTYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_PURPOSE_SUBTYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRST_I_S_I_TR] ON PIMS_LEASE_PURPOSE_SUBTYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_PURPOSE_SUBTYPE ("LEASE_PURPOSE_SUBTYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_PURPOSE_SUBTYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACPR_I_S_U_TR] ON PIMS_LEASE_ACTIVITY_PERIOD INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_ACTIVITY_PERIOD_ID = deleted.LEASE_ACTIVITY_PERIOD_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_ACTIVITY_PERIOD set "LEASE_ACTIVITY_PERIOD_ID" = inserted."LEASE_ACTIVITY_PERIOD_ID", "PERIOD_DATE" = inserted."PERIOD_DATE", "IS_CLOSED" = inserted."IS_CLOSED", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_ACTIVITY_PERIOD inner join inserted on (PIMS_LEASE_ACTIVITY_PERIOD.LEASE_ACTIVITY_PERIOD_ID = inserted.LEASE_ACTIVITY_PERIOD_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACPR_I_S_U_TR] ON PIMS_LEASE_ACTIVITY_PERIOD INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_ACTIVITY_PERIOD_ID = deleted.LEASE_ACTIVITY_PERIOD_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_ACTIVITY_PERIOD set "LEASE_ACTIVITY_PERIOD_ID" = inserted."LEASE_ACTIVITY_PERIOD_ID", "PERIOD_DATE" = inserted."PERIOD_DATE", "IS_CLOSED" = inserted."IS_CLOSED", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_ACTIVITY_PERIOD inner join inserted on (PIMS_LEASE_ACTIVITY_PERIOD.LEASE_ACTIVITY_PERIOD_ID = inserted.LEASE_ACTIVITY_PERIOD_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSSTSY_I_S_U_TR] ON PIMS_LEASE_STATUS_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_STATUS_TYPE_CODE = deleted.LEASE_STATUS_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_STATUS_TYPE set "LEASE_STATUS_TYPE_CODE" = inserted."LEASE_STATUS_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_STATUS_TYPE inner join inserted on (PIMS_LEASE_STATUS_TYPE.LEASE_STATUS_TYPE_CODE = inserted.LEASE_STATUS_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSSTSY_I_S_U_TR] ON PIMS_LEASE_STATUS_TYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_STATUS_TYPE_CODE = deleted.LEASE_STATUS_TYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_STATUS_TYPE set "LEASE_STATUS_TYPE_CODE" = inserted."LEASE_STATUS_TYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_STATUS_TYPE inner join inserted on (PIMS_LEASE_STATUS_TYPE.LEASE_STATUS_TYPE_CODE = inserted.LEASE_STATUS_TYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LEASE_I_S_U_TR] ON PIMS_LEASE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_ID = deleted.LEASE_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE set "LEASE_ID" = inserted."LEASE_ID", "PROP_MGMT_ORG_ID" = inserted."PROP_MGMT_ORG_ID", "LEASE_PURPOSE_TYPE_CODE" = inserted."LEASE_PURPOSE_TYPE_CODE", "LEASE_PURPOSE_SUBTYPE_CODE" = inserted."LEASE_PURPOSE_SUBTYPE_CODE", "LEASE_STATUS_TYPE_CODE" = inserted."LEASE_STATUS_TYPE_CODE", "LEASE_PMT_FREQ_TYPE_CODE" = inserted."LEASE_PMT_FREQ_TYPE_CODE", "LEASE_PROGRAM_TYPE_CODE" = inserted."LEASE_PROGRAM_TYPE_CODE", "PROPERTY_MANAGER_ID" = inserted."PROPERTY_MANAGER_ID", "TENANT_ID" = inserted."TENANT_ID", "L_FILE_NO" = inserted."L_FILE_NO", "TFA_FILE_NO" = inserted."TFA_FILE_NO", "PS_FILE_NO" = inserted."PS_FILE_NO", "START_DATE" = inserted."START_DATE", "RENEWAL_DATE" = inserted."RENEWAL_DATE", "EXPIRY_DATE" = inserted."EXPIRY_DATE", "LEASE_AMOUNT" = inserted."LEASE_AMOUNT", "INSURANCE_START_DATE" = inserted."INSURANCE_START_DATE", "INSURANCE_END_DATE" = inserted."INSURANCE_END_DATE", "SECURITY_START_DATE" = inserted."SECURITY_START_DATE", "SECURITY_END_DATE" = inserted."SECURITY_END_DATE", "INSPECTION_DATE" = inserted."INSPECTION_DATE", "INSPECTION_NOTES" = inserted."INSPECTION_NOTES", "LEASE_NOTES" = inserted."LEASE_NOTES", "UNIT" = inserted."UNIT", "EXPIRED" = inserted."EXPIRED", "HAS_PHYSICAL_FILE" = inserted."HAS_PHYSICAL_FILE", "HAS_DIGITAL_FILE" = inserted."HAS_DIGITAL_FILE", "HAS_PHYSICAL_LICENSE" = inserted."HAS_PHYSICAL_LICENSE", "HAS_DIGITAL_LICENSE" = inserted."HAS_DIGITAL_LICENSE", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE inner join inserted on (PIMS_LEASE.LEASE_ID = inserted.LEASE_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LEASE_I_S_U_TR] ON PIMS_LEASE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_ID = deleted.LEASE_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE set "LEASE_ID" = inserted."LEASE_ID", "PROP_MGMT_ORG_ID" = inserted."PROP_MGMT_ORG_ID", "LEASE_PURPOSE_TYPE_CODE" = inserted."LEASE_PURPOSE_TYPE_CODE", "LEASE_PURPOSE_SUBTYPE_CODE" = inserted."LEASE_PURPOSE_SUBTYPE_CODE", "LEASE_STATUS_TYPE_CODE" = inserted."LEASE_STATUS_TYPE_CODE", "LEASE_PMT_FREQ_TYPE_CODE" = inserted."LEASE_PMT_FREQ_TYPE_CODE", "LEASE_PROGRAM_TYPE_CODE" = inserted."LEASE_PROGRAM_TYPE_CODE", "PROPERTY_MANAGER_ID" = inserted."PROPERTY_MANAGER_ID", "TENANT_ID" = inserted."TENANT_ID", "L_FILE_NO" = inserted."L_FILE_NO", "TFA_FILE_NO" = inserted."TFA_FILE_NO", "PS_FILE_NO" = inserted."PS_FILE_NO", "START_DATE" = inserted."START_DATE", "RENEWAL_DATE" = inserted."RENEWAL_DATE", "EXPIRY_DATE" = inserted."EXPIRY_DATE", "LEASE_AMOUNT" = inserted."LEASE_AMOUNT", "INSURANCE_START_DATE" = inserted."INSURANCE_START_DATE", "INSURANCE_END_DATE" = inserted."INSURANCE_END_DATE", "SECURITY_START_DATE" = inserted."SECURITY_START_DATE", "SECURITY_END_DATE" = inserted."SECURITY_END_DATE", "INSPECTION_DATE" = inserted."INSPECTION_DATE", "INSPECTION_NOTES" = inserted."INSPECTION_NOTES", "LEASE_NOTES" = inserted."LEASE_NOTES", "UNIT" = inserted."UNIT", "EXPIRED" = inserted."EXPIRED", "HAS_PHYSICAL_FILE" = inserted."HAS_PHYSICAL_FILE", "HAS_DIGITAL_FILE" = inserted."HAS_DIGITAL_FILE", "HAS_PHYSICAL_LICENSE" = inserted."HAS_PHYSICAL_LICENSE", "HAS_DIGITAL_LICENSE" = inserted."HAS_DIGITAL_LICENSE", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE inner join inserted on (PIMS_LEASE.LEASE_ID = inserted.LEASE_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRST_I_S_U_TR] ON PIMS_LEASE_PURPOSE_SUBTYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_PURPOSE_SUBTYPE_CODE = deleted.LEASE_PURPOSE_SUBTYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_PURPOSE_SUBTYPE set "LEASE_PURPOSE_SUBTYPE_CODE" = inserted."LEASE_PURPOSE_SUBTYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_PURPOSE_SUBTYPE inner join inserted on (PIMS_LEASE_PURPOSE_SUBTYPE.LEASE_PURPOSE_SUBTYPE_CODE = inserted.LEASE_PURPOSE_SUBTYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSPRST_I_S_U_TR] ON PIMS_LEASE_PURPOSE_SUBTYPE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_PURPOSE_SUBTYPE_CODE = deleted.LEASE_PURPOSE_SUBTYPE_CODE) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_PURPOSE_SUBTYPE set "LEASE_PURPOSE_SUBTYPE_CODE" = inserted."LEASE_PURPOSE_SUBTYPE_CODE", "DESCRIPTION" = inserted."DESCRIPTION", "IS_DISABLED" = inserted."IS_DISABLED", "DISPLAY_ORDER" = inserted."DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_PURPOSE_SUBTYPE inner join inserted on (PIMS_LEASE_PURPOSE_SUBTYPE.LEASE_PURPOSE_SUBTYPE_CODE = inserted.LEASE_PURPOSE_SUBTYPE_CODE); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_EXPAMT_I_S_I_TR] ON PIMS_EXPECTED_AMOUNT INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_EXPECTED_AMOUNT ("EXPECTED_AMOUNT_ID", "LEASE_ID", "LEASE_ACTIVITY_PERIOD_ID", "EXPECTED_AMOUNT", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "EXPECTED_AMOUNT_ID", "LEASE_ID", "LEASE_ACTIVITY_PERIOD_ID", "EXPECTED_AMOUNT", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_EXPAMT_I_S_I_TR] ON PIMS_EXPECTED_AMOUNT INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_EXPECTED_AMOUNT ("EXPECTED_AMOUNT_ID", "LEASE_ID", "LEASE_ACTIVITY_PERIOD_ID", "EXPECTED_AMOUNT", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "EXPECTED_AMOUNT_ID", "LEASE_ID", "LEASE_ACTIVITY_PERIOD_ID", "EXPECTED_AMOUNT", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LEASE_I_S_I_TR] ON PIMS_LEASE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE ("LEASE_ID", "PROP_MGMT_ORG_ID", "LEASE_PURPOSE_TYPE_CODE", "LEASE_PURPOSE_SUBTYPE_CODE", "LEASE_STATUS_TYPE_CODE", "LEASE_PMT_FREQ_TYPE_CODE", "LEASE_PROGRAM_TYPE_CODE", "PROPERTY_MANAGER_ID", "TENANT_ID", "L_FILE_NO", "TFA_FILE_NO", "PS_FILE_NO", "START_DATE", "RENEWAL_DATE", "EXPIRY_DATE", "LEASE_AMOUNT", "INSURANCE_START_DATE", "INSURANCE_END_DATE", "SECURITY_START_DATE", "SECURITY_END_DATE", "INSPECTION_DATE", "INSPECTION_NOTES", "LEASE_NOTES", "UNIT", "EXPIRED", "HAS_PHYSICAL_FILE", "HAS_DIGITAL_FILE", "HAS_PHYSICAL_LICENSE", "HAS_DIGITAL_LICENSE", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "LEASE_ID", "PROP_MGMT_ORG_ID", "LEASE_PURPOSE_TYPE_CODE", "LEASE_PURPOSE_SUBTYPE_CODE", "LEASE_STATUS_TYPE_CODE", "LEASE_PMT_FREQ_TYPE_CODE", "LEASE_PROGRAM_TYPE_CODE", "PROPERTY_MANAGER_ID", "TENANT_ID", "L_FILE_NO", "TFA_FILE_NO", "PS_FILE_NO", "START_DATE", "RENEWAL_DATE", "EXPIRY_DATE", "LEASE_AMOUNT", "INSURANCE_START_DATE", "INSURANCE_END_DATE", "SECURITY_START_DATE", "SECURITY_END_DATE", "INSPECTION_DATE", "INSPECTION_NOTES", "LEASE_NOTES", "UNIT", "EXPIRED", "HAS_PHYSICAL_FILE", "HAS_DIGITAL_FILE", "HAS_PHYSICAL_LICENSE", "HAS_DIGITAL_LICENSE", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LEASE_I_S_I_TR] ON PIMS_LEASE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE ("LEASE_ID", "PROP_MGMT_ORG_ID", "LEASE_PURPOSE_TYPE_CODE", "LEASE_PURPOSE_SUBTYPE_CODE", "LEASE_STATUS_TYPE_CODE", "LEASE_PMT_FREQ_TYPE_CODE", "LEASE_PROGRAM_TYPE_CODE", "PROPERTY_MANAGER_ID", "TENANT_ID", "L_FILE_NO", "TFA_FILE_NO", "PS_FILE_NO", "START_DATE", "RENEWAL_DATE", "EXPIRY_DATE", "LEASE_AMOUNT", "INSURANCE_START_DATE", "INSURANCE_END_DATE", "SECURITY_START_DATE", "SECURITY_END_DATE", "INSPECTION_DATE", "INSPECTION_NOTES", "LEASE_NOTES", "UNIT", "EXPIRED", "HAS_PHYSICAL_FILE", "HAS_DIGITAL_FILE", "HAS_PHYSICAL_LICENSE", "HAS_DIGITAL_LICENSE", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "LEASE_ID", "PROP_MGMT_ORG_ID", "LEASE_PURPOSE_TYPE_CODE", "LEASE_PURPOSE_SUBTYPE_CODE", "LEASE_STATUS_TYPE_CODE", "LEASE_PMT_FREQ_TYPE_CODE", "LEASE_PROGRAM_TYPE_CODE", "PROPERTY_MANAGER_ID", "TENANT_ID", "L_FILE_NO", "TFA_FILE_NO", "PS_FILE_NO", "START_DATE", "RENEWAL_DATE", "EXPIRY_DATE", "LEASE_AMOUNT", "INSURANCE_START_DATE", "INSURANCE_END_DATE", "SECURITY_START_DATE", "SECURITY_END_DATE", "INSPECTION_DATE", "INSPECTION_NOTES", "LEASE_NOTES", "UNIT", "EXPIRED", "HAS_PHYSICAL_FILE", "HAS_DIGITAL_FILE", "HAS_PHYSICAL_LICENSE", "HAS_DIGITAL_LICENSE", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_PROPLS_A_S_IUD_TR] ON PIMS_PROPERTY_LEASE FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_PROPERTY_LEASE_HIST set END_DATE_HIST = @curr_date where PROPERTY_LEASE_ID in (select PROPERTY_LEASE_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_PROPERTY_LEASE_HIST ([PROPERTY_LEASE_ID], [PROPERTY_ID], [LEASE_ID], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _PROPERTY_LEASE_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [PROPERTY_LEASE_ID], [PROPERTY_ID], [LEASE_ID], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_PROPERTY_LEASE_H_ID_SEQ]) as [_PROPERTY_LEASE_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_PROPLS_A_S_IUD_TR] ON PIMS_PROPERTY_LEASE FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_PROPERTY_LEASE_HIST set END_DATE_HIST = @curr_date where PROPERTY_LEASE_ID in (select PROPERTY_LEASE_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_PROPERTY_LEASE_HIST ([PROPERTY_LEASE_ID], [PROPERTY_ID], [LEASE_ID], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _PROPERTY_LEASE_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [PROPERTY_LEASE_ID], [PROPERTY_ID], [LEASE_ID], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_PROPERTY_LEASE_H_ID_SEQ]) as [_PROPERTY_LEASE_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACPR_I_S_I_TR] ON PIMS_LEASE_ACTIVITY_PERIOD INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_ACTIVITY_PERIOD ("LEASE_ACTIVITY_PERIOD_ID", "PERIOD_DATE", "IS_CLOSED", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "LEASE_ACTIVITY_PERIOD_ID", "PERIOD_DATE", "IS_CLOSED", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACPR_I_S_I_TR] ON PIMS_LEASE_ACTIVITY_PERIOD INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_ACTIVITY_PERIOD ("LEASE_ACTIVITY_PERIOD_ID", "PERIOD_DATE", "IS_CLOSED", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "LEASE_ACTIVITY_PERIOD_ID", "PERIOD_DATE", "IS_CLOSED", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_PROPLS_I_S_I_TR] ON PIMS_PROPERTY_LEASE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_PROPERTY_LEASE ("PROPERTY_LEASE_ID", "PROPERTY_ID", "LEASE_ID", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "PROPERTY_LEASE_ID", "PROPERTY_ID", "LEASE_ID", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_PROPLS_I_S_I_TR] ON PIMS_PROPERTY_LEASE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_PROPERTY_LEASE ("PROPERTY_LEASE_ID", "PROPERTY_ID", "LEASE_ID", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY") select "PROPERTY_LEASE_ID", "PROPERTY_ID", "LEASE_ID", "CONCURRENCY_CONTROL_NUMBER", "APP_CREATE_TIMESTAMP", "APP_CREATE_USERID", "APP_CREATE_USER_GUID", "APP_CREATE_USER_DIRECTORY", "APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACTV_I_S_U_TR] ON PIMS_LEASE_ACTIVITY INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_ACTIVITY_ID = deleted.LEASE_ACTIVITY_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_ACTIVITY set "LEASE_ACTIVITY_ID" = inserted."LEASE_ACTIVITY_ID", "LEASE_ID" = inserted."LEASE_ID", "LEASE_TYPE_CODE" = inserted."LEASE_TYPE_CODE", "LEASE_SUBTYPE_CODE" = inserted."LEASE_SUBTYPE_CODE", "LEASE_ACTIVITY_PERIOD_ID" = inserted."LEASE_ACTIVITY_PERIOD_ID", "AMOUNT" = inserted."AMOUNT", "ACTIVITY_DATE" = inserted."ACTIVITY_DATE", "COMMENT" = inserted."COMMENT", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_ACTIVITY inner join inserted on (PIMS_LEASE_ACTIVITY.LEASE_ACTIVITY_ID = inserted.LEASE_ACTIVITY_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACTV_I_S_U_TR] ON PIMS_LEASE_ACTIVITY INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.LEASE_ACTIVITY_ID = deleted.LEASE_ACTIVITY_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_LEASE_ACTIVITY set "LEASE_ACTIVITY_ID" = inserted."LEASE_ACTIVITY_ID", "LEASE_ID" = inserted."LEASE_ID", "LEASE_TYPE_CODE" = inserted."LEASE_TYPE_CODE", "LEASE_SUBTYPE_CODE" = inserted."LEASE_SUBTYPE_CODE", "LEASE_ACTIVITY_PERIOD_ID" = inserted."LEASE_ACTIVITY_PERIOD_ID", "AMOUNT" = inserted."AMOUNT", "ACTIVITY_DATE" = inserted."ACTIVITY_DATE", "COMMENT" = inserted."COMMENT", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_LEASE_ACTIVITY inner join inserted on (PIMS_LEASE_ACTIVITY.LEASE_ACTIVITY_ID = inserted.LEASE_ACTIVITY_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_PROPLS_I_S_U_TR] ON PIMS_PROPERTY_LEASE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.PROPERTY_LEASE_ID = deleted.PROPERTY_LEASE_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_PROPERTY_LEASE set "PROPERTY_LEASE_ID" = inserted."PROPERTY_LEASE_ID", "PROPERTY_ID" = inserted."PROPERTY_ID", "LEASE_ID" = inserted."LEASE_ID", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_PROPERTY_LEASE inner join inserted on (PIMS_PROPERTY_LEASE.PROPERTY_LEASE_ID = inserted.PROPERTY_LEASE_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_PROPLS_I_S_U_TR] ON PIMS_PROPERTY_LEASE INSTEAD OF UPDATE AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM deleted) RETURN; -- validate concurrency control if exists (select 1 from inserted, deleted where inserted.CONCURRENCY_CONTROL_NUMBER != deleted.CONCURRENCY_CONTROL_NUMBER+1 AND inserted.PROPERTY_LEASE_ID = deleted.PROPERTY_LEASE_ID) raiserror('CONCURRENCY FAILURE.',16,1) -- update statement update PIMS_PROPERTY_LEASE set "PROPERTY_LEASE_ID" = inserted."PROPERTY_LEASE_ID", "PROPERTY_ID" = inserted."PROPERTY_ID", "LEASE_ID" = inserted."LEASE_ID", "CONCURRENCY_CONTROL_NUMBER" = inserted."CONCURRENCY_CONTROL_NUMBER", "APP_LAST_UPDATE_TIMESTAMP" = inserted."APP_LAST_UPDATE_TIMESTAMP", "APP_LAST_UPDATE_USERID" = inserted."APP_LAST_UPDATE_USERID", "APP_LAST_UPDATE_USER_GUID" = inserted."APP_LAST_UPDATE_USER_GUID", "APP_LAST_UPDATE_USER_DIRECTORY" = inserted."APP_LAST_UPDATE_USER_DIRECTORY" , DB_LAST_UPDATE_TIMESTAMP = getutcdate() , DB_LAST_UPDATE_USERID = user_name() from PIMS_PROPERTY_LEASE inner join inserted on (PIMS_PROPERTY_LEASE.PROPERTY_LEASE_ID = inserted.PROPERTY_LEASE_ID); END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSSTSY_I_S_I_TR] ON PIMS_LEASE_STATUS_TYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_STATUS_TYPE ("LEASE_STATUS_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_STATUS_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSSTSY_I_S_I_TR] ON PIMS_LEASE_STATUS_TYPE INSTEAD OF INSERT AS SET NOCOUNT ON BEGIN TRY IF NOT EXISTS(SELECT * FROM inserted) RETURN; insert into PIMS_LEASE_STATUS_TYPE ("LEASE_STATUS_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER") select "LEASE_STATUS_TYPE_CODE", "DESCRIPTION", "IS_DISABLED", "DISPLAY_ORDER", "CONCURRENCY_CONTROL_NUMBER" from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACTV_A_S_IUD_TR] ON PIMS_LEASE_ACTIVITY FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_LEASE_ACTIVITY_HIST set END_DATE_HIST = @curr_date where LEASE_ACTIVITY_ID in (select LEASE_ACTIVITY_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_LEASE_ACTIVITY_HIST ([LEASE_ACTIVITY_ID], [LEASE_ID], [LEASE_TYPE_CODE], [LEASE_SUBTYPE_CODE], [LEASE_ACTIVITY_PERIOD_ID], [AMOUNT], [ACTIVITY_DATE], [COMMENT], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _LEASE_ACTIVITY_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [LEASE_ACTIVITY_ID], [LEASE_ID], [LEASE_TYPE_CODE], [LEASE_SUBTYPE_CODE], [LEASE_ACTIVITY_PERIOD_ID], [AMOUNT], [ACTIVITY_DATE], [COMMENT], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_LEASE_ACTIVITY_H_ID_SEQ]) as [_LEASE_ACTIVITY_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACTV_A_S_IUD_TR] ON PIMS_LEASE_ACTIVITY FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_LEASE_ACTIVITY_HIST set END_DATE_HIST = @curr_date where LEASE_ACTIVITY_ID in (select LEASE_ACTIVITY_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_LEASE_ACTIVITY_HIST ([LEASE_ACTIVITY_ID], [LEASE_ID], [LEASE_TYPE_CODE], [LEASE_SUBTYPE_CODE], [LEASE_ACTIVITY_PERIOD_ID], [AMOUNT], [ACTIVITY_DATE], [COMMENT], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _LEASE_ACTIVITY_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [LEASE_ACTIVITY_ID], [LEASE_ID], [LEASE_TYPE_CODE], [LEASE_SUBTYPE_CODE], [LEASE_ACTIVITY_PERIOD_ID], [AMOUNT], [ACTIVITY_DATE], [COMMENT], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_LEASE_ACTIVITY_H_ID_SEQ]) as [_LEASE_ACTIVITY_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_EXPAMT_A_S_IUD_TR] ON PIMS_EXPECTED_AMOUNT FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_EXPECTED_AMOUNT_HIST set END_DATE_HIST = @curr_date where EXPECTED_AMOUNT_ID in (select EXPECTED_AMOUNT_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_EXPECTED_AMOUNT_HIST ([EXPECTED_AMOUNT_ID], [LEASE_ID], [LEASE_ACTIVITY_PERIOD_ID], [EXPECTED_AMOUNT], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _EXPECTED_AMOUNT_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [EXPECTED_AMOUNT_ID], [LEASE_ID], [LEASE_ACTIVITY_PERIOD_ID], [EXPECTED_AMOUNT], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_EXPECTED_AMOUNT_H_ID_SEQ]) as [_EXPECTED_AMOUNT_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_EXPAMT_A_S_IUD_TR] ON PIMS_EXPECTED_AMOUNT FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_EXPECTED_AMOUNT_HIST set END_DATE_HIST = @curr_date where EXPECTED_AMOUNT_ID in (select EXPECTED_AMOUNT_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_EXPECTED_AMOUNT_HIST ([EXPECTED_AMOUNT_ID], [LEASE_ID], [LEASE_ACTIVITY_PERIOD_ID], [EXPECTED_AMOUNT], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _EXPECTED_AMOUNT_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [EXPECTED_AMOUNT_ID], [LEASE_ID], [LEASE_ACTIVITY_PERIOD_ID], [EXPECTED_AMOUNT], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_EXPECTED_AMOUNT_H_ID_SEQ]) as [_EXPECTED_AMOUNT_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACPR_A_S_IUD_TR] ON PIMS_LEASE_ACTIVITY_PERIOD FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_LEASE_ACTIVITY_PERIOD_HIST set END_DATE_HIST = @curr_date where LEASE_ACTIVITY_PERIOD_ID in (select LEASE_ACTIVITY_PERIOD_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_LEASE_ACTIVITY_PERIOD_HIST ([LEASE_ACTIVITY_PERIOD_ID], [PERIOD_DATE], [IS_CLOSED], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _LEASE_ACTIVITY_PERIOD_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [LEASE_ACTIVITY_PERIOD_ID], [PERIOD_DATE], [IS_CLOSED], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_LEASE_ACTIVITY_PERIOD_H_ID_SEQ]) as [_LEASE_ACTIVITY_PERIOD_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] CREATE TRIGGER [dbo].[PIMS_LSACPR_A_S_IUD_TR] ON PIMS_LEASE_ACTIVITY_PERIOD FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN TRY DECLARE @curr_date datetime; SET @curr_date = getutcdate(); IF NOT EXISTS(SELECT * FROM inserted) AND NOT EXISTS(SELECT * FROM deleted) RETURN; -- historical IF EXISTS(SELECT * FROM deleted) update PIMS_LEASE_ACTIVITY_PERIOD_HIST set END_DATE_HIST = @curr_date where LEASE_ACTIVITY_PERIOD_ID in (select LEASE_ACTIVITY_PERIOD_ID from deleted) and END_DATE_HIST is null; IF EXISTS(SELECT * FROM inserted) insert into PIMS_LEASE_ACTIVITY_PERIOD_HIST ([LEASE_ACTIVITY_PERIOD_ID], [PERIOD_DATE], [IS_CLOSED], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], _LEASE_ACTIVITY_PERIOD_HIST_ID, END_DATE_HIST, EFFECTIVE_DATE_HIST) select [LEASE_ACTIVITY_PERIOD_ID], [PERIOD_DATE], [IS_CLOSED], [CONCURRENCY_CONTROL_NUMBER], [APP_CREATE_TIMESTAMP], [APP_CREATE_USERID], [APP_CREATE_USER_GUID], [APP_CREATE_USER_DIRECTORY], [APP_LAST_UPDATE_TIMESTAMP], [APP_LAST_UPDATE_USERID], [APP_LAST_UPDATE_USER_GUID], [APP_LAST_UPDATE_USER_DIRECTORY], [DB_CREATE_TIMESTAMP], [DB_CREATE_USERID], [DB_LAST_UPDATE_TIMESTAMP], [DB_LAST_UPDATE_USERID], (next value for [dbo].[PIMS_LEASE_ACTIVITY_PERIOD_H_ID_SEQ]) as [_LEASE_ACTIVITY_PERIOD_HIST_ID], null as [END_DATE_HIST], @curr_date as [EFFECTIVE_DATE_HIST] from inserted; END TRY BEGIN CATCH IF @@trancount > 0 ROLLBACK TRANSACTION EXEC pims_error_handling END CATCH; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] IF @@ERROR <> 0 SET NOEXEC ON Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO [__EFMigrationsHistory] ([MIGRATION_ID], [PRODUCT_VERSION]) VALUES (N'20210909194500_v0.2.10.0', N'5.0.6'); Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] INSERT INTO [__EFMigrationsHistory] ([MIGRATION_ID], [PRODUCT_VERSION]) VALUES (N'20210909194500_v0.2.10.0', N'5.0.6'); Committing transaction. Committed transaction. Disposing transaction. Closing connection to database 'pims' on server 'localhost,5433'. Closed connection to database 'pims' on server 'localhost,5433'. Applying migration '20211001205930_v0.2.11.0'. Opening connection to database 'pims' on server 'localhost,5433'. Opened connection to database 'pims' on server 'localhost,5433'. Beginning transaction with isolation level 'Unspecified'. Began transaction with isolation level 'ReadCommitted'. Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'PreUp Scripts' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'PreUp Scripts' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Script does not exist C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.11.0\Up\PreUp.' Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] PRINT N'Script does not exist C:\git\PSP\backend\dal\bin\Debug\net5.0\Migrations\v0.2.11.0\Up\PreUp.' Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] ALTER TABLE [PIMS_LEASE] DROP CONSTRAINT [PIM_ORG_PIM_LEASE_FK]; Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] ALTER TABLE [PIMS_LEASE] DROP CONSTRAINT [PIM_ORG_PIM_LEASE_FK]; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] EXEC sp_rename N'[PIMS_LEASE_ACTIVITY].[LSEACT_LEASE_TYPE_CODE_ID_IDX]', N'LSACTV_LEASE_TYPE_CODE_ID_IDX', N'INDEX'; Executed DbCommand (430ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] EXEC sp_rename N'[PIMS_LEASE_ACTIVITY].[LSEACT_LEASE_TYPE_CODE_ID_IDX]', N'LSACTV_LEASE_TYPE_CODE_ID_IDX', N'INDEX'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] EXEC sp_rename N'[PIMS_LEASE_ACTIVITY].[LSEACT_LEASE_SUBTYPE_CODE_ID_IDX]', N'LSACTV_LEASE_SUBTYPE_CODE_ID_IDX', N'INDEX'; Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] EXEC sp_rename N'[PIMS_LEASE_ACTIVITY].[LSEACT_LEASE_SUBTYPE_CODE_ID_IDX]', N'LSACTV_LEASE_SUBTYPE_CODE_ID_IDX', N'INDEX'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] EXEC sp_rename N'[PIMS_LEASE_ACTIVITY].[LSEACT_LEASE_ID_IDX]', N'LSACTV_LEASE_ID_IDX', N'INDEX'; Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] EXEC sp_rename N'[PIMS_LEASE_ACTIVITY].[LSEACT_LEASE_ID_IDX]', N'LSACTV_LEASE_ID_IDX', N'INDEX'; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] DECLARE @var0 sysname; SELECT @var0 = [d].[name] FROM [sys].[default_constraints] [d] INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id] WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PIMS_USER_ROLE]') AND [c].[name] = N'IS_DISABLED'); IF @var0 IS NOT NULL EXEC(N'ALTER TABLE [PIMS_USER_ROLE] DROP CONSTRAINT [' + @var0 + '];'); ALTER TABLE [PIMS_USER_ROLE] ADD CONSTRAINT PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF DEFAULT CAST(0 AS bit) FOR [IS_DISABLED]; Executed DbCommand (31ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] DECLARE @var0 sysname; SELECT @var0 = [d].[name] FROM [sys].[default_constraints] [d] INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id] WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PIMS_USER_ROLE]') AND [c].[name] = N'IS_DISABLED'); IF @var0 IS NOT NULL EXEC(N'ALTER TABLE [PIMS_USER_ROLE] DROP CONSTRAINT [' + @var0 + '];'); ALTER TABLE [PIMS_USER_ROLE] ADD CONSTRAINT PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF DEFAULT CAST(0 AS bit) FOR [IS_DISABLED]; Creating DbCommand for 'ExecuteNonQuery'. Created DbCommand for 'ExecuteNonQuery' (0ms). Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='600'] DECLARE @var1 sysname; SELECT @var1 = [d].[name] FROM [sys].[default_constraints] [d] INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id] WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PIMS_USER_ORGANIZATION]') AND [c].[name] = N'IS_DISABLED'); IF @var1 IS NOT NULL EXEC(N'ALTER TABLE [PIMS_USER_ORGANIZATION] DROP CONSTRAINT [' + @var1 + '];'); ALTER TABLE [PIMS_USER_ORGANIZATION] ADD CONSTRAINT PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF DEFAULT CAST(0 AS bit) FOR [IS_DISABLED]; Failed executing DbCommand (26ms) [Parameters=[], CommandType='Text', CommandTimeout='600'] DECLARE @var1 sysname; SELECT @var1 = [d].[name] FROM [sys].[default_constraints] [d] INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id] WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PIMS_USER_ORGANIZATION]') AND [c].[name] = N'IS_DISABLED'); IF @var1 IS NOT NULL EXEC(N'ALTER TABLE [PIMS_USER_ORGANIZATION] DROP CONSTRAINT [' + @var1 + '];'); ALTER TABLE [PIMS_USER_ORGANIZATION] ADD CONSTRAINT PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF DEFAULT CAST(0 AS bit) FOR [IS_DISABLED]; Disposing transaction. Closing connection to database 'pims' on server 'localhost,5433'. Closed connection to database 'pims' on server 'localhost,5433'. 'PimsContext' disposed. Microsoft.Data.SqlClient.SqlException (0x80131904): There is already an object named 'PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF' in the database. Could not create constraint or index. See previous errors. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlConnection.cs:line 1777 at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlInternalConnection.cs:line 606 at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\TdsParser.cs:line 1302 at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\TdsParser.cs:line 2523 at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 3062 at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 1446 at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 1061 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0() at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action) ClientConnectionId:b1937800-5bc9-472c-bb24-297a27fe31a3 Error Number:2714,State:5,Class:16 There is already an object named 'PROPLS_APP_LAST_UPDATE_USER_DIRECTORY_DEF' in the database. Could not create constraint or index. See previous errors. ``` EF Core version: 5.0.9 Database provider:  Target framework: .NET 5.0 Operating system: Microsoft Windows 10 Enterprise Build 19042 IDE: Visual Studio Community 2019 16.11.2

[roji]

I can provide more code on request, if that would be helpful as this is an open source project.

That would be the best way to move forward with this. Please also try to reduce the sample as much as possible - there's quite a lot going on in the logs above, and a minimal sample would help pinpoint what this is about.

[devinleighsmith]

Closing this, it turns out this project was using a custom sql generator to dynamically generate unique constraint names for defaults using a custom annotation. This is what was at fault. Apologies for logging this erroneously.

[devinleighsmith]

closing.