Make RedBean Works on Custom Table

add_id_column.sql

#RedBean needs the 'id' column.
ALTER TABLE `table_name` ADD `id` INT  UNSIGNED  NULL  DEFAULT '1';

addrecord-patch.php

	<?php
	/*
	RedBean need 'id' column but
	your table use profile_id.
	So, we need to sync it
	*/
	
	//Register User
	$bean = R::dispense( "profile" );
	$bean->profile_username=$profile_username;
	$bean->profile_password=$profile_password;
	$bean->token=null;
	R::store($bean);

	//Fix Bean ID
	$bean_id = R::getCell("SELECT MAX(profile_id) AS profile_id FROM profile");
	R::exec( "UPDATE profile SET id=:id WHERE profile_id=:id",
	[
		':id' => $bean_id
	]);

setup.php

<?php
R::setup();
R::setStrictTyping(false);
R::ext('xdispense', function($type){ 
        return R::getRedBean()->dispense($type); 
    });