CREATE SCHEMA [report] AUTHORIZATION [dbo]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[report].[True]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [report].[True]
GO

create function [report].[True]()
returns integer
as 
begin
return 1; --@b2 bit = 'true'
end

GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[report].[False]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [report].[False]
GO

create function [report].[False]()
returns integer
as 
begin
return 0; --@b1 bit = 'false'
end

GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[report].[CharacterWidth]') AND type in (N'U'))
DROP TABLE [report].[CharacterWidth]
GO

CREATE TABLE [report].[CharacterWidth](
	[FontName]		varchar(31) not null,
	[FontBold]		int			not null,
	[FontItalic]	int			not null,
	[CODE]			int			not null,
	[Length]		float		NULL,
 CONSTRAINT [PK_CharacterWidth] PRIMARY KEY CLUSTERED 
(
	[FontName], [FontBold], [FontItalic], [CODE]
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO