From 2ce073c4efb685f0bf92db2e79f1423c20b08129 Mon Sep 17 00:00:00 2001 From: James Atkinson <thefinn@users.sourceforge.net> Date: Thu, 13 Sep 2001 09:54:09 +0000 Subject: Inital work on Oracle schema. If you are installing on oracle run the triggers file AFTER the basic file git-svn-id: file:///svn/phpbb/trunk@1032 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/oracle_schema.sql | 481 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 481 insertions(+) create mode 100755 phpBB/db/oracle_schema.sql (limited to 'phpBB/db/oracle_schema.sql') diff --git a/phpBB/db/oracle_schema.sql b/phpBB/db/oracle_schema.sql new file mode 100755 index 0000000000..22ae342a36 --- /dev/null +++ b/phpBB/db/oracle_schema.sql @@ -0,0 +1,481 @@ +/* + phpBB2 Oracle 8i DB schema - (c) 2001 The phpBB Group + + $Id$ +*/ + +CREATE SEQUENCE phpbb_banlist_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_categories_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_config_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_disallow_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_forums_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_posts_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_privmsgs_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_ranks_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_smilies_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_themes_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_topics_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_users_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_words_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_groups_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_forum_prune_id_seq increment by 1 start with 2 minvalue 0; +CREATE SEQUENCE phpbb_vote_desc_id_seq increment by 1 start with 2 minvalue 0; + + +/* -------------------------------------------------------- + Table structure for table phpbb_auth_access +-------------------------------------------------------- */ +CREATE TABLE phpbb_auth_access ( + group_id number(4) DEFAULT '0' NOT NULL, + forum_id number(4) DEFAULT '0' NOT NULL, + auth_view number(4) DEFAULT '0' NOT NULL, + auth_read number(4) DEFAULT '0' NOT NULL, + auth_post number(4) DEFAULT '0' NOT NULL, + auth_reply number(4) DEFAULT '0' NOT NULL, + auth_edit number(4) DEFAULT '0' NOT NULL, + auth_delete number(4) DEFAULT '0' NOT NULL, + auth_announce number(4) DEFAULT '0' NOT NULL, + auth_sticky number(4) DEFAULT '0' NOT NULL, + auth_pollcreate number(4) DEFAULT '0' NOT NULL, + auth_attachments number(4) DEFAULT '0' NOT NULL, + auth_vote number(4) DEFAULT '0' NOT NULL, + auth_mod number(4) DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_auth_access_pkey PRIMARY KEY (group_id) +); +CREATE INDEX group_phpbb_auth_access_index ON phpbb_auth_access (forum_id); + + +/* -------------------------------------------------------- + Table structure for table phpbb_groups +-------------------------------------------------------- */ +CREATE TABLE phpbb_groups ( + group_id number(4) NOT NULL, + group_name varchar(40) NOT NULL, + group_type number(2) DEFAULT '1' NOT NULL, + group_description varchar(255) NOT NULL, + group_moderator number(4) DEFAULT '0' NOT NULL, + group_single_user number(4) DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_groups_pkey PRIMARY KEY (group_id) +); + +/* -------------------------------------------------------- + Table structure for table phpbb_banlist +-------------------------------------------------------- */ +CREATE TABLE phpbb_banlist ( + ban_id number(4) NOT NULL, + ban_userid number(4), + ban_ip char(8), + ban_email varchar(255), + CONSTRAINT phpbb_banlist_pkey PRIMARY KEY (ban_id) +); +CREATE INDEX ban_userid_phpbb_banlist_index ON phpbb_banlist (ban_userid); + + +/* -------------------------------------------------------- + Table structure for table phpbb_categories +-------------------------------------------------------- */ +CREATE TABLE phpbb_categories ( + cat_id number(4) NOT NULL, + cat_title varchar(100), + cat_order number(4), + CONSTRAINT phpbb_categories_pkey PRIMARY KEY (cat_id) +); + + +/* -------------------------------------------------------- + Table structure for table phpbb_config +-------------------------------------------------------- */ +CREATE TABLE phpbb_config ( + config_name varchar(255) NOT NULL, + config_value varchar(255) NOT NULL, + CONSTRAINT phpbb_config_pkey PRIMARY KEY (config_name) +); + + +/* -------------------------------------------------------- + Table structure for table phpbb_disallow +-------------------------------------------------------- */ +CREATE TABLE phpbb_disallow ( + disallow_id number(4) NOT NULL, + disallow_username varchar(25), + CONSTRAINT phpbb_disallow_pkey PRIMARY KEY (disallow_id) +); + + +/* -------------------------------------------------------- + Table structure for table phpbb_forums +-------------------------------------------------------- */ +CREATE TABLE phpbb_forums ( + forum_id number(4) NOT NULL, + cat_id number(4), + forum_name varchar(150), + forum_desc varchar(2000), + forum_status number(4) DEFAULT '0' NOT NULL, + forum_order number(4) DEFAULT '1' NOT NULL, + forum_posts number(4) DEFAULT '0' NOT NULL, + forum_topics number(4) DEFAULT '0' NOT NULL, + forum_last_post_id number(4) DEFAULT '0' NOT NULL, + prune_enable number(4) DEFAULT '1' NOT NULL, + prune_next number(4), + auth_view number(4) DEFAULT '0' NOT NULL, + auth_read number(4) DEFAULT '0' NOT NULL, + auth_post number(4) DEFAULT '0' NOT NULL, + auth_reply number(4) DEFAULT '0' NOT NULL, + auth_edit number(4) DEFAULT '0' NOT NULL, + auth_delete number(4) DEFAULT '0' NOT NULL, + auth_announce number(4) DEFAULT '0' NOT NULL, + auth_sticky number(4) DEFAULT '0' NOT NULL, + auth_pollcreate number(4) DEFAULT '0' NOT NULL, + auth_vote number(4) DEFAULT '0' NOT NULL, + auth_attachments number(4) DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_forums_pkey PRIMARY KEY (forum_id) +); +CREATE INDEX cat_id_phpbb_forums_index ON phpbb_forums (cat_id); +CREATE INDEX forums_order_phpbb_forums ON phpbb_forums (forum_order); + + +/* -------------------------------------------------------- + Table structure for table phpbb_forum_prune +-------------------------------------------------------- */ +CREATE TABLE phpbb_forum_prune ( + prune_id number(4) NOT NULL, + forum_id number(4) NOT NULL, + prune_days number(4) NOT NULL, + prune_freq number(4) NOT NULL, + CONSTRAINT phpbb_forum_prune_pkey PRIMARY KEY (prune_id) +); +CREATE INDEX forum_id_phpbb_forum_prune ON phpbb_forum_prune (forum_id); + + +/* -------------------------------------------------------- + Table structure for table phpbb_posts +-------------------------------------------------------- */ +CREATE TABLE phpbb_posts ( + post_id number(4) NOT NULL, + topic_id number(4) DEFAULT '0' NOT NULL, + forum_id number(4) DEFAULT '0' NOT NULL, + poster_id number(4) DEFAULT '0' NOT NULL, + post_time number(11) DEFAULT '0' NOT NULL, + post_username varchar(30), + poster_ip char(8) DEFAULT '' NOT NULL, + enable_bbcode number(4) DEFAULT '1' NOT NULL, + enable_html number(4) DEFAULT '0' NOT NULL, + enable_smilies number(4) DEFAULT '1' NOT NULL, + enable_sig number(4) DEFAULT '1' NOT NULL, + bbcode_uid varchar(10) DEFAULT '', + post_edit_time number(11), + post_edit_count number(4) DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id) +); +CREATE INDEX forum_id_phpbb_posts_index ON phpbb_posts (forum_id); +CREATE INDEX post_time_phpbb_posts_index ON phpbb_posts (post_time); +CREATE INDEX poster_id_phpbb_posts_index ON phpbb_posts (poster_id); +CREATE INDEX topic_id_phpbb_posts_index ON phpbb_posts (topic_id); + + +/* -------------------------------------------------------- + Table structure for table phpbb_posts_text +-------------------------------------------------------- */ +CREATE TABLE phpbb_posts_text ( + post_id number(4) DEFAULT '0' NOT NULL, + post_subject varchar(255), + post_text varchar(2000), + CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id) +); + + +/* -------------------------------------------------------- + Table structure for table phpbb_privmsgs +-------------------------------------------------------- */ +CREATE TABLE phpbb_privmsgs ( + privmsgs_id number(4) NOT NULL, + privmsgs_type number(4) DEFAULT '0' NOT NULL, + privmsgs_subject varchar(255) DEFAULT '0' NOT NULL, + privmsgs_from_userid number(4) DEFAULT '0' NOT NULL, + privmsgs_to_userid number(4) DEFAULT '0' NOT NULL, + privmsgs_date number(4) DEFAULT '0' NOT NULL, + privmsgs_ip char(8) NOT NULL, + privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id) +); +CREATE INDEX privmsgs_from_userid_index ON phpbb_privmsgs (privmsgs_from_userid); +CREATE INDEX privmsgs_to_userid_index ON phpbb_privmsgs (privmsgs_to_userid); + + +/* -------------------------------------------------------- + Table structure for table phpbb_privmsgs_text +-------------------------------------------------------- */ +CREATE TABLE phpbb_privmsgs_text ( + privmsgs_text_id number(4) DEFAULT '0' NOT NULL, + privmsgs_text varchar(2000), + CONSTRAINT phpbb_privmsgs_text_pkey PRIMARY KEY (privmsgs_text_id) +); + + +/* -------------------------------------------------------- + Table structure for table phpbb_ranks +-------------------------------------------------------- */ +CREATE TABLE phpbb_ranks ( + rank_id number(4) NOT NULL, + rank_title varchar(50) DEFAULT '' NOT NULL, + rank_min number(4) DEFAULT '0' NOT NULL, + rank_max number(4) DEFAULT '0' NOT NULL, + rank_special number(4) DEFAULT '0', + rank_image varchar(255), + CONSTRAINT phpbb_ranks_pkey PRIMARY KEY (rank_id) +); +CREATE INDEX rank_max_phpbb_ranks_index ON phpbb_ranks (rank_max); +CREATE INDEX rank_min_phpbb_ranks_index ON phpbb_ranks (rank_min); + + +/* -------------------------------------------------------- + Table structure for table phpbb_session +-------------------------------------------------------- */ +CREATE TABLE phpbb_sessions ( + session_id char(32) DEFAULT '0' NOT NULL, + session_user_id number(11) DEFAULT '0' NOT NULL, + session_start number(11) DEFAULT '0' NOT NULL, + session_time number(11) DEFAULT '0' NOT NULL, + session_last_visit number(11) DEFAULT '0' NOT NULL, + session_ip char(8) DEFAULT '0' NOT NULL, + session_page number(11) DEFAULT '0' NOT NULL, + session_logged_in number(11) DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_sessions_pkey PRIMARY KEY (session_id) +); +CREATE INDEX session_id_ip_user_id ON phpbb_sessions (session_id, session_ip, session_user_id); + + +/* -------------------------------------------------------- + Table structure for table phpbb_smilies +-------------------------------------------------------- */ +CREATE TABLE phpbb_smilies ( + smilies_id number(4) NOT NULL, + code varchar(50), + smile_url varchar(100), + emoticon varchar(75), + CONSTRAINT phpbb_smilies_pkey PRIMARY KEY (smilies_id) +); + + +/* -------------------------------------------------------- + Table structure for table phpbb_themes +-------------------------------------------------------- */ +CREATE TABLE phpbb_themes ( + themes_id number(4) NOT NULL, + themes_name varchar(30), + template_name varchar(30) DEFAULT '' NOT NULL, + head_stylesheet varchar(100), + body_background varchar(100), + body_bgcolor char(6), + body_text char(6), + body_link char(6), + body_vlink char(6), + body_alink char(6), + body_hlink char(6), + tr_color1 char(6), + tr_color2 char(6), + tr_color3 char(6), + tr_class1 varchar(25), + tr_class2 varchar(25), + tr_class3 varchar(25), + th_color1 char(6), + th_color2 char(6), + th_color3 char(6), + th_class1 varchar(25), + th_class2 varchar(25), + th_class3 varchar(25), + td_color1 char(6), + td_color2 char(6), + td_color3 char(6), + td_class1 varchar(25), + td_class2 varchar(25), + td_class3 varchar(25), + fontface1 varchar(25), + fontface2 varchar(25), + fontface3 varchar(25), + fontsize1 number(4), + fontsize2 number(4), + fontsize3 number(4), + fontcolor1 char(6), + fontcolor2 char(6), + fontcolor3 char(6), + span_class1 varchar(25), + span_class2 varchar(25), + span_class3 varchar(25), + CONSTRAINT phpbb_themes_pkey PRIMARY KEY (themes_id) +); +CREATE INDEX themes_name_phpbb_themes_index ON phpbb_themes (themes_name); + + +/* -------------------------------------------------------- + Table structure for table phpbb_themes_name +-------------------------------------------------------- */ +CREATE TABLE phpbb_themes_name ( + themes_id number(4) DEFAULT '0' NOT NULL, + tr_color1_name varchar(50), + tr_color2_name varchar(50), + tr_color3_name varchar(50), + tr_class1_name varchar(50), + tr_class2_name varchar(50), + tr_class3_name varchar(50), + th_color1_name varchar(50), + th_color2_name varchar(50), + th_color3_name varchar(50), + th_class1_name varchar(50), + th_class2_name varchar(50), + th_class3_name varchar(50), + td_color1_name varchar(50), + td_color2_name varchar(50), + td_color3_name varchar(50), + td_class1_name varchar(50), + td_class2_name varchar(50), + td_class3_name varchar(50), + fontface1_name varchar(50), + fontface2_name varchar(50), + fontface3_name varchar(50), + fontsize1_name varchar(50), + fontsize2_name varchar(50), + fontsize3_name varchar(50), + fontcolor1_name varchar(50), + fontcolor2_name varchar(50), + fontcolor3_name varchar(50), + span_class1_name varchar(50), + span_class2_name varchar(50), + span_class3_name varchar(50), + CONSTRAINT phpbb_themes_name_pkey PRIMARY KEY (themes_id) +); + + +/* -------------------------------------------------------- + Table structure for table phpbb_topics +-------------------------------------------------------- */ +CREATE TABLE phpbb_topics ( + topic_id number(4) NOT NULL, + topic_title varchar(100) DEFAULT '' NOT NULL, + topic_poster number(4) DEFAULT '0' NOT NULL, + topic_time number(11) DEFAULT '0' NOT NULL, + topic_views number(4) DEFAULT '0' NOT NULL, + topic_replies number(4) DEFAULT '0' NOT NULL, + forum_id number(4) DEFAULT '0' NOT NULL, + topic_status number(4) DEFAULT '0' NOT NULL, + topic_vote number(4) DEFAULT '0' NOT NULL, + topic_type number(4) DEFAULT '0' NOT NULL, + topic_moved_id number(4), + topic_last_post_id number(4) DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_topics_pkey PRIMARY KEY (topic_id) +); +CREATE INDEX phpbb_topics_index ON phpbb_topics (forum_id, topic_id); +CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id); + +/* -------------------------------------------------------- + Table structure for table phpbb_topics_watch +-------------------------------------------------------- */ +CREATE TABLE phpbb_topics_watch ( + topic_id number(4), + user_id number(4), + notify_status number(4) DEFAULT '0' NOT NULL +); +CREATE INDEX phpbb_topics_watch_index ON phpbb_topics_watch (topic_id, user_id); + + +/* -------------------------------------------------------- + Table structure for table phpbb_user_group +-------------------------------------------------------- */ +CREATE TABLE phpbb_user_group ( + group_id number(4) DEFAULT '0' NOT NULL, + user_id number(4) DEFAULT '0' NOT NULL, + user_pending number(4) +); +CREATE INDEX group_id_phpbb_user_group ON phpbb_user_group (group_id); +CREATE INDEX user_id_phpbb_user_group_index ON phpbb_user_group (user_id); + + +/* -------------------------------------------------------- + Table structure for table phpbb_users +-------------------------------------------------------- */ +CREATE TABLE phpbb_users ( + user_id number(4) NOT NULL, + user_active number(4), + username varchar(25) DEFAULT '' NOT NULL, + user_regdate number(11) DEFAULT '0' NOT NULL, + user_password varchar(32) DEFAULT '' NOT NULL, + user_autologin_key varchar(32), + user_email varchar(255), + user_icq varchar(15), + user_website varchar(100), + user_occ varchar(100), + user_from varchar(100), + user_interests varchar(255), + user_sig varchar(255), + user_theme number(4), + user_aim varchar(255), + user_yim varchar(255), + user_msnm varchar(255), + user_posts number(4) DEFAULT '0' NOT NULL, + user_viewemail number(4), + user_attachsig number(4), + user_allowhtml number(4), + user_allowbbcode number(4), + user_allowsmile number(4), + user_allow_pm number(4) DEFAULT '1' NOT NULL, + user_allowavatar number(4) DEFAULT '1' NOT NULL, + user_allow_viewonline number(4) DEFAULT '1' NOT NULL, + user_rank number(4) DEFAULT '0', + user_avatar varchar(100), + user_level number(4) DEFAULT '1', + user_lang varchar(255), + user_template varchar(50), + user_timezone number(4) DEFAULT '0' NOT NULL, + user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL, + user_notify_pm number(4) DEFAULT '1' NOT NULL, + user_notify number(4), + user_actkey varchar(32), + user_newpasswd varchar(32), + CONSTRAINT phpbb_users_pkey PRIMARY KEY (user_id) +); + +/* -------------------------------------------------------- + Table structure for table phpbb_vote_desc +-------------------------------------------------------- */ +CREATE TABLE phpbb_vote_desc ( + vote_id number(4) NOT NULL, + topic_id number(4) DEFAULT '0' NOT NULL, + vote_text varchar2(4000) NOT NULL, + vote_start number(4) DEFAULT '0' NOT NULL, + vote_length number(4) DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_vote_dsc_pkey PRIMARY KEY (vote_id) +); +CREATE INDEX topic_id_phpbb_vote_desc_index ON phpbb_vote_desc (topic_id); + +/* -------------------------------------------------------- + Table structure for table phpbb_vote_results +-------------------------------------------------------- */ +CREATE TABLE phpbb_vote_results ( + vote_id number(4) DEFAULT '0' NOT NULL, + vote_option_id number(4) DEFAULT '0' NOT NULL, + vote_option_text varchar(255) NOT NULL, + vote_result number(4) DEFAULT '0' NOT NULL +); +CREATE INDEX option_id_vote_results_index ON phpbb_vote_results (vote_option_id); + +/* -------------------------------------------------------- + Table structure for table phpbb_vote_voters +-------------------------------------------------------- */ +CREATE TABLE phpbb_vote_voters ( + vote_id number(4) DEFAULT '0' NOT NULL, + vote_user_id number(4) DEFAULT '0' NOT NULL, + vote_user_ip char(8) NOT NULL +); +CREATE INDEX vote_id_vote_voters_index ON phpbb_vote_voters (vote_id); +CREATE INDEX vote_user_id_vote_voters_index ON phpbb_vote_voters (vote_user_id); +CREATE INDEX vote_user_ip_vote_voters_index ON phpbb_vote_voters (vote_user_ip); + +/* -------------------------------------------------------- + Table structure for table phpbb_words +-------------------------------------------------------- */ +CREATE TABLE phpbb_words ( + word_id number(4) NOT NULL, + word varchar(100) DEFAULT '' NOT NULL, + replacement varchar(100) DEFAULT '' NOT NULL, + CONSTRAINT phpbb_words_pkey PRIMARY KEY (word_id) +); -- cgit v1.2.1