View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update | 
|---|---|---|---|---|---|
| 0011014 | mantisbt | db oracle | public | 2009-10-07 13:29 | 2015-03-16 19:19 | 
| Reporter | watergad | Assigned To | dregad | ||
| Priority | normal | Severity | minor | Reproducibility | N/A | 
| Status | closed | Resolution | fixed | ||
| Product Version | 1.2.0rc1 | ||||
| Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
| Summary | 0011014: Database creation SQL scripts may be more handy | ||||
| Description | Database creation SQL scripts are not good enough. CREATE OR REPLACE TRIGGER TRIG_SEQ_m_bugfile BEFORE insert ON m_bugfile FOR EACH ROW WHEN (NEW.id IS NULL OR NEW.id = 0) BEGIN select SEQ_m_bugfile.nextval into :new.id from dual; END; / Otherwise the whole following code will go to the trigger body. Next thing is the indexes creation - some of them is repeating. Maybe CREATE OR REPLACE <object> instead of CREATE <object>? | ||||
| Tags | No tags attached. | ||||
