/* Fix for Online Enrollment update 2/3/23 - bad PRD table with IDENTITY column For customer distribution c. 2023 Aeries Software */ USE [AeriesRegistration]; GO IF( SELECT 1 FROM SYS.IDENTITY_COLUMNS WHERE OBJECT_NAME(OBJECT_ID) = 'PRD' AND OBJECT_SCHEMA_NAME(object_id) = 'dbo' AND name = 'SQ' ) = 1 BEGIN DROP TABLE [PRD]; END IF(NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'PRD')) BEGIN CREATE TABLE [dbo].[PRD]( [RID] [int] NOT NULL CONSTRAINT [DF_PRD_RID] DEFAULT(0), [TY] [smallint] NOT NULL CONSTRAINT [DF_PRD_TY] DEFAULT(0), [SQ] [int] NOT NULL CONSTRAINT [DF_PRD_SQ] DEFAULT(0), [NM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PRD_NM] DEFAULT(''), [GN] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PRD_GN] DEFAULT (''), [BD] [datetime] NULL, [GR] [smallint] NOT NULL CONSTRAINT [DF_PRD_GR] DEFAULT(0), [SNM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PRD_SNM] DEFAULT(''), CONSTRAINT [PK_PRD] PRIMARY KEY (RID, TY, SQ)); END IF NOT EXISTS(SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'FK_PRD_PRS')) BEGIN EXEC('ALTER TABLE [dbo].[PRD] ADD CONSTRAINT [FK_PRD_PRS] FOREIGN KEY ([RID], [TY]) REFERENCES [PRS] ([RID], [TY])'); END