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