 	[forum_id] [int] DEFAULT (0) NOT NULL ,
 	[user_id] [bigint] DEFAULT (0) NOT NULL ,
 	[post_time] [datetime] NULL ,
-	[poster_ip] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+	[poster_ip] [varchar] (15) NULL ,
 	[enable_bbcode] [tinyint] DEFAULT (1) NOT NULL ,
 	[enable_html] [tinyint] DEFAULT (1)  NOT NULL ,
 	[enable_smilies] [tinyint] DEFAULT (1) NOT NULL ,


CREATE TABLE [jforum_groups] (
	[group_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
	[group_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[group_description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[parent_id] [bigint] DEFAULT (0) NULL 
) ON [PRIMARY]



CREATE TABLE [jforum_privmsgs_text] (
	[privmsgs_id] [bigint] DEFAULT (0) PRIMARY KEY CLUSTERED NOT NULL ,
	[privmsgs_text] [text] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [jforum_ranks] (
	[rank_id] [int] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
	[rank_title] [varchar] (50) NOT NULL ,
	[rank_min] [bigint] DEFAULT (0) NOT NULL ,
	[rank_special] [tinyint] NULL ,
	[rank_image] [varchar] (255) NULL 
) ON [PRIMARY]

	
CREATE TABLE [jforum_role_values] (
	[role_id] [bigint] DEFAULT (0) NOT NULL ,
	[role_value] [varchar] (255) NULL ,
	[role_type] [tinyint] DEFAULT (1) NULL 
) ON [PRIMARY]

