Missing Sql Tables form 6.4.2 files

[CDWriter]

Ill do this in order on how to fix it 100% after installing the 6.0.7 server files and following the Sql install from the Guid here ... after tables are installed and you have it all setup created these tables ....

Add these to ROM_ImportDB

WeekInstances

CREATE TABLE [dbo].[WeekInstances](
	[WorldID] [int] NOT NULL,
	[ZoneID] [int] NOT NULL,
	[ZoneGroupID] [int] NOT NULL,
	[Clock] [int] NOT NULL,
	[SysTime] [bigint] NOT NULL,
	[SysTime_Base] [bigint] NOT NULL,
	[PKType] [int] NOT NULL,
	[NowStr] [int] NOT NULL,
	[Now] [bigint] NOT NULL,
	[Now_Float] [float] NOT NULL,
	[Day] [int] NOT NULL,
	[IsPvE] [int] NOT NULL,
	[TimeZone] [int] NULL,
	[MaxVocCount] [int] NOT NULL
) ON [PRIMARY]

GO

Table_ItemCombine <--- Thanks to LifeFire

CREATE TABLE [dbo].[Table_ItemCombine](
	[GUID] [int] IDENTITY(1,1) NOT NULL,
	[GroupID] [int] NOT NULL,
	[ProductID] [int] NOT NULL,
	[ProductCount] [int] NOT NULL,
	[SourceID1] [int] NOT NULL,
	[SourceID2] [int] NOT NULL,
	[SourceID3] [int] NOT NULL,
	[SourceID4] [int] NOT NULL,
	[SourceID5] [int] NOT NULL,
	[SourceCount1] [int] NOT NULL,
	[SourceCount2] [int] NOT NULL,
	[SourceCount3] [int] NOT NULL,
	[SourceCount4] [int] NOT NULL,
	[SourceCount5] [int] NOT NULL,
 CONSTRAINT [PK_Table_ItemCombine] PRIMARY KEY CLUSTERED 
(
	[GUID] 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

BuffSchedule

CREATE TABLE [dbo].[BuffSchedule](
	[WorldID] [int] NOT NULL,
	[ZoneID] [int] NOT NULL,
	[BuffID] [int] NOT NULL,
	[BuffLv] [int] NOT NULL,
	[StartTime] [real] NOT NULL,
	[EndTime] [real] NOT NULL
) ON [PRIMARY]

GO

Next you have to fix your RoleData table in ROM_World, So add these 5 columns like this

ALTER TABLE RoleData
ADD mirrorcoin [int] NOT NULL CONSTRAINT [DF_RoleData_mirrorcoin]  DEFAULT ((0)),
    phantom  [int] NOT NULL CONSTRAINT [DF_RoleData_phantom]  DEFAULT ((0)),
    weekinstance   binary(20) NULL,
    weekinstday  [int] NOT NULL CONSTRAINT [DF_RoleData_weekinstday]  DEFAULT ((0)),
    weekresetcount  [int] NOT NULL CONSTRAINT [DF_RoleData_weekresetcount]  DEFAULT ((0))
GO

UPDATE [ROM_World].[dbo].[RoleData]
set weekinstance = CONVERT(BINARY,'')

GO

Next you have to Fix the Missing tables in ROM_Account by adding theses

CREATE TABLE [dbo].[AccountTable](
    [Account] varchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
    [Password] varchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
    [ManageLv] int DEFAULT ((0)) NOT NULL,
    [LoggedIn] int DEFAULT ((0)) NOT NULL,
    [DateDiff]  int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ActionLog](
    [Account] [varchar](32) NOT NULL,
    [Action] [varchar](64) NOT NULL,
    [Time] [smalldatetime] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[LoginHistory](
    [Account] [varchar](32) NOT NULL,
    [Type] [varchar](32) NOT NULL,
    [Time] [smalldatetime] NOT NULL
) ON [PRIMARY]

ALTER TABLE [dbo].[ActionLog] ALTER COLUMN [Account] VARCHAR(250)
ALTER TABLE [dbo].[ActionLog] ALTER COLUMN [Action] VARCHAR(250)
GO

Make sure you add in your AccountTable with the correct login and password based on the Account you made prier to this ... This will be your Login for RA_Server Monitor

That should fix the DB issues when you login .... Now lets fix the missing tables that throw errors Later as you login to the game .... add these Next with ....

USE [ROM_ImportDB]
GO

/***** LoginBonus sql ********/
DROP TABLE [dbo].[LoginBonusDescription];
DROP TABLE [dbo].[LoginBonusConstraint];
DROP TABLE [dbo].[LoginBonusBase];
DROP TABLE [dbo].[LoginBonusStamp];
DROP TABLE [dbo].[LoginBonusReceipt];
DROP TABLE [dbo].[LoginBonusItem];
DROP TABLE [dbo].[LoginBonusBoost];
/**** Healthtime sql *****/
DROP TABLE [dbo].[HealthTime];
/**** Bank Sql ******/
DROP TABLE [dbo].[ImportMoney];
DROP TABLE [dbo].[Bank];
DROP TABLE [dbo].[BankLog];
/****** Object:  Table [dbo].[LoginBonusxxxxx]    Script Date: 1/29/2020 11:53:58 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LoginBonusDescription](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[Description] nvarchar(512) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
	[Date] smalldatetime DEFAULT ((0)) NOT NULL,
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[LoginBonusConstraint](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[BaseGUID] int DEFAULT ((0)) NOT NULL,
	[Type] int DEFAULT ((0)) NOT NULL,
	[Value1] int DEFAULT ((0)) NOT NULL,
	[Value2] int DEFAULT ((0)) NOT NULL,
	[Value3] int DEFAULT ((0)) NOT NULL,
	[Value4] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[LoginBonusBase](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[ToWho] int DEFAULT ((0)) NOT NULL,
	[StartDate] smalldatetime DEFAULT ((0)) NOT NULL,
	[EndDate] smalldatetime DEFAULT ((0)) NOT NULL,
	[Money] int DEFAULT ((0)) NOT NULL,
	[Status] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[LoginBonusStamp](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[Account] int DEFAULT ((0)) NOT NULL,
	[WorldID] int DEFAULT ((0)) NOT NULL,
	[PlayerDBID] int DEFAULT ((0)) NOT NULL,
	[Date] smalldatetime DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[LoginBonusReceipt](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[BaseGUID] int DEFAULT ((0)) NOT NULL,
	[PlayerDBID] int DEFAULT ((0)) NOT NULL,
	[Account] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LoginBonusItem](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[BaseGUID] int DEFAULT ((0)) NOT NULL,
	[OrgObjID] int DEFAULT ((0)) NOT NULL,
	[Count] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LoginBonusBoost](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[BaseGUID] int DEFAULT ((0)) NOT NULL,
	[MagicID] int DEFAULT ((0)) NOT NULL,
	[MagicLv] int DEFAULT ((0)) NOT NULL,
	[EffectTime]  int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO
/*****************************************/

CREATE TABLE [dbo].[ImportMoney](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[Money1] int DEFAULT ((0)) NOT NULL,
	[ProcessTime] int DEFAULT ((0)) NOT NULL,
	[ToAccount] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[Bank](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[Money1] int DEFAULT ((0)) NOT NULL,
	[Account] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO


CREATE TABLE [dbo].[BankLog](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[Source] int DEFAULT ((0)) NOT NULL,
	[Account] int DEFAULT ((0)) NOT NULL,
	[Amount] int DEFAULT ((0)) NOT NULL,
	[Money1_Old] int DEFAULT ((0)) NOT NULL,
	[Money1_New] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]

GO

/*******************************/

CREATE TABLE [dbo].[HealthTime](
	[GUID] bigint  IDENTITY(1,1) NOT NULL,
	[ID] int DEFAULT ((0)) NOT NULL,
	[LastRecordTime] datetime DEFAULT (getdate()) NOT NULL,
	[HealthTime] datetime DEFAULT (getdate()) NOT NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[WebShopBag]
ADD Account_ID varchar(63) NOT NULL

go

Your all done So far for me there has been NO sql errors reported to LOGs if i see any more ill post another Topic .... Thanks all hope this helps .......

ALTER TABLE WebShopBag
ADD Account_ID varchar(63) NOT NULL

go

would be the last one....


<---------- Click the Thumbs up if you like thanks ....

[MentaL]

[CDWriter]

Upgraded Tables More add.. FIXES DONE