create table Admin (
  admin_id bigint default global autoincrement(1000000) primary key,
  data     varchar(64)
);

create procedure admin_insert()
result ( admin_id bigint, data varchar(64) )
begin
  select admin_id, data from Admin;
end;

create publication p1 with scripted upload ( 
  table Admin using ( admin_insert for upload insert )
);

create synchronization user "rem1";
create synchronization subscription to p1 for "rem1" 
  type 'tcpip' address 'host=localhost' option sv='v1';

create procedure sp_hook_dbmlsync_schema_upgrade()
begin
  declare @pub_name varchar(128);
  declare @pub_id unsigned int;
  declare @site_name varchar(128);
  declare @last_download timestamp;

  select value 
    into @pub_name 
    from #hook_dict
   where name = 'publication_0';

  select value 
    into @site_name 
    from #hook_dict
   where name = 'MobiLink user';

  select publication_id 
    into @pub_id
    from SYS.SYSPUBLICATION 
   where publication_name = @pub_name;

  select last_download_time 
    into @last_download
    from SYS.SYSSYNC 
   where publication_id = @pub_id
     and site_name = @site_name;

  execute immediate 'drop synchronization subscription to ' || @pub_name || ' for "' || @site_name || '"';
  execute immediate 'drop publication ' || @pub_name;
  execute immediate 'create publication ' || @pub_name || ' ( table Admin )';
  execute immediate 'create synchronization subscription to ' || @pub_name || ' for "' || @site_name || '" type ''tcpip'' address ''host=localhost'' option sv=''v1''';

  select publication_id 
    into @pub_id
    from SYS.SYSPUBLICATION 
   where publication_name = @pub_name;

  call dbo.sa_sync_sub( @pub_id, @site_name, 'set lastdownloadtime', @last_download );

  UPDATE #hook_dict SET value = 'on success' WHERE name = 'drop hook';
end;