What datatype to use in table when inserting int_16 [ ] array - Source

You are viewing an old version of this question. View the current version here

Revision: 89938
User: Anders Sundberg
Date: 2019-10-21 12:33

How should I best construct/define the table and its column that are to hold a struct of data in transport between frontend webpage and backend low level system.

My idea is to create a web interface to replace FIFO rpc usage with MariaDB as a go-between apart from data storage, adding logging functionality
The web shall post REQUEST into table ie send a command with corresponding information or 
send changed data (like the name or value) to be updated.
Request is sent to manipulate backend connected engine, 
Posted data is inserted/updated by backend after handling (like security test), into corresponding tables and pushed to frontend

I need to handle all swedish and danish letters

CREATE TABLE `guirequest` (
  `request_id` BINARY(16) DEFAULT NULL,
  `functioncode` int(11) DEFAULT 0,
  `indexcode` int(11) DEFAULT 0,
  `idata` int(11) DEFAULT -1,
  `argv` text(4096) DEFAULT NULL,
  `size_argv` int DEFAULT -1,
  `logdate` datetime DEFAULT NULL,
  `signature` text(20) DEFAULT NULL,
  `read_request` datetime DEFAULT NULL,
  `done_request` int DEFAULT -1,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

struct data{ 
 int functioncode;    // command 
 int src;                   // from
 int destination;      // to whom
 int size_of_request; // size including headers
 int argc;       // no of arguments
 int argv[1];   // list of arguments
 short messagetype;   // severity of message
}REQUEST;

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

What datatype to use in table when inserting int_16 [ ] array - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB