[asterisk-users] sql schema without alembic

[Marek Červenka]

Dne 4.2.2016 v 12:17 A J Stiles napsal(a):
> On Thursday 04 Feb 2016, Marek Červenka wrote:
>> hi,
>>
>> is there way to get SQL schema for Asterisk 13.7.0 without alembic?
>> thanks
> Assuming you already have Asterisk up and running, you can just use
>
> $ mysqldump -d -uroot DATABASE TABLE1 TABLE2 TABLE3 ...
>
> will print  (on STDOUT, so you can just use > to write it to a new file, >> to
> join onot an existing file or | to pass it through a program)  the SQL
> statements required to recreate the given tables in the given database.  (If
> you don't specify any tables, it will assume you mean all of them.)
>
> The -d means "don't dump any data", so it will dump just the CREATE statements
> and not the INSERT statements that would actually populate the database.

i have asterisk 13.3.0 running on box where i cannot install alembic
i need upgrade to latest asterisk.
for me is the best way apply only "alter table ..." commands for upgrade 
13.3.0->13.7.2

-- 
---------------------------------------
Marek Cervenka
=======================================