tree 4b8387ab19684ab3dd6fa02821db564351461bde
parent 3a7f3e2dd2db6afbcee8d3df8691703fef87addf
author Fang Deng <fdeng@chromium.org> 1433484124 -0700
committer ChromeOS Commit Bot <chromeos-commit-bot@chromium.org> 1433527729 +0000

[autotest] modify invalidates_test_idx fk constraint

The foreign key invalidates_test_idx is causing trouble
in db cleanup. If row1 points to row2 points to row3, they can only
be removed in the order of row3, row2, row1, which often not
the case in the db cleanup. This CL change the fk constraint
from ON DELETE NO ACTION to ON DELETE CASADE, such that
the db will handle the dependency.

TEST=database/migrate.py sync
database/migrate.py sync 101
BUG=None
DEPLOY=migrate

Change-Id: Ic208b87b95ded81612d50f0798aa43d4f611f798
Reviewed-on: https://chromium-review.googlesource.com/275470
Reviewed-by: Dan Shi <dshi@chromium.org>
Tested-by: Fang Deng <fdeng@chromium.org>
Commit-Queue: Fang Deng <fdeng@chromium.org>