简易社区管理系统源码.zip

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[user]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[user]( [userID] [varchar](20) NOT NULL, [userPwd] [varchar](20) NOT NULL, [userName] [varchar](20) NULL, [userSex] [varchar](20) NULL, [userPhone] [varchar](20) NULL, [userIndentity] [varchar](20) NOT NULL, [userInfo] [varchar](5000) NULL, CONSTRAINT [PK_user_1] PRIMARY KEY CLUSTERED ( [userID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[house-info]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[house-info]( [number] [nchar](10) NOT NULL, [price] [money] NOT NULL, [sq] [nchar](10) NOT NULL, [style] [text] NOT NULL, [check] [text] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[house]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[house]( [houseID] [varchar](20) NOT NULL, [houseImg] [varchar](20) NULL, [houseInfo] [text] NULL, [houseUser] [varchar](20) NULL, [houseSize] [varchar](20) NULL, [housePrice] [varchar](10) NULL, [houseWz] [varchar](20) NULL, CONSTRAINT [PK_house] PRIMARY KEY CLUSTERED ( [houseID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[admin]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[admin]( [adminName] [varchar](20) NOT NULL, [adminPwd] [varchar](20) NOT NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ( [adminName] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END