Changeset 5565


Ignore:
Timestamp:
Jul 19, 2017, 12:18:53 PM (22 months ago)
Author:
mabarracus
Message:

Fix typo error

File:
1 edited

Legend:

Unmodified
Added
Removed
  • lliurex-analytics-server/trunk/fuentes/lliurex-analytics-server/usr/lib/analytics-server/migrate_from_1_4.sql

    r5560 r5565  
    1717insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'15' as Releases_name, 'client' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '15%' and sabor != 'dummy' and (sabor like '%client%') on duplicate key update uuid=values(uuid);
    1818delete from analytics.clients_bkp where version like '15%' and sabor != 'dummy' and (sabor like '%client%');
    19 insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'16' as Releases_name, 'desktop' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%desktop%') on duplicate key update uuid=values(uuid)
     19insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'16' as Releases_name, 'desktop' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%desktop%') on duplicate key update uuid=values(uuid);
    2020delete from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%desktop%');
    21 insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'16' as Releases_name, 'server' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%server%') on duplicate key update uuid=values(uuid)
     21insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'16' as Releases_name, 'server' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%server%') on duplicate key update uuid=values(uuid);
    2222delete from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%server%');
    23 insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'16' as Releases_name, 'client' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%client%') on duplicate key update uuid=values(uuid)
     23insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'16' as Releases_name, 'client' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%client%') on duplicate key update uuid=values(uuid);
    2424delete from analytics.clients_bkp where version like '16%' and sabor != 'dummy' and (sabor like '%client%');
    25 insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'15' as Releases_name, 'other' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '15%' and sabor != 'dummy' on duplicate key update uuid=values(uuid)
     25insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'15' as Releases_name, 'other' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '15%' and sabor != 'dummy' on duplicate key update uuid=values(uuid);
    2626delete from analytics.clients_bkp where version like '15%' and sabor != 'dummy';
    27 insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'16' as Releases_name, 'other' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '16%' and sabor != 'dummy' on duplicate key update uuid=values(uuid)
     27insert into analytics.Client_Versions select CONV(SUBSTRING(CAST(SHA(CONCAT(month(lastlogin),'-',year(lastlogin),'-',user,'-',version,'-',sabor)) AS CHAR), 1, 16), 16, 10) as uuid,user as Client_uid,'16' as Releases_name, 'other' as Flavours_name,date(lastlogin) as date,version as string_release,sabor as string_flavour from analytics.clients_bkp where version like '16%' and sabor != 'dummy' on duplicate key update uuid=values(uuid);
    2828delete from analytics.clients_bkp where version like '16%' and sabor != 'dummy';
    2929
Note: See TracChangeset for help on using the changeset viewer.