USE [sistema]
GO
/****** Object: Table [dbo].[ORDENES] Script Date: 07/06/2016 17:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ORDENES](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CODIGO] [varchar](255) NOT NULL,
[RAZONSOCIAL] [varchar](255) NOT NULL,
[RIF] [varchar](255) NOT NULL,
[DIRECCION] [varchar](255) NULL,
[TELEFONO] [varchar](255) NULL,
[NRODENOTADEENTREGA] [varchar](255) NULL,
[FECHANOTADEENTREGA] [date] NULL,
[FECHAORDERN] [date] NULL,
[C01] [varchar](8) NULL,
[C02] [varchar](7) NULL,
[C03] [varchar](7) NULL,
[C04] [varchar](7) NULL,
[C05] [varchar](7) NULL,
[C06] [varchar](7) NULL,
[C07] [varchar](7) NULL,
[C08] [varchar](7) NULL,
[C09] [varchar](7) NULL,
[C10] [varchar](7) NULL,
[C11] [varchar](7) NULL,
[C12] [varchar](7) NULL,
[C13] [varchar](7) NULL,
[C14] [varchar](7) NULL,
[OBSERVACIONES] [varchar](255) NULL,
[ESTADO] [varchar](255) NULL,
[LABORATORIO] [varchar](255) NULL,
[CERRADA] [varchar](255) NULL,
[ORDENDELCLIENTE] [varchar](255) NOT NULL,
[ENLABORATORIO] [varchar](255) NULL,
[ENTREGADA] [varchar](255) NULL,
[PORENTREGAR] [varchar](255) NULL,
[CAJA] [varchar](255) NULL,
CONSTRAINT [PK__ORDENES__3214EC27060DEAE8] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Default [DF__ORDENES__FECHAOR__108B795B] Script Date: 07/06/2016 17:03:53 ******/
ALTER TABLE [dbo].[ORDENES] ADD CONSTRAINT [DF__ORDENES__FECHAOR__108B795B] DEFAULT (getdate()) FOR [FECHAORDERN]
GO
/****** Object: Default [DF__ORDENES__ESTADO__117F9D94] Script Date: 07/06/2016 17:03:53 ******/
ALTER TABLE [dbo].[ORDENES] ADD CONSTRAINT [DF__ORDENES__ESTADO__117F9D94] DEFAULT ('Sin estado') FOR [ESTADO]
GO
/****** Object: Default [DF_ORDENES_CERRADA] Script Date: 07/06/2016 17:03:53 ******/
ALTER TABLE [dbo].[ORDENES] ADD CONSTRAINT [DF_ORDENES_CERRADA] DEFAULT ('No') FOR [CERRADA]
GO
/****** Object: Default [DF_ORDENES_ENTREGADA] Script Date: 07/06/2016 17:03:53 ******/
ALTER TABLE [dbo].[ORDENES] ADD CONSTRAINT [DF_ORDENES_ENTREGADA] DEFAULT ('No') FOR [ENTREGADA]
GO
/****** Object: Default [DF_ORDENES_PORENTREGAR] Script Date: 07/06/2016 17:03:53 ******/
ALTER TABLE [dbo].[ORDENES] ADD CONSTRAINT [DF_ORDENES_PORENTREGAR] DEFAULT ('Si') FOR [PORENTREGAR]
GO