Login   Register  
PHP Classes
elePHPant
Icontem

File: users_mysql.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of norayrx  >  user_registration_module  >  users_mysql.sql  >  Download  
File: users_mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: users_mysql
Class: user_registration_module
Register users with records in a MySQL database
Author: By
Last change:
Date: 5 years ago
Size: 1,258 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Хост: localhost
-- Время создания: Янв 16 2009 г., 13:27
-- Версия сервера: 4.1.8
-- Версия PHP: 5.2.6
-- 
-- БД: `MY_CMS`
-- 

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

-- 
-- Структура таблицы `users`
-- 

CREATE TABLE `users` (
  `userID` int(11) NOT NULL auto_increment,
  `username` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(35) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `phone` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `first_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `last_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `gender` char(1) collate utf8_unicode_ci NOT NULL default '',
  `age` varchar(4) collate utf8_unicode_ci NOT NULL default '',
  `country` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `city` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `zipcode` int(10) NOT NULL default '0',
  `street_address` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;