Uploaded image for project: 'Jahia Community'
  1. Jahia Community
  2. JAHIA-4610

Add jackrabbit-schema.sql file to drop all the tables, to be used with both jahia:configure maven goal and configuration wizard.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • xCM 6.0.0
    • xCM 6.0.0
    • None

    Description

      When we are using other database than MySQL, we do not drop the database, and therefore the content of the Jackrabbit tables is never purged. We should do this by adding a schema file that would at the minimum drop the tables (that will be re-created by Jackrabbit's startup). Here is an example of such a script :

      drop table JR_DEFAULT_BINVAL;
      drop table jr_default_bundle;
      drop table jr_default_names;
      drop table jr_default_refs;
      drop table jr_default_seq_names_id;
      drop table jr_fsdefault_fsentry;
      drop table jr_fsg_fsentry;
      drop table jr_fsv_fsentry;
      drop table jr_v_binval;
      drop table jr_v_bundle;
      drop table jr_v_names;
      drop table jr_v_refs;
      drop table jr_v_seq_names_id;

      TestRail: Results

        Attachments

          Activity

            People

              tdraier_old Thomas Draier (Inactive)
              shuber_old Serge Huber (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                TestRail: Runs

                  TestRail: Cases

                    Packages

                      Version Package
                      xCM 6.0.0