function xanth_db_install_user()
{
//Users
xanth_db_query("\r\n\t\tCREATE TABLE user (\r\n\t\tid INT UNSIGNED AUTO_INCREMENT NOT NULL,\r\n\t\tusername VARCHAR(32) NOT NULL,\r\n\t\tpassword VARCHAR(64) NOT NULL,\r\n\t\temail VARCHAR(128) NOT NULL,\r\n\t\tcookie_token VARCHAR(64) NOT NULL,\r\n\t\tPRIMARY KEY (id),\r\n\t\tUNIQUE(username),\r\n\t\tINDEX(username),\r\n\t\tUNIQUE(email)\r\n\t\t)TYPE=InnoDB");
//User to role
xanth_db_query("\r\n\t\tCREATE TABLE user_to_role (\r\n\t\tuserid INT UNSIGNED NOT NULL,\r\n\t\troleName VARCHAR(32) NOT NULL,\r\n\t\tUNIQUE(userid,roleName),\r\n\t\tINDEX(userid),\r\n\t\tINDEX(roleName),\r\n\t\tFOREIGN KEY (userid) REFERENCES user(id) ON DELETE CASCADE,\r\n\t\tFOREIGN KEY (roleName) REFERENCES role(name) ON DELETE CASCADE\r\n\t\t)TYPE=InnoDB");
$user = new xUser('', 'admin', '*****@*****.**');
$user->insert('pass');
$user->add_in_role('administrator');
//create a box for login
$login_box = new xBox('login_box', 'Login', NULL, 'Full Html', 0, 'sidebar left');
$login_box->insert();
}
function xanth_db_install_admin()
{
$box = new xBox('admin_menu', 'Admin', NULL, 'Full Html', FALSE, 'sidebar left');
$box->insert();
}
