Migration
Jump to navigation
Jump to search
Table
Column
Data Types
| Postgres | MariaDB | |
|---|---|---|
| Incremental | CREATE TABLE public.testIncremental (
id1 serial NOT NULL,
id2 int GENERATED ALWAYS AS IDENTITY NOT NULL,
id3 int GENERATED BY DEFAULT AS IDENTITY NOT NULL,
CONSTRAINT testincremental_pk PRIMARY KEY (id1)
);
|
|
| Text with emoji | CREATE TABLE public.testemoji (
id serial NOT NULL,
text1 varchar(5) NULL,
text2 text NULL,
CONSTRAINT testemoji_pk PRIMARY KEY (id)
);
|
|
| DateTime |