Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
CREATE TABLE IF NOT EXISTS `j32_user_profiles` (
`user_id` int(11) NOT NULL,
`profile_key` varchar(100) NOT NULL,
`profile_value` varchar(255) NOT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Simple user profile storage table';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment