CREATE TABLE [dbo].[CoSync]
(
[SyncID] [int] NOT NULL IDENTITY(1, 1),
[FormID] [int] NOT NULL,
[SourceDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SQLString] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SecuredObjectID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DestinationDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DestinationTable] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DestinationColumn] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DestinationAlias] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestinationWhere] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AdditionalUpdateSQL] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DialogType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ColumnString] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ControlName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ControlValueCall] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[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_CoSync_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_CoSync_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[ColumnStringEx] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoSync] ADD CONSTRAINT [PK_CoSync] PRIMARY KEY CLUSTERED ([SyncID]) ON [PRIMARY]
GO