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%)GOEXEC dbo.sp_dbcmptlevel @dbname=N'yygh_db', @new_cmptlevel=80GOIF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC [yygh_db].[dbo].[sp_fulltext_database] @action = 'disable'endGOALTER DATABASE [yygh_db] SET ANSI_NULL_DEFAULT OFFGOALTER DATABASE [yygh_db] SET ANSI_NULLS OFFGOALTER DATABASE [yygh_db] SET ANSI_PADDING OFFGOALTER DATABASE [yygh_db] SET ANSI_WARNINGS OFFGOALTER DATABASE [yygh_db] SET ARITHABORT OFFGOALTER DATABASE [yygh_db] SET AUTO_CLOSE OFFGOALTER DATABASE [yygh_db] SET AUTO_CREATE_STATISTICS ONGOALTER DATABASE [yygh_db] SET AUTO_SHRINK ONGOALTER DATABASE [yygh_db] SET AUTO_UPDATE_STATISTICS ONGOALTER DATABASE [yygh_db] SET CURSOR_CLOSE_ON_COMMIT OFFGOALTER DATABASE [yygh_db] SET CURSOR_DEFAULT  GLOBALGOALTER DATABASE [yygh_db] SET CONCAT_NULL_YIELDS_NULL OFFGOALTER DATABASE [yygh_db] SET NUMERIC_ROUNDABORT OFFGOALTER DATABASE [yygh_db] SET QUOTED_IDENTIFIER OFFGOALTER DATABASE [yygh_db] SET RECURSIVE_TRIGGERS OFFGOALTER DATABASE [yygh_db] SET  ENABLE_BROKERGOALTER DATABASE [yygh_db] SET AUTO_UPDATE_STATISTICS_ASYNC OFFGOALTER DATABASE [yygh_db] SET DATE_CORRELATION_OPTIMIZATION OFFGOALTER DATABASE [yygh_db] SET TRUSTWORTHY OFFGOALTER DATABASE [yygh_db] SET ALLOW_SNAPSHOT_ISOLATION OFFGOALTER DATABASE [yygh_db] SET PARAMETERIZATION SIMPLEGOALTER DATABASE [yygh_db] SET READ_COMMITTED_SNAPSHOT OFFGOALTER DATABASE [yygh_db] SET  READ_WRITEGOALTER DATABASE [yygh_db] SET RECOVERY SIMPLEGOALTER DATABASE [yygh_db] SET  MULTI_USERGOALTER DATABASE [yygh_db] SET PAGE_VERIFY TORN_PAGE_DETECTIONGOALTER DATABASE [yygh_db] SET DB_CHAINING OFFGOEXEC sys.sp_db_vardecimal_storage_format N'yygh_db', N'ON'GOUSE [yygh_db]GO/****** Object:  Table [dbo].[yyjj]    Script Date: 05/20/2014 00:04:50 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE 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 ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE 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]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[yspb]    Script Date: 05/20/2014 00:04:50 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE 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]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[sysuser]    Script Date: 05/20/2014 00:04:50 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE 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]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[notice]    Script Date: 05/20/2014 00:04:50 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE 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]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[ks]    Script Date: 05/20/2014 00:04:50 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE 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]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[br]    Script Date: 05/20/2014 00:04:50 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE 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]GOSET ANSI_PADDING OFFGO