sourceforge2.5_oci8.sql

来自「GForge 3.0 协作开发平台 支持CVS, mailing lists, 」· SQL 代码 · 共 2,809 行 · 第 1/5 页

--
-- Selected TOC Entries:
--
--\connect - tperdue
--
-- TOC Entry ID 2 (OID 18138427)
--
-- Name: bug_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_pk_seq START WITH 1;

--
-- TOC Entry ID 182 (OID 18138445)
--
-- Name: bug Type: TABLE Owner: tperdue
--

CREATE TABLE bug (
	bug_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	status_id number(*) DEFAULT '0' NOT NULL,
	priority number(*) DEFAULT '0' NOT NULL,
	category_id number(*) DEFAULT '0' NOT NULL,
	submitted_by number(*) DEFAULT '0' NOT NULL,
	assigned_to number(*) DEFAULT '0' NOT NULL,
	date1 number(*) DEFAULT '0' NOT NULL,
	summary varchar2(4000),
	details varchar2(4000),
	close_date number(*),
	bug_group_id number(*) DEFAULT '0' NOT NULL,
	resolution_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (bug_id)
);

--
-- TOC Entry ID 4 (OID 18138495)
--
-- Name: bug_bug_dependencies_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_bug_dependencies_pk_seq START WITH 1;

--
-- TOC Entry ID 183 (OID 18138513)
--
-- Name: bug_bug_dependencies Type: TABLE Owner: tperdue
--

CREATE TABLE bug_bug_dependencies (
	bug_depend_id number(*) NOT NULL,
	bug_id number(*) DEFAULT '0' NOT NULL,
	is_dependent_on_bug_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (bug_depend_id)
);

--
-- TOC Entry ID 6 (OID 18138531)
--
-- Name: bug_canned_responses_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_canned_responses_pk_seq START WITH 1;

--
-- TOC Entry ID 184 (OID 18138549)
--
-- Name: bug_canned_responses Type: TABLE Owner: tperdue
--

CREATE TABLE bug_canned_responses (
	bug_canned_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	title varchar2(4000),
	body varchar2(4000),
	PRIMARY KEY (bug_canned_id)
);

--
-- TOC Entry ID 8 (OID 18138582)
--
-- Name: bug_category_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_category_pk_seq START WITH 1;

--
-- TOC Entry ID 185 (OID 18138600)
--
-- Name: bug_category Type: TABLE Owner: tperdue
--

CREATE TABLE bug_category (
	bug_category_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	category_name varchar2(4000),
	PRIMARY KEY (bug_category_id)
);

--
-- TOC Entry ID 10 (OID 18138632)
--
-- Name: bug_filter_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_filter_pk_seq START WITH 1;

--
-- TOC Entry ID 186 (OID 18138650)
--
-- Name: bug_filter Type: TABLE Owner: tperdue
--

CREATE TABLE bug_filter (
	filter_id number(*) NOT NULL,
	user_id number(*) DEFAULT '0' NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	sql_clause varchar2(4000) DEFAULT ' ' NOT NULL,
	is_active number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (filter_id)
);

--
-- TOC Entry ID 12 (OID 18138687)
--
-- Name: bug_group_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_group_pk_seq START WITH 1;

--
-- TOC Entry ID 187 (OID 18138705)
--
-- Name: bug_group Type: TABLE Owner: tperdue
--

CREATE TABLE bug_group (
	bug_group_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	group_name varchar2(4000) DEFAULT ' ' NOT NULL,
	PRIMARY KEY (bug_group_id)
);

--
-- TOC Entry ID 14 (OID 18138738)
--
-- Name: bug_history_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_history_pk_seq START WITH 1;

--
-- TOC Entry ID 188 (OID 18138756)
--
-- Name: bug_history Type: TABLE Owner: tperdue
--

CREATE TABLE bug_history (
	bug_history_id number(*) NOT NULL,
	bug_id number(*) DEFAULT '0' NOT NULL,
	field_name varchar2(4000) DEFAULT ' ' NOT NULL,
	old_value varchar2(4000) DEFAULT ' ' NOT NULL,
	mod_by number(*) DEFAULT '0' NOT NULL,
	date1 number(*),
	PRIMARY KEY (bug_history_id)
);

--
-- TOC Entry ID 16 (OID 18138794)
--
-- Name: bug_resolution_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_resolution_pk_seq START WITH 1;

--
-- TOC Entry ID 189 (OID 18138812)
--
-- Name: bug_resolution Type: TABLE Owner: tperdue
--

CREATE TABLE bug_resolution (
	resolution_id number(*) NOT NULL,
	resolution_name varchar2(4000) DEFAULT ' ' NOT NULL,
	PRIMARY KEY (resolution_id)
);

--
-- TOC Entry ID 18 (OID 18138843)
--
-- Name: bug_status_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_status_pk_seq START WITH 1;

--
-- TOC Entry ID 190 (OID 18138861)
--
-- Name: bug_status Type: TABLE Owner: tperdue
--

CREATE TABLE bug_status (
	status_id number(*) NOT NULL,
	status_name varchar2(4000),
	PRIMARY KEY (status_id)
);

--
-- TOC Entry ID 20 (OID 18138891)
--
-- Name: bug_task_dependencies_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE bug_task_dependencies_pk_seq START WITH 1;

--
-- TOC Entry ID 191 (OID 18138909)
--
-- Name: bug_task_dependencies Type: TABLE Owner: tperdue
--

CREATE TABLE bug_task_dependencies (
	bug_depend_id number(*) NOT NULL,
	bug_id number(*) DEFAULT '0' NOT NULL,
	is_dependent_on_task_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (bug_depend_id)
);

--
-- TOC Entry ID 22 (OID 18138927)
--
-- Name: canned_responses_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE canned_responses_pk_seq START WITH 1;

--
-- TOC Entry ID 192 (OID 18138946)
--
-- Name: canned_responses Type: TABLE Owner: tperdue
--

CREATE TABLE canned_responses (
	response_id number(*) NOT NULL,
	response_title character varying(25),
	response_text varchar2(4000),
	PRIMARY KEY (response_id)
);

--
-- TOC Entry ID 24 (OID 18138977)
--
-- Name: db_images_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE db_images_pk_seq START WITH 1;

--
-- TOC Entry ID 193 (OID 18138995)
--
-- Name: db_images Type: TABLE Owner: tperdue
--

CREATE TABLE db_images (
	id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	description varchar2(4000) DEFAULT ' ' NOT NULL,
	bin_data varchar2(4000) DEFAULT ' ' NOT NULL,
	filename varchar2(4000) DEFAULT ' ' NOT NULL,
	filesize number(*) DEFAULT '0' NOT NULL,
	filetype varchar2(4000) DEFAULT ' ' NOT NULL,
	width number(*) DEFAULT '0' NOT NULL,
	height number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (id)
);

--
-- TOC Entry ID 26 (OID 18139040)
--
-- Name: doc_data_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE doc_data_pk_seq START WITH 1;

--
-- TOC Entry ID 194 (OID 18139058)
--
-- Name: doc_data Type: TABLE Owner: tperdue
--

CREATE TABLE doc_data (
	docid number(*) NOT NULL,
	stateid number(*) DEFAULT '0' NOT NULL,
	title character varying(255) DEFAULT ' ' NOT NULL,
	data varchar2(4000) DEFAULT ' ' NOT NULL,
	updatedate1 number(*) DEFAULT '0' NOT NULL,
	createdate1 number(*) DEFAULT '0' NOT NULL,
	created_by number(*) DEFAULT '0' NOT NULL,
	doc_group number(*) DEFAULT '0' NOT NULL,
	description varchar2(4000),
	language_id number(*) DEFAULT '1' NOT NULL,
	PRIMARY KEY (docid)
);

--
-- TOC Entry ID 28 (OID 18139104)
--
-- Name: doc_groups_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE doc_groups_pk_seq START WITH 1;

--
-- TOC Entry ID 195 (OID 18139122)
--
-- Name: doc_groups Type: TABLE Owner: tperdue
--

CREATE TABLE doc_groups (
	doc_group number(*) NOT NULL,
	groupname character varying(255) DEFAULT ' ' NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (doc_group)
);

--
-- TOC Entry ID 30 (OID 18139140)
--
-- Name: doc_states_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE doc_states_pk_seq START WITH 1;

--
-- TOC Entry ID 196 (OID 18139158)
--
-- Name: doc_states Type: TABLE Owner: tperdue
--

CREATE TABLE doc_states (
	stateid number(*) NOT NULL,
	name character varying(255) DEFAULT ' ' NOT NULL,
	PRIMARY KEY (stateid)
);

--
-- TOC Entry ID 32 (OID 18139174)
--
-- Name: filemodule_monitor_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE filemodule_monitor_pk_seq START WITH 1;

--
-- TOC Entry ID 197 (OID 18139192)
--
-- Name: filemodule_monitor Type: TABLE Owner: tperdue
--

CREATE TABLE filemodule_monitor (
	id number(*) NOT NULL,
	filemodule_id number(*) DEFAULT '0' NOT NULL,
	user_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (id)
);

--
-- TOC Entry ID 34 (OID 18139210)
--
-- Name: forum_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE forum_pk_seq START WITH 1;

--
-- TOC Entry ID 198 (OID 18139228)
--
-- Name: forum Type: TABLE Owner: tperdue
--

CREATE TABLE forum (
	msg_id number(*) NOT NULL,
	group_forum_id number(*) DEFAULT '0' NOT NULL,
	posted_by number(*) DEFAULT '0' NOT NULL,
	subject varchar2(4000) DEFAULT ' ' NOT NULL,
	body varchar2(4000) DEFAULT ' ' NOT NULL,
	date1 number(*) DEFAULT '0' NOT NULL,
	is_followup_to number(*) DEFAULT '0' NOT NULL,
	thread_id number(*) DEFAULT '0' NOT NULL,
	has_followups number(*) DEFAULT '0',
	most_recent_date number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (msg_id)
);

--
-- TOC Entry ID 199 (OID 18139275)
--
-- Name: forum_agg_msg_count Type: TABLE Owner: tperdue
--

CREATE TABLE forum_agg_msg_count (
	group_forum_id number(*) DEFAULT '0' NOT NULL,
	count number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (group_forum_id)
);

--
-- TOC Entry ID 36 (OID 18139291)
--
-- Name: forum_group_list_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE forum_group_list_pk_seq START WITH 1;

--
-- TOC Entry ID 200 (OID 18139309)
--
-- Name: forum_group_list Type: TABLE Owner: tperdue
--

CREATE TABLE forum_group_list (
	group_forum_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	forum_name varchar2(4000) DEFAULT ' ' NOT NULL,
	is_public number(*) DEFAULT '0' NOT NULL,
	description varchar2(4000),
	allow_anonymous number(*) DEFAULT '0' NOT NULL,
	send_all_posts_to varchar2(4000),
	PRIMARY KEY (group_forum_id)
);

--
-- TOC Entry ID 38 (OID 18139348)
--
-- Name: forum_monitor_forums_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE forum_monitor_forums_pk_seq START WITH 1;

--
-- TOC Entry ID 201 (OID 18139366)
--
-- Name: forum_monitored_forums Type: TABLE Owner: tperdue
--

CREATE TABLE forum_monitored_forums (
	monitor_id number(*) NOT NULL,
	forum_id number(*) DEFAULT '0' NOT NULL,
	user_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (monitor_id)
);

--
-- TOC Entry ID 40 (OID 18139384)
--
-- Name: forum_saved_place_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE forum_saved_place_pk_seq START WITH 1;

--
-- TOC Entry ID 202 (OID 18139402)
--
-- Name: forum_saved_place Type: TABLE Owner: tperdue
--

CREATE TABLE forum_saved_place (
	saved_place_id number(*) NOT NULL,
	user_id number(*) DEFAULT '0' NOT NULL,
	forum_id number(*) DEFAULT '0' NOT NULL,
	save_date number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (saved_place_id)
);

--
-- TOC Entry ID 203 (OID 18139454)
--
-- Name: foundry_data Type: TABLE Owner: tperdue
--

CREATE TABLE foundry_data (
	foundry_id number(*) DEFAULT '0' NOT NULL,
	freeform1_html varchar2(4000),
	freeform2_html varchar2(4000),
	sponsor1_html varchar2(4000),
	sponsor2_html varchar2(4000),
	guide_image_id number(*) DEFAULT '0' NOT NULL,
	logo_image_id number(*) DEFAULT '0' NOT NULL,
	trove_categories varchar2(4000),
	PRIMARY KEY (foundry_id)
);

--
-- TOC Entry ID 42 (OID 18139492)
--
-- Name: foundry_news_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE foundry_news_pk_seq START WITH 1;

--
-- TOC Entry ID 204 (OID 18139510)
--
-- Name: foundry_news Type: TABLE Owner: tperdue
--

CREATE TABLE foundry_news (
	foundry_news_id number(*) NOT NULL,
	foundry_id number(*) DEFAULT '0' NOT NULL,
	news_id number(*) DEFAULT '0' NOT NULL,
	approve_date number(*) DEFAULT '0' NOT NULL,
	is_approved number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (foundry_news_id)
);

--
-- TOC Entry ID 44 (OID 18139532)
--
-- Name: foundry_prefer_proj_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE foundry_prefer_proj_pk_seq START WITH 1;

--
-- TOC Entry ID 205 (OID 18139550)
--
-- Name: foundry_preferred_projects Type: TABLE Owner: tperdue
--

CREATE TABLE foundry_preferred_projects (
	foundry_project_id number(*) NOT NULL,
	foundry_id number(*) DEFAULT '0' NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	rank number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (foundry_project_id)
);

--
-- TOC Entry ID 46 (OID 18139570)
--
-- Name: foundry_projects_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE foundry_projects_pk_seq START WITH 1;

--
-- TOC Entry ID 206 (OID 18139588)
--
-- Name: foundry_projects Type: TABLE Owner: tperdue
--

CREATE TABLE foundry_projects (
	id number(*) NOT NULL,
	foundry_id number(*) DEFAULT '0' NOT NULL,
	project_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (id)
);

--
-- TOC Entry ID 207 (OID 18139606)
--
-- Name: frs_dlstats_agg Type: TABLE Owner: tperdue