mirror of https://github.com/kacos2000/Queries
You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
15 lines
389 B
SQL
15 lines
389 B
SQL
select
|
|
Assets.id as 'id',
|
|
Assets.key as 'key',
|
|
Assets.sub_key as 'sub_key',
|
|
assets.lock_count as 'lock_count',
|
|
datetime(assets.access_time /10000000, 'unixepoch', 'localtime') as 'AccessTime',
|
|
assets.actual_size as 'actual_size',
|
|
assets.reserved_size as 'reserved_size',
|
|
assets.type as 'type',
|
|
assets.owner as 'owner',
|
|
hex(assets.serialized_data) as 'serial'
|
|
from Assets
|
|
|
|
|