Re: [Web-erp-developers] create demo script

[Phil D. <ph...@du...>]

BlankYes I saw that. I thought the upgrade script would work for those that
already had a weberp db. Running the web_erp_demo.sql would hit snags
naturally in deleting the tables where there are foreign key constraints in
other tables. The upgrade script would not have a problem with this.

What I haven't tried is running the script when a previous version of the db
is not already existing, does this fail too?

Loading the demo data from scratch with the web_erp_demo.sql should probably
have the disable foreign key checks option in like you say - I will modify
this.

P
  ----- Original Message -----
  From: Stins, Dick
  To: web...@li...
  Sent: Wednesday, February 25, 2004 10:18 AM
  Subject: [Web-erp-developers] create demo script


    Hoi,

    I tried to setup a new demo database.

    The foreign keys are causing some trouble.

    Although I think we should not use the next statement, it is a quick
workaround to add to the script:

mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE dump_file_name;
mysql> SET FOREIGN_KEY_CHECKS = 1;
To be in control, we should deliver a script which does
not need this workaround.
See also:
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
    The load of the demo data is also complaining about the foreign key
constraints.

    The workaround works too, but there is a chance that the data integrity
is corrupted, because I suppose that mysql does not check the data integrity
(foreign keys) when the foreign keys are enabled.

    To be sure, we should improve the script with the ability to load the
(demo) data without any problems while the foreign key checks are enabled.

    With best regards,

    Dick Stins