简单商品房销售系统源码.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].[house]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[house]( [houseID] [varchar](10) NOT NULL, [houseUser] [varchar](20) NULL, [housezb] [varchar](50) NOT NULL, [houseSize] [varchar](20) NOT NULL, [houseFunction] [varchar](20) NOT NULL, [houseInfo] [varchar](100) NOT NULL, [houseImage] [varchar](10) NULL, CONSTRAINT [PK_house] PRIMARY KEY CLUSTERED ( [houseID] 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].[message]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[message]( [id] [int] IDENTITY(1,1) NOT NULL, [title] [varchar](50) NULL, [content] [varchar](100) NOT NULL, [reply] [varchar](100) NULL, [face] [varchar](5) NULL, [time] [datetime] NULL, [userID] [varchar](20) NULL, CONSTRAINT [PK_message] PRIMARY KEY CLUSTERED ( [id] 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].[contact]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[contact]( [id] [varchar](50) NOT NULL, [text] [text] NOT NULL, CONSTRAINT [PK_contact] PRIMARY KEY CLUSTERED ( [id] 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]( [adminID] [varchar](20) NOT NULL, [adminPwd] [varchar](20) NOT NULL, CONSTRAINT [PK_admin] PRIMARY KEY CLUSTERED ( [adminID] 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].[user]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[user]( [userID] [varchar](20) NOT NULL, [userPwd] [varchar](20) NOT NULL, [userName] [varchar](20) NOT NULL, [userSex] [char](2) NOT NULL, [userPhone] [varchar](15) NULL, [userMail] [varchar](50) NULL, [userAddress] [varchar](50) NULL, CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED ( [userID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END