script

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[BL_Relatonships]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[BL_Relatonships](
 [RelationShipID] [tinyint] NOT NULL,
 [RelationshipName] [varchar](50) NULL,
 [Description] [varchar](50) NULL,
 [RelationshipMasterID] [tinyint] NULL,
 [SortOrder] [tinyint] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[BL_MingleUsers]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[BL_MingleUsers](
 [UserID] [bigint] NOT NULL,
 [UserUniqueID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_BL_MingleUsers_UserUniqueID]  DEFAULT (newid()),
 [UserEmail] [varchar](50) NULL,
 [Password] [varchar](50) NULL,
 [LoggedInIpAddress] [varchar](50) NULL,
 [UserLogoPath] [varchar](256) NULL,
 [IsAcitive] [bit] NOT NULL CONSTRAINT [DF_U_UserLogin_IsAcitive]  DEFAULT ((1))
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[U_AddressBook]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[U_AddressBook](
 [AddressBookID] [bigint] IDENTITY(1,1) NOT NULL,
 [FName] [varchar](100) NULL,
 [LName] [varchar](100) NULL,
 [MName] [varchar](100) NULL,
 [EMail] [varchar](50) NULL,
 [CreatedDate] [smalldatetime] NULL CONSTRAINT [DF_U_Addressbook_CreatedDate]  DEFAULT (getdate()),
 [LoginUserId] [bigint] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[U_ContactConnection]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[U_ContactConnection](
 [ContactConnectionId] [bigint] IDENTITY(1,1) NOT NULL,
 [LoginUserID] [bigint] NOT NULL,
 [ConnectionID] [bigint] NULL,
 [AddressBookID] [bigint] NULL,
 [SharingContactsCount] [int] NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N’MS_Description’ , N’SCHEMA’,N’dbo’, N’TABLE’,N’U_ContactConnection’, N’COLUMN’,N’ConnectionID’))
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Friend id’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N’U_ContactConnection’, @level2type=N’COLUMN’,@level2name=N’ConnectionID’
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[U_ContactRelationship]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[U_ContactRelationship](
 [RelationId] [bigint] IDENTITY(1,1) NOT NULL,
 [ShareMe] [bit] NOT NULL CONSTRAINT [DF_U_ContactRelationship_ShareMe]  DEFAULT ((1)),
 [KeepPrivate] [bit] NOT NULL CONSTRAINT [DF_U_ContactRelationship_KeepPrivate]  DEFAULT ((0)),
 [PersonalRelationship] [int] NOT NULL,
 [ProfessionalRelationship] [int] NOT NULL,
 [Notes] [varchar](1000) NULL,
 [Message] [varchar](1000) NULL,
 [Location] [varchar](256) NULL,
 [AddressBookID] [bigint] NOT NULL,
 [ConnectionRequest] [bit] NOT NULL CONSTRAINT [DF_U_ContactRelationship_ConnectionRequest]  DEFAULT ((0)),
 [RequestStatus] [varchar](50) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[BL_RelatonShipMaster]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[BL_RelatonShipMaster](
 [RelationshipMasterID] [tinyint] NULL,
 [Name] [varchar](50) NOT NULL,
 [Description] [varchar](150) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[BL_FolderMembers]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[BL_FolderMembers](
 [ContactID] [bigint] NULL,
 [FoldersID] [bigint] NULL,
 [Description] [varchar](50) NULL,
 [SharedContactsCount] [bigint] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[BL_UserFolders]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[BL_UserFolders](
 [FolderID] [bigint] NOT NULL,
 [FolderName] [varchar](30) NULL,
 [Description] [varchar](50) NULL,
 [SortOrder] [tinyint] NULL,
 [ContactsCount] [int] NULL,
 [ParentID] [bigint] NULL,
 [LoginUserID] [bigint] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[AddressBook_Insertion]‘) AND type in (N’P', N’PC’))
BEGIN
EXEC dbo.sp_executesql @statement = N’–exec [UserLogin_Validate] ”admin”, ”admin”,”123”,””,””

CREATE PROCEDURE [dbo].[AddressBook_Insertion]
(
 @Email  VARCHAR(150), 
 @Fname VARCHAR(100),
 @Lname VARCHAR(100),
 @Network   INT
)
AS
BEGIN
 
 BEGIN TRY

     BEGIN
     INSERT  INTO U_AddressBook(FName,LName,EMail)
         VALUES (@Fname,@Lname,@Email)
     END
    
 END TRY
 BEGIN CATCH
  SELECT ”ERROR””Result”
 END CATCH

END
 ’
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[BL_NetworkMembers]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[BL_NetworkMembers](
 [AddressBookID] [int] NOT NULL,
 [NetworksID] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[BL_Networks]‘) AND type in (N’U'))
BEGIN
CREATE TABLE [dbo].[BL_Networks](
 [NetworkID] [int] NOT NULL,
 [NetworkName] [varchar](50) NULL,
 [NetworkDesc] [varchar](150) NULL,
 [NetworkPhotoPath] [varchar](250) NULL,
 [Active] [bit] NULL CONSTRAINT [DF_BL_Networks_Active]  DEFAULT ((1)),
 [Visible] [bit] NULL CONSTRAINT [DF_BL_Networks_Visible]  DEFAULT ((1)),
 [parentNetworkID] [int] NULL,
 [CreatedDate] [smalldatetime] NULL,
 [UpdatedDate] [smalldatetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[GetAllNetworks]‘) AND type in (N’P', N’PC’))
BEGIN
EXEC dbo.sp_executesql @statement = N’
CREATE procedure [dbo].[GetAllNetworks]
as
–Used To get all the network names
begin
select Networkid=case when isnull(c.Networkid,0) =0 then p.Networkid else c.Networkid end,ChildNetworkName=c.Networkname,c.NetworkDesc,p.Networkname from dbo.BL_Networks p
left outer join BL_Networks c on P.Networkid =c.parentnetworkID
where ( p.parentnetworkID = 0)
end’
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[GetAllRelationships]‘) AND type in (N’P', N’PC’))
BEGIN
EXEC dbo.sp_executesql @statement = N’–select * from dbo.BL_Relatonships

CREATE procedure [dbo].[GetAllRelationships]
as
begin
select RelationshipID,Head=[name],Relationshipname from BL_RelatonShipMaster p
left outer join BL_Relatonships c on P.RelationshipMasterID =c.RelationshipMasterID order by RelationshipID,sortorder
end
‘
END