File: users_mysql.sql

-- 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;