1.项目是用三层加WebFrom做的网站(下为文件结构)
(1).BFS_UI
(2).BFS_Model
(3).BFS_DAL
(4).BFS_BLL
2.后台管理 BFS_UI/Admin_BMS
3.数据库脚本
USE [master]
GO
/****** Object: Database [BFS] Script Date: 2018/6/4 8:43:11 /
CREATE DATABASE [BFS]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'BFS', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\BFS.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'BFS_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\BFS_log.ldf' , SIZE = 2048KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [BFS] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [BFS].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [BFS] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [BFS] SET ANSI_NULLS OFF
GO
ALTER DATABASE [BFS] SET ANSI_PADDING OFF
GO
ALTER DATABASE [BFS] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [BFS] SET ARITHABORT OFF
GO
ALTER DATABASE [BFS] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [BFS] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [BFS] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [BFS] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [BFS] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [BFS] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [BFS] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [BFS] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [BFS] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [BFS] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [BFS] SET DISABLE_BROKER
GO
ALTER DATABASE [BFS] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [BFS] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [BFS] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [BFS] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [BFS] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [BFS] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [BFS] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [BFS] SET RECOVERY FULL
GO
ALTER DATABASE [BFS] SET MULTI_USER
GO
ALTER DATABASE [BFS] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [BFS] SET DB_CHAINING OFF
GO
ALTER DATABASE [BFS] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [BFS] SET TARGET_RECOVERY_TIME = 0 SECONDS
GO
USE [BFS]
GO
/ Object: Table [dbo].[ActIvit] Script Date: 2018/6/4 8:43:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ActIvit](
[Act_ID] [int] IDENTITY(1,1) NOT NULL,
[Act_Title] nvarchar NOT NULL,
[Act_Content] nvarchar NOT NULL,
[Act_Img] nvarchar NOT NULL,
[Act_Time] [datetime] NULL,
CONSTRAINT [PK_ActIvit1_1] PRIMARY KEY CLUSTERED
(
[Act_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] TEXTIMAGE_ON [PRIMARY]
GO /****** Object: Table [dbo].[Back_Comment_Back] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Back_Comment_Back]( [BCB_ID] [int] IDENTITY(1,1) NOT NULL, [BCB_Content] nvarchar NOT NULL, [BCB_Time] [datetime] NOT NULL, [BCB_Users_Name] nchar NOT NULL, [BCBID] [int] NOT NULL, CONSTRAINT [PK_Back_Comment_Back] PRIMARY KEY CLUSTERED ( [BCB_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]
GO /****** Object: Table [dbo].[BBS] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BBS]( [BBS_ID] [int] IDENTITY(1,1) NOT NULL, [BBS_Title] nvarchar NOT NULL, [BBS_Time] [datetime] NOT NULL, [BBS_Img] nchar NULL, [BBS_Content] nvarchar NULL, [BBS_Users_Name] nchar NULL, [BBS_Cream] nchar NOT NULL, [BBS_Class] nchar NULL, CONSTRAINT [PK_BBS1] PRIMARY KEY CLUSTERED ( [BBS_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] TEXTIMAGE_ON [PRIMARY]
GO /****** Object: Table [dbo].[BBS_Comment] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BBS_Comment]( [BC_ID] [int] IDENTITY(1,1) NOT NULL, [BC_Content] nvarchar NULL, [BC_Time] [datetime] NOT NULL, [BC_Users_Name] nchar NOT NULL, [BC_BBS_ID] [int] NOT NULL, CONSTRAINT [PK_BBS_Comment] PRIMARY KEY CLUSTERED ( [BC_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] TEXTIMAGE_ON [PRIMARY]
GO /****** Object: Table [dbo].[BBS_Comment_Back] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BBS_Comment_Back]( [BCB_ID] [int] IDENTITY(1,1) NOT NULL, [BCB_Content] nvarchar NULL, [BCB_Time] [datetime] NOT NULL, [BCB_Users_Name] nchar NOT NULL, [BCB_BC_ID] [int] NOT NULL, CONSTRAINT [PK_BBS_Comment_Back] PRIMARY KEY CLUSTERED ( [BCB_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] TEXTIMAGE_ON [PRIMARY]
GO /****** Object: Table [dbo].[Card] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Card]( [Card_ID] [int] IDENTITY(1,1) NOT NULL, [Card_Name] nchar NOT NULL, [Card_Cost] [int] NOT NULL, [Card_Rd] nchar NULL, [Card_Hp] [int] NULL, [Card_Ap] [int] NULL, [Card_Effect] nvarchar NULL, [Card_Characteristic] nchar NULL, [Card_Race] nchar NULL, [Card_Occupation] nchar NULL, [Card_Off] nchar NULL, [Card_Img] nchar NULL, CONSTRAINT [PK_Card] PRIMARY KEY CLUSTERED ( [Card_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]
GO /****** Object: Table [dbo].[Live] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Live]( [Live_ID] [int] IDENTITY(1,1) NOT NULL, [Live_Title] nchar NOT NULL, [Live_Img] nchar NOT NULL, [Live_Url] nchar NOT NULL, CONSTRAINT [PK_Live] PRIMARY KEY CLUSTERED ( [Live_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]
GO /****** Object: Table [dbo].[News] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[News]( [News_ID] [int] IDENTITY(1,1) NOT NULL, [News_Title] nchar NOT NULL, [News_Time] [datetime] NOT NULL, [News_Conentent] nvarchar NULL, [News_Img] nchar NULL, [News_Num] [int] NOT NULL, [News_Class] nchar NULL, CONSTRAINT [PK_News1] PRIMARY KEY CLUSTERED ( [News_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] TEXTIMAGE_ON [PRIMARY]
GO /****** Object: Table [dbo].[News_Class] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[News_Class]( [News_Id] [int] NOT NULL, [News_Class] nvarchar NOT NULL, CONSTRAINT [PK_News_a] PRIMARY KEY CLUSTERED ( [News_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]
GO /****** Object: Table [dbo].[News_Comment_Back] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[News_Comment_Back]( [CB_ID] [int] IDENTITY(1,1) NOT NULL, [CB_Content] nvarchar NULL, [CB_Time] [datetime] NULL, [CB_Users_Name] nchar NOT NULL, [CB_NC_ID] [int] NOT NULL, CONSTRAINT [PK_News_Comment_Back] PRIMARY KEY CLUSTERED ( [CB_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] TEXTIMAGE_ON [PRIMARY]
GO /****** Object: Table [dbo].[News_Commentary] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[News_Commentary]( [NC_ID] [int] IDENTITY(1,1) NOT NULL, [NC_Content] nvarchar NULL, [NC_Time] [datetime] NULL, [NC_Users_Name] nchar NOT NULL, [NC_News_ID] [int] NOT NULL, CONSTRAINT [PK_News_Commentary] PRIMARY KEY CLUSTERED ( [NC_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] TEXTIMAGE_ON [PRIMARY]
GO /****** Object: Table [dbo].[Pic_Class] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Pic_Class]( [Pic_Id] [int] NOT NULL, [Pic_Class] nvarchar NOT NULL, CONSTRAINT [PK_Pic_a] PRIMARY KEY CLUSTERED ( [Pic_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]
GO /****** Object: Table [dbo].[Picture] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Picture]( [Pic_ID] [int] IDENTITY(1,1) NOT NULL, [Pic_Name] nchar NULL, [Pic_ImgUrl] varchar NOT NULL, [Pic_Class] nchar NOT NULL, CONSTRAINT [PK_Pic] PRIMARY KEY CLUSTERED ( [Pic_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]
GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Users] Script Date: 2018/6/4 8:43:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Users]( [Users_ID] [int] IDENTITY(1,1) NOT NULL, [Users_Name] nchar NOT NULL, [Users_Password] nchar NOT NULL, [Users_Tel] nchar NOT NULL, [Users_Sex] nchar NOT NULL, [Users_Img] nchar NOT NULL, [Users_Vip] [bit] NOT NULL, [Users_Admin] [bit] NOT NULL, CONSTRAINT [PK_Users1] PRIMARY KEY CLUSTERED ( [Users_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]
GO ALTER TABLE [dbo].[BBS] ADD CONSTRAINT [DF_BBS1_BBS_Cream] DEFAULT (N'否') FOR [BBS_Cream] GO ALTER TABLE [dbo].[Users] ADD CONSTRAINT [DF_Users1_Users_Sex] DEFAULT (N'男') FOR [Users_Sex] GO ALTER TABLE [dbo].[Users] ADD CONSTRAINT [DF_Users1_Users_Vip] DEFAULT ((0)) FOR [Users_Vip] GO ALTER TABLE [dbo].[Users] ADD CONSTRAINT [DF_Users1_Users_Admin] DEFAULT ((0)) FOR [Users_Admin] GO USE [master] GO ALTER DATABASE [BFS] SET READ_WRITE GO