Hubzilla Documentation

Contents
    FieldDescriptionTypeNullKeyDefaultExtra
    idint(10) unsignedNOPRINULLauto_increment
    aidint(10) unsignedNOMUL0
    uidint(10) unsignedNOMULNULL
    xchanchar(255)NOMUL
    resource_idchar(255)NOMULNULL
    createddatetimeNONULL
    editeddatetimeNONULL
    titlechar(255)NONULL
    descriptiontextNONULL
    albumchar(255)NOMULNULL
    filenamechar(255)NONULL
    mimetypechar(128)NOMULimage/jpeg
    heightsmallint(6)NONULL
    widthsmallint(6)NONULL
    filesizeint(10) unsignedNOMUL0
    contentmediumblobNONULL
    scaletinyint(3)NOMULNULL
    profiletinyint(1)NOMUL0
    photo_flagsint(10) unsignedNOMUL0
    allow_cidmediumtextNONULL
    allow_gidmediumtextNONULL
    deny_cidmediumtextNONULL
    deny_gidmediumtextNONULL

    Return to database documentation