 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) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
-	[banlist_email] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS 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) COLLATE SQL_Latin1_General_CP1_CI_AS 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) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
-	[config_value] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+	[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]
 


CREATE TABLE [jforum_posts_text] (
	[post_id] [bigint] DEFAULT (0) PRIMARY KEY CLUSTERED NOT NULL ,
	[post_text] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[post_subject] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [jforum_privmsgs] (
	[privmsgs_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
	[privmsgs_type] [tinyint] DEFAULT (0) NOT NULL ,
	[privmsgs_subject] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[privmsgs_from_userid] [bigint] DEFAULT (0) NOT NULL ,
	[privmsgs_to_userid] [bigint] DEFAULT (0) NOT NULL ,
	[privmsgs_date] [datetime] NULL ,
	[privmsgs_ip] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT('') NOT NULL , 
	[privmsgs_enable_bbcode] [tinyint] DEFAULT (1) NOT NULL ,
	[privmsgs_enable_html] [tinyint] DEFAULT (0) NOT NULL ,
	[privmsgs_enable_smilies] [tinyint] DEFAULT (1) NOT NULL ,

	[user_notify_pm] [tinyint] DEFAULT (1) NULL ,
	[user_popup_pm] [tinyint] DEFAULT (1) NULL ,
	[rank_id] [int] DEFAULT (1) NULL ,
	[user_avatar] [varchar] (100)  NULL ,
	[user_avatar_type] [tinyint] DEFAULT (0) NOT NULL ,
	[user_email] [varchar] (255)  DEFAULT('') NOT NULL ,
	[user_icq] [varchar] (15) NULL ,
	[user_website] [varchar] (100) NULL ,
	[user_from] [varchar] (100) NULL ,
	[user_sig] [text] NULL ,
	[user_sig_bbcode_uid] [varchar] (10) NULL ,
	[user_aim] [varchar] (255) NULL ,
	[user_yim] [varchar] (255) NULL ,
	[user_msnm] [varchar] (255) NULL ,
	[user_occ] [varchar] (100) NULL ,
	[user_interests] [varchar] (255) NULL ,
	[user_actkey] [varchar] (32) NULL ,
	[gender] [char] (1) NULL ,
	[themes_id] [bigint] NULL ,
	[deleted] [tinyint] NULL ,
	[user_viewonline] [tinyint] DEFAULT(1) NULL ,
	[security_hash] [varchar] (32) NULL, 
	[user_karma] [decimal] (10,2)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

