BVB Source Codes

1.0 housing, rental housing sale platform Show House.sql Source code

Return Download 1.0 housing, rental housing sale platform: download House.sql Source code - Download 1.0 housing, rental housing sale platform Source code - Type:.sql
  1. SE [master]
  2.  
  3. GO
  4.  
  5. /****** Object: Database [House] Script Date: 08/06/2014 18:04:38 ******/
  6.  
  7. CREATE DATABASE [House] ON PRIMARY
  8.  
  9. ( NAME = N'House', FILENAME = N'F:\C#\ASP,NET WebSite\House\DB\House.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  10.  
  11. LOG ON
  12.  
  13. ( NAME = N'House_log', FILENAME = N'F:\C#\ASP,NET WebSite\House\DB\House_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
  14.  
  15. GO
  16.  
  17. ALTER DATABASE [House] SET COMPATIBILITY_LEVEL = 100
  18.  
  19. GO
  20.  
  21. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  22.  
  23. begin
  24.  
  25. EXEC [House].[dbo].[sp_fulltext_database] @action = 'enable'
  26.  
  27. end
  28.  
  29. GO
  30.  
  31. ALTER DATABASE [House] SET ANSI_NULL_DEFAULT OFF
  32.  
  33. GO
  34.  
  35. ALTER DATABASE [House] SET ANSI_NULLS OFF
  36.  
  37. GO
  38.  
  39. ALTER DATABASE [House] SET ANSI_PADDING OFF
  40.  
  41. GO
  42.  
  43. ALTER DATABASE [House] SET ANSI_WARNINGS OFF
  44.  
  45. GO
  46.  
  47. ALTER DATABASE [House] SET ARITHABORT OFF
  48.  
  49. GO
  50.  
  51. ALTER DATABASE [House] SET AUTO_CLOSE OFF
  52.  
  53. GO
  54.  
  55. ALTER DATABASE [House] SET AUTO_CREATE_STATISTICS ON
  56.  
  57. GO
  58.  
  59. ALTER DATABASE [House] SET AUTO_SHRINK OFF
  60.  
  61. GO
  62.  
  63. ALTER DATABASE [House] SET AUTO_UPDATE_STATISTICS ON
  64.  
  65. GO
  66.  
  67. ALTER DATABASE [House] SET CURSOR_CLOSE_ON_COMMIT OFF
  68.  
  69. GO
  70.  
  71. ALTER DATABASE [House] SET CURSOR_DEFAULT GLOBAL
  72.  
  73. GO
  74.  
  75. ALTER DATABASE [House] SET CONCAT_NULL_YIELDS_NULL OFF
  76.  
  77. GO
  78.  
  79. ALTER DATABASE [House] SET NUMERIC_ROUNDABORT OFF
  80.  
  81. GO
  82.  
  83. ALTER DATABASE [House] SET QUOTED_IDENTIFIER OFF
  84.  
  85. GO
  86.  
  87. ALTER DATABASE [House] SET RECURSIVE_TRIGGERS OFF
  88.  
  89. GO
  90.  
  91. ALTER DATABASE [House] SET DISABLE_BROKER
  92.  
  93. GO
  94.  
  95. ALTER DATABASE [House] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  96.  
  97. GO
  98.  
  99. ALTER DATABASE [House] SET DATE_CORRELATION_OPTIMIZATION OFF
  100.  
  101. GO
  102.  
  103. ALTER DATABASE [House] SET TRUSTWORTHY OFF
  104.  
  105. GO
  106.  
  107. ALTER DATABASE [House] SET ALLOW_SNAPSHOT_ISOLATION OFF
  108.  
  109. GO
  110.  
  111. ALTER DATABASE [House] SET PARAMETERIZATION SIMPLE
  112.  
  113. GO
  114.  
  115. ALTER DATABASE [House] SET READ_COMMITTED_SNAPSHOT OFF
  116.  
  117. GO
  118.  
  119. ALTER DATABASE [House] SET HONOR_BROKER_PRIORITY OFF
  120.  
  121. GO
  122.  
  123. ALTER DATABASE [House] SET READ_WRITE
  124.  
  125. GO
  126.  
  127. ALTER DATABASE [House] SET RECOVERY FULL
  128.  
  129. GO
  130.  
  131. ALTER DATABASE [House] SET MULTI_USER
  132.  
  133. GO
  134.  
  135. ALTER DATABASE [House] SET PAGE_VERIFY CHECKSUM
  136.  
  137. GO
  138.  
  139. ALTER DATABASE [House] SET DB_CHAINING OFF
  140.  
  141. GO
  142.  
  143. EXEC sys.sp_db_vardecimal_storage_format N'House', N'ON'
  144.  
  145. GO
  146.  
  147. USE [House]
  148.  
  149. GO
  150.  
  151. /****** Object: Table [dbo].[District] Script Date: 08/06/2014 18:04:39 ******/
  152.  
  153. SET ANSI_NULLS ON
  154.  
  155. GO
  156.  
  157. SET QUOTED_IDENTIFIER ON
  158.  
  159. GO
  160.  
  161. CREATE TABLE [dbo].[District](
  162.  
  163.       [Id] [int] NOT NULL,
  164.  
  165.       [Name] [nvarchar](50) NULL,
  166.  
  167. CONSTRAINT [PK_District] PRIMARY KEY CLUSTERED
  168.  
  169. (
  170.  
  171.       [Id] ASC
  172.  
  173. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  174.  
  175. ) ON [PRIMARY]
  176.  
  177. GO
  178.  
  179. INSERT [dbo].[District] ([Id], [Name]) VALUES (1000, N'0N餝')
  180.  
  181. INSERT [dbo].[District] ([Id], [Name]) VALUES (1001, N'N蜽')
  182.  
  183. INSERT [dbo].[District] ([Id], [Name]) VALUES (1002, N'壩W')
  184.  
  185. INSERT [dbo].[District] ([Id], [Name]) VALUES (1003, N'體ofq\')
  186. INSERT [dbo].[District] ([Id], [Name]) VALUES (1004, N'wm續')
  187. INSERT [dbo].[District] ([Id], [Name]) VALUES (1006, N'g3?)
  188.  
  189. /****** Object: Table [dbo].[HouseType] Script Date: 08/06/2014 18:04:39 ******/
  190.  
  191. SET ANSI_NULLS ON
  192.  
  193. GO
  194.  
  195. SET QUOTED_IDENTIFIER ON
  196.  
  197. GO
  198.  
  199. CREATE TABLE [dbo].[HouseType](
  200.  
  201.       [Id] [int] NOT NULL,
  202.  
  203.       [Name] [nvarchar](10) NOT NULL,
  204.  
  205. CONSTRAINT [PK_HouseType] PRIMARY KEY CLUSTERED
  206.  
  207. (
  208.  
  209.       [Id] ASC
  210.  
  211. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  212.  
  213. ) ON [PRIMARY]
  214.  
  215. GO
  216.  
  217. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1000, N'NN匰')
  218.  
  219. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1001, N'N$N匰')
  220.  
  221. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1002, N'$NN匰')
  222.  
  223. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1003, N'$N$N匰')
  224.  
  225. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1004, N'       NN匰')
  226.  
  227. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1005, N'       N$N匰')
  228.  
  229. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1006, N'踁N匰')
  230.  
  231. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1007, N'踁$N匰')
  232.  
  233. INSERT [dbo].[HouseType] ([Id], [Name]) VALUES (1008, N'踁 N匰')
  234.  
  235. /****** Object: Table [dbo].[User] Script Date: 08/06/2014 18:04:39 ******/
  236.  
  237. SET ANSI_NULLS ON
  238.  
  239. GO
  240.  
  241. SET QUOTED_IDENTIFIER ON
  242.  
  243. GO
  244.  
  245. CREATE TABLE [dbo].[User](
  246.  
  247.       [LoginId] [int] IDENTITY(10000,1) NOT NULL,
  248.  
  249.       [LoginName] [nvarchar](20) NOT NULL,
  250.  
  251.       [UserName] [nvarchar](10) NOT NULL,
  252.  
  253.       [Password] [nvarchar](50) NOT NULL,
  254.  
  255.       [Telephone] [nvarchar](20) NULL,
  256.  
  257. CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
  258.  
  259. (
  260.  
  261.       [LoginId] ASC
  262.  
  263. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  264.  
  265. ) ON [PRIMARY]
  266.  
  267. GO
  268.  
  269. SET IDENTITY_INSERT [dbo].[User] ON
  270.  
  271. INSERT [dbo].[User] ([LoginId], [LoginName], [UserName], [Password], [Telephone]) VALUES (10001, N'admin', N'admin', N'admin', NULL)
  272.  
  273. INSERT [dbo].[User] ([LoginId], [LoginName], [UserName], [Password], [Telephone]) VALUES (10002, N'hlg_owner', N'S鷁 f', N'123', N'18612346578')
  274.  
  275. INSERT [dbo].[User] ([LoginId], [LoginName], [UserName], [Password], [Telephone]) VALUES (10003, N'tty_owner', N'H杍?, N'123', N'56567878')
  276. SET IDENTITY_INSERT [dbo].[User] OFF
  277. /****** Object: Table [dbo].[Street] Script Date: 08/06/2014 18:04:39 ******/
  278. SET ANSI_NULLS ON
  279. GO
  280. SET QUOTED_IDENTIFIER ON
  281. GO
  282. CREATE TABLE [dbo].[Street](
  283.       [Id] [int] NOT NULL,
  284.       [Name] [nvarchar](50) NOT NULL,
  285.       [DistrictId] [int] NOT NULL,
  286. CONSTRAINT [PK_Street] PRIMARY KEY CLUSTERED
  287. (
  288.       [Id] ASC
  289. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  290. ) ON [PRIMARY]
  291. GO
  292. INSERT [dbo].[Street] ([Id], [Name], [DistrictId]) VALUES (1000, N'鍂%f飴', 1004)
  293. INSERT [dbo].[Street] ([Id], [Name], [DistrictId]) VALUES (1001, N'-NsQQg'YW?, 1004)
  294. INSERT [dbo].[Street] ([Id], [Name], [DistrictId]) VALUES (1002, N'f[b栵?, 1004)
  295.  
  296. INSERT [dbo].[Street] ([Id], [Name], [DistrictId]) VALUES (1003, N'g3栵?, 1006)
  297. /****** Object: Table [dbo].[House] Script Date: 08/06/2014 18:04:39 ******/
  298. SET ANSI_NULLS ON
  299. GO
  300. SET QUOTED_IDENTIFIER ON
  301. GO
  302. CREATE TABLE [dbo].[House](
  303.       [HouseId] [int] IDENTITY(1,1) NOT NULL,
  304.       [Title] [nvarchar](50) NOT NULL,
  305.       [TypeId] [int] NOT NULL,
  306.       [Floorage] [decimal](18, 2) NOT NULL,
  307.       [Price] [decimal](18, 2) NOT NULL,
  308.       [StreetId] [int] NOT NULL,
  309.       [Contract] [nvarchar](50) NOT NULL,
  310.       [Description] [nvarchar](1000) NULL,
  311.       [PublishUser] [int] NOT NULL,
  312.       [PublishTime] [datetime] NOT NULL,
  313. CONSTRAINT [PK_House] PRIMARY KEY CLUSTERED
  314. (
  315.       [HouseId] ASC
  316. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  317. ) ON [PRIMARY]
  318. GO
  319. SET IDENTITY_INSERT [dbo].[House] ON
  320. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (2, N'鍂%f飴56鱏b '}粣13鱏縹', 1002, CAST(61.60 AS Decimal(18, 2)), CAST(4500.00 AS Decimal(18, 2)), 1000, N'13522039951', N'WSS 禰5uP焗Q 蝏SeQOO0', 10002, CAST(0x0000A1F300C0618A AS DateTime))
  321.  
  322. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (3, N'鍂%f飴W刕N虘WSS?, 1002, CAST(58.00 AS Decimal(18, 2)), CAST(3800.00 AS Decimal(18, 2)), 1000, N'1352210787', N'ck膲$NE\ WSS (g0Wg ?bP[^?^r^繯 軴c梍坃}Y0禰5uP焗Q 蝏SeQOO0', 10002, CAST(0x0000A1F300C15DEE AS DateTime))
  323. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (4, N'-NsQQg'Y;NgS', 1004, CAST(18.00 AS Decimal(18, 2)), CAST(1500.00 AS Decimal(18, 2)), 1001, N'55457788', N''Y;NgS S'Y羍箯 r^繯0', 10002, CAST(0x0000A1F300F8B598 AS DateTime))
  324.  
  325. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (5, N'g3NE\4N6鱏縹', 1000, CAST(40.00 AS Decimal(18, 2)), CAST(2600.00 AS Decimal(18, 2)), 1003, N'55457788', N'癳艌頞剉NE\  ^g遹賬f[ub+Y籝0', 10002, CAST(0x0000A1F300F92E86 AS DateTime))
  326.  
  327. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (6, N'R棏N\:SUS魰', 1002, CAST(10.00 AS Decimal(18, 2)), CAST(900.00 AS Decimal(18, 2)), 1000, N'13522039951', N'孨@\-N剉N*N\US魰  ^g遹賬u;m    g膲媉剉>yO篘隭bf[u0', 10002, CAST(0x0000A1F300F9A355 AS DateTime))
  328.  
  329. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (7, N'S異f[u縖
  330. ?奮MO', 1000, CAST(6.00 AS Decimal(18, 2)), CAST(300.00 AS Decimal(18, 2)), 1002, N'18711234566', N'S異xvzu縖
  331. ?奮MO鶴遹', 10002, CAST(0x0000A1F300FA53F8 AS DateTime))
  332.  
  333. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (9, N'篘'Y}YUS魰鶴遹', 1004, CAST(12.00 AS Decimal(18, 2)), CAST(1200.00 AS Decimal(18, 2)), 1001, N'18645456766', N'鍕?bP[騗   g$N遹7beQOO Bl1篘T遹 7usY
  334. NP u;m^?^筫縊0', 10003, CAST(0x0000A25000B7964C AS DateTime))
  335. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (14, N''Yh魰鶴遹', 1000, CAST(30.00 AS Decimal(18, 2)), CAST(500.00 AS Decimal(18, 2)), 1002, N'13132132', N'蛻璬S_b`O剉鎝|`剉`O', 10001, CAST(0x0000A37F011F7C63 AS DateTime))
  336.  
  337. INSERT [dbo].[House] ([HouseId], [Title], [TypeId], [Floorage], [Price], [StreetId], [Contract], [Description], [PublishUser], [PublishTime]) VALUES (15, N'test', 1004, CAST(150.00 AS Decimal(18, 2)), CAST(5000.00 AS Decimal(18, 2)), 1003, N'13132132', N'test', 10001, CAST(0x0000A37F012242FD AS DateTime))
  338.  
  339. SET IDENTITY_INSERT [dbo].[House] OFF
  340.  
  341. /****** Object: Default [DF_House_PublishTime] Script Date: 08/06/2014 18:04:39 ******/
  342.  
  343. ALTER TABLE [dbo].[House] ADD CONSTRAINT [DF_House_PublishTime] DEFAULT (getdate()) FOR [PublishTime]
  344.  
  345. GO
  346.  
  347. /****** Object: ForeignKey [FK_Street_District] Script Date: 08/06/2014 18:04:39 ******/
  348.  
  349. ALTER TABLE [dbo].[Street] WITH CHECK ADD CONSTRAINT [FK_Street_District] FOREIGN KEY([DistrictId])
  350.  
  351. REFERENCES [dbo].[District] ([Id])
  352.  
  353. GO
  354.  
  355. ALTER TABLE [dbo].[Street] CHECK CONSTRAINT [FK_Street_District]
  356.  
  357. GO
  358.  
  359. /****** Object: ForeignKey [FK_House_House] Script Date: 08/06/2014 18:04:39 ******/
  360.  
  361. ALTER TABLE [dbo].[House] WITH CHECK ADD CONSTRAINT [FK_House_House] FOREIGN KEY([PublishUser])
  362.  
  363. REFERENCES [dbo].[User] ([LoginId])
  364.  
  365. GO
  366.  
  367. ALTER TABLE [dbo].[House] CHECK CONSTRAINT [FK_House_House]
  368.  
  369. GO
  370.  
  371. /****** Object: ForeignKey [FK_House_HouseType] Script Date: 08/06/2014 18:04:39 ******/
  372.  
  373. ALTER TABLE [dbo].[House] WITH CHECK ADD CONSTRAINT [FK_House_HouseType] FOREIGN KEY([TypeId])
  374.  
  375. REFERENCES [dbo].[HouseType] ([Id])
  376.  
  377. GO
  378.  
  379. ALTER TABLE [dbo].[House] CHECK CONSTRAINT [FK_House_HouseType]
  380.  
  381. GO
  382.  
  383. /****** Object: ForeignKey [FK_House_Street] Script Date: 08/06/2014 18:04:39 ******/
  384.  
  385. ALTER TABLE [dbo].[House] WITH CHECK ADD CONSTRAINT [FK_House_Street] FOREIGN KEY([StreetId])
  386.  
  387. REFERENCES [dbo].[Street] ([Id])
  388.  
  389. GO
  390.  
  391. ALTER TABLE [dbo].[House] CHECK CONSTRAINT [FK_House_Street]
  392.  
  393. GO
  394.  
  395.  
downloadHouse.sql Source code - Download 1.0 housing, rental housing sale platform Source code
Related Source Codes/Software:
Cloud on the CMS (SyCms) v1.95 - Add menus and blocks the system style functionalit... 2016-08-19
SuperSocket v1.6.6 - SuperSocket the Socket is a lightweight and extens... 2016-08-19
Students' basic information input program v2.0 - 1, the program is based on. net4.0 framework and d... 2016-08-19
Student information input system v2.0 - 1, the program is based on. net4.0 framework and d... 2016-08-19
Baidu handwriting input source v1.0 - Baidu handwriting input method source code, no nee... 2016-08-19
Deng Xi v2.4 website help system - Deng Xi website help system is a very useful help ... 2016-08-19
Address book v1.0 FaLiang three layer - This Demo is a three layer address book source cod... 2016-08-19
Ray speed v7.0 wage query system - To modify the software to conduct a comprehensive ... 2016-08-19
Easy to point the content management system DianCMS v6.0.0 SQL version - Easy content management system (DianCMS) is based ... 2016-08-19
KesionICMS intelligent website system (school) v3.7 formal version - For school management web site, the kesion forward... 2016-08-19
hologram - A markdown based documentation system for style gu... 2017-05-12
www.html5rocks.com - ....a top-notch resource for web developer 2017-05-12
MTStatusBarOverlay - A custom iOS status bar overlay seen in Apps like ... 2017-05-12
blueprint - Reverse engineer server configuration ... 2017-05-12
PullToRefresh - A simple iPhone TableViewController for adding the... 2017-05-12
mrjob - Run MapReduce jobs on Hadoop or Amazon Web Service... 2017-05-11
wax - Wax is now being maintained by alibaba ... 2017-05-11
ledisdb - a high performance NoSQL powered by Go ... 2017-05-11
d3-cloud - Create word clouds in JavaScript. ... 2017-05-11
react-makes-you-sad - Here's a flowchart to make you happy again! 2017-05-11

 Back to top