create.sql

javaBB,一套很不錯的JSP源碼,特共享給大家

CREATE TABLE `jbb_answer_notify` (
  `id_topic` bigint(20) NOT NULL default '0',
  `id_user` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id_topic`,`id_user`),
  KEY `jbb_answer_notify_ind1_fk` (`id_topic`),
  KEY `jbb_answer_notify_ind2_fk` (`id_user`),
  KEY `JBB_ANSWER_NOTIFY_FK` (`id_topic`),
  KEY `JBB_ANSWER_NOTIFYIDEX_FK` (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_badwords` table : 
#

CREATE TABLE `jbb_badwords` (
  `id_badword` bigint(20) unsigned NOT NULL auto_increment,
  `word` varchar(50) default NULL,
  `replacement` varchar(50) default NULL,
  PRIMARY KEY  (`id_badword`),
  UNIQUE KEY `id_badword` (`id_badword`),
  KEY `id_badword_2` (`id_badword`),
  KEY `id_badword_3` (`id_badword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_category` table : 
#

CREATE TABLE `jbb_category` (
  `id_category` bigint(3) unsigned NOT NULL auto_increment,
  `nm_category` varchar(200) NOT NULL default '',
  `cat_order` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_category`),
  UNIQUE KEY `id_category` (`id_category`),
  KEY `id_category_2` (`id_category`),
  KEY `id_category_3` (`id_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_forum` table : 
#

CREATE TABLE `jbb_forum` (
  `id_forum` bigint(20) unsigned NOT NULL auto_increment,
  `nome` varchar(200) default NULL,
  `descricao` varchar(200) default NULL,
  `forum_status` int(2) unsigned default NULL,
  `forum_order` int(2) unsigned default NULL,
  `id_category` bigint(20) unsigned NOT NULL default '0',
  `last_post_id` bigint(20) unsigned default NULL,
  `topic_count` bigint(20) unsigned default NULL,
  `post_count` bigint(20) unsigned default NULL,
  `last_page_post` bigint(20) unsigned default '1',
  `last_post_user_name` varchar(255) default NULL,
  `last_post_user_id` bigint(20) unsigned default NULL,
  `last_post_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `last_topic_id` bigint(20) unsigned default NULL,
  PRIMARY KEY  (`id_forum`),
  UNIQUE KEY `id_forum` (`id_forum`),
  KEY `id_forum_2` (`id_forum`),
  KEY `id_forum_3` (`id_forum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_forum_top_user` table : 
#

CREATE TABLE `jbb_forum_top_user` (
  `id_user` int(11) NOT NULL default '0',
  `post_count` int(11) NOT NULL default '0',
  `date_row` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `id_forum` int(11) default NULL,
  KEY `id_user` (`id_user`),
  KEY `id_forum` (`id_forum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_posts` table : 
#

CREATE TABLE `jbb_posts` (
  `id_post` bigint(20) unsigned NOT NULL auto_increment,
  `id_user` bigint(20) unsigned NOT NULL default '0',
  `id_topic` bigint(20) unsigned NOT NULL default '0',
  `data_post` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `assunto` varchar(200) default NULL,
  `sig` int(1) unsigned default '0',
  `ip` varchar(20) default NULL,
  `post_state` int(2) unsigned default '0',
  PRIMARY KEY  (`id_post`),
  UNIQUE KEY `id_post` (`id_post`),
  KEY `id_user` (`id_user`),
  KEY `id_topic` (`id_topic`),
  KEY `id_post_2` (`id_post`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_posts_text` table : 
#

CREATE TABLE `jbb_posts_text` (
  `id_post` bigint(20) NOT NULL default '0',
  `post_body` text,
  PRIMARY KEY  (`id_post`),
  KEY `id_post` (`id_post`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_privmsg_inbox` table : 
#

CREATE TABLE `jbb_privmsg_inbox` (
  `id_privmsg` int(11) NOT NULL auto_increment,
  `id_user_from` int(11) NOT NULL default '0',
  `id_user_to` int(11) NOT NULL default '0',
  `privmsg_topic` varchar(255) NOT NULL default '',
  `privmsg_text` text NOT NULL,
  `privmsg_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `allow_bbcode` int(1) default '0',
  `allow_smiles` int(1) default '0',
  `attach_sign` int(1) default '1',
  `flag_read` int(1) default '0',
  PRIMARY KEY  (`id_privmsg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_privmsg_outbox` table : 
#

CREATE TABLE `jbb_privmsg_outbox` (
  `id_privmsg` int(11) NOT NULL auto_increment,
  `id_user_from` int(11) NOT NULL default '0',
  `id_user_to` int(11) NOT NULL default '0',
  `privmsg_topic` varchar(255) NOT NULL default '',
  `privmsg_text` text NOT NULL,
  `privmsg_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `allow_bbcode` int(1) default '0',
  `allow_smiles` int(1) default '0',
  `attach_sign` int(1) default '1',
  `flag_read` int(1) default '0',
  PRIMARY KEY  (`id_privmsg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_rank` table : 
#

CREATE TABLE `jbb_rank` (
  `rank_id` int(11) unsigned NOT NULL auto_increment,
  `rank_name` varchar(255) default NULL,
  `rank_min` int(11) default NULL,
  `rank_max` int(11) default NULL,
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_smiles` table : 
#

CREATE TABLE `jbb_smiles` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `symbol` varchar(50) NOT NULL default '',
  `emoticon` varchar(75) NOT NULL default '',
  `filename` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_topics` table : 
#

CREATE TABLE `jbb_topics` (
  `id_topic` bigint(20) unsigned NOT NULL auto_increment,
  `id_user` bigint(20) unsigned NOT NULL default '0',
  `id_forum` bigint(20) unsigned NOT NULL default '0',
  `title_topic` varchar(200) NOT NULL default '',
  `data_topico` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `visualizacoes` int(10) unsigned default '0',
  `respostas` int(10) unsigned default '0',
  `topic_status` int(10) unsigned default '0',
  `topic_model` tinyint(3) unsigned default '0',
  `last_post_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  `last_post_id` bigint(20) unsigned default NULL,
  `last_post_page` tinyint(3) unsigned default NULL,
  `last_post_user_id` bigint(20) unsigned default NULL,
  `last_post_user_name` varchar(200) default NULL,
  `notify_me` tinyint(3) unsigned default '0',
  PRIMARY KEY  (`id_topic`),
  UNIQUE KEY `id_topic` (`id_topic`),
  KEY `id_topic_2` (`id_topic`),
  KEY `id_user` (`id_user`),
  KEY `id_forum` (`id_forum`),
  KEY `id_topic_3` (`id_topic`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `jbb_users` table : 
#

CREATE TABLE `jbb_users` (
  `id_user` bigint(20) unsigned NOT NULL auto_increment,
  `user_name` varchar(50) default NULL,
  `pws` varchar(50) default NULL,
  `name` varchar(100) default NULL,
  `email` varchar(100) default NULL,
  `posts` int(10) unsigned default '0',
  `admin` int(1) unsigned default '0',
  `data_registro` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `localizacao` varchar(100) default NULL,
  `website` varchar(200) default NULL,
  `occupation` varchar(200) default NULL,
  `user_sig` text,
  `user_msnm` varchar(200) default NULL,
  `user_actualvisit` timestamp NOT NULL default '0000-00-00 00:00:00',