IF  EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_orders]'))

DROP TABLE [dbo].[CRM_orders]

GO

CREATE TABLE [dbo].[CRM_orders](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Order_ID] [varchar](50) NOT NULL,

[Guest_UID] [varchar](50) NULL,

[Integral] [int] NULL,

[Amount] [money] NULL,

[IsUp] [int] NOT NULL,

[is_yd] [int] NOT NULL,

[yd_id] [varchar](50) NULL,

[ispayoff] [int] NOT NULL

) ON [PRIMARY]

GO