 
 CREATE TABLE [jforum_search_words] (
 	[word_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
-	[word] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[word] [varchar] (100) NOT NULL ,
 	[word_hash] [bigint] NULL 
 ) ON [PRIMARY]
 
 
 CREATE TABLE [jforum_sessions] (
-	[session_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[session_id] [varchar] (50) NOT NULL ,
 	[session_user_id] [bigint] DEFAULT (0) NOT NULL ,
 	[session_start] [datetime] NULL ,
 	[session_time] [bigint] DEFAULT (0) NULL ,
-	[session_ip] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL  ,
+	[session_ip] [varchar] (8) DEFAULT '' NOT NULL  ,
 	[session_page] [bigint] DEFAULT (0) NOT NULL ,
 	[session_logged_int] [tinyint] NULL 
 ) ON [PRIMARY]

	[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 ,
	[enable_bbcode] [tinyint] DEFAULT (1) NOT NULL ,
	[enable_html] [tinyint] DEFAULT (1)  NOT NULL ,
	[enable_smilies] [tinyint] DEFAULT (1) NOT NULL ,

CREATE TABLE [jforum_banlist] (
	[banlist_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
	[user_id] [bigint] DEFAULT (0) NOT NULL ,
	[banlist_ip] [varchar] (8) NOT NULL ,
	[banlist_email] [varchar] (255) NULL 
) ON [PRIMARY]


CREATE TABLE [jforum_categories] (
	[categories_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
	[title] [varchar] (100) NOT NULL ,
	[display_order] [bigint] DEFAULT (0) NOT NULL,
	[moderated] [tinyint] DEFAULT (0) 
) ON [PRIMARY]


CREATE TABLE [jforum_config] (
	[config_name] [varchar] (255) NOT NULL ,
	[config_value] [varchar] (255) NOT NULL ,
	[config_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL 
) ON [PRIMARY]

