On 10 August 2010 21:23, Andrew Pogrebennyk <andrew.pogreben...@portaone.com> wrote: > On 10.08.2010 23:21, Gavin Henry wrote: >> "opensipsdbctl migrate opensips_1_5 opensips_1_6" was used and there >> was one error with the subscriber db which is actually a stored >> procedure calling an Asterisk realtime table. >> >> Is there a guide to migrate the SQL with out using the above tool? > > Gavin, > I sometimes checkout two versions with svn and run diff - you are > correct the structure of dialog table has changed in 1.6.3, not sure why > opensipsdbctl migrate .. did not convert it: > > diff -ruN opensips_1_5/scripts/mysql/dialog-create.sql > opensips_1_6/scripts/mysql/dialog-create.sql > --- opensips_1_5/scripts/mysql/dialog-create.sql 2010-08-04 > 17:11:48.000000000 +0300 > +++ opensips_1_6/scripts/mysql/dialog-create.sql 2010-08-04 > 17:11:48.000000000 +0300 > @@ -1,4 +1,4 @@ > -INSERT INTO version (table_name, table_version) values ('dialog','3'); > +INSERT INTO version (table_name, table_version) values ('dialog','4'); > CREATE TABLE dialog ( > id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, > hash_entry INT(10) UNSIGNED NOT NULL, > @@ -18,7 +18,10 @@ > callee_sock CHAR(64) NOT NULL, > state INT(10) UNSIGNED NOT NULL, > start_time INT(10) UNSIGNED NOT NULL, > - timeout INT(10) UNSIGNED NOT NULL > + timeout INT(10) UNSIGNED NOT NULL, > + vars TEXT(512) DEFAULT NULL, > + profiles TEXT(512) DEFAULT NULL, > + script_flags INT(10) UNSIGNED DEFAULT 0 NOT NULL > ) ENGINE=MyISAM; > > > -- > Sincerely, > Andrew Pogrebennyk
Thanks Andrew. Should have done that! Will check myself. Cheers! -- http://www.suretecsystems.com/services/openldap/ http://www.suretectelecom.com _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users