/****** Object:  Table [dbo].[User]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[User](
	[Cod] [int] NOT NULL,
	[FirstName] [varchar](32) NULL,
	[LastName] [varchar](32) NULL,
	[Father] [varchar](32) NULL,
	[Male] [bit] NOT NULL,
	[Birth] [char](10) NULL,
	[Degree] [varchar](32) NULL,
	[Job] [varchar](32) NULL,
	[StateCod] [int] NULL,
	[City] [varchar](16) NULL,
	[Address] [varchar](128) NULL,
	[Postal] [varchar](16) NULL,
	[Phone] [varchar](16) NULL,
	[Mobile] [varchar](16) NULL,
	[Relation] [varchar](16) NULL,
	[Email] [varchar](32) NULL,
	[User] [varchar](16) NULL,
	[Pass] [varchar](16) NULL,
	[GetEmail] [bit] NOT NULL,
	[GetSMS] [bit] NOT NULL,
	[GetMonthly] [bit] NOT NULL,
	[Money] [money] NULL,
	[Added] [bit] NOT NULL,
	[EntryDate] [char](10) NULL,
	[Vijeh] [int] NULL,
	[Post] [char](1) NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [User_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[User] ([Cod], [FirstName], [LastName], [Father], [Male], [Birth], [Degree], [Job], [StateCod], [City], [Address], [Postal], [Phone], [Mobile], [Relation], [Email], [User], [Pass], [GetEmail], [GetSMS], [GetMonthly], [Money], [Added], [EntryDate], [Vijeh], [Post], [CreateDate]) VALUES (101, N'مدير', N'ارشد', N'', 1, N'          ', N'', N'', 9, N'قم', N'سايت', N'', N'سايت', N'', N'', N'', N'admin', N'ur-pZw1BtN', 1, 1, 1, 0.0000, 1, N'1389/03/28', 0, N'A', CAST(0x00009D9901288164 AS DateTime))
/****** Object:  Table [dbo].[Type]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Type](
	[Cod] [int] NOT NULL,
	[Title] [varchar](16) NULL,
	[Vijeh] [int] NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [Type_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[Type] ([Cod], [Title], [Vijeh], [CreateDate]) VALUES (1, N'كتاب', 0, CAST(0x00009B84012B8BFC AS DateTime))
INSERT [dbo].[Type] ([Cod], [Title], [Vijeh], [CreateDate]) VALUES (2, N'نشريه', 0, CAST(0x00009B84012B9304 AS DateTime))
INSERT [dbo].[Type] ([Cod], [Title], [Vijeh], [CreateDate]) VALUES (3, N'لوح فشرده', 0, CAST(0x00009B84012B9C64 AS DateTime))
INSERT [dbo].[Type] ([Cod], [Title], [Vijeh], [CreateDate]) VALUES (4, N'بازي', 0, CAST(0x00009C06014A69CF AS DateTime))
INSERT [dbo].[Type] ([Cod], [Title], [Vijeh], [CreateDate]) VALUES (5, N'گزارشات', 1, CAST(0x00009D6B00F2C5DB AS DateTime))
INSERT [dbo].[Type] ([Cod], [Title], [Vijeh], [CreateDate]) VALUES (6, N'تست نوع', 0, CAST(0x00009D6C00FAC246 AS DateTime))
/****** Object:  Table [dbo].[tmpUser]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tmpUser](
	[EmCod] [varchar](16) NULL,
	[Pass] [char](4) NULL,
	[Name] [varchar](255) NULL,
	[Family] [varchar](255) NULL,
	[Grade] [varchar](255) NULL,
	[Phone] [varchar](64) NULL,
	[Mobile] [varchar](64) NULL,
	[Email] [varchar](255) NULL,
	[PostCod] [varchar](16) NULL,
	[StateCod] [int] NULL,
	[City] [varchar](255) NULL,
	[Address] [varchar](255) NULL,
	[Kharid] [bit] NULL,
	[Baaz] [bit] NULL,
	[BaazDate] [smalldatetime] NULL,
	[Usered] [bit] NULL,
	[Tried] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[tmpUser] ([EmCod], [Pass], [Name], [Family], [Grade], [Phone], [Mobile], [Email], [PostCod], [StateCod], [City], [Address], [Kharid], [Baaz], [BaazDate], [Usered], [Tried]) VALUES (N'20006', N'3446', NULL, N'عرب هدي', NULL, NULL, N'09130005893', NULL, NULL, 26, NULL, N'?رمان جيرفت خ مال? ', 0, 0, NULL, 0, 0)
/****** Object:  Table [dbo].[SubjUser]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SubjUser](
	[UserCod] [int] NULL,
	[SubjectCod] [int] NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[SubjUser] ([UserCod], [SubjectCod], [CreateDate]) VALUES (100, 3, CAST(0x00009C0D00F7A81A AS DateTime))
INSERT [dbo].[SubjUser] ([UserCod], [SubjectCod], [CreateDate]) VALUES (100, 5, CAST(0x00009C0D00F7A81A AS DateTime))
INSERT [dbo].[SubjUser] ([UserCod], [SubjectCod], [CreateDate]) VALUES (100, 4, CAST(0x00009C0D00F7A831 AS DateTime))
/****** Object:  Table [dbo].[SubjProd]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SubjProd](
	[ProductCod] [int] NULL,
	[SubjectCod] [int] NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1000, 10, CAST(0x00009BE7006C4319 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1001, 1, CAST(0x00009BE60173F586 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1001, 5, CAST(0x00009BE60173F599 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1000, 5, CAST(0x00009BE7006C4331 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1002, 10, CAST(0x00009C0601509F9A AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1002, 12, CAST(0x00009C0601509F9F AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1003, 5, CAST(0x00009C1A00DD0D59 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1003, 2, CAST(0x00009C1A00DD0D83 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1003, 10, CAST(0x00009C1A00DD0D9B AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1003, 12, CAST(0x00009C1A00DD0DB2 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1007, 1, CAST(0x00009D6900F1E689 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1004, 2, CAST(0x00009D1F01098D8F AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1008, 14, CAST(0x00009D6B00F86BF8 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1009, 5, CAST(0x00009D6C00FF8010 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1009, 1, CAST(0x00009D6C00FF8010 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1008, 13, CAST(0x00009D7100F220F4 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1008, 10, CAST(0x00009D7100F3EB74 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1010, 15, CAST(0x00009D7400FC5F53 AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1005, 9, CAST(0x00009D600168D84C AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1005, 12, CAST(0x00009D600168D84F AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1005, 1, CAST(0x00009D600168D84F AS DateTime))
INSERT [dbo].[SubjProd] ([ProductCod], [SubjectCod], [CreateDate]) VALUES (1005, 5, CAST(0x00009D600168D851 AS DateTime))
/****** Object:  Table [dbo].[Subject]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Subject](
	[Cod] [int] NOT NULL,
	[Title] [varchar](32) NULL,
	[Position] [varchar](128) NULL,
	[GrandCod] [int] NULL,
	[Tartib] [int] NULL,
	[Vijeh] [int] NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [Subject_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (1, N'اولين موضوع', N'0', 0, NULL, 0, CAST(0x00009BC20101B638 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (2, N'تست2', N'5-9-2', 5, NULL, 0, CAST(0x00009BC20101BD40 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (5, N'دومين موضوع', N'0', 0, NULL, 0, CAST(0x00009BC20101CB50 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (8, N'تست8', N'5-9-2-8', 5, NULL, 0, CAST(0x00009BC20101DBB8 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (9, N'تست9', N'5-9', 5, NULL, 0, CAST(0x00009BC20101E068 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (10, N'تست10', N'5-9-2-8-10', 5, NULL, 0, CAST(0x00009BC20101E644 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (12, N'سومين موضوع', N'0', 0, NULL, 0, CAST(0x00009BC20101F0D0 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (13, N'عنوان جديد', N'5-9-2-13', 5, NULL, 0, CAST(0x00009C14016B2FB3 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (14, N'موضوع محرمانه', N'0', 0, NULL, 1, CAST(0x00009D6A00F0366C AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (15, N'زيرمحرمانه1', N'12-15', 12, NULL, 1, CAST(0x00009D6A00F25838 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (16, N'زيرمحرمانه2', N'5-9-2-13-16', 5, NULL, 1, CAST(0x00009D6A00F276C3 AS DateTime))
INSERT [dbo].[Subject] ([Cod], [Title], [Position], [GrandCod], [Tartib], [Vijeh], [CreateDate]) VALUES (17, N'نجات بشر', N'1-17', 1, NULL, 1, CAST(0x00009D6E010CF3DA AS DateTime))
/****** Object:  Table [dbo].[State]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[State](
	[Cod] [int] NOT NULL,
	[Title] [varchar](32) NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [State_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (1, N'اردبيل', CAST(0x00009B8300AF36B0 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (2, N'آذربايجان غربي', CAST(0x00009B8300AF3B60 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (3, N'آذربايجان شرقي', CAST(0x00009B8300AF44C0 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (4, N'بوشهر', CAST(0x00009B8300AF45EC AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (5, N'چهارمحال و بختياري', CAST(0x00009B8300AF4718 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (6, N'اصفهان', CAST(0x00009B8300AF4718 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (7, N'فارس', CAST(0x00009B8300AF4844 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (8, N'قزوين', CAST(0x00009B8300AF4844 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (9, N'قم', CAST(0x00009B8300AF4844 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (10, N'گلستان', CAST(0x00009B8300AF4970 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (11, N'گيلان', CAST(0x00009B8300AF4970 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (12, N'همدان', CAST(0x00009B8300AF4CF4 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (13, N'هرمزگان', CAST(0x00009B8300AF4E20 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (14, N'ايلام', CAST(0x00009B8300AF4F4C AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (15, N'كردستان', CAST(0x00009B8300AF4F4C AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (16, N'كرمان', CAST(0x00009B8300AF5078 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (17, N'كرمانشاه', CAST(0x00009B8300AF51A4 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (18, N'كهكيلويه و بويراحمد', CAST(0x00009B8300AF51A4 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (19, N'خراسان رضوي', CAST(0x00009B8300AF53FC AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (20, N'خوزستان', CAST(0x00009B8300AF5654 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (21, N'مازندران', CAST(0x00009B8300AF5780 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (22, N'لرستان', CAST(0x00009B8300AF58AC AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (23, N'مركزي', CAST(0x00009B8300AF58AC AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (24, N'سيستان و بلوچستان', CAST(0x00009B8300AF59D8 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (25, N'سمنان', CAST(0x00009B8300AF5B04 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (26, N'تهران', CAST(0x00009B8300AF5E88 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (27, N'يزد', CAST(0x00009B8300AF60E0 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (28, N'زنجان', CAST(0x00009B8300AF620C AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (29, N'خراسان شمالي', CAST(0x00009BF800694B07 AS DateTime))
INSERT [dbo].[State] ([Cod], [Title], [CreateDate]) VALUES (30, N'خراسان جنوبي', CAST(0x00009BF800695EBB AS DateTime))
/****** Object:  Table [dbo].[Setting]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Setting](
	[IDN] [varchar](8) NOT NULL,
	[Valu] [varchar](64) NULL,
	[Comm] [varchar](128) NULL,
 CONSTRAINT [Setting_pk] PRIMARY KEY CLUSTERED 
(
	[IDN] 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
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'AddGram', N'100', N'پست: عمومي - وزن تخميني بسته‌بندي براي هر مرسوله به گرم (100)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'AvarezP', N'3', N'پست: عمومي - درصد عوارض (3)‏‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'BestCnt', N'7', N'تعداد: عناوين در حال نمايش - صفحه اصلي - پرفروش‏ترين محصولات')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'BpicWith', N'400', N'تصوير محصول: عرض تصوير - تصوير بزرگ (400)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'FrstMony', N'0', N'مبلغ: موجودي اوليه هنگام عضويت در سايت')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'IsSale', N'Yes', N'فروش: در صورت No بودن سامانه فروش به صورت ?امل پنهان مي‌شود')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'KisePay', N'3200', N'پست: عمومي - ثبت كيسه بالاي 5 كيلو (3200)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'KoolAll', N'120000', N'باشگاه محصولات فرهنگي امين: كل پرداختي به هر كاربر')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'KoolEdat', N'1389/02/01', N'باشگاه محصولات فرهنگي امين: تاريخ پايان مهلت عضويت (س4/م2/ر2)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'KoolMaah', N'12', N'باشگاه محصولات فرهنگي امين: تعداد ماه‏هاي پرداخت به هر كاربر')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'KoolSale', N'30000', N'باشگاه محصولات فرهنگي امين: هزينه عضويت (از موجودي كسر مي‏شود)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'KoolSdat', N'1388/02/01', N'باشگاه محصولات فرهنگي امين: تاريخ آغاز پرداخت‏ها (س4/م2/ر2)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'ListsCnt', N'7', N'تعداد: عناوين در حال نمايش - تمامي فهرست‏ها')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'LockTime', N'10', N'قفل: مدت زمان قفل بودن شناسه كاربري به دقيقه')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'MailHost', N'127.0.0.1', N'عنوان: نشاني سرور ايميل براي ارسال ايميل از طريق آن')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'MailPass', N'000', N'عنوان: رمز ايميل خودكار سايت')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'MaxDef', N'1024', N'متن: حداكثر حروف مجاز براي متن معرفي هر محصول (1024)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'MaxTry', N'3', N'قفل: تعداد تلاش كاربر در ورود رمز نادرست براي قفل شدن شناسه')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'MaxTXT', N'4096', N'متن: حداكثر تعداد حروف در فيلدهاي متني هر محصول (4096)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'MpicWith', N'200', N'تصوير محصول: عرض تصوير - تصوير متوسط (200)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'NewCnt', N'2', N'تعداد: عناوين در حال نمايش - صفحه اول - جديدترين محصولات')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'NewsCnt', N'4', N'تعداد: عناوين در حال نمايش - صفحه اول - اخبار')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PageCnt', N'10', N'تعداد: شماره صفحات - فهرست‏هاي چند صفحه‏اي')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PakPrice', N'2000', N'پست: هزينه بسته‏بندي هر محصول قبل از ارسال (ريال)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PayVaght', N'40', N'مبلغ: فرصت كاربر براي تكميل پرداخت آن‌لاين به دقيقه')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Pish100g', N'1600', N'پست: پيشتاز - افزايش گرمي - مازاد 100 گرم - به ازاي هر 100 گرم (1600)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Pish1kg', N'6300', N'پست: پيشتاز - افزايش گرمي - مازاد 1000 گرم - به ازاي هر 1000 گرم (6300)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Pish20g', N'1100', N'پست: پيشتاز - افزايش گرمي - مازاد 20 گرم (1100)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Pish50g', N'1050', N'پست: پيشتاز - افزايش گرمي - مازاد 50 گرم (1050)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PishBase', N'4200', N'پست: پيشتاز - نرخ پايه (4200)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PishIdle', N'200', N'پست: پيشتاز - خارج وقت اداري (200)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PishKray', N'25', N'پست: عمومي - درصد كرايه پستي (25)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PishSabt', N'1700', N'پست: پيشتاز - حق ثبت (1700)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PishShab', N'100', N'پست: پيشتاز - هنگام شب (100)‏‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PishTozi', N'60', N'پست: پيشتاز - حق توزيع (60)‏‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'PrnLists', N'5', N'تعداد: عناوين در حال نمايش - فهرست‏ها - هر صفحه كاغذ هنگام پرينت')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SamanCod', N'000000', N'مبلغ: كد پذيرنده در بانك سامان جهت پرداخت الكترونيكي')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SamanPas', N'000', N'مبلغ: رمز خدمات اينترنتي سامانه بانك سامان')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Sef1kg', N'200', N'پست: سفارشي - افزايش گرمي - مازاد 1000 گرم (200)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Sef20g', N'100', N'پست: سفارشي - افزايش گرمي - مازاد 20 گرم (100)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Sef250g', N'100', N'پست: سفارشي - افزايش گرمي - مازاد 250 گرم (100)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Sef2Ghbz', N'3000', N'پست: سفارشي - دو قبضه - حق ثبت قبض دوم (3000)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Sef2kg', N'320', N'پست: سفارشي - افزايش گرمي - مازاد 2000 گرم - به ازاي هر 2000 گرم (320)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Sef2kgB', N'420', N'پست: سفارشي - افزايش گرمي - مازاد 2000 گرم - افزايش بين‏شهري (420)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SefBase', N'300', N'پست: سفارشي - نرخ پايه (300)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SefBein', N'350', N'پست: سفارشي - افزايش بين‏شهري (350)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SefExp2k', N'300', N'پست: سفارشي - حق اكسپرس - افزايش گرمي - مازاد 2000 گرم - به ازاي هر 2000 گرم (300)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SefExpr', N'2100', N'پست: سفارشي - حق اكسپرس (2100)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SefSefar', N'3700', N'پست: سفارشي - حق سفارش (3700)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SiteEn', N'Self Management Shop', N'عنوان: عنوان انگليسي سايت')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SiteMail', N'autopost@sms.ir', N'عنوان: نشاني ايميل سايت براي ارسال خودكار ايميل‌ها')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SiteName', N'فروشگاه فرهنگي ما', N'عنوان: عنوان فارسي سايت')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SpicWith', N'90', N'تصوير محصول: عرض تصوير - تصوير كوچك (90)‏')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SrchCnt', N'5', N'تعداد: جستجو - نتايج اجمالي')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SrchCut', N'50', N'تعداد: جستجو - نتايج اجمالي - كاراكترها')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'Stop', N'No', N'قفل: در صورت No بودن سايت فعّال بوده و اگر Yes شود سايت متوقف مي‏شود')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'SubjCol', N'3', N'تعداد: صفحه عضويت - ستون‏هاي موضوعات')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'CntCpn', N'20', N'فروش: درصد تخفيف كوپن - به درصد - بدون علامت درصد')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'AzCpn', N'0', N'فروش: شماره آغاز كوپن تخفيف حداكثر 8 رقم')
INSERT [dbo].[Setting] ([IDN], [Valu], [Comm]) VALUES (N'TaCpn', N'1000', N'فروش: شماره پايان كوپن تخفيف حداكثر 8 رقم')
/****** Object:  Table [dbo].[Selected]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Selected](
	[ProductCod] [int] NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Selected] ([ProductCod], [CreateDate]) VALUES (1002, CAST(0x00009C39005992B7 AS DateTime))
INSERT [dbo].[Selected] ([ProductCod], [CreateDate]) VALUES (1001, CAST(0x00009C39005999BB AS DateTime))
INSERT [dbo].[Selected] ([ProductCod], [CreateDate]) VALUES (1004, CAST(0x00009D1F010D5A3F AS DateTime))
INSERT [dbo].[Selected] ([ProductCod], [CreateDate]) VALUES (1007, CAST(0x00009D67010FA763 AS DateTime))
/****** Object:  Table [dbo].[Sale]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Sale](
	[ProductCod] [int] NULL,
	[UserCod] [int] NULL,
	[Tedad] [int] NULL,
	[Price] [money] NULL,
	[PostType] [int] NULL,
	[BasketDate] [char](10) NULL,
	[Order] [bit] NOT NULL,
	[OrderDate] [char](10) NULL,
	[Recieve] [bit] NOT NULL,
	[RecieveDate] [char](10) NULL,
	[Send] [bit] NOT NULL,
	[SendDate] [char](10) NULL,
	[Finish] [bit] NOT NULL,
	[FinishDate] [char](10) NULL,
	[Reject] [bit] NOT NULL,
	[RejectDate] [char](10) NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Sale] ([ProductCod], [UserCod], [Tedad], [Price], [PostType], [BasketDate], [Order], [OrderDate], [Recieve], [RecieveDate], [Send], [SendDate], [Finish], [FinishDate], [Reject], [RejectDate], [CreateDate]) VALUES (1001, 100, 1, 21400.0000, NULL, N'1388/01/22', 1, N'1388/01/22', 1, N'1388/01/22', 1, N'1388/01/31', 1, N'1388/01/31', 1, NULL, CAST(0x00009BE800D9F16D AS DateTime))
INSERT [dbo].[Sale] ([ProductCod], [UserCod], [Tedad], [Price], [PostType], [BasketDate], [Order], [OrderDate], [Recieve], [RecieveDate], [Send], [SendDate], [Finish], [FinishDate], [Reject], [RejectDate], [CreateDate]) VALUES (1001, 100, 2, 20000.0000, 1, N'1388/06/13', 1, N'1388/06/13', 1, N'1388/06/13', 1, N'1388/06/13', 1, N'1388/06/13', 1, NULL, CAST(0x00009C7A005FC04F AS DateTime))
INSERT [dbo].[Sale] ([ProductCod], [UserCod], [Tedad], [Price], [PostType], [BasketDate], [Order], [OrderDate], [Recieve], [RecieveDate], [Send], [SendDate], [Finish], [FinishDate], [Reject], [RejectDate], [CreateDate]) VALUES (1001, 100, 1, 11000.0000, 1, N'1388/06/13', 1, N'1388/06/13', 1, N'1388/06/13', 1, N'1388/06/13', 1, N'1388/06/13', 1, NULL, CAST(0x00009C7A006DBC5A AS DateTime))
/****** Object:  Table [dbo].[Rent]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Rent](
	[ProductCod] [int] NULL,
	[UserCod] [int] NULL,
	[OrderDate] [char](10) NULL,
	[Recieve] [bit] NOT NULL,
	[RecieveDate] [char](10) NULL,
	[Send] [bit] NOT NULL,
	[SendDate] [char](10) NULL,
	[Stay] [bit] NOT NULL,
	[StayDate] [char](10) NULL,
	[Back] [bit] NOT NULL,
	[BackDate] [char](10) NULL,
	[Finish] [bit] NOT NULL,
	[FinishDate] [char](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Product]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Product](
	[Cod] [int] NOT NULL,
	[TypeCod] [int] NULL,
	[Title] [varchar](128) NULL,
	[AuthorCod] [int] NULL,
	[Stock] [int] NULL,
	[LastPrice] [money] NULL,
	[Price] [money] NULL,
	[Weight] [int] NULL,
	[SaleCount] [int] NULL,
	[Rent] [bit] NOT NULL,
	[RentCount] [int] NULL,
	[Vijeh] [int] NULL,
	[Del] [bit] NOT NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [Product_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1000, 1, N'تست عنوان مي شود', 1, 3, 0.0000, 8900.0000, 10, 2, 0, NULL, 1, 0, CAST(0x00009BC6012B764D AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1001, 1, N'كتاب شماره دو', 1, 20, 9080.0000, 9000.0000, 90, 7, 0, NULL, 0, 0, CAST(0x00009BD00057700E AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1002, 4, N'راهي به سوي آينده', 1, 90, 8900.0000, 7000.0000, 120, NULL, 0, NULL, 0, 0, CAST(0x00009C06014B8143 AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1003, 4, N'لثقفل ث قث', 2, 2, 656.0000, 45646.0000, 60, 1, 0, NULL, 0, 0, CAST(0x00009C14016BE9E6 AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1004, 1, N'اينجا بهشت است', 2, 90, 900.0000, 1000.0000, 12, NULL, 0, NULL, 0, 0, CAST(0x00009D1F0109291A AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1005, 1, N'در ناكجا آباد بمان براي هميشه', 2, 1, 1500.0000, 1000.0000, 100, NULL, 0, NULL, 0, 0, CAST(0x00009D34007E65F2 AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1006, 1, N'اين يك محصول محرمانه و ويژه است', 1, 7, 1500.0000, 1000.0000, 100, NULL, 0, NULL, 1, 0, CAST(0x00009D6700F6A1F1 AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1007, 2, N'اين هم نشريه محرمانه', 1, 1, 1500.0000, 1000.0000, 100, NULL, 0, NULL, 1, 0, CAST(0x00009D6700F7887B AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1008, 5, N'تحليل اطلاعات سميم', 2, 1, 1500.0000, 1000.0000, 100, NULL, 0, NULL, 0, 0, CAST(0x00009D6B00F80A4F AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1009, 6, N'يك محصول داراي فيلد محرمانه', 1, 1, 1500.0000, 1000.0000, 100, NULL, 0, NULL, 0, 0, CAST(0x00009D6C00FF4316 AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1010, 6, N'تست فيلد صوتي', 1, 1, 1.0000, 2.0000, 1, NULL, 0, NULL, 0, 0, CAST(0x00009D7400FAE50F AS DateTime))
INSERT [dbo].[Product] ([Cod], [TypeCod], [Title], [AuthorCod], [Stock], [LastPrice], [Price], [Weight], [SaleCount], [Rent], [RentCount], [Vijeh], [Del], [CreateDate]) VALUES (1011, 6, N'دومين محصول ضميمه‌اي', 2, 6, 7000.0000, 6000.0000, 67, NULL, 0, NULL, 1, 0, CAST(0x00009D7F00C773AC AS DateTime))
/****** Object:  Table [dbo].[PayType]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PayType](
	[Cod] [int] NOT NULL,
	[Title] [varchar](32) NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [PayType_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[PayType] ([Cod], [Title], [CreateDate]) VALUES (1, N'فيش بانكي', CAST(0x00009B900074B3C8 AS DateTime))
INSERT [dbo].[PayType] ([Cod], [Title], [CreateDate]) VALUES (2, N'باشگاه محصولات فرهنگي امين', CAST(0x00009B900074B74C AS DateTime))
INSERT [dbo].[PayType] ([Cod], [Title], [CreateDate]) VALUES (3, N'هديه سايت', CAST(0x00009B900074BE54 AS DateTime))
INSERT [dbo].[PayType] ([Cod], [Title], [CreateDate]) VALUES (4, N'پرداخت پيش از عضويت', CAST(0x00009BD60082FD17 AS DateTime))
INSERT [dbo].[PayType] ([Cod], [Title], [CreateDate]) VALUES (5, N'پرداخت اينترنتي', CAST(0x00009D76007E4C3F AS DateTime))
/****** Object:  Table [dbo].[News]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[News](
	[Cod] [int] NOT NULL,
	[Title] [varchar](128) NULL,
	[Lead] [varchar](max) NULL,
	[Text] [varchar](max) NULL,
	[NewsDate] [char](10) NULL,
	[Show] [bit] NOT NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [News_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[News] ([Cod], [Title], [Lead], [Text], [NewsDate], [Show], [CreateDate]) VALUES (1, N'افتتاح پايگاه اينترنتي ما از نيمه دوم فروردين', N'پايگاه مركز ارتباطات فرهنگي ما، از پانزدهم فروردين 1388 افتتاح و آغاز به كار مي‏كند.', N'شما مي‏توانيد از اين تاريخ با مراجعه به اين پايگاه، ضمن آشنايي با مركز ارتباطات فرهنگي ما و همچنين باشگاه محصولات فرهنگي امين، اطلاعات كاملي از ناب‏ترين محصولات فرهنگي به دست آوريد.بيسب', N'1387/12/17', 0, CAST(0x00009BBE00E3F760 AS DateTime))
INSERT [dbo].[News] ([Cod], [Title], [Lead], [Text], [NewsDate], [Show], [CreateDate]) VALUES (2, N'راه‏اندازي سامانه كنترل رفتار مديران', N'سامانه كنترل رفتار مديران سايت به راه افتاد. در اين سامانه كه به هدف مديريت رفتار و كنترل امنيت سايت ايجاد شده است، تمامي فعاليت‏هاي انجام گرفته به صورت كاملا فيزيكي ذخيره سازي مي شود.', N'در اين سامانه تمامي رفتار مديران در سايت و فعاليت‏هايشان به صورت خودكار ذخيره‏سازي شده و در بانك نگهداري مي‏شود.
بدين ترتيب در صورت هر گونه خطا در سيستم مي‏توان شخص خاطي يا هكر وارد شده به سيستم را شناسايي كرد.', N'1388/01/12', 1, CAST(0x00009BC900FD8B01 AS DateTime))
INSERT [dbo].[News] ([Cod], [Title], [Lead], [Text], [NewsDate], [Show], [CreateDate]) VALUES (5, N'تست خبر', N'اين فقط تست بخر است', N'<p>سلام اين فقطتست خبر است</p>
<p><del>سلام اين فقطتست خبر است</del></p>
<p dir="rtl"><span style="font-size: large;"><span style="font-family: arial black,avant garde;">سلام اين فقطتست خبر است</span></span></p>
<p><span style="color: #ffcc00;">سلام اين فقطتست خبر است</span></p>
<p dir="rtl"><span style="background-color: #ffcc00;">سلام اين فقطتست خبر است</span></p>
<p>&nbsp;</p>', N'1388/11/24', 1, CAST(0x00009D1C010C60F7 AS DateTime))
INSERT [dbo].[News] ([Cod], [Title], [Lead], [Text], [NewsDate], [Show], [CreateDate]) VALUES (6, N'اين تس آي اي است', N'خبر جديد است كه مي  نويسم

', N'<p><span style="font-size: large;">سلام اي مثلا خحبر است</span></p>
<p><span style="font-size: large;">سلام اي مثلا خحبر است<a href=" شيسبيس بسبسيب"><img title="Logo 1" src="media/logo.jpg" alt="Logo 1" width="250" height="48" /></a></span></p>
<p><span style="font-size: large;">سلام اي مثلا خحبر است</span></p>
<p><span style="font-size: large;">سلام اي مثلا خحبر است</span></p>', N'1388/11/24', 1, CAST(0x00009D1C010CF42F AS DateTime))
/****** Object:  Table [dbo].[Nazar]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Nazar](
	[Cod] [int] NOT NULL,
	[ProductCod] [int] NULL,
	[Name] [varchar](30) NULL,
	[Email] [varchar](30) NULL,
	[Tozih] [varchar](255) NULL,
	[rOK] [int] NULL,
	[rNO] [int] NULL,
	[NazCod] [int] NULL,
	[Tarikh] [varchar](32) NULL,
	[IP] [varchar](15) NULL,
	[Sho] [smallint] NULL,
	[Del] [smallint] NULL,
 CONSTRAINT [Nazar_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[Nazar] ([Cod], [ProductCod], [Name], [Email], [Tozih], [rOK], [rNO], [NazCod], [Tarikh], [IP], [Sho], [Del]) VALUES (24, 1001, N'سيدمهدي', N'مهدي@تهران.ايران', N'با سلام', 0, 0, -1, N'1388/01/22', N'127.0.0.1', 0, 0)
INSERT [dbo].[Nazar] ([Cod], [ProductCod], [Name], [Email], [Tozih], [rOK], [rNO], [NazCod], [Tarikh], [IP], [Sho], [Del]) VALUES (25, 1001, N'مدير سايت', N'مدير@سايت.ايران', N'سلام', 0, 0, 4, N'1388/01/22', N'127.0.0.1', 0, 0)
/****** Object:  Table [dbo].[LogU]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LogU](
	[User] [varchar](16) NULL,
	[Whn] [char](10) NULL,
	[Whr] [char](15) NULL,
	[Agent] [varchar](256) NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[LogU] ([User], [Whn], [Whr], [Agent], [CreateDate]) VALUES (N'movashah', N'1389/03/02', N'127.0.0.1      ', N'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Win64; x64; Trident/4.0; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) (non', CAST(0x00009D7F00AE16EB AS DateTime))
/****** Object:  Table [dbo].[LogP]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LogP](
	[UserCod] [int] NULL,
	[ProductCod] [int] NULL,
	[Whn] [char](10) NULL,
	[Whr] [char](15) NULL,
	[Agent] [varchar](256) NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[LogP] ([UserCod], [ProductCod], [Whn], [Whr], [Agent], [CreateDate]) VALUES (0, 1009, N'1389/03/23', N'127.0.0.1      ', N'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Win64; x64; Trident/4.0; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) (non', CAST(0x00009D940166868D AS DateTime))
/****** Object:  Table [dbo].[LogC]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LogC](
	[UserCod] [int] NULL,
	[Coupon] [int] NULL,
	[Price] [money] NULL,
	[Takhfif] [money] NULL,
	[Whn] [char](10) NULL,
	[Whr] [char](15) NULL,
	[Agent] [varchar](256) NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[LogA]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LogA](
	[UserCod] [int] NULL,
	[UserPost] [char](1) NULL,
	[Wht] [varchar](128) NULL,
	[Whn] [char](10) NULL,
	[Whr] [char](15) NULL,
	[Agent] [varchar](256) NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[LogA] ([UserCod], [UserPost], [Wht], [Whn], [Whr], [Agent], [CreateDate]) VALUES (100, N'A', N'حذف كامل خبر شماره «4» از سايت', N'1389/03/28', N'127.0.0.1      ', N'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Win64; x64; Trident/4.0; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) (non', CAST(0x00009D99012C589D AS DateTime))
INSERT [dbo].[LogA] ([UserCod], [UserPost], [Wht], [Whn], [Whr], [Agent], [CreateDate]) VALUES (100, N'A', N'اضافه درباره «Jomleh» به درباره‌ها', N'1390/08/24', N'::1            ', N'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MASM; .NET4.0C; .NET4.0E; InfoPath.3)', CAST(0x00009F9C015B6624 AS DateTime))
/****** Object:  Table [dbo].[Kooleh]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Kooleh](
	[UserCod] [int] NULL,
	[OrderDate] [char](10) NULL,
	[AllPay] [money] NULL,
	[MonthCount] [int] NULL,
	[Sale] [money] NULL,
	[Finish] [bit] NOT NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Kooleh] ([UserCod], [OrderDate], [AllPay], [MonthCount], [Sale], [Finish], [CreateDate]) VALUES (100, N'1388/02/01', 120000.0000, 6, 50000.0000, 1, CAST(0x00009C230149BC80 AS DateTime))
/****** Object:  Table [dbo].[Gals]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Gals](
	[Cod] [int] NULL,
	[GalCod] [int] NULL,
	[Title] [varchar](128) NULL,
	[Del] [bit] NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Gal]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Gal](
	[Cod] [int] NULL,
	[Title] [varchar](128) NULL,
	[Del] [bit] NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Field]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Field](
	[Cod] [int] NOT NULL,
	[TypeCod] [int] NULL,
	[Title] [varchar](32) NULL,
	[DataType] [char](3) NULL,
	[Define] [bit] NOT NULL,
	[Vijeh] [int] NULL,
	[CreateDate] [datetime] NULL,
	[ComboCod] [int] NULL,
 CONSTRAINT [Field_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (3, 1, N'مترجم', N'STR', 0, 0, CAST(0x00009B84012D110C AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (4, 1, N'سال نشر', N'INT', 0, 0, CAST(0x00009B84012D1238 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (5, 1, N'ناشر', N'STR', 0, 0, CAST(0x00009B84012D1238 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (6, 1, N'نوبت چاپ', N'STR', 0, 0, CAST(0x00009B84012D1238 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (7, 1, N'تيراژ', N'INT', 0, 0, CAST(0x00009B84012D1364 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (8, 1, N'شابك', N'STR', 0, 0, CAST(0x00009B84012D1364 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (9, 1, N'قيمت پشت جلد (به ريال)', N'INT', 0, 0, CAST(0x00009B84012D1364 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (11, 1, N'رده‏سني مخاطبين', N'STR', 0, 0, CAST(0x00009B84012D15BC AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (12, 1, N'تعداد صفحات', N'INT', 0, 0, CAST(0x00009B84012D16E8 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (13, 1, N'جنس جلد', N'STR', 0, 0, CAST(0x00009B84012D16E8 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (14, 2, N'مدير مسؤول', N'STR', 0, 0, CAST(0x00009B84012D1814 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (15, 2, N'سردبير', N'STR', 0, 0, CAST(0x00009B84012D1940 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (16, 2, N'صاحب امتياز', N'STR', 0, 0, CAST(0x00009B84012D1A6C AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (17, 2, N'شماره', N'INT', 0, 0, CAST(0x00009B84012D1A6C AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (18, 2, N'تاريخ انتشار', N'STR', 0, 0, CAST(0x00009B84012D1B98 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (19, 2, N'باركد', N'STR', 0, 0, CAST(0x00009B84012D1DF0 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (20, 2, N'قيمت روي جلد (به ريال)', N'INT', 0, 0, CAST(0x00009B84012D1F1C AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (21, 2, N'رده‏سني مخاطبين', N'STR', 0, 0, CAST(0x00009B84012D2048 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (22, 2, N'تعداد صفحات', N'INT', 0, 0, CAST(0x00009B84012D2048 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (23, 2, N'شمارگان', N'INT', 0, 0, CAST(0x00009B84012D2174 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (24, 2, N'عنوان تيتر يك', N'STR', 0, 0, CAST(0x00009B84012D23CC AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (27, 3, N'تعداد حلقه', N'INT', 0, 0, CAST(0x00009B84012D2750 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (28, 3, N'قيمت روي قاب (به ريال)', N'INT', 0, 0, CAST(0x00009B84012D287C AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (29, 3, N'توليدكننده', N'STR', 0, 0, CAST(0x00009B84012D29A8 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (30, 3, N'باركد', N'STR', 0, 0, CAST(0x00009B84012D2AD4 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (31, 3, N'نام تهيه‏كننده', N'STR', 0, 0, CAST(0x00009B84012D2D2C AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (32, 3, N'كارگردان فيلم', N'STR', 0, 0, CAST(0x00009B84012D2F84 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (33, 1, N'معرفي كتاب', N'TXT', 1, 0, CAST(0x00009B84012D30B0 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (34, 1, N'گزيده متن', N'TXT', 0, 0, CAST(0x00009B84012D31DC AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (35, 1, N'فهرست كتاب', N'TXT', 0, 0, CAST(0x00009B84012D3308 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (36, 2, N'معرفي نشريه', N'TXT', 1, 0, CAST(0x00009B84012E4540 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (37, 2, N'فهرست مطالب', N'TXT', 0, 0, CAST(0x00009B84012E466C AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (38, 3, N'معرفي لوح فشرده', N'TXT', 1, 0, CAST(0x00009B84012E4798 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (39, 4, N'توليدكننده', N'STR', 0, 0, CAST(0x00009C06014AC5CD AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (40, 4, N'تيراژ', N'INT', 0, 0, CAST(0x00009C06014AD25C AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (41, 4, N'معرفي بازي', N'TXT', 1, 0, CAST(0x00009C06014AFF7A AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (42, 4, N'هدف از بازي', N'TXT', 0, 0, CAST(0x00009C06014B11F4 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (43, 4, N'تعداد قطعات', N'INT', 0, 0, CAST(0x00009C14016BCAC1 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (44, 5, N'نام', N'STR', 0, 0, CAST(0x00009D6B00F4BB93 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (45, 5, N'تنظيم', N'STR', 0, 0, CAST(0x00009D6B00F4C4D6 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (46, 5, N'خلاصه', N'TXT', 1, 0, CAST(0x00009D6B00F4CFDC AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (47, 6, N'نام', N'STR', 0, 0, CAST(0x00009D6C00FAF170 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (48, 6, N'محرمانه', N'STR', 0, 1, CAST(0x00009D6C00FAF849 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (49, 6, N'عجيب', N'STR', 0, 0, CAST(0x00009D6C00FB0829 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (50, 6, N'معرفي', N'TXT', 1, 0, CAST(0x00009D6C00FEDBD1 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (51, 6, N'عددي محرمانه', N'INT', 0, 1, CAST(0x00009D6C0100903E AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (52, 6, N'متن محرمانه', N'TXT', 0, 1, CAST(0x00009D6C01009D25 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (53, 6, N'تصوير نويسنده', N'PIC', 0, 1, CAST(0x00009D7400F1EF06 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (54, 6, N'سخنراني نويسنده', N'SND', 0, 0, CAST(0x00009D7400F29548 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (55, 6, N'لينك دانلود يك', N'LNK', 0, 0, CAST(0x00009D7401045C14 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (56, 6, N'لينك دانلود دو', N'LNK', 0, 1, CAST(0x00009D740104674B AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (57, 6, N'بخشي از سخنراني', N'MOV', 0, 0, CAST(0x00009D7700DDC204 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (58, 6, N'يك تكه فلش', N'SWF', 0, 1, CAST(0x00009D7700DDD22B AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (59, 6, N'تصوير پشت جلد', N'PIC', 0, 0, CAST(0x00009D8700F7CD5B AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (60, 6, N'تصوير كنار', N'PIC', 0, 0, CAST(0x00009D8700F7D98D AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (61, 6, N'تصوير صفحه وسط', N'PIC', 0, 0, CAST(0x00009D8700F7E5F6 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (62, 6, N'اسكن صفحه اول', N'PIC', 0, 0, CAST(0x00009D8700F81085 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (63, 6, N'متن گزارش', N'PDF', 0, 0, CAST(0x00009D8E00E6D0C5 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (64, 6, N'سند گزارش', N'DOC', 0, 0, CAST(0x00009D8E00E7A491 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (65, 6, N'تصوير اصلي', N'PSD', 0, 0, CAST(0x00009D9600EFD531 AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (66, 6, N'نرم‌افزار موبايل', N'JAR', 0, 0, CAST(0x00009D9600F0136F AS DateTime), NULL)
INSERT [dbo].[Field] ([Cod], [TypeCod], [Title], [DataType], [Define], [Vijeh], [CreateDate], [ComboCod]) VALUES (67, 6, N'نرم‌افزار', N'ZIP', 0, 0, CAST(0x00009D9600F7DB26 AS DateTime), NULL)
/****** Object:  Table [dbo].[Diags]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Diags](
	[Cod] [int] NOT NULL,
	[Title] [varchar](128) NULL,
	[Kon] [varchar](64) NULL,
	[Sho] [varchar](64) NULL,
	[Lead] [varchar](max) NULL,
	[Text] [varchar](max) NULL,
	[NewsDate] [char](10) NULL,
	[Show] [bit] NOT NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dataTXT]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dataTXT](
	[ProductCod] [int] NULL,
	[FieldCod] [int] NULL,
	[Content] [varchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[dataTXT] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 34, N'صثقصث ق  قثصقث صثقصث ق صث قثص ق ثص ق ثق ثص قث صثقصث ق صث')
INSERT [dbo].[dataTXT] ([ProductCod], [FieldCod], [Content]) VALUES (1005, 33, N' بيسشبشسي بشيسبسيشبشيسبيسب')
INSERT [dbo].[dataTXT] ([ProductCod], [FieldCod], [Content]) VALUES (1008, 46, N'شبسيب سي بشيسب سي شب سشي ب سشي ب شيس ب شيس ب شيس ب شيس ب يسش ب سيش ب شيس ب سشيب يس شبش')
INSERT [dbo].[dataTXT] ([ProductCod], [FieldCod], [Content]) VALUES (1003, 41, N'بيسش بيس ب سشي ب شيسب  يشسب يسشب س شيب س شيب سشي ب شيس ب سيشبسش يبس شيب ي')
INSERT [dbo].[dataTXT] ([ProductCod], [FieldCod], [Content]) VALUES (1009, 50, N'سشيبسيب سي ب سي ب سي ب يسش ب يس ب سشي بس يب')
INSERT [dbo].[dataTXT] ([ProductCod], [FieldCod], [Content]) VALUES (1009, 52, N' ب شيس بيسشب سيش ب سشي بشيب')
INSERT [dbo].[dataTXT] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 50, N'لبيس ليب ليس بل يسبل يسبل يسب ل يبس ل يسبل يسب ل')
INSERT [dbo].[dataTXT] ([ProductCod], [FieldCod], [Content]) VALUES (1011, 50, N'<p dir="rtl"><span style="font-family: tahoma,arial,helvetica,sans-serif;"><span style="font-size: large;">من در اين دوره و زمانه كه هر كسي به <span style="color: #ff0000;">كسي </span>اعتماد دارد.</span></span></p>
<table style="width: 270px; height: 105px;" border="1">
<tbody>
<tr>
<td>سبسشيبشسيبيس</td>
<td>بسيبسيبسيب</td>
</tr>
<tr>
<td>
<p>سيبشسيبيسب سي بسيب</p>
<p>يسبسيبسيب</p>
<p>&nbsp;</p>
</td>
<td>بيسشبسيبسيبشسيبسيب</td>
</tr>
</tbody>
</table>
<p dir="rtl"><span style="font-family: tahoma,arial,helvetica,sans-serif;"><span style="font-size: large;">سشيبسشي</span></span></p>
<p dir="rtl"><span style="font-family: tahoma,arial,helvetica,sans-serif;"><span style="font-size: large;"><span style="font-family: tahoma,arial,helvetica,sans-serif;"><span style="font-size: large;">بسشيبسيب</span></span></span></span></p>')
/****** Object:  Table [dbo].[dataSTR]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dataSTR](
	[ProductCod] [int] NULL,
	[FieldCod] [int] NULL,
	[Content] [varchar](64) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 5, N'سيب')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 6, N'34')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 11, N'بسيبسي')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 13, N'بيسبسيب')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1001, 5, N'نوين')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1001, 6, N'اول')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 8, N'سيبسي')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1002, 39, N'شركت نماپرداز')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 3, N'خودم')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 5, N'صبا')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 6, N'اول')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 11, N'الف')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 13, N'شوميز')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1007, 15, N'سبيسشيبسيش')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1008, 44, N'خودم')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1008, 45, N'خودم فيلد دارم')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1009, 47, N'محصول است')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1009, 48, N'اين فيلد نبايد براي هر كسي نمايش دادهش')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1005, 5, N'ناشر فيلد هستم')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 47, N'سشيبيسش')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 48, N'بسشيب')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 49, N'سبسيب')
INSERT [dbo].[dataSTR] ([ProductCod], [FieldCod], [Content]) VALUES (1009, 49, N'نيست')
/****** Object:  Table [dbo].[dataINT]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dataINT](
	[ProductCod] [int] NULL,
	[FieldCod] [int] NULL,
	[Content] [float] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 4, 34)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 7, 234)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 12, 4324)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1001, 4, 87)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1001, 7, 3000)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1001, 9, 12000)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1001, 12, 239)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1002, 40, 4000)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 4, 1388)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 7, 3000)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 9, 12000)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1004, 12, 89)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1009, 51, 78787)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 51, 4324)
INSERT [dbo].[dataINT] ([ProductCod], [FieldCod], [Content]) VALUES (1000, 9, 43423)
/****** Object:  Table [dbo].[dataFLE]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dataFLE](
	[ProductCod] [int] NULL,
	[FieldCod] [int] NULL,
	[Content] [varchar](256) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[dataFLE] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 64, N'52T82U5C00QH1FOX.TXT')
INSERT [dbo].[dataFLE] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 55, N'http://mihannic.ir')
INSERT [dbo].[dataFLE] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 53, N'KHANHBKRGF7WGV5E.JPG')
INSERT [dbo].[dataFLE] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 57, N'1XP5WQ18VVMDVCKT.MPG')
INSERT [dbo].[dataFLE] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 58, N'DA2G93CJ88XO8NV6.SWF')
INSERT [dbo].[dataFLE] ([ProductCod], [FieldCod], [Content]) VALUES (1010, 56, N'http://reza.com')
/****** Object:  Table [dbo].[dataCMB]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dataCMB](
	[ProductCod] [int] NULL,
	[FieldCod] [int] NULL,
	[Content] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Combo]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Combo](
	[Cod] [int] NOT NULL,
	[Title] [varchar](256) NULL,
	[CreateDate] [datetime] NULL,
	[Place] [int] NOT NULL,
 CONSTRAINT [Combo_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (1, N'استان‌هاي ايران', CAST(0x00009E780139B5F8 AS DateTime), 0)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (2, N'اردبيل', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (3, N'آذربايجان غربي', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (4, N'آذربايجان شرقي', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (5, N'بوشهر', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (6, N'چهارمحال و بختياري', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (7, N'اصفهان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (8, N'فارس', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (9, N'قزوين', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (10, N'قم', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (11, N'گلستان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (12, N'گيلان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (13, N'همدان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (14, N'هرمزگان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (15, N'ايلام', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (16, N'كردستان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (17, N'كرمان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (18, N'كرمانشاه', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (19, N'كهكيلويه و بويراحمد', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (20, N'خراسان رضوي', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (21, N'خوزستان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (22, N'مازندران', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (23, N'لرستان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (24, N'مركزي', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (25, N'سيستان و بلوچستان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (26, N'سمنان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (27, N'تهران', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (28, N'يزد', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (29, N'زنجان', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (30, N'خراسان شمالي', CAST(0x00009E7801388439 AS DateTime), 1)
INSERT [dbo].[Combo] ([Cod], [Title], [CreateDate], [Place]) VALUES (31, N'خراسان جنوبي', CAST(0x00009E7801388439 AS DateTime), 1)
/****** Object:  Table [dbo].[CatchType]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CatchType](
	[Cod] [int] NOT NULL,
	[Title] [varchar](16) NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [CatchType_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[CatchType] ([Cod], [Title], [CreateDate]) VALUES (1, N'مانده باشگاه', CAST(0x00009BA50084F198 AS DateTime))
INSERT [dbo].[CatchType] ([Cod], [Title], [CreateDate]) VALUES (2, N'خريد غيراينترنتي', CAST(0x00009C0E005FA12A AS DateTime))
/****** Object:  Table [dbo].[Catch]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Catch](
	[UserCod] [int] NULL,
	[Payment] [money] NULL,
	[CatchType] [int] NULL,
	[CatchDate] [char](10) NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Cash]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cash](
	[UserCod] [int] NULL,
	[Payment] [money] NULL,
	[PayType] [int] NULL,
	[PayNumber] [varchar](16) NULL,
	[Bank] [varchar](16) NULL,
	[Branch] [varchar](32) NULL,
	[BranchCod] [varchar](8) NULL,
	[StateCod] [int] NULL,
	[City] [varchar](16) NULL,
	[PayDate] [char](10) NULL,
	[Accept] [bit] NOT NULL,
	[Reject] [bit] NOT NULL,
	[CreateDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Cash] ([UserCod], [Payment], [PayType], [PayNumber], [Bank], [Branch], [BranchCod], [StateCod], [City], [PayDate], [Accept], [Reject], [CreateDate]) VALUES (100, 323000.0000, 1, N'frsafawf', N'ملي', N'تست', N'34535', 2, N'شسيب', N'1388/01/23', 1, 0, CAST(0x00009C1901032037 AS DateTime))
INSERT [dbo].[Cash] ([UserCod], [Payment], [PayType], [PayNumber], [Bank], [Branch], [BranchCod], [StateCod], [City], [PayDate], [Accept], [Reject], [CreateDate]) VALUES (100, 9000.0000, 5, N'140100-93226', NULL, NULL, NULL, NULL, NULL, N'1389/02/30', 0, 1, CAST(0x00009D7C009D3A58 AS DateTime))
/****** Object:  Table [dbo].[BoxData]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BoxData](
	[Cod] [int] NOT NULL,
	[BoxCod] [int] NULL,
	[Onvan] [varchar](128) NULL,
	[Link] [varchar](256) NULL,
	[CreateDate] [smalldatetime] NULL,
 CONSTRAINT [PK__BoxData__C1FE6AA92F8501C7] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[BoxData] ([Cod], [BoxCod], [Onvan], [Link], [CreateDate]) VALUES (1, 1, N'ستاد مركزي راهيان نور', N'http://rahiannoor.com/rt', CAST(0x9D8C02CD AS SmallDateTime))
INSERT [dbo].[BoxData] ([Cod], [BoxCod], [Onvan], [Link], [CreateDate]) VALUES (5, 1, N'نام‌آوران', N'http://', CAST(0x9D8C02D5 AS SmallDateTime))
INSERT [dbo].[BoxData] ([Cod], [BoxCod], [Onvan], [Link], [CreateDate]) VALUES (7, 2, N'pic/SMS-thumb.jpg', N'', CAST(0x9D8D0388 AS SmallDateTime))
INSERT [dbo].[BoxData] ([Cod], [BoxCod], [Onvan], [Link], [CreateDate]) VALUES (8, 2, N'images/post.gif', N'http://test.cuj', CAST(0x9D8D0388 AS SmallDateTime))
/****** Object:  Table [dbo].[Box]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Box](
	[Cod] [int] NOT NULL,
	[Title] [varchar](32) NOT NULL,
	[Type] [char](1) NULL,
	[Show] [bit] NULL,
	[CreateDate] [smalldatetime] NULL,
 CONSTRAINT [PK__Box__C1FE6AA92AC04CAA] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'T for Text, P for Pic' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Box', @level2type=N'COLUMN',@level2name=N'Type'
GO
INSERT [dbo].[Box] ([Cod], [Title], [Type], [Show], [CreateDate]) VALUES (1, N'سايت‌هاي ديگر من', N'T', 0, CAST(0x9D8C0289 AS SmallDateTime))
/****** Object:  Table [dbo].[Author]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Author](
	[Cod] [int] NOT NULL,
	[FirstName] [varchar](32) NULL,
	[LastName] [varchar](32) NULL,
	[Define] [varchar](max) NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [Author_pk] PRIMARY KEY CLUSTERED 
(
	[Cod] 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
INSERT [dbo].[Author] ([Cod], [FirstName], [LastName], [Define], [CreateDate]) VALUES (1, N'رضا', N'رهگذر', N'اين پديدآورنده كه در ابتدا كار خود را با ويراستاري آغاز كرد از ابتداي فعاليت خود در سال 1379 كتاب مهمي را از شخصيت برجسته‏اي ويرايش نمود و منتشر ساخت. ادامه دارد.', CAST(0x00009BC30101A24C AS DateTime))
INSERT [dbo].[Author] ([Cod], [FirstName], [LastName], [Define], [CreateDate]) VALUES (2, N'مهدي', N'قزلي', N'', CAST(0x00009BC301046F7C AS DateTime))
/****** Object:  Table [dbo].[About]    Script Date: 11/15/2011 21:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[About](
	[IDN] [varchar](8) NOT NULL,
	[Title] [varchar](64) NULL,
	[Matn] [varchar](max) NULL,
	[Def] [bit] NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [About_pk] PRIMARY KEY CLUSTERED 
(
	[IDN] 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
INSERT [dbo].[About] ([IDN], [Title], [Matn], [Def], [CreateDate]) VALUES (N'About', N'معرفي ما', N'ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟ ما كه هستيم؟', 1, CAST(0x00009B890079E708 AS DateTime))
INSERT [dbo].[About] ([IDN], [Title], [Matn], [Def], [CreateDate]) VALUES (N'Bank', N'حساب‏هاي بانكي فروشگاه فرهنگي ما', N'اين حساب بانكي ماست.', 0, CAST(0x00009BBE00F79158 AS DateTime))
INSERT [dbo].[About] ([IDN], [Title], [Matn], [Def], [CreateDate]) VALUES (N'Jomleh', N'جملات خوردني', N'كتاب، دروازه‌اى به سوى گستره‌ى دانش و معرفت است و كتاب خوب، يكى از بهترين ابزارهاى كمال بشرى است.
 همه‌ى دستاوردهاى بشر در سراسر عمر جهان، تا آن‌جا كه قابل كتابت بوده است، در ميان نوشته‌هايى است كه انسان‌ها پديد آورده‌اند و مى‌آورند.
كسى كه با اين دنياى زيبا و زندگى‌بخش- دنياى كتاب- ارتباط ندارد بى‌شك از مهم‌ترين دستاورد انسانى و نيز از بيشترين معارف الهى و بشرى محروم است.
 براى يك ملت، خسارتى بزرگ است كه افراد آن، با كتاب سر و كارى نداشته باشند و براى يك فرد، توفيق عظيمى است كه با كتاب، مأنوس و همواره در حال بهره‌گيرى از آن يعنى آموختن چيزهاى تازه باشد. 
', 0, CAST(0x00009F9C015B6623 AS DateTime))
INSERT [dbo].[About] ([IDN], [Title], [Matn], [Def], [CreateDate]) VALUES (N'Kooleh', N'معرفي باشگاه امين', N'با پرداخت مبلغ 5000 تومان و پر نمودن فرم اشترا? مي‏توانيد تا 12000 تومان محصولات فرهنگي مورد علاقه خود را انتخاب نماييد.
نحوه عضويت:
3. ايستگاه‏هاي امتداد در يادمان‏ها
نحوه خريد:
1. مرحله اول اين پروژه شش‏ماهه است ?ه در صورت عضويت هر ماه مي‏توانيد تا سقف 2000 تومان محصول رايگان انتخاب نماييد.
2. در صورت عضويت از طريق ايستگاه‏هاي امتداد، در يادمان‏ها و دريافت فرم اشترا? و مهر بن‏هاي خود مي‏توانيد در نمايشگاه خا?ريز (اروند?نار) تا سقف 4000 تومان محصول رايگان انتخاب ?نيد ?ه اين مبلغ معادل دو ماه خريد شماست.
3. عزيزاني ?ه تا شش‏ماه خريد ن?رده‏اند مي‏توانند در ماه آخر ?ل اعتبار 12000 توماني خود را خريد نمايند.
تذ?ر: در صورت عدم خريد تا پايان شش‏ماهه اول فقط به ميزان 5000 تومان مي‏توانيد در شش‌ماهه دوم خريد نماييد. بديهي است پس از گذشت ي?سال ديگر اعتباري براي خريد باقي نخواهد ماند.
نحوه انتخاب محصول:
نحوه ارسال محصولات براي اعضاي باشگاه:
1. از طريق پيك موتوري در تهران
2. از طريق پست سفارشي يا پيشتاز در شهرستان‌ها', 1, CAST(0x00009BBE00F23514 AS DateTime))
INSERT [dbo].[About] ([IDN], [Title], [Matn], [Def], [CreateDate]) VALUES (N'Law', N'قوانين و تعرفه‏ها', N'پس از آغاز به كار پايگاه، قوانين خريد و همچنين تعرفه‏هاي ارسال يك محصول، در اين قسمت درج خواهد شد.', 1, CAST(0x00009BBE00F79158 AS DateTime))
INSERT [dbo].[About] ([IDN], [Title], [Matn], [Def], [CreateDate]) VALUES (N'Lock', N'حفاظت در مقابل نفوذگران و هكرها', N'با توجه به حساس بودن اطلاعات مالي اين سايت، براي جلوگيري از نفوذ افراد متخلف به سايت يك سيستم امنيتي قدرتمند نصب شده است.', 0, CAST(0x00009BBE00F79158 AS DateTime))
INSERT [dbo].[About] ([IDN], [Title], [Matn], [Def], [CreateDate]) VALUES (N'Relate', N'كد ارتباطي', N'در صورتي كه در اردوي راهيان نور به زيارت مزار شهدا در مناطق جنگي رفته‏ايد، كدي با عنوان كد ارتباطي دريافت كرده‏ايد، اين كد را در فرم اطلاعات شخصي خود وارد نماييد، تا از خدمات ويژه فرهنگي ما بهره‏مند شويد.', 0, CAST(0x00009BBE00F79158 AS DateTime))
/****** Object:  Default [DF__About__Def__46E78A0C]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[About] ADD  CONSTRAINT [DF__About__Def__46E78A0C]  DEFAULT ((0)) FOR [Def]
GO
/****** Object:  Default [DF__About__CreateDat__4AB81AF0]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[About] ADD  CONSTRAINT [DF__About__CreateDat__4AB81AF0]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Author__CreateDa__4BAC3F29]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Author] ADD  CONSTRAINT [DF__Author__CreateDa__4BAC3F29]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Box__Show__353DDB1D]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Box] ADD  CONSTRAINT [DF__Box__Show__353DDB1D]  DEFAULT ((0)) FOR [Show]
GO
/****** Object:  Default [DF__Box__CreateDate__2CA8951C]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Box] ADD  CONSTRAINT [DF__Box__CreateDate__2CA8951C]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__BoxData__CreateD__316D4A39]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[BoxData] ADD  CONSTRAINT [DF__BoxData__CreateD__316D4A39]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Cash__Payment__2E1BDC42]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Cash] ADD  CONSTRAINT [DF__Cash__Payment__2E1BDC42]  DEFAULT ((0)) FOR [Payment]
GO
/****** Object:  Default [DF__Cash__Accept__2F10007B]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Cash] ADD  CONSTRAINT [DF__Cash__Accept__2F10007B]  DEFAULT ((0)) FOR [Accept]
GO
/****** Object:  Default [DF__Cash__Reject__300424B4]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Cash] ADD  CONSTRAINT [DF__Cash__Reject__300424B4]  DEFAULT ((0)) FOR [Reject]
GO
/****** Object:  Default [DF__Cash__CreateDate__4CA06362]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Cash] ADD  CONSTRAINT [DF__Cash__CreateDate__4CA06362]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Catch__CreateDat__4D94879B]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Catch] ADD  CONSTRAINT [DF__Catch__CreateDat__4D94879B]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__CatchType__Creat__4E88ABD4]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[CatchType] ADD  CONSTRAINT [DF__CatchType__Creat__4E88ABD4]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__State__Crea8teDat__5629CD9C]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Combo] ADD  CONSTRAINT [DF__State__Crea8teDat__5629CD9C]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Field__Define__3D5E1FD2]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Field] ADD  CONSTRAINT [DF__Field__Define__3D5E1FD2]  DEFAULT ((0)) FOR [Define]
GO
/****** Object:  Default [DF__Field__Vijeh__0C3BC58A]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Field] ADD  CONSTRAINT [DF__Field__Vijeh__0C3BC58A]  DEFAULT ((0)) FOR [Vijeh]
GO
/****** Object:  Default [DF__Field__CreateDat__4F7CD00D]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Field] ADD  CONSTRAINT [DF__Field__CreateDat__4F7CD00D]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Kooleh__Finish__3E52440B]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Kooleh] ADD  CONSTRAINT [DF__Kooleh__Finish__3E52440B]  DEFAULT ((0)) FOR [Finish]
GO
/****** Object:  Default [DF__Kooleh__CreateDa__5070F446]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Kooleh] ADD  CONSTRAINT [DF__Kooleh__CreateDa__5070F446]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Log__CreateDate__5EBF139D]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[LogA] ADD  CONSTRAINT [DF__Log__CreateDate__5EBF139D]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__uLog__CreateDate__619B8048_LogP]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[LogP] ADD  CONSTRAINT [DF__uLog__CreateDate__619B8048_LogP]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__uLog__CreateDate__619B8048]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[LogU] ADD  CONSTRAINT [DF__uLog__CreateDate__619B8048]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__News__Show__3F466844]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[News] ADD  CONSTRAINT [DF__News__Show__3F466844]  DEFAULT ((-1)) FOR [Show]
GO
/****** Object:  Default [DF__News__CreateDate__5165187F]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[News] ADD  CONSTRAINT [DF__News__CreateDate__5165187F]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__PayType__CreateD__52593CB8]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[PayType] ADD  CONSTRAINT [DF__PayType__CreateD__52593CB8]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Product__Rent__403A8C7D]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__Rent__403A8C7D]  DEFAULT ((0)) FOR [Rent]
GO
/****** Object:  Default [DF__Product__Vijeh__058EC7FB]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__Vijeh__058EC7FB]  DEFAULT ((0)) FOR [Vijeh]
GO
/****** Object:  Default [DF__Product__Del__412EB0B6]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__Del__412EB0B6]  DEFAULT ((0)) FOR [Del]
GO
/****** Object:  Default [DF__Product__CreateD__534D60F1]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__CreateD__534D60F1]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Rent__Recieve__4222D4EF]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Rent] ADD  CONSTRAINT [DF__Rent__Recieve__4222D4EF]  DEFAULT ((0)) FOR [Recieve]
GO
/****** Object:  Default [DF__Rent__Send__4316F928]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Rent] ADD  CONSTRAINT [DF__Rent__Send__4316F928]  DEFAULT ((0)) FOR [Send]
GO
/****** Object:  Default [DF__Rent__Stay__440B1D61]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Rent] ADD  CONSTRAINT [DF__Rent__Stay__440B1D61]  DEFAULT ((0)) FOR [Stay]
GO
/****** Object:  Default [DF__Rent__Back__44FF419A]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Rent] ADD  CONSTRAINT [DF__Rent__Back__44FF419A]  DEFAULT ((0)) FOR [Back]
GO
/****** Object:  Default [DF__Rent__Finish__45F365D3]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Rent] ADD  CONSTRAINT [DF__Rent__Finish__45F365D3]  DEFAULT ((0)) FOR [Finish]
GO
/****** Object:  Default [DF__Sale__PostType__787EE5A0]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Sale] ADD  CONSTRAINT [DF__Sale__PostType__787EE5A0]  DEFAULT ((0)) FOR [PostType]
GO
/****** Object:  Default [DF__Sale__Order__30F848ED]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Sale] ADD  CONSTRAINT [DF__Sale__Order__30F848ED]  DEFAULT ((0)) FOR [Order]
GO
/****** Object:  Default [DF__Sale__Recieve__31EC6D26]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Sale] ADD  CONSTRAINT [DF__Sale__Recieve__31EC6D26]  DEFAULT ((0)) FOR [Recieve]
GO
/****** Object:  Default [DF__Sale__Send__32E0915F]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Sale] ADD  CONSTRAINT [DF__Sale__Send__32E0915F]  DEFAULT ((0)) FOR [Send]
GO
/****** Object:  Default [DF__Sale__Finish__33D4B598]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Sale] ADD  CONSTRAINT [DF__Sale__Finish__33D4B598]  DEFAULT ((0)) FOR [Finish]
GO
/****** Object:  Default [DF__Sale__Reject__34C8D9D1]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Sale] ADD  CONSTRAINT [DF__Sale__Reject__34C8D9D1]  DEFAULT ((0)) FOR [Reject]
GO
/****** Object:  Default [DF__Sale__CreateDate__5441852A]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Sale] ADD  CONSTRAINT [DF__Sale__CreateDate__5441852A]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Selected__Create__5535A963]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Selected] ADD  CONSTRAINT [DF__Selected__Create__5535A963]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__State__CreateDat__5629CD9C]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[State] ADD  CONSTRAINT [DF__State__CreateDat__5629CD9C]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__Subject__Positio__3B75D760]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Subject] ADD  CONSTRAINT [DF__Subject__Positio__3B75D760]  DEFAULT ((0)) FOR [Position]
GO
/****** Object:  Default [DF__Subject__GrandCo__3C69FB99]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Subject] ADD  CONSTRAINT [DF__Subject__GrandCo__3C69FB99]  DEFAULT ((0)) FOR [GrandCod]
GO
/****** Object:  Default [DF__Subject__Vijeh__2136E270]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Subject] ADD  CONSTRAINT [DF__Subject__Vijeh__2136E270]  DEFAULT ((0)) FOR [Vijeh]
GO
/****** Object:  Default [DF__Subject__CreateD__571DF1D5]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Subject] ADD  CONSTRAINT [DF__Subject__CreateD__571DF1D5]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__SubjProd__Create__5812160E]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[SubjProd] ADD  CONSTRAINT [DF__SubjProd__Create__5812160E]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__SubjUser__Create__59063A47]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[SubjUser] ADD  CONSTRAINT [DF__SubjUser__Create__59063A47]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__tmpUser__kharid__7C4F7684]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[tmpUser] ADD  CONSTRAINT [DF__tmpUser__kharid__7C4F7684]  DEFAULT ((0)) FOR [Kharid]
GO
/****** Object:  Default [DF__Type__Vijeh__1C722D53]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Type] ADD  CONSTRAINT [DF__Type__Vijeh__1C722D53]  DEFAULT ((0)) FOR [Vijeh]
GO
/****** Object:  Default [DF__Type__CreateDate__59FA5E80]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[Type] ADD  CONSTRAINT [DF__Type__CreateDate__59FA5E80]  DEFAULT (getdate()) FOR [CreateDate]
GO
/****** Object:  Default [DF__User__Male__3A81B327]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[User] ADD  CONSTRAINT [DF__User__Male__3A81B327]  DEFAULT ((-1)) FOR [Male]
GO
/****** Object:  Default [DF__User__GetEmail__35BCFE0A]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[User] ADD  CONSTRAINT [DF__User__GetEmail__35BCFE0A]  DEFAULT ((0)) FOR [GetEmail]
GO
/****** Object:  Default [DF__User__GetSMS__36B12243]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[User] ADD  CONSTRAINT [DF__User__GetSMS__36B12243]  DEFAULT ((0)) FOR [GetSMS]
GO
/****** Object:  Default [DF__User__GetMonthly__37A5467C]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[User] ADD  CONSTRAINT [DF__User__GetMonthly__37A5467C]  DEFAULT ((0)) FOR [GetMonthly]
GO
/****** Object:  Default [DF__User__Money__38996AB5]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[User] ADD  CONSTRAINT [DF__User__Money__38996AB5]  DEFAULT ((0)) FOR [Money]
GO
/****** Object:  Default [DF__User__Added__398D8EEE]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[User] ADD  CONSTRAINT [DF__User__Added__398D8EEE]  DEFAULT ((0)) FOR [Added]
GO
/****** Object:  Default [DF__User__Vijeh__11F49EE0]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[User] ADD  CONSTRAINT [DF__User__Vijeh__11F49EE0]  DEFAULT ((0)) FOR [Vijeh]
GO
/****** Object:  Default [DF__User__CreateDate__5AEE82B9]    Script Date: 11/15/2011 21:28:26 ******/
ALTER TABLE [dbo].[User] ADD  CONSTRAINT [DF__User__CreateDate__5AEE82B9]  DEFAULT (getdate()) FOR [CreateDate]
GO
