当前文件路径：AspNetWuYeGuanLi/DB_51aspx/SmallHouse.sql

		            
  1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Area]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  2drop table [dbo].[Area]
  3GO
  4
  5if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AreaKK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  6drop table [dbo].[AreaKK]
  7GO
  8
  9if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BM_Config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 10drop table [dbo].[BM_Config]
 11GO
 12
 13if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BM_PavilionType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 14drop table [dbo].[BM_PavilionType]
 15GO
 16
 17if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BM_Pursuant]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 18drop table [dbo].[BM_Pursuant]
 19GO
 20
 21if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BM_Sunny]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 22drop table [dbo].[BM_Sunny]
 23GO
 24
 25if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Bm_Indoor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 26drop table [dbo].[Bm_Indoor]
 27GO
 28
 29if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Carbarn]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 30drop table [dbo].[Carbarn]
 31GO
 32
 33if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[House]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 34drop table [dbo].[House]
 35GO
 36
 37if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MeterReading]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 38drop table [dbo].[MeterReading]
 39GO
 40
 41if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PaviPhoto]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 42drop table [dbo].[PaviPhoto]
 43GO
 44
 45if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pavilion]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 46drop table [dbo].[Pavilion]
 47GO
 48
 49if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Phone]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 50drop table [dbo].[Phone]
 51GO
 52
 53if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bm_Cell]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 54drop table [dbo].[bm_Cell]
 55GO
 56
 57if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bm_Months]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 58drop table [dbo].[bm_Months]
 59GO
 60
 61if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bm_PlaceType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 62drop table [dbo].[bm_PlaceType]
 63GO
 64
 65if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bm_Property]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 66drop table [dbo].[bm_Property]
 67GO
 68
 69if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bm_SLevel]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 70drop table [dbo].[bm_SLevel]
 71GO
 72
 73if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bm_YesNO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 74drop table [dbo].[bm_YesNO]
 75GO
 76
 77if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bm_bm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 78drop table [dbo].[bm_bm]
 79GO
 80
 81if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ldcw]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 82drop table [dbo].[ldcw]
 83GO
 84
 85if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[lvhua]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 86drop table [dbo].[lvhua]
 87GO
 88
 89if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[members]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 90drop table [dbo].[members]
 91GO
 92
 93if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[shebei_mingxi]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 94drop table [dbo].[shebei_mingxi]
 95GO
 96
 97if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[shebei_weixiu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 98drop table [dbo].[shebei_weixiu]
 99GO
100
101if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zhuhu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
102drop table [dbo].[zhuhu]
103GO
104
105if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zhuhuchuru]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
106drop table [dbo].[zhuhuchuru]
107GO
108
109CREATE TABLE [dbo].[Area] (
110    [id] [int] IDENTITY (1, 1) NOT NULL ,
111    [Name] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
112    [fuzeren] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
113    [jianchengdate] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
114    [lianxiren] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
115    [lianxitel] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
116    [yidongtel] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
117    [zhandiarea] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
118    [daoluarea] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
119    [dcheweiarea] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
120    [jianzhuarea] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
121    [gaocengnum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
122    [chekuarea] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
123    [gonggarea] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
124    [duocengnum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
125    [cheweinum] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
126    [luhuaarea] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
127    [weizhi] [char] (90) COLLATE Chinese_PRC_CI_AS NULL ,
128    [beizhu] [char] (90) COLLATE Chinese_PRC_CI_AS NULL 
129) ON [PRIMARY]
130GO
131
132CREATE TABLE [dbo].[AreaKK] (
133    [id] [int] IDENTITY (1, 1) NOT NULL ,
134    [Name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
135    [AllName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
136    [note] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
137    [MainPerson] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
138    [contactPerson] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
139    [phone] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
140    [Memo] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
141    [typeid] [int] NULL 
142) ON [PRIMARY]
143GO
144
145CREATE TABLE [dbo].[BM_Config] (
146    [bmConId] [int] IDENTITY (1, 1) NOT NULL ,
147    [bmConfig] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
148    [arBm] [int] NULL ,
149    [bmConMemo] [char] (80) COLLATE Chinese_PRC_CI_AS NULL 
150) ON [PRIMARY]
151GO
152
153CREATE TABLE [dbo].[BM_PavilionType] (
154    [typeID] [int] IDENTITY (1, 1) NOT NULL ,
155    [Name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
156) ON [PRIMARY]
157GO
158
159CREATE TABLE [dbo].[BM_Pursuant] (
160    [Id] [int] IDENTITY (1, 1) NOT NULL ,
161    [Name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
162) ON [PRIMARY]
163GO
164
165CREATE TABLE [dbo].[BM_Sunny] (
166    [id] [int] IDENTITY (1, 1) NOT NULL ,
167    [Name] [char] (15) COLLATE Chinese_PRC_CI_AS NULL 
168) ON [PRIMARY]
169GO
170
171CREATE TABLE [dbo].[Bm_Indoor] (
172    [id] [int] IDENTITY (1, 1) NOT NULL ,
173    [Name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
174) ON [PRIMARY]
175GO
176
177CREATE TABLE [dbo].[Carbarn] (
178    [id] [int] IDENTITY (1, 1) NOT NULL ,
179    [theNO] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
180    [carNO] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
181    [carType] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
182    [Area] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
183    [Place] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
184    [Master] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
185    [Phone] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
186    [Memo] [char] (150) COLLATE Chinese_PRC_CI_AS NULL 
187) ON [PRIMARY]
188GO
189
190CREATE TABLE [dbo].[House] (
191    [hoID] [int] IDENTITY (1, 1) NOT NULL ,
192    [paID] [int] NULL ,
193    [cellID] [int] NULL ,
194    [hoFloor] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
195    [hoRoom] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
196    [sunnyId] [int] NULL ,
197    [indoorID] [int] NULL ,
198    [hoArchArce] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
199    [hoUseArce] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
200    [CLIENT_NAME] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
201    [CLIENT_CARD] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
202    [CLIENT_ACCOUNT_NUMBER] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
203    [COMPANY_NAME] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
204    [CLIENT_PHONE] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
205    [CLIENT_ADDRESS] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
206    [USE_DATE] [datetime] NULL ,
207    [Memo] [char] (150) COLLATE Chinese_PRC_CI_AS NULL 
208) ON [PRIMARY]
209GO
210