1 每次都自动执行到master数据库，能默认执行到我创建的数据库吗，
每次都要切换创建的数据库吗，不智能。执行到master数据库可以撤销吗，恢复master
2 老是语法错误啊 sql没问题的 是不是 master数据库弄坏了
USE [fhadmin]
GO
/****** Object: Database [fhadmin] Script Date: 2016/2/4 11:00:37 ******/
CREATE DATABASE [fhadmin]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'fhadmin', FILENAME = N'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\fhadmin.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'fhadmin_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\fhadmin_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [fhadmin] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [fhadmin].[dbo].[sp_fulltext_database] @action = 'enable'
en'
GO
ALTER DATABASE [fhadmin] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [fhadmin] SET ANSI_NULLS OFF
GO
ALTER DATABASE [fhadmin] SET ANSI_PADDING OFF
GO
ALTER DATABASE [fhadmin] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [fhadmin] SET ARITHABORT OFF
GO
ALTER DATABASE [fhadmin] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [fhadmin] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [fhadmin] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [fhadmin] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [fhadmin] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [fhadmin] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [fhadmin] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [fhadmin] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [fhadmin] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [fhadmin] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [fhadmin] SET DISABLE_BROKER
GO
ALTER DATABASE [fhadmin] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [fhadmin] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [fhadmin] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [fhadmin] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [fhadmin] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [fhadmin] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [fhadmin] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [fhadmin] SET RECOVERY FULL
GO
ALTER DATABASE [fhadmin] SET MULTI_USER
GO
ALTER DATABASE [fhadmin] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [fhadmin] SET DB_CHAINING OFF
GO
ALTER DATABASE [fhadmin] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [fhadmin] SET TARGET_RECOVERY_TIME = 0 SECONDS
GO
EXEC sys.sp_db_vardecimal_storage_format N'fhadmin', N'ON'
GO
USE [fhadmin]
GO
/****** Object: Table [dbo].[FH_TESTFH] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FH_TESTFH](
[TESTFH_ID] [nvarchar](100) NOT NULL,
[NAME] [nvarchar](255) NULL,
[AGE] [int] NOT NULL,
[BIRTHDAY] [nvarchar](32) NULL,
PRIMARY KEY CLUSTERED
(
[TESTFH_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].[sys_app_user] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_app_user](
[USER_ID] [nvarchar](100) NOT NULL,
[USERNAME] [nvarchar](255) NULL,
[PASSWORD] [nvarchar](255) NULL,
[NAME] [nvarchar](255) NULL,
[RIGHTS] [nvarchar](255) NULL,
[ROLE_ID] [nvarchar](100) NULL,
[LAST_LOGIN] [nvarchar](255) NULL,
[IP] [nvarchar](100) NULL,
[STATUS] [nvarchar](32) NULL,
[BZ] [nvarchar](255) NULL,
[PHONE] [nvarchar](100) NULL,
[SFID] [nvarchar](100) NULL,
[START_TIME] [nvarchar](100) NULL,
[END_TIME] [nvarchar](100) NULL,
[YEARS] [int] NULL,
[NUMBER] [nvarchar](100) NULL,
[EMAIL] [nvarchar](32) NULL,
PRIMARY KEY CLUSTERED
(
[USER_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].[sys_createcode] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_createcode](
[CREATECODE_ID] [nvarchar](100) NOT NULL,
[PACKAGENAME] [nvarchar](50) NULL,
[OBJECTNAME] [nvarchar](50) NULL,
[TABLENAME] [nvarchar](50) NULL,
[FIELDLIST] [nvarchar](4000) NULL,
[CREATETIME] [nvarchar](100) NULL,
[TITLE] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[CREATECODE_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].[sys_department] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_department](
[DEPARTMENT_ID] [nvarchar](100) NOT NULL,
[NAME] [nvarchar](30) NULL,
[NAME_EN] [nvarchar](50) NULL,
[BIANMA] [nvarchar](50) NULL,
[PARENT_ID] [nvarchar](100) NULL,
[BZ] [nvarchar](255) NULL,
[HEADMAN] [nvarchar](30) NULL,
[TEL] [nvarchar](50) NULL,
[FUNCTIONS] [nvarchar](255) NULL,
[ADDRESS] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[DEPARTMENT_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].[sys_dictionaries] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_dictionaries](
[DICTIONARIES_ID] [nvarchar](100) NOT NULL,
[NAME] [nvarchar](30) NULL,
[NAME_EN] [nvarchar](50) NULL,
[BIANMA] [nvarchar](50) NULL,
[ORDER_BY] [int] NOT NULL,
[PARENT_ID] [nvarchar](100) NULL,
[BZ] [nvarchar](255) NULL,
[TBSNAME] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED
(
[DICTIONARIES_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].[sys_fhbutton] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_fhbutton](
[FHBUTTON_ID] [nvarchar](100) NOT NULL,
[NAME] [nvarchar](30) NULL,
[QX_NAME] [nvarchar](50) NULL,
[BZ] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[FHBUTTON_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].[sys_fhsms] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_fhsms](
[FHSMS_ID] [nvarchar](100) NOT NULL,
[CONTENT] [nvarchar](1000) NULL,
[TYPE] [nvarchar](5) NULL,
[TO_USERNAME] [nvarchar](255) NULL,
[FROM_USERNAME] [nvarchar](255) NULL,
[SEND_TIME] [nvarchar](100) NULL,
[STATUS] [nvarchar](5) NULL,
[SANME_ID] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED
(
[FHSMS_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].[sys_menu] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_menu](
[MENU_ID] [int] NOT NULL,
[MENU_NAME] [nvarchar](255) NULL,
[MENU_URL] [nvarchar](255) NULL,
[PARENT_ID] [nvarchar](100) NULL,
[MENU_ORDER] [nvarchar](100) NULL,
[MENU_ICON] [nvarchar](60) NULL,
[MENU_TYPE] [nvarchar](10) NULL,
[MENU_STATE] [int] NULL,
PRIMARY KEY CLUSTERED
(
[MENU_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].[sys_role] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_role](
[ROLE_ID] [nvarchar](100) NOT NULL,
[ROLE_NAME] [nvarchar](100) NULL,
[RIGHTS] [nvarchar](255) NULL,
[PARENT_ID] [nvarchar](100) NULL,
[ADD_QX] [nvarchar](255) NULL,
[DEL_QX] [nvarchar](255) NULL,
[EDIT_QX] [nvarchar](255) NULL,
[CHA_QX] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[ROLE_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].[sys_role_fhbutton] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_role_fhbutton](
[RB_ID] [nvarchar](100) NOT NULL,
[ROLE_ID] [nvarchar](100) NULL,
[BUTTON_ID] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED
(
[RB_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].[sys_user] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_user](
[USER_ID] [char](32) NOT NULL,
[USERNAME] [nvarchar](100) NULL,
[PASSWORD] [nvarchar](100) NULL,
[NAME] [nvarchar](100) NULL,
[RIGHTS] [nvarchar](255) NULL,
[ROLE_ID] [nvarchar](100) NULL,
[LAST_LOGIN] [nvarchar](100) NULL,
[IP] [nvarchar](15) NULL,
[STATUS] [nvarchar](32) NULL,
[BZ] [nvarchar](255) NULL,
[SKIN] [nvarchar](100) NULL,
[EMAIL] [nvarchar](50) NULL,
[NUMBER] [nvarchar](100) NULL,
[PHONE] [nvarchar](100) NULL,
CONSTRAINT [PK_sys_user] PRIMARY KEY CLUSTERED
(
[USER_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].[tb_pictures] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_pictures](
[PICTURES_ID] [nvarchar](100) NOT NULL,
[TITLE] [nvarchar](255) NULL,
[NAME] [nvarchar](255) NULL,
[PATH] [nvarchar](255) NULL,
[CREATETIME] [nvarchar](100) NULL,
[MASTER_ID] [nvarchar](255) NULL,
[BZ] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[PICTURES_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].[weixin_command] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[weixin_command](
[COMMAND_ID] [nvarchar](100) NOT NULL,
[KEYWORD] [nvarchar](255) NULL,
[COMMANDCODE] [nvarchar](255) NULL,
[CREATETIME] [nvarchar](255) NULL,
[STATUS] [int] NOT NULL,
[BZ] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[COMMAND_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].[weixin_imgmsg] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[weixin_imgmsg](
[IMGMSG_ID] [nvarchar](100) NOT NULL,
[KEYWORD] [nvarchar](255) NULL,
[CREATETIME] [nvarchar](100) NULL,
[STATUS] [int] NOT NULL,
[BZ] [nvarchar](255) NULL,
[TITLE1] [nvarchar](255) NULL,
[DESCRIPTION1] [nvarchar](255) NULL,
[IMGURL1] [nvarchar](255) NULL,
[TOURL1] [nvarchar](255) NULL,
[TITLE2] [nvarchar](255) NULL,
[DESCRIPTION2] [nvarchar](255) NULL,
[IMGURL2] [nvarchar](255) NULL,
[TOURL2] [nvarchar](255) NULL,
[TITLE3] [nvarchar](255) NULL,
[DESCRIPTION3] [nvarchar](255) NULL,
[IMGURL3] [nvarchar](255) NULL,
[TOURL3] [nvarchar](255) NULL,
[TITLE4] [nvarchar](255) NULL,
[DESCRIPTION4] [nvarchar](255) NULL,
[IMGURL4] [nvarchar](255) NULL,
[TOURL4] [nvarchar](255) NULL,
[TITLE5] [nvarchar](255) NULL,
[DESCRIPTION5] [nvarchar](255) NULL,
[IMGURL5] [nvarchar](255) NULL,
[TOURL5] [nvarchar](255) NULL,
[TITLE6] [nvarchar](255) NULL,
[DESCRIPTION6] [nvarchar](255) NULL,
[IMGURL6] [nvarchar](255) NULL,
[TOURL6] [nvarchar](255) NULL,
[TITLE7] [nvarchar](255) NULL,
[DESCRIPTION7] [nvarchar](255) NULL,
[IMGURL7] [nvarchar](255) NULL,
[TOURL7] [nvarchar](255) NULL,
[TITLE8] [nvarchar](255) NULL,
[DESCRIPTION8] [nvarchar](255) NULL,
[IMGURL8] [nvarchar](255) NULL,
[TOURL8] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[IMGMSG_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].[weixin_textmsg] Script Date: 2016/2/4 11:00:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[weixin_textmsg](
[TEXTMSG_ID] [nvarchar](100) NOT NULL,
[KEYWORD] [nvarchar](255) NULL,
[CONTENT] [nvarchar](255) NULL,
[CREATETIME] [nvarchar](100) NULL,
[STATUS] [int] NULL,
[BZ] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[TEXTMSG_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
INSERT [dbo].[sys_app_user] ([USER_ID], [USERNAME], [PASSWORD], [NAME], [RIGHTS], [ROLE_ID], [LAST_LOGIN], [IP], [STATUS], [BZ], [PHONE], [SFID], [START_TIME], [END_TIME], [YEARS], [NUMBER], [EMAIL]) VALUES (N'1e89e6504be349a68c025976b3ecc1d1', N'a1', N'698d51a19d8a121ce581499d7b701668', N'会员甲', N'', N'115b386ff04f4352b060dffcd2b5d1da', N'', N'', N'1', N'121', N'1212', N'1212', N'2015-12-02', N'2015-12-25', 2, N'111', N'313596790@qq.com')
INSERT [dbo].[sys_app_user] ([USER_ID], [USERNAME], [PASSWORD], [NAME], [RIGHTS], [ROLE_ID], [LAST_LOGIN], [IP], [STATUS], [BZ], [PHONE], [SFID], [START_TIME], [END_TIME], [YEARS], [NUMBER], [EMAIL]) VALUES (N'ead1f56708e4409c8d071e0a699e5633', N'a2', N'bcbe3365e6ac95ea2c0343a2395834dd', N'会员乙', N'', N'1b67fc82ce89457a8347ae53e43a347e', N'', N'', N'0', N'', N'', N'', N'2015-12-01', N'2015-12-24', 1, N'121', N'978336446@qq.com')
INSERT [dbo].[sys_createcode] ([CREATECODE_ID], [PACKAGENAME], [OBJECTNAME], [TABLENAME], [FIELDLIST], [CREATETIME], [TITLE]) VALUES (N'002ea762e3e242a7a10ea5ca633701d8', N'system', N'Buttonrights', N'sys_,fh,BUTTONRIGHTS', N'NAME,fh,String,fh,名称,fh,是,fh,无,fh,255Q313596790', N'2016-01-16 23:20:36', N'按钮权限')
INSERT [dbo].[sys_createcode] ([CREATECODE_ID], [PACKAGENAME], [OBJECTNAME], [TABLENAME], [FIELDLIST], [CREATETIME], [TITLE]) VALUES (N'11c0f9b57ec94cefa21d58ed5c6161ae', N'system', N'Testfh', N'FH_,fh,TESTFH', N'NAME,fh,String,fh,姓名,fh,是,fh,无,fh,255Q313596790AGE,fh,Integer,fh,年龄,fh,是,fh,无,fh,11Q313596790BIRTHDAY,fh,Date,fh,生日,fh,是,fh,无,fh,32Q313596790', N'2016-02-01 15:45:18', N'测试')
INSERT [dbo].[sys_createcode] ([CREATECODE_ID], [PACKAGENAME], [OBJECTNAME], [TABLENAME], [FIELDLIST], [CREATETIME], [TITLE]) VALUES (N'c7586f931fd44c61beccd3248774c68c', N'system', N'Department', N'SYS_,fh,DEPARTMENT', N'NAME,fh,String,fh,名称,fh,是,fh,无,fh,30Q313596790NAME_EN,fh,String,fh,英文,fh,是,fh,无,fh,50Q313596790BIANMA,fh,String,fh,编码,fh,是,fh,无,fh,50Q313596790PARENT_ID,fh,String,fh,上级ID,fh,否,fh,无,fh,100Q313596790BZ,fh,String,fh,备注,fh,是,fh,无,fh,255Q313596790HEADMAN,fh,String,fh,负责人,fh,是,fh,无,fh,30Q313596790TEL,fh,String,fh,电话,fh,是,fh,无,fh,50Q313596790FUNCTIONS,fh,String,fh,部门职能,fh,是,fh,无,fh,255Q313596790ADDRESS,fh,String,fh,地址,fh,是,fh,无,fh,255Q313596790', N'2015-12-20 01:49:25', N'组织机构')
INSERT [dbo].[sys_createcode] ([CREATECODE_ID], [PACKAGENAME], [OBJECTNAME], [TABLENAME], [FIELDLIST], [CREATETIME], [TITLE]) VALUES (N'dbd7b8330d774dcabd184eca8668a295', N'system', N'Fhsms', N'SYS_,fh,FHSMS', N'CONTENT,fh,String,fh,内容,fh,是,fh,无,fh,1000Q313596790TYPE,fh,String,fh,类型,fh,否,fh,无,fh,5Q313596790TO_USERNAME,fh,String,fh,收信人,fh,是,fh,无,fh,255Q313596790FROM_USERNAME,fh,String,fh,发信人,fh,是,fh,无,fh,255Q313596790SEND_TIME,fh,String,fh,发信时间,fh,是,fh,无,fh,100Q313596790STATUS,fh,String,fh,状态,fh,否,fh,无,fh,5Q313596790SANME_ID,fh,String,fh,共同ID,fh,是,fh,无,fh,100Q313596790', N'2016-01-23 01:44:15', N'站内信')
INSERT [dbo].[sys_createcode] ([CREATECODE_ID], [PACKAGENAME], [OBJECTNAME], [TABLENAME], [FIELDLIST], [CREATETIME], [TITLE]) VALUES (N'fe239f8742194481a5b56f90cad71520', N'system', N'Fhbutton', N'SYS_,fh,FHBUTTON', N'NAME,fh,String,fh,名称,fh,是,fh,无,fh,30Q313596790QX_NAME,fh,String,fh,权限标识,fh,是,fh,无,fh,50Q313596790BZ,fh,String,fh,备注,fh,是,fh,无,fh,255Q313596790', N'2016-01-15 18:38:40', N'按钮管理')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'0956d8c279274fca92f4091f2a69a9ad', N'销售会计', N'xiaokuai', N'05896', N'd41af567914a409893d011aa53eda797', N'', N'', N'', N'', N'')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'3e7227e11dc14b4d9e863dd1a1fcedf6', N'成本会计', N'chengb', N'03656', N'd41af567914a409893d011aa53eda797', N'', N'', N'', N'', N'')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'5cccdb7c432449d8b853c52880058140', N'B公司', N'b', N'002', N'0', N'冶铁', N'李四', N'112', N'冶铁', N'河北')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'83a25761c618457cae2fa1211bd8696d', N'销售B组', N'xiaob', N'002365', N'cbbc84eddde947ba8af7d509e430eb70', N'', N'李四', N'', N'', N'')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'8f8b045470f342fdbc4c312ab881d62b', N'销售A组', N'xiaoA', N'0326', N'cbbc84eddde947ba8af7d509e430eb70', N'', N'张三', N'0201212', N'', N'')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'a0982dea52554225ab682cd4b421de47', N'1队', N'yidui', N'02563', N'8f8b045470f342fdbc4c312ab881d62b', N'', N'小王', N'12356989', N'', N'')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'a6c6695217ba4a4dbfe9f7e9d2c06730', N'A公司', N'a', N'001', N'0', N'挖煤', N'张三', N'110', N'洼煤矿', N'山西')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'cbbc84eddde947ba8af7d509e430eb70', N'销售部', N'xiaoshoubu', N'00201', N'5cccdb7c432449d8b853c52880058140', N'推销商品', N'小明', N'11236', N'推销商品', N'909办公室')
INSERT [dbo].[sys_department] ([DEPARTMENT_ID], [NAME], [NAME_EN], [BIANMA], [PARENT_ID], [BZ], [HEADMAN], [TEL], [FUNCTIONS], [ADDRESS]) VALUES (N'd41af567914a409893d011aa53eda797', N'财务部', N'caiwubu', N'00101', N'a6c6695217ba4a4dbfe9f7e9d2c06730', N'负责发工资', N'王武', N'11236', N'管理财务', N'308办公室')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'096e4ec8986149d994b09e604504e38d', N'黄浦区', N'huangpu', N'0030201', 1, N'f1ea30ddef1340609c35c88fb2919bee', N'黄埔', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'12a62a3e5bed44bba0412b7e6b733c93', N'北京', N'beijing', N'00301', 1, N'be4a8c5182c744d28282a5345783a77f', N'北京', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'507fa87a49104c7c8cdb52fdb297da12', N'宣武区', N'xuanwuqu', N'0030101', 1, N'12a62a3e5bed44bba0412b7e6b733c93', N'宣武区', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'8994f5995f474e2dba6cfbcdfe5ea07a', N'语文', N'yuwen', N'00201', 1, N'fce20eb06d7b4b4d8f200eda623f725c', N'语文', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'8ea7c44af25f48b993a14f791c8d689f', N'分类', N'fenlei', N'001', 1, N'0', N'分类', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'be4a8c5182c744d28282a5345783a77f', N'地区', N'diqu', N'003', 3, N'0', N'地区', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'd428594b0494476aa7338d9061e23ae3', N'红色', N'red', N'00101', 1, N'8ea7c44af25f48b993a14f791c8d689f', N'红色', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'de9afadfbed0428fa343704d6acce2c4', N'绿色', N'green', N'00102', 2, N'8ea7c44af25f48b993a14f791c8d689f', N'绿色', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'f1ea30ddef1340609c35c88fb2919bee', N'上海', N'shanghai', N'00302', 2, N'be4a8c5182c744d28282a5345783a77f', N'上海', N'')
INSERT [dbo].[sys_dictionaries] ([DICTIONARIES_ID], [NAME], [NAME_EN], [BIANMA], [ORDER_BY], [PARENT_ID], [BZ], [TBSNAME]) VALUES (N'fce20eb06d7b4b4d8f200eda623f725c', N'课程', N'kecheng', N'002', 2, N'0', N'课程', N'')
INSERT [dbo].[sys_fhbutton] ([FHBUTTON_ID], [NAME], [QX_NAME], [BZ]) VALUES (N'3542adfbda73410c976e185ffe50ad06', N'导出EXCEL', N'toExcel', N'导出EXCEL')
INSERT [dbo].[sys_fhbutton] ([FHBUTTON_ID], [NAME], [QX_NAME], [BZ]) VALUES (N'46992ea280ba4b72b29dedb0d4bc0106', N'发邮件', N'email', N'发送电子邮件')
INSERT [dbo].[sys_fhbutton] ([FHBUTTON_ID], [NAME], [QX_NAME], [BZ]) VALUES (N'4efa162fce8340f0bd2dcd3b11d327ec', N'导入EXCEL', N'FromExcel', N'导入EXCEL到系统用户')
INSERT [dbo].[sys_fhbutton] ([FHBUTTON_ID], [NAME], [QX_NAME], [BZ]) VALUES (N'cc51b694d5344d28a9aa13c84b7166cd', N'发短信', N'sms', N'发送短信')
INSERT [dbo].[sys_fhbutton] ([FHBUTTON_ID], [NAME], [QX_NAME], [BZ]) VALUES (N'da7fd386de0b49ce809984f5919022b8', N'站内信', N'FHSMS', N'发送站内信')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'05879f5868824f35932ee9f2062adc03', N'你好', N'2', N'admin', N'san', N'2016-01-25 14:05:31', N'1', N'b311e893228f42d5a05dbe16917fd16f')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'2635dd035c6f4bb5a091abdd784bd899', N'你好', N'2', N'san', N'admin', N'2016-01-25 14:05:02', N'2', N'1b7637306683460f89174c2b025862b5')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'52378ccd4e2d4fe08994d1652af87c68', N'你好', N'1', N'admin', N'san', N'2016-01-25 16:26:44', N'1', N'920b20dafdfb4c09b560884eb277c51d')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'77ed13f9c49a4c4bb460c41b8580dd36', N'gggg', N'2', N'admin', N'san', N'2016-01-24 21:22:43', N'2', N'dd9ee339576e48c5b046b94fa1901d00')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'98a6869f942042a1a037d9d9f01cb50f', N'你好', N'1', N'admin', N'san', N'2016-01-25 14:05:02', N'2', N'1b7637306683460f89174c2b025862b5')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'9e00295529014b6e8a27019cbccb3da1', N'柔柔弱弱', N'1', N'admin', N'san', N'2016-01-24 21:22:57', N'1', N'a29603d613ea4e54b5678033c1bf70a6')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'd3aedeb430f640359bff86cd657a8f59', N'你好', N'1', N'admin', N'san', N'2016-01-24 21:22:12', N'1', N'f022fbdce3d845aba927edb698beb90b')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'e5376b1bd54b489cb7f2203632bd74ec', N'管理员好', N'2', N'admin', N'san', N'2016-01-25 14:06:13', N'2', N'b347b2034faf43c79b54be4627f3bd2b')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'e613ac0fcc454f32895a70b747bf4fb5', N'你也好', N'2', N'admin', N'san', N'2016-01-25 16:27:54', N'2', N'ce8dc3b15afb40f28090f8b8e13f078d')
INSERT [dbo].[sys_fhsms] ([FHSMS_ID], [CONTENT], [TYPE], [TO_USERNAME], [FROM_USERNAME], [SEND_TIME], [STATUS], [SANME_ID]) VALUES (N'f25e00cfafe741a3a05e3839b66dc7aa', N'你好', N'2', N'san', N'admin', N'2016-01-25 16:26:44', N'1', N'920b20dafdfb4c09b560884eb277c51d')
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (1, N'系统管理', N'#', N'0', N'1', N'menu-icon fa fa-desktop blue', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (2, N'权限管理', N'#', N'1', N'1', N'menu-icon fa fa-lock black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (6, N'信息管理', N'#', N'0', N'5', N'menu-icon fa fa-credit-card green', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (7, N'图片管理', N'pictures/list.do', N'6', N'1', N'menu-icon fa fa-folder-o pink', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (8, N'性能监控', N'druid/index.html', N'9', N'1', N'menu-icon fa fa-tachometer red', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (9, N'系统工具', N'#', N'0', N'3', N'menu-icon fa fa-cog black', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (10, N'接口测试', N'tool/interfaceTest.do', N'9', N'2', N'menu-icon fa fa-exchange green', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (11, N'发送邮件', N'tool/goSendEmail.do', N'9', N'3', N'menu-icon fa fa-envelope-o green', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (12, N'置二维码', N'tool/goTwoDimensionCode.do', N'9', N'4', N'menu-icon fa fa-barcode green', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (14, N'地图工具', N'tool/map.do', N'9', N'6', N'menu-icon fa fa-globe black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (15, N'微信管理', N'#', N'0', N'4', N'menu-icon fa fa-comments purple', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (16, N'文本回复', N'textmsg/list.do', N'15', N'2', N'menu-icon fa fa-comment green', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (17, N'应用命令', N'command/list.do', N'15', N'4', N'menu-icon fa fa-comment grey', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (18, N'图文回复', N'imgmsg/list.do', N'15', N'3', N'menu-icon fa fa-comment pink', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (19, N'关注回复', N'textmsg/goSubscribe.do', N'15', N'1', N'menu-icon fa fa-comment orange', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (20, N'在线管理', N'onlinemanager/list.do', N'1', N'6', N'menu-icon fa fa-laptop green', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (21, N'打印测试', N'tool/printTest.do', N'9', N'7', N'menu-icon fa fa-hdd-o grey', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (22, N'一级菜单', N'#', N'0', N'6', N'menu-icon fa fa-fire orange', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (23, N'二级菜单', N'#', N'22', N'1', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (24, N'三级菜单', N'#', N'23', N'1', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (30, N'四级菜单', N'#', N'24', N'1', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (31, N'五级菜单1', N'#', N'30', N'1', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (32, N'五级菜单2', N'#', N'30', N'2', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (33, N'六级菜单', N'#', N'31', N'1', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (34, N'六级菜单2', N'login_default.do', N'31', N'2', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (35, N'四级菜单2', N'login_default.do', N'24', N'2', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (36, N'角色(基础权限)', N'role.do', N'2', N'1', N'menu-icon fa fa-key orange', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (37, N'按钮权限', N'buttonrights/list.do', N'2', N'2', N'menu-icon fa fa-key green', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (38, N'菜单管理', N'menu/listAllMenu.do', N'1', N'3', N'menu-icon fa fa-folder-open-o brown', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (39, N'按钮管理', N'fhbutton/list.do', N'1', N'2', N'menu-icon fa fa-download orange', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (40, N'用户管理', N'#', N'0', N'2', N'menu-icon fa fa-users blue', N'2', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (41, N'系统用户', N'user/listUsers.do', N'40', N'1', N'menu-icon fa fa-users green', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (42, N'会员管理', N'happuser/listUsers.do', N'40', N'2', N'menu-icon fa fa-users orange', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (43, N'数据字典', N'dictionaries/listAllDict.do?DICTIONARIES_ID=0', N'1', N'4', N'menu-icon fa fa-book purple', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (44, N'代码生成', N'createCode/list.do', N'9', N'0', N'menu-icon fa fa-cogs brown', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (45, N'七级菜单1', N'#', N'33', N'1', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (46, N'七级菜单2', N'#', N'33', N'2', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (47, N'八级菜单', N'login_default.do', N'45', N'1', N'menu-icon fa fa-leaf black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (48, N'图表报表', N' tool/fusionchartsdemo.do', N'9', N'5', N'menu-icon fa fa-bar-chart-o black', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (49, N'组织机构', N'department/listAllDepartment.do?DEPARTMENT_ID=0', N'1', N'5', N'menu-icon fa fa-users blue', N'1', 1)
INSERT [dbo].[sys_menu] ([MENU_ID], [MENU_NAME], [MENU_URL], [PARENT_ID], [MENU_ORDER], [MENU_ICON], [MENU_TYPE], [MENU_STATE]) VALUES (50, N'站内信', N'fhsms/list.do', N'6', N'2', N'menu-icon fa fa-envelope green', N'1', 1)
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'1', N'系统管理组', N'4503598587174854', N'0', N'1', N'1', N'1', N'1')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'115b386ff04f4352b060dffcd2b5d1da', N'中级会员', N'498', N'2', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'1b67fc82ce89457a8347ae53e43a347e', N'初级会员', N'498', N'2', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'2', N'会员组', N'498', N'0', N'0', N'0', N'0', N'1')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'3264c8e83d0248bb9e3ea6195b4c0216', N'一级管理员', N'4503598587174854', N'1', N'2251798773489606', N'2251798773489606', N'1125898866646982', N'2251798773489606')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'46294b31a71c4600801724a6eb06bb26', N'职位组', N'', N'0', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'5466347ac07044cb8d82990ec7f3a90e', N'主管', N'', N'46294b31a71c4600801724a6eb06bb26', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'68f8e4a39efe47c7bb869e9d15ab925d', N'二级管理员', N'4503598587174854', N'1', N'0', N'0', N'2251798773489606', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'856849f422774ad390a4e564054d8cc8', N'经理', N'', N'46294b31a71c4600801724a6eb06bb26', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'8b70a7e67f2841e7aaba8a4d92e5ff6f', N'高级会员', N'498', N'2', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'c21cecf84048434b93383182b1d98cba', N'组长', N'', N'46294b31a71c4600801724a6eb06bb26', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'd449195cd8e7491080688c58e11452eb', N'总监', N'', N'46294b31a71c4600801724a6eb06bb26', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_role] ([ROLE_ID], [ROLE_NAME], [RIGHTS], [PARENT_ID], [ADD_QX], [DEL_QX], [EDIT_QX], [CHA_QX]) VALUES (N'de9de2f006e145a29d52dfadda295353', N'三级管理员', N'4503598587174854', N'1', N'0', N'0', N'0', N'0')
INSERT [dbo].[sys_user] ([USER_ID], [USERNAME], [PASSWORD], [NAME], [RIGHTS], [ROLE_ID], [LAST_LOGIN], [IP], [STATUS], [BZ], [SKIN], [EMAIL], [NUMBER], [PHONE]) VALUES (N'1 ', N'admin', N'de41b7fb99201d8334c23c014db35ecd92df81bc', N'系统管理员', N'1133671055321055258374707980945218933803269864762743594642571294', N'1', N'2016-02-01 16:36:10', N'127.0.0.1', N'0', N'最高统治者', N'default', N'QQ313596790@main.com', N'001', N'18788888888')
INSERT [dbo].[sys_user] ([USER_ID], [USERNAME], [PASSWORD], [NAME], [RIGHTS], [ROLE_ID], [LAST_LOGIN], [IP], [STATUS], [BZ], [SKIN], [EMAIL], [NUMBER], [PHONE]) VALUES (N'69177258a06e4927b4639ab1684c3320', N'san', N'47c4a8dc64ac2f0bb46bbd8813b037c9718f9349', N'三', N'', N'3264c8e83d0248bb9e3ea6195b4c0216', N'2016-01-25 16:25:36', N'192.168.1.102', N'0', N'111', N'default', N'978336446@qq.com', N'333', N'13562202556')
INSERT [dbo].[sys_user] ([USER_ID], [USERNAME], [PASSWORD], [NAME], [RIGHTS], [ROLE_ID], [LAST_LOGIN], [IP], [STATUS], [BZ], [SKIN], [EMAIL], [NUMBER], [PHONE]) VALUES (N'9991f4d7782a4ccfb8a65bd96ea7aafa', N'lisi', N'2612ade71c1e48cd7150b5f4df152faa699cedfe', N'李四', N'', N'3264c8e83d0248bb9e3ea6195b4c0216', N'2016-01-06 01:24:26', N'127.0.0.1', N'0', N'小李', N'default', N'313596790@qq.com', N'1102', N'13566233663')
INSERT [dbo].[sys_user] ([USER_ID], [USERNAME], [PASSWORD], [NAME], [RIGHTS], [ROLE_ID], [LAST_LOGIN], [IP], [STATUS], [BZ], [SKIN], [EMAIL], [NUMBER], [PHONE]) VALUES (N'e29149962e944589bb7da23ad18ddeed', N'zhangsan', N'c2da1419caf053885c492e10ebde421581cdc03f', N'张三', N'', N'3264c8e83d0248bb9e3ea6195b4c0216', N'', N'', N'0', N'小张', N'default', N'zhangsan@www.com', N'1101', N'2147483647')
INSERT [dbo].[tb_pictures] ([PICTURES_ID], [TITLE], [NAME], [PATH], [CREATETIME], [MASTER_ID], [BZ]) VALUES (N'b06010340ee54cfab49b8bfbe2387557', N'图片', N'5e6ba5ad3067482e9a8063b0627ee983.png', N'20160125/5e6ba5ad3067482e9a8063b0627ee983.png', N'2016-01-25 16:49:44', N'1', N'图片管理处上传')
INSERT [dbo].[tb_pictures] ([PICTURES_ID], [TITLE], [NAME], [PATH], [CREATETIME], [MASTER_ID], [BZ]) VALUES (N'c9f1eca620c94c27bfa7028c66911f41', N'图片', N'928da750ec8542ceb7b2495f45ea6a9e.jpg', N'20160125/928da750ec8542ceb7b2495f45ea6a9e.jpg', N'2016-01-25 16:49:44', N'1', N'图片管理处上传')
INSERT [dbo].[weixin_command] ([COMMAND_ID], [KEYWORD], [COMMANDCODE], [CREATETIME], [STATUS], [BZ]) VALUES (N'2636750f6978451b8330874c9be042c2', N'锁定服务器', N'rundll32.exe user32.dll,LockWorkStation', N'2015-05-10 21:25:06', 1, N'锁定计算机')
INSERT [dbo].[weixin_command] ([COMMAND_ID], [KEYWORD], [COMMANDCODE], [CREATETIME], [STATUS], [BZ]) VALUES (N'46217c6d44354010823241ef484f7214', N'打开浏览器', N'C:/Program Files/Internet Explorer/iexplore.exe', N'2015-05-09 02:43:02', 1, N'打开浏览器操作')
INSERT [dbo].[weixin_command] ([COMMAND_ID], [KEYWORD], [COMMANDCODE], [CREATETIME], [STATUS], [BZ]) VALUES (N'576adcecce504bf3bb34c6b4da79a177', N'关闭浏览器', N'taskkill /f /im iexplore.exe', N'2015-05-09 02:36:48', 2, N'关闭浏览器操作')
INSERT [dbo].[weixin_command] ([COMMAND_ID], [KEYWORD], [COMMANDCODE], [CREATETIME], [STATUS], [BZ]) VALUES (N'854a157c6d99499493f4cc303674c01f', N'关闭QQ', N'taskkill /f /im qq.exe', N'2015-05-10 21:25:46', 1, N'关闭QQ')
INSERT [dbo].[weixin_command] ([COMMAND_ID], [KEYWORD], [COMMANDCODE], [CREATETIME], [STATUS], [BZ]) VALUES (N'ab3a8c6310ca4dc8b803ecc547e55ae7', N'打开QQ', N'D:/SOFT/QQ/QQ/Bin/qq.exe', N'2015-05-10 21:25:25', 1, N'打开QQ')
INSERT [dbo].[weixin_textmsg] ([TEXTMSG_ID], [KEYWORD], [CONTENT], [CREATETIME], [STATUS], [BZ]) VALUES (N'63681adbe7144f10b66d6863e07f23c2', N'你好', N'你也好', N'2015-05-09 02:39:23', 1, N'文本回复')
INSERT [dbo].[weixin_textmsg] ([TEXTMSG_ID], [KEYWORD], [CONTENT], [CREATETIME], [STATUS], [BZ]) VALUES (N'695cd74779734231928a253107ab0eeb', N'吃饭', N'吃了噢噢噢噢', N'2015-05-10 22:52:27', 1, N'文本回复')
INSERT [dbo].[weixin_textmsg] ([TEXTMSG_ID], [KEYWORD], [CONTENT], [CREATETIME], [STATUS], [BZ]) VALUES (N'd4738af7aea74a6ca1a5fb25a98f9acb', N'关注', N'这里是关注后回复的内容', N'2015-05-11 02:12:36', 1, N'关注回复')
ALTER TABLE [dbo].[FH_TESTFH] ADD DEFAULT (NULL) FOR [NAME]
GO
ALTER TABLE [dbo].[FH_TESTFH] ADD DEFAULT (NULL) FOR [BIRTHDAY]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [USERNAME]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [PASSWORD]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [NAME]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [RIGHTS]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [ROLE_ID]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [LAST_LOGIN]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [IP]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [STATUS]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [BZ]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [PHONE]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [SFID]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [START_TIME]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [END_TIME]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [YEARS]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [NUMBER]
GO
ALTER TABLE [dbo].[sys_app_user] ADD DEFAULT (NULL) FOR [EMAIL]
GO
ALTER TABLE [dbo].[sys_createcode] ADD DEFAULT (NULL) FOR [PACKAGENAME]
GO
ALTER TABLE [dbo].[sys_createcode] ADD DEFAULT (NULL) FOR [OBJECTNAME]
GO
ALTER TABLE [dbo].[sys_createcode] ADD DEFAULT (NULL) FOR [TABLENAME]
GO
ALTER TABLE [dbo].[sys_createcode] ADD DEFAULT (NULL) FOR [FIELDLIST]
GO
ALTER TABLE [dbo].[sys_createcode] ADD DEFAULT (NULL) FOR [CREATETIME]
GO
ALTER TABLE [dbo].[sys_createcode] ADD DEFAULT (NULL) FOR [TITLE]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [NAME]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [NAME_EN]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [BIANMA]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [PARENT_ID]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [BZ]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [HEADMAN]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [TEL]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [FUNCTIONS]
GO
ALTER TABLE [dbo].[sys_department] ADD DEFAULT (NULL) FOR [ADDRESS]
GO
ALTER TABLE [dbo].[sys_dictionaries] ADD DEFAULT (NULL) FOR [NAME]
GO
ALTER TABLE [dbo].[sys_dictionaries] ADD DEFAULT (NULL) FOR [NAME_EN]
GO
ALTER TABLE [dbo].[sys_dictionaries] ADD DEFAULT (NULL) FOR [BIANMA]
GO
ALTER TABLE [dbo].[sys_dictionaries] ADD DEFAULT (NULL) FOR [PARENT_ID]
GO
ALTER TABLE [dbo].[sys_dictionaries] ADD DEFAULT (NULL) FOR [BZ]
GO
ALTER TABLE [dbo].[sys_dictionaries] ADD DEFAULT (NULL) FOR [TBSNAME]
GO
ALTER TABLE [dbo].[sys_fhbutton] ADD DEFAULT (NULL) FOR [NAME]
GO
ALTER TABLE [dbo].[sys_fhbutton] ADD DEFAULT (NULL) FOR [QX_NAME]
GO
ALTER TABLE [dbo].[sys_fhbutton] ADD DEFAULT (NULL) FOR [BZ]
GO
ALTER TABLE [dbo].[sys_fhsms] ADD DEFAULT (NULL) FOR [CONTENT]
GO
ALTER TABLE [dbo].[sys_fhsms] ADD DEFAULT (NULL) FOR [TYPE]
GO
ALTER TABLE [dbo].[sys_fhsms] ADD DEFAULT (NULL) FOR [TO_USERNAME]
GO
ALTER TABLE [dbo].[sys_fhsms] ADD DEFAULT (NULL) FOR [FROM_USERNAME]
GO
ALTER TABLE [dbo].[sys_fhsms] ADD DEFAULT (NULL) FOR [SEND_TIME]
GO
ALTER TABLE [dbo].[sys_fhsms] ADD DEFAULT (NULL) FOR [STATUS]
GO
ALTER TABLE [dbo].[sys_fhsms] ADD DEFAULT (NULL) FOR [SANME_ID]
GO
ALTER TABLE [dbo].[sys_menu] ADD DEFAULT (NULL) FOR [MENU_NAME]
GO
ALTER TABLE [dbo].[sys_menu] ADD DEFAULT (NULL) FOR [MENU_URL]
GO
ALTER TABLE [dbo].[sys_menu] ADD DEFAULT (NULL) FOR [PARENT_ID]
GO
ALTER TABLE [dbo].[sys_menu] ADD DEFAULT (NULL) FOR [MENU_ORDER]
GO
ALTER TABLE [dbo].[sys_menu] ADD DEFAULT (NULL) FOR [MENU_ICON]
GO
ALTER TABLE [dbo].[sys_menu] ADD DEFAULT (NULL) FOR [MENU_TYPE]
GO
ALTER TABLE [dbo].[sys_menu] ADD DEFAULT (NULL) FOR [MENU_STATE]
GO
ALTER TABLE [dbo].[sys_role] ADD DEFAULT (NULL) FOR [ROLE_NAME]
GO
ALTER TABLE [dbo].[sys_role] ADD DEFAULT (NULL) FOR [RIGHTS]
GO
ALTER TABLE [dbo].[sys_role] ADD DEFAULT (NULL) FOR [PARENT_ID]
GO
ALTER TABLE [dbo].[sys_role] ADD DEFAULT (NULL) FOR [ADD_QX]
GO
ALTER TABLE [dbo].[sys_role] ADD DEFAULT (NULL) FOR [DEL_QX]
GO
ALTER TABLE [dbo].[sys_role] ADD DEFAULT (NULL) FOR [EDIT_QX]
GO
ALTER TABLE [dbo].[sys_role] ADD DEFAULT (NULL) FOR [CHA_QX]
GO
ALTER TABLE [dbo].[sys_role_fhbutton] ADD DEFAULT (NULL) FOR [ROLE_ID]
GO
ALTER TABLE [dbo].[sys_role_fhbutton] ADD DEFAULT (NULL) FOR [BUTTON_ID]
GO
ALTER TABLE [dbo].[tb_pictures] ADD DEFAULT (NULL) FOR [TITLE]
GO
ALTER TABLE [dbo].[tb_pictures] ADD DEFAULT (NULL) FOR [NAME]
GO
ALTER TABLE [dbo].[tb_pictures] ADD DEFAULT (NULL) FOR [PATH]
GO
ALTER TABLE [dbo].[tb_pictures] ADD DEFAULT (NULL) FOR [CREATETIME]
GO
ALTER TABLE [dbo].[tb_pictures] ADD DEFAULT (NULL) FOR [MASTER_ID]
GO
ALTER TABLE [dbo].[tb_pictures] ADD DEFAULT (NULL) FOR [BZ]
GO
ALTER TABLE [dbo].[weixin_command] ADD DEFAULT (NULL) FOR [KEYWORD]
GO
ALTER TABLE [dbo].[weixin_command] ADD DEFAULT (NULL) FOR [COMMANDCODE]
GO
ALTER TABLE [dbo].[weixin_command] ADD DEFAULT (NULL) FOR [CREATETIME]
GO
ALTER TABLE [dbo].[weixin_command] ADD DEFAULT (NULL) FOR [BZ]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [KEYWORD]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [CREATETIME]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [BZ]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TITLE1]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [DESCRIPTION1]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [IMGURL1]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TOURL1]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TITLE2]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [DESCRIPTION2]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [IMGURL2]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TOURL2]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TITLE3]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [DESCRIPTION3]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [IMGURL3]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TOURL3]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TITLE4]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [DESCRIPTION4]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [IMGURL4]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TOURL4]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TITLE5]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [DESCRIPTION5]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [IMGURL5]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TOURL5]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TITLE6]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [DESCRIPTION6]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [IMGURL6]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TOURL6]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TITLE7]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [DESCRIPTION7]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [IMGURL7]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TOURL7]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TITLE8]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [DESCRIPTION8]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [IMGURL8]
GO
ALTER TABLE [dbo].[weixin_imgmsg] ADD DEFAULT (NULL) FOR [TOURL8]
GO
ALTER TABLE [dbo].[weixin_textmsg] ADD DEFAULT (NULL) FOR [KEYWORD]
GO
ALTER TABLE [dbo].[weixin_textmsg] ADD DEFAULT (NULL) FOR [CONTENT]
GO
ALTER TABLE [dbo].[weixin_textmsg] ADD DEFAULT (NULL) FOR [CREATETIME]
GO
ALTER TABLE [dbo].[weixin_textmsg] ADD DEFAULT (NULL) FOR [STATUS]
GO
ALTER TABLE [dbo].[weixin_textmsg] ADD DEFAULT (NULL) FOR [BZ]
GO
ALTER TABLE [dbo].[sys_role_fhbutton] WITH NOCHECK ADD CONSTRAINT [FK_sys_role_fhbutton_sys_fhbutton] FOREIGN KEY([BUTTON_ID])
REFERENCES [dbo].[sys_fhbutton] ([FHBUTTON_ID])
ON DELETE CASCADE
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[sys_role_fhbutton] CHECK CONSTRAINT [FK_sys_role_fhbutton_sys_fhbutton]
GO
ALTER TABLE [dbo].[sys_role_fhbutton] WITH NOCHECK ADD CONSTRAINT [FK_sys_role_fhbutton_sys_role] FOREIGN KEY([ROLE_ID])
REFERENCES [dbo].[sys_role] ([ROLE_ID])
ON DELETE CASCADE
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[sys_role_fhbutton] CHECK CONSTRAINT [FK_sys_role_fhbutton_sys_role]
GO
USE [master]
GO
ALTER DATABASE [fhadmin] SET READ_WRITE
GO
老是语法错误啊 sql没问题的 是不是 master数据库弄坏了
消息 102，级别 15，状态 1，第 3 行
'CONTAINMENT' 附近有语法错误。
消息 15048，级别 16，状态 1，第 1 行
数据库兼容级别的有效值为 80、90 或 100。
消息 102，级别 15，状态 1，第 4 行
'en' 附近有语法错误。
消息 168，级别 15，状态 1，第 422 行
浮点值 '3e7227' 超出了计算机表示范围(8 个字节)。
消息 168，级别 15，状态 1，第 450 行
浮点值 '9e00295529014' 超出了计算机表示范围(8 个字节)。
消息 1007，级别 15，状态 1，第 509 行
数字 '1133671055321055258374707980945218933803269864762743594642571294' 超出了数值表示范围(最大精度为 38)。
消息 105，级别 15，状态 1，第 522 行
字符串 ')
