Hi, Thanks for your mail! I will add a feature request. Was it created using a tool (MySQL export or something similar)? If not, I'm afraid it has low priority for me. For H2, this here should work (please tell me if it doesn't):
alter table CAMPAIGN_SERVICE_MAPPING add constraint FKB6C55FD57471B2CD foreign key (CAMPAIGN_TARIFF_MAPPING_ID) references CAMPAIGN_TARIFF_MAPPING (rec__id); Regards, Thomas On Fri, Jul 31, 2009 at 4:50 AM, AaronJWhiteside<[email protected]> wrote: > > Hey Guys, > > Any chance of supporting the MySQL syntax for alter table statement > under the MySQL compatibility mode? > > > 31/07/2009 12:41:47 ERROR create(SchemaExport.java:348) SchemaExport - > Unsuccessful: alter table CAMPAIGN_SERVICE_MAPPING add index > FKB6C55FD57471B2CD (CAMPAIGN_TARIFF_MAPPING_ID), add constraint > FKB6C55FD57471B2CD foreign key (CAMPAIGN_TARIFF_MAPPING_ID) references > CAMPAIGN_TARIFF_MAPPING (rec__id) > 31/07/2009 12:41:47 ERROR create(SchemaExport.java:349) SchemaExport - > Syntax error in SQL statement ALTER TABLE CAMPAIGN_SERVICE_MAPPING ADD > INDEX FKB6C55FD57471B2CD (CAMPAIGN_TARIFF_MAPPING_ID),[*] ADD > CONSTRAINT FKB6C55FD57471B2CD FOREIGN KEY (CAMPAIGN_TARIFF_MAPPING_ID) > REFERENCES CAMPAIGN_TARIFF_MAPPING (REC__ID) ; SQL statement: > alter table CAMPAIGN_SERVICE_MAPPING add index FKB6C55FD57471B2CD > (CAMPAIGN_TARIFF_MAPPING_ID), add constraint FKB6C55FD57471B2CD > foreign key (CAMPAIGN_TARIFF_MAPPING_ID) references > CAMPAIGN_TARIFF_MAPPING (rec__id) [42000-116] > 31/07/2009 12:41:47 ERROR create(SchemaExport.java:348) SchemaExport - > Unsuccessful: alter table CAMPAIGN_SERVICE_MAPPING add index > FKB6C55FD51530CD15 (SERVICE_ID), add constraint FKB6C55FD51530CD15 > foreign key (SERVICE_ID) references SERVICE (rec__id) > 31/07/2009 12:41:47 ERROR create(SchemaExport.java:349) SchemaExport - > Syntax error in SQL statement ALTER TABLE CAMPAIGN_SERVICE_MAPPING ADD > INDEX FKB6C55FD51530CD15 (SERVICE_ID),[*] ADD CONSTRAINT > FKB6C55FD51530CD15 FOREIGN KEY (SERVICE_ID) REFERENCES SERVICE > (REC__ID) ; SQL statement: > alter table CAMPAIGN_SERVICE_MAPPING add index FKB6C55FD51530CD15 > (SERVICE_ID), add constraint FKB6C55FD51530CD15 foreign key > (SERVICE_ID) references SERVICE (rec__id) [42000-116] > 31/07/2009 12:41:47 ERROR create(SchemaExport.java:348) SchemaExport - > Unsuccessful: alter table CAMPAIGN_TARIFF_MAPPING add index > FK4F968FA29E82805F (TARIFF_ID), add constraint FK4F968FA29E82805F > foreign key (TARIFF_ID) references TARIFF (rec__id) > > > The errors go on but you get the idea... > > JDBC URL: jdbc:h2:mem:smsgw;TRACE_LEVEL_FILE=4;MODE=MySQL > > Regards, > Aaron > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
