Login   Register  
PHP Classes
elePHPant
Icontem

File: users_table.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Olaf Lederer  >  Access user Class  >  users_table.sql  >  Download  
File: users_table.sql
Role: Auxiliary data
Content type: text/plain
Description: sql statement for the user table
Class: Access user Class
Site user registration and page access restriction
Author: By
Last change: added an example record for the admin
Date: 2005-09-18 01:45
Size: 738 bytes
 

Contents

Class file image Download 
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(25) NOT NULL default '',
  `pw` varchar(32) NOT NULL default '',
  `real_name` varchar(32) NOT NULL default '',
  `extra_info` varchar(100) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `tmp_mail` varchar(50) NOT NULL default '',
  `access_level` tinyint(4) NOT NULL default '0',
  `active` enum('y','n') NOT NULL default 'n',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user` (`login`),
  UNIQUE KEY `mail` (`email`)
) TYPE=MyISAM;

#
# admin example record for table `users`
#

INSERT INTO `users` VALUES (NULL, 'administrator', '40be4e59b9a2a2b5dffb918c0e86b3d7', 'The site administrator', '', 'my@mail.com', '', 10, 'y');