CREATE TABLE `accounts_users` ( `id` INTEGER unsigned AUTO_INCREMENT, `user_id` INTEGER unsigned, `account_id` INTEGER unsigned, `creator_id` INTEGER unsigned, `created_account_id` INTEGER unsigned, `editor_id` INTEGER unsigned, `edited_account_id` INTEGER unsigned, PRIMARY KEY (`id`) ) ENGINE=MyISAM;
CREATE TABLE `accounts` ( `id` INTEGER unsigned AUTO_INCREMENT, `creator_id` INTEGER unsigned, `editor_id` INTEGER unsigned ... PRIMARY KEY (`id`) ) ENGINE=MyISAM; CREATE TABLE `accounts_users` ( `id` INTEGER unsigned AUTO_INCREMENT, `user_id` INTEGER unsigned, `account_id` INTEGER unsigned PRIMARY KEY (`id`) ) ENGINE=MyISAM;