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. | ||||