X-Git-Url: http://git.shiar.net/sheet.git/blobdiff_plain/5ba01432d80e839e2c6240717225017635cba28f..d66fb2e242cd73e7a3b5c3980d7491080fc5f8d1:/tools/word.pg.sql

diff --git a/tools/word.pg.sql b/tools/word.pg.sql
index 9f6bd41..7f97ada 100644
--- a/tools/word.pg.sql
+++ b/tools/word.pg.sql
@@ -4,7 +4,7 @@ CREATE TABLE login (
 	email      text,
 	fullname   text,
 	editlang   text[],
-	id         serial      NOT NULL PRIMARY KEY
+	id         integer     NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
 );
 
 CREATE TABLE word (
@@ -24,7 +24,7 @@ CREATE TABLE word (
 	creator    integer              REFERENCES login (id),
 	created    timestamptz          DEFAULT now(),
 	updated    timestamptz,
-	id         serial      NOT NULL PRIMARY KEY
+	id         integer     NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
 );
 
 COMMENT ON COLUMN word.form       IS 'preferred textual representation';
@@ -49,7 +49,7 @@ CREATE TABLE kind (
 	creator    integer              REFERENCES login (id),
 	created    timestamptz          DEFAULT now(),
 	updated    timestamptz,
-	id         serial      NOT NULL PRIMARY KEY
+	id         integer     NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
 );
 
 COMMENT ON COLUMN kind.truth      IS 'link validity ranging from 0 (never) to 100 (always)';