Migration: Difference between revisions
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
id1 serial NOT NULL, | id1 serial NOT NULL, | ||
id2 int GENERATED ALWAYS AS IDENTITY NOT NULL, | id2 int GENERATED ALWAYS AS IDENTITY NOT NULL, | ||
id3 int GENERATED BY DEFAULT AS IDENTITY NOT NULL | id3 int GENERATED BY DEFAULT AS IDENTITY NOT NULL, | ||
CONSTRAINT testincremental_pk PRIMARY KEY (id1) | |||
); | ); | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 03:50, 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)
);
|
auto incremental
|
| Text with emoji | ||
| DateTime |