USE [master]
GO
/****** Object: Database [yygh_db] Script Date: 05/20/2014 00:04:48 ******/
CREATE DATABASE [yygh_db] ON PRIMARY
( NAME = N'yygh_db_Data', FILENAME = N'F:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\yygh_db_Data.MDF' , SIZE = 1792KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'yygh_db_Log', FILENAME = N'F:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\yygh_db_Log.LDF' , SIZE = 2816KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'yygh_db', @new_cmptlevel=80
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [yygh_db].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [yygh_db] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [yygh_db] SET ANSI_NULLS OFF
GO
ALTER DATABASE [yygh_db] SET ANSI_PADDING OFF
GO
ALTER DATABASE [yygh_db] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [yygh_db] SET ARITHABORT OFF
GO
ALTER DATABASE [yygh_db] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [yygh_db] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [yygh_db] SET AUTO_SHRINK ON
GO
ALTER DATABASE [yygh_db] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [yygh_db] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [yygh_db] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [yygh_db] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [yygh_db] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [yygh_db] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [yygh_db] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [yygh_db] SET ENABLE_BROKER
GO
ALTER DATABASE [yygh_db] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [yygh_db] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [yygh_db] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [yygh_db] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [yygh_db] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [yygh_db] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [yygh_db] SET READ_WRITE
GO
ALTER DATABASE [yygh_db] SET RECOVERY SIMPLE
GO
ALTER DATABASE [yygh_db] SET MULTI_USER
GO
ALTER DATABASE [yygh_db] SET PAGE_VERIFY TORN_PAGE_DETECTION
GO
ALTER DATABASE [yygh_db] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'yygh_db', N'ON'
GO
USE [yygh_db]
GO
/****** Object: Table [dbo].[yyjj] Script Date: 05/20/2014 00:04:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[yyjj](
[id] [int] IDENTITY(1,1) NOT NULL,
[remark] [text] NULL,
CONSTRAINT [PK_yyjj] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[yy] Script Date: 05/20/2014 00:04:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[yy](
[id] [int] IDENTITY(1,1) NOT NULL,
[ysid] [varchar](50) NULL,
[rq] [varchar](50) NULL,
[uid] [varchar](50) NULL,
[status] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[yspb] Script Date: 05/20/2014 00:04:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[yspb](
[id] [int] IDENTITY(1,1) NOT NULL,
[rq] [varchar](50) NULL,
[rs] [int] NULL,
[ysid] [varchar](50) NULL,
CONSTRAINT [PK_yspb] 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]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[sysuser] Script Date: 05/20/2014 00:04:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sysuser](
[id] [int] IDENTITY(1,1) NOT NULL,
[uname] [varchar](50) NULL,
[upass] [varchar](50) NULL,
[tname] [varchar](50) NULL,
[sex] [varchar](50) NULL,
[tel] [varchar](50) NULL,
[ks] [varchar](50) NULL,
[zc] [varchar](50) NULL,
[utype] [varchar](50) NULL,
[img] [varchar](50) NULL,
[delstatus] [varchar](50) NULL,
[idcard] [varchar](50) NULL,
[remark] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[notice] Script Date: 05/20/2014 00:04:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[notice](
[id] [int] IDENTITY(1,1) NOT NULL,
[title] [varchar](500) NULL,
[content] [text] NULL,
[savetime] [varchar](50) NULL,
CONSTRAINT [PK_notice] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ks] Script Date: 05/20/2014 00:04:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ks](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) NULL,
[type] [varchar](50) NULL,
[remark] [text] NULL,
[delstatus] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[br] Script Date: 05/20/2014 00:04:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[br](
[id] [int] IDENTITY(1,1) NOT NULL,
[uname] [varchar](50) NULL,
[upass] [varchar](50) NULL,
[tname] [varchar](50) NULL,
[age] [varchar](50) NULL,
[sex] [varchar](50) NULL,
[tel] [varchar](50) NULL,
[isblack] [varchar](50) NULL,
[delstatus] [varchar](50) NULL,
[idcard] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
qq_Dreamy_旧城_0