View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0007126 | mantisbt | db oracle | public | 2006-05-23 20:38 | 2014-12-08 00:34 |
Reporter | ipardo | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | Oracle8i o 9i | OS | Windows, Linux | OS Version | 1.0.2 |
Product Version | 1.0.2 | ||||
Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
Summary | 0007126: For the execution of Mantis in Oracle 8i, 9i | ||||
Description | For the execution of Mantis in Oracle. Annexed scheme of the data base | ||||
Tags | No 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 / | ||||
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 ? |
|