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 148666 Details for
Bug 291233
Exceptions when generating entities from certain Sybase tables
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.
DDL file to create Sybase tables
SYBASE_SurveyBTMUP.sql (text/plain), 1.48 KB, created by
Leonard Theivendra
on 2009-10-02 13:35:45 EDT
(
hide
)
Description:
DDL file to create Sybase tables
Filename:
MIME Type:
Creator:
Leonard Theivendra
Created:
2009-10-02 13:35:45 EDT
Size:
1.48 KB
patch
obsolete
> > >-- Generated by Relational Schema Center on Tue Mar 08 14:21:38 EST 2005 for Sybase Adaptive Server Enterprise V12.5 >DROP table CHOICETYPE; >DROP table CHOICE; >DROP table RESULT; >DROP table QUESTION; >DROP table SURVEY; > > >create table SURVEY > (NAME VARCHAR(100) not null); > >alter table SURVEY > add constraint PK_SURVEY primary key (NAME); > >create table QUESTION > (NUM INT not null, > QUESTIONTEXT VARCHAR(100) null, > SURVEY_NAME VARCHAR(100) not null); > >alter table QUESTION > add constraint PK_QUESTION primary key (NUM, SURVEY_NAME); > > >create table CHOICE > (NUM INT not null, > CHOICETEXT VARCHAR(100) null, > QUESTION_NUM INT not null, > QUESTION_SURVEY_NAME VARCHAR(100) not null); > >alter table CHOICE > add constraint PK_CHOICE primary key (NUM, QUESTION_NUM, QUESTION_SURVEY_NAME); > > create table RESULT > (USERNAME VARCHAR(100) not null, > ANSWER INT null, > QUESTION_NUM INT not null, > QUESTION_SURVEY_NAME VARCHAR(100) not null); > >alter table RESULT > add constraint PK_RESULT primary key (USERNAME, QUESTION_NUM, QUESTION_SURVEY_NAME); > >ALTER TABLE QUESTION > add constraint survey > FOREIGN KEY (SURVEY_NAME) > REFERENCES SURVEY (NAME); > >ALTER TABLE RESULT > add constraint question > FOREIGN KEY (QUESTION_NUM, QUESTION_SURVEY_NAME ) > REFERENCES QUESTION (NUM, SURVEY_NAME); > >ALTER TABLE CHOICE > add constraint cquestion > FOREIGN KEY (QUESTION_NUM, QUESTION_SURVEY_NAME ) > REFERENCES QUESTION (NUM, SURVEY_NAME); > > > >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 291233
: 148666