1 problem with [ip] set as an [int] value is you cant have it in the standard ip format like "192.168.1.1" you can only have it like "19216811" which wouldn't work. we need it as database type "varchar(50)" so we can enter the ip format.
So the solution to that is this:
Quote:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SK_gamebang_ip](
[nID] [smallint] NOT NULL,
[ip] [varchar(50)] NOT NULL,
[capacity] [smallint] NOT NULL
) ON [PRIMARY]
|
* Please feel free to correct me if im wrong, i dont have that much knowledge in databases but i have used them alot for different gaming servers.