View Issue Details

IDProjectCategoryView StatusLast Update
0007126mantisbtdb oraclepublic2014-12-08 00:34
Reporteripardo Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformOracle8i o 9iOSWindows, LinuxOS Version1.0.2
Product Version1.0.2 
Target Version1.3.0-beta.1Fixed in Version1.3.0-beta.1 
Summary0007126: For the execution of Mantis in Oracle 8i, 9i
Description

For the execution of Mantis in Oracle.

Annexed scheme of the data base

TagsNo tags attached.
Attached Files
MANTISORACLE.sql (19,544 bytes)   
----------------------------------------------------------
-- Export file for user MANTIS                          --
-- Created by Israel Pardo on 23/05/2006, 03:33:13 p.m. --
-- Email:ipardo2000@yahoo.com
----------------------------------------------------------

CREATE TABLE  "MANTIS_BUG" 
   (	"ID" NUMBER(10,2) NOT NULL ENABLE, 
	"PROJECT_ID" NUMBER(10,0) DEFAULT 0, 
	"REPORTER_ID" NUMBER(10,0) DEFAULT 0, 
	"HANDLER_ID" NUMBER(10,0) DEFAULT 0, 
	"DUPLICATE_ID" NUMBER(10,0) DEFAULT 0, 
	"PRIORITY" NUMBER(6,0) DEFAULT 30, 
	"SEVERITY" NUMBER(6,0) DEFAULT 50, 
	"REPRODUCIBILITY" NUMBER(6,0) DEFAULT 10, 
	"STATUS" NUMBER(6,0) DEFAULT 10, 
	"RESOLUTION" NUMBER(6,0) DEFAULT 10, 
	"PROJECTION" NUMBER(6,0) DEFAULT 10, 
	"CATEGORY" VARCHAR2(64) NOT NULL ENABLE, 
	"DATE_SUBMITTED" DATE NOT NULL ENABLE, 
	"LAST_UPDATED" DATE NOT NULL ENABLE, 
	"ETA" NUMBER(6,0) DEFAULT 10, 
	"BUG_TEXT_ID" NUMBER(10,0) DEFAULT 0, 
	"OS" VARCHAR2(32) DEFAULT ' ', 
	"OS_BUILD" VARCHAR2(32) DEFAULT ' ', 
	"PLATFORM" VARCHAR2(32) DEFAULT ' ', 
	"VERSION" VARCHAR2(64) DEFAULT ' ', 
	"FIXED_IN_VERSION" VARCHAR2(64) DEFAULT ' ', 
	"BUILD" VARCHAR2(32) DEFAULT ' ', 
	"PROFILE_ID" NUMBER(10,0) DEFAULT 0, 
	"VIEW_STATE" NUMBER(6,0) DEFAULT 10, 
	"SUMMARY" VARCHAR2(128) NOT NULL ENABLE, 
	"SPONSORSHIP_TOTAL" NUMBER(11,0) DEFAULT 0, 
	"STICKY" NUMBER(4,0) DEFAULT 0, 
	 CONSTRAINT "MANTIS_BUG_CON" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "MANTIS_BUG_FILE" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"BUG_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"TITLE" VARCHAR2(250), 
	"DESCRIPTION" VARCHAR2(250), 
	"DISKFILE" VARCHAR2(250), 
	"FILENAME" VARCHAR2(250), 
	"FOLDER" VARCHAR2(250), 
	"FILESIZE" VARCHAR2(20), 
	"FILE_TYPE" VARCHAR2(250), 
	"DATE_ADDED" DATE, 
	"CONTENT" BLOB, 
	 CONSTRAINT "MANTIS_BUG_FILE_CON" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "MANTIS_BUG_HISTORY" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USER_ID" NUMBER(10,0) DEFAULT 0, 
	"BUG_ID" NUMBER(10,0) DEFAULT 0, 
	"DATE_MODIFIED" DATE, 
	"FIELD_NAME" VARCHAR2(32), 
	"OLD_VALUE" VARCHAR2(128), 
	"NEW_VALUE" VARCHAR2(128), 
	"TYPE" VARCHAR2(10)
   )
/
CREATE TABLE  "MANTIS_BUG_MONITOR" 
   (	"USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"BUG_ID" NUMBER(10,0) NOT NULL ENABLE
   )
/
CREATE TABLE  "MANTIS_BUGNOTE" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"BUG_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"REPORTER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"BUGNOTE_TEXT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"VIEW_STATE" NUMBER(6,0), 
	"DATE_SUBMITTED" DATE, 
	"LAST_MODIFIED" DATE, 
	"NOTE_TYPE" NUMBER(11,0), 
	"NOTE_ATTR" VARCHAR2(250)
   )
/
CREATE TABLE  "MANTIS_BUGNOTE_TEXT" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"NOTE" CLOB
   )
/
CREATE TABLE  "MANTIS_BUG_RELATIONSHIP" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"SOURCE_BUG_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"DESTINATION_BUG_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"RELATIONSHIP_TYPE" NUMBER(6,0) NOT NULL ENABLE
   )
/
CREATE TABLE  "MANTIS_BUG_TEXT" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(4000) NOT NULL ENABLE, 
	"STEPS_TO_REPRODUCE" VARCHAR2(4000), 
	"ADDITIONAL_INFORMATION" VARCHAR2(4000)
   )
/
CREATE TABLE  "MANTIS_CONFIG" 
   (	"CONFIG_ID" VARCHAR2(64), 
	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"ACCESS_REQD" NUMBER(10,0), 
	"TYPE" NUMBER(10,0), 
	"VALUE" CLOB
   )
/
CREATE TABLE  "MANTIS_CUSTOM_FIELD" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"NAME" VARCHAR2(64), 
	"TYPE" NUMBER, 
	"POSSIBLE_VALUES" VARCHAR2(255), 
	"DEFAULT_VALUE" VARCHAR2(255), 
	"VALID_REGEXP" VARCHAR2(255), 
	"ACCESS_LEVEL_R" NUMBER(6,0), 
	"ACCESS_LEVEL_RW" NUMBER(6,0), 
	"LENGTH_MIN" NUMBER(11,0), 
	"LENGTH_MAX" NUMBER(11,0), 
	"ADVANCED" NUMBER(4,0), 
	"REQUIRE_REPORT" NUMBER(4,0), 
	"REQUIRE_UPDATE" NUMBER(4,0), 
	"DISPLAY_REPORT" NUMBER(4,0), 
	"DISPLAY_UPDATE" NUMBER(4,0), 
	"REQUIRE_RESOLVED" NUMBER(4,0), 
	"DISPLAY_RESOLVED" NUMBER(4,0), 
	"DISPLAY_CLOSED" NUMBER(4,0), 
	"REQUIRE_CLOSED" NUMBER(4,0)
   )
/
CREATE TABLE  "MANTIS_CUSTOM_FIELD_PROJECT" 
   (	"FIELD_ID" NUMBER(11,0) NOT NULL ENABLE, 
	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"SEQUENCE" NUMBER(6,0)
   )
/
CREATE TABLE  "MANTIS_CUSTOM_FIELD_STRING" 
   (	"FIELD_ID" NUMBER(11,0) NOT NULL ENABLE, 
	"BUG_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"VALUE" VARCHAR2(255)
   )
/
CREATE TABLE  "MANTIS_DIASFESTIVO" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USUARIO_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"FECHA_MODIFICACION" DATE, 
	"ANNO" VARCHAR2(10), 
	"MES" VARCHAR2(2), 
	"DIAS" VARCHAR2(20)
   )
/
CREATE TABLE  "MANTIS_FILTERS" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"IS_PUBLIC" NUMBER(4,0), 
	"NAME" VARCHAR2(64), 
	"FILTER_STRING" CLOB
   )
/
CREATE TABLE  "MANTIS_HORARIO" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"TIPOHORARIO" VARCHAR2(15) NOT NULL ENABLE, 
	"DIASEMANA" VARCHAR2(10), 
	"INICIOJORNADA" VARCHAR2(20), 
	"FINJORNADA" VARCHAR2(20), 
	"FECHAESPECIAL" VARCHAR2(10)
   )
/
CREATE TABLE  "MANTIS_NEWS" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"POSTER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"DATE_POSTED" DATE, 
	"LAST_MODIFIELD" DATE, 
	"VIEW_STATE" NUMBER(6,0), 
	"ANNOUNCEMENT" NUMBER(4,0), 
	"HEADLINE" VARCHAR2(64), 
	"BODY" CLOB
   )
/
CREATE TABLE  "MANTIS_PROJECT" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"NAME" VARCHAR2(128), 
	"STATUS" NUMBER(6,0), 
	"ENABLED" NUMBER(4,0), 
	"VIEW_STATE" NUMBER(6,0), 
	"ACCESS_MIN" NUMBER(6,0), 
	"FILE_PATH" VARCHAR2(250), 
	"DESCRIPTION" VARCHAR2(4000), 
	 CONSTRAINT "MANTIS_PROJECT_CON" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "MANTIS_PROJECT_CATEGORY" 
   (	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"CATEGORY" VARCHAR2(64), 
	"USER_ID" NUMBER(10,0)
   )
/
CREATE TABLE  "MANTIS_PROJECT_FILE" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"TITLE" VARCHAR2(250), 
	"DESCRIPTION" VARCHAR2(250), 
	"DISKFILE" VARCHAR2(250), 
	"FILENAME" VARCHAR2(250), 
	"FOLDER" VARCHAR2(250), 
	"FILESIZE" VARCHAR2(20), 
	"FILE_TYPE" VARCHAR2(250), 
	"DATE_ADDED" DATE, 
	"CONTENT" BLOB
   )
/
CREATE TABLE  "MANTIS_PROJECT_HIERARCHY" 
   (	"CHILD_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"PARENT_ID" NUMBER(10,0) NOT NULL ENABLE
   )
/
CREATE TABLE  "MANTIS_PROJECT_USER_LIST" 
   (	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USER_ID" NUMBER(6,0), 
	"ACCESS_LEVEL" VARCHAR2(10)
   )
/
CREATE TABLE  "MANTIS_PROJECT_VERSION" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"VERSION" VARCHAR2(64), 
	"DATE_ORDER" DATE, 
	"DESCRIPTION" CLOB, 
	"RELEASED" VARCHAR2(10), 
	 CONSTRAINT "MANTIS_PROJECT_VERSION_CON" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "MANTIS_SPONSORSHIP" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"BUG_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"AMOUNT" NUMBER(10,0), 
	"LOGO" VARCHAR2(128), 
	"URL" VARCHAR2(128), 
	"PAID" NUMBER(4,0), 
	"DATE_SUBMITTED" DATE, 
	"LAST_UPDATED" DATE, 
	 CONSTRAINT "MANTIS_SPONSORSHIP_CON" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "MANTIS_TOKENS" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"OWNER" NUMBER(10,0) NOT NULL ENABLE, 
	"TYPE" NUMBER(10,0) NOT NULL ENABLE, 
	"TIMESTAMP" DATE, 
	"EXPIRY" DATE, 
	"VALUE" CLOB
   )
/
CREATE TABLE  "MANTIS_USER" 
   (	"ID" NUMBER(10,2) NOT NULL ENABLE, 
	"USERNAME" VARCHAR2(32) NOT NULL ENABLE, 
	"REALNAME" VARCHAR2(64) NOT NULL ENABLE, 
	"EMAIL" VARCHAR2(64) NOT NULL ENABLE, 
	"PASSWORD" VARCHAR2(32) NOT NULL ENABLE, 
	"DATE_CREATED" DATE NOT NULL ENABLE, 
	"LAST_VISIT" DATE NOT NULL ENABLE, 
	"ENABLED" NUMBER(4,0) DEFAULT 1, 
	"PROTECTED" NUMBER(4,0) DEFAULT 0, 
	"ACCESS_LEVEL" NUMBER(6,0) DEFAULT 10, 
	"LOGIN_COUNT" NUMBER(11,0) DEFAULT 0, 
	"LOST_PASSWORD_REQUEST_COUNT" NUMBER(6,0) DEFAULT 0, 
	"FAILED_LOGIN_COUNT" NUMBER(6,0) DEFAULT 0, 
	"COOKIE_STRING" VARCHAR2(64) NOT NULL ENABLE, 
	 CONSTRAINT "MANTIS_USER_CON" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "MANTIS_USER_PREF" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"PROJECT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"DEFAULT_PROFILE" VARCHAR2(20), 
	"DEFAULT_PROJECT" VARCHAR2(20), 
	"ADVANCED_REPORT" VARCHAR2(10), 
	"ADVANCED_VIEW" VARCHAR2(10), 
	"ADVANCED_UPDATE" VARCHAR2(10), 
	"REFRESH_DELAY" VARCHAR2(20), 
	"REDIRECT_DELAY" VARCHAR2(10), 
	"BUGNOTE_ORDER" VARCHAR2(4), 
	"EMAIL_ON_NEW" VARCHAR2(10), 
	"EMAIL_ON_ASSIGNED" VARCHAR2(10), 
	"EMAIL_ON_FEEDBACK" VARCHAR2(10), 
	"EMAIL_ON_RESOLVED" VARCHAR2(10), 
	"EMAIL_ON_CLOSED" VARCHAR2(10), 
	"EMAIL_ON_REOPENED" VARCHAR2(10), 
	"EMAIL_ON_BUGNOTE" VARCHAR2(10), 
	"EMAIL_ON_STATUS" VARCHAR2(10), 
	"EMAIL_ON_PRIOPRITY" VARCHAR2(10), 
	"EMAIL_ON_PRIORITY_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_ON_STATUS_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_ON_BUGNOTE_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_ON_REOPENED_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_ON_CLOSED_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_ON_RESOLVED_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_ON_FEEDBACK_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_ON_ASSIGNED_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_ON_NEW_MIN_SEVERITY" VARCHAR2(10), 
	"EMAIL_BUGNOTE_LIMT" VARCHAR2(10), 
	"LANGUAGE" VARCHAR2(32)
   )
/
CREATE TABLE  "MANTIS_USER_PRINT_PREF" 
   (	"USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"PRINT_PREF" VARCHAR2(27)
   )
/
CREATE TABLE  "MANTIS_USER_PROFILE" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"PLAFORM" VARCHAR2(32), 
	"OS" VARCHAR2(32), 
	"OS_BUILD" VARCHAR2(32), 
	"DESCRIPTION" CLOB, 
	 CONSTRAINT "MANTIS_USER_PROFILE_CON" PRIMARY KEY ("ID") ENABLE
   )
/

CREATE INDEX  "MANTIS_USER_PROFILE_IDX1" ON  "MANTIS_USER_PROFILE" ("USER_ID")
/
CREATE UNIQUE INDEX  "MANTIS_USER_PROFILE_CON" ON  "MANTIS_USER_PROFILE" ("ID")
/
CREATE UNIQUE INDEX  "MANTIS_USER_CON" ON  "MANTIS_USER" ("ID")
/
CREATE INDEX  "MANTIS_SPONSORSHIP_IDX2" ON  "MANTIS_SPONSORSHIP" ("USER_ID")
/
CREATE INDEX  "MANTIS_SPONSORSHIP_IDX1" ON  "MANTIS_SPONSORSHIP" ("BUG_ID")
/
CREATE UNIQUE INDEX  "MANTIS_SPONSORSHIP_CON" ON  "MANTIS_SPONSORSHIP" ("ID")
/
CREATE INDEX  "MANTIS_PROJECT_VERSION_IDX1" ON  "MANTIS_PROJECT_VERSION" ("PROJECT_ID")
/
CREATE UNIQUE INDEX  "MANTIS_PROJECT_VERSION_CON" ON  "MANTIS_PROJECT_VERSION" ("ID")
/
CREATE INDEX  "MANTIS_PROJECT_USER_LIST_IDX1" ON  "MANTIS_PROJECT_USER_LIST" ("PROJECT_ID")
/
CREATE UNIQUE INDEX  "MANTIS_PROJECT_CON" ON  "MANTIS_PROJECT" ("ID")
/
CREATE INDEX  "MANTIS_PROJECT_CATEGORY_IDX2" ON  "MANTIS_PROJECT_CATEGORY" ("PROJECT_ID")
/
CREATE INDEX  "MANTIS_PROJECT_CATEGORY_IDX1" ON  "MANTIS_PROJECT_CATEGORY" ("PROJECT_ID", "USER_ID")
/
CREATE INDEX  "MANTIS_BUG_IDX1" ON  "MANTIS_BUG" ("PROJECT_ID")
/
CREATE INDEX  "MANTIS_BUG_FILE_IDX1" ON  "MANTIS_BUG_FILE" ("BUG_ID")
/
CREATE UNIQUE INDEX  "MANTIS_BUG_FILE_CON" ON  "MANTIS_BUG_FILE" ("ID")
/
CREATE UNIQUE INDEX  "MANTIS_BUG_CON" ON  "MANTIS_BUG" ("ID")
/

 CREATE SEQUENCE   "MANTIS_USER_TABLA_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_USER_PROFILE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_USER_PREF_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_USER_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_TOKENS_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_SPONSORSHIP_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_PROJECT_VERSION_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_PROJECT_ID_SEQ"  MINVALUE 1 MAXVALUE 99999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_PROJECT_FILE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_NEW_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_HORARIO_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_FILTERS_ID_SEQ"  MINVALUE 1 MAXVALUE 99999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_DIASFESTIVO_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_CUSTOM_FIELD_ID_SEQ"  MINVALUE 1 MAXVALUE 999999999 INCREMENT BY 1 START WITH 9 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_BUG_TEXT_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_BUG_RELATIONSHIP_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_BUGNOTE_TEXT_ID_SEQ"  MINVALUE 1 MAXVALUE 99999999999 INCREMENT BY 1 START WITH 3 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_BUGNOTE_ID_SEQ"  MINVALUE 1 MAXVALUE 99999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_BUG_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_BUG_HISTORY_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 72 NOCACHE  NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "MANTIS_BUG_FILE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
/

CREATE OR REPLACE TRIGGER  "MANTIS_USER_T1" 
BEFORE
insert on "MANTIS_USER"
for each row
begin
   SELECT mantis_user_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_USER_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_USER_PROFILE_T1" 
BEFORE
insert on "MANTIS_USER_PROFILE"
for each row
begin
   SELECT mantis_user_profile_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_USER_PROFILE_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_USER_PREF_T1" 
BEFORE
insert on "MANTIS_USER_PREF"
for each row
begin
   SELECT mantis_user_pref_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_USER_PREF_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_TOKENS_T1" 
BEFORE
insert on "MANTIS_TOKENS"
for each row
begin
   SELECT mantis_tokens_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_TOKENS_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_SPONSORSHIP_T1" 
BEFORE
insert on "MANTIS_SPONSORSHIP"
for each row
begin
   SELECT mantis_sponsorship_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_SPONSORSHIP_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_PROJECT_VERSION_T1" 
BEFORE
insert on "MANTIS_PROJECT_VERSION"
for each row
begin
   SELECT mantis_project_version_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_PROJECT_VERSION_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_PROJECT_T1" 
BEFORE
insert on "MANTIS_PROJECT"
for each row
begin
   SELECT mantis_project_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_PROJECT_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_PROJECT_FILE_T1" 
BEFORE
insert or update or delete on "MANTIS_PROJECT_FILE"
for each row
begin
   SELECT mantis_project_file_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_PROJECT_FILE_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_NEWS_T1" 
BEFORE
insert on "MANTIS_NEWS"
for each row
begin
   SELECT mantis_new_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_NEWS_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_HORARIO_T1" 
BEFORE
insert on "MANTIS_HORARIO"
for each row
begin
   SELECT mantis_horario_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_HORARIO_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_FILTERS_T1" 
BEFORE
insert on "MANTIS_FILTERS"
for each row
begin
   SELECT mantis_filters_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_FILTERS_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_DIASFESTIVO_T1" 
BEFORE
insert on "MANTIS_DIASFESTIVO"
for each row
begin
   SELECT mantis_diasfestivo_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_DIASFESTIVO_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_CUSTOM_FIELD_T1" 
BEFORE
insert on "MANTIS_CUSTOM_FIELD"
for each row
begin
   SELECT mantis_custom_field_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;
/
ALTER TRIGGER  "MANTIS_CUSTOM_FIELD_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_BUG_T1" 
BEFORE
insert on "MANTIS_BUG"
for each row
begin
   SELECT mantis_bug_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_BUG_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_BUG_TEXT_T1" 
BEFORE
insert on "MANTIS_BUG_TEXT"
for each row
begin
   SELECT mantis_bug_text_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_BUG_TEXT_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_BUG_RELATIONSHIP_T1" 
BEFORE
insert on "MANTIS_BUG_RELATIONSHIP"
for each row
begin
   SELECT mantis_bug_relationship_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_BUG_RELATIONSHIP_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_BUGNOTE_T1" 
BEFORE
insert on "MANTIS_BUGNOTE"
for each row
begin
   SELECT mantis_bugnote_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_BUGNOTE_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_BUGNOTE_TEXT_T1" 
BEFORE
insert on "MANTIS_BUGNOTE_TEXT"
for each row
begin
   SELECT mantis_bugnote_text_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_BUGNOTE_TEXT_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_BUG_HISTORY_T1" 
BEFORE
insert on "MANTIS_BUG_HISTORY"
for each row
begin
   SELECT mantis_bug_history_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_BUG_HISTORY_T1" ENABLE
/
CREATE OR REPLACE TRIGGER  "MANTIS_BUG_FILE_T1" 
BEFORE
insert on "MANTIS_BUG_FILE"
for each row
begin
   SELECT mantis_bug_file_id_seq.NEXTVAL         
        INTO  :NEW.ID
        FROM  DUAL;
end;

/
ALTER TRIGGER  "MANTIS_BUG_FILE_T1" ENABLE
/

 
 
        
 
  




MANTISORACLE.sql (19,544 bytes)   

Relationships

child of 0013227 closeddregad Oracle DB support multiple issues 

Activities

dregad

dregad

2011-09-09 12:47

developer   ~0029677

Would you have a chance to test if problem still exists using oracle branch in 0013227 (https://github.com/dregad/mantisbt/commits/oracle), and submit a revised patch/pull request against that if it's the case ?