Missing Sql Tables form 6.4.2 files

Results 1 to 2 of 2
  1. #1
    Hardcore Member CDWriter is offline
    MemberRank
    Aug 2004 Join Date
    iowa/usaLocation
    142Posts

    Missing Sql Tables form 6.4.2 files

    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

    Code:
    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

    Code:
    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

    Code:
    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

    Code:
    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

    Code:
    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 ....


    Code:
    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 .......


    Code:
    ALTER TABLE WebShopBag
    ADD Account_ID varchar(63) NOT NULL
    
    go
    would be the last one....


    <---------- Click the Thumbs up if you like thanks ....
    Last edited by CDWriter; 05-06-20 at 09:07 PM. Reason: Upgraded Tables More add.. FIXES DONE


  2. #2
    Hardcore Member CDWriter is offline
    MemberRank
    Aug 2004 Join Date
    iowa/usaLocation
    142Posts

    Re: Missing Sql Tables form 6.4.2 files

    Upgraded Tables More add.. FIXES DONE



Advertisement