From 270d696eaf3f45999b87b22bff1a014bed9a1bb0 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Sat, 29 Oct 2016 00:36:54 +0100 Subject: Don't screw with sequence settings just for tests --- gentoobrowse-api/db/schema.sql | 2 +- gentoobrowse-api/unittests/data.sql | 4 ++++ 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/gentoobrowse-api/db/schema.sql b/gentoobrowse-api/db/schema.sql index d5d7678..6d89a05 100644 --- a/gentoobrowse-api/db/schema.sql +++ b/gentoobrowse-api/db/schema.sql @@ -604,7 +604,7 @@ ALTER TABLE users OWNER TO gentoo; COMMENT ON TABLE users IS 'Registered users'; -- Name: users_userid_seq; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo CREATE SEQUENCE users_userid_seq - START WITH 3 + START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE diff --git a/gentoobrowse-api/unittests/data.sql b/gentoobrowse-api/unittests/data.sql index e7746a9..cb63bc4 100644 --- a/gentoobrowse-api/unittests/data.sql +++ b/gentoobrowse-api/unittests/data.sql @@ -30,3 +30,7 @@ COPY gentoobrowse.users (userid, username, userrealname, userpassword, useremail COPY gentoobrowse.user_ebuild_emails (userid, ebuildid, sentat) FROM '$SCRIPTDIR/fixtures/user_ebuild_emails.dat'; COPY gentoobrowse.user_packages (userid, packageid, trackedsince) FROM '$SCRIPTDIR/fixtures/user_packages.dat'; COPY gentoobrowse.changelog (changeid, repoid, commitid, committime, authorname, authoremail, summary, body, files) FROM '$SCRIPTDIR/fixtures/changelog.dat'; + +ALTER SEQUENCE users_userid_seq + RESTART WITH 3; + -- cgit v1.2.3