Категории
[TOC]
Пользователи
| Column | Тип | Атрибуты | Флаги | Комментарии |
|---|---|---|---|---|
id | int(10) | NULL, Auto-Increment | ||
group_id | int(10) | NULL | ||
dopgroup | int(10) | NULL | ||
username | varchar(200) | NOT NULL | ||
password | varchar(40) | NOT NULL | ||
salt | varchar(12) | NULL | ||
email | varchar(80) | NOT NULL | ||
realname | varchar(40) | NULL | ||
timezone | float | NOT NULL | ||
registered | int(10) | NULL | ||
registration_ip | varchar(39) | NOT NULL | ||
last_visit | int(10) | NULL | ||
last_ip | varchar(20) | NOT NULL | ||
last_update_profile | int(10) | NULL | ||
active | int(11) | NOT NULL | ||
activate | int(11) | NULL | ||
city | varchar(1000) | NOT NULL | ||
region | varchar(1000) | NOT NULL | ||
country | int(10) | NULL | ||
adres | varchar(1000) | NOT NULL | ||
phone | varchar(255) | NOT NULL | ||
phone_confirm | varchar(255) | NOT NULL | ||
wm | float | NOT NULL | ||
desc | varchar(255) | NOT NULL | ||
karma | int(10) | NOT NULL | ||
alertmail | int(10) | NULL | ||
alertsms | int(10) | NULL | ||
data_serv | text | NOT NULL | ||
rate | int(11) | NOT NULL | ||
display_name | varchar(100) | NOT NULL | ||
webpush_token | text | NOT NULL |