diff options
| author | Jacob Bachmeyer <jcb62281+dev@gmail.com> | 2020-05-27 18:38:18 -0500 |
|---|---|---|
| committer | Jacob Bachmeyer <jcb62281+dev@gmail.com> | 2020-05-27 18:38:18 -0500 |
| commit | 2bf18f2662abd8ada5cd4b4710724bc3335698fe (patch) | |
| tree | 9c579649eae003cf953a90c59a30c4a35f17479c | |
| parent | 90c3680a0bc1b8a9f89e9deaf875eaee8d8605b6 (diff) | |
| download | dejagnu-2bf18f2662abd8ada5cd4b4710724bc3335698fe.zip dejagnu-2bf18f2662abd8ada5cd4b4710724bc3335698fe.tar.gz dejagnu-2bf18f2662abd8ada5cd4b4710724bc3335698fe.tar.bz2 | |
Whitespace cleanup in DB schema
| -rw-r--r-- | contrib/database/psql.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/database/psql.sql b/contrib/database/psql.sql index 071a2ba..b7b7938 100644 --- a/contrib/database/psql.sql +++ b/contrib/database/psql.sql @@ -61,7 +61,7 @@ CREATE TABLE dejagnu.manifest_packages ( OR ((branch IS NULL) AND (filespec IS NOT NULL))), CONSTRAINT "md5sum xor revision" CHECK(((md5sum IS NOT NULL) AND (revision IS NULL)) - OR ((md5sum IS NULL) AND (revision IS NOT NULL))), + OR ((md5sum IS NULL) AND (revision IS NOT NULL))), CONSTRAINT "valid hex md5sum" CHECK((md5sum IS NULL) OR (lower(md5sum) SIMILAR TO '[0-9a-f]{32}')), CONSTRAINT "host looks like an arch tuple" @@ -97,7 +97,7 @@ CREATE FUNCTION dejagnu.intern_set_by_name BEGIN SELECT set INTO set_id FROM dejagnu.sets WHERE name = set_name; IF NOT FOUND THEN - INSERT + INSERT INTO dejagnu.sets (name, tag) VALUES (set_name, dejagnu.set_tag_from_name(set_name)) RETURNING set INTO STRICT set_id; |