Skip to content

Instantly share code, notes, and snippets.

@manchumahara

manchumahara/gist:7427002

Created November 12, 2013 07:33
Show Gist options
  • Save manchumahara/7427002 to your computer and use it in GitHub Desktop.
Save manchumahara/7427002 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
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