Структура backup'а сайта ucoz

Описание полей от материалов разных модулей

Думаю кому-то пригодится данная информация, но сам лично в работе не использовал.

Спойлер: users

user
unetID
password
avatar
flags
fullname
gender
email
homepage
icq
country
state
city
signature
title
regdate
ip
o ld-field
aol
msn
yahoo
ispm
birthday
verify
options
lastmodified

Спойлер: ugen

id
user
groupID
ban
banrate
banreason
rank
reputation
reputetext text NOT NULL,
forum_posts
com_posts
blog_posts
news_posts
publ_posts
load_posts
dir_posts
board_posts
subscribe
forum
lastLogin
photo_po sts
forumPoll
pmGroups
awards

Спойлер: blog & news

id
catID
year
month
day
pending
ontop
com_may
addtime
num_com
author
title
brief
message
attach
files
reads
rating
rate_num
rate_sum
rate_ip
other1
other2
other3
other4
other5
uid
sbscr
lastmod

Спойлер: forum

id
forumID
poll
ontop
lpost
closed
posts
reads
name
descr
author
authreg
userpost
userreg
fontop
uid

Спойлер: forump

id
treadID
postTime
isFirst
message
userIsReg
user
signatureOn
editedBy
edittime
attach
attachsize
ip
subscribe
pollD etails
uid
lastmod

Спойлер: gb

id
name
email
url
icq
country
city
state
addtime
ip
message
answer
user
pending
uid
lastmod

Спойлер: photo

id
catID
sectionID
photoID
extension
isFullPhoto
addtime
num_com
name
descr
size
width
height
rating
rate_num
rate_s um
rate_ip
sort
user
com_may
reads
uid
subscription
filter1
filter2
marks
pending
lastmod

Спойлер: publ

id
sectionID
catID
sort
ontop
addtime
pending
com_may
num_com
rating
rate_num
rate_sum
rate_ip
title
brief
user
ana me
aemail
asite
source
message
reads
uid
subscription
files
lastmod

Спойлер: loads

id
sectionID
catID
sort
ontop
addtime
pending
com_may
num_com
rating
rate_num
rate_sum
rate_ip
reads
loads
title
br ief
licence
vers
os
lng
screen
llink
lsize
fname
fsize
user
aname
aemail
asite
doclink
proglink
message
filter1
filter2
u id
subscription
files
lastmod

Спойлер: dir

id
sectionID
catID
sort
ontop
addtime
pending
com_may
num_com
rating
rate_num
rate_sum
rate_ip
reads
loads
redirs
t itle
slink
brief
screen
scrsize
fname
fsize
user
aname
aemail
asite
other1
other2
other3
other4
other5
message
filter1
fil ter2
uid
subscription
files
lastmod

Спойлер: board

id
sectionID
catID
sort
ontop
addtime
pending
com_may
num_com
rating
rate_num
rate_sum
rate_ip
reads
loads
title
at ype
brief
screen
scrsize
fname
fsize
user
aname
aemail
asite
phone
other1
other2
other3
other4
other5
message
period
filte r1
filter2
uid
subscription
files
lastmod

Спойлер: faq

id
catID
sort
questionTime
answerTime
pending
rating
rate_num
rate_sum
rate_ip
subject
question
answer
user
name
ema il
uid
files
lastmod

Спойлер: site

id
isOwnTmpl
pending
whoCanRead
name
files
content
lastmod
pid

Спойлер: ocats

moduleID
catID
entryID

Спойлер: comments

commentID
moduleID (1=>'blog',2=>'news',3=>'publ',4=>'photo',5=>'load',6=>'dir',7=>'board')
materialID
pending
addTime
user
name
email
www
ip
me ssage
answer
userID
parentID
rate
rateUserIDs

Описание полей от категорий разных модулей

Спойлер: blog/news/faq/tests

id
position
num_data
name
description

Спойлер: publ/load/board/dir/photo

id
parentID
isGroup
position
num_data
name
descr
who_can_read
who_can_load
who_can_add
password (photo only)

Спойлер: tags

В файле указаны соответствия тегов для материалов/товаров в модулях.
Список тегов глобальный для сервера.

id - ID тега
sid - ID модуля
did - ID материала/товара

Источник: Структура бекапа (backup) - Сообщество uCoz