alvinalexander.com | career | drupal | java | mac | mysql | perl | scala | uml | unix  

What this is

This file is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" TM.

Other links

The source code

srjava.util.ArrayListxaIsizexpFwXt$DROP TABLE IF EXISTS jforum_banlist;tCREATE TABLE jforum_banlist (  banlist_id mediumint(8) NOT NULL auto_increment,  user_id mediumint(8) NOT NULL default '0',  banlist_ip varchar(8) NOT NULL default '',  banlist_email varchar(255) default NULL,  PRIMARY KEY  (banlist_id),  INDEX idx_user (user_id)) TYPE=InnoDB;t'DROP TABLE IF EXISTS jforum_categories;tCREATE TABLE jforum_categories (  categories_id mediumint(8) NOT NULL auto_increment,  title varchar(100) NOT NULL default '',  display_order mediumint(8) NOT NULL default '0',  moderated TINYINT(1) DEFAULT '0',  PRIMARY KEY  (categories_id)) TYPE=InnoDB;t#DROP TABLE IF EXISTS jforum_config;tCREATE TABLE jforum_config (  config_name varchar(255) NOT NULL default '',  config_value varchar(255) NOT NULL default '',  config_id int not null auto_increment,  PRIMARY KEY(config_id)) TYPE=InnoDB;t#DROP TABLE IF EXISTS jforum_forums;tCREATE TABLE jforum_forums (  forum_id smallint(5) NOT NULL auto_increment,  categories_id mediumint(8) NOT NULL default '1',  forum_name varchar(150) NOT NULL default '',  forum_desc varchar(255) default NULL,  forum_order mediumint(8) default '1',  forum_topics mediumint(8) NOT NULL default '0',  forum_last_post_id mediumint(8) NOT NULL default '0',  moderated TINYINT(1) DEFAULT '0',  PRIMARY KEY  (forum_id),  KEY (categories_id)) TYPE=InnoDB;t#DROP TABLE IF EXISTS jforum_groups;tCREATE TABLE jforum_groups (  group_id mediumint(8) NOT NULL auto_increment,  group_name varchar(40) NOT NULL default '',  group_description varchar(255) default NULL,  parent_id mediumint(8) default '0',  PRIMARY KEY  (group_id)) TYPE=InnoDB;t(DROP TABLE IF EXISTS jforum_user_groups;tCREATE TABLE jforum_user_groups (	group_id INT NOT NULL,	user_id INT NOT NULL,	INDEX idx_group (group_id),	INDEX idx_user (user_id)) TYPE=InnoDB;t"DROP TABLE IF EXISTS jforum_roles;t/CREATE TABLE jforum_roles (  role_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,  group_id mediumint(8) default '0',  user_id mediumint(8) default '0',  name varchar(255) NOT NULL,  role_type TINYINT(1) DEFAULT 1,  INDEX idx_group (group_id),  INDEX idx_user (user_id),  INDEX idx_name (name)) TYPE=InnoDB;t(DROP TABLE IF EXISTS jforum_role_values;tCREATE TABLE jforum_role_values (  role_id INT NOT NULL,  role_value VARCHAR(255),  role_type TINYINT(1) DEFAULT 1,  INDEX idx_role(role_id)) TYPE=InnoDB;t"DROP TABLE IF EXISTS jforum_posts;tCREATE TABLE jforum_posts (  post_id mediumint(8) NOT NULL auto_increment,  topic_id mediumint(8) NOT NULL default '0',  forum_id smallint(5) NOT NULL default '0',  user_id mediumint(8) default NULL,  post_time datetime default NULL,  poster_ip varchar(15) default NULL,  enable_bbcode tinyint(1) NOT NULL default '1',  enable_html tinyint(1) NOT NULL default '1',  enable_smilies tinyint(1) NOT NULL default '1',  enable_sig tinyint(1) NOT NULL default '1',  post_edit_time datetime default NULL,  post_edit_count smallint(5) NOT NULL default '0',  status tinyint(1) default '1',  PRIMARY KEY  (post_id),  attach TINYINT(1) DEFAULT '0',  need_moderate TINYINT(1) DEFAULT '0',  KEY (user_id),  KEY (topic_id),  KEY (forum_id)) TYPE=InnoDB;t'DROP TABLE IF EXISTS jforum_posts_text;tCREATE TABLE jforum_posts_text (	post_id MEDIUMINT(8) NOT NULL PRIMARY KEY,	post_text TEXT,	post_subject VARCHAR(100)) TYPE=InnoDB;t%DROP TABLE IF EXISTS jforum_privmsgs;tCREATE TABLE jforum_privmsgs (  privmsgs_id mediumint(8) NOT NULL auto_increment,  privmsgs_type tinyint(4) NOT NULL default '0',  privmsgs_subject varchar(255) NOT NULL default '',  privmsgs_from_userid mediumint(8) NOT NULL default '0',  privmsgs_to_userid mediumint(8) NOT NULL default '0',  privmsgs_date datetime default null,  privmsgs_ip varchar(8) NOT NULL default '',  privmsgs_enable_bbcode tinyint(1) NOT NULL default '1',  privmsgs_enable_html tinyint(1) NOT NULL default '0',  privmsgs_enable_smilies tinyint(1) NOT NULL default '1',  privmsgs_attach_sig tinyint(1) NOT NULL default '1',  PRIMARY KEY  (privmsgs_id)) TYPE=InnoDB;t*DROP TABLE IF EXISTS jforum_privmsgs_text;tCREATE TABLE jforum_privmsgs_text (	privmsgs_id MEDIUMINT(8) NOT NULL,	privmsgs_text TEXT,	PRIMARY KEY ( privmsgs_id )) Type=InnoDB;t"DROP TABLE IF EXISTS jforum_ranks;tCREATE TABLE jforum_ranks (  rank_id smallint(5) NOT NULL auto_increment,  rank_title varchar(50) NOT NULL default '',  rank_min mediumint(8) NOT NULL default '0',  rank_special tinyint(1) default NULL,  rank_image varchar(255) default NULL,  PRIMARY KEY  (rank_id)) TYPE=InnoDB;t%DROP TABLE IF EXISTS jforum_sessions;tYCREATE TABLE jforum_sessions (  session_id varchar(50) NOT NULL default '',  session_user_id mediumint(8) NOT NULL default '0',  session_start datetime default null,  session_time bigint default '0',  session_ip varchar(8) NOT NULL default '',  session_page int(11) NOT NULL default '0',  session_logged_int tinyint(1) default NULL) TYPE=InnoDB;t$DROP TABLE IF EXISTS jforum_smilies;tCREATE TABLE jforum_smilies (  smilie_id smallint(5) NOT NULL auto_increment,  code varchar(50) NOT NULL default '',  url varchar(100) default NULL,  disk_name varchar(255),  PRIMARY KEY  (smilie_id)) TYPE=InnoDB;t#DROP TABLE IF EXISTS jforum_themes;tCREATE TABLE jforum_themes (  themes_id mediumint(8) NOT NULL auto_increment,  template_name varchar(30) NOT NULL default '',  style_name varchar(30) NOT NULL default '',  PRIMARY KEY  (themes_id)) TYPE=InnoDB;t#DROP TABLE IF EXISTS jforum_topics;tCREATE TABLE jforum_topics (  topic_id mediumint(8) NOT NULL auto_increment,  forum_id smallint(8) NOT NULL default '0',  topic_title varchar(100) NOT NULL default '',  user_id mediumint(8) NOT NULL default '0',  topic_time datetime default null,  topic_views mediumint(8) default '1',  topic_replies mediumint(8) default '0',  topic_status tinyint(3) default '0',  topic_vote tinyint(1) default '0',  topic_type tinyint(3) default '0',  topic_first_post_id mediumint(8) default '0',  topic_last_post_id mediumint(8) NOT NULL default '0',  moderated TINYINT(1) DEFAULT '0',  PRIMARY KEY  (topic_id),  KEY (forum_id),  KEY(user_id),  KEY(topic_first_post_id),  KEY(topic_last_post_id)) TYPE=InnoDB;t)DROP TABLE IF EXISTS jforum_topics_watch;tCREATE TABLE jforum_topics_watch (  topic_id mediumint(8) NOT NULL default '0',  user_id mediumint(8) NOT NULL default '0',  is_read tinyint(1) NOT NULL DEFAULT '0',  INDEX idx_topic (topic_id),  INDEX idx_user (user_id)) TYPE=InnoDB;t"DROP TABLE IF EXISTS jforum_users;t+CREATE TABLE jforum_users (  user_id mediumint(8) NOT NULL auto_increment,  user_active tinyint(1) default NULL,  username varchar(50) NOT NULL default '',  user_password varchar(32) NOT NULL default '',  user_session_time bigint default 0,  user_session_page smallint(5) NOT NULL default '0',  user_lastvisit datetime default null,  user_regdate datetime default null,  user_level tinyint(4) default NULL,  user_posts mediumint(8) NOT NULL default '0',  user_timezone varchar(5) NOT NULL default '',  user_style tinyint(4) default NULL,  user_lang varchar(255) NOT NULL default '',  user_dateformat varchar(20) NOT NULL default '%d/%M/%Y %H:%i',  user_new_privmsg smallint(5) NOT NULL default '0',  user_unread_privmsg smallint(5) NOT NULL default '0',  user_last_privmsg datetime NULL,  user_emailtime datetime default NULL,  user_viewemail tinyint(1) default '0',  user_attachsig tinyint(1) default '1',  user_allowhtml tinyint(1) default '0',  user_allowbbcode tinyint(1) default '1',  user_allowsmilies tinyint(1) default '1',  user_allowavatar tinyint(1) default '1',  user_allow_pm tinyint(1) default '1',  user_allow_viewonline tinyint(1) default '1',  user_notify tinyint(1) default '1',  user_notify_pm tinyint(1) default '1',  user_popup_pm tinyint(1) default '1',  rank_id smallint(5) default '1',  user_avatar varchar(100) default NULL,  user_avatar_type tinyint(4) NOT NULL default '0',  user_email varchar(255) NOT NULL default '',  user_icq varchar(15) default NULL,  user_website varchar(100) default NULL,  user_from varchar(100) default NULL,  user_sig text,  user_sig_bbcode_uid varchar(10) default NULL,  user_aim varchar(255) default NULL,  user_yim varchar(255) default NULL,  user_msnm varchar(255) default NULL,  user_occ varchar(100) default NULL,  user_interests varchar(255) default NULL,  user_actkey varchar(32) default NULL,  gender char(1) default NULL,  themes_id mediumint(8) default NULL,  deleted tinyint(1) default NULL,  user_viewonline tinyint(1) default '1',  security_hash varchar(32),  user_karma DECIMAL(10,2),  PRIMARY KEY  (user_id)) TYPE=InnoDB;t&DROP TABLE IF EXISTS jforum_vote_desc;tCREATE TABLE jforum_vote_desc (  vote_id mediumint(8) NOT NULL auto_increment,  topic_id mediumint(8) NOT NULL default '0',  vote_text text NOT NULL,  vote_start int(11) NOT NULL default '0',  vote_length int(11) NOT NULL default '0',  PRIMARY KEY  (vote_id)) TYPE=InnoDB;t)DROP TABLE IF EXISTS jforum_vote_results;tCREATE TABLE jforum_vote_results (  vote_id mediumint(8) NOT NULL default '0',  vote_option_id tinyint(4) NOT NULL default '0',  vote_option_text varchar(255) NOT NULL default '',  vote_result int(11) NOT NULL default '0') TYPE=InnoDB;t(DROP TABLE IF EXISTS jforum_vote_voters;tCREATE TABLE jforum_vote_voters (  vote_id mediumint(8) NOT NULL default '0',  vote_user_id mediumint(8) NOT NULL default '0',  vote_user_ip char(8) NOT NULL default '') TYPE=InnoDB;t"DROP TABLE IF EXISTS jforum_words;tCREATE TABLE jforum_words (  word_id mediumint(8) NOT NULL auto_increment,  word varchar(100) NOT NULL default '',  replacement varchar(100) NOT NULL default '',  PRIMARY KEY  (word_id)) TYPE=InnoDB;t)DROP TABLE IF EXISTS jforum_search_words;tCREATE TABLE jforum_search_words (  word_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,  word VARCHAR(100) NOT NULL,  word_hash INT,  KEY(word),  KEY(word_hash)) TYPE=InnoDB;t-DROP TABLE IF EXISTS jforum_search_wordmatch;tCREATE TABLE jforum_search_wordmatch (  post_id INT NOT NULL,  word_id INT NOT NULL,  title_match TINYINT(1) DEFAULT '0',  KEY(post_id),  KEY(word_id),  KEY(title_match)) TYPE=InnoDB;t+DROP TABLE IF EXISTS jforum_search_results;tCREATE TABLE jforum_search_results (  topic_id INT NOT NULL,  session VARCHAR(50),  search_time DATETIME,  KEY (topic_id)) TYPE=InnoDB;t*DROP TABLE IF EXISTS jforum_search_topics;tCREATE TABLE jforum_search_topics (  topic_id mediumint(8) NOT NULL,  forum_id smallint(8) NOT NULL default '0',  topic_title varchar(60) NOT NULL default '',  user_id mediumint(8) NOT NULL default '0',  topic_time datetime default null,  topic_views mediumint(8) default '1',  topic_replies mediumint(8) default '0',  topic_status tinyint(3) default '0',  topic_vote tinyint(1) default '0',  topic_type tinyint(3) default '0',  topic_first_post_id mediumint(8) default '0',  topic_last_post_id mediumint(8) NOT NULL default '0',  moderated smallint(1) default '0',  session varchar(50),  search_time datetime,  KEY  (topic_id),  KEY (forum_id),  KEY(user_id),  KEY(topic_first_post_id),  KEY(topic_last_post_id)) TYPE=InnoDB;t"DROP TABLE IF EXISTS jforum_karma;tCREATE TABLE jforum_karma (	karma_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,	post_id INT NOT NULL,	topic_id INT NOT NULL,	post_user_id INT NOT NULL,	from_user_id INT NOT NULL,	points INT NOT NULL,	KEY(post_id),	KEY(topic_id),	KEY(post_user_id),	KEY(from_user_id)) TYPE=InnoDB;t&DROP TABLE IF EXISTS jforum_bookmarks;t0CREATE TABLE jforum_bookmarks (	bookmark_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,	user_id INT NOT NULL,	relation_id INT NOT NULL,	relation_type INT NOT NULL,	public_visible INT DEFAULT '1',	title varchar(255),	description varchar(255),	INDEX book_idx_relation (relation_id),	KEY(user_id)) TYPE=InnoDB;t(DROP TABLE IF EXISTS jforum_quota_limit;tCREATE TABLE jforum_quota_limit (	quota_limit_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,	quota_desc VARCHAR(50) NOT NULL,	quota_limit INT NOT NULL,	quota_type TINYINT(1) DEFAULT '1') TYPE=InnoDB;t-DROP TABLE IF EXISTS jforum_extension_groups;tCREATE TABLE jforum_extension_groups (	extension_group_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,	name VARCHAR(100) NOT NULL,	allow TINYINT(1) DEFAULT '1', 	upload_icon VARCHAR(100),	download_mode TINYINT(1) DEFAULT '1') TYPE=InnoDB;t'DROP TABLE IF EXISTS jforum_extensions;tCREATE TABLE jforum_extensions (	extension_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,	extension_group_id INT NOT NULL,	description VARCHAR(100),	upload_icon VARCHAR(100),	extension VARCHAR(10),	allow TINYINT(1) DEFAULT '1',	KEY(extension_group_id)) TYPE=InnoDB;t#DROP TABLE IF EXISTS jforum_attach;tCREATE TABLE jforum_attach (	attach_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,	post_id INT,	privmsgs_id INT,	user_id INT NOT NULL,	INDEX idx_att_post(post_id),	INDEX idx_att_priv(privmsgs_id),	INDEX idx_att_user(user_id)) TYPE=InnoDB;t(DROP TABLE IF EXISTS jforum_attach_desc;tCREATE TABLE jforum_attach_desc (	attach_desc_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,	attach_id INT NOT NULL,	physical_filename VARCHAR(255) NOT NULL,	real_filename VARCHAR(255) NOT NULL,	download_count INT,	description VARCHAR(255),	mimetype VARCHAR(50),	filesize INT,	upload_time DATETIME,	thumb TINYINT(1) DEFAULT '0',	extension_id INT,	INDEX idx_att_d_att(attach_id),	INDEX idx_att_d_ext(extension_id)) TYPE=InnoDB;t)DROP TABLE IF EXISTS jforum_attach_quota;tCREATE TABLE jforum_attach_quota (	attach_quota_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,	group_id INT NOT NULL,	quota_limit_id INT NOT NULL,	KEY(group_id)) TYPE=InnoDB;x
... this post is sponsored by my books ...

#1 New Release!

FP Best Seller

 

new blog posts

 

Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.

A percentage of advertising revenue from
pages under the /java/jwarehouse URI on this website is
paid back to open source projects.