数据库用的是mssql2005.
数据库表如下:
![](http://static.oschina.net/uploads/img/201503/03144338_smQt.gif)
![](http://static.oschina.net/uploads/img/201503/03144338_Vlw2.gif)
USE [RoomSchedule]
GO
/****** 对象: Table [dbo].[ClassRoom] 脚本日期: 02/07/2015 22:41:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClassRoom](
[Id] [int] IDENTITY(1000,1) NOT NULL,
[RoomName] [nvarchar](200) NULL,
[DepID] [int] NULL,
[Department] [nvarchar](200) NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
![](http://static.oschina.net/uploads/img/201503/03144338_smQt.gif)
![](http://static.oschina.net/uploads/img/201503/03144338_Vlw2.gif)
USE [RoomSchedule]
GO
/****** 对象: Table [dbo].[ClassRoomConfig] 脚本日期: 02/07/2015 22:42:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClassRoomConfig](
[Id] [int] IDENTITY(1000,1) NOT NULL,
[DaySpan] [int] NULL,
[StopTime] [int] NULL,
[RoomID] [int] NULL,
[RoomName] [nvarchar](200) NULL,
[ModifyDate] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
![](http://static.oschina.net/uploads/img/201503/03144338_smQt.gif)
![](http://static.oschina.net/uploads/img/201503/03144338_Vlw2.gif)
USE [RoomSchedule]
GO
/****** 对象: Table [dbo].[DepTable] 脚本日期: 02/07/2015 22:43:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DepTable](
[Id] [int] IDENTITY(100,1) NOT NULL,
[Department] [nvarchar](200) NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
![](http://static.oschina.net/uploads/img/201503/03144338_smQt.gif)
![](http://static.oschina.net/uploads/img/201503/03144338_Vlw2.gif)
USE [RoomSchedule]
GO
/****** 对象: Table [dbo].[Operate] 脚本日期: 02/07/2015 22:44:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Operate](
[Id] [int] IDENTITY(10000,1) NOT NULL,
[DateKey] [int] NULL,
[UserID] [nvarchar](100) NULL,
[UserName] [nvarchar](200) NULL,
[Comments] [nvarchar](800) NULL,
[StartTime] [int] NULL,
[EndTime] [int] NULL,
[Department] [nvarchar](100) NULL,
[RoomID] [int] NULL,
[RoomName] [nvarchar](100) NULL,
[UpdateTime] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
![](http://static.oschina.net/uploads/img/201503/03144338_smQt.gif)
![](http://static.oschina.net/uploads/img/201503/03144338_Vlw2.gif)
USE [RoomSchedule]
GO
/****** 对象: Table [dbo].[OperateRecord] 脚本日期: 02/07/2015 22:44:26 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OperateRecord](
[Id] [int] IDENTITY(10000,1) NOT NULL,
[StartTime] [int] NULL,
[EndTime] [int] NULL,
[DateKey] [int] NULL,
[RoomID] [int] NULL,
[RoomName] [nvarchar](200) NULL,
[Department] [nvarchar](100) NULL,
[UserID] [nvarchar](100) NULL,
[UserName] [nvarchar](200) NULL,
[DeleteDate] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
![](http://static.oschina.net/uploads/img/201503/03144338_smQt.gif)
![](http://static.oschina.net/uploads/img/201503/03144338_Vlw2.gif)
USE [RoomSchedule]
GO
/****** 对象: Table [dbo].[Users] 脚本日期: 02/07/2015 22:44:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
[Id] [int] IDENTITY(10000,1) NOT NULL,
[UserID] [nvarchar](200) NULL,
[Name] [nvarchar](200) NULL,
[Password] [nvarchar](200) NULL,
[Declaring] [nvarchar](200) NULL CONSTRAINT [rcUsersdefaultDeclaring] DEFAULT (''),
[Status] [int] NULL CONSTRAINT [UsersdefaultStatus] DEFAULT ((0)),
[IsMale] [bit] NULL CONSTRAINT [UsersdefaultIsMale] DEFAULT ((1)),
[UserLevel] [int] NULL CONSTRAINT [UsersdefaultUserLevel] DEFAULT ((1)),
[Enabled] [bit] NULL CONSTRAINT [UsersdefaultEnabled] DEFAULT ((1)),
[RegisterTime] [datetime] NULL CONSTRAINT [UsersdefaultRegisterTime] DEFAULT (getdate()),
[LastLoginTime] [datetime] NULL CONSTRAINT [UsersdefaultLastLoginTime] DEFAULT (getdate()),
[DepID] [int] NULL,
[Department] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
www.cnblogs.com/networkcomms
www.networkcomms.cn
【开源下载】基于TCP网络通信的即时聊天系统(IM系统)(c#源码)
【开源下载】基于winform的xml菜单编辑器(c#源码)