removing byte order mark
authorvb
Thu, 31 Jul 2014 10:19:20 +0200
changeset 113ac4c77f987a
parent 10 ead888e73384
child 12 44803a6c4549
removing byte order mark
src/update.sql
     1.1 --- a/src/update.sql	Thu Jul 31 10:15:09 2014 +0200
     1.2 +++ b/src/update.sql	Thu Jul 31 10:19:20 2014 +0200
     1.3 @@ -1,4 +1,4 @@
     1.4 -create table trust (
     1.5 +create table trust (
     1.6     user_id text references person (id) on delete cascade,
     1.7     pgp_keypair_fpr text references pgp_keypair (fpr) on delete cascade,
     1.8     comm_type integer not null,
     1.9 @@ -16,18 +16,17 @@
    1.10  alter table identity rename to identity_old;
    1.11  
    1.12  create table identity (
    1.13 -	address text primary key,
    1.14 -	user_id text
    1.15 -		references person (id)
    1.16 -		on delete cascade,
    1.17 -	main_key_id text
    1.18 -		references pgp_keypair (fpr)
    1.19 -		on delete set null,
    1.20 -	comment text
    1.21 +    address text primary key,
    1.22 +    user_id text
    1.23 +        references person (id)
    1.24 +        on delete cascade,
    1.25 +    main_key_id text
    1.26 +        references pgp_keypair (fpr)
    1.27 +        on delete set null,
    1.28 +    comment text
    1.29  );
    1.30  
    1.31  insert into identity (address, user_id, main_key_id)
    1.32      select address, user_id, main_key_id from identity_old;
    1.33  
    1.34  drop table identity_old;
    1.35 -