USE [design]
GO
/****** Object: Table [dbo].[rolelinkmenu] Script Date: 04/25/2015 08:46:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[rolelinkmenu](
[linkid] [int] IDENTITY(1,1) NOT NULL,
[roleid] [int] NULL,
[menuid] [int] NULL,
PRIMARY KEY CLUSTERED
(
[linkid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[rolelinkmenu] ON
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (1, 1, 1)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (2, 1, 2)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (3, 1, 3)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (4, 1, 4)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (8, 2, 4)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (9, 3, 5)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (10, 3, 6)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (11, 2, 7)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (12, 1, 8)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (13, 2, 8)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (14, 3, 8)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (19, 4, 1)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (20, 4, 2)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (21, 4, 3)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (22, 4, 4)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (23, 4, 5)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (24, 4, 6)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (25, 4, 7)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (26, 4, 8)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (27, 4, 9)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (28, 2, 11)
INSERT [dbo].[rolelinkmenu] ([linkid], [roleid], [menuid]) VALUES (29, 5, 4)
SET IDENTITY_INSERT [dbo].[rolelinkmenu] OFF
/****** Object: Table [dbo].[role] Script Date: 04/25/2015 08:46:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[role](
[roleid] [int] IDENTITY(1,1) NOT NULL,
[rolename] [nvarchar](255) NULL,
[roledesc] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[roleid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[role] ON
INSERT [dbo].[role] ([roleid], [rolename], [roledesc]) VALUES (1, N'超级管理员', N'这是超级管理员,类似与年纪主任级别 现有的角色不能删除')
INSERT [dbo].[role] ([roleid], [rolename], [roledesc]) VALUES (2, N'教师', N'负责出题')
INSERT [dbo].[role] ([roleid], [rolename], [roledesc]) VALUES (3, N'学生', N'学生就是用来做毕业设计的')
INSERT [dbo].[role] ([roleid], [rolename], [roledesc]) VALUES (5, N'超级出题员', N'专门负责出题')
SET IDENTITY_INSERT [dbo].[role] OFF
/****** Object: Table [dbo].[progress] Script Date: 04/25/2015 08:46:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[progress](
[proid] [int] IDENTITY(1,1) NOT NULL,
[title] [nvarchar](255) NULL,
[mycontent] [nvarchar](4000) NULL,
[prodate] [date] NULL,
PRIMARY KEY CLUSTERED
(
[proid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[progress] ON
INSERT [dbo].[progress] ([proid], [title], [mycontent], [prodate]) VALUES (1, N'2013年进度安排', N'<p class="MsoNormal" style="margin-left:0cm;text-align:left;text-indent:21.0pt;vertical-align:baseline;" align="left">
<span style="font-family:宋体;"><sp�