search

jaanmeld / tennis-ladder-online

Automatically exported from code.google.com/p/tennis-ladder-online
0 stars 0 forks source link

clean up & merge release 2 db with release 1 db. #43

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
1. changed EntityBase from a class to interface, since both the default
grails table mapping machanism TablePerHierachy & TablePerClass not suite
for my case, I just want a clean & simple TablePerConcrete class.

2. a bunch of hibernate errors raised after the new domain code hooked up
with the release 1 db:
2010-05-03 13:49:33,217 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table authority_people add constraint FK4C07070BDDDEFBEE foreign key
(authority_id) references authority
2010-05-03 13:49:33,221 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table authority_people add constraint
FK4C07070BDDDEFBEE foreign key (authority_id) references authori
2010-05-03 13:49:33,223 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table authority_people add constraint FK4C07070B814F3D86 foreign key
(player_id) references player
2010-05-03 13:49:33,224 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table authority_people add constraint
FK4C07070B814F3D86 foreign key (player_id) references player]
2010-05-03 13:49:33,238 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table level add constraint FK6219B842D0029E6 foreign key (ladder_id)
references ladder
2010-05-03 13:49:33,239 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table level add constraint
FK6219B842D0029E6 foreign key (ladder_id) references ladder]
2010-05-03 13:49:33,241 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table level_position add constraint FKEE52E3842D0029E6 foreign key
(ladder_id) references ladder
2010-05-03 13:49:33,243 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table level_position add constraint
FKEE52E3842D0029E6 foreign key (ladder_id) references ladder]
2010-05-03 13:49:33,245 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table level_position add constraint FKEE52E3842D442706 foreign key
(team_id) references team
2010-05-03 13:49:33,246 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table level_position add constraint
FKEE52E3842D442706 foreign key (team_id) references team]
2010-05-03 13:49:33,250 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table level_position add constraint FKEE52E3845F31B24E foreign key
(level_id) references level
2010-05-03 13:49:33,251 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table level_position add constraint
FKEE52E3845F31B24E foreign key (level_id) references level]
2010-05-03 13:49:33,254 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table match_schedule add constraint FKB5A617D152B2C7B4 foreign key
(challenger_id) references team
2010-05-03 13:49:33,276 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table match_schedule add constraint
FKB5A617D152B2C7B4 foreign key (challenger_id) references team]
2010-05-03 13:49:33,278 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table match_schedule add constraint FKB5A617D187CEF1C0 foreign key
(defender_id) references team
2010-05-03 13:49:33,279 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table match_schedule add constraint
FKB5A617D187CEF1C0 foreign key (defender_id) references team]
2010-05-03 13:49:33,281 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table match_schedule add constraint FKB5A617D1B8EE771 foreign key
(default_reason_id) references default_reason
2010-05-03 13:49:33,282 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table match_schedule add constraint
FKB5A617D1B8EE771 foreign key (default_reason_id) references defau
2010-05-03 13:49:33,286 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table message add constraint FK38EB000789A47E28 foreign key (to_id)
references team
2010-05-03 13:49:33,287 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table message add constraint
FK38EB000789A47E28 foreign key (to_id) references team]
2010-05-03 13:49:33,292 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table message add constraint FK38EB000741954A53 foreign key
(schedule_id) references match_schedule
2010-05-03 13:49:33,295 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table message add constraint
FK38EB000741954A53 foreign key (schedule_id) references match_schedule]
2010-05-03 13:49:33,300 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table message add constraint FK38EB00075FEE274D foreign key
(create_by_id) references player
2010-05-03 13:49:33,303 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table message add constraint
FK38EB00075FEE274D foreign key (create_by_id) references player]
2010-05-03 13:49:33,307 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table message add constraint FK38EB0007FD645AEB foreign key
(parent_id) references message
2010-05-03 13:49:33,326 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table message add constraint
FK38EB0007FD645AEB foreign key (parent_id) references message]
2010-05-03 13:49:33,330 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table team add constraint FK36425D2D0029E6 foreign key (ladder_id)
references ladder
2010-05-03 13:49:33,331 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table team add constraint
FK36425D2D0029E6 foreign key (ladder_id) references ladder]
2010-05-03 13:49:33,333 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table team add constraint FK36425D6DC0CCF6 foreign key (player2_id)
references player
2010-05-03 13:49:33,335 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table team add constraint
FK36425D6DC0CCF6 foreign key (player2_id) references player]
2010-05-03 13:49:33,337 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful:
alter table team add constraint FK36425D6DC05897 foreign key (player1_id)
references player
2010-05-03 13:49:33,338 [main] ERROR hbm2ddl.SchemaUpdate  - Constraint
already exists in statement [alter table team add constraint
FK36425D6DC05897 foreign key (player1_id) references player]
Server running. Browse to http://localhost:8080/Ladder

I am going to backup the player table, authority+player_authority table,
and recreate the ladder etc.

Original issue reported on code.google.com by will....@gmail.com on 3 May 2010 at 6:30

GoogleCodeExporter commented 8 years ago 
see the wiki on how to merge existing data & create the ladder

Original comment by will....@gmail.com on 9 May 2010 at 1:21