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(); }