create.sql

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

CREATE TABLE jbb_badwords (
    id_badword bigint DEFAULT 0 NOT NULL,
    word character varying(50),
    replacement character varying(50)
) WITHOUT OIDS;
--
-- Structure for table jbb_category (OID = 234201) : 
--
CREATE TABLE jbb_category (
    id_category bigint DEFAULT 0 NOT NULL,
    nm_category character varying(200),
    cat_order integer DEFAULT 0 NOT NULL
) WITHOUT OIDS;
--
-- Structure for table jbb_forum (OID = 234205) : 
--
CREATE TABLE jbb_forum (
    id_forum bigint DEFAULT 0 NOT NULL,
    nome character varying(200),
    descricao text,
    forum_status integer,
    forum_order integer,
    id_category bigint DEFAULT 0,
    last_post_id bigint,
    topic_count bigint,
    post_count bigint,
    last_page_post bigint DEFAULT 1,
    last_post_user_name character varying(255),
    last_post_user_id bigint,
    last_post_date timestamp(0) without time zone,
    last_topic_id bigint
) WITHOUT OIDS;
--
-- Structure for table jbb_group (OID = 234213) : 
--
CREATE TABLE jbb_group (
    group_id bigint DEFAULT 0 NOT NULL,
    id_user bigint,
    group_name character varying(255)
) WITHOUT OIDS;
--
-- Structure for table jbb_group_moderator (OID = 234216) : 
--
CREATE TABLE jbb_group_moderator (
    group_id bigint DEFAULT 0 NOT NULL,
    id_forum bigint DEFAULT 0 NOT NULL
) WITHOUT OIDS;
--
-- Structure for table jbb_group_permission (OID = 234220) : 
--
CREATE TABLE jbb_group_permission (
    group_id bigint DEFAULT 0 NOT NULL,
    id_forum bigint DEFAULT 0,
    permission_type bigint
) WITHOUT OIDS;
--
-- Structure for table jbb_privmsg_inbox (OID = 234224) : 
--
CREATE TABLE jbb_privmsg_inbox (
    id_privmsg integer DEFAULT 0 NOT NULL,
    id_user_from integer DEFAULT 0,
    id_user_to integer DEFAULT 0,
    privmsg_topic character varying(255),
    privmsg_text text,
    privmsg_date timestamp(0) without time zone,
    allow_bbcode integer DEFAULT 0,
    allow_smiles integer DEFAULT 0,
    attach_sign integer DEFAULT 1,
    flag_read integer DEFAULT 0
) WITHOUT OIDS;
--
-- Structure for table jbb_privmsg_outbox (OID = 234236) : 
--
CREATE TABLE jbb_privmsg_outbox (
    id_privmsg integer DEFAULT 0 NOT NULL,
    id_user_from integer DEFAULT 0,
    id_user_to integer DEFAULT 0,
    privmsg_topic character varying(255),
    privmsg_text text,
    privmsg_date timestamp(0) without time zone,
    allow_bbcode integer DEFAULT 0,
    allow_smiles integer DEFAULT 0,
    attach_sign integer DEFAULT 1,
    flag_read integer DEFAULT 0
) WITHOUT OIDS;
--
-- Structure for table jbb_smiles (OID = 234248) : 
--
CREATE TABLE jbb_smiles (
    id bigint DEFAULT 0 NOT NULL,
    symbol character varying(50),
    emoticon character varying(75),
    filename character varying(100)
) WITHOUT OIDS;
--
-- Structure for table jbb_topics (OID = 234251) : 
--
CREATE TABLE jbb_topics (
    id_topic bigint DEFAULT 0 NOT NULL,
    id_user bigint DEFAULT 0,
    id_forum bigint DEFAULT 0,
    title_topic character varying(200),
    data_topico timestamp(0) without time zone,
    visualizacoes integer DEFAULT 0,
    respostas integer DEFAULT 0,
    topic_status integer DEFAULT 0,
    last_post_date timestamp(0) without time zone,
    last_post_id bigint,
    last_post_page smallint,
    last_post_user_id bigint,
    last_post_user_name character varying(200),
    topic_model smallint DEFAULT 0,
    notify_me integer
) WITHOUT OIDS;
--
-- Structure for table jbb_user_group (OID = 234260) : 
--
CREATE TABLE jbb_user_group (
    group_id bigint DEFAULT 0 NOT NULL,
    id_user bigint DEFAULT 0 NOT NULL
) WITHOUT OIDS;
--
-- Structure for table jbb_users (OID = 234264) : 
--
CREATE TABLE jbb_users (
    id_user bigint DEFAULT 0,
    user_name character varying(50),
    pws character varying(50),
    name character varying(100),
    email character varying(100),
    posts integer DEFAULT 0,
    admin integer DEFAULT 0,
    data_registro timestamp(0) without time zone,
    localizacao character varying(100),
    website character varying(200),
    occupation character varying(200),
    user_sig text,
    user_msnm character varying(200),
    user_actualvisit timestamp(0) without time zone,
    user_lastvisit timestamp(0) without time zone,
    user_dateformat character varying(50),
    user_allow_viewonline character varying(1),
    user_avatar character varying(200),
    user_icq character varying(50),
    user_interests character varying(200),
    user_aim character varying(200),
    user_yim character varying(200),
    show_mail integer DEFAULT 0,
    show_signature integer DEFAULT 0,
    user_status integer,
    user_code character varying(100),
    receive_news user_status integer DEFAULT 1,
    hash_fpwd character varying(100)
) WITHOUT OIDS;
--
-- Structure for table jbb_posts_text (OID = 234274) : 
--
CREATE TABLE jbb_posts_text (
    id_post bigint NOT NULL,
    post_body text
) WITHOUT OIDS;
--
-- Structure for table jbb_answer_notify (OID = 234279) : 
--
CREATE TABLE jbb_answer_notify (
    id_topic bigint NOT NULL,
    id_user bigint NOT NULL
) WITHOUT OIDS;
--
-- Structure for table jbb_posts (OID = 234281) : 
--
CREATE TABLE jbb_posts (
    id_post bigint DEFAULT 0 NOT NULL,
    id_user bigint DEFAULT 0,
    id_topic bigint DEFAULT 0,
    data_post timestamp(0) without time zone,
    assunto character varying(200),
    sig integer DEFAULT 0,
    ip character varying(20),
    post_state integer DEFAULT 0
) WITHOUT OIDS;
--
-- Structure for table jbb_forum_top_user (OID = 234310) : 
--
CREATE TABLE jbb_forum_top_user (
    id_user bigint NOT NULL,
    post_count bigint,
    date_row timestamp(0) without time zone,
    id_forum bigint NOT NULL
);
--
-- Structure for table jbb_rank (OID = 234315) : 
--
CREATE TABLE jbb_rank (
    rank_id bigint NOT NULL,
    rank_name character varying(255),
    rank_min integer,
    rank_max integer,
    rank_image character varying(255)
);

CREATE TABLE jbb_fav_topic (
  id_topic bigint DEFAULT 0 NOT NULL UNIQUE,
  id_user bigint DEFAULT 0 NOT NULL UNIQUE
) WITHOUT OIDS;

ALTER TABLE ONLY jbb_fav_topic
    ADD CONSTRAINT jbb_fav_topic_pkey PRIMARY KEY (id_topic,id_user);

CREATE TABLE jbb_newsletter (
  news_id bigint NOT NULL,
  name character varying(255),
  html_text text,
  active integer DEFAULT 0
) WITHOUT OIDS;


CREATE TABLE jbb_posts_files (
  file_id bigint NOT NULL,
  post_id bigint NOT NULL,
  file_name character varying(255),
  file_path character varying(255),
  file_size character varying(255),
  user_file_name character varying(255),
) WITHOUT OIDS;



--
-- Data for blobs (OID = 234198) (LIMIT 0,1)
--
INSERT INTO jbb_badwords (id_badword, word, replacement) VALUES (1, 'shit', '***');
--
-- Data for blobs (OID = 234201) (LIMIT 0,1)
--
INSERT INTO jbb_category (id_category, nm_category, cat_order) VALUES (2, 'Misc', 30);
--
-- Data for blobs (OID = 234205) (LIMIT 0,1)
--
INSERT INTO jbb_forum (id_forum, nome, descricao, forum_status, forum_order, id_category, last_post_id, topic_count, post_count, last_page_post, last_post_user_name, last_post_user_id, last_post_date, last_topic_id) VALUES (1, 'JavaBB Informations', 'Informations about JavaBB', 0, 1, 2, 4, 3, 3, 1, 'admin', 63, '2006-04-08 11:08:14', NULL);
--
-- Data for blobs (OID = 234248) (LIMIT 0,50)
--
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (2, ':-D', 'Very Happy', 'icon_biggrin.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (3, ':grin:', 'Very Happy', 'icon_biggrin.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (4, ':)', 'Smile', 'icon_smile.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (5, ':-)', 'Smile', 'icon_smile.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (6, ':smile:', 'Smile', 'icon_smile.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (7, ':(', 'Sad', 'icon_sad.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (8, ':-(', 'Sad', 'icon_sad.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (9, ':sad:', 'Sad', 'icon_sad.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (10, ':o', 'Metal Rules!!', 'icon_surprised.gif');
INSERT INTO jbb_smiles (id, symbol, emoticon, filename) VALUES (13, ':shock:', 'Shocked', 'icon_eek.gif');