create table trust (

    user_id text references person (id) on delete cascade,

    pgp_keypair_fpr text references pgp_keypair (fpr) on delete cascade,

    comm_type integer not null,

    comment text

 );

 create unique index trust_index on trust (

    user_id,

    pgp_keypair_fpr

 );

 insert into trust (user_id, pgp_keypair_fpr, comm_type)

     select user_id, main_key_id, comm_type from identity;

 alter table identity rename to identity_old;

 create table identity (

     address text primary key,

     user_id text

         references person (id)

         on delete cascade,

     main_key_id text

         references pgp_keypair (fpr)

         on delete set null,

     comment text

 );

 insert into identity (address, user_id, main_key_id)

     select address, user_id, main_key_id from identity_old;

 drop table identity_old;