if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[classifyDrug]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Begin
CREATE TABLE [dbo].[classifyDrug](
	[AutoId] [smallint] IDENTITY(1,1) Primary Key NOT NULL,
	[Title] [varchar](20) NULL,
	[Name] [nvarchar](40) NULL,
	[Active] [Flag] NULL,
	[Acc_Code] [varchar](20) NULL
) ON [PRIMARY]



SET IDENTITY_INSERT [dbo].[classifyDrug] ON 
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (1, CONVERT(TEXT, N'Forosh'), N'فروش خالص داروخانه', 1, CONVERT(TEXT, N'70100001'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (2, CONVERT(TEXT, N'FaniBimar'), N'درامد حق فني از بيمار', 1, CONVERT(TEXT, N'72100001'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (3, CONVERT(TEXT, N'FaniSazman'), N'درامد حق فني از سازمان', 1, CONVERT(TEXT, N'72100001'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (4, CONVERT(TEXT, N'Otc'), N'درامد او تي سي', 1, CONVERT(TEXT, N'72100002'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (5, CONVERT(TEXT, N'PishDaryaft'), N'بيعانه يا پيش دريافت', 1, CONVERT(TEXT, N'40400003'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (6, CONVERT(TEXT, N'CashAndCard'), N'صندوق', 0, CONVERT(TEXT, N'10100004'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (7, CONVERT(TEXT, N'BedehSazmanBimeh'), N'بدهي سازمانهاي بيمه گر', 0, CONVERT(TEXT, N'11500004'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (8, CONVERT(TEXT, N'BedehFaniBimeh'), N'بدهي حق فني سازمانهاي بيمه گر', 0, CONVERT(TEXT, N'11500004'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (9, CONVERT(TEXT, N'BedehSazmanHemayati'), N'بدهي سازمانهاي حمايتي يا مکمل', 0, CONVERT(TEXT, N'11500005'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (10, CONVERT(TEXT, N'BedehPishDaryaft'), N'بدهي پيش دريافت', 0, CONVERT(TEXT, N'40400003'))
INSERT [dbo].[classifyDrug] ([AutoId], [Title], [Name], [Active], [Acc_Code]) VALUES (11, CONVERT(TEXT, N'CardAndCheqe'), N'کارت و چک', 0, CONVERT(TEXT, N'10100005'))
SET IDENTITY_INSERT [dbo].[classifyDrug] OFF


End