Page Menu
Home
Phorge
Search
Configure Global Search
Log In
Files
F120822685
2018021600.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Authored By
Unknown
Size
457 B
Referenced Files
None
Subscribers
None
2018021600.sql
View Options
CREATE
SEQUENCE
"filestore_seq"
INCREMENT
BY
1
NO
MAXVALUE
NO
MINVALUE
CACHE
1
;
CREATE
TABLE
"filestore"
(
file_id
integer
DEFAULT
nextval
(
'filestore_seq'
::
text
)
PRIMARY
KEY
,
user_id
integer
NOT
NULL
REFERENCES
users
(
user_id
)
ON
DELETE
CASCADE
ON
UPDATE
CASCADE
,
filename
varchar
(
128
)
NOT
NULL
,
mtime
integer
NOT
NULL
,
data
text
NOT
NULL
,
CONSTRAINT
filestore_user_id_filename
UNIQUE
(
user_id
,
filename
)
);
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Fri, Apr 24, 9:54 AM (1 w, 8 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
7f/19/76698b8fd42f9e7b6b9bee701ff3
Default Alt Text
2018021600.sql (457 B)
Attached To
Mode
R113 roundcubemail
Attached
Detach File
Event Timeline