those r the changes. look closely at the account n charac0 table. ive
modified both of the table as u can see it up there. account : 3 new
columns n for the charac0 : 2 new columns.
HSDB db
just insert this new table inside ur HSDB table n ull be fine.
HSDB db
Code:
USE [HSDB]
GO
/****** Object: Table [dbo].[MERC] Script Date: 04/29/2012 23:10:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MERC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[MERC](
[HSID] [int] NOT NULL,
[HSName] [varchar](255) NOT NULL,
[MasterName] [varchar](255) NOT NULL,
[Type] [int] NOT NULL,
[HSLevel] [smallint] NOT NULL,
[rb] [int] NOT NULL,
[reset_rb] [int] NOT NULL CONSTRAINT [DF_MERC_reset_rb] DEFAULT ((0))
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
