
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'prop1_BillingInstructions')
BEGIN
	CREATE TABLE [dbo].[prop1_BillingInstructions](
	    [recId] [int] IDENTITY(1,1) NOT NULL,
	    [entityId] [int] NULL,
	    [billingInstructions] [nvarchar](max) NULL,
	CONSTRAINT [PK_prop1_BillingInstructions] PRIMARY KEY CLUSTERED 
    (
	    [recId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'prop1_PreferredSuppliers')
BEGIN
	CREATE TABLE [dbo].[prop1_PreferredSuppliers](
	    [recId] [INT] IDENTITY(1,1) NOT NULL,
	    [entityId] [INT] NULL,
	    [preferredSuppliers] [NVARCHAR](MAX) NULL,
	CONSTRAINT [PK_prop1_PreferredSuppliers] PRIMARY KEY CLUSTERED 
    (
	    [recId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'prop1_PropertyLookupDetails')
BEGIN
	CREATE TABLE [dbo].[prop1_PropertyLookupDetails](
	    [ID] [int] IDENTITY(1,1) NOT NULL,
	    [propertyID] [int] NULL,
	    [propertyName] [nvarchar](max) NULL,
	    [propertyLookupDetails] [nvarchar](max) NULL,
	CONSTRAINT [PK_prop1_PropertyLookupDetails] PRIMARY KEY CLUSTERED 
    (
	    [ID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END