Migration: Difference between revisions
Jump to navigation
Jump to search
| Line 19: | Line 19: | ||
); | ); | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| | | | ||
|- | |- | ||
| Text with emoji | | Text with emoji | ||
| <syntaxhighlight lang="sql"> | | <syntaxhighlight lang="sql"> | ||
CREATE TABLE public.testemoji ( | |||
id serial NOT NULL, | |||
text1 varchar(5) NULL, | |||
text2 text NULL, | |||
CONSTRAINT testemoji_pk PRIMARY KEY (id) | |||
); | |||
</syntaxhighlight> | </syntaxhighlight> | ||
| | | | ||
Revision as of 03:53, 1 September 2025
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 |