uid_avp_db-create.sql 379 B

1234567891011
  1. INSERT INTO version (table_name, table_version) values ('uid_user_attrs','3');
  2. CREATE TABLE uid_user_attrs (
  3. id SERIAL PRIMARY KEY NOT NULL,
  4. uid VARCHAR(64) NOT NULL,
  5. name VARCHAR(32) NOT NULL,
  6. value VARCHAR(128),
  7. type INTEGER DEFAULT 0 NOT NULL,
  8. flags INTEGER DEFAULT 0 NOT NULL,
  9. CONSTRAINT uid_user_attrs_userattrs_idx UNIQUE (uid, name, value)
  10. );