USE [master]
GO
/****** Object:  Database [PaylineAsp]    Script Date: 2/20/2016 5:55:13 PM ******/
CREATE DATABASE [PaylineAsp]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'PaylineAsp', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\PaylineAsp.mdf' , SIZE = 3136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'PaylineAsp_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\PaylineAsp_log.ldf' , SIZE = 832KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [PaylineAsp] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [PaylineAsp].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [PaylineAsp] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [PaylineAsp] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [PaylineAsp] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [PaylineAsp] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [PaylineAsp] SET ARITHABORT OFF 
GO
ALTER DATABASE [PaylineAsp] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [PaylineAsp] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [PaylineAsp] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [PaylineAsp] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [PaylineAsp] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [PaylineAsp] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [PaylineAsp] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [PaylineAsp] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [PaylineAsp] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [PaylineAsp] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [PaylineAsp] SET  ENABLE_BROKER 
GO
ALTER DATABASE [PaylineAsp] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [PaylineAsp] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [PaylineAsp] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [PaylineAsp] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [PaylineAsp] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [PaylineAsp] SET READ_COMMITTED_SNAPSHOT ON 
GO
ALTER DATABASE [PaylineAsp] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [PaylineAsp] SET RECOVERY FULL 
GO
ALTER DATABASE [PaylineAsp] SET  MULTI_USER 
GO
ALTER DATABASE [PaylineAsp] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [PaylineAsp] SET DB_CHAINING OFF 
GO
ALTER DATABASE [PaylineAsp] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [PaylineAsp] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'PaylineAsp', N'ON'
GO
USE [PaylineAsp]
GO
/****** Object:  Table [dbo].[__MigrationHistory]    Script Date: 2/20/2016 5:55:13 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[__MigrationHistory](
	[MigrationId] [nvarchar](150) NOT NULL,
	[ContextKey] [nvarchar](300) NOT NULL,
	[Model] [varbinary](max) NOT NULL,
	[ProductVersion] [nvarchar](32) NOT NULL,
 CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY CLUSTERED 
(
	[MigrationId] ASC,
	[ContextKey] 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].[Payments]    Script Date: 2/20/2016 5:55:13 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Payments](
	[PaymentId] [int] IDENTITY(1,1) NOT NULL,
	[ReferenceNumber] [nvarchar](50) NULL,
	[SaleReferenceId] [nvarchar](50) NULL,
	[StatusPayment] [nvarchar](5) NULL,
	[Amount] [int] NOT NULL,
	[UserId] [int] NOT NULL,
	[InsertDatetime] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.Payments] PRIMARY KEY CLUSTERED 
(
	[PaymentId] 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
INSERT [dbo].[__MigrationHistory] ([MigrationId], [ContextKey], [Model], [ProductVersion]) VALUES (N'201602201300009_AutomaticMigration', N'Models.DataBaseContext', 0x1F8B0800000000000400CD58DB6EDB38107D5FA0FF20E839359D040BB481DCC27592C2D83A09AAB4AF0B5A1ADB4429524B5281DD5FDB87FDA4FD851DEA2ECAD7348B167989C8993387C399A391FFFDFB9FE0FD3AE1DE1328CDA418F9E783A1EF818864CCC472E46766F1FA8DFFFEDDABDF829B38597B5F2BBB4B6B879E428FFC9531E915213A5A4142F5206191925A2ECC209209A1B12417C3E15B727E4E00217CC4F2BCE073260C4B207FC0C7891411A426A37C2663E0BA5CC79D3047F5EE68023AA5118CFCC2C2F7C69C518C1E025FF81E15421A6A90DBD5170DA151522CC31417287FDCA480760BCA35949CAF1AF363E90F2F2C7DD238565051A68D4C4E043CBF2CF3415CF76765D5AFF38519BBC1CC9A8D3D759EB591FF40370908E37B6EACAB0957D6AECAE9A0B43CF3C669FAE704D706DFDEBCDD30F8BE3AABAF7E38C8FFCEBC49C64DA6602420338AF233EF219B7316FD019B47F90DC448649CB7892135DCEB2CE0D283922928B3F90C8B2EDD69EC7BA4EB4E5CFFDABBEF5A9C6B2ACCE585EFDD21153AE75057412B07A1910A3E8200450DC40FD418507889D318F23CF64838219137286C18B8CB9239A82A3056203690EFCDE8FA1388A5598DFCDFB1636ED91AE26AA1E4F245306C37F4312A8343E142CAA10ED99CF37F0B8749CA745D40BB83BD40AC7122B326C8AE9BDB8F81BDAF0EDFFE7E8CA94010738DD56015AAC2B2CF8FF9F35EB88034EDD76F4A94394319965A190A41E907AAC1AEC37A5B87E281CA26D56516BBDC0BDC104CB703501E1B1E85460EEA5BDCC6B766D6282F29A4B79268B243A383194D53AC879666972B5E5808F6E47578BAAA25050689F41671ABD9D691B089E9129C5D0C8D4C6F99D2F63AE99CDADB9AC449CFCCBD871D39AEA239A97625ADC97CE560FF2F9CBA42EBBA36B9BBC5E3588BFC64503368C4BCE799BF2B29A76AB7264E24CF12714065F761F5C4AE8DD8DB3C1EB7A76A6DDCDEE609B85DF9EAA076B78EC7AC64AA0D56AD1D8F5209551BA55A3B1EC595AA369ABBD7470D88536C6E21935E253BEF63B733F6098B6B5247AF05C61192A06CEAC31361AFCB0B13DFC3743DB1D87678B8D10692813518847FF10967F9B55706332AD802B42926171F07B40B67C0FC75863DA275CC8F9BF87EF2F4C56C8A0FCE5727BE9E770C5CE289AA6845556F066AE07F60BE7A29F46DE3D476EC53A1BBD3539EF91F9A9D9E83B07D728AEBE7179C9CFA2FF6A3E6A27D6351211AC8772E917AC1B319A79E3934F5352C20ED6FDFE01A345B3610F64B584064C5A101AD6CA66221AB94E3D1DA8C2A13E746666028E69F8E95610B1A19DC8E40EB7C7CFF4A79862637D845F154DC6726CDCC586B48E6BCF3D51390FDF1F3C9B0CB39B84FED937E8923204D664BE85E7CC8188F6BDEB75B4A6807842D96528190157EBE20DC725323DD4971245099BE6B484158FD7A8424E508A6EF45489FE039DCB0EB3EC192469BEA55B41BE4F04574D31E5C33BA5434D12546E36F7FCF21F6079D77FF015CBD8C2102120000, N'6.1.2-31219')
SET IDENTITY_INSERT [dbo].[Payments] ON 

INSERT [dbo].[Payments] ([PaymentId], [ReferenceNumber], [SaleReferenceId], [StatusPayment], [Amount], [UserId], [InsertDatetime]) VALUES (8, N'110964', N'146247', N'1', 10000, 1, CAST(0x0000A5B20116878A AS DateTime))
INSERT [dbo].[Payments] ([PaymentId], [ReferenceNumber], [SaleReferenceId], [StatusPayment], [Amount], [UserId], [InsertDatetime]) VALUES (9, N'110965', N'93866', N'1', 10000, 1, CAST(0x0000A5B201171DFA AS DateTime))
INSERT [dbo].[Payments] ([PaymentId], [ReferenceNumber], [SaleReferenceId], [StatusPayment], [Amount], [UserId], [InsertDatetime]) VALUES (10, N'110966', N'448544', N'1', 10000, 1, CAST(0x0000A5B2011A2461 AS DateTime))
SET IDENTITY_INSERT [dbo].[Payments] OFF
USE [master]
GO
ALTER DATABASE [PaylineAsp] SET  READ_WRITE 
GO
