mysql user system tables.

[bogdaniel]

hello after i played a while with php doing diferent things.. i would like to start building a members system from scratch can someone provide me an example of a mysql table for this kind of script.

[Mchl]

Can't see what would be difficult in here... anyway here's what I use in my current project.

 

CREATE TABLE  `users` (
  `ID` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Primary key',
  `name` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `login` varchar(255) NOT NULL,
  `password` char(32) NOT NULL,
  `active` tinyint(1) NOT NULL COMMENT 'Is the account active?',
  `registrationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

[bogdaniel]

Can't see what would be difficult in here... anyway here's what I use in my current project.

 

CREATE TABLE  `users` (
  `ID` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Primary key',
  `name` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `login` varchar(255) NOT NULL,
  `password` char(32) NOT NULL,
  `active` tinyint(1) NOT NULL COMMENT 'Is the account active?',
  `registrationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

 

hello it's not dificult i just wanted onther opinion to see how others did .. maybe someone did something more better.

[Mchl]

Well then. What you think about my table?

[bogdaniel]

Well then. What you think about my table?

it's nice i like it on my table i didn't had an active option and i've didn't add for the moment details about the user only username password registration date and i've made some changes about what i had changed vchar to char on password field.