XF 2.2 JSON Column Support

[Andy R]

Are we able to create json columns in addons via the setup.php file?

 

[Kirby]

Explain waht you mean with "JSON column"?

XenForo doesn't use native MySQL native JSON column datatype (which AFAIK isn't supported by MariaDB), but you can use a BLOB type fied and define its type as JSON in the entity, the entity manager will present this as an array in PHP and store JSON in the table.

 

[Andy R]

I mean, can we do this using the native Db schema classes:

CREATE TABLE products (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255),
details JSON
);

Or must it be a raw query?