sourceforge2.5_oci8.sql

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

--

CREATE TABLE frs_dlstats_agg (
	file_id number(*) DEFAULT '0' NOT NULL,
	day number(*) DEFAULT '0' NOT NULL,
	downloads_http number(*) DEFAULT '0' NOT NULL,
	downloads_ftp number(*) DEFAULT '0' NOT NULL
);

--
-- TOC Entry ID 208 (OID 18139623)
--
-- Name: frs_dlstats_file_agg Type: TABLE Owner: tperdue
--

CREATE TABLE frs_dlstats_file_agg (
	file_id number(*) DEFAULT '0' NOT NULL,
	day number(*) DEFAULT '0' NOT NULL,
	downloads number(*) DEFAULT '0' NOT NULL
);

--
-- TOC Entry ID 209 (OID 18139638)
--
-- Name: frs_dlstats_filetotal_agg Type: TABLE Owner: tperdue
--

CREATE TABLE frs_dlstats_filetotal_agg (
	file_id number(*) DEFAULT '0' NOT NULL,
	downloads number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (file_id)
);

--
-- TOC Entry ID 210 (OID 18139654)
--
-- Name: frs_dlstats_filetotal_agg_old Type: TABLE Owner: tperdue
--

CREATE TABLE frs_dlstats_filetotal_agg_old (
	file_id number(*) DEFAULT '0' NOT NULL,
	downloads number(*) DEFAULT '0' NOT NULL
);

--
-- TOC Entry ID 211 (OID 18139667)
--
-- Name: frs_dlstats_group_agg Type: TABLE Owner: tperdue
--

CREATE TABLE frs_dlstats_group_agg (
	group_id number(*) DEFAULT '0' NOT NULL,
	day number(*) DEFAULT '0' NOT NULL,
	downloads number(*) DEFAULT '0' NOT NULL
);

--
-- TOC Entry ID 212 (OID 18139682)
--
-- Name: frs_dlstats_grouptotal_agg Type: TABLE Owner: tperdue
--

CREATE TABLE frs_dlstats_grouptotal_agg (
	group_id number(*) DEFAULT '0' NOT NULL,
	downloads number(*) DEFAULT '0' NOT NULL
);

--
-- TOC Entry ID 48 (OID 18139695)
--
-- Name: frs_file_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE frs_file_pk_seq START WITH 1;

--
-- TOC Entry ID 213 (OID 18139714)
--
-- Name: frs_file Type: TABLE Owner: tperdue
--

CREATE TABLE frs_file (
	file_id number(*) NOT NULL,
	filename varchar2(200),
	release_id number(*) DEFAULT '0' NOT NULL,
	type_id number(*) DEFAULT '0' NOT NULL,
	processor_id number(*) DEFAULT '0' NOT NULL,
	release_time number(*) DEFAULT '0' NOT NULL,
	file_size number(*) DEFAULT '0' NOT NULL,
	post_date number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (file_id)
);

--
-- TOC Entry ID 50 (OID 18139756)
--
-- Name: frs_filetype_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE frs_filetype_pk_seq START WITH 1;

--
-- TOC Entry ID 214 (OID 18139774)
--
-- Name: frs_filetype Type: TABLE Owner: tperdue
--

CREATE TABLE frs_filetype (
	type_id number(*) NOT NULL,
	name varchar2(4000),
	PRIMARY KEY (type_id)
);

--
-- TOC Entry ID 52 (OID 18139804)
--
-- Name: frs_package_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE frs_package_pk_seq START WITH 1;

--
-- TOC Entry ID 215 (OID 18139822)
--
-- Name: frs_package Type: TABLE Owner: tperdue
--

CREATE TABLE frs_package (
	package_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	name varchar2(4000),
	status_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (package_id)
);

--
-- TOC Entry ID 54 (OID 18139856)
--
-- Name: frs_processor_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE frs_processor_pk_seq START WITH 1;

--
-- TOC Entry ID 216 (OID 18139874)
--
-- Name: frs_processor Type: TABLE Owner: tperdue
--

CREATE TABLE frs_processor (
	processor_id number(*) NOT NULL,
	name varchar2(4000),
	PRIMARY KEY (processor_id)
);

--
-- TOC Entry ID 56 (OID 18139904)
--
-- Name: frs_release_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE frs_release_pk_seq START WITH 1;

--
-- TOC Entry ID 217 (OID 18139922)
--
-- Name: frs_release Type: TABLE Owner: tperdue
--

CREATE TABLE frs_release (
	release_id number(*) NOT NULL,
	package_id number(*) DEFAULT '0' NOT NULL,
	name varchar2(4000),
	notes varchar2(4000),
	changes varchar2(4000),
	status_id number(*) DEFAULT '0' NOT NULL,
	preformatted number(*) DEFAULT '0' NOT NULL,
	release_date number(*) DEFAULT '0' NOT NULL,
	released_by number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (release_id)
);

--
-- TOC Entry ID 58 (OID 18139964)
--
-- Name: frs_status_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE frs_status_pk_seq START WITH 1;

--
-- TOC Entry ID 218 (OID 18139982)
--
-- Name: frs_status Type: TABLE Owner: tperdue
--

CREATE TABLE frs_status (
	status_id number(*) NOT NULL,
	name varchar2(4000),
	PRIMARY KEY (status_id)
);

--
-- TOC Entry ID 60 (OID 18140012)
--
-- Name: group_cvs_history_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE group_cvs_history_pk_seq START WITH 1;

--
-- TOC Entry ID 219 (OID 18140030)
--
-- Name: group_cvs_history Type: TABLE Owner: tperdue
--

CREATE TABLE group_cvs_history (
	id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	user_name character varying(80) DEFAULT ' ' NOT NULL,
	cvs_commits number(*) DEFAULT '0' NOT NULL,
	cvs_commits_wk number(*) DEFAULT '0' NOT NULL,
	cvs_adds number(*) DEFAULT '0' NOT NULL,
	cvs_adds_wk number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (id)
);

--
-- TOC Entry ID 62 (OID 18140056)
--
-- Name: group_history_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE group_history_pk_seq START WITH 1;

--
-- TOC Entry ID 220 (OID 18140074)
--
-- Name: group_history Type: TABLE Owner: tperdue
--

CREATE TABLE group_history (
	group_history_id number(*) NOT NULL,
	group_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 (group_history_id)
);

--
-- TOC Entry ID 64 (OID 18140112)
--
-- Name: group_type_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE group_type_pk_seq START WITH 1;

--
-- TOC Entry ID 221 (OID 18140130)
--
-- Name: group_type Type: TABLE Owner: tperdue
--

CREATE TABLE group_type (
	type_id number(*) NOT NULL,
	name varchar2(4000),
	PRIMARY KEY (type_id)
);

--
-- TOC Entry ID 66 (OID 18140160)
--
-- Name: groups_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE groups_pk_seq START WITH 1;

--
-- TOC Entry ID 222 (OID 18140178)
--
-- Name: groups Type: TABLE Owner: tperdue
--

CREATE TABLE groups (
	group_id number(*) NOT NULL,
	group_name character varying(40),
	homepage character varying(128),
	is_public number(*) DEFAULT '0' NOT NULL,
	status character(1) DEFAULT 'A' NOT NULL,
	unix_group_name character varying(30) DEFAULT ' ' NOT NULL,
	unix_box character varying(20) DEFAULT 'shell1' NOT NULL,
	http_domain character varying(80),
	short_description character varying(255),
	cvs_box character varying(20) DEFAULT 'cvs1' NOT NULL,
	license character varying(16),
	register_purpose varchar2(4000),
	license_other varchar2(4000),
	register_time number(*) DEFAULT '0' NOT NULL,
	use_bugs number(*) DEFAULT '1' NOT NULL,
	rand_hash varchar2(4000),
	use_mail number(*) DEFAULT '1' NOT NULL,
	use_survey number(*) DEFAULT '1' NOT NULL,
	use_patch number(*) DEFAULT '1' NOT NULL,
	use_forum number(*) DEFAULT '1' NOT NULL,
	use_pm number(*) DEFAULT '1' NOT NULL,
	use_cvs number(*) DEFAULT '1' NOT NULL,
	use_news number(*) DEFAULT '1' NOT NULL,
	use_support number(*) DEFAULT '1' NOT NULL,
	new_bug_address varchar2(4000) DEFAULT ' ' NOT NULL,
	new_patch_address varchar2(4000) DEFAULT ' ' NOT NULL,
	new_support_address varchar2(4000) DEFAULT ' ' NOT NULL,
	type number(*) DEFAULT '1' NOT NULL,
	use_docman number(*) DEFAULT '1' NOT NULL,
	send_all_bugs number(*) DEFAULT '0' NOT NULL,
	send_all_patches number(*) DEFAULT '0' NOT NULL,
	send_all_support number(*) DEFAULT '0' NOT NULL,
	new_task_address varchar2(4000) DEFAULT ' ' NOT NULL,
	send_all_tasks number(*) DEFAULT '0' NOT NULL,
	use_bug_depend_box number(*) DEFAULT '1' NOT NULL,
	use_pm_depend_box number(*) DEFAULT '1' NOT NULL,
	PRIMARY KEY (group_id)
);

--
-- TOC Entry ID 223 (OID 18140269)
--
-- Name: intel_agreement Type: TABLE Owner: tperdue
--

CREATE TABLE intel_agreement (
	user_id number(*) DEFAULT '0' NOT NULL,
	message varchar2(4000),
	is_approved number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (user_id)
);

--
-- TOC Entry ID 68 (OID 18140301)
--
-- Name: mail_group_list_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE mail_group_list_pk_seq START WITH 1;

--
-- TOC Entry ID 224 (OID 18140319)
--
-- Name: mail_group_list Type: TABLE Owner: tperdue
--

CREATE TABLE mail_group_list (
	group_list_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	list_name varchar2(4000),
	is_public number(*) DEFAULT '0' NOT NULL,
	password character varying(16),
	list_admin number(*) DEFAULT '0' NOT NULL,
	status number(*) DEFAULT '0' NOT NULL,
	description varchar2(4000),
	PRIMARY KEY (group_list_id)
);

--
-- TOC Entry ID 70 (OID 18140359)
--
-- Name: news_bytes_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE news_bytes_pk_seq START WITH 1;

--
-- TOC Entry ID 225 (OID 18140377)
--
-- Name: news_bytes Type: TABLE Owner: tperdue
--

CREATE TABLE news_bytes (
	id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	submitted_by number(*) DEFAULT '0' NOT NULL,
	is_approved number(*) DEFAULT '0' NOT NULL,
	date1 number(*) DEFAULT '0' NOT NULL,
	forum_id number(*) DEFAULT '0' NOT NULL,
	summary varchar2(4000),
	details varchar2(4000),
	PRIMARY KEY (id)
);

--
-- TOC Entry ID 72 (OID 18140419)
--
-- Name: patch_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE patch_pk_seq START WITH 1;

--
-- TOC Entry ID 226 (OID 18140437)
--
-- Name: patch Type: TABLE Owner: tperdue
--

CREATE TABLE patch (
	patch_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	patch_status_id number(*) DEFAULT '0' NOT NULL,
	patch_category_id number(*) DEFAULT '0' NOT NULL,
	submitted_by number(*) DEFAULT '0' NOT NULL,
	assigned_to number(*) DEFAULT '0' NOT NULL,
	open_date number(*) DEFAULT '0' NOT NULL,
	summary varchar2(4000),
	code varchar2(4000),
	close_date number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (patch_id)
);

--
-- TOC Entry ID 74 (OID 18140483)
--
-- Name: patch_category_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE patch_category_pk_seq START WITH 1;

--
-- TOC Entry ID 227 (OID 18140501)
--
-- Name: patch_category Type: TABLE Owner: tperdue
--

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

--
-- TOC Entry ID 76 (OID 18140534)
--
-- Name: patch_history_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE patch_history_pk_seq START WITH 1;

--
-- TOC Entry ID 228 (OID 18140552)
--
-- Name: patch_history Type: TABLE Owner: tperdue
--

CREATE TABLE patch_history (
	patch_history_id number(*) NOT NULL,
	patch_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 (patch_history_id)
);

--
-- TOC Entry ID 78 (OID 18140590)
--
-- Name: patch_status_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE patch_status_pk_seq START WITH 1;

--
-- TOC Entry ID 229 (OID 18140608)
--
-- Name: patch_status Type: TABLE Owner: tperdue
--

CREATE TABLE patch_status (
	patch_status_id number(*) NOT NULL,
	status_name varchar2(4000),
	PRIMARY KEY (patch_status_id)
);

--
-- TOC Entry ID 80 (OID 18140638)
--
-- Name: people_job_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE people_job_pk_seq START WITH 1;

--
-- TOC Entry ID 230 (OID 18140656)
--
-- Name: people_job Type: TABLE Owner: tperdue
--

CREATE TABLE people_job (
	job_id number(*) NOT NULL,
	group_id number(*) DEFAULT '0' NOT NULL,
	created_by number(*) DEFAULT '0' NOT NULL,
	title varchar2(4000),
	description varchar2(4000),
	date1 number(*) DEFAULT '0' NOT NULL,
	status_id number(*) DEFAULT '0' NOT NULL,
	category_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (job_id)
);

--
-- TOC Entry ID 82 (OID 18140697)
--
-- Name: people_job_category_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE people_job_category_pk_seq START WITH 1;

--
-- TOC Entry ID 231 (OID 18140715)
--
-- Name: people_job_category Type: TABLE Owner: tperdue
--

CREATE TABLE people_job_category (
	category_id number(*) NOT NULL,
	name varchar2(4000),
	private_flag number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (category_id)
);

--
-- TOC Entry ID 84 (OID 18140747)
--
-- Name: people_job_inventory_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE people_job_inventory_pk_seq START WITH 1;

--
-- TOC Entry ID 232 (OID 18140765)
--
-- Name: people_job_inventory Type: TABLE Owner: tperdue
--

CREATE TABLE people_job_inventory (
	job_inventory_id number(*) NOT NULL,
	job_id number(*) DEFAULT '0' NOT NULL,
	skill_id number(*) DEFAULT '0' NOT NULL,
	skill_level_id number(*) DEFAULT '0' NOT NULL,
	skill_year_id number(*) DEFAULT '0' NOT NULL,
	PRIMARY KEY (job_inventory_id)
);

--
-- TOC Entry ID 86 (OID 18140787)
--
-- Name: people_job_status_pk_seq Type: SEQUENCE Owner: tperdue
--

CREATE SEQUENCE people_job_status_pk_seq START WITH 1;

--