- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'sequential ID',
- `uid` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'Owner user id',
- `psid` int(10) unsigned DEFAULT NULL COMMENT 'ID of the permission set of this profile field - 0 = public',
- `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name of the field',
- `value` text COMMENT 'Value of the field',
- `order` mediumint(8) unsigned NOT NULL DEFAULT 1 COMMENT 'Field ordering per user',
- `label` varchar(255) NOT NULL DEFAULT '' COMMENT 'Label of the field',
- `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- PRIMARY KEY (`id`),
- KEY `uid` (`uid`),
- KEY `psid` (`psid`),
- KEY `order` (`order`)
+ `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
+ `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner user id',
+ `order` mediumint unsigned NOT NULL DEFAULT 1 COMMENT 'Field ordering per user',
+ `psid` int unsigned COMMENT 'ID of the permission set of this profile field - 0 = public',
+ `label` varchar(255) NOT NULL DEFAULT '' COMMENT 'Label of the field',
+ `value` text COMMENT 'Value of the field',
+ `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'creation time',
+ `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'last edit time',
+ PRIMARY KEY(`id`),
+ INDEX `uid` (`uid`),
+ INDEX `order` (`order`),
+ INDEX `psid` (`psid`)