[dbo].[wtipx_generic

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:52 AM Wednesday, March 07, 2007
Last Modified	11:36:17 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
uuid	binary(16)	16
segment	varchar(8)	8
lanmode	char(1)	1
nodeaddresstype	char(1)	1
maxdatasize	int	4
transporttime	int	4
version	varchar(10)	10
flagether	char(1)	1
selectedcfg	char(1)	1
landesc	varchar(80)	80
ioaddress1	int	4
ioaddress2	int	4
iorange1	int	4
iorange2	int	4
memoryaddress1	varchar(3)	3
memoryaddress2	varchar(3)	3
memoryrange1	int	4
memoryrange2	int	4
interruptline1	char(1)	1
interruptline2	char(1)	1
dmaline1	char(1)	1
dmaline2	char(1)	1
microchannelflag	char(1)	1
textdesc	varchar(80)	80

	Name	Columns	Unique
	XPKwtipx_generic_interface	uuid
	x_IPX_Generic_Interface_x	uuid

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Delete	wvadmin
Grant	Insert	wvadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser
Grant	Select	wvadmin
Grant	Update	wvadmin
Grant	Select	wvuser

SQL Script

CREATE TABLE [dbo].[wtipx_generic_interface]
(
[uuid] [binary] (16) NOT NULL,
[segment] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lanmode] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[nodeaddresstype] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[maxdatasize] [int] NULL,
[transporttime] [int] NULL,
[version] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[flagether] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[selectedcfg] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[landesc] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ioaddress1] [int] NULL,
[ioaddress2] [int] NULL,
[iorange1] [int] NULL,
[iorange2] [int] NULL,
[memoryaddress1] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[memoryaddress2] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[memoryrange1] [int] NULL,
[memoryrange2] [int] NULL,
[interruptline1] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[interruptline2] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dmaline1] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dmaline2] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[microchannelflag] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[textdesc] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtipx_generic_interface] ADD CONSTRAINT [XPKwtipx_generic_interface] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_IPX_Generic_Interface_x] ON [dbo].[wtipx_generic_interface] ([uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[wtipx_generic_interface] TO [uniadmin]
GRANT INSERT ON  [dbo].[wtipx_generic_interface] TO [uniadmin]
GRANT DELETE ON  [dbo].[wtipx_generic_interface] TO [uniadmin]
GRANT UPDATE ON  [dbo].[wtipx_generic_interface] TO [uniadmin]
GRANT SELECT ON  [dbo].[wtipx_generic_interface] TO [uniuser]
GRANT SELECT ON  [dbo].[wtipx_generic_interface] TO [wvadmin]
GRANT INSERT ON  [dbo].[wtipx_generic_interface] TO [wvadmin]
GRANT DELETE ON  [dbo].[wtipx_generic_interface] TO [wvadmin]
GRANT UPDATE ON  [dbo].[wtipx_generic_interface] TO [wvadmin]
GRANT SELECT ON  [dbo].[wtipx_generic_interface] TO [wvuser]
GO