sourceforge.sql

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

	sf_date integer DEFAULT '0' NOT NULL,
	is_followup_to integer DEFAULT '0' NOT NULL,
	thread_id integer DEFAULT '0' NOT NULL,
	has_followups integer DEFAULT '0',
	most_recent_date integer DEFAULT '0' NOT NULL,
	PRIMARY KEY (msg_id)
);

--nextval('forum_pk_seq'::text) 
CREATE TRIGGER DEFAULT_FORUM_MSG_ID BEFORE 
    INSERT 
    ON forum REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select forum_pk_seq.nextval into :new.msg_id from dual;
END;
/


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

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

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

CREATE SEQUENCE forum_group_list_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('forum_group_list_pk_seq'::text) 
CREATE TRIGGER DEFAULT_FORUM_GROUP_ID BEFORE 
    INSERT 
    ON forum_group_list REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select forum_group_list_pk_seq.nextval into :new.group_forum_id from dual;
END;
/

--
-- TOC Entry ID 38 (OID 18139348)
--
-- Name: forum_monitored_forums_pk_seq Type: SEQUENCE 
--

CREATE SEQUENCE forum_monitored_forums_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('forum_monitored_forums_pk_seq'::text)
CREATE TRIGGER DEFAULT_FORUM_MON_FORUMS_ID BEFORE 
    INSERT 
    ON forum_monitored_forums REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select forum_monitored_forums_pk_seq.nextval into :new.monitor_id from dual;
END;
/

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

CREATE SEQUENCE forum_saved_place_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('forum_saved_place_pk_seq'::text) 
CREATE TRIGGER DEFAULT_FORUM_SAVED_PLACES_ID BEFORE 
    INSERT 
    ON forum_saved_place REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select forum_saved_place_pk_seq.nextval into :new.saved_place_id from dual;
END;
/

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

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

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

CREATE SEQUENCE foundry_news_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('foundry_news_pk_seq'::text) 
CREATE TRIGGER DEFAULT_FOUNDRY_NEWS_ID BEFORE 
    INSERT 
    ON foundry_news REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select foundry_news_pk_seq.nextval into :new.foundry_news_id from dual;
END;
/

--
-- TOC Entry ID 44 (OID 18139532)
--
-- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE 
--

CREATE SEQUENCE foundry_preferred_proj_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('foundry_preferred_projec_pk_seq'::text) 
CREATE TRIGGER DEFAULT_FOUNDRY_PREF_PROJS_ID BEFORE 
    INSERT 
    ON foundry_preferred_projects REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select foundry_preferred_proj_pk_seq.nextval into :new.foundry_project_id from dual;
END;
/

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

CREATE SEQUENCE foundry_projects_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('foundry_projects_pk_seq'::text) 
CREATE TRIGGER DEFAULT_FOUNDRY_PROJS_ID BEFORE 
    INSERT 
    ON foundry_projects REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select foundry_projects_pk_seq.nextval into :new.id from dual;
END;
/

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE SEQUENCE frs_file_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('frs_file_pk_seq'::text)
CREATE TRIGGER DEFAULT_FRS_FILE_ID BEFORE 
    INSERT 
    ON frs_file REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select frs_file_pk_seq.nextval into :new.file_id from dual;
END;
/

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

CREATE SEQUENCE frs_filetype_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

CREATE TABLE frs_filetype (
	type_id integer DEFAULT '0' NOT NULL,
	name varchar2(255),
	PRIMARY KEY (type_id)
);

--nextval('frs_filetype_pk_seq'::text) 
CREATE TRIGGER DEFAULT_FRS_FILETYPE_ID BEFORE 
    INSERT 
    ON frs_filetype REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select frs_filetype_pk_seq.nextval into :new.type_id from dual;
END;
/

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

CREATE SEQUENCE frs_package_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

CREATE TABLE frs_package (
	package_id integer DEFAULT '0' NOT NULL,
	group_id integer DEFAULT '0' NOT NULL,
	name varchar2(255),
	status_id integer DEFAULT '0' NOT NULL,
	PRIMARY KEY (package_id)
);

--nextval('frs_package_pk_seq'::text)
CREATE TRIGGER DEFAULT_FRS_PACKAGE_ID BEFORE 
    INSERT 
    ON frs_package REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select frs_package_pk_seq.nextval into :new.package_id from dual;
END;
/

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

CREATE SEQUENCE frs_processor_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

CREATE TABLE frs_processor (
	processor_id integer DEFAULT '0' NOT NULL,
	name varchar2(255),
	PRIMARY KEY (processor_id)
);

--nextval('frs_processor_pk_seq'::text) 
CREATE TRIGGER DEFAULT_FRS_PROCESSOR_ID BEFORE 
    INSERT 
    ON frs_processor REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select frs_processor_pk_seq.nextval into :new.processor_id from dual;
END;
/

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

CREATE SEQUENCE frs_release_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('frs_release_pk_seq'::text)
CREATE TRIGGER DEFAULT_FRS_RELEASE_ID BEFORE 
    INSERT 
    ON frs_release REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select frs_release_pk_seq.nextval into :new.release_id from dual;
END;
/

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

CREATE SEQUENCE frs_status_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

CREATE TABLE frs_status (
	status_id integer DEFAULT '0' NULL,
	name varchar2(255),
	PRIMARY KEY (status_id)
);

--nextval('frs_status_pk_seq'::text)
CREATE TRIGGER DEFAULT_FRS_STATUS_ID BEFORE 
    INSERT 
    ON frs_status REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select frs_status_pk_seq.nextval into :new.status_id from dual;
END;
/

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

CREATE SEQUENCE group_cvs_history_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;

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

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

--nextval('group_cvs_history_pk_seq'::text)
CREATE TRIGGER DEFAULT_GROUP_CVS_HISTORY_ID BEFORE 
    INSERT 
    ON group_cvs_history REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select group_cvs_history_pk_seq.nextval into :new.id from dual;
END;
/

--
-- TOC Entry ID 62 (OID 18140056)