CREATE TABLE [dbo].[ICUnits]
(
[ID] [int] NOT NULL,
[TextID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Type] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_ICUnits_Locks] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ICUnits_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICUnits_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[UseAreaCalculations] [bit] NOT NULL CONSTRAINT [DF_ICUnits_UseAreaCalculations] DEFAULT ((0)),
[Units] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICUnits_Units] DEFAULT (''),
[UseRounding] [bit] NOT NULL CONSTRAINT [DF_ICUnits_UseRounding] DEFAULT ((0)),
[RoundDirection] [bit] NOT NULL CONSTRAINT [DF_ICUnits_RoundDirection] DEFAULT ((1)),
[RoundFraction] [decimal] (8, 6) NOT NULL CONSTRAINT [DF_ICUnits_RoundFraction] DEFAULT ((1)),
[RoundUnits] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICUnits_RoundUnits] DEFAULT (''),
[UseSetCalculations] [bit] NOT NULL CONSTRAINT [DF_ICUnits_UseSetCalculations] DEFAULT ((0)),
[SetNameSingular] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICUnits_SetNameSingular] DEFAULT (''),
[SetNamePlural] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICUnits_SetNamePlural] DEFAULT (''),
[PieceNameSingular] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICUnits_PieceNameSingular] DEFAULT (''),
[PieceNamePlural] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICUnits_PieceNamePlural] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICUnits] ADD CONSTRAINT [PK_ICUnits] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO