|
id
|
int(11)
|
|
|
|
|
asset_id
|
int(10) unsigned
|
|
|
0
|
|
parent_id
|
int(10) unsigned
|
|
|
0
|
|
lft
|
int(11)
|
|
|
0
|
|
rgt
|
int(11)
|
|
|
0
|
|
level
|
int(10) unsigned
|
|
|
0
|
|
path
|
varchar(400)
|
|
|
|
|
extension
|
varchar(50)
|
|
|
|
|
title
|
varchar(255)
|
|
|
|
|
alias
|
varchar(400)
|
|
|
|
|
note
|
varchar(255)
|
|
|
|
|
description
|
mediumtext
|
|
|
|
|
published
|
tinyint(1)
|
|
|
0
|
|
checked_out
|
int(11) unsigned
|
|
|
0
|
|
checked_out_time
|
datetime
|
|
|
0000-00-00 00:00:00.000000
|
|
access
|
int(10) unsigned
|
|
|
0
|
|
params
|
text
|
|
|
|
|
metadesc
|
varchar(1024)
|
|
|
|
|
metakey
|
varchar(1024)
|
|
|
|
|
metadata
|
varchar(2048)
|
|
|
|
|
created_user_id
|
int(10) unsigned
|
|
|
0
|
|
created_time
|
datetime
|
|
|
0000-00-00 00:00:00.000000
|
|
modified_user_id
|
int(10) unsigned
|
|
|
0
|
|
modified_time
|
datetime
|
|
|
0000-00-00 00:00:00.000000
|
|
hits
|
int(10) unsigned
|
|
|
0
|
|
language
|
char(7)
|
|
|
|
|
version
|
int(10) unsigned
|
|
|
1
|