# #This is the table that holds the session info - just create it as is! # CREATE TABLE sessions ( sesskey varchar(32) NOT NULL, expiry int(11) unsigned DEFAULT '0' NOT NULL, value text NOT NULL, PRIMARY KEY (sesskey) ); # #This is the table that holds usernames, passwords, and user rights levels #Rights are now based on an integer - ultimate rights level is 999, #and all lower numbers have lesser rights, as you designate. #Note that default admin rights level is 777 - can you tell I use *nix? # CREATE TABLE user_track ( ut_id int(3) NOT NULL auto_increment, ut_name varchar(30) DEFAULT '0' NOT NULL, ut_pwd varchar(50) NOT NULL, ut_rights int(3) DEFAULT '100' NOT NULL, PRIMARY KEY (ut_id), KEY ut_id (ut_id) ); # #Use this last line of code against your user_track table to create your basic admin user #and then create your own admin user, and delete this one # INSERT INTO user_track VALUES('','admin',md5('admin'),'777');