Файл: strongcms.sql
Строк: 21
-- phpMyAdmin SQL Dump
-- version 4.0.10.10
--
http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1:3306
-- Время
создания: Май 25 2016 г., 15:46
-- Версия сервера:
5.5.45
-- Версия PHP: 5.6.12
SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;
--
-- База данных: `strongcms`
--
--
--------------------------------------------------------
--
--
Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS
`users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT
NULL,
`password` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`sex` int(1) NOT NULL,
`time_reg` int(11) NOT NULL,
`tocken`
varchar(32) NOT NULL,
`time_online` int(11) NOT NULL,
`avatar`
varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`birthday`
varchar(10) NOT NULL,
`country` varchar(30) NOT NULL,
`city`
varchar(50) NOT NULL,
`admin` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;