Mysql integratio with Bamboo 2.0 Beta release 1 doesn't work

XMLWordPrintable

      In the Capablility_set table, we use a reserved word (KEY) to name a column - this doesn't go well with MYSQL so needs to be fixed!

      As a result, the table creation fails - 

      2008-02-18 14:45:24,455 ERROR [btpool0-1] [SchemaExport] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255), VALUE text, CAPABILITY_SET bigint, primary key (CAPABILITY_ID))' at line 1
2008-02-18 14:45:24,499 ERROR [btpool0-1] [SchemaExport] Unsuccessful: create table REQUIREMENT (REQUIREMENT_ID bigint not null, KEY varchar(255), REGEX_MATCH bit, READONLY_REQ bit, MATCH_VALUE text, REQUIREMENT_SET bigint, primary key (REQUIREMENT_ID))
2008-02-18 14:45:24,500 ERROR [btpool0-1] [SchemaExport] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255), REGEX_MATCH bit, READONLY_REQ bit, MATCH_VALUE text, REQUIREMENT_S' at line 1
2008-02-18 14:45:24,564 ERROR [btpool0-1] [SchemaExport] Unsuccessful: alter table CAPABILITY add constraint FKEE341118A542349B foreign key (CAPABILITY_SET) references CAPABILITY_SET (CAPABILITY_SET_ID)
2008-02-18 14:45:24,564 ERROR [btpool0-1] [SchemaExport] Table 'mysql.CAPABILITY' doesn't exist

              Assignee:
              AjayA
              Reporter:
              AjayA
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: