Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

river_droplet_forms DB update script #5

Open
ekala opened this issue Apr 4, 2013 · 0 comments
Open

river_droplet_forms DB update script #5

ekala opened this issue Apr 4, 2013 · 0 comments
Labels

Comments

@ekala
Copy link
Contributor

ekala commented Apr 4, 2013

The DDL for TABLE river_droplet_form in 2013_03_27_00_river_droplet_forms.sql:

CREATE TABLE IF NOT EXISTS river_droplet_form (
  id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
  river_droplets_id bigint NOT NULL,
  form_id bigint NOT NULL,
  UNIQUE (rivers_droplets_id, form_id)
);

is different from the one in schema.sql

CREATE TABLE IF NOT EXISTS river_droplet_form (
  id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
  drop_id bigint NOT NULL,
  form_id bigint NOT NULL,
  UNIQUE (drop_id, form_id)
);

Therefore, if an existing DB is updated using the update scripts, an exception is thrown whenever a drop fetch request is made

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant