نیما حتمی
پنج شنبه 07 آذر 1392, 20:02 عصر
USE [Ajans]
GO
/****** Object: Table [dbo].[users] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[Family] [nvarchar](50) NULL,
[Pass] [nvarchar](50) NULL,
[username] [nvarchar](50) NULL,
[tarifetor] [bit] NULL,
[users] [bit] NULL,
[AccessUsers] [bit] NULL,
[recieption] [bit] NULL,
[gozaeshat] [bit] NULL,
[finance] [bit] NULL,
[gozaeshatchek] [bit] NULL,
[EditGozaresh] [bit] NULL,
[SystemSetting] [bit] NULL,
[BaseTbl] [bit] NULL,
[BlakList] [bit] NULL,
[Alarm] [bit] NULL,
[DialyGozaresh] [bit] NULL,
[Kartabl] [bit] NULL,
[FinanceMali] [bit] NULL,
CONSTRAINT [PK_users] 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].[Typevasile] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Typevasile](
[ID] [int] IDENTITY(1,1) NOT NULL,
[NameVasileRaft] [nvarchar](50) NULL,
[Namevasilebargasht] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[TaeidTbl] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaeidTbl](
[ID] [int] IDENTITY(1,1) NOT NULL,
[shgh] [nvarchar](50) NULL,
[accountkol] [int] NULL,
[MonyHotel] [int] NULL,
[MonyP] [int] NULL,
[KolP] [int] NULL,
[Sod] [int] NULL,
[Managment] [bit] NULL,
[modirefanni] [bit] NULL,
[Comm] [nvarchar](500) NULL,
[MonyGasht] [int] NULL,
[MonyComisiun] [int] NULL,
[DateHotel] [nvarchar](50) NULL,
[DateParvaz] [nvarchar](50) NULL,
[DateGasht] [nvarchar](50) NULL,
CONSTRAINT [PK_TaeidTbl] 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].[Setting] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Setting](
[NameCompany] [nvarchar](50) NULL,
[TelN] [nvarchar](50) NULL,
[FaxN] [nvarchar](50) NULL,
[Logo] [image] NULL,
[Address] [nvarchar](200) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[salemali] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[salemali](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[DateStart] [nvarchar](50) NULL,
[DateEnd] [nvarchar](50) NULL,
[MaliYear] [nvarchar](50) NULL,
[shsef] [nvarchar](50) NULL,
[shsekh] [nvarchar](50) NULL,
[status] [nvarchar](50) NULL,
CONSTRAINT [PK_salemali] 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].[Rojo] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Rojo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DateSabtenam] [nvarchar](50) NULL,
[Name] [nvarchar](50) NULL,
CONSTRAINT [PK_Rojo] 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].[ReciveKoli] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ReciveKoli](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DateSabt] [nvarchar](50) NULL,
[DateRecive] [nvarchar](50) NULL,
[TarafhesabName] [nvarchar](50) NULL,
[Namayandeh] [nvarchar](50) NULL,
[NameBank] [nvarchar](50) NULL,
[ShH] [nvarchar](50) NULL,
[mony] [int] NULL,
[Shp] [nvarchar](50) NULL,
[babate] [nvarchar](50) NULL,
[Comm] [nvarchar](50) NULL,
[Type] [nvarchar](50) NULL,
CONSTRAINT [PK_ReciveKoli] 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].[MaliRecieve] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MaliRecieve](
[ID] [int] NULL,
[Shsanad] [nvarchar](50) NULL,
[Shgh] [nvarchar](50) NULL,
[NameM] [nvarchar](50) NULL,
[FamilyM] [nvarchar](50) NULL,
[Nametor] [nvarchar](50) NULL,
[DateSabt] [nvarchar](50) NULL,
[DateRecieve] [nvarchar](50) NULL,
[TypeRecieve] [nvarchar](50) NULL,
[MonyRecieve] [int] NULL,
[mablaghekol] [int] NULL,
[Comm] [nvarchar](500) NULL,
[NameUser] [nvarchar](50) NULL,
[tarafhesab] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[MaliPeyment] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MaliPeyment](
[ID] [int] NOT NULL,
[Shsanad] [nvarchar](50) NULL,
[Shgh] [nvarchar](50) NULL,
[NameM] [nvarchar](50) NULL,
[FamilyM] [nvarchar](50) NULL,
[Nametor] [nvarchar](50) NULL,
[DateSabt] [nvarchar](50) NULL,
[DateRecieve] [nvarchar](50) NULL,
[TypeRecieve] [nvarchar](50) NULL,
[MonyPeyment] [int] NULL,
[mablaghekol] [int] NULL,
[TarafhesabName] [nvarchar](50) NULL,
[Namayandename] [nvarchar](50) NULL,
[Comm] [nvarchar](500) NULL,
[NameUser] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Leider] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Leider](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Datesabt] [nvarchar](50) NULL,
[Name] [nvarchar](50) NULL,
[Family] [nvarchar](50) NULL,
[Sex] [nvarchar](50) NULL,
[tahsilat] [nvarchar](50) NULL,
CONSTRAINT [PK_Leider] 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].[Kolipeyment] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Kolipeyment](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DateSabt] [nvarchar](50) NULL,
[Typetor] [nvarchar](50) NULL,
[Nametor] [nvarchar](50) NULL,
[DateHarekat] [nvarchar](50) NULL,
[TarafhesabName] [nvarchar](50) NULL,
[Namayandeh] [nvarchar](50) NULL,
[NameBank] [nvarchar](50) NULL,
[ShH] [nvarchar](50) NULL,
[Mony] [int] NULL,
[babate] [nvarchar](50) NULL,
[Comm] [nvarchar](500) NULL,
[Shp] [nvarchar](50) NULL,
[Type] [nvarchar](50) NULL,
[UserName] [nvarchar](50) NULL,
CONSTRAINT [PK_KoliPeymaebt] 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].[HotelTbl] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HotelTbl](
[ID] [int] NOT NULL,
[Shgh] [nvarchar](50) NULL,
[NameTarafHesab] [nvarchar](50) NULL,
[NAmeNamyande] [nvarchar](50) NULL,
[MonyHotel] [int] NULL,
[NameHotel] [nvarchar](50) NULL,
[NameCity] [nvarchar](50) NULL,
[StartHotel] [nvarchar](50) NULL,
[Chekin] [nvarchar](50) NULL,
[ChekOut] [nvarchar](50) NULL,
[Night] [nvarchar](50) NULL,
[Ext] [nvarchar](50) NULL,
[Sgl] [nvarchar](50) NULL,
[Dbl] [nvarchar](50) NULL,
[Trp] [nvarchar](50) NULL,
[fourbed] [nvarchar](50) NULL,
[fivebed] [nvarchar](50) NULL,
[sexbed] [nvarchar](50) NULL,
[Comm] [nvarchar](500) NULL,
[Managment] [bit] NULL,
[modirefanni] [bit] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[hotell] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[hotell](
[Id] [int] IDENTITY(1,1) NOT NULL,
[NameTor] [nvarchar](50) NULL,
[NameHotel] [nvarchar](50) NULL,
[Date] [nvarchar](50) NULL,
[twootagh] [int] NULL,
[treeotagh] [int] NULL,
[fourotagh] [int] NULL,
[fiveotagh] [int] NULL,
[sexotagh] [int] NULL,
[countotaghkol] [int] NULL,
[countzarfiat] [int] NULL,
[dateinter] [nvarchar](50) NULL,
[dateout] [nvarchar](50) NULL,
[DateHarekat] [nvarchar](50) NULL,
[csandalibus] [int] NULL,
[Nameairline1] [nvarchar](50) NULL,
[cNameairline1] [int] NULL,
[Nameairline2] [nvarchar](50) NULL,
[cNameairline2] [int] NULL,
[ModatEghamat] [char](10) NULL,
[oneotagh] [int] NULL,
[MonyComisiun] [int] NULL,
CONSTRAINT [PK_hotell] 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].[Hazine] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Hazine](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DateSabt] [nvarchar](50) NULL,
[NameHazine] [nvarchar](50) NULL,
CONSTRAINT [PK_Hazine] 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].[gashtTbl] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gashtTbl](
[ID] [int] IDENTITY(1,1) NOT NULL,
[shgh] [nvarchar](50) NULL,
[MonyGasht] [int] NULL,
[MonyFod] [int] NULL,
[MonyMotefareghe] [int] NULL,
[NameTG] [nvarchar](50) NULL,
[NameTF] [nvarchar](50) NULL,
[NameTM] [nvarchar](50) NULL,
[Comm] [nvarchar](500) NULL,
CONSTRAINT [PK_gashtTbl] 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].[GardeshBank] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GardeshBank](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Comm] [nvarchar](50) NULL,
[Date] [nvarchar](50) NULL,
[Bedehkari] [nvarchar](100) NULL,
[Bestankari] [nchar](10) NULL,
[NameUser] [nvarchar](50) NULL,
CONSTRAINT [PK_GardeshBank] 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].[Customer] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ShGH] [nvarchar](50) NULL,
[NameC] [nvarchar](50) NULL,
[Familyc] [nvarchar](50) NULL,
[ShMobile] [nvarchar](50) NULL,
[dateintertohetel] [nvarchar](50) NULL,
[Typevasileraft] [nvarchar](50) NULL,
[Typevasilebargasht] [nvarchar](50) NULL,
[Datesabtenam] [nvarchar](50) NULL,
[count] [int] NULL,
[radeseni] [nvarchar](50) NULL,
[request] [nvarchar](50) NULL,
[Nameuser] [nvarchar](50) NULL,
[madarek] [nvarchar](50) NULL,
[Comm] [nvarchar](200) NULL,
[NameHotel] [nvarchar](50) NULL,
[Nametor] [nvarchar](50) NULL,
[rezerv] [nvarchar](50) NULL,
[Towotagh] [int] NULL,
[treeotagh] [int] NULL,
[fourotagh] [int] NULL,
[fiveotagh] [int] NULL,
[sexotagh] [int] NULL,
[accountkol] [int] NULL,
[sersingletransfer] [bit] NULL,
[serdtransfer] [bit] NULL,
[sersobhane] [bit] NULL,
[sernahar] [bit] NULL,
[sersham] [bit] NULL,
[S2] [nvarchar](50) NULL,
[s3] [nvarchar](50) NULL,
[s4] [nvarchar](50) NULL,
[s5] [nvarchar](50) NULL,
[s6] [nvarchar](50) NULL,
[typegh] [nvarchar](50) NULL,
[vagozar] [nvarchar](50) NULL,
[csandalibus] [int] NULL,
[traft] [bit] NULL,
[tbargasht] [bit] NULL,
[vocher] [bit] NULL,
[motamam] [bit] NULL,
[chnames] [bit] NULL,
[chload] [bit] NULL,
[chseni] [bit] NULL,
[chmaharem] [bit] NULL,
[chcon] [bit] NULL,
[pishpardakht] [bit] NULL,
[tasveye] [bit] NULL,
[tahvilm] [bit] NULL,
[ModateE] [nvarchar](50) NULL,
[TypeTor] [nvarchar](50) NULL,
[DateBack] [nvarchar](50) NULL,
[typePassenger] [bit] NULL,
[Documentmali] [bit] NULL,
[CodeMelli] [nvarchar](10) NULL,
[Htb] [int] NULL,
[P1] [int] NULL,
[P2] [int] NULL,
[P3] [int] NULL,
[Bestankar] [int] NULL,
[bedehkar] [int] NULL,
[Typerojo] [nvarchar](50) NULL,
[Telsabet] [nvarchar](50) NULL,
[Pasport] [nvarchar](50) NULL,
[Address] [nvarchar](1000) NULL,
[serhotel] [bit] NULL,
[sersimkart] [bit] NULL,
[sergashtnimroz] [bit] NULL,
[sergashttamamroz] [bit] NULL,
[serblit] [bit] NULL,
[serbime] [bit] NULL,
[commagriment] [nvarchar](50) NULL,
[sex] [nvarchar](50) NULL,
[Discount] [nvarchar](50) NULL,
[DateHarekat] [nvarchar](50) NULL,
[oneotagh] [int] NULL,
[vagozarmony] [int] NULL,
[CancelShgh] [bit] NULL,
CONSTRAINT [PK_Customer] 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].[ComisiunTbl] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ComisiunTbl](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Shgh] [nvarchar](50) NULL,
[NameTor] [nvarchar](50) NULL,
[DateInter] [nvarchar](50) NULL,
[DateLeave] [nvarchar](50) NULL,
[ModateEghamat] [nvarchar](50) NULL,
[NameUser] [nvarchar](50) NULL,
[MonyComisiun] [int] NULL,
[Typetor] [nvarchar](50) NULL,
[Count] [nvarchar](50) NULL,
[DateSabt] [nvarchar](50) NULL,
[SumComisiun] [int] NULL,
[CancelShgh] [bit] NULL,
CONSTRAINT [PK_ComisiunTbl] 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].[ChekTblPeyment] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChekTblPeyment](
[ID] [int] NOT NULL,
[Shgh] [nvarchar](50) NULL,
[NameBankChek] [nvarchar](50) NULL,
[ShHChek] [nvarchar](50) NULL,
[ShChek] [nvarchar](50) NULL,
[DateChek] [nvarchar](50) NULL,
[Malirecieve] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[ChekTbl] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChekTbl](
[ID] [int] NOT NULL,
[Shgh] [nvarchar](50) NULL,
[NameBankChek] [nvarchar](50) NULL,
[ShHChek] [nvarchar](50) NULL,
[ShChek] [nvarchar](50) NULL,
[DateChek] [nvarchar](50) NULL,
[Malirecieve] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[CardToCardPeyment] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CardToCardPeyment](
[ID] [int] NULL,
[shgh] [nvarchar](50) NOT NULL,
[NameBank] [nvarchar](50) NULL,
[ShH] [nvarchar](50) NULL,
[ShPeygiri] [nvarchar](50) NULL,
[Malirecieve] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[CardToCard] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CardToCard](
[ID] [int] NULL,
[shgh] [nvarchar](50) NULL,
[NameBank] [nvarchar](50) NULL,
[ShH] [nvarchar](50) NULL,
[ShPeygiri] [nvarchar](50) NULL,
[Malirecieve] [int] NULL,
[Type] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[BlakList] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BlakList](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[Family] [nvarchar](50) NULL,
[Mobile] [nvarchar](50) NULL,
[Comm] [nvarchar](250) NULL,
CONSTRAINT [PK_BlakList] 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].[Bank] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Bank](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DateSabt] [nvarchar](50) NULL,
[NameBank] [nvarchar](50) NULL,
[NameShobe] [nvarchar](50) NULL,
[ShHesab] [nvarchar](50) NULL,
[TypHesab] [nvarchar](50) NULL,
[SahebHesab] [nvarchar](50) NULL,
[Account] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Amlak] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Amlak](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Typehome] [nvarchar](50) NULL,
[TypeMelk] [nvarchar](50) NULL,
[malek] [nvarchar](50) NULL,
[Tel] [char](10) NULL,
[Date] [nvarchar](50) NULL,
[Addres] [nvarchar](200) NULL,
[samt] [nvarchar](50) NULL,
[counttabaghe] [int] NULL,
[countvahed] [int] NULL,
[moneykol] [nvarchar](50) NULL,
[tabaghe] [nchar](10) NULL,
[zirbana] [nvarchar](50) NULL,
[khab] [int] NULL,
[metrajbalkon] [nvarchar](50) NULL,
[phone] [bit] NULL,
[serviceticken] [varchar](50) NULL,
[servicewc] [varchar](50) NULL,
[kafposh] [varchar](50) NULL,
[parking] [bit] NULL,
[anbari] [bit] NULL,
[shomine] [bit] NULL,
[masahat] [varchar](50) NULL,
[tolebar] [varchar](50) NULL,
[darremot] [bit] NULL,
[hayat] [bit] NULL,
[shofaj] [bit] NULL,
[pakeyj] [bit] NULL,
[koler] [bit] NULL,
[gaz] [bit] NULL,
[ifone] [bit] NULL,
[asansor] [bit] NULL,
[agebana] [varchar](50) NULL,
[nama] [nvarchar](50) NULL,
[manbadata] [varchar](50) NULL,
[sokonatmalek] [varchar](50) NULL,
[comm] [varchar](200) NULL,
[takhleye] [bit] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[AlarmUsers] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AlarmUsers](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DateSabt] [nvarchar](50) NULL,
[NameUser] [nvarchar](50) NULL,
[Comm] [nvarchar](250) NULL,
[DateErsal] [nvarchar](50) NULL,
[Time] [nvarchar](50) NULL,
[comp] [nvarchar](250) NULL,
[position] [nvarchar](50) NULL,
CONSTRAINT [PK_AlarmUsers] 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].[AirTbl] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AirTbl](
[Id] [int] NULL,
[Shgh] [nvarchar](50) NULL,
[Company] [nvarchar](50) NULL,
[ShP] [nvarchar](50) NULL,
[Mabda] [nvarchar](50) NULL,
[Maghsad] [nvarchar](50) NULL,
[NameTarafhesab] [nvarchar](50) NULL,
[NameNamayande] [nvarchar](50) NULL,
[MonyP] [int] NULL,
[DateHarekat] [nvarchar](50) NULL,
[TimeHarekat] [nvarchar](50) NULL,
[Local] [nvarchar](50) NULL,
[Comm] [nvarchar](500) NULL,
[Managment] [bit] NULL,
[modirefanni] [bit] NULL,
[DateBargasht] [nvarchar](50) NULL,
[Timebargasht] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Account] Script Date: 11/28/2013 19:44:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Account](
[Id] [int] IDENTITY(1,1) NOT NULL,
[DateSabtenam] [nvarchar](50) NULL,
[NameAcc] [nvarchar](100) NULL,
[NameNamayande] [nvarchar](80) NULL,
[Shmobile] [nvarchar](50) NULL,
[Shsabet] [nvarchar](50) NULL,
[Email] [nvarchar](50) NULL,
[Address] [nvarchar](1000) NULL,
[Comm] [nvarchar](500) NULL,
[Daste] [nvarchar](50) NULL,
CONSTRAINT [PK_Account_1] 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
vBulletin® v4.2.5, Copyright ©2000-1403, Jelsoft Enterprises Ltd.