Table: Server

ColumnName	DataType	Key	Not Null	Default Value	Comment
ServerID	INTEGER	PK	NN		Unique server ID
Description	NVARCHAR(255)				Arbitrary description
IPAddress	NVARCHAR(255)				Server IP address (dotted notation)
IPName	NVARCHAR(255)				Server host name
ServerTypeID	INTEGER		NN		Server type 1 SERVERTYPE_DNS Domain name server 2 SERVERTYPE_GW  Router 3 SERVERTYPE_FONT  Font server 4 SERVERTYPE_TIME  Time server 5 SERVERTYPE_WOL  WakeOnLAN server 6 SERVERTYPE_PROXY  Proxy server 7 SERVERTYPE_FW  Firmware server 8 SERVERTYPE_FILE  File server
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ServerID

 

how to create

CREATE TABLE Server(
ServerID INTEGER NOT NULL,
Description NVARCHAR(255),
IPAddress NVARCHAR(255),
IPName NVARCHAR(255),
ServerTypeID INTEGER NOT NULL,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (ServerID));