MeNeedz Auth

[eluser]davidbehler[/eluser]
I have just created a small sql script that should get you going:

Code:

--
-- Table `group`
--

CREATE TABLE IF NOT EXISTS `group` (
  `group_id` varchar(20) NOT NULL,
  `group_level` tinyint(4) NOT NULL,
  PRIMARY KEY  (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table `member`
--

CREATE TABLE IF NOT EXISTS `member` (
  `member_id` smallint(6) NOT NULL auto_increment,
  `group` varchar(20) NOT NULL,
  `user_id` smallint(6) NOT NULL,
  PRIMARY KEY  (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table `right`
--

CREATE TABLE IF NOT EXISTS `right` (
  `right_id` smallint(6) NOT NULL auto_increment,
  `group` varchar(20) NOT NULL,
  `controller` varchar(50) NOT NULL,
  `function` varchar(50) NOT NULL,
  `access_right` varchar(10) NOT NULL,
  PRIMARY KEY  (`right_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` smallint(6) NOT NULL auto_increment,
  `user_name` varchar(30) NOT NULL,
  `user_password` varchar(40) NOT NULL,
  `user_salt` varchar(40) NOT NULL,
  `user_group` varchar(20) NOT NULL,
  `user_email` varchar(100) NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

@your last question:
Actually it depends on what you prefer to do
First of all the field "user_group" in "user" table is only used if users can only be members of one group and not multiple. The datatype of the "user_group" field in the "user" group should always be the same as the one used as primary key in your "group" table. If you don't use database groups but have them in your config file, then the datatype must be choosen depending on the kind of index/group name you use in your config.

Does that help?