  CREATE  INDEX [topic_id] ON [jforum_posts]([topic_id]) ON [PRIMARY]
  CREATE  INDEX [karma_id] ON [jforum_karma]([karma_id]) ON [PRIMARY]
  CREATE  INDEX [bookmarks_relation_id] ON [jforum_bookmarks]([relation_id]) ON [PRIMARY]
+
+ CREATE  INDEX [idx_att_post] ON [jforum_attach]([post_id]) ON [PRIMARY]
+ CREATE  INDEX [idx_att_priv] ON [jforum_attach]([privmsgs_id]) ON [PRIMARY]
+ CREATE  INDEX [idx_att_user] ON [jforum_attach]([user_id]) ON [PRIMARY]
+ CREATE  INDEX [idx_att_d_att] ON [jforum_attach_desc]([attach_id]) ON [PRIMARY]
+ CREATE  INDEX [idx_att_d_ext] ON [jforum_attach_desc]([extension_id]) ON [PRIMARY]

	[description] [varchar] (255)
) ON [PRIMARY]

 CREATE  INDEX [forum_id] ON [jforum_posts]([forum_id]) ON [PRIMARY]
 CREATE  INDEX [idx_role] ON [jforum_role_values]([role_id]) ON [PRIMARY]
 CREATE  INDEX [idx_group] ON [jforum_roles]([group_id]) ON [PRIMARY]


IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[jforum_bookmarks]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [jforum_bookmarks]

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[jforum_quota_limit]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [jforum_quota_limit]

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[jforum_extension_groups]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [jforum_extension_groups]

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[jforum_extensions]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [jforum_extensions]

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[jforum_attach]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [jforum_attach]

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[jforum_attach_desc]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [jforum_attach_desc]

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[jforum_attch_quota]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [jforum_attch_quota]


CREATE TABLE [jforum_banlist] (
	[banlist_id] [bigint] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,
