soha-db-2

USE [soha]
GO
/****** Object:  Table [dbo].[Transactions]    Script Date: 07/15/2013 14:08:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Transactions](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [TransactionID] [CHAR](50) NULL,
    [BookID] [INT] NULL,
    [DateTime] [datetime] NULL,
    [Username] [CHAR](20) NULL,
    [ReferrerURL] [NCHAR](500) NULL,
    [CustomerIP] [CHAR](15) NULL,
    [RegisterDate] [datetime] NULL,
 CONSTRAINT [PK_Transactions] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Reviews]    Script Date: 07/15/2013 14:08:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Reviews](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [BookID] [INT] NULL,
    [Username] [INT] NULL,
    [Comment] [nvarchar](MAX) NULL,
    [Rate] [DECIMAL](18, 0) NULL,
    [RegisterDate] [smalldatetime] NULL,
    [RegisterDateHijri] [NCHAR](20) NULL,
 CONSTRAINT [PK_Reviews] 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].[News]    Script Date: 07/15/2013 14:08:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[News](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [Title] [NCHAR](30) NULL,
    [Text] [nvarchar](MAX) NULL,
    [RegisterDate] [smalldatetime] NULL,
    [RegisterDateHijri] [NCHAR](30) NULL,
    [Author] [NCHAR](20) NULL,
 CONSTRAINT [PK_News] 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].[GlobalSettings]    Script Date: 07/15/2013 14:08:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GlobalSettings](
    [PriceRate] [DECIMAL](18, 0) NULL,
    [ImportantMessage] [nvarchar](50) NULL,
    [ImportantMessageVisibility] [bit] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Categories]    Script Date: 07/15/2013 14:08:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Categories](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [category] [NCHAR](25) NULL,
 CONSTRAINT [PK_Categories] 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