SQL script to help recover from corrupted database
The compiler should generate some SQL scripts to help discover referential integrity violations, e.g. when using MyISAM storage engine.
Submitted by Danny Groenewegen on 21 May 2010 at 17:10
Issue Log
On 25 May 2010 at 10:46 Sander Vermolen commented:
I can make a check script generator and make it a builder in the WebDSL plugin. Will that do?
On 25 May 2010 at 14:45 Sander Vermolen closed this issue.
On 25 May 2010 at 14:45 Sander Vermolen commented:
Done. The WebDSL editor now has a ‘database integrity check’ builder, which produces a SQL script to check the database. The SQL script will output all invalid references. Only foreign key checks for now. Will add uniqueness checks later.
Log in to post comments