Ticket #4962 (closed Feature Requests: fixed)

Opened 2 years ago

Last modified 2 years ago

please provide up-to-date database dump

Reported by: tzafrir Assigned to: p_lindheimer
Priority: minor Milestone: 2.10
Component: Installation Version: 2.9-branch
Keywords: Cc:
Confirmation: Need Feedback Distro:
Backend Engine: All Distro Ver:
Backend Ver: SVN Revision (if applicable):

Description

The installation procedure is quite odd: you install an old (2.2.0beta3) database schema and data. And then you run a whole bunch of scripts to upgrade it to the latest version.

Wouldn't it be simpler to just provide the latest version of the required schema?

It would much simplify the installation procedure.

Working on a patch to the files in the SQL/ directory.

Attachments

mysql.diff (4.2 kB) - added by tzafrir on 03/16/11 14:10:29.
suggested diff for the mysql dump
0001-2.3.0beta2-notifications-and-cronmanager.patch (1.4 kB) - added by tzafrir on 03/16/11 14:11:18.
0002-2.4.0beta1-zapchandids.patch (1.2 kB) - added by tzafrir on 03/16/11 14:11:45.
0003-2.6.0beta1-trunks-trunks_dialpatterns.patch (1.4 kB) - added by tzafrir on 03/16/11 14:12:26.
0004-2.8.0alpha1-outbound_routes-and-more-new-tables.patch (1.6 kB) - added by tzafrir on 03/16/11 14:13:20.
0005-2.8.0alpha2-trunk-s-_dialplatterns-dahdi.patch (1.6 kB) - added by tzafrir on 03/16/11 14:13:53.
0006-2.9.0alpha1-migrate_ampconf.php-freepbx_settings.patch (1.2 kB) - added by tzafrir on 03/16/11 14:14:30.

Change History

03/13/11 22:11:17 changed by p_lindheimer

  • confirmation changed from Unreviewed to Need Feedback.
  • milestone changed from 2.9 to 2.10.

the schema has been updated many times but I am sure there are tables that are out of date. Feel free to provide patches or data as to which tables you find out of date in there and we'll be glad to update them.

03/16/11 14:10:29 changed by tzafrir

  • attachment mysql.diff added.

suggested diff for the mysql dump

03/16/11 14:11:18 changed by tzafrir

  • attachment 0001-2.3.0beta2-notifications-and-cronmanager.patch added.

03/16/11 14:11:45 changed by tzafrir

  • attachment 0002-2.4.0beta1-zapchandids.patch added.

03/16/11 14:12:26 changed by tzafrir

  • attachment 0003-2.6.0beta1-trunks-trunks_dialpatterns.patch added.

03/16/11 14:13:20 changed by tzafrir

  • attachment 0004-2.8.0alpha1-outbound_routes-and-more-new-tables.patch added.

03/16/11 14:13:53 changed by tzafrir

  • attachment 0005-2.8.0alpha2-trunk-s-_dialplatterns-dahdi.patch added.

03/16/11 14:14:30 changed by tzafrir

  • attachment 0006-2.9.0alpha1-migrate_ampconf.php-freepbx_settings.patch added.

03/16/11 14:16:26 changed by tzafrir

Added mysql.diff - the suggested change to the mysql dump (actually - the actual version was not updated, now that I think about it). The other patches show the steps from which this change is composed of.

08/13/11 19:55:56 changed by xrobau

  • status changed from new to closed.
  • resolution set to fixed.

Fixed in r12407