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 (
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';
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)';