Revision 293

Date:
2013/03/26 17:54:17
Author:
ahitrov
Revision Log:
Credentials table
Files:

Legend:

 
Added
 
Removed
 
Modified

  • utf8/plugins/users/sql/TOAST/credentials.sql

     
    1 create table profile_credentials
    2 (
    3 id integer not null primary key default nextval('public.documents_id_seq'::text),
    4 class text not null,
    5 ctime timestamp not null default now(),
    6 mtime timestamp not null default now(),
    7 status smallint not null default 0,
    8 opaque smallint not null default 0,
    9 uid integer not null default 0,
    10 ext_id integer not null default 0,
    11 sections integer,
    12 name text,
    13 main integer,
    14 confirm varchar(32),
    15 data text
    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);
    19 create unique index profile_credentials_class_ext_id on profile_credentials (class, ext_id) where ext_id != 0;
    20 create unique index profile_credentials_class_name on profile_credentials (class, name) where ext_id = 0;