首先确保你的数据库中同时存在表MEMB_INFO 和Character 如果以上这2个表在不同数据库中,你可以考虑合并数据库后,修改你原来正常使用的数据源,并指向合并后的库。
首先,我们改变 1 memb__pwd varchar 10 0
此主题相关图片如下:
然后,由于新数据库没有了收费表的问题。我们要执行以下sql角本来建立那几个收费表。
注意:打开SQL查询分析器后,在里面我们要选择数据库 muonline 执行以下角本。
-----------------------------------------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_CURR_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_CURR_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_FQNW_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_FQNW_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_LEAV_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_LEAV_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_MIDS_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_MIDS_INFO]
GO
CREATE TABLE [dbo].[VI_CURR_INFO] (
[ends_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[used_time] [int] NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Bill_Section] [int] NULL ,
[Bill_Value] [int] NULL ,
[Bill_Hour] [int] NULL ,
[Surplus_Point] [int] NULL ,
[Surplus_Minute] [datetime] NULL ,
[Increase_Days] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_FQNW_INFO] (
[appl_code] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctrl_text] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fpas_ques] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fpas_answ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[fanw_guid] [int] NOT NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_LEAV_INFO] (
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cont_text] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctrl_text] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[appl_code] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[leav_guid] [int] NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[memb_mail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[dist_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[prss_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[tel__numb] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_MIDS_INFO] (
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[prev_info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[modi_info] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cont_text] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mids_guid] [int] NOT NULL ,
[admin_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
------------------------------------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Bill_Section]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Bill_Section]
GO
CREATE TABLE [dbo].[T_Bill_Section] (
[Bill_Start_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_End_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
-------------------------------------------
最后是换为原来的JS-JoinServer 或者用去掉加密的新版JoinServer都可以!