Download
Getting Started
Members
Projects
Community
Marketplace
Events
Planet Eclipse
Newsletter
Videos
Participate
Report a Bug
Forums
Mailing Lists
Wiki
IRC
How to Contribute
Working Groups
Automotive
Internet of Things
LocationTech
Long-Term Support
PolarSys
Science
OpenMDM
More
Community
Marketplace
Events
Planet Eclipse
Newsletter
Videos
Participate
Report a Bug
Forums
Mailing Lists
Wiki
IRC
How to Contribute
Working Groups
Automotive
Internet of Things
LocationTech
Long-Term Support
PolarSys
Science
OpenMDM
Toggle navigation
Bugzilla – Attachment 69703 Details for
Bug 190486
DTP doesn't recognize Oracle columns of type TIMESTAMP
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Requests
|
Help
|
Log In
[x]
|
Terms of Use
|
Copyright Agent
Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read
this important communication.
DTP-generated DDL
script.sql.ddl (text/plain), 779 bytes, created by
Alex Savitsky
on 2007-06-01 10:42:13 EDT
(
hide
)
Description:
DTP-generated DDL
Filename:
MIME Type:
Creator:
Alex Savitsky
Created:
2007-06-01 10:42:13 EDT
Size:
779 bytes
patch
obsolete
>CREATE TABLE ISSUE ( > ID NUMBER(22 , 0) NOT NULL, > DESCRIPTION VARCHAR2(4000) NOT NULL, > DUE_DATE DATE NOT NULL, > CREATED_ON null DEFAULT SYSTIMESTAMP NOT NULL, > CREATED_BY VARCHAR2(20) DEFAULT 'ADMIN' NOT NULL, > MODIFIED_ON null DEFAULT SYSTIMESTAMP NOT NULL, > MODIFIED_BY VARCHAR2(20) DEFAULT 'ADMIN' NOT NULL, > ACCOUNT_NBR VARCHAR2(50), > CLOSING_DATE DATE, > VISIT_ID NUMBER(22 , 0) NOT NULL, > REF_NBR VARCHAR2(50), > REP_NBR VARCHAR2(20) > ); > >CREATE UNIQUE INDEX SYS_C0060511 ON ISSUE (null); > >ALTER TABLE ISSUE ADD CONSTRAINT SYS_C0060511 PRIMARY KEY (ID); > >ALTER TABLE ISSUE ADD CONSTRAINT SYS_C0062149 FOREIGN KEY (VISIT_ID) > REFERENCES VISIT (ID) > ON DELETE CASCADE > ON UPDATE CASCADE; >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=69703">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 190486
:
69699
|
69700
|
69701
|
69702
| 69703 |
69705
