base de datos en sql server microsoft

incidencias.sql

USE [SISTINCIDENCIAS]
GO
/****** Object:  Table [dbo].[INCIDENCIAS]    Script Date: 12/17/2015 17:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[INCIDENCIAS](
	[id_incidencia] [int] IDENTITY(1,1) NOT NULL,
	[nombre] [varchar](50) NULL,
	[descripcion] [varchar](100) NULL,
	[detalle] [varchar](50) NULL,
	[nombre_usuario] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CATALOGO_EQUIPOS]    Script Date: 12/17/2015 17:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CATALOGO_EQUIPOS](
	[id_catalogo] [int] IDENTITY(1,1) NOT NULL,
	[equipo] [varchar](50) NULL,
	[garantia] [varchar](50) NULL,
	[accesorios] [varchar](50) NULL,
	[dispositvos] [varchar](50) NULL,
	[detalle] [varchar](50) NULL,
	[usuario_cata] [varchar](50) NULL,
 CONSTRAINT [PK_CATALOGO_EQUIPOS] PRIMARY KEY CLUSTERED 
(
	[id_catalogo] 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].[USUARIOS]    Script Date: 12/17/2015 17:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USUARIOS](
	[id_usuario] [int] IDENTITY(1,1) NOT NULL,
	[nombre] [varchar](50) NULL,
	[apellido] [varchar](50) NULL,
	[usuario] [varchar](50) NULL,
	[password] [varchar](50) NULL,
	[tipo_usuario] [varchar](20) NULL,
 CONSTRAINT [PK_USUARIOS] PRIMARY KEY CLUSTERED 
(
	[id_usuario] 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].[SOLUCIONES]    Script Date: 12/17/2015 17:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SOLUCIONES](
	[id_soluciones] [int] IDENTITY(1,1) NOT NULL,
	[descripcion_incidencia] [varchar](100) NULL,
	[archivo_pdf] [nchar](25) NULL,
	[detalle_incidencia] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SEDE]    Script Date: 12/17/2015 17:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SEDE](
	[id_sede] [int] IDENTITY(1,1) NOT NULL,
	[nombre] [varchar](50) NULL,
	[sede] [varchar](50) NULL,
	[descripcion] [varchar](80) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  StoredProcedure [dbo].[personalsoporte]    Script Date: 12/17/2015 17:05:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[personalsoporte]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	SELECT        nombre, apellido, usuario, tipo_usuario
	FROM            USUARIOS
	RETURN
GO
/****** Object:  StoredProcedure [dbo].[lstequser]    Script Date: 12/17/2015 17:05:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[lstequser]
	
AS
	SELECT        CATALOGO_EQUIPOS.equipo, USUARIOS.usuario
	FROM            CATALOGO_EQUIPOS INNER JOIN
	                         USUARIOS ON CATALOGO_EQUIPOS.usuario_cata = USUARIOS.usuario
	RETURN
GO
/****** Object:  StoredProcedure [dbo].[listarquipos]    Script Date: 12/17/2015 17:05:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[listarquipos]	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	SELECT        equipo, accesorios
	FROM            CATALOGO_EQUIPOS
	RETURN
GO
/****** Object:  StoredProcedure [dbo].[listarincmatsol]    Script Date: 12/17/2015 17:05:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[listarincmatsol]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	SELECT        INCIDENCIAS.nombre, INCIDENCIAS.descripcion, INCIDENCIAS.detalle, SOLUCIONES.descripcion_incidencia, SOLUCIONES.archivo_pdf
	FROM            INCIDENCIAS INNER JOIN
	                         SOLUCIONES ON INCIDENCIAS.detalle = SOLUCIONES.descripcion_incidencia
	RETURN
GO