PHP Classes

File: users_profile_table.sql

Recommend this page to a friend!
  Classes of Olaf Lederer   Access user Class   users_profile_table.sql   Download  
File: users_profile_table.sql
Role: Auxiliary data
Content type: text/plain
Description: The database table will hold the users profile data
Class: Access user Class
Site user registration and page access restriction
Author: By
Last change:
Date: 19 years ago
Size: 824 bytes
 

Contents

Class file image Download
CREATE TABLE `users_profile` ( `id` int(11) NOT NULL auto_increment, `users_id` int(11) NOT NULL default '0', `language` char(2) NOT NULL default '', `address` varchar(50) NOT NULL default '', `postcode` varchar(15) NOT NULL default '', `city` varchar(50) NOT NULL default '', `country` char(2) NOT NULL default '', `phone` varchar(50) NOT NULL default '', `fax` varchar(50) NOT NULL default '', `homepage` varchar(100) NOT NULL default '', `notes` text NOT NULL, `user_1` varchar(100) NOT NULL default '', `user_2` varchar(100) NOT NULL default '', `user_3` varchar(100) NOT NULL default '', `user_4` varchar(100) NOT NULL default '', `last_change` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `users_id` (`users_id`) ) TYPE=MyISAM;