CREATE TABLE [dbo].[Estadistica](
	[EstadisticaID] [numeric](9, 0) IDENTITY(1,1) NOT NULL,
	[Indicador] [varchar](16) NOT NULL,
	[Cantidad] [int] NOT NULL,
	[FechaActualizacion] [datetime] NOT NULL,
 CONSTRAINT [PK_Estadistica] PRIMARY KEY CLUSTERED 
(
	[EstadisticaID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LOG]    Script Date: 4/10/2020 9:47:29 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG](
	[LogID] [numeric](9, 0) IDENTITY(1,1) NOT NULL,
	[Fecha] [datetime] NOT NULL,
	[Cedula] [varchar](50) NULL,
	[Correo] [varchar](100) NULL,
	[Navigator] [varchar](1024) NULL,
	[UserAgent] [varchar](64) NULL,
	[IP] [varchar](32) NULL,
 CONSTRAINT [PK_LOG] PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Solicitud]    Script Date: 4/10/2020 9:47:29 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Solicitud](
	[SolicitudID] [numeric](9, 0) IDENTITY(1,1) NOT NULL,
	[Cedula] [varchar](50) NOT NULL,
	[EsCedula] [char](1) NOT NULL,
	[Genero] [char](1) NOT NULL,
	[Edad] [smallint] NOT NULL,
	[Destino] [varchar](16) NOT NULL,
	[Correo] [varchar](100) NOT NULL,
	[Longitud] [varchar](50) NOT NULL,
	[Latitud] [varchar](50) NOT NULL,
	[Fecha] [datetime] NOT NULL,
	[Navigator] [varchar](1024) NULL,
	[UserAgent] [varchar](400) NULL,
	[IP] [varchar](32) NULL,
 CONSTRAINT [PK_Solicitud] PRIMARY KEY CLUSTERED 
(
	[SolicitudID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [master]
GO
ALTER DATABASE [LOGICSTUDIO_VOYSEGURO] SET  READ_WRITE 
GO


INSERT INTO Estadistica values ('VISITA',0,GETDATE())
INSERT INTO Estadistica values ('MEGUSTA',0,GETDATE())
INSERT INTO Estadistica values ('COMPARTIR',0,GETDATE())