text: 
  DROP TABLE IF EXISTS `cgn_forum`;
  CREATE TABLE `cgn_forum` (
  		
  	`cgn_forum_id` integer (11) NOT NULL auto_increment,  -- 
  
  	`name` varchar (255),  -- 
  
  	`is_locked` tinyint (1),  -- 
  
  	`is_visible` tinyint (1),  -- 
  
  	`is_moderated` tinyint (1),  -- 
  
  	`allow_uploads` tinyint (1),  -- 
  
  	`description` varchar (255),  -- 
  
  	`recent_post_datetime` integer (11),  -- 
  
  	`recent_poster` varchar (32),  -- 
  
  	`thread_count` integer (11),  -- 
  
  	`post_count` integer (11),  -- 
  
  	`unanswered_count` integer (11),  -- 
  
  	`cgn_forum_category_id` integer (11),  -- 
  
  	`group_id` int(10) unsigned default '0', --
  
  	`browse_mode` varchar (15) DEFAULT '',  -- 
  
  	PRIMARY KEY (cgn_forum_id)
  )TYPE=InnoDB;
  
  CREATE INDEX cgn_forum_category_idx ON cgn_forum (cgn_forum_category_id);
  
  -- DB type: mysql
  -- generated on: 08.16.2005
  
  DROP TABLE IF EXISTS `cgn_forum_post`;
  CREATE TABLE `cgn_forum_post` (
  		
  	`cgn_forum_post_id` integer (11) NOT NULL auto_increment,  -- 
  
  	`cgn_forum_id` integer (11),  -- 
  
  	`is_sticky` tinyint (1),  -- 
  
  	`is_hidden` tinyint (1),  -- 
  
  	`reply_id` integer (11),  -- 
  
  	`thread_id` integer (11),  -- 
  
  	`subject` varchar (255),  -- 
  
  	`user_id` int(10) unsigned default '0', --
  
  	`user_name` varchar (32),  -- 
  
  	`post_datetime` integer (11),  -- 
  
  	`last_edit_username` varchar (32),  -- 
  
  	`last_edit_datetime` integer (11),  -- 
  
  	`message` text,  -- 
  
  	PRIMARY KEY (cgn_forum_post_id)
  )TYPE=InnoDB;
  
  CREATE INDEX is_sticky_idx ON cgn_forum_post (is_sticky);
  CREATE INDEX user_idx ON cgn_forum_post (user_id);
  CREATE INDEX thread_id ON cgn_forum_post (thread_id);
  CREATE INDEX reply_id ON cgn_forum_post (reply_id);
  CREATE INDEX cgn_forum_id ON cgn_forum_post (cgn_forum_id);
  CREATE INDEX post_datetime ON cgn_forum_post (post_datetime);
  
  -- DB type: mysql
  -- generated on: 08.13.2005
  
  DROP TABLE IF EXISTS `cgn_forum_category`;
  CREATE TABLE `cgn_forum_category` (
  		
  	`cgn_forum_category_id` integer (11) NOT NULL auto_increment,  -- 
  
  	`name` varchar (255),  -- 
  
  	`group_id` int(10) unsigned default '0', --
  
  	PRIMARY KEY (cgn_forum_category_id)
  )TYPE=InnoDB;
  
  CREATE INDEX group_idx ON cgn_forum_category (group_id);
  
  -- DB type: mysql
  -- generated on: 08.16.2005
  
  DROP TABLE IF EXISTS `cgn_forum_user_activity`;
  CREATE TABLE `cgn_forum_user_activity` (
  		
  	`cgn_forum_user_activity_id` integer (11) NOT NULL auto_increment,  -- 
  
  	`cgn_forum_id` integer (11),  -- 
  
  	`user_id` integer (11),  -- 
  
  	`views` text,  -- 
  
  	PRIMARY KEY (cgn_forum_user_activity_id)
  )TYPE=InnoDB;
  
  CREATE INDEX cgn_forum_idx ON cgn_forum_user_activity (cgn_forum_id);
  CREATE INDEX user_idx ON cgn_forum_user_activity (user_id);
  
  -- DB type: mysql
  -- generated on: 08.18.2005
  
  DROP TABLE IF EXISTS `cgn_forum_trash_post`;
  CREATE TABLE `cgn_forum_trash_post` (
  		
  	`cgn_forum_trash_post_id` integer (11) NOT NULL auto_increment,  -- 
  
  	`cgn_forum_id` integer (11),  -- 
  
  	`is_sticky` tinyint (1),  -- 
  
  	`is_hidden` tinyint (1),  -- 
  
  	`reply_id` integer (11),  -- 
  
  	`thread_id` integer (11),  -- 
  
  	`subject` varchar (255),  -- 
  
  	`message` text,  -- 
  
  	`user_id` varchar (32),  -- 
  
  	`post_datetime` integer (11),  -- 
  
  	`last_edit_username` varchar (32),  -- 
  
  	`last_edit_datetime` integer (11),  -- 
  
  	PRIMARY KEY (cgn_forum_trash_post_id)
  )TYPE=InnoDB;
  
  CREATE INDEX is_sticky_idx ON cgn_forum_trash_post (is_sticky);
  CREATE INDEX user_idx ON cgn_forum_trash_post (user_id);
  CREATE INDEX thread_id ON cgn_forum_trash_post (thread_id);
  CREATE INDEX reply_id ON cgn_forum_trash_post (reply_id);
  
  