Table commands and device_command schema ?

Good day:

I have installed tracker-linux-3.16 in Ubuntu 16.04 LTS and I have successfully change from H2 Database to MariaDb.

I search on the forums but cant find information about the schema of the tables on the mysql database.

What I want to do is to write a command on the DB instead of sending it with GUI or API.

I figure it out the following:

The current schema for tables are as follows:

CREATE TABLE `commands` (
  `id` int(11) NOT NULL,
  `description` varchar(4000) NOT NULL,
  `type` varchar(128) NOT NULL,
  `textchannel` bit(1) NOT NULL DEFAULT b'0',
  `attributes` varchar(4000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `device_command` (
  `deviceid` int(11) NOT NULL,
  `commandid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I think that if I want to send a command to a device I must write first on table commands and then write the id on device_command and specify what device_id I want to send.

I have tried to take a look on the table when I write the command on the GUI but I havent figure it out what does it write on the fields:

  `description` varchar(4000) NOT NULL,
  `type` varchar(128) NOT NULL,
  `textchannel` bit(1) NOT NULL DEFAULT b'0',
  `attributes` varchar(4000) NOT NULL

For example, If I want to send the following command: "ST600CMD;000IMEI000;02;Enable1" what should I write on each field?

Tks

Commands are not stored in the database. You need to use API.

Understood. To the API we go

Tks again