How would this SQL syntax for PSTGRESQL look like in MARIADB?

Question

PostgreSQL

I am new to databases, writing a program that runs on MariaDB.

There is SQL written for postgree, but I can't figure out how it should look like in maria

CREATE TABLE images (
       image_id SERIAL PRIMARY KEY,
       filename TEXT NOT NULL UNIQUE
);

CREATE TABLE tags (
       tag_id SERIAL PRIMARY KEY,
       tag    TEXT NOT NULL UNIQUE
);

CREATE TABLE images_tags (
       PRIMARY KEY (tag_id, image_id),
       image_id INTEGER NOT NULL REFERENCES images (image_id),
       tag_id   INTEGER NOT NULL REFERENCES tags (tag_id)
);

Answer 1

This solution works in MariaDB:

CREATE TABLE images (
  image_id INTEGER AUTO_INCREMENT PRIMARY KEY, 
  filename VARCHAR(255) NOT NULL UNIQUE
);

CREATE TABLE tags (
  tag_id INTEGER AUTO_INCREMENT PRIMARY KEY, 
  tag VARCHAR(255) NOT NULL UNIQUE
);

CREATE TABLE images_tags (
  image_id INTEGER NOT NULL, 
  tag_id INTEGER NOT NULL, 
  PRIMARY KEY (tag_id, image_id), 
  FOREIGN KEY (tag_id) REFERENCES tags(tag_id),
  FOREIGN KEY (image_id) REFERENCES images(image_id)
);

Here you can test SQL queries

Answer 2

SERIAL => INT AUTO_INCREMENT
text cannot be unique in mysql/mariadb. You have to choose a prefix by which to count the uniqueness. For example, make varchar(maximum allowed number of characters) instead of text.