USE KEYHOUSE
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InterestLedger]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[InterestLedger]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InterestRates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[InterestRates]
GO

CREATE TABLE [dbo].[InterestLedger] (
	[RECORDID] [int] IDENTITY (1, 1) NOT NULL ,
	[MATTER] [char] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[VDATE] [int] NULL ,
	[DATE] [int] NULL ,
	[VALUE] [decimal](15, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[InterestRates] (
	[RECORDID] [int] IDENTITY (1, 1) NOT NULL ,
	[DATEFROM] [int] NOT NULL ,
	[DATETO] [int] NULL ,
	[RATE] [decimal](7, 2) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[InterestLedger] WITH NOCHECK ADD 
	CONSTRAINT [PK__InterestLedger__3F865F66] PRIMARY KEY  CLUSTERED 
	(
		[RECORDID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[InterestRates] WITH NOCHECK ADD 
	CONSTRAINT [PK__InterestRates__3CA9F2BB] PRIMARY KEY  CLUSTERED 
	(
		[RECORDID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[InterestRates] ADD 
	CONSTRAINT [UQ__InterestRates__3D9E16F4] UNIQUE  NONCLUSTERED 
	(
		[DATEFROM],
		[RECORDID]
	)  ON [PRIMARY] 
GO