 
 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]

CREATE TABLE [jforum_vote_results] (
	[vote_id] [bigint] DEFAULT (0) NOT NULL ,
	[vote_option_id] [tinyint] DEFAULT (0) NOT NULL ,
	[vote_option_text] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[vote_result] [bigint] DEFAULT (0) NOT NULL 
) ON [PRIMARY]



CREATE TABLE [jforum_smilies] (
	[smilie_id] [int] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
	[code] [varchar] (50) NOT NULL ,
	[url] [varchar] (100) NULL ,
	[disk_name] [varchar] (255) NULL 
) ON [PRIMARY]


CREATE TABLE [jforum_themes] (
	[themes_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
	[template_name] [varchar] (30) NOT NULL ,
	[style_name] [varchar] (30) NOT NULL 
) ON [PRIMARY]

CREATE TABLE [jforum_topics] (
	[topic_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
	[forum_id] [int] DEFAULT (0) NOT NULL ,
	[topic_title] [varchar] (100) NOT NULL ,
	[user_id] [bigint] DEFAULT (0) NOT NULL ,
	[topic_time] [datetime] NULL ,
	[topic_views] [bigint] DEFAULT (1) NULL ,
