0 rows


built in and custom external services


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
external_services_functions.externalserviceid exteservfunc_ext2_fkR
external_services_users.externalserviceid exteservuser_ext2_fkR
external_tokens.externalserviceid extetoke_ext2_fkR
name VARCHAR 200
enabled BIT 1 null
requiredcapability VARCHAR 150 null
restrictedusers BIT 1 null
component VARCHAR 100 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
shortname VARCHAR 255 null

a unique shortname

downloadfiles BIT 1 0

1 if the service allow people to download file from webservice/plugins.php - 0 if not

uploadfiles BIT 1 0

1 if the service allow people to upload files to webservice/upload.php - 0 if not


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
exteserv_nam2_uix Must be unique Asc name