Here's the schema generated:
alter table FX_POSITION drop foreign key FX_POSITION_FX_POSITION_SOURCE; alter table FX_POSITION drop foreign key FX_POSITION_FX_POSITION_TYPE_F; -- SKIP drop table if exists USER; -- SKIP drop table if exists FX_POSITION_TYPE; -- SKIP drop table if exists FX_POSITION_SOURCE_TYPE; -- SKIP drop table if exists FX_POSITION; create table USER ( ID BIGINT not null auto_increment, NAME VARCHAR(255) BINARY not null, PASSWORD VARCHAR(255) BINARY not null, primary key (ID) ); create table FX_POSITION_TYPE ( ID BIGINT not null auto_increment, primary key (ID) ); create table FX_POSITION_SOURCE_TYPE ( ID BIGINT not null auto_increment, SOURCE VARCHAR(255) BINARY not null, primary key (ID) ); create table FX_POSITION ( ID BIGINT not null auto_increment, SEQUENCE_I_D INTEGER not null unique, MESSAGE_IMPORT_SEQ INTEGER not null, AUDIT_VERSION INTEGER not null, IS_AUDIT_CURRENT INTEGER not null, AUDIT_USER VARCHAR(32) BINARY not null, AUDIT_TIME_STAMP TIMESTAMP not null, SOURCE_REF_NUM INTEGER not null, SOURCE_SEQ INTEGER not null, CPTY_NAME VARCHAR(128) BINARY not null, TRANSACTION_TYPE VARCHAR(16) BINARY not null, SENDERS_REF VARCHAR(32) BINARY not null, BUY_CCY VARCHAR(3) BINARY not null, BUY_AMT FLOAT not null, SELL_CCY CHAR(3) not null, SELL_AMT FLOAT not null, CLIENT_RATE FLOAT not null, VALUE_DATE TIMESTAMP not null, DEAL_DATE TIMESTAMP not null, ENTRY_DATE TIMESTAMP not null, COVER_RATE FLOAT not null, FX_RATE FLOAT not null, NEW_FX_RATE FLOAT not null, DEALT_CCY CHAR(3) not null, CONTRA_CCY CHAR(3) not null, QUOTE_BASIS CHAR(7) not null, INTERBANK_SPOT_RATE FLOAT not null, CLIENT_SPOT_RATE FLOAT not null, QUOTE_BASIS_DEALT_CCY CHAR(3) not null, SPOT_RATE_DEALT_CCY CHAR(3) not null, DEALT_RATE FLOAT not null, INTERBANK_ALLLN_RATE FLOAT not null, GTI_SPOT_RATE_MARGIN INTEGER not null, FXO2_REF_NUM VARCHAR(64) BINARY not null, LAST_STATUS_SEQ INTEGER not null, REPAIR_ACTION_SEQ INTEGER not null, LAST_ERROR CHAR(128) not null, LAST_COMMENTS CHAR(128) not null, STATE VARCHAR(255) BINARY not null, COMMENTS VARCHAR(255) BINARY not null, FX_POSITION_SOURCE_TYPE_FK BIGINT not null, FX_POSITION_TYPE_FK BIGINT not null, primary key (ID) ); alter table FX_POSITION add index FX_POSITION_FX_POSITION_SOURCE (FX_POSITION_SOURCE_TYPE_FK), add constraint FX_POSITION_FX_POSITION_SOURCE foreign key (FX_POSITION_SOURCE_TYPE_FK) references FX_POSITION_SOURCE_TYPE (ID); alter table FX_POSITION add index FX_POSITION_FX_POSITION_TYPE_F (FX_POSITION_TYPE_FK), add constraint FX_POSITION_FX_POSITION_TYPE_F foreign key (FX_POSITION_TYPE_FK) references FX_POSITION_TYPE (ID); _________________________________________________________ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=966#966 Posting to http://forum.andromda.org/ is preferred over posting to the mailing list! ------------------------------------------------------- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20 _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user
