CREATE TABLE [dbo].[FilterConditions] (
	[cflt] [numeric](18, 0) NOT NULL ,
	[seqn] [int] NOT NULL ,
	[cfld] [varchar] (30) NULL ,
	[oper] [int] NULL ,
	[valu] [varchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Filters] (
	[seco] [char] (10) NOT NULL ,
	[tviw] [smallint] NOT NULL ,
	[fltr] [varchar] (30) NULL ,
	[cflt] [numeric](18, 0) IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[FilterConditions] WITH NOCHECK ADD 
	CONSTRAINT [PK_FilterConditions] PRIMARY KEY  NONCLUSTERED 
	(
		[cflt],
		[seqn]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Filters] WITH NOCHECK ADD 
	CONSTRAINT [PK_Filters] PRIMARY KEY  NONCLUSTERED 
	(
		[cflt]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsbss001] WITH NOCHECK ADD
	[sayn] [bit] NOT NULL DEFAULT 0,
	[obdc] [varchar] (4) NULL,
	[abdc] [varchar] (4) NULL
GO
	
ALTER TABLE tsbss002 ALTER COLUMN orpo VARCHAR(70)
GO
ALTER TABLE tsbss002 ALTER COLUMN acpo VARCHAR(62)
GO