USE [dbDecotune]

GO
create database dbDecotune
/****** Object:  Table [dbo].[Usuario]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOde
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Usuario](
[pkUsuario] [int] IDENTITY(1,1) NOT NULL,
[nombres] [varchar](100) NOT NULL,
[apellidoPaterno] [varchar](50) NOT NULL,
[apellidoMaterno] [varchar](50) NULL,
[usuario] [varchar](10) NULL,
[clave] [varchar](10) NULL,
[estado] [bit] NULL,
[fechaRegistro] [date] NULL,
[dni] [varchar](8) NULL,
 CONSTRAINT [PK_Usuario] PRIMARY KEY CLUSTERED
(
[pkUsuario] 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:  Table [dbo].[Cliente]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cliente](
[pkCliente] [int] IDENTITY(1,1) NOT NULL,
[nombre] [varchar](100) NOT NULL,
[apellidoPaterno] [varchar](50) NOT NULL,
[apellidoMaterno] [varchar](50) NOT NULL,
[dni] [varchar](11) NOT NULL,
[direccion] [varchar](100) NOT NULL,
[sexo] [char](1) NOT NULL,
[NCelular] [varchar](20) NULL,
[correoElectronico] [varchar](100) NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [datetime] NOT NULL,
 CONSTRAINT [PK_Cliente] PRIMARY KEY CLUSTERED
(
[pkCliente] 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:  Table [dbo].[Calidad]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Calidad](
[pkCalidad] [int] IDENTITY(1,1) NOT NULL,
[descripcion] [varchar](100) NOT NULL,
[estado] [bit] NULL,
[fechaRegistro] [datetime] NULL,
 CONSTRAINT [PK_Material] PRIMARY KEY CLUSTERED
(
[pkCalidad] 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:  Table [dbo].[Empresa]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Empresa](
[pkEmpresa] [int] IDENTITY(1,1) NOT NULL,
[RazonSocial] [varchar](100) NOT NULL,
[ruc] [varchar](11) NOT NULL,
[nCelular] [varchar](20) NULL,
[direccion] [varchar](50) NOT NULL,
[correoElectronico] [varchar](50) NULL,
[HorarioDeAtencion] [text] NOT NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [date] NOT NULL,
 CONSTRAINT [PK_Empresa] PRIMARY KEY CLUSTERED
(
[pkEmpresa] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Inventario]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Inventario](
[pkInventario] [int] NOT NULL,
[tipoInventario] [varchar](50) NOT NULL,
[fechaInventario] [datetime] NOT NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [date] NOT NULL,
[fkEmpresa] [int] NULL,
 CONSTRAINT [PK_Inventario_1] PRIMARY KEY CLUSTERED
(
[pkInventario] 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:  Table [dbo].[Moto]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Moto](
[pkMoto] [int] IDENTITY(1,1) NOT NULL,
[comentario] [text] NOT NULL,
[nChasis] [varchar](20) NOT NULL,
[nMotor] [varchar](20) NOT NULL,
[Color] [varchar](10) NOT NULL,
[fkCliente] [int] NOT NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [datetime] NOT NULL,
 CONSTRAINT [PK_Moto] PRIMARY KEY CLUSTERED
(
[pkMoto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Modelo]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Modelo](
[pkModelo] [int] IDENTITY(1,1) NOT NULL,
[serie] [int] NOT NULL,
[descripcion] [varchar](100) NOT NULL,
[comentario] [text] NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [datetime] NOT NULL,
[color] [varchar](50) NULL,
[fkCalidad] [int] NULL,
[precio] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Modelo] PRIMARY KEY CLUSTERED
(
[pkModelo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Material]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Material](
[pkMaterial] [int] IDENTITY(1,1) NOT NULL,
[descripcionCorta] [varchar](100) NOT NULL,
[descripconLarga] [text] NOT NULL,
[Precio] [decimal](18, 2) NOT NULL,
[Codigo] [varchar](10) NOT NULL,
[fechaRegistro] [nchar](10) NOT NULL,
[estado] [bit] NOT NULL,
[Disponibilidad] [varchar](100) NULL,
[fkInventario] [int] NULL,
 CONSTRAINT [PK_Inventario] PRIMARY KEY CLUSTERED
(
[pkMaterial] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DetalleVenta]    Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DetalleVenta](
[pkDetalleModelo] [int] IDENTITY(1,1) NOT NULL,
[fkMoto] [int] NOT NULL,
[fkModelo] [int] NOT NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [datetime] NOT NULL,
 CONSTRAINT [PK_DetalleModelo] PRIMARY KEY CLUSTERED
(
[pkDetalleModelo] 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
/****** Object:  ForeignKey [FK_DetalleModelo_Modelo]    Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[DetalleVenta]  WITH CHECK ADD  CONSTRAINT [FK_DetalleModelo_Modelo] FOREIGN KEY([fkMoto])
REFERENCES [dbo].[Modelo] ([pkModelo])
GO
ALTER TABLE [dbo].[DetalleVenta] CHECK CONSTRAINT [FK_DetalleModelo_Modelo]
GO
/****** Object:  ForeignKey [FK_DetalleModelo_Moto]    Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[DetalleVenta]  WITH CHECK ADD  CONSTRAINT [FK_DetalleModelo_Moto] FOREIGN KEY([fkMoto])
REFERENCES [dbo].[Moto] ([pkMoto])
GO
ALTER TABLE [dbo].[DetalleVenta] CHECK CONSTRAINT [FK_DetalleModelo_Moto]
GO
/****** Object:  ForeignKey [FK_Inventario_Inventario]    Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[Inventaro]  WITH CHECK ADD  CONSTRAINT [FK_Inventario_Inventario] FOREIGN KEY([fkEmpresa])
REFERENCES [dbo].[Empresa] ([pkEmpresa])
GO
ALTER TABLE [dbo].[Inventario] CHECK CONSTRAINT [FK_Inventario_Inventario]
GO
/****** Object:  ForeignKey [FK_Material_Inventario]    Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[Material]  WITH CHECK ADD  CONSTRAINT [FK_Material_Inventario] FOREIGN KEY([fkInventario])
REFERENCES [dbo].[Inventario] ([pkInventario])
GO
ALTER TABLE [dbo].[Material] CHECK CONSTRAINT [FK_Material_Inventario]
GO
/****** Object:  ForeignKey [FK_Modelo_Calidad]    Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[Modelo]  WITH CHECK ADD  CONSTRAINT [FK_Modelo_Calidad] FOREIGN KEY([fkCalidad])
REFERENCES [dbo].[Calidad] ([pkCalidad])
GO
ALTER TABLE [dbo].[Modelo] CHECK CONSTRAINT [FK_Modelo_Calidad]
GO
/****** Object:  ForeignKey [FK_Moto_Cliente]    Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[Moto]  WITH CHECK ADD  CONSTRAINT [FK_Moto_Cliente] FOREIGN KEY([fkCliente])
REFERENCES [dbo].[Cliente] ([pkCliente])
GO
ALTER TABLE [dbo].[Moto] CHECK CONSTRAINT [FK_Moto_Cliente]
GO