sourceforge.sql

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

-- ORACLE SCRIPT
--   Changes were renaming the "session" table to sf_session
--                renaming "date" columns to sf_date
--                commenting out the create trigger constraints
--                commenting out the select setval statements

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

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

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

CREATE TABLE bug (
	bug_id integer DEFAULT '0' NOT NULL,
	group_id integer DEFAULT '0' NOT NULL,
	status_id integer DEFAULT '0' NOT NULL,
	priority integer DEFAULT '0' NOT NULL,
	category_id integer DEFAULT '0' NOT NULL,
	submitted_by integer DEFAULT '0' NOT NULL,
	assigned_to integer DEFAULT '0' NOT NULL,
	sf_date integer DEFAULT '0' NOT NULL,
	summary varchar2(255),
	details varchar2(255),
	close_date integer,
	bug_group_id integer DEFAULT '0' NOT NULL,
	resolution_id integer DEFAULT '0' NOT NULL,
	PRIMARY KEY (bug_id)
);

CREATE TRIGGER DEFAULT_BUG_ID BEFORE 
    INSERT 
    ON bug REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_pk_seq.nextval into :new.bug_id from dual;
END;
/

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

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

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

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

CREATE TRIGGER DEFAULT_BUG_DEPEND_ID BEFORE 
    INSERT 
    ON bug_bug_dependencies REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_bug_dependencies_pk_seq.nextval into :new.bug_depend_id from dual;
END;
/

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

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

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

CREATE TABLE bug_canned_responses (
	bug_canned_id integer DEFAULT '0' NOT NULL,
	group_id integer DEFAULT '0' NOT NULL,
	title varchar2(255),
	body varchar2(255),
	PRIMARY KEY (bug_canned_id)
);

CREATE TRIGGER DEFAULT_BUG_CANNED_ID BEFORE 
    INSERT 
    ON bug_canned_responses REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_canned_responses_pk_seq.nextval into :new.bug_canned_id from dual;
END;
/

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

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

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

CREATE TABLE bug_category (
	bug_category_id integer DEFAULT '0' NOT NULL,
	group_id integer DEFAULT '0' NOT NULL,
	category_name varchar2(255),
	PRIMARY KEY (bug_category_id)
);

CREATE TRIGGER DEFAULT_BUG_CATEGORY_ID BEFORE 
    INSERT 
    ON bug_category REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_category_pk_seq.nextval into :new.bug_category_id from dual;
END;
/

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

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

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

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

CREATE TRIGGER DEFAULT_BUG_FILTER_ID BEFORE 
    INSERT 
    ON bug_filter REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_filter_pk_seq.nextval into :new.filter_id from dual;
END;
/

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

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

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

CREATE TABLE bug_group (
	bug_group_id integer DEFAULT '0' NOT NULL,
	group_id integer DEFAULT '0' NOT NULL,
	group_name varchar2(255) DEFAULT '',
	PRIMARY KEY (bug_group_id)
);

CREATE TRIGGER DEFAULT_BUG_GROUP_ID BEFORE 
    INSERT 
    ON bug_group REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_group_pk_seq.nextval into :new.bug_group_id from dual;
END;
/

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

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

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

CREATE TABLE bug_history (
	bug_history_id integer DEFAULT '0' NOT NULL,
	bug_id integer DEFAULT '0' NOT NULL,
	field_name varchar2(255) DEFAULT '',
	old_value varchar2(255) DEFAULT '',
	mod_by integer DEFAULT '0' NOT NULL,
	sf_date integer,
	PRIMARY KEY (bug_history_id)
);

--nextval('bug_history_pk_seq'::text)
CREATE TRIGGER DEFAULT_BUG_HISTORY_ID BEFORE 
    INSERT 
    ON bug_history REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_history_pk_seq.nextval into :new.bug_history_id from dual;
END;
/

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

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

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

CREATE TABLE bug_resolution (
	resolution_id integer DEFAULT '0' NOT NULL,
	resolution_name varchar2(255) DEFAULT '',
	PRIMARY KEY (resolution_id)
);

--nextval('bug_resolution_pk_seq'::text)
CREATE TRIGGER DEFAULT_BUG_RESOLUTION_ID BEFORE 
    INSERT 
    ON bug_resolution REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_resolution_pk_seq.nextval into :new.resolution_id from dual;
END;
/

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

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

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

CREATE TABLE bug_status (
	status_id integer DEFAULT '0' NOT NULL,
	status_name varchar2(255),
	PRIMARY KEY (status_id)
);

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

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

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

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

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

--nextval('bug_task_dependencies_pk_seq'::text) 
CREATE TRIGGER DEFAULT_BUG_TASK_ID BEFORE 
    INSERT 
    ON bug_task_dependencies REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select bug_task_dependencies_pk_seq.nextval into :new.bug_depend_id from dual;
END;
/

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

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

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

CREATE TABLE canned_responses (
	response_id integer DEFAULT '0' NOT NULL,
	response_title character varying(25),
	response_text varchar2(255),
	PRIMARY KEY (response_id)
);

--nextval('canned_responses_pk_seq'::text) 
CREATE TRIGGER DEFAULT_CANNED_RESPONSE_ID BEFORE 
    INSERT 
    ON canned_responses REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select canned_responses_pk_seq.nextval into :new.response_id from dual;
END;
/

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

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

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

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

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

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

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

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

CREATE TABLE doc_data (
	docid integer DEFAULT '0' NOT NULL,
	stateid integer DEFAULT '0' NOT NULL,
	title character varying(255) DEFAULT '',
	data varchar2(255) DEFAULT '',
	updatedate integer DEFAULT '0' NOT NULL,
	createdate integer DEFAULT '0' NOT NULL,
	created_by integer DEFAULT '0' NOT NULL,
	doc_group integer DEFAULT '0' NOT NULL,
	description varchar2(255),
	language_id integer DEFAULT '1' NOT NULL,
	PRIMARY KEY (docid)
);

--nextval('doc_data_pk_seq'::text) 
CREATE TRIGGER DEFAULT_DOC_DATA_ID BEFORE 
    INSERT 
    ON doc_data REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select doc_data_pk_seq.nextval into :new.docid from dual;
END;
/

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

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

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

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

--nextval('doc_groups_pk_seq'::text) 
CREATE TRIGGER DEFAULT_DOC_GROUP BEFORE 
    INSERT 
    ON doc_groups REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select doc_groups_pk_seq.nextval into :new.doc_group from dual;
END;
/

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

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

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

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

--nextval('doc_states_pk_seq'::text) 
CREATE TRIGGER DEFAULT_DOC_STATES_ID BEFORE 
    INSERT 
    ON doc_states REFERENCING OLD AS old NEW AS new 
    FOR EACH ROW 
BEGIN
  select doc_states_pk_seq.nextval into :new.stateid from dual;
END;
/

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

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

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

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

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

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

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

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

CREATE TABLE forum (
	msg_id integer DEFAULT '0' NOT NULL,
	group_forum_id integer DEFAULT '0' NOT NULL,
	posted_by integer DEFAULT '0' NOT NULL,
	subject varchar2(255) DEFAULT '',
	body varchar2(255) DEFAULT '',