USE [gips]
GO

/****** Object:  Table [dbo].[Recipes]    Script Date: 11/27/2014 08:33:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Recipes](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [title] [VARCHAR](50) NOT NULL,
    [plaster_weight] [FLOAT] NOT NULL,
    [plaster_correction] [FLOAT] NOT NULL,
    [water_weight] [FLOAT] NOT NULL,
    [water_correction] [FLOAT] NOT NULL,
    [CURRENT] [bit] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Recipes] ADD  CONSTRAINT [DF_Recipes_current]  DEFAULT ((0)) FOR [CURRENT]
GO