git.shiar.nl
/
sheet.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
keyboard: move layout data to include
[sheet.git]
/
tools
/
word.pg.sql
diff --git
a/tools/word.pg.sql
b/tools/word.pg.sql
index 9f6bd41769a1b715b8f81f45f1dffb7254b15248..7f97ada4c58ebd947ed27083d5c49863128f20d4 100644
(file)
--- a/
tools/word.pg.sql
+++ b/
tools/word.pg.sql
@@
-4,7
+4,7
@@
CREATE TABLE login (
email text,
fullname text,
editlang text[],
email text,
fullname text,
editlang text[],
- id
serial NOT NULL PRIMARY KE
Y
+ id
integer NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTIT
Y
);
CREATE TABLE word (
);
CREATE TABLE word (
@@
-24,7
+24,7
@@
CREATE TABLE word (
creator integer REFERENCES login (id),
created timestamptz DEFAULT now(),
updated timestamptz,
creator integer REFERENCES login (id),
created timestamptz DEFAULT now(),
updated timestamptz,
- id
serial NOT NULL PRIMARY KE
Y
+ id
integer NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTIT
Y
);
COMMENT ON COLUMN word.form IS 'preferred textual representation';
);
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,
creator integer REFERENCES login (id),
created timestamptz DEFAULT now(),
updated timestamptz,
- id
serial NOT NULL PRIMARY KE
Y
+ id
integer NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTIT
Y
);
COMMENT ON COLUMN kind.truth IS 'link validity ranging from 0 (never) to 100 (always)';
);
COMMENT ON COLUMN kind.truth IS 'link validity ranging from 0 (never) to 100 (always)';