[Home]

Summary:ASTERISK-22525: Realtime mysql database schema missing in contrib/realtime/mysql/
Reporter:Dinesh Ramjuttun (din3sh)Labels:
Date Opened:2013-09-13 07:50:28Date Closed:2013-10-09 06:40:37
Priority:MinorRegression?
Status:Closed/CompleteComponents:
Versions:12.0.0-alpha1 Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:Realtime database schema files in contrib/realtime/mysql/ have to data.
Comments:By: Matt Jordan (mjordan) 2013-09-13 15:15:15.437-0500

So, they shouldn't actually even be there. We'll get them removed.

In Asterisk 12, the old SQL scripts have been replaced with Alembic, which can not only generate creation scripts but also upgrade scripts between Asterisk versions (and other nice things).
By: Rusty Newton (rnewton) 2013-09-13 15:17:05.225-0500

More info:

https://wiki.asterisk.org/wiki/display/AST/New+in+12

{quote}
   Asterisk previously included example db schemas in the contrib/realtime/ directory of the source tree. This has been replaced by a set of database migrations using the [Alembic framework|https://alembic.readthedocs.org/en/latest/tutorial.html]. This allows you to use Alembic to initialize the database for you. It will also serve as a database migration tool when upgrading Asterisk in the future. See [contrib/ast-db-manage/README.md|http://svn.asterisk.org/svn/asterisk/branches/12/contrib/ast-db-manage/README.md] for more details.
{quote}
By: Matt Jordan (mjordan) 2013-09-27 08:53:12.161-0500

I've thought about this some more.

During the review of the Alembic Scripts (see [https://reviewboard.asterisk.org/r/2731/]), Tilghman mentioned that we should probably generate scripts for the tagged releases. I concurred with that - if I download Asterisk 12.0.0, I should have creation scripts for the various supported databases.

To do that, we'll need the folders to put them in. So we probably shouldn't remove them.

I'll treat this issue as making sure that the tarballs get the scripts, and close this out when that work is done.
By: Matt Jordan (mjordan) 2013-10-09 06:40:26.905-0500

The newest Asterisk 12 tarballs should now contain the SQL scripts in the appropriate folders.