数据库mysql预约_预约系统（一） 数据库设计

1 USE [DB_Date_Plan]

2 GO

3 /****** Object: Table [dbo].[T_userInfo] Script Date: 07/13/2017 08:38:16 ******/

4 SET ANSI_NULLS ON

5 GO

6 SET QUOTED_IDENTIFIER ON

7 GO

8 CREATE TABLE [dbo].[T_userInfo](9 [id] [int] IDENTITY(1,1) NOT NULL,10 [userName] [nvarchar](50) NULL,11 [userPassword] [nvarchar](50) NULL,12 [userEmail] [nvarchar](50) NULL,13 [user_BM] [nvarchar](50) NULL,14 [add_time] [datetime] NULL,15 [user_FullName] [nvarchar](50) NULL,16 [user_Power] [nvarchar](50) NULL,17 CONSTRAINT [PK_T_userInfo] PRIMARY KEY CLUSTERED

18 (19 [id] ASC

20 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

21 ) ON [PRIMARY]

22 GO

23 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户权限，1-用户权限，2-管理员权限，3-超级权限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_userInfo', @level2type=N'COLUMN',@level2name=N'user_Power'

24 GO

25 /****** Object: Table [dbo].[T_room] Script Date: 07/13/2017 08:38:16 ******/

26 SET ANSI_NULLS ON

27 GO

28 SET QUOTED_IDENTIFIER ON

29 GO

30 CREATE TABLE [dbo].[T_room](31 [id] [bigint] IDENTITY(1,1) NOT NULL,32 [room_id] [nvarchar](50) NULL,33 [room_mc] [nvarchar](50) NULL,34 [adder] [nvarchar](50) NULL,35 [add_time] [datetime] NULL,36 CONSTRAINT [PK_T_room] PRIMARY KEY CLUSTERED

37 (38 [id] ASC

39 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

40 ) ON [PRIMARY]

41 GO

42 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会议室编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_room', @level2type=N'COLUMN',@level2name=N'room_id'

43 GO

44 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会议室名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_room', @level2type=N'COLUMN',@level2name=N'room_mc'

45 GO

46 /****** Object: Table [dbo].[T_kryy_plan] Script Date: 07/13/2017 08:38:16 ******/

47 SET ANSI_NULLS ON

48 GO

49 SET QUOTED_IDENTIFIER ON

50 GO

51 CREATE TABLE [dbo].[T_kryy_plan](52 [id] [bigint] IDENTITY(1,1) NOT NULL,53 [adder] [nvarchar](50) NULL,54 [add_time] [datetime] NULL,55 [rq] [nvarchar](50) NULL,56 [sjd] [nvarchar](50) NULL,57 [yyr] [nvarchar](50) NULL,58 [yybm] [nvarchar](50) NULL,59 [in_time] [datetime] NULL,60 [out_time] [datetime] NULL,61 [krxm] [nvarchar](50) NULL,62 [krgs] [nvarchar](50) NULL,63 [mqzt] [nvarchar](50) NULL,64 [ztsj] [nvarchar](50) NULL,65 [bz] [nvarchar](50) NULL,66 [flax] [nvarchar](50) NULL,67 [time_begin] [nvarchar](50) NULL,68 [time_end] [nvarchar](50) NULL,69 CONSTRAINT [PK_T_kryy_plan] PRIMARY KEY CLUSTERED

70 (71 [id] ASC

72 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

73 ) ON [PRIMARY]

74 GO

75 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'rq'

76 GO

77 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间段' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'sjd'

78 GO

79 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'yyr'

80 GO

81 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约人部门' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'yybm'

82 GO

83 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入厂时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'in_time'

84 GO

85 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'离厂时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'out_time'

86 GO

87 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'krxm'

88 GO

89 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客人单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'krgs'

90 GO

91 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目前状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'mqzt'

92 GO

93 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'ztsj'

94 GO

95 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'bz'

96 GO

97 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'flax'

98 GO

99 /****** Object: Table [dbo].[T_bm] Script Date: 07/13/2017 08:38:16 ******/

100 SET ANSI_NULLS ON

101 GO

102 SET QUOTED_IDENTIFIER ON

103 GO

104 CREATE TABLE [dbo].[T_bm](105 [id] [bigint] IDENTITY(1,1) NOT NULL,106 [bm_no] [nvarchar](50) NULL,107 [bm_mc] [nvarchar](50) NULL,108 [adder] [nvarchar](50) NULL,109 [add_time] [datetime] NULL,110 CONSTRAINT [PK_T_bm] PRIMARY KEY CLUSTERED

111 (112 [id] ASC

113 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

114 ) ON [PRIMARY]

115 GO

116 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门代号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_bm', @level2type=N'COLUMN',@level2name=N'bm_no'

117 GO

118 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_bm', @level2type=N'COLUMN',@level2name=N'bm_mc'

119 GO

120 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_bm', @level2type=N'COLUMN',@level2name=N'adder'

121 GO

122 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_bm', @level2type=N'COLUMN',@level2name=N'add_time'

123 GO

124 /****** Object: Table [dbo].[T_hys_plan] Script Date: 07/13/2017 08:38:16 ******/

125 SET ANSI_NULLS ON

126 GO

127 SET QUOTED_IDENTIFIER ON

128 GO

129 CREATE TABLE [dbo].[T_hys_plan](130 [id] [bigint] IDENTITY(1,1) NOT NULL,131 [add_time] [datetime] NULL,132 [adder] [nvarchar](50) NULL,133 [rq] [nvarchar](50) NULL,134 [time_begin] [nvarchar](50) NULL,135 [time_end] [nvarchar](50) NULL,136 [hys] [nvarchar](50) NULL,137 [yyr] [nvarchar](50) NULL,138 [yybm] [nvarchar](50) NULL,139 [hyzt] [nvarchar](100) NULL,140 [mqzt] [nvarchar](50) NULL,141 [lock_key] [nvarchar](50) NULL,142 [flax_while] [nvarchar](50) NULL,143 [flax_bz] [nvarchar](200) NULL,144 [zhou_x] [nvarchar](50) NULL,145 [yue_x] [nvarchar](50) NULL,146 [day_x] [nvarchar](50) NULL,147 [bz] [nvarchar](50) NULL,148 [flax] [nvarchar](50) NULL,149 CONSTRAINT [PK_T_hys] PRIMARY KEY CLUSTERED

150 (151 [id] ASC

152 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

153 ) ON [PRIMARY]

154 GO

155 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'add_time'

156 GO

157 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'adder'

158 GO

159 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'rq'

160 GO

161 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约开始时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'time_begin'

162 GO

163 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'time_end'

164 GO

165 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会议室' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'hys'

166 GO

167 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'yyr'

168 GO

169 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约部门' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'yybm'

170 GO

171 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会议主题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'hyzt'

172 GO

173 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目前状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'mqzt'

174 GO

175 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'lock_key'

176 GO

177 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否例会 0--不是例会，1--是例会' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'flax_while'

178 GO

179 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'例会备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'flax_bz'

180 GO

181 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'每周几' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'zhou_x'

182 GO

183 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'每月几号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'yue_x'

184 GO

185 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'每天' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'day_x'

186 GO

187 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'bz'

188 GO

189 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_hys_plan', @level2type=N'COLUMN',@level2name=N'flax'

190 GO

191 /****** Object: Table [dbo].[T_meetingroom] Script Date: 07/13/2017 08:38:16 ******/

192 SET ANSI_NULLS ON

193 GO

194 SET QUOTED_IDENTIFIER ON

195 GO

196 CREATE TABLE [dbo].[T_meetingroom](197 [id] [int] IDENTITY(1,1) NOT NULL,198 [meetingroom] [nvarchar](50) NULL,199 CONSTRAINT [PK_T_meetingroom] PRIMARY KEY CLUSTERED

200 (201 [id] ASC

202 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

203 ) ON [PRIMARY]

204 GO

205 /****** Object: Table [dbo].[T_time] Script Date: 07/13/2017 08:38:16 ******/

206 SET ANSI_NULLS ON

207 GO

208 SET QUOTED_IDENTIFIER ON

209 GO

210 CREATE TABLE [dbo].[T_time](211 [id] [int] IDENTITY(1,1) NOT NULL,212 [timeContent] [nvarchar](50) NOT NULL,213 CONSTRAINT [PK_T_time] PRIMARY KEY CLUSTERED

214 (215 [id] ASC

216 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

217 ) ON [PRIMARY]

218 GO

219 /****** Object: View [dbo].[T_meeting_plan] Script Date: 07/13/2017 08:38:17 ******/

220 SET ANSI_NULLS ON

221 GO

222 SET QUOTED_IDENTIFIER ON

223 GO

224 CREATE VIEW [dbo].[T_meeting_plan]

225 AS

226 SELECTid, add_time, adder, rq, time_begin, time_end, hys, yyr, yybm, hyzt, bz, mqzt, lock_key, flax_while, flax227 FROMdbo.T_hys_plan228 WHERE (flax_while = '0')229 GO

230 EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]231 Begin DesignProperties =232 Begin PaneConfigurations =233 Begin PaneConfiguration = 0234 NumPanes = 4235 Configuration = "(H (1[40] 4[20] 2[20] 3) )"236 End237 Begin PaneConfiguration = 1238 NumPanes = 3239 Configuration = "(H (1 [50] 4 [25] 3))"240 End241 Begin PaneConfiguration = 2242 NumPanes = 3243 Configuration = "(H (1 [50] 2 [25] 3))"244 End245 Begin PaneConfiguration = 3246 NumPanes = 3247 Configuration = "(H (4 [30] 2 [40] 3))"248 End249 Begin PaneConfiguration = 4250 NumPanes = 2251 Configuration = "(H (1 [56] 3))"252 End253 Begin PaneConfiguration = 5254 NumPanes = 2255 Configuration = "(H (2 [66] 3))"256 End257 Begin PaneConfiguration = 6258 NumPanes = 2259 Configuration = "(H (4 [50] 3))"260 End261 Begin PaneConfiguration = 7262 NumPanes = 1263 Configuration = "(V (3))"264 End265 Begin PaneConfiguration = 8266 NumPanes = 3267 Configuration = "(H (1[56] 4[18] 2) )"268 End269 Begin PaneConfiguration = 9270 NumPanes = 2271 Configuration = "(H (1 [75] 4))"272 End273 Begin PaneConfiguration = 10274 NumPanes = 2275 Configuration = "(H (1[66] 2) )"276 End277 Begin PaneConfiguration = 11278 NumPanes = 2279 Configuration = "(H (4 [60] 2))"280 End281 Begin PaneConfiguration = 12282 NumPanes = 1283 Configuration = "(H (1) )"284 End285 Begin PaneConfiguration = 13286 NumPanes = 1287 Configuration = "(V (4))"288 End289 Begin PaneConfiguration = 14290 NumPanes = 1291 Configuration = "(V (2))"292 End293 ActivePaneConfig = 0294 End295 Begin DiagramPane =296 Begin Origin =297 Top = 0298 Left = 0299 End300 Begin Tables =301 Begin Table = "T_hys_plan"302 Begin Extent =303 Top = 6304 Left = 38305 Bottom = 243306 Right = 171307 End308 DisplayFlags = 280309 TopColumn = 7310 End311 End312 End313 Begin SQLPane =314 End315 Begin DataPane =316 Begin ParameterDefaults = ""317 End318 End319 Begin CriteriaPane =320 Begin ColumnWidths = 11321 Column = 1440322 Alias = 900323 Table = 1170324 Output = 720325 Append = 1400326 NewValue = 1170327 SortType = 1350328 SortOrder = 1410329 GroupBy = 1350330 Filter = 1350331 Or = 1350332 Or = 1350333 Or = 1350334 End335 End336 End337 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'T_meeting_plan'

338 GO

339 EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'T_meeting_plan'

340 GO

341 /****** Object: Default [DF_T_bm_bm_no] Script Date: 07/13/2017 08:38:16 ******/

342 ALTER TABLE [dbo].[T_bm] ADD CONSTRAINT [DF_T_bm_bm_no] DEFAULT ('') FOR [bm_no]

343 GO

344 /****** Object: Default [DF_T_bm_bm_mc] Script Date: 07/13/2017 08:38:16 ******/

345 ALTER TABLE [dbo].[T_bm] ADD CONSTRAINT [DF_T_bm_bm_mc] DEFAULT ('') FOR [bm_mc]

346 GO

347 /****** Object: Default [DF_T_bm_adder] Script Date: 07/13/2017 08:38:16 ******/

348 ALTER TABLE [dbo].[T_bm] ADD CONSTRAINT [DF_T_bm_adder] DEFAULT ('') FOR [adder]

349 GO

350 /****** Object: Default [DF_T_bm_add_time] Script Date: 07/13/2017 08:38:16 ******/

351 ALTER TABLE [dbo].[T_bm] ADD CONSTRAINT [DF_T_bm_add_time] DEFAULT (CONVERT([varchar](100),getdate(),(20))) FOR [add_time]

352 GO

353 /****** Object: Default [DF_T_hys_add_time] Script Date: 07/13/2017 08:38:16 ******/

354 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_add_time] DEFAULT (CONVERT([varchar](100),getdate(),(20))) FOR [add_time]

355 GO

356 /****** Object: Default [DF_T_hys_adder] Script Date: 07/13/2017 08:38:16 ******/

357 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_adder] DEFAULT ('') FOR [adder]

358 GO

359 /****** Object: Default [DF_T_hys_hys] Script Date: 07/13/2017 08:38:16 ******/

360 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_hys] DEFAULT ('') FOR [hys]

361 GO

362 /****** Object: Default [DF_T_hys_yyr] Script Date: 07/13/2017 08:38:16 ******/

363 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_yyr] DEFAULT ('') FOR [yyr]

364 GO

365 /****** Object: Default [DF_T_hys_yybm] Script Date: 07/13/2017 08:38:16 ******/

366 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_yybm] DEFAULT ('') FOR [yybm]

367 GO

368 /****** Object: Default [DF_T_hys_hyzt] Script Date: 07/13/2017 08:38:16 ******/

369 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_hyzt] DEFAULT ('') FOR [hyzt]

370 GO

371 /****** Object: Default [DF_T_hys_mqzt] Script Date: 07/13/2017 08:38:16 ******/

372 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_mqzt] DEFAULT ('') FOR [mqzt]

373 GO

374 /****** Object: Default [DF_T_hys_lock_key] Script Date: 07/13/2017 08:38:16 ******/

375 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_lock_key] DEFAULT ('') FOR [lock_key]

376 GO

377 /****** Object: Default [DF_T_hys_plan_flax_while] Script Date: 07/13/2017 08:38:16 ******/

378 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_plan_flax_while] DEFAULT ('') FOR [flax_while]

379 GO

380 /****** Object: Default [DF_T_hys_plan_flax_bz] Script Date: 07/13/2017 08:38:16 ******/

381 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_plan_flax_bz] DEFAULT ('') FOR [flax_bz]

382 GO

383 /****** Object: Default [DF_T_hys_plan_zhou_x] Script Date: 07/13/2017 08:38:16 ******/

384 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_plan_zhou_x] DEFAULT ('') FOR [zhou_x]

385 GO

386 /****** Object: Default [DF_T_hys_plan_yue_x] Script Date: 07/13/2017 08:38:16 ******/

387 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_plan_yue_x] DEFAULT ('') FOR [yue_x]

388 GO

389 /****** Object: Default [DF_T_hys_plan_day_x] Script Date: 07/13/2017 08:38:16 ******/

390 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_plan_day_x] DEFAULT ('') FOR [day_x]

391 GO

392 /****** Object: Default [DF_T_hys_plan_bz] Script Date: 07/13/2017 08:38:16 ******/

393 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_plan_bz] DEFAULT ('') FOR [bz]

394 GO

395 /****** Object: Default [DF_T_hys_plan_flax] Script Date: 07/13/2017 08:38:16 ******/

396 ALTER TABLE [dbo].[T_hys_plan] ADD CONSTRAINT [DF_T_hys_plan_flax] DEFAULT ('') FOR [flax]

397 GO

398 /****** Object: Default [DF_T_kryy_plan_adder] Script Date: 07/13/2017 08:38:16 ******/

399 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_adder] DEFAULT ('') FOR [adder]

400 GO

401 /****** Object: Default [DF_T_kryy_plan_add_time] Script Date: 07/13/2017 08:38:16 ******/

402 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_add_time] DEFAULT (CONVERT([varchar](100),getdate(),(20))) FOR [add_time]

403 GO

404 /****** Object: Default [DF_T_kryy_plan_rq] Script Date: 07/13/2017 08:38:16 ******/

405 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_rq] DEFAULT ('') FOR [rq]

406 GO

407 /****** Object: Default [DF_T_kryy_plan_sjd] Script Date: 07/13/2017 08:38:16 ******/

408 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_sjd] DEFAULT ('') FOR [sjd]

409 GO

410 /****** Object: Default [DF_T_kryy_plan_yyr] Script Date: 07/13/2017 08:38:16 ******/

411 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_yyr] DEFAULT ('') FOR [yyr]

412 GO

413 /****** Object: Default [DF_T_kryy_plan_yybm] Script Date: 07/13/2017 08:38:16 ******/

414 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_yybm] DEFAULT ('') FOR [yybm]

415 GO

416 /****** Object: Default [DF_T_kryy_plan_krxm] Script Date: 07/13/2017 08:38:16 ******/

417 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_krxm] DEFAULT ('') FOR [krxm]

418 GO

419 /****** Object: Default [DF_T_kryy_plan_krgs] Script Date: 07/13/2017 08:38:16 ******/

420 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_krgs] DEFAULT ('') FOR [krgs]

421 GO

422 /****** Object: Default [DF_T_kryy_plan_mqzt] Script Date: 07/13/2017 08:38:16 ******/

423 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_mqzt] DEFAULT ('') FOR [mqzt]

424 GO

425 /****** Object: Default [DF_T_kryy_plan_ztsj] Script Date: 07/13/2017 08:38:16 ******/

426 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_ztsj] DEFAULT ('') FOR [ztsj]

427 GO

428 /****** Object: Default [DF_T_kryy_plan_bz] Script Date: 07/13/2017 08:38:16 ******/

429 ALTER TABLE [dbo].[T_kryy_plan] ADD CONSTRAINT [DF_T_kryy_plan_bz] DEFAULT ('') FOR [bz]

430 GO

431 /****** Object: Default [DF_T_room_room_id] Script Date: 07/13/2017 08:38:16 ******/

432 ALTER TABLE [dbo].[T_room] ADD CONSTRAINT [DF_T_room_room_id] DEFAULT ('') FOR [room_id]

433 GO

434 /****** Object: Default [DF_T_room_room_mc] Script Date: 07/13/2017 08:38:16 ******/

435 ALTER TABLE [dbo].[T_room] ADD CONSTRAINT [DF_T_room_room_mc] DEFAULT ('') FOR [room_mc]

436 GO

437 /****** Object: Default [DF_T_room_adder] Script Date: 07/13/2017 08:38:16 ******/

438 ALTER TABLE [dbo].[T_room] ADD CONSTRAINT [DF_T_room_adder] DEFAULT ('') FOR [adder]

439 GO

440 /****** Object: Default [DF_T_room_add_time] Script Date: 07/13/2017 08:38:16 ******/

441 ALTER TABLE [dbo].[T_room] ADD CONSTRAINT [DF_T_room_add_time] DEFAULT (CONVERT([varchar](100),getdate(),(20))) FOR [add_time]

442 GO

443 /****** Object: Default [DF_T_userInfo_add_time] Script Date: 07/13/2017 08:38:16 ******/

444 ALTER TABLE [dbo].[T_userInfo] ADD CONSTRAINT [DF_T_userInfo_add_time] DEFAULT (getdate()) FOR [add_time]

445 GO