USE [master]GO/****** Object:? Database [yygh_db]??? Script Date: 04/16/2015 15:52:19 ******/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? DISABLE_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: 04/16/2015 15:52:20 ******/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]GOSET IDENTITY_INSERT [dbo].[yyjj] ONINSERT [dbo].[yyjj] ([id], [remark]) VALUES (1, N'<p>我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院我們是一家三級甲等醫(yī)院</p>')SET IDENTITY_INSERT [dbo].[yyjj] OFF/****** Object:? Table [dbo].[yy]??? Script Date: 04/16/2015 15:52:20 ******/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,?? ?[lsno] [varchar](50) NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGOSET IDENTITY_INSERT [dbo].[yy] ONINSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (20, N'2', N'2014-05-20', N'2', N'完成', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (18, N'2', N'2014-05-19', N'1', N'完成', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (21, N'3', N'2014-05-21', N'2', N'待診', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (22, N'2', N'2014-05-20', N'8', N'完成', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (23, N'2', N'2014-05-26', N'1', N'待診', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (24, N'2', N'2014-05-26', N'2', N'完成', N'20140525011200')SET IDENTITY_INSERT [dbo].[yy] OFF/****** Object:? Table [dbo].[yspb]??? Script Date: 04/16/2015 15:52:20 ******/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 OFFGOSET IDENTITY_INSERT [dbo].[yspb] ONINSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (1, N'2014-05-19', 5, N'2')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (2, N'2014-05-20', 4, N'2')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (3, N'2014-05-21', 6, N'2')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (4, N'2014-05-19', 2, N'3')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (5, N'2014-05-20', 6, N'3')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (6, N'2014-05-21', 5, N'3')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (8, N'2014-05-26', 5, N'2')SET IDENTITY_INSERT [dbo].[yspb] OFF/****** Object:? Table [dbo].[sysuser]??? Script Date: 04/16/2015 15:52:20 ******/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 OFFGOSET IDENTITY_INSERT [dbo].[sysuser] ONINSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (1, N'admin', N'123', N'管理員', N'男', N'13888888888', N'null', N'null', N'管理員', NULL, N'0', NULL, NULL)INSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (2, N'xm', N'123', N'王醫(yī)生', N'女', N'13333333333', N'3', N'高級', N'醫(yī)生', N'201405171227540003.jpg', N'0', N'', N'asefawegfaqwe')INSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (3, N'xh', N'123', N'陳醫(yī)生', N'女', N'13512344321', N'3', N'中級', N'醫(yī)生', N'201405171153350001.jpg', N'0', NULL, NULL)INSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (5, N'aa', N'123', N'陳醫(yī)生', N'男', N'13000000000', N'2', N'初級', N'醫(yī)生', N'201405192336450002.jpg', N'0', N'1241234234', N'123412341234')INSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (6, N'bb', N'123', N'張醫(yī)生', N'男', N'15512344321', N'4', N'中級', N'醫(yī)生', N'201405192337440003.jpg', N'0', N'123123123123123123', N'45保護(hù)膜')SET IDENTITY_INSERT [dbo].[sysuser] OFF/****** Object:? Table [dbo].[notice]??? Script Date: 04/16/2015 15:52:20 ******/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 OFFGOSET IDENTITY_INSERT [dbo].[notice] ONINSERT [dbo].[notice] ([id], [title], [content], [savetime]) VALUES (2, N'測試新聞一', N'<p>測試新聞一測試新聞一測試新聞一</p>', N'2014-05-18 01:06:37')INSERT [dbo].[notice] ([id], [title], [content], [savetime]) VALUES (3, N'測試新聞二', N'<p>測試新聞二測試新聞二測試新聞二</p>', N'2014-05-18 01:06:44')INSERT [dbo].[notice] ([id], [title], [content], [savetime]) VALUES (4, N'測試新聞三', N'<p>測試新聞三測試新聞三測試新聞三</p>', N'2014-05-19 22:49:39')INSERT [dbo].[notice] ([id], [title], [content], [savetime]) VALUES (5, N'測試新聞四', N'<p>測試新聞四測試新聞四測試新聞四</p>', N'2014-05-19 22:49:45')SET IDENTITY_INSERT [dbo].[notice] OFF/****** Object:? Table [dbo].[ks]??? Script Date: 04/16/2015 15:52:20 ******/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 OFFGOSET IDENTITY_INSERT [dbo].[ks] ONINSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (2, N'普外門診', N'外科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (3, N'婦科門診', N'婦產(chǎn)科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (4, N'兒科門診', N'兒科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (5, N'眼科門診', N'眼科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (7, N'耳鼻喉科門診', N'耳鼻喉科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (8, N'中醫(yī)科門診', N'中醫(yī)科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (9, N'呼吸門診-肺癌?？崎T診', N'內(nèi)科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (12, N'神經(jīng)內(nèi)科', N'內(nèi)科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (6, N'口腔科門診', N'口腔科', N'簡介內(nèi)容，自己去編輯', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (11, N'皮膚科', N'外科', N'簡介內(nèi)容，自己去編輯', N'0')SET IDENTITY_INSERT [dbo].[ks] OFF/****** Object:? Table [dbo].[br]??? Script Date: 04/16/2015 15:52:20 ******/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 OFFGOSET IDENTITY_INSERT [dbo].[br] ONINSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (1, N'vip1', N'123', N'小花', N'40', N'女', N'13555555555', N'no', N'0', N'2451234234456345')INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (2, N'vip2', N'123', N'小陳', N'30', N'男', N'13345665433', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (3, N'vip3', N'123', N'小王', N'45', N'男', N'13112344321', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (5, N'vip5', N'123', N'小小', N'33', N'男', N'13765433456', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (6, N'vip6', N'123', N'筆筆', N'38', N'男', N'13555556666', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (8, N'calvin', N'123', N'calvin', N'23', N'男', N'13900001166', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (7, N'vip4', N'123', N'筆筆', N'44', N'男', N'13555555555', N'no', N'0', NULL)SET IDENTITY_INSERT [dbo].[br] OFF