SqlServer的.sql文件导入mysql应该如何修改

Question

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%)
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  DISABLE_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: 04/16/2015 15:52:20 ******/
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
SET IDENTITY_INSERT [dbo].[yyjj] ON
INSERT [dbo].[yyjj] ([id], [remark]) VALUES (1, N'<p>我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院</p>')
SET IDENTITY_INSERT [dbo].[yyjj] OFF
/****** Object:  Table [dbo].[yy]    Script Date: 04/16/2015 15:52:20 ******/
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,
    [lsno] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[yy] ON
INSERT [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 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
SET IDENTITY_INSERT [dbo].[yspb] ON
INSERT [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 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
SET IDENTITY_INSERT [dbo].[sysuser] ON
INSERT [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'王医生', N'女', N'13333333333', N'3', N'高级', N'医生', 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'陈医生', N'女', N'13512344321', N'3', N'中级', N'医生', 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'陈医生', N'男', N'13000000000', N'2', N'初级', N'医生', 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'张医生', N'男', N'15512344321', N'4', N'中级', N'医生', N'201405192337440003.jpg', N'0', N'123123123123123123', N'45保护膜')
SET IDENTITY_INSERT [dbo].[sysuser] OFF
/****** Object:  Table [dbo].[notice]    Script Date: 04/16/2015 15:52:20 ******/
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
SET IDENTITY_INSERT [dbo].[notice] ON
INSERT [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 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
SET IDENTITY_INSERT [dbo].[ks] ON
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (2, N'普外门诊', N'外科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (3, N'妇科门诊', N'妇产科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (4, N'儿科门诊', N'儿科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (5, N'眼科门诊', N'眼科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (7, N'耳鼻喉科门诊', N'耳鼻喉科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (8, N'中医科门诊', N'中医科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (9, N'呼吸门诊-肺癌专科门诊', N'内科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (12, N'神经内科', N'内科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (6, N'口腔科门诊', N'口腔科', N'简介内容，自己去编辑', N'0')
INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (11, N'皮肤科', N'外科', N'简介内容，自己去编辑', N'0')
SET IDENTITY_INSERT [dbo].[ks] OFF
/****** Object:  Table [dbo].[br]    Script Date: 04/16/2015 15:52:20 ******/
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
SET IDENTITY_INSERT [dbo].[br] ON
INSERT [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