uid_avp_db-create.sql 411 B

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