123456789101112 |
- CREATE TABLE `uid_user_attrs` (
- `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
- `uid` VARCHAR(64) NOT NULL,
- `name` VARCHAR(32) NOT NULL,
- `value` VARCHAR(128),
- `type` INT DEFAULT 0 NOT NULL,
- `flags` INT UNSIGNED DEFAULT 0 NOT NULL,
- CONSTRAINT userattrs_idx UNIQUE (`uid`, `name`, `value`)
- );
- INSERT INTO version (table_name, table_version) values ('uid_user_attrs','3');
|