Redmatrix Documentation



FieldDescriptionTypeNullKeyDefaultExtra
idgenerated indexint(10) unsignedNOPRINULLauto_increment
aidaccount_id of ownerint(10) unsignedNOMUL0
uidchannel_id of ownerint(10) unsignedNOMUL0
hashhash for cross-site identificationchar(64)NOMUL
creatorxchan_hash of author/creatorchar(128)NOMUL
filenamefilename of originalchar(255)NOMUL
filetypemimetypechar(64)NOMUL
filesizesize in bytesint(10) unsignedNOMUL0
revisionfor version control (partially implemented)int(10) unsignedNOMUL0
folderattach.hash of parent folderchar(64)NOMUL
flagssee notesint(10) unsignedNOMUL0
datafile data or pathname to stored data if ATTACH_FLAG_OSlongblobNONULL
createdcreation timedatetimeNOMUL0000-00-00 00:00:00
editedlast edit timedatetimeNOMUL0000-00-00 00:00:00
allow_cidpermissionsmediumtextNONULL
allow_gidpermissionsmediumtextNONULL
deny_cidpermissionsmediumtextNONULL
deny_gidpermissionsmediumtextNONULL



Bitmasks

define ( 'ATTACH_FLAG_DIR',    0x0001);  This is a directory
define ( 'ATTACH_FLAG_OS',     0x0002);  Data content is link to OS file containing data, if unset the data filed contains the file data

permissions are xchan_hash or group_hash surrounded by angle chars. e.g. '<abc123><xyz789>'

Return to database documentation