Sql data calendar in sql server 2008 sql

/****** Object:  Table [dbo].[tb_StoreUserProfile]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_StoreUserProfile](
	[ProfileID] [uniqueidentifier] NOT NULL,
	[FName] [nvarchar](50) NULL,
	[LName] [nvarchar](50) NULL,
	[Email] [nvarchar](50) NULL,
	[Phone] [nvarchar](50) NULL,
	[Mobile] [nvarchar](50) NULL,
	[Zipcode] [nvarchar](50) NULL,
	[Sate] [nvarchar](50) NULL,
	[City] [nvarchar](50) NULL,
	[CountryID] [bigint] NULL,
	[SoreName] [nvarchar](50) NULL,
	[website] [varchar](50) NULL,
	[Logo] [varchar](50) NULL,
	[RegNumber] [varchar](50) NULL,
	[Comments] [nvarchar](1000) NULL,
	[Kyewords] [nvarchar](1000) NULL,
	[GoogleMapPath] [varchar](50) NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
	[UpdateBy] [uniqueidentifier] NULL,
	[OwnerID] [uniqueidentifier] NULL,
	[IP] [varchar](50) NULL,
 CONSTRAINT [PK_tb_StoreUserProfile] PRIMARY KEY CLUSTERED 
(
	[ProfileID] 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].[tb_storeUserPackSpace]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_storeUserPackSpace](
	[ID] [uniqueidentifier] NOT NULL,
	[PackSpace] [bigint] NULL,
	[UseSpace] [bigint] NULL,
	[FreeSpace] [bigint] NULL,
	[PackName] [nvarchar](50) NULL,
	[CompanyPoliciPrice] [bigint] NULL,
	[PackDate] [datetime] NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
	[OwnerID] [uniqueidentifier] NULL,
 CONSTRAINT [PK_tb_storeUserPackSpace] PRIMARY KEY CLUSTERED 
(
	[ID] 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
/****** Object:  Table [dbo].[tb_storeUserPackDetail]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_storeUserPackDetail](
	[UserPackID] [uniqueidentifier] NULL,
	[PackID] [int] NULL,
	[UserID] [uniqueidentifier] NULL,
	[OwnerID] [uniqueidentifier] NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tb_StoreUserMaster]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_StoreUserMaster](
	[UserID] [uniqueidentifier] NOT NULL,
	[UserName] [nvarchar](50) NULL,
	[Password] [nvarchar](50) NULL,
	[OwnerID] [uniqueidentifier] NULL,
	[IsAactive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
	[IP] [nvarchar](50) NULL,
 CONSTRAINT [PK_tb_StoreUserMaster] PRIMARY KEY CLUSTERED 
(
	[UserID] 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
/****** Object:  Table [dbo].[tb_storePackMaster]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_storePackMaster](
	[PackID] [int] NOT NULL,
	[PackName] [nvarchar](50) NULL,
	[PackDurastion] [int] NULL,
	[PackFee] [decimal](18, 2) NULL,
	[PackScope] [bigint] NULL,
	[IsActive] [bit] NULL,
	[UpDateby] [bigint] NULL,
	[LastUpdate] [datetime] NULL,
 CONSTRAINT [PK_tb_storePackMaster] PRIMARY KEY CLUSTERED 
(
	[PackID] 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
/****** Object:  Table [dbo].[tb_storeItemPhotoGallery]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_storeItemPhotoGallery](
	[PhotoID] [uniqueidentifier] NOT NULL,
	[PhotoGalleryName] [nvarchar](500) NULL,
	[PhotoOne] [varchar](500) NULL,
	[Phototwo] [varchar](500) NULL,
	[PhotoThree] [varchar](500) NULL,
	[PhotoFour] [varchar](50) NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
	[ItemID] [uniqueidentifier] NULL,
	[OwnerID] [uniqueidentifier] NULL,
 CONSTRAINT [PK_tb_storeItemPhotoGallery] PRIMARY KEY CLUSTERED 
(
	[PhotoID] 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].[tb_StoreItemMaster]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_StoreItemMaster](
	[ItemID] [uniqueidentifier] NOT NULL,
	[ItemName] [nvarchar](200) NULL,
	[ItemShortName] [nvarchar](100) NULL,
	[ItemOurPrice] [decimal](18, 2) NULL,
	[ItemMarkitPrice] [decimal](18, 2) NULL,
	[ShowMarkitPrice] [bit] NULL,
	[ItemDescount] [decimal](18, 2) NULL,
	[ShowDescount] [bit] NULL,
	[ItemPhoto] [varchar](1000) NULL,
	[Comments] [nvarchar](max) NULL,
	[ItemInfo] [nvarchar](max) NULL,
	[OwnerID] [uniqueidentifier] NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
	[UpdateBy] [uniqueidentifier] NULL,
	[CatID] [bigint] NULL,
	[SubCatID] [bigint] NULL,
	[Keywords] [nvarchar](max) NULL,
	[NumberOfItme] [bigint] NULL,
	[CompanyBiil] [decimal](18, 2) NULL,
	[ItemTotalPrice] [decimal](18, 2) NULL,
	[ShowPrice] [bit] NULL,
	[IP] [varchar](50) NULL,
	[IsDelete] [bit] NULL,
	[ForMen] [bit] NULL,
	[ForWmen] [bit] NULL,
	[ForChild] [bit] NULL,
 CONSTRAINT [PK_tb_ItemMaster] PRIMARY KEY CLUSTERED 
(
	[ItemID] 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].[tb_storeIndustry]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_storeIndustry](
	[industryID] [bigint] NOT NULL,
	[industryName] [nvarchar](50) NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
 CONSTRAINT [PK_tb_storeindustry] PRIMARY KEY CLUSTERED 
(
	[industryID] 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
/****** Object:  Table [dbo].[tb_storeCompanyPolicies]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_storeCompanyPolicies](
	[CompanypolicID] [bigint] NOT NULL,
	[CompanypolicPrice] [int] NULL,
	[CompanypolicDetail] [nvarchar](max) NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
 CONSTRAINT [PK_tb_storeCompanyPolicies] PRIMARY KEY CLUSTERED 
(
	[CompanypolicID] 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
/****** Object:  Table [dbo].[tb_storeCatMaster]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_storeCatMaster](
	[CatID] [bigint] NOT NULL,
	[CatName] [nvarchar](50) NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
	[ParentID] [bigint] NULL,
	[IndustryID] [bigint] NULL,
 CONSTRAINT [PK_tb_storeCatMaster] PRIMARY KEY CLUSTERED 
(
	[CatID] 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
/****** Object:  Table [dbo].[tb_storeBuyerUserMaster]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_storeBuyerUserMaster](
	[BuyerID] [uniqueidentifier] NOT NULL,
	[BuyerFName] [nvarchar](200) NULL,
	[BuyerLName] [nvarchar](200) NULL,
	[BuyerEmailAddress] [varchar](100) NULL,
	[BuyerPassword] [nvarchar](50) NULL,
	[BuyerMobile] [varchar](50) NULL,
	[BuyerZipCode] [nvarchar](50) NULL,
	[BuyerState] [nvarchar](50) NULL,
	[BuyerCity] [nvarchar](50) NULL,
	[BuyerCountryID] [bigint] NULL,
	[BuyerAddress] [nvarchar](500) NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
	[IP] [varchar](50) NULL,
 CONSTRAINT [PK_tb_storeBuyerUserMaster] PRIMARY KEY CLUSTERED 
(
	[BuyerID] 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].[tb_storeAdminusermaster]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_storeAdminusermaster](
	[UserID] [uniqueidentifier] NOT NULL,
	[Name] [nvarchar](50) NULL,
	[UserName] [nvarchar](50) NULL,
	[Password] [nvarchar](50) NULL,
	[Email] [varchar](50) NULL,
	[Contact] [nvarchar](50) NULL,
	[Address] [nvarchar](500) NULL,
	[Comments] [nvarchar](500) NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
 CONSTRAINT [PK_tb_storeAdminusermaster] PRIMARY KEY CLUSTERED 
(
	[UserID] 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].[tb_SotrePaymentSystem]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_SotrePaymentSystem](
	[SystemID] [uniqueidentifier] NULL,
	[PayPalID] [nvarchar](500) NULL,
	[MasterCardNumber] [nvarchar](50) NULL,
	[VisaCardNumber] [nvarchar](50) NULL,
	[OwnerID] [bigint] NULL,
	[PaymentWithPayPal] [bit] NULL,
	[PayMentwithMasterCard] [bit] NULL,
	[PayMentwithVisaCard] [bit] NULL,
	[IsActive] [bit] NULL,
	[LastUPdate] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tb_ItemOrderDetail]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_ItemOrderDetail](
	[OrderID] [uniqueidentifier] NOT NULL,
	[ItemID] [nchar](10) NULL,
	[NumberOfItems] [bigint] NULL,
	[ItemPrice] [decimal](18, 2) NULL,
	[OwnerID] [uniqueidentifier] NULL,
	[OrderDate] [datetime] NULL,
	[LastUpdate] [datetime] NULL,
	[UpdateBy] [uniqueidentifier] NULL,
	[BuyerID] [uniqueidentifier] NULL,
 CONSTRAINT [PK_tb_ItemOrderDetail] PRIMARY KEY CLUSTERED 
(
	[OrderID] 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
/****** Object:  Table [dbo].[tb_BuyerBIllingAddress]    Script Date: 07/13/2011 17:53:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_BuyerBIllingAddress](
	[BIllingID] [uniqueidentifier] NOT NULL,
	[BIllingFName] [nvarchar](200) NULL,
	[BIllingLName] [nvarchar](200) NULL,
	[BIllingEmailAddress] [varchar](100) NULL,
	[OrderID] [uniqueidentifier] NULL,
	[BIllingMobile] [varchar](50) NULL,
	[BIllingZipCode] [nvarchar](50) NULL,
	[BIllingState] [nvarchar](50) NULL,
	[BIllingCity] [nvarchar](50) NULL,
	[BIllingCountryID] [bigint] NULL,
	[BIllingAddress] [nvarchar](500) NULL,
	[IsActive] [bit] NULL,
	[LastUpdate] [datetime] NULL,
	[IP] [varchar](50) NULL,
 CONSTRAINT [PK_tb_BuyerBIllingAddress] PRIMARY KEY CLUSTERED 
(
	[BIllingID] 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:  Default [DF_tb_BuyerBIllingAddress_IsActive]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_BuyerBIllingAddress] ADD  CONSTRAINT [DF_tb_BuyerBIllingAddress_IsActive]  DEFAULT ((1)) FOR [IsActive]
GO
/****** Object:  Default [DF_tb_storeAdminusermaster_Is_Active]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_storeAdminusermaster] ADD  CONSTRAINT [DF_tb_storeAdminusermaster_Is_Active]  DEFAULT ((1)) FOR [IsActive]
GO
/****** Object:  Default [DF_tb_storeBuyerUserMaster_IsActive]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_storeBuyerUserMaster] ADD  CONSTRAINT [DF_tb_storeBuyerUserMaster_IsActive]  DEFAULT ((1)) FOR [IsActive]
GO
/****** Object:  Default [DF_tb_storeCatMaster_IsActive]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_storeCatMaster] ADD  CONSTRAINT [DF_tb_storeCatMaster_IsActive]  DEFAULT ((1)) FOR [IsActive]
GO
/****** Object:  Default [DF_tb_ItemMaster_ShowMarkitPrice]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_StoreItemMaster] ADD  CONSTRAINT [DF_tb_ItemMaster_ShowMarkitPrice]  DEFAULT ((0)) FOR [ShowMarkitPrice]
GO
/****** Object:  Default [DF_Table_1_ShowdeSCOUNT]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_StoreItemMaster] ADD  CONSTRAINT [DF_Table_1_ShowdeSCOUNT]  DEFAULT ((0)) FOR [ShowDescount]
GO
/****** Object:  Default [DF_tb_ItemMaster_IsActive]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_StoreItemMaster] ADD  CONSTRAINT [DF_tb_ItemMaster_IsActive]  DEFAULT ((1)) FOR [IsActive]
GO
/****** Object:  Default [DF_Table_1_ShowPrice]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_StoreItemMaster] ADD  CONSTRAINT [DF_Table_1_ShowPrice]  DEFAULT ((1)) FOR [ShowPrice]
GO
/****** Object:  Default [DF_tb_StoreItemMaster_IsDelete]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_StoreItemMaster] ADD  CONSTRAINT [DF_tb_StoreItemMaster_IsDelete]  DEFAULT ((1)) FOR [IsDelete]
GO
/****** Object:  Default [DF_tb_StoreItemMaster_ForMen]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_StoreItemMaster] ADD  CONSTRAINT [DF_tb_StoreItemMaster_ForMen]  DEFAULT ((0)) FOR [ForMen]
GO
/****** Object:  Default [DF_tb_StoreItemMaster_ForWmen]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_StoreItemMaster] ADD  CONSTRAINT [DF_tb_StoreItemMaster_ForWmen]  DEFAULT ((0)) FOR [ForWmen]
GO
/****** Object:  Default [DF_tb_storeItemPhotoGallery_IsActive]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_storeItemPhotoGallery] ADD  CONSTRAINT [DF_tb_storeItemPhotoGallery_IsActive]  DEFAULT ((1)) FOR [IsActive]
GO
/****** Object:  Default [DF_tb_storePackMaster_Is_Active]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_storePackMaster] ADD  CONSTRAINT [DF_tb_storePackMaster_Is_Active]  DEFAULT ((1)) FOR [IsActive]
GO
/****** Object:  Default [DF_Table_1_IS_Aactive]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_StoreUserMaster] ADD  CONSTRAINT [DF_Table_1_IS_Aactive]  DEFAULT ((1)) FOR [IsAactive]
GO
/****** Object:  Default [DF_tb_storeUserPackDetail_IsActive]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_storeUserPackDetail] ADD  CONSTRAINT [DF_tb_storeUserPackDetail_IsActive]  DEFAULT ((1)) FOR [IsActive]
GO
/****** Object:  Default [DF_tb_storeUserPackSpace_IsActive]    Script Date: 07/13/2011 17:53:21 ******/
ALTER TABLE [dbo].[tb_storeUserPackSpace] ADD  CONSTRAINT [DF_tb_storeUserPackSpace_IsActive]  DEFAULT ((1)) FOR [IsActive]
GO