• credentials.sql

    378 379  
    14 14 confirm varchar(32),
    15 15 data text
    16 16 );
    17 create index profile_credentials_user_class_name on profile_credentials (class, uid, name);
    18 create index profile_credentials_user_class_ext_id on profile_credentials (class, uid, ext_id);
    17 create index profile_credentials_user_class_ext_id on profile_credentials (class, uid, ext_id) where ext_id != 0;
    18 create index profile_credentials_user_class_name on profile_credentials (class, uid, name) where ext_id = 0;
    19 19 create unique index profile_credentials_class_ext_id on profile_credentials (class, ext_id) where ext_id != 0;
    20 20 create unique index profile_credentials_class_name on profile_credentials (class, name) where ext_id = 0;