 
 ) ON [PRIMARY]
 
-END
-
-GO
-
-/****** Object:  Table [dbo].[AspNetUsers]    Script Date: 5/23/2017 5:21:28 PM ******/
-
-SET ANSI_NULLS ON
-
-GO
-
-SET QUOTED_IDENTIFIER ON
-
-GO
-
-IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AspNetUsers]') AND type in (N'U'))
-
-BEGIN
+GO
+
+/****** Object:  Table [dbo].[AspNetUsers]    Script Date: 6/5/2017 5:22:06 PM ******/
+
+SET ANSI_NULLS ON
+
+GO
+
+SET QUOTED_IDENTIFIER ON
+
+GO
 
 CREATE TABLE [dbo].[AspNetUsers](
 
-	[Id] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
-
-	[Email] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[Id] [nvarchar](128) NOT NULL,
+
+	[Email] [nvarchar](256) NULL,
 
 	[EmailConfirmed] [bit] NOT NULL,
 
-	[PasswordHash] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
-
-	[SecurityStamp] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
-
-	[PhoneNumber] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[PasswordHash] [nvarchar](max) NULL,
+
+	[SecurityStamp] [nvarchar](max) NULL,
+
+	[PhoneNumber] [nvarchar](max) NULL,
 
 	[PhoneNumberConfirmed] [bit] NOT NULL,
 


GO

/****** Object:  StoredProcedure [dbo].[Company_Delete]    Script Date: 5/23/2017 5:21:28 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Company_Delete]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Company_Delete] AS' 

END

GO



ALTER PROCEDURE [dbo].[Company_Delete]

@Id INT 



GO

ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId]

GO

/****** Object:  StoredProcedure [dbo].[Company_Add]    Script Date: 6/5/2017 5:22:06 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO





CREATE PROCEDURE [dbo].[Company_Add]

@Id INT OUTPUT,

@Name NVARCHAR(50),

@UserId NVARCHAR(128) NULL,

@Address1 NVARCHAR(50) NULL,

@Address2 NVARCHAR(50) NULL,

@City NVARCHAR(50) NULL,

@State NVARCHAR(2) NULL,

@PostalCode NVARCHAR(10) NULL,

@PhoneNumber NVARCHAR(20) NULL



