...
You can also edit or delete the licenses.
Database Schema
The database schema
...
can
...
be found in the application
...
is the user has database::read permission by going to menu: Admin -> Database -> List Tables, then clicking on the
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
CREATE TABLE `licenses` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL DEFAULT '',
`org_id` int(10) unsigned NOT NULL DEFAULT '1',
`org_descendants` enum('y','n') NOT NULL DEFAULT 'y',
`purchase_count` int(10) unsigned NOT NULL DEFAULT '0',
`used_count` int(10) unsigned NOT NULL DEFAULT '0',
`description` text NOT NULL,
`match_string` text NOT NULL,
`edited_by` varchar(200) NOT NULL DEFAULT '',
`edited_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; |
A typical entry looks as below.
| Code Block | ||||
|---|---|---|---|---|
| ||||
id: 3
name: Microsoft Office 2013 Professional Plus
org_id: 2
org_descendants: y
purchase_count: 45
used_count: 0
description: Microsoft Office 2013 Professional Plus for Mgmt Staff
match_string: %Microsoft Office 2013%
edited_by: Administrator
edited_date: 2017-05-31 09:57:30 |
details button for the table.
API / Web Access
You can access the
...
collection using the normal Open-AudIT JSON based API. Just like any other collection. Please
...
see The Open-AudIT API documentation for further details.
Access is provided as part of a roles permissions. Licenses is a standard resource and can have create, read, update and delete permissions.
The API routes below are usable from both a JSON Restful API and the web interface. The Web application routes are specifically designed to be called from the web interface (a browser).
API Routes
...
...
...
...
...
...
...
...
...
Web Application Routes
Request Method | ID | Action | Resulting Function | Permission Required | URL Example | Notes |
|---|---|---|---|---|---|---|
| GET | n | create | create_form | licenses::create | /licenses/create | Displays a standard web form for submission to POST /licenses. |
| GET | y | update | update_form | licenses::update | /licenses/{id}/update | Show the license details with the option to update attributes using PATCH to /licenses/{id} |